Sessions table is full creating an error

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
koups
Registered User
Posts: 40
Joined: Thu Jan 16, 2003 12:05 pm

Sessions table is full creating an error

Post by koups » Fri Nov 14, 2008 7:56 am

Hi, for some reason the sessions table keeps getting full and creating the following error. I empty the table, it fixes it then it comes back in a day or so. Any ideas what I should be doing now? Thanks!

DEBUG MODE

SQL Error : 1114 The table 'phpbb_sessions' is full

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('88fba431f3a7162ecaccf9ca4daeb185', -1, 1226649178, 1226649178, '59bb4826', 0, 0, 0)

Line : 187
File : sessions.php

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Sessions table is full creating an error

Post by karlsemple » Fri Nov 14, 2008 8:01 am

Please provide us with the information necessary to assist you by filling out the Support Request Template.
Image

koups
Registered User
Posts: 40
Joined: Thu Jan 16, 2003 12:05 pm

Re: Sessions table is full creating an error

Post by koups » Fri Nov 14, 2008 8:12 am

The following is the basic SRT
Your board's URL: http://www.anesthesiausa.com/forum/
Version of phpBB3: phpBB 2.0.22
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? No it has been running for about 5 years
Did you use an automated wizard provided by your host to install phpBB? Hmm- can't remember it was so long ago
MODs you have installed: moderator email when post, inactive users
When the problem started: only in the past month
Your level of expertise (be honest): intermediate beginner

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: Sessions table is full creating an error

Post by espicom » Sun Nov 16, 2008 1:33 am

Script to repair/clear/alter sessions table

A "full" table means you're using an in-memory "Heap" table for sessions. That is a practice that hasn't been right for about 5 years, but wasn't under your control when it (the board) was created. You can fix it now, though.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

koups
Registered User
Posts: 40
Joined: Thu Jan 16, 2003 12:05 pm

Re: Sessions table is full creating an error

Post by koups » Sun Nov 16, 2008 8:37 am

Thank you- I will run the scripts and see if that fixes the problem. Thanks again.

Locked

Return to “2.0.x Support Forum”