DEBUG MODE

Trainman · Post by **Trainman** » 23 Sep 2010, 10:00

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '9227' for key 2

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('edc71f27265406935a4c4cfc44bc22cc', 9227, 1285232351, 1285232351, '3e194837', 3, 1, 0)

Line : 187
File : sessions.php

The above is what greeted me about 5 minutes ago when I tried to log in.

citroenxm · Post by **citroenxm** » 23 Sep 2010, 10:11

Me too, but seems solved now...

PAul

Xaccers · Post by **Xaccers** » 23 Sep 2010, 11:05

Session table had crashed, I've repaired it with washing up liquid bottles and some sticky backed plastic

Trainman · Post by **Trainman** » 23 Sep 2010, 11:08

Xac wrote:Session table had crashed, I've repaired it with washing up liquid bottles and some sticky backed plastic

Ah, only a temporary fix then, should have used double sided sticky tape and PVA glue, Blue Peter badge technology

spider · Post by **spider** » 23 Sep 2010, 11:32

/Tech type post

Suggestion: consider moving the session table to memory to prevent crashes.

It will retain the table structure on disk obviously, but the data contents are held in memory. These will be lost when server offline (but mysql offline = no forum anyway)

They tend to not crash (at least in my experience with other software) when set to heap.

, I doubt there is any data held in the session table that is needed after a restart (although I'd have to install phpbb2 to double check they have not held any critical data in it, I doubt it though)

Does cause a small increase in server memory usage though, but seems an acceptable compromise in most cases, as a memory based table cannot crash and given its nature it is the most heavily used table.

Caution ( ! ) don't set any other tables to memory, I've seen that done.

/End of tech type post

davetherave · Post by **davetherave** » 23 Sep 2010, 14:52

I just heard a wooshing noise above my head.....

jgra1 · Post by **jgra1** » 23 Sep 2010, 15:02

that was the table before it crashed into the wall

Xaccers · Post by **Xaccers** » 23 Sep 2010, 15:06

Cheers Spider, have now changed to HEAP

spider · Post by **spider** » 23 Sep 2010, 15:09

Xac wrote:Cheers Spider, have now changed to HEAP

All being well, it should never crash now (that table anyway)

I can't (without installing and checking) seeing anything of value living in that table really, obviously server restart = loss sessions so everyone will have to login again but that should be it really.

You're welcome anyway

Xaccers · Post by **Xaccers** » 23 Sep 2010, 15:19

It crashed due to the server going down without giving sql enough time to shut down cleanly.

It only contains temporary session data.
Will keep an eye on memory use, if it does start going up a significant amount (I really doubt it) I've got a script that can clear out the oldest sessions.

Post by **myglaren** » 23 Sep 2010, 17:07

Trainman wrote:phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '9227' for key 2

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('edc71f27265406935a4c4cfc44bc22cc', 9227, 1285232351, 1285232351, '3e194837', 3, 1, 0)

Line : 187
File : sessions.php

The above is what greeted me about 5 minutes ago when I tried to log in.

I got the same thing yesterday evening and thought that it was just me.

spider · Post by **spider** » 23 Sep 2010, 17:33

Spoke to (well messaged) Xac earlier, should hopefully not happen again now

, all being well that is.

French Car Forum

DEBUG MODE

DEBUG MODE

Re: DEBUG MODE