Schema version set wrong PostgreSQL
MarijnDoeve opened this issue ยท 2 comments
Issue Description: When using PostgreSQL as map storage the schema version gets misaligned which breaks markers
-
Dynmap Version: version 3.4-beta-3 (core version 3.4-beta-3-774)
-
Server Version: fabric 1.18.2 (0.51.1+1.18.2) PostgreSQL 14.2
-
Pastebin of Configuration.txt: click
-
Server Host (if applicable): Selfhosted via Docker Compose
-
Pastebin of crashlogs or other relevant logs: click (part of the same Gist as above)
-
Steps to Replicate:
I had problems with markers sometime after migrating to PostgreSQL, so I started investigating by replacing my config.txt with a new one with a new database. This worked fine, I saw in the logs that it had problems with migrating so I paid particular attention to the schema version on the fresh start of Dynmap. It started with version 4. Everything was working again.
After a server restart, I saw the same issues with markers again. And in the logs, I saw [Dynmap] Updating database schema from version = 3
again. But I was sure it already was on version 4.
Logging in into the database I saw the schemaversion
was indeed set 3, I changed it manually to 4 and everything worked again!
- I have looked at all other issues and this is not a duplicate
- I have been able to replicate this
Apparently, the initial version was just set wrong in code, not as complicated as I initially thought.