List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:September 10 2011 4:57pm
Subject:Re: MySQL daemons restarting every 7 minutes
View as plain text  
Am 10.09.2011 18:52, schrieb a.smith@stripped:
> Quoting walter harms <wharms@stripped>:
>
>> restart it with the same parameter on the command line and see what happens
>> the server support a verbos option (never used) perhaps it will tell you more.
>>
>
> I can start mysqld direct from the command line and reproduce the problem. I checked
> and it seems the verbose
> option only works in conjunction with --help.
>
> Playing around with a couple of tools that are installed on FreeBSD, I ran via truss
> and ktrace to see if there
> was anything obvious before the process dies but not really. In ktrace you can see
> that it gets as far as
> deciding that the remote connection should not be allowed then rapidly just dies:
>
>
>  78353 echo     GIO   fd 1 wrote 44 bytes
>        "You are not welcome to use mysqld from tau.
>        "
>  78353 echo     RET   writev 44/0x2c
>  78353 echo     CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffffffebd0)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffffffeb80)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  exit(0)
>
>
> Interesting also to see it exits with status 0 :S. What would be the best tool to
> debug this further?

"You are not welcome to use mysqld from tau" is NOT from mysqld
remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
if the problem goes away make a bugreport on BSD side becahuse this is NOT a mysqld issue



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
MySQL daemons restarting every 7 minutesa.smith7 Sep
  • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
    • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
      • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
        • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
          • Re: MySQL daemons restarting every 7 minutesReindl Harald9 Sep
            • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
              • Re: MySQL daemons restarting every 7 minutesSuresh Kuna10 Sep
                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                  • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                      • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                        • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                          • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep