|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
MySQL - 4.1.22 PHP Version 4.3.11 I installed 7.5 last night and today I have a few hundred kbs of MySQL error logs. Also, forum features appear to be intermittently slow. They are predominately like this... (I guess 95% relate to showprofile.inc.php) I asked my host if there was any issue with the MySQL server and there isn't. All the other scripts on my site using php/MySQL appear to be ok.
Script: /-----/forums/scripts/showprofile.inc.php - Line: 418
select t2.USER_AVATAR,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT,t3.USER_DISPLAY_NAME,t3.USER_ID,t4.ONLINE_LAST_ACTIVITY,t2.USER_MOOD
from ubbt_ADDRESS_BOOK as t1
left join ubbt_ONLINE as t4 on t4.USER_ID = t1.USER_ID,
ubbt_USER_PROFILE as t2,
ubbt_USERS as t3
where t1.ADDRESS_ENTRY_USER_ID = 272
and t1.USER_ID = t2.USER_ID
and t2.USER_ID = t3.USER_ID
- Lost connection to MySQL server during query
Any thoughts?
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Even though your host states no problem. I would be highly suspicious of "Lost connection to MySQL server during query" But for the rest of it. I noticed when I upgraded to 7.5 I had similar errors other than the connection issue. I recall about 4 entries but I believe a different line.
Call it coincidence but when I enabled the profile comments. The errors did not return.
To your question about slow I did notice at first that viewing profiles seemed to stall a little but not now. But if you are having Mysql connection issues, that would slow down everything.
But in any case I think this should be in the Bug forum.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
I didn't post it in the bug forum as I figured that if it was a bug it would have affected others (and there didn't appear to be a more appropriate forum). Call it coincidence but when I enabled the profile comments. The errors did not return. I'll have a look for this
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
when I enabled the profile comments. Can't see the wood for the trees... Where is this?
|
|
|
|
Joined: Jun 2006
Posts: 16,365 Likes: 126
|
Joined: Jun 2006
Posts: 16,365 Likes: 126 |
Well, the benefit of the error logging is it blatantly tells you the problem in the error message; if you're loosing connections to MySQL it's generally the MySQL servers fault
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
Cheers Giz - I'll get back to them.
Where's the enable profile comments?
|
|
|
|
Joined: Jun 2006
Posts: 16,365 Likes: 126
|
Joined: Jun 2006
Posts: 16,365 Likes: 126 |
Good question; I'm not sure... I figured it'd be in "Profile Settings" but it's not lol...
|
|
|
|
Joined: Jun 2006
Posts: 16,365 Likes: 126
|
Joined: Jun 2006
Posts: 16,365 Likes: 126 |
Found it... Master Settings -> Feature Settings -> General -> Enable Profile Comments?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
that's a very inefficient query.. just from an SQL geek's standpoint..
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
that's a very inefficient query.. just from an SQL geek's standpoint.. Don't know where it's coming from - but my error log file is full of these queries. There are hundreds of them in there this morning and it's just 9am.
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
Anyone know if this query used in 7.3?
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
I removed top posters, who's online, and new members from the portal in case that was what was causing the error - but the log file is getting bigger and bigger. Another thing. When I submitted the changes (above) to 'portal layout' - The page hung for several minutes - during which time the forum was not accessible. It does this each time I click on submit.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Driv, can you PM me or open a ticket with both admin info and ftp info to your site?
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
Thanks Rick - PM on its way.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Odd. I can run that query from the SQL command window and it comes back right away. I added an index on the entry id, which made it even quicker.
Debugging the showprofile page and it definitely hangs on that query. Run a show processlist while it's hanging, and it's not showing that query at all.
Definitely getting hangs in other places as well, like you said, even submitting a control panel update. I tried doing one where the only SQL query it does is add to the admin log table and that's hanging as well.
So it doesn't necessarily appear to be that query. It hangs when I try to bring up the database tools like in the control panel as well. Right now it's hanging when I try to even bring up the control panel page.
Do you have anything like phpmyadmin installed?
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
Do you have anything like phpmyadmin installed? phpMyAdmin details sent by pm
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, I don't necessarily think it's just that query. It seems to randomly hang anywhere (some places seem to hang more consistently). While it's hanging I can run queries through phpmyadmin just fine (even then My Buddies query).
Odd thing is, even if it's hanging in one tab. I can open up another and still get some pages to load up, even one that hung before.
I can't think of any changes in 7.5 that would cause this. Like you said, even trying to submit a control panel page (one that only adds to the admin log) might end up hanging.
Normally, if it's a query causing issues, when you look at the processlist, that query will be listed. I'm not seeing it at all, the processlist is normally empty. Catch a query once in a while, but disappears from the list quickly as it should.
Will check a few more things that I can think of.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, definitely looks like going to need to contact your host on this. If I close my browser completely, and then try to go directly to a user profile *sometimes* I can get it to come up. Sometimes it will still hang.
When it's hanging, I've tried added debug code as the very first line to the main ubbthreads.php script, where all it should do is print out "Debugging, back shortly." and then exit. I can't even get that to appear, so it seems like it won't even execute the php script at all when it hangs.
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
ok - what should I be asking/telling my host?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
That's a good question. Normally I can pinpoint it down to something in particular. With this, I really can't. It doesn't really appear to be MySQL as that seems to be running fine even when it hangs. It doesn't seem to be any script in particular. I can click on a link and 2 out of 3 times it might load fine, and the rest it might hang.
SSH access might make it easier since you could actually watch the server processes and see what's going on while it's hanging. Maybe they can look into that.
Are you on a regular shared plan or some type of VPS?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I can't really rule out that it's not something with the MySQL server either. It's possible that when it hangs, it's trying to make the MySQL connection, which would be why it doesn't show up in the processlist.
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
I'm on a regular shared plan and don't have ssh access.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
So, probably going to be at their mercy in how much they want to assist.
A bit more info from my earlier post. If I close my browser and visit a profile direcly by pasting into into my address window sometimes that will come up. It will never come up if I click on it from a link.
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
Yes, I noticed that. Sometimes you can click on a link 2-3 times. It's almost as if you have to 'catch' it, to get it to work. Yet everything was fine until the upgrade
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yeah, I see that things started happening since the upgrade, which is why I've been trying to see if anything was added that might be causing the issue. What I'm seeing however it doesn't look like it. Basically all scripts run through the main ubbthreads.php script. Normally to debug, I'll add something like this: I'll put that into various spots of the ubbthreads.php script to start. I'll move it down a bit at a time, so when I no longer see that line, then I know it's something above that point that's causing an issue. On your site, I can stick that up right at the top after the opening <?php tag and I never see it, so it's like it won't even begin to execute the php script when it hangs.
|
|
|
|
Joined: Jun 2006
Posts: 16,365 Likes: 126
|
Joined: Jun 2006
Posts: 16,365 Likes: 126 |
I wonder if they have some "throttling" script run via PHP that says "Hey, the CPU is this bogged, lets not let anything on the server run for a couple seconds"...
|
|
|
0 members (),
1,502
guests, and
50
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|