View Revisions: Issue #4161

Summary 0004161: MySQL ignore zeroDateTimeBehavior=convertToNull if server is set to NO_ZERO_DATE
Revision 2019-11-24 17:13 by elong
Description The settings of db.url with zeroDateTimeBehavior=convertToNull and server set to sql_mode of NO_ZERO_DATE are not compatible. SymmetricDS will try to compare dates with 0000-00-00 to convert them, but MySQL will return a syntax error, which causes queries and triggers to break.

In a fresh installation of Ubuntu 18.04.3 Desktop and Fedora31 Workstation in VirtualBox and with addition of MySQL on both VM's provisioning of Master Node is stuck at at Installing Node banner and it just keeps on hanging, Even after refresh. I can see in MySQL DB that SymmetricDS tables get installed but the installation does not finish, even after couple of hours.
Revision 2019-11-23 18:56 by zeljko.katic@procosafe.no
Description In a fresh installation of Ubuntu 18.04.3 Desktop and Fedora31 Workstation in VirtualBox and with addition of MySQL on both VM's provisioning of Master Node is stuck at at Installing Node banner and it just keeps on hanging, Even after refresh. I can see in MySQL DB that SymmetricDS tables get installed but the installation does not finish, even after couple of hours.