Starting this morning, when we try to create and save a new item, the new item’s metadata and files merge with an older item instead of saving as a new item.
Yesterday our web host updated the database on our server from MySQL 5.6 to MariaDB 10.3.14. We are using Omeka version 2.6.
Are there any known conflicts between Omeka 2.6 and MariaDB 10.3.14?
Hmmm… I haven’t heard any reports of that happening before. Maybe there could have been some issue with the database update and it’s not generating the correct ID for new records? You could look at the output of SHOW CREATE TABLE omeka_items to see what ID the database is going to assign next: this should be a value that’s greater than any existing item IDs.
which should set the ID value for auto increment higher than the most recent item. Would be curious if that fixes it, though it still wouldn’t answer why it was necessary.
Yeah, I’m not sure what’s going on there… it would indicate some kind of problem on the MariaDB end of things, or possibly in the conversion process… this is a pretty basic thing that it’s strange to see not being accounted for correctly.
Well I’m glad to hear it’s working and I’m going to light a few candles and say a prayer that it’s not a sign of larger issues to come. This upgrade was particular impactful as we moved incrementally from 5.6 to 5.7 to 10.1 to 10.2 to 10.3 in one night to get things running smoothly on that server at the latest version. But it is the first to run 10.3 (we have several on 10.2 and hadn’t heard of any issues). Very odd bug indeed.
My remaining concern would be that the other autoincrement values for the other tables could be wrong in the same way.
Somewhere along the line MySQL/MariaDB changed the way the autoincrement is handled for InnoDB tables: it used to be re-calculated at server startup and it switched to being stored on disk, so I’d imagine that’s related to the issue.
That error is definitely an issue of the Geolocation plugin communicating with Google so likely unrelated to the database issue you were experiencing previously.