FUDforum
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 :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Database problem in fud30_ses sessions table [message #183073] Mon, 07 October 2013 03:26 Go to next message
randomserver is currently offline  randomserver   
Messages: 3
Registered: January 2011
Karma: 0
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.

RANDOMSERVER
http://www.randomserver.dyndns.org
Re: Database problem in fud30_ses sessions table [message #183074 is a reply to message #183073] Mon, 07 October 2013 04:56 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
This issue is addressed on the wiki at performance tuning (see section about "database performance").

We've also made some changes to the session handling code in 3.0.5, so it might be worth your while to upgrade. FUDforum 3.0.5 also contains a Session Manager ACP to help you monitor sessions.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Mon Oct 23 18:49:51 EDT 2017

Total time taken to generate the page: 0.00632 seconds