Re: aborted connections wierdness...

On Mon, 28 Apr 2008 14:51:24 -0400, Patrick Galbraith
wrote:
> Hi all,
>
> I've configured many a server in my life, but have this odd issue lately:
>
> 080428 14:45:47 [Warning] Aborted connection 3185826 to db: 'xxxx' user:
> 'xxxxx' host: 'dbserverxxx' (Got an error reading communication packets)
>

Have you tried doing a packet trace to see exactly what is going on at the
network level?

-r


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

aborted connections wierdness...

Hi all,

I've configured many a server in my life, but have this odd issue lately:

080428 14:45:47 [Warning] Aborted connection 3185826 to db: 'xxxx' user:
'xxxxx' host: 'dbserverxxx' (Got an error reading communication packets)

This is pretty much stock mod_perl setup, even using Apache::DBI.

I still have two boxes giving me this problem, whereas I have been able
to get rid of this message on my other servers by changing my usage of
"connect_cached" to just "connect" (Apache::DBI should give me
connection caching). Problem went away on those servers just by doing
that, but remains on the other two, despite the switch.

What other settings, factors might contribute to this?

Thanks in advance to thoughts/opinions.

regards,

Patrick

--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: aborted connections wierdness...

Rudolf Lippan wrote:

>On Mon, 28 Apr 2008 14:51:24 -0400, Patrick Galbraith
>wrote:
>
>
>>Hi all,
>>
>>I've configured many a server in my life, but have this odd issue lately:
>>
>>080428 14:45:47 [Warning] Aborted connection 3185826 to db: 'xxxx' user:
>>'xxxxx' host: 'dbserverxxx' (Got an error reading communication packets)
>>
>>
>>
>
>Have you tried doing a packet trace to see exactly what is going on at the
>network level?
>
>

Not yet - I haven't messed around with tcp dump much, but maybe now is
the time to start. What would I be looking at?

>-r
>
>
>
>


--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: aborted connections wierdness...

Sounds like Apache::DBI sets max_allowed_packet,
or mysql protocol version explicitely,
while other clients do not.

Chances are mysql-client upgrade may help,
or some SHOW for variables?..

Regards,
--Vladimir

Patrick Galbraith wrote:
> Hi all,
>
> I've configured many a server in my life, but have this odd issue lately:
>
> 080428 14:45:47 [Warning] Aborted connection 3185826 to db: 'xxxx' user:
> 'xxxxx' host: 'dbserverxxx' (Got an error reading communication packets)
>
> This is pretty much stock mod_perl setup, even using Apache::DBI.
>
> I still have two boxes giving me this problem, whereas I have been able
> to get rid of this message on my other servers by changing my usage of
> "connect_cached" to just "connect" (Apache::DBI should give me
> connection caching). Problem went away on those servers just by doing
> that, but remains on the other two, despite the switch.
>
> What other settings, factors might contribute to this?
>
> Thanks in advance to thoughts/opinions.
>
> regards,
>
> Patrick
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org