search

rosedu / vmchecker

Automatic assignment checker
http://vmchecker.cs.pub.ro/
MIT License
36 stars 34 forks source link

Refresh bug #91

Open ralucasg opened 7 years ago

ralucasg commented 7 years ago

screenshot_10 Steps: upload archive, go to all grades, refresh

razvancrainea commented 7 years ago

Additional information: this bug happened when the server was under high load and a write operation to the database (that was taking too long) was interrupted. This left the database locked for any operations, reads or writes, and the server could no longer be used.

A quick solution was to replace the database with a new one:

mv vmchecker.db vmchecker-locked.db
echo ".dump" | sqlite3 vmchecker-locked.db | sqlite3 vmchecker.db

After this the service recovered.