DBB error

VonVulcan · Post by **VonVulcan** » Sun Feb 12, 2006 4:15 pm

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

Bet51987 · Post by **Bet51987** » Sun Feb 12, 2006 4:27 pm

I got exactly the same one yesterday, one time only. It hasn't happened today at all....

Just for your ref.

Bettina

KoolBear · Post by **KoolBear** » Sun Feb 12, 2006 6:22 pm

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.

Top Wop · Post by **Top Wop** » Mon Feb 13, 2006 2:16 pm

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.

MD-2389 · Post by **MD-2389** » Mon Feb 13, 2006 3:51 pm

Top, I've seen that happen just making a post.

roid · Post by **roid** » Tue Feb 14, 2006 3:47 am

i'm getting Top Wop's problem as well. Also the DBB is acting mega slow.

Richard Cranium · Post by **Richard Cranium** » Wed Feb 15, 2006 11:24 am

I'll look in to it right away.

RC

MD-2389 · Post by **MD-2389** » Wed Feb 15, 2006 2:08 pm

Thank you.

Suncho · Post by **Suncho** » Thu Feb 16, 2006 6:45 am

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.

Bet51987 · Post by **Bet51987** » Thu Feb 16, 2006 7:30 pm

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

Bet51987 · Post by **Bet51987** » Thu Feb 16, 2006 7:31 pm

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

Suncho · Post by **Suncho** » Thu Feb 16, 2006 7:57 pm

Hey you made a post! Congratulations! This one probably won't go through. =P

Richard Cranium · Post by **Richard Cranium** » Thu Feb 16, 2006 8:06 pm

I've made some updates to the server that will take effect over night. They should improve the response.

Richard Cranium · Post by **Richard Cranium** » Fri Feb 17, 2006 8:01 am

Ok, the change was made over night. Let's see what happens.

KoolBear · Post by **KoolBear** » Fri Feb 17, 2006 8:06 am

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

Suncho · Post by **Suncho** » Fri Feb 17, 2006 4:46 pm

I'm still having problems. It's not as bad as yesterday though.

KoolBear · Post by **KoolBear** » Fri Feb 17, 2006 5:31 pm

X2 4 what Suncho said

roid · Post by **roid** » Sat Feb 18, 2006 9:43 am

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

MD-2389 · Post by **MD-2389** » Sun Feb 19, 2006 4:14 pm

Its getting worse now. The server is timing out quite frequently now, and refuses to respond for atleast two minutes at a time.

Richard Cranium · Post by **Richard Cranium** » Sun Feb 19, 2006 5:15 pm

Ok, I just made a couple more adjustments. The DB had grown to over 700 megs and I needed a little cleanup.

RC

MD-2389 · Post by **MD-2389** » Sun Feb 19, 2006 5:43 pm

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.

Richard Cranium · Post by **Richard Cranium** » Sun Feb 19, 2006 10:28 pm

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.

roid · Post by **roid** » Mon Feb 20, 2006 7:33 pm

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

Bet51987 · Post by **Bet51987** » Tue Feb 21, 2006 7:15 pm

I got \"Debug Mode...can't query database\" about 6 times tonight. FYI.

Bettina

Kilarin · Post by **Kilarin** » Tue Feb 21, 2006 11:58 pm

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!

Suncho · Post by **Suncho** » Thu Feb 23, 2006 10:28 am

Yeah this is getting kinda ridiculous.

KoolBear · Post by **KoolBear** » Thu Feb 23, 2006 10:29 am

I agree, Diedel lost a rather LARGE thread today.

MD-2389 · Post by **MD-2389** » Thu Feb 23, 2006 1:18 pm

Hell, I got a debug error just trying to load the index last night.

Bet51987 · Post by **Bet51987** » Thu Feb 23, 2006 6:12 pm

Maybe its a spy from the \"other\" place thats slowing us down. Nah....just kidding..... or am I.

Bettina

roid · Post by **roid** » Thu Feb 23, 2006 10:41 pm

oh sure, blame jesus

the DBB borkborks are still getting worse, like MD i have occasionly been getting problems just loading index pages

KompresZor · Post by **KompresZor** » Thu Feb 23, 2006 11:29 pm

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

This May Help

MD-2389 · Post by **MD-2389** » Fri Feb 24, 2006 9:56 am

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

Diedel · Post by **Diedel** » Sat Feb 25, 2006 4:14 pm

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!

Krom · Post by **Krom** » Sat Feb 25, 2006 4:45 pm

Or at least get it off MS-SQL.

KoolBear · Post by **KoolBear** » Sat Feb 25, 2006 5:27 pm

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 ...

KoolBear · Post by **KoolBear** » Sat Feb 25, 2006 5:31 pm

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.

KoolBear · Post by **KoolBear** » Sat Feb 25, 2006 6:56 pm

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

Krom · Post by **Krom** » Sat Feb 25, 2006 7:52 pm

Perhaps the SQL server isn't set up to handle the user load that it is under.

roid · Post by **roid** » Mon Feb 27, 2006 12:22 am

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

MD-2389 · Post by **MD-2389** » Wed Mar 01, 2006 10:57 pm

Just curious, but am I the only one here having issues with the board timing out?

DBB error

DBB error

Re: