Upgrade to 4.2.0 fails with SQL error

Support & Bugs
1

Hi there,

I’ve tried to upgrade the databse from version 3.13.5-rc1 to the new version 4.2.0.

I’m getting the following error:

Error trying to execute the migration ‘UPDATE matomo_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400,
visitor_seconds_since_order = visitor_days_since_order * 86400,
visitor_seconds_since_last = visitor_days_since_last * 86400;’.
The error was: SQLSTATE[HY000]: General error: 3100 Error on observer while running replication hook ‘before_commit’.

I’ve tried re-running the db upgrade, but I keep getting this error.

2

Hi,

Disclaimer: I know nearly nothing about MySQL replication and mutiple-server Database setups.

But the error Error on observer while running replication hook sounds a lot as if your MySQL server would try to replicate the changes on a secondary database server and fails there.

So I’d recommend to check the server log of the secondary database server or ask whoever setup the database environment and is therefore probably more familiar with replication than me.

3

Thanks for the tip, I’ll ask the person responsible for this.