Just as an FYI: I have updated the ticket letting you know they are still getting intermittent mySQL3 timeouts from different web apps on different domains.
They had 6 that they knew of yesterday.
They are running out of patience so I need anyone who can help to jump in here.
I really think there is a real issue as it would be hard to believe this would happen on multiple domains and multiple web apps and not be a problem.
The only common thread is everything is running on WIN11 and mySQL3.
I thought perhaps the error may be erroneous and maybe there is a WIN11 problem that results in that error, but it doesn’t make much sense.
Guys, I am being as patient as possible, but this problem has existed and been reported to Jodo since October the 8th on ticket YZU-77300-601 and here.
I realize you guys were pretty swamped with all the email issues and spam, but I need to get some support on this mySQL timeout issues that have been taking place.
Stephen, Yash, Tanmaya, Atul… I need someone to respond to the issues we are having hear. I don’t care if it is communicated here or in the ticket YZU-77300-601. At the moment it appears that my requests are being ignored as of late.
I haven’t had a response since the 17th and that was just to say things are being examined. Before that the last response was on the 10th.
Is this an acceptable response time… I would have to say NO.
It’s been quite a while since I got the errors, but it happened just now:
[FONT=“Courier New”]Could not connect to the database
PHP Warning: mysql_connect(): Can’t connect to MySQL server on ‘mysql3.servicedomain.info’ (10060) in E:\hshome\username\domain.com\forums\db\mysql4.php on line 48
PHP Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in E:\hshome\username\domain.com\forums\db\mysql4.php on line 330
PHP Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in E:\hshome\username\domain.com\forums\db\mysql4.php on line 331[/FONT]
This may happen if application takes more than 10 seconds to complete initial connection request to MySQL. Any possibility of this? Like DNS resolution delay may also be one thing possible.
Just adding my 2 cents, one of my clients is getting this as well. It’s on his WordPress blog. Connecting to mysql4. Same error can’t connect to database. I’ve been trying to figure it out myself and with live help but to no avail. I’m a Windows reseller as well.
uhh, gsaunders, I may have just found the issue on your client, it has over 300 php processes going right now, killing the DB server with connections, and maxing the user limit.
I killed them and 50 were back within 20 seconds…still working on this one.
Edit:
All of this within 10 seconds, they are spawning fast:
pskill.exe php
PsKill v1.11 - Terminates processes on local or remote systems
Copyright (C) 1999-2005 Mark Russinovich
Sysinternals - www.sysinternals.com
20 processes named php killed.
pskill.exe php
PsKill v1.11 - Terminates processes on local or remote systems
Copyright (C) 1999-2005 Mark Russinovich
Sysinternals - www.sysinternals.com
45 processes named php killed.
pskill.exe php
PsKill v1.11 - Terminates processes on local or remote systems
Copyright (C) 1999-2005 Mark Russinovich
Sysinternals - www.sysinternals.com
gsaunders have seen things better on a Linux. But since you have asp apps as well, we need to figure a different workroud here. I’ve asked Stephen about changes suggested on MySQL’s website as pointed by you. We can continue in your other thread on this issue.
