Geeklog Forums

It crashed last week twice and today also

Here is the error log


Jul 20 08:45:18 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184942418
Fri Jul 20 08:45:20 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184942420
Fri Jul 20 08:46:22 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184942482
Fri Jul 20 08:50:04 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:50:20 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:50:33 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:51:19 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:51:48 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:52:46 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:52:59 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 08:53:02 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:08:12 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:08:14 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:09:23 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:10:28 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:21:09 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184944569
Fri Jul 20 09:21:34 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184944594
Fri Jul 20 09:21:43 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184944603
Fri Jul 20 09:21:54 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184944614
Fri Jul 20 09:26:16 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:26:48 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:27:23 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:27:47 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:28:07 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Fri Jul 20 09:38:34 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945614
Fri Jul 20 09:38:34 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945614
Fri Jul 20 09:38:40 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945620
Fri Jul 20 09:38:42 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945622
Fri Jul 20 09:38:44 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945624
Fri Jul 20 09:38:45 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945625
Fri Jul 20 09:38:46 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945626
Fri Jul 20 09:38:48 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945628
Fri Jul 20 09:38:49 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945629
Fri Jul 20 09:38:50 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945630
Fri Jul 20 09:39:02 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND start_time < 1184945642








Can you tell me why is this happening?

Did this problem ever get resolved?

Yes i fixed that one by repairing that table. But today again the site was down. And now it is automitically up again.

I called the host and they told me they restareted the mysql because it was slow or something like that

and after 1 hour it is offline again

bluehost sucks big time

but why all the other sites are working that are nt made in geeklog on my server

here is the errorl log again


Fri Jul 20 12:48:27 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950107)
Fri Jul 20 12:48:29 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950109)
Fri Jul 20 12:48:30 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950110)
Fri Jul 20 12:49:25 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950165)
Fri Jul 20 12:49:27 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950167)
Fri Jul 20 12:49:29 2007 - 1030: Got error 127 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE (start_time < 1184950169)

Repair the table (again) and talk to your hosting service (again).

Try a Google search for "Got error 127 from storage engine". The results seem to indicate either a problem with a specific version of MySQL or some limitations set up by your host for your database and that you are running into.

Are you using some plugin or add-on that creates a lot of db entries? Like the GUS plugin or some sort of adserver? That may have something to do with it.

MySQL can crash and when it does, it often takes a table with it. But that should be a rare thing. If it happens often, the problems are somewhere else - and your hosting service, if they are worth their money, should be able to explain what's happening.

bye, Dirk

I only have

Edit calendar 1.0.0 1.4.1
Edit captcha 2.0.2 1.4.0
Edit links 1.0.1 1.4.1
Edit phpbbbridge 107 1.3.10
Edit polls 1.1.0 1.4.1
Edit spamx 1.1.0 1.4.1
Edit staticpages