Dynmap-Forge/Fabric

Dynmap-Forge/Fabric

888k Downloads

Dynmap 3.3 Beta5 fails to update the Database Schema

Aaron2550 opened this issue ยท 4 comments

commented

Issue Description: Dynmap tries to update the Database Schema and fails while doing so.

  • Dynmap Version: v3.3-beta-5-657
  • Server Version: git-Paper-175 (MC: 1.18.1)
  • Server Host (if applicable): Selfhosted
  • Pastebin of crashlogs or other relevant logs: https://pastebin.com/rqZ5bZM4
  • Other Relevant Data/Screenshots: Using MariaDB 10.6.5 with default settings
  • Steps to Replicate:
  • Update from Beta 4 to Beta 5,
  • start server,
  • wait
  • see error

[x] I have looked at all other issues and this is not a duplicate
[x] I have been able to replicate this

commented

If manually updating the Database is feasible: I dont really feel comfortable copy pasting sql statements from the source code and running them directly. Would be appreciated if you guys could maybe tell me which ones i need to run....

commented

I ended up rolling back to the Beta 4 version, I updated last night and has the same issue except it just got hung up on the upgrade.

commented

Thats what i did too.
LostBot over on the Discord suggested trying with innodb_buffer_pool_size=1G under [mysqld] in /etc/my.cnf or /etc/my.cnf.d/server.cnf

I havent tried that yet because im still waiting for everyone to go offline for the night

commented

OK - I've come up with another (somewhat more complicated) procedure to provide the MEDIUMBLOB column needed for bigger tiles (particularly due to boosting) that is a more lazy process (it adds a new column vs modifying the existing one, and changes the queries to handle new insert/updates into the new column, and pulling from both columns on read). In any case, give the latest SNAPSHOT a try (build 661+).