phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Table crash

Goto page 1, 2  Next
 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Fri Jun 12, 2015 1:13 pm 
Post subject: Table crash

For the very first time I have just experienced my database crash. This was a single table in the database (sessions table)
What would be the most likely cause of a table such as "sessions" crashing or is it just one of those things and I have been lucky up to now?

The whole server had been down for unknown reason and had just been rebooted. Could that be the cause?

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
StarWolf3000
Board Member



Joined: 10 Jun 2010

Posts: 127
Location: Germany


flag
PostPosted: Sun Jun 14, 2015 8:54 am 
Post subject: Re: Table crash

Is your sessions table using the default MyISAM engine? In most cases MEMORY would be the better storage engine (you can change it with ALTER TABLE prefix_sessions ENGINE=MEMORY; ).

This stores the structure of the table on disk, but it's contents in RAM of the server (make sure your server has enough RAM and MySQL enough assigned), emptying the table when MySQL is stopped/restarted.

To repair the sessions table:
REPAIR TABLE prefix_sessions;

If your server rebooted without a MySQL clean shutdown, this can lead to a problem with tables, when data is written to the disk during that moment. Normally, MySQL autochecks most databases and tables on startup and tries to repair them on its own (or prompting the user to do that, only with shell access), but there can always be some lost or corrupted data.

A lot of database related problems in phpBB 2.x origin of corrupted sessions tables.
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Sun Jun 14, 2015 9:02 am 
Post subject: Re: Table crash

Thanks for the info. I shall monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
Matuse
Board Member



Joined: 18 Apr 2017

Posts: 1



PostPosted: Sat Apr 22, 2017 7:24 am 
Post subject: Re: Table crash

Jim_UKe wrote:
Thanks for the info. I shall try the Yoga Burn monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.

Jim


I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself.
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Sat Apr 22, 2017 7:30 am 
Post subject: Re: Table crash

We have had no problems since that incident.
Have you run a repair on your database tables?

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
DanielBenford
Board Member



Joined: 20 Jul 2018

Posts: 1



PostPosted: Fri Jul 20, 2018 2:47 am 
Post subject: Re: Table crash

Matuse wrote:
Jim_UKe wrote:
Thanks for the info. I shall try to monitor it for a while before deciding whether to take phenq will make any change. That is the first table crash in 10 years.

Jim


I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself.


I've also experienced a crash once after 5-6 years of running with no problem. One table got corrupted, but backups helped. No problem experienced since then.
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Fri Jul 20, 2018 9:01 am 
Post subject: Re: Table crash

Still just had the one table crash and now at 14 years.
I do of course do regular database backups "just in case"

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 317
Location: U.S.A


flag
PostPosted: Mon Jul 23, 2018 8:32 pm 
Post subject: Re: Table crash

We've found it helpful to run scheduled optimize and repairs on tables. Also for INNODB it has been helpful to have each table have its own file....
_________________
http://www.jlaforums.com
Back to top
Manuelm
Board Member



Joined: 02 Aug 2018

Posts: 1



PostPosted: Thu Aug 02, 2018 9:40 am 
Post subject: Re: Table crash

Matuse wrote:
Jim_UKe wrote:
Thanks for the info. I shall try the Yoga Burn monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.

Jim


I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself.


I had my first one the other day after 8 years of perfect running. I've been doing backups since the start and I can tell you, all of that extra time backing things up did pay off in the end icon_biggrin.gif
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Thu Aug 02, 2018 11:01 am 
Post subject: Re: Table crash

I used to do a daily backup using Msqldumper but have reduced it to about once a week.
Daily is better of course. icon_wink.gif

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Sat Feb 16, 2019 3:32 pm 
Post subject: Re: Table crash

Jim_UK wrote:
For the very first time I have just experienced my database crash. This was a single table in the database (sessions table)
Jim


Well I have just had my second one and once again it is the sessions table. Could it be that of all the tables this is the one most likely to develop problems. Fortunately I happened to be on line at the moment the sessions table crashed so it was fixed in just a couple of minutes. icon_biggrin.gif

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
lumpy burgertushie
Board Member



Joined: 19 Nov 2008

Posts: 237


flag
PostPosted: Sun Feb 17, 2019 5:28 pm 
Post subject: Re: Table crash

so, once ever 4 years the sessions table gets sideways. I would say that is not too bad.

are you truncating the table when you fix it? if not, do that. all that will happen is that it will log out anyone logged in at the time and everyone will have to log in next time they visit.


maybe the table just can't handle as many records as it has after 4 years.


robert
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Sun Feb 17, 2019 5:36 pm 
Post subject: Re: Table crash

Hi Robert
Rarely more than about 7 or 8 on line at anyone time.
I don't truncate it - just run a repair on it and that cures the problem.
First indication there was a problem was when I tried to do a search for "posts since last visit".
That threw up an error message on the screen indication a sessions table error.
I didn't do a screen shot but was something to do with a duplicate entry in sessions table.

Problem solved - I just wondered if the sessions table was prone to this sort of thing.

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
StarWolf3000
Board Member



Joined: 10 Jun 2010

Posts: 127
Location: Germany


flag
PostPosted: Mon Feb 18, 2019 7:28 am 
Post subject: Re: Table crash

I'm just wondering: phpBB2 already includes a clean-up routine for the sessions, so I don't really get it why the table gets full or damaged. Even though its not of type MEMORY by default, it should not become "full", since the key is not an integer (that might overflow), but a 32 chars string.
If its type is MyISAM, then you have a row limit of 4,294,967,296 (2^32), unless MySQL has been built with the --with-big-tables option, for which the row limit is 18,446,744,073,709,551,616 (2^64).

If it gets full, then you're probably hitting the 4 billion something mark.
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 585
Location: North West UK


flag
PostPosted: Mon Feb 18, 2019 10:29 am 
Post subject: Re: Table crash

The error message was something about a duplicate entry. I should have done a screen grab but first thing on my mind was get rid of the problem before I start getting emails/phone calls from members telling me there was a problem. icon_wink.gif

Jim

_________________
The truth is out there.
Unfortunately they will not let you anywhere near it!
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT
Goto page 1, 2  Next
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0260 seconds using 15 queries. (SQL 0.0016 Parse 0.0009 Other 0.0235)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo