List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 12 2012 11:38am
Subject:Re: Aborted clients
View as plain text  
Johan,

"Print out warnings such as Aborted connection... to the error log."
the dots are not telling if they comprise Aborted clients as well.
I find the MySQL error log extremely poor, as far as I know it is one of
the MySQL features (like authentication) stuck to the dawn of MySQL times.
Very hard to debug non basic things like your issue.
From what I have experienced usually Aborted connection  means wrong
credentials while Aborted clients means the client (typically PHP) did not
close the connection properly.
Do you have any chance to check if the code is closing the connections to
the mysql database?

Cheers

Claudio

2012/6/12 Johan De Meersman <vegivamp@stripped>

> Yo,
>
> I'm having trouble with clients aborting, but for some reason they don't
> get logged.
>
> The documentation at http://preview.tinyurl.com/27w9a4x clearly states
> "If a client successfully connects but later disconnects improperly or is
> terminated, the server increments the Aborted_clients status variable, and
> logs an Aborted connection message to the error log."
>
> The log_warnings variable has been set; originally to 1 and later to 2
> because another bit of the doc says " If the value is greater than 1,
> aborted connections are written to the error log."
>
> The error.log I'm looking at is the one that is currently opened by the
> MySQL daemon, as shown by lsof - and does have entries about
> non-replication-safe queries I'd been doing several days ago.
>
> And, yet, I see the Aborted_clients counter increase, but never find any
> entries in the errorlog - which is annoying, because now I don't even know
> which application is misbehaving.
>
> This is MySQL 5.1.50-community-log on Suse 11.1 64-bit.
>
> Does anyone have an idea why the aborted clients don't get logged, and how
> to fix it?
>
> thx,
> Johan
>
> --
>
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>



-- 
Claudio

Thread
Aborted clientsJohan De Meersman12 Jun
  • Re: Aborted clientsClaudio Nanni12 Jun
    • Re: Aborted clientsAnanda Kumar12 Jun
      • Re: Aborted clientsAnanda Kumar12 Jun
        • Re: Aborted clientsJohan De Meersman12 Jun
    • Re: Aborted clientsJohan De Meersman12 Jun
      • Re: Aborted clientsHoward Hart12 Jun
        • Re: Aborted clientsClaudio Nanni12 Jun
          • Re: Aborted clientsJohan De Meersman13 Jun
            • Re: Aborted clientsClaudio Nanni13 Jun
              • Re: Aborted clientsAnanda Kumar13 Jun
              • Re: Aborted clientsJohan De Meersman13 Jun