|
|
InstallingNodeHanging.PNG (66,241 bytes) |
|
|
Can you attach the symmetric.log file from /opt/symmetricds/logs? |
|
|
OK. I have deleted the system and currently trying to run it in Ubuntu 19.10. As soon as I have the system running I will send the requested logs |
|
|
Hi. Here are all the logs for SymmetricDS. At this point the "Installing Node" step was running 30 minutes and did not finish. This behaviour was also noticed in 3.10.5 version but not in 3.10.4 version |
|
|
In the db.url, it has the parameter of zeroDateTimeBehavior=convertToNull. On MySQL server, it has a sql-mode with NO_ZERO_DATE and/or NO_ZERO_IN_DATE. Together, these settings are not compatible. Maybe SymmetricDS should defer to MySQL server and ignore the user's parameter to convert zero dates to null, since the server already forbids zero dates. You should decide what you want to happen for dates with zeros, like 0000-00-00, since these dates are not compatible with databases other than MySQL. Some people want to sync 0000-00-00 between two MySQL databases. Some people want to convert them to null when syncing to non-MySQL database. Some people don't want them at all and tell MySQL to prevent their use. Since you have your MySQL server setup to forbid zero date, you should edit the /opt/symmetric-ds/engines/server.properties and remove zeroDateTimeBehavior=convertToNull from db.url. |
- Anonymous