Interesting errors

What do you want to see here? Some more categories, forums, and mods? Hmm...
Post Reply
User avatar
Z-Man
God & Project Admin
Posts: 11710
Joined: Sun Jan 23, 2005 6:01 pm
Location: Cologne
Contact:

Interesting errors

Post by Z-Man »

When restarting my laptop with KDE and konqueror, I had several tabs with forum threads open. Usually, that's no problem, but this time I got two errors:
http://forums.armagetronad.net/viewtopic.php?p=135941#135941 wrote:phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry 'cfd42af35a99f60f5e4162aa3a1437b1' for key 'PRIMARY'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('cfd42af35a99f60f5e4162aa3a1437b1', 352, 1170528102, 1170528102, '50871d59', 4, 1)

Line : 158
File : sessions.php
http://forums.armagetronad.net/viewtopic.php?sid=07e878c5b7bf83c31a01c72bf9e2a746&p=137871#137871 wrote:phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '519d80615afab9b6a1daf072d6fad830' for key 'PRIMARY'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('519d80615afab9b6a1daf072d6fad830', 352, 1170528101, 1170528101, '50871d59', 4, 1)

Line : 158
File : sessions.php
Looks like the simultaneous queries made the random session key generation slightly less random than it should be :) A negligible glitch, certainly. Refreshing the pages made the errors go away.
User avatar
Jonathan
A Brave Victim
Posts: 3391
Joined: Thu Feb 03, 2005 12:50 am
Location: Not really lurking anymore

Post by Jonathan »

Heh. Let me add that it didn't mark everything as read when I loaded several threads at once lately.
ˌɑrməˈɡɛˌtrɑn
User avatar
Tank Program
Forum & Project Admin, PhD
Posts: 6712
Joined: Thu Dec 18, 2003 7:03 pm

Post by Tank Program »

Go figure... There are more errors here because it gets used more :).
Image
User avatar
Jonathan
A Brave Victim
Posts: 3391
Joined: Thu Feb 03, 2005 12:50 am
Location: Not really lurking anymore

Post by Jonathan »

The average should be similar.

Anyway, I had a good reason to load many pages at once: a broken connection. I could actually see threads slowly being added to index pages, or bits of posts to threads, or simply nothing for seconds. Letting that happen in the background while the connection usually sits mostly idle helps a lot. It seems that the ISP is now finally trying to get the connection back up to 'normal' standards ('' because as we all know by now it isn't the greatest ISP), but I need some more samples to be sure (I'm not even there at the moment).
ˌɑrməˈɡɛˌtrɑn
User avatar
belenus
Round Winner
Posts: 269
Joined: Wed Nov 30, 2005 6:22 pm
Location: Cologne
Contact:

Post by belenus »

Just got one too...
http://forums.armagetronad.net/search.php?search_id=newposts wrote:General Error

Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '1561579679' for key 'PRIMARY'

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1561579679, '9e4c8151e742f16fd24680763fd9b6cc', 'a:7:{s:14:"search_results";s:26:"13021, 13331, 13471, 13481";s:17:"total_match_count";i:4;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 709
File : search.php
- bel
User avatar
Tank Program
Forum & Project Admin, PhD
Posts: 6712
Joined: Thu Dec 18, 2003 7:03 pm

Post by Tank Program »

Yeah, sometimes that happens.
Image
Post Reply