Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Database problem in fud30_ses sessions table
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
Database problem in fud30_ses sessions table [message #183073] Mon, 07 October 2013 03:26 Go to previous message
randomserver is currently offline  randomserver   
Messages: 3
Registered: January 2011
Junior Member
add to buddy list
ignore all messages by this user
I have found a systematic error in the sessions table. The "ses" sessions table
occasionally report that the table has crashed. Due to this nothing can be displayed;
the entire forum is just blank.

Finding a source bug could be difficult, and if this is a hard-drive problem
nothing can be found. I suspect that a hacker-script enter some special
angry URL, and the session number is transferred to the database and some error
occurs. I have the logs, but I don't know what to look for.

The solution that I use now is that I "drop table" and then create a new empty
one using an SQL obtained from a forum that still works.

My thought is that:
To test-read the table, and monitor the error codes.
If the table is plain inaccessible, drop and then write
a new table by an external script.

There might also be problems with other tables that are updated frequently,
but I have not detected any problem elsewhere.

[Message index]
Read Message
Read Message
Previous Topic: Use Aliases on groupmgr problem
Next Topic: Images take too much space
Goto Forum:

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 29 10:18:30 EDT 2022

Total time taken to generate the page: 0.00729 seconds