Anybody else having problems on mysql06?

[icook]

I have been updating a phpesp survey quite happily for a couple of days now.

This morning it now comes up with the following message all the time..
Warning: Unknown(): open(/www/php/1/3/5/sess_135a6baf6c66331ee51452f8d425b4ae, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (3;/www/php) in Unknown on line 0

As this is kind of new to me, I am curious if it is the mysql file, or the phpesp script..

Ian

[mitchind]

As you suspected, that error message has nothing to do with mysql06.

It's failing trying to open/save a session file.

These are saved in a global directory for which you have no control over.

If your up to it, I'd recommend creating your own sessions directory (at your root level), modifying the path in your php.ini to /www/u/username/sessions, and then adding a cron job to clean it out every 24 hours.

You'd have much more control over how many files are under your ownership - and better security - but it's a bit of work to setup.

[icook]

Thanks for the tip!
Next dumb qestion. Can you point me in the direction in how to clean up a session.

Thanks in advance

[alphadesk]

Read this whole thread ... sessions are addressed, but it has other good info you may need in the future.

http://forum.powweb.com/showthread.php?t=30966

[icook]

Fantastic! I followed the link, ran the php script, and that fixed.
I definately bookmarking that valuable thread!!

Ian :) :) :)

[riskynil]

Gosh, you got my hopes up that SOMEONE other than me is suffering on mysql06.

It seems like the last week or so I've been getting an unusual number of "Too many connections" errors. About 50 of them in the past half hour. Is it really just me with this problem on this server?

I keep writing the problem off as "out of my control", but shoot, this is really, really annoying me and I want to do something about it. Besides move the site to another hosting service, of course, since that would just be a pain.

-- Ryan

[pk698]

I'm on mysql06 and I'm having a lot of problems connecting to my site.

[mitchind]

I'm on mysql06 and I'm having a lot of problems connecting to my site.

I thought you were on mysql03? That's where you replied to the "too many connections" error. Or are you getting a "too many connections" error on mysql06 on another site?

I'm very interested in this one - as I have been on mysql06 for a while now and have only had that message once - at 8:20am one day this week.

[pk698]

I'm on mysql06. if I mentioned 03, then I made a mistake. And I just came back from class and checked my site...59sec to load :/

[mitchind]

Do you have same slow results using phpMyAdmin to view your database?

Might be the cluster - try tracert your website and see what cluster comes back. It might also show if there's a problem along the way with your ISP

[pk698]

"traceroute 'beaverchat.com':
Note: this may take up to a minute.

Unknown host beaverchat.com"

[pk698]

"ping error (unknown host, etc.)"

Name: cluster04.powweb.com
Address: 66.152.98.204

[riskynil]

Do you have same slow results using phpMyAdmin to view your database?
Might be the cluster - try tracert your website and see what cluster comes back. It might also show if there's a problem along the way with your ISP


Yes, phpMyAdmin runs slowly when I view my database.

Hmm.... How about that. I didn't even know about tracert. =) I'm not sure what it means or what to look for, but I just ran it on my system and this is what came back:



Tracing route to atlasquest.com [66.152.98.202]
over a maximum of 30 hops:

1 1297 ms 1485 ms 1437 ms 165.238.140.27
2 1484 ms 1453 ms 1484 ms 165.238.140.17
3 1485 ms 1453 ms 1484 ms 12.122.253.233
4 1281 ms 1469 ms 1484 ms gbr1-p60.st6wa.ip.att.net [12.123.44.114]
5 1469 ms 1500 ms 1468 ms tbr1-p012501.st6wa.ip.att.net [12.122.12.157]
6 1500 ms 1469 ms 1500 ms tbr2-cl1.sffca.ip.att.net [12.122.12.113]
7 1469 ms 1469 ms * ggr1-p370.sffca.ip.att.net [12.123.13.69]
8 2453 ms 1469 ms 1172 ms 64.200.151.17
9 1140 ms 1485 ms 1468 ms sntcca1wcx1-pos2-1.wcg.net [64.200.149.45]
10 1469 ms 1453 ms 1453 ms anhmca1wcx3-pos3-0-oc192.wcg.net [64.200.240.109]
11 1485 ms 1469 ms 1468 ms lsancaclce1-pos4-0.wcg.net [64.200.141.42]
12 * * * Request timed out.
13 1516 ms 1500 ms 1406 ms www.atlasquest.com [66.152.98.202]

Trace complete.

What's the "Request timed out" deal about? Are these otherwise normal results that are to be expected?

-- Ryan

[mitchind]

That looks like a slow ISP problem (a very uneducated guess from a person very unknowledgeable in the world of networks)

What kind of a connection do you have? With ADSL from Canada mine looks like:

