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.
DEBUG MODE
Moderator: myglaren
-
- (Donor 2018)
- Posts: 2590
- Joined: 21 Aug 2009, 11:58
- Location: Penwortham
- Lexia Available: Yes
- My Cars: 2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
2017 1.6HDi Berlingo Van - the works van - x 42
- Contact:
DEBUG MODE
Steve
2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
http://c6owners.org/index.php
2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
http://c6owners.org/index.php
-
- Posts: 8061
- Joined: 30 Dec 2004, 23:10
- Location: Somewhere in North Wales, Anglesey
- My Cars: M reg Xm S2 2.1td Auto Exclusive. 269k and rising
L reg XM S1 V6 12v Manual SEi
L 94 XM 2.1 TD auto total resto
2008 Peugeot 207 Sw 1.6 16v hdi. 217k and rising
2010 Peugeot 207 SW 1.6 8v HDi 161k and rising - x 71
- Xaccers
- Posts: 7654
- Joined: 07 Feb 2007, 23:46
- Location: Milling around Milton Keynes
- My Cars:
- x 184
Session table had crashed, I've repaired it with washing up liquid bottles and some sticky backed plastic
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
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)
DIY sphere tool
-
- (Donor 2018)
- Posts: 2590
- Joined: 21 Aug 2009, 11:58
- Location: Penwortham
- Lexia Available: Yes
- My Cars: 2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
2017 1.6HDi Berlingo Van - the works van - x 42
- Contact:
Ah, only a temporary fix then, should have used double sided sticky tape and PVA glue, Blue Peter badge technologyXac wrote:Session table had crashed, I've repaired it with washing up liquid bottles and some sticky backed plastic
Steve
2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
http://c6owners.org/index.php
2008 C6 2.7 Exclusive in Mativoire Beige with Vitali Leather.
2019 C5 1.6 Aircross Flair+ in Platinum Grey with Claudia Rimini Leather
http://c6owners.org/index.php
- spider
- Posts: 3949
- Joined: 05 Jan 2010, 14:28
- Location: Derby.
- My Cars: Soon, I hope...
- x 77
- Contact:
/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
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
Andy.
91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG
91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG
-
- Posts: 880
- Joined: 01 Apr 2009, 21:06
- Location: Norwich
- My Cars:
- x 4
- Xaccers
- Posts: 7654
- Joined: 07 Feb 2007, 23:46
- Location: Milling around Milton Keynes
- My Cars:
- x 184
Cheers Spider, have now changed to HEAP
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
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)
DIY sphere tool
- spider
- Posts: 3949
- Joined: 05 Jan 2010, 14:28
- Location: Derby.
- My Cars: Soon, I hope...
- x 77
- Contact:
All being well, it should never crash now (that table anyway)Xac wrote:Cheers Spider, have now changed to HEAP
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
Andy.
91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG
91 205D-Turbo, gone but still missed
02 106D, TUD5B, gone but not really missed apart from the MPG
- Xaccers
- Posts: 7654
- Joined: 07 Feb 2007, 23:46
- Location: Milling around Milton Keynes
- My Cars:
- x 184
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.
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.
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
1.9TD SX Xantia Hatchback (Jenny) running on 100% veg for sale
Laguna II 2.0dCi Privilege (Monty)
DIY sphere tool
- myglaren
- Forum Admin Team
- Posts: 25480
- Joined: 02 Mar 2008, 13:30
- Location: Washington
- My Cars: Mazda 6
Ooops.
Previously:
2009 Honda Civic :(
C5, C5, Xantia, BX, GS, Visa.
R4, R11TXE, R14, R30TX - x 4922
Re: DEBUG MODE
I got the same thing yesterday evening and thought that it was just me.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.