← Back to team overview

maria-discuss team mailing list archive

Problem in replication with NOW('2012-03-07 17:32:03')

 

Hi,

I set up 2 hosts as a galera cluster, one of them is a slave of my main database.

The galera hosts are 5.5.28a-MariaDB-a1~precise-log, all other databases are
 5.2.12-MariaDB-mariadb115~squeeze-log.

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 phpmyadmin frontend.
In the error log the queries look like this:

UPDATE ..., some_timestamp_field = NOW('2012-03-07 17:32:03') WHERE ...primary keys...

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 fine again.

All 5.2 hosts replicate just fine.

is this a bug in 5.5?

Thanks
Jan



Follow ups