DEBUG MODE

Forum News, Announcements and any issues you're having with the forum

Moderator: myglaren

Trainman
Posts: 2674
Joined: Fri Aug 21, 2009 11:58 am
Location: Penwortham
My Cars: 2007 Citroen C6 Exclusive, 2002 Citroen C5 SX Estate
Contact:

DEBUG MODE

Postby Trainman » Thu Sep 23, 2010 10:00 am

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.
0 x
Steve

2007 C6 2.7 V6 Exclusive in Mauritius Blue
2002 C5 2.0 HDi SX Estate Silver

Head Admin for http://www.C6Owners.org

citroenxm
Posts: 11032
Joined: Fri Dec 31, 2004 12:10 am
Location: I WISH I KNEW!!!!. Somewhere in North Wales, Anglesey
My Cars: 93 L Xantia TD SX anti sink
H 91 XM V6 24v PRV Manual
K 93 XM V6 12v SEi auto LPG

55 C5 1.6 HDi VTR
L 94 XM 2.1 TD auto
51 C5 LX HDi 2.0 auto
x 20

Postby citroenxm » Thu Sep 23, 2010 10:11 am

Me too, but seems solved now...

PAul
0 x
1991 XM 3.0 24v Manual (x2)
1994 XM 2.1 d auto (undecided what to do now)

1994 Xantia TD SX Project
s**t thats scarey... two XMs left...

User avatar
Xaccers
Posts: 8035
Joined: Thu Feb 08, 2007 12:46 am
Location: Milling around Milton Keynes
My Cars:
x 1

Postby Xaccers » Thu Sep 23, 2010 11:05 am

Session table had crashed, I've repaired it with washing up liquid bottles and some sticky backed plastic :)
0 x
1.9TD+ SX Xantia Estate (Cassy) running on 100% veg
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)

DIY sphere tool

Trainman
Posts: 2674
Joined: Fri Aug 21, 2009 11:58 am
Location: Penwortham
My Cars: 2007 Citroen C6 Exclusive, 2002 Citroen C5 SX Estate
Contact:

Postby Trainman » Thu Sep 23, 2010 11:08 am

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 :lol: :lol: :lol:
0 x
Steve

2007 C6 2.7 V6 Exclusive in Mauritius Blue
2002 C5 2.0 HDi SX Estate Silver

Head Admin for http://www.C6Owners.org

User avatar
spider
Posts: 3986
Joined: Tue Jan 05, 2010 3:28 pm
Location: Derby.
My Cars: Soon, I hope...
x 63
Contact:

Postby spider » Thu Sep 23, 2010 11:32 am

/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
0 x
Andy.

91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG

User avatar
davetherave
Posts: 1071
Joined: Wed Apr 01, 2009 9:06 pm
Location: Norwich
My Cars:
x 1

Postby davetherave » Thu Sep 23, 2010 2:52 pm

I just heard a wooshing noise above my head..... :lol:
0 x
(95) XM Silver 2.1td Exclusive.
(87) Cx 2.5 DTR T1 undergoing major cosmetic surgery.
GPZ500s

jgra1
Posts: 4831
Joined: Sun Nov 27, 2005 8:07 pm
Location: Kent / Susssex
My Cars: 2010 C5 X7 2.0 hdi 160 exc auto
MG TF 135
Honda VFR800 Fix
Honda Goldwing 1500/6 old and gold
x 9

Postby jgra1 » Thu Sep 23, 2010 3:02 pm

that was the table before it crashed into the wall :D
0 x

User avatar
Xaccers
Posts: 8035
Joined: Thu Feb 08, 2007 12:46 am
Location: Milling around Milton Keynes
My Cars:
x 1

Postby Xaccers » Thu Sep 23, 2010 3:06 pm

Cheers Spider, have now changed to HEAP
0 x
1.9TD+ SX Xantia Estate (Cassy) running on 100% veg
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)

DIY sphere tool

User avatar
spider
Posts: 3986
Joined: Tue Jan 05, 2010 3:28 pm
Location: Derby.
My Cars: Soon, I hope...
x 63
Contact:

Postby spider » Thu Sep 23, 2010 3:09 pm

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 :)
0 x
Andy.

91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG

User avatar
Xaccers
Posts: 8035
Joined: Thu Feb 08, 2007 12:46 am
Location: Milling around Milton Keynes
My Cars:
x 1

Postby Xaccers » Thu Sep 23, 2010 3:19 pm

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.
0 x
1.9TD+ SX Xantia Estate (Cassy) running on 100% veg
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)

DIY sphere tool

User avatar
myglaren
Forum Admin Team
Posts: 12536
Joined: Sun Mar 02, 2008 2:30 pm
Location: Katzenellen Bogen by the Sea
My Cars: 2003 C5 2.0 HDi 110 SX 213,200
x 78

Re: DEBUG MODE

Postby myglaren » Thu Sep 23, 2010 5:07 pm

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.
0 x
________________________________
Sent via Heliograph from the other side of the mountain

Steve

Jackie Evancho...Divine!

User avatar
spider
Posts: 3986
Joined: Tue Jan 05, 2010 3:28 pm
Location: Derby.
My Cars: Soon, I hope...
x 63
Contact:

Postby spider » Thu Sep 23, 2010 5:33 pm

Spoke to (well messaged) Xac earlier, should hopefully not happen again now ;) , all being well that is. :)
0 x
Andy.

91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG


Return to “Forum News, Announcements and Issues”

Who is online

Users browsing this forum: No registered users and 4 guests