Forums updates and announcements

random stuff
Locked
User avatar
AkaiHebi
admin
admin
Posts: 309
Joined: 2015 Apr 22, 20:23

Forums updates and announcements

Post by AkaiHebi » 2016 May 27, 12:57

Hello everyone,

Just a quick note to announce that the forums database was corrupt, making users unable to log in.
The issue is now fixed, thanks to ShinigamiRikko for reporting the issue !

(as a reference, only the session table was affected, a missing row causing index inconsistency. The fix using SQLite3 CLI, just a simple dump-rebuild:)

Code: Select all

echo '.dump'|sqlite3 $DB_NAME|sqlite3 repaired_$DB_NAME

User avatar
AkaiHebi
admin
admin
Posts: 309
Joined: 2015 Apr 22, 20:23

Re: Forums updates and announcements

Post by AkaiHebi » 2018 Feb 03, 17:20

Hello everyone,
I just updated the forum server on PHP version 7 8-)
I got recently notified about a login issue, due to a corrupt session table of the database. So now sessions are flushed and things should run smoothly 8-)

User avatar
AkaiHebi
admin
admin
Posts: 309
Joined: 2015 Apr 22, 20:23

Re: Forums updates and announcements

Post by AkaiHebi » 2018 May 04, 23:24

Same's same, database fixed ;)

User avatar
AkaiHebi
admin
admin
Posts: 309
Joined: 2015 Apr 22, 20:23

Re: Forums updates and announcements

Post by AkaiHebi » 2018 Dec 16, 19:21

Turns out using SQLite on our webhost is no longer a good option: they rely heavily on NFS and often the web servers hit a write operation simultaneously on different filers. In short: their filesystem merges changes concurrently, and the database becomes corrupt.
More and more badly so.

So, now the forums turn on MariaDB :)

Locked