search

spring / upq

extracts metadata of game and map files of the spring engine
https://springfiles.springrts.com/
GNU General Public License v3.0
2 stars 5 forks source link

since 14.06.2022 3:12, filesystem does missmatch db #86

Closed abma closed 2 years ago

abma commented 2 years ago

Traceback (most recent call last): File "/home/springfiles/upq/verify.py", line 47, in raise Exception("db vs filesystem missmatch: %s" %str(diff)) Exception: db vs filesystem missmatch: {'/home/springfiles/upq/files/maps/otago_redux_1.0.sd7'}

abma commented 2 years ago

very likely related to #85

springraaar commented 2 years ago

in what situation was that executed? when? Is that really a serious error? seems like it should be a warning.

That's probably due to this error report where i reverted the change a few hours later and subsequently fixed https://springrts.com/phpbb/viewtopic.php?p=603412#p603412

At the moment that file exists in the file system and also has a record on the springfiles DB.

People have been able to upload maps normally throughout the next few days. I tested uploading some myself too.

abma commented 2 years ago

its run every hour by cron. and yes, this is a serious error as the list of files doesn't match the list of files in the database.

for the reference: https://github.com/spring/upq/blob/master/verify.py#L47

also atm the error is:

Exception: db vs filesystem missmatch: {'/home/springfiles/upq/files/maps/otago_dx_1.0.sd7', '/home/springfiles/upq/files/maps/alexandra_1.0.sd7', '/home/springfiles/upq/files/games/micronwars2-_v0.23.sdz'}

springraaar commented 2 years ago

I had deleted the record for micronwars2-_v0.23 by mistake, but restored it now using a dump from 12 june (before i started making changes to the db).

springraaar commented 2 years ago

-r--r--r-- 1 springfiles springfiles 81517801 Jun 14 02:53 /home/springfiles/upq/files/maps/otago_redux_1.0.sd7 -r--r--r-- 1 springfiles springfiles 78932279 Jun 14 23:39 /home/springfiles/upq/files/maps/otago_dx_1.0.sd7 -r--r--r-- 1 springfiles springfiles 78932277 Jun 15 00:09 /home/springfiles/upq/files/maps/alexandra_1.0.sd7 -r--r--r-- 1 springfiles springfiles 78932530 Jun 15 02:02 /home/springfiles/upq/files/maps/otago_redux_1.1.sd7 -r--r--r-- 1 springfiles springfiles 78932533 Jun 15 03:11 /home/springfiles/upq/files/maps/otago_redux_1.2.sd7 -r--r--r-- 1 springfiles springfiles 78537576 Jun 18 04:33 /home/springfiles/upq/files/maps/otago_redux_1.21.sd7 springfiles@spring1:~/raaar_2022_06_05$ ls -la /home/springfiles/upq/files/maps/alexandra_1.0.sd7 -r--r--r-- 1 springfiles springfiles 78932277 Jun 15 00:09 /home/springfiles/upq/files/maps/alexandra_1.0.sd7

alexandra_1.0.sd7 and otago_dx are earlier iterations of the otago_redux map that Moose uploaded in the following days, I moved them out to /home/springfiles/to_delete and am pretty sure they're safe to remove.

abma commented 2 years ago

thanks for solving!