Tracing route to atlasquest.com [66.152.98.202]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 192.168.0.1
2 28 ms 27 ms 27 ms 10.134.128.1
3 27 ms 27 ms 26 ms clgrab01dr00.bb.telus.com [154.11.95.58]
4 26 ms 27 ms 27 ms CLGRAB31GR01.bb.telus.com [205.233.111.87]
5 62 ms 62 ms 62 ms clgrab31br01.bb.telus.com [154.11.10.169]
6 62 ms 62 ms 62 ms CLGRAB21BR01.bb.telus.com [204.225.243.66]
7 62 ms 61 ms 62 ms WNPGMB38BR00.bb.telus.com [204.225.243.78]
8 61 ms 61 ms 61 ms WNPGMBABBR00.bb.telus.com [204.225.243.157]
9 * * * Request timed out.
10 61 ms 61 ms 60 ms chcgildtgr00.bb.telus.com [154.11.11.18]
11 61 ms 61 ms 61 ms Williams.chcgildtgr00.bb.telus.com [154.11.3.178
]
12 61 ms 61 ms 61 ms brvwil1wcx3-pos1-1-oc48.wcg.net [64.200.236.101]

13 82 ms 83 ms 82 ms dnvrco1wcx3-pos13-0-oc192.wcg.net [64.200.240.12
1]
14 83 ms 82 ms 82 ms dnvrco1wcx2-pos3-0-oc192.wcg.net [64.200.106.37]

15 94 ms 94 ms 94 ms anhmca1wcx3-pos12-0-oc192.wcg.net [64.200.240.24
9]
16 93 ms 93 ms 93 ms lsancaclce1-pos4-0.wcg.net [64.200.141.42]
17 93 ms 94 ms 93 ms lsancaclce1-powweb-gige.wcg.net [64.200.200.98]

18 93 ms 93 ms 94 ms cluster02.powweb.com [66.152.98.202]

Trace complete.

[jschein]

1400ms ping time is more like a dial-up account than a high speed account.

Normal high-speed traffic speeds are anywhere from 20ms - 140ms.

On your own internal networks, they should be <10ms.

[riskynil]

1400ms ping time is more like a dial-up account than a high speed account.

Yep, I'm on a dial-up account. Guilty as charged. =) Does that mean everything looks good from my end of things?

-- Ryan

[jschein]

Yes, that means everything is well on your end. However I have utilized phpmyadmin on high speed lines and still takes 20+ seconds to transition through pages. So i know you must be having more than likely a slower response time than that.

[riskynil]

However I have utilized phpmyadmin on high speed lines and still takes 20+ seconds to transition through pages. So i know you must be having more than likely a slower response time than that.

Yeah, the phpmyadmin runs slower than a three-toed sloth. I attribute the slowness to it, at least partially, due to those pages being secure. Secure pages always tend to load slower than non-secure pages. Used to run a lot faster when the pages were not secure, but I'm not going to complain about things being more secure either. *shrug*

-- Ryan

[pk698]

Tracing route to beaverchat.com [66.152.98.204]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 10.0.0.1
2 * * * Request timed out.
3 10 ms 25 ms 23 ms 68.87.219.109
4 22 ms 17 ms 16 ms 68.87.216.58
5 23 ms 21 ms 14 ms 68.87.216.5
6 27 ms 24 ms 30 ms 12.244.72.38
7 24 ms 19 ms 31 ms gbr1-p80.st6wa.ip.att.net [12.123.203.182]
8 29 ms 21 ms 38 ms tbr1-p012501.st6wa.ip.att.net [12.122.12.157]
9 48 ms 44 ms 51 ms tbr2-cl1.sffca.ip.att.net [12.122.12.113]
10 56 ms 43 ms 42 ms ggr1-p3100.sffca.ip.att.net [12.122.11.230]
11 42 ms 54 ms 86 ms 64.200.151.17
12 51 ms 49 ms 43 ms sntcca1wcx1-pos5-0.wcg.net [64.200.240.129]
13 46 ms 86 ms 69 ms anhmca1wcx3-pos3-0-oc192.wcg.net [64.200.240.109
]
14 58 ms 102 ms 46 ms lsancaclce1-pos4-0.wcg.net [64.200.141.42]
15 * * * Request timed out.
16 55 ms 78 ms 56 ms cluster04.powweb.com [66.152.98.204]

Trace complete.

Why am I getting time outs? My page does NOT load for me. I don't know what's going on. about 2 hours ago, my forum stats were reset to "0". I had 0 members, 0 posts. I highly doubt that I this is my fault as I have NOT gotten into my acp, or touched PHPmyadmin at all.

Can a staff please explain why I, or other users, are having so much problems??? why is powweb not updating its customers of the problems that is plaguing some of the customers here?

[dave_childress]

OK having a bit of a problem, and it's gotten quite serious

Could not query forums information

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_posts.MYI' (errno: 145)

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

and then I fixed it by running this in phpMyAdmin

Code:
REPAIR TABLE phpbb_posts;


But now it keeps coming back every 10-20 minutes.

I'm not sure if I am triggering it off or whats hapenning.

Any help would be appreciated.