WorldGuard region delete/create confliction with MySQL
LadyCailinBot opened this issue · 4 comments
WORLDGUARD-4095 - Reported by andrewkm
Paper 1.13.2 - 627
Worldedit - 4309
WorldGuard - 1883
When deleting a region, and immediately recreating it with the same name (with say 2-3 seconds in between) the following error is shot and saving fails:
https://pastebin.com/raw/sJAb8VaE
(Looks like region by that name already exists)
If waiting about 8-10 seconds before recreating a region with the same name, goes through successfully.
Can we please get an immediate flush if possible on region deletion/creation, or some information on how to change it ourselves? Or of course any other kind of fix regarding this.
Comment by wizjany
you can use /rg save to immediately trigger a save.
unfortunately the sql stuff in WG is a mess of contributed spaghetti and I care very little about fixing (edge case) issues like this due to the amount of effort it would take.
Comment by andrewkm
I was always under the impression that MySQL provides better performance. If that’s not the case I’ll just migrate to YAML assuming WGs migration process isn’t problematic.
Comment by wizjany
/rg migratedb
there's no performance concerns except the extra 1ms at startup because mysql has to make a network connection which is slower than reading a file.
while the server is running, saving changes is async, and no reading is done.