Issues with MySQL connectivity ... on only one machine, and for a

Oct 25 22:00:01 sql02 php: PHP Warning: mysqli_connect():
(HY000/2013): Lost connection to MySQL server at 'sending
authentication information', system error: 32 in
/home/foo/web/foo.com/core.php on line 2394

It's either this or one or two others. What is odd is I have switched
to making it sockets only - doesn't seem to help. I think it was
anyway, it's all over localhost. It wasn't always like this either.

Can't seem to find any reason for it. Scripts are able to connect at
near lightning speed, do 20+ queries a page load and disconnect
without an issue before it even shows up in a "show processlist" but
I'm seeing issues with disconnections on localhost.

I wanted to upgrade to PHP 5.3.x to use the mysqli.reconnect option,
but I don't think the code will work 100% - does anyone else have any
ideas? I have a second server, same specs, being beaten (not as hard,
but decently) that exhibits none of these behaviors.

mysql 5.0.75 on ubuntu jaunty 64-bit
php 5.2.11 (but has been showing this issue since 5.2.9 if not
earlier, I didn't start tracking it then)

I don't understand why it would be having issues during the
authentication phase especially over localhost or socket!?! I think
this might be more of a question for the PHP community than the MySQL
one; I've tried some additional MySQL tuning and it doesn't seem to
help, and the error comes from PHP, I can't reproduce it any other
way.

Any ideas?

Thanks!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Issues with MySQL connectivity ... on only one machine,and for a while now

Michael Shadle wrote on 2009-10-26 06:48:
> Oct 25 22:00:01 sql02 php: PHP Warning: mysqli_connect():
> (HY000/2013): Lost connection to MySQL server at 'sending
> authentication information', system error: 32 in
> /home/foo/web/foo.com/core.php on line 2394
>
> It's either this or one or two others. What is odd is I have switched
> to making it sockets only - doesn't seem to help. I think it was
> anyway, it's all over localhost. It wasn't always like this either.

I think it's related to network flaws, at least that was the
understanding I had from the same problem, which occured some months ago
at an ISP i'm using, but you're writing "all over localhost"?

--
Kind regards
Kim Emax - masterminds.dk

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Issues with MySQL connectivity ... on only one machine, and

Yep the only connectivity issues are coming from the server itself.

I have 3 webservers talking to this server and never get a failed read
- the batch jobs running on the server itself have issues once in a
while. I even FORCED sockets just in case it was using TCP via
localhost...


On Mon, Oct 26, 2009 at 12:24 AM, Kim Madsen wrote:
> Michael Shadle wrote on 2009-10-26 06:48:
>>
>> Oct 25 22:00:01 sql02 php: PHP Warning:  mysqli_connect():
>> (HY000/2013): Lost connection to MySQL server at 'sending
>> authentication information', system error: 32 in
>> /home/foo/web/foo.com/core.php on line 2394
>>
>> It's either this or one or two others. What is odd is I have switched
>> to making it sockets only - doesn't seem to help. I think it was
>> anyway, it's all over localhost. It wasn't always like this either.
>
> I think it's related to network flaws, at least that was the understandin=
g I
> had from the same problem, which occured some months ago at an ISP i'm
> using, but you're writing "all over localhost"?
>
> --
> Kind regards
> Kim Emax - masterminds.dk
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Issues with MySQL connectivity ... on only one machine,and for a while now

Michael Shadle wrote:
> Oct 25 22:00:01 sql02 php: PHP Warning: mysqli_connect():
> (HY000/2013): Lost connection to MySQL server at 'sending
> authentication information', system error: 32 in
> /home/foo/web/foo.com/core.php on line 2394
>
> mysql 5.0.75 on ubuntu jaunty 64-bit
> php 5.2.11 (but has been showing this issue since 5.2.9 if not
> earlier, I didn't start tracking it then)


Is this a VPS (virtual private server)?
Reason I am asking is because some VPS implementations only give you RAM
but no SWAP space. So once all RAM is consumed processes will get aborted.

--
John
Klarmachen zum Ändern!
Piratenpartei Deutschland
http://www.youtube.com/v/-u3IUno5A-M

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Issues with MySQL connectivity ... on only one machine, and

nope. it's a quad core with 4 gig ram

[root@sql02 ~]# free -m
total used free shared buffers cached
Mem: 3905 3774 130 0 170 941
-/+ buffers/cache: 2662 1243
Swap: 3906 20 3886
[root@sql02 ~]#

i do have collectd installed and am waiting for it to happen some more
to see if i can correlate it with any specific event

On Mon, Oct 26, 2009 at 5:53 AM, John Black
wrote:
> Michael Shadle wrote:
>>
>> Oct 25 22:00:01 sql02 php: PHP Warning:  mysqli_connect():
>> (HY000/2013): Lost connection to MySQL server at 'sending
>> authentication information', system error: 32 in
>> /home/foo/web/foo.com/core.php on line 2394
>>
>> mysql 5.0.75 on ubuntu jaunty 64-bit
>> php 5.2.11 (but has been showing this issue since 5.2.9 if not
>> earlier, I didn't start tracking it then)
>
>
> Is this a VPS (virtual private server)?
> Reason I am asking is because some VPS implementations only give you RAM =
but
> no SWAP space. So once all RAM is consumed processes will get aborted.
>
> --
> John
> Klarmachen zum Ändern!
>   Piratenpartei Deutschland
> http://www.youtube.com/v/-u3IUno5A-M
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php