maria-discuss team mailing list archive
Mailing list archive
Problem in replication with NOW('2012-03-07 17:32:03')
I set up 2 hosts as a galera cluster, one of them is a slave of my main
The galera hosts are 5.5.28a-MariaDB-a1~precise-log, all other databases
The 5.5 slave stops with 1064 errors. I figured this is because of
updates using NOW() on timestamp columns, I think they come from a
In the error log the queries look like this:
UPDATE ..., some_timestamp_field = NOW('2012-03-07 17:32:03') WHERE
when I manually execute the query and just remove the NOW so it is a
simple update some_timestamp_field = '2012-03-07 17:32:03' and then
execute set global sql_slave_skip_counter=1;slave start; everything is
All 5.2 hosts replicate just fine.
is this a bug in 5.5?