Page 1 of 1
DBB error
Posted: Sun Feb 12, 2006 4:15 pm
by VonVulcan
I just clicked on a forum topic and got this... no clue why or if it is important...
General Error
Could not query new topic information
DEBUG MODE
SQL Error : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SELECT t.forum_id, t.topic_id, p.post_time FROM phpbb_topics t, phpbb_posts p WHERE p.post_id = t.topic_last_post_id AND p.post_time > 1139770351 AND t.topic_moved_id = 0
Line : 201
File : index.php
Posted: Sun Feb 12, 2006 4:27 pm
by Bet51987
I got exactly the same one yesterday, one time only. It hasn't happened today at all....
Just for your ref.
Bettina
Posted: Sun Feb 12, 2006 6:22 pm
by KoolBear
I'm not sure but I think MSSQL handles this routine differently than MySQL does. Because this is extremely common occurence for me too.
You can see it's when two or more users invoke this routine.
Posted: Mon Feb 13, 2006 2:16 pm
by Top Wop
Another error. THis happens all the time: I would go back to edit a post, submit it, and it would just sit there until it moves to a white screen. Then I have to hit the back button and hit submit again. Sometimes it goes, sometimes I have to give it a few more tries. Sometimes it gets aggrivating and I give up.
Posted: Mon Feb 13, 2006 3:51 pm
by MD-2389
Top, I've seen that happen just making a post.
Posted: Tue Feb 14, 2006 3:47 am
by roid
i'm getting Top Wop's problem as well. Also the DBB is acting mega slow.
Posted: Wed Feb 15, 2006 11:24 am
by Richard Cranium
I'll look in to it right away.
RC
Posted: Wed Feb 15, 2006 2:08 pm
by MD-2389
Thank you.
Posted: Thu Feb 16, 2006 6:45 am
by Suncho
Yeah. The DBB is really slow right now. I think it's timing out a lot. I'm getting blank white screens and the debug error... and when my posts do go through, they take forever.
Posted: Thu Feb 16, 2006 7:30 pm
by Bet51987
I have to try several times to get one post thru. I get DEBUG, or just a white page that says \"done\". It seens to be worse than last week...
Bettina
Posted: Thu Feb 16, 2006 7:31 pm
by Bet51987
I have to try several times to get one post thru. I get DEBUG, or just a white page that says \"done\". It seens to be worse than last week...
Bettina
Posted: Thu Feb 16, 2006 7:57 pm
by Suncho
Hey you made a post! Congratulations! This one probably won't go through. =P
Posted: Thu Feb 16, 2006 8:06 pm
by Richard Cranium
I've made some updates to the server that will take effect over night. They should improve the response.
Posted: Fri Feb 17, 2006 8:01 am
by Richard Cranium
Ok, the change was made over night. Let's see what happens.
Posted: Fri Feb 17, 2006 8:06 am
by KoolBear
I got this from, Diedel this morning Fri Feb 17, 2006 7:38 am
Diedel wrote:
KB,
the performance problems seem to be related to some filtering or dictionary uplook/management when posting. The longer the post, the worse. I had once received an SQL error message hinting to such a problem.
Diedel
Posted: Fri Feb 17, 2006 4:46 pm
by Suncho
I'm still having problems. It's not as bad as yesterday though.
Posted: Fri Feb 17, 2006 5:31 pm
by KoolBear
X2 4 what Suncho said
Re:
Posted: Sat Feb 18, 2006 9:43 am
by roid
Top Wop wrote:Another error. THis happens all the time: I would go back to edit a post, submit it, and it would just sit there until it moves to a white screen. Then I have to hit the back button and hit submit again. Sometimes it goes, sometimes I have to give it a few more tries. Sometimes it gets aggrivating and I give up.
this coupled with the general slowness of the DBB is getting increasingly annoying
Posted: Sun Feb 19, 2006 4:14 pm
by MD-2389
Its getting worse now. The server is timing out quite frequently now, and refuses to respond for atleast two minutes at a time.
Posted: Sun Feb 19, 2006 5:15 pm
by Richard Cranium
Ok, I just made a couple more adjustments. The DB had grown to over 700 megs and I needed a little cleanup.
RC
Posted: Sun Feb 19, 2006 5:43 pm
by MD-2389
Ok, the server is MUCH faster now, but its still timing out on my end. I can just hit retry in firefox and it reconnects just fine though. No more two minute waits. *knocks on wood*
Thank you Richard.
Posted: Sun Feb 19, 2006 10:28 pm
by Richard Cranium
Ya, it looks like one of the indexes got corrupted. The DB had also grown to almost 800 megs because of the bad index. I'll have to spend some time on it to shrink it back down.
Posted: Mon Feb 20, 2006 7:33 pm
by roid
aright i just got this error, do you notice it says \"error DELETING\" ? i wasn't deleting anything, i was EDITING my post!! maybe this is the cause of teh fubar?
Error in deleting post
DEBUG MODE
SQL Error : Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
DELETE FROM phpbb_search_wordmatch WHERE post_id IN (157043)
Line : 419
File : functions_search.php
Posted: Tue Feb 21, 2006 7:15 pm
by Bet51987
I got \"Debug Mode...can't query database\" about 6 times tonight. FYI.
Bettina
Posted: Tue Feb 21, 2006 11:58 pm
by Kilarin
I got debug mode just trying to READ this very topic. now that was odd.
AND I've been trying to edit a bad tag in
this post all evening, getting the white screen of annoyance.
that will teach me to make typos!
Posted: Thu Feb 23, 2006 10:28 am
by Suncho
Yeah this is getting kinda ridiculous.
Posted: Thu Feb 23, 2006 10:29 am
by KoolBear
I agree, Diedel lost a rather LARGE thread today.
Posted: Thu Feb 23, 2006 1:18 pm
by MD-2389
Hell, I got a debug error just trying to load the index last night.
Posted: Thu Feb 23, 2006 6:12 pm
by Bet51987
Maybe its a spy from the \"other\" place thats slowing us down. Nah....just kidding..... or am I.
Bettina
Posted: Thu Feb 23, 2006 10:41 pm
by roid
oh sure, blame jesus
the DBB borkborks are still getting worse, like MD i have occasionly been getting problems just loading index pages
Posted: Thu Feb 23, 2006 11:29 pm
by KompresZor
Code: Select all
Could not obtain post/user information.
DEBUG MODE
SQL Error : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 9235 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 40
Line : 399
File : viewtopic.php
Posted: Fri Feb 24, 2006 9:56 am
by MD-2389
Got this just now trying to load the index:
Could not query forums information
DEBUG MODE
SQL Error : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order
Line : 167
File : index.php
Posted: Sat Feb 25, 2006 4:14 pm
by Diedel
I need to edit quite a few posts a day usually, and I am sick and tired of it.
This is not what I donated for.
KB,
collect some more money and get us to a
dedicated server running Linux!
Posted: Sat Feb 25, 2006 4:45 pm
by Krom
Or at least get it off MS-SQL.
Posted: Sat Feb 25, 2006 5:27 pm
by KoolBear
I beleive the serach word index table is corrupted, add to it that when I try and rebuild it I get an error message ...
Code: Select all
Could not delete search table
DEBUG MODE
SQL Error : The statement has been terminated.
DELETE FROM phpbb_search_wordmatch
Line : 326
File : functions_admin_rebuild_search.php
Now if I could find RC to look into this backend error ...
Posted: Sat Feb 25, 2006 5:31 pm
by KoolBear
EXPECT some delays, I have started rebuilding the search word index, but had to use the truncate command instaed of the \"delete the table contents\" option.
Not sure but maybe it will help.
Posted: Sat Feb 25, 2006 6:56 pm
by KoolBear
Code: Select all
Could not insert new word
DEBUG MODE
SQL Error : Internal Query Processor Error: The query processor ran out of stack space during query optimization.
INSERT INTO phpbb_search_wordlist (word_text, word_common) SELECT '0', 0 UNION ALL SELECT '03pm', 0 UNION
...
blah blah blah
...
'youve', 0 UNION ALL SELECT 'zappafan', 0 UNION ALL SELECT 'zapped', 0 UNION ALL SELECT 'zero', 0 UNION ALL SELECT 'zoom', 0
Line : 234
File : functions_search.php
Posted: Sat Feb 25, 2006 7:52 pm
by Krom
Perhaps the SQL server isn't set up to handle the user load that it is under.
Posted: Mon Feb 27, 2006 12:22 am
by roid
here's an ingeresting error i just got while trying to click on the E&C Swedish feminists thread
General Error
Could not obtain newer/older topic information
DEBUG MODE
SQL Error : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SELECT p.post_id FROM phpbb_posts p, phpbb_sessions s, phpbb_users u WHERE s.session_id = '17342f99d17a3506ab41baae78f56bda' AND u.user_id = s.session_user_id AND p.topic_id = 9595 AND p.post_time >= u.user_lastvisit ORDER BY p.post_time ASC LIMIT 1
Line : 84
File : viewtopic.php
Posted: Wed Mar 01, 2006 10:57 pm
by MD-2389
Just curious, but am I the only one here having issues with the board timing out?