Re: MySQL daemons restarting every 7 minutes
This was me restarting MySQL as was requested by Suresh... Quoting Singer X.J. Wang w...@singerwang.com: This doesn't look like a MySQL issue. Verify that there's no rogue scripts that shutdowns MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
i bet if he stops crond the problem is going away anyways i have enough of this thread after the part for the shutdown because if peopole are way too stupid to provide full logs (normally in the first post) even after requested multiple times they should learn their lessons the hard way... Am 10.09.2011 06:33, schrieb Singer X.J. Wang:This doesn't look like a MySQL issue. Verify that there's no rogue scripts that shutdowns MySQL... On Fri, Sep 9, 2011 at 13:07, a.sm...@ukgrid.net mailto:a.sm...@ukgrid.net wrote: No need for that really is there? I posted what was requested. The part for the shutdown: 110909 17:27:31 InnoDB: Starting shutdown... 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 110909 17:27:32 mysqld_safe mysqld from pid file /var/db/mysql/tau.pid ended 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G 110909 17:27:36 InnoDB: Completed initialization of buffer pool 110909 17:27:36 InnoDB: highest supported file format is Barracuda. 110909 17:27:36 InnoDB: Waiting for the background threads to start 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002830' at position 293541, relay log './tau-relay-bin.000920' position: 253 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave_user@kappa:3306',replication started in log 'mysql-bin.002830' at position 293541 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=w...@singerwang.com signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
Ok, this is pretty odd but I have found the problem. Today I have repointed all applications to a different DB server, so I have been free to do any testing on the problem server. I started by dropping the databases one by one, dropped em all and the issue persisted. I stopped crond, even tho Id already looked in crontab and was satisfied it wasn't the culprit. Problem persisted. I then removed the mysql data dir, and my.cnf and restarted with a blank config. Problem still persisted. Turned on the general log, nothing happening (as nothing legit was still pointing to the DB on this server). Problem persisted. Then I thought, what if I have hosts.allow misconfigured and its wide open maybe a remote system is connecting and messing with it. But hosts.allow was correct (mysql not listed, so denied by the last all:all). I tested connecting from a remote server, guess what? Mysql daemons restarted in exactly the way I was seeing each 7 mins, each time just by simply running: mysql -h tau Odd that, so I added a mysql specific line to the hosts.allow (which is not necessary as all services are blocked on the last line anyway). Tested that, no no more crashing. Odd! The hosts.allow file is the stock FreeBSD updated to not allow all:all and to use denyhosts (ssh blocked). Additional info, using tcpdump I could see that the every 7 min crashes were not in fact caused by any connections from other hosts, MySQL was crashing regardless. Still don't know why this would suddenly appear as an issue, or why I don't see this issue on other identically configured servers... :S thanks Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net: Ok, this is pretty odd but I have found the problem. Today I have repointed all applications to a different DB server, so I have been free to do any testing on the problem server. I started by dropping the databases one by one, dropped em all and the issue persisted. I stopped crond, even tho Id already looked in crontab and was satisfied it wasn't the culprit. Problem persisted. I then removed the mysql data dir, and my.cnf and restarted with a blank config. Problem still persisted. Turned on the general log, nothing happening (as nothing legit was still pointing to the DB on this server). Problem persisted. Then I thought, what if I have hosts.allow misconfigured and its wide open maybe a remote system is connecting and messing with it. But hosts.allow was correct (mysql not listed, so denied by the last all:all). I tested connecting from a remote server, guess what? Mysql daemons restarted in exactly the way I was seeing each 7 mins, each time just by simply running: mysql -h tau Odd that, so I added a mysql specific line to the hosts.allow (which is not necessary as all services are blocked on the last line anyway). Tested that, no no more crashing. Odd! The hosts.allow file is the stock FreeBSD updated to not allow all:all and to use denyhosts (ssh blocked). Additional info, using tcpdump I could see that the every 7 min crashes were not in fact caused by any connections from other hosts, MySQL was crashing regardless. What i found odd that your mysqld actualy restarts. Do you have it in some runlevel ? if yes stop and see what happens. If this does not work simple move the mysqld out of he way and replace it with a script like #!/bin/sh echo mysqld ... | logger -t TEST see what happens in /var/log/syslog (you get the idea). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Quoting walter harms wha...@bfs.de: What i found odd that your mysqld actualy restarts. Do you have it in some runlevel ? if yes stop and see what happens. If this does not work simple move the mysqld out of he way and replace it with a script like #!/bin/sh echo mysqld ... | logger -t TEST see what happens in /var/log/syslog (you get the idea). Hi, its FreeBSD so no run levels other than single user and up/multi user. And FreeBSD has no Solaris like SMF like monitoring of daemons so I can be fairly certain that the RC script is not being called by anything. I do use PSMON but this will advise me if its taken action, and Ive tested with PSMON stopped also. As I said I can get it to restart just by doing a remote connect from another server... Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net: Then I thought, what if I have hosts.allow misconfigured and its wide open maybe a remote system is connecting and messing with it. But hosts.allow was correct (mysql not listed, so denied by the last all:all). I tested connecting from a remote server, guess what? Mysql daemons restarted in exactly the way I was seeing each 7 mins, each time just by simply running: mysql -h tau Odd that, so I added a mysql specific line to the hosts.allow who is using hosts.allow for protection instead a firewall in front of the machine or iptables (linux) / ipf (bsd)? As I said I can get it to restart just by doing a remote connect from another server... reproduceable or was it a lucky hit once? if mysqld crashs ypu see normally something in the mysqld-error-log or in the syslog of the machine, until now ypu provided no silngle line about a crash from any log signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net: Quoting walter harms wha...@bfs.de: What i found odd that your mysqld actualy restarts. Do you have it in some runlevel ? if yes stop and see what happens. If this does not work simple move the mysqld out of he way and replace it with a script like #!/bin/sh echo mysqld ... | logger -t TEST see what happens in /var/log/syslog (you get the idea). Hi, its FreeBSD so no run levels other than single user and up/multi user. And FreeBSD has no Solaris like SMF like monitoring of daemons so I can be fairly certain that the RC script is not being called by anything. I do use PSMON but this will advise me if its taken action, and Ive tested with PSMON stopped also. As I said I can get it to restart just by doing a remote connect from another server... Sorry, I am a late starter in the thread ... What i would like to understand is: is it a propper shutdown ? (So far i understand yes, so the idea of a starter script) Does it concern target mysqld only ? (therefore the script) Since my first idea was that something was calling the starter script we will modify the dummy a bit. #!/bin/sh while true do echo mysqld ... | logger -t TEST sleep 1m done This will make sure that you see a msg every minute. If you trigger something it will try to kill the script. I still do not see why it is restarting ... there must be something watching is disappear. Just to be sure, you do from a remote host: mysql -hHOST -ume -e show tables ? long shot: Do you have LDAP, NIS or so enabled ? re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Quoting Reindl Harald h.rei...@thelounge.net: Odd that, so I added a mysql specific line to the hosts.allow who is using hosts.allow for protection instead a firewall in front of the machine or iptables (linux) / ipf (bsd)? Its used for denyhosts as I mentioned. As I said I can get it to restart just by doing a remote connect from another server... reproduceable or was it a lucky hit once? if mysqld crashs ypu see normally something in the mysqld-error-log or in the syslog of the machine, until now ypu provided no silngle line about a crash from any log Yes its reproduceable as I mentioned. I have provided all info from the mysqld-error-log already, I haven't provided anything from syslog as there is nothing there, as I mentioned. If you don't believe me I can't provide it to you... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Quoting walter harms wha...@bfs.de: I still do not see why it is restarting ... there must be something watching is disappear. Just to be sure, you do from a remote host: mysql -hHOST -ume -e show tables ? long shot: Do you have LDAP, NIS or so enabled ? Ok so made a script as you suggested, and it is called from mysqld_safe. So that is what is restarting mysqld. With regard to is it doing a proper shutdown, no it isn't. It restarts instantly when triggered by a remote connection, and for example I see no InnoDB: Starting shutdown... info logged by mysqld. I'm not using LDAP or NIS. Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net: Quoting walter harms wha...@bfs.de: I still do not see why it is restarting ... there must be something watching is disappear. Just to be sure, you do from a remote host: mysql -hHOST -ume -e show tables ? long shot: Do you have LDAP, NIS or so enabled ? Ok so made a script as you suggested, and it is called from mysqld_safe. So that is what is restarting mysqld. when can establish that here is no interference from outside we need to reduce more since you are running mysqld_safe - that is nice - can you see the parameters who mysqld is started ? 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. With regard to is it doing a proper shutdown, no it isn't. It restarts instantly when triggered by a remote connection, and for example I see no InnoDB: Starting shutdown... info logged by mysqld. I'm not using LDAP or NIS. So it must be a local problem (at least it has nothing todo with auth) re, wh Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Quoting walter harms wha...@bfs.de: 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,0x7fffebd0) 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,0x7fffeb80) 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? thanks Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 18:52, schrieb a.sm...@ukgrid.net: Quoting walter harms wha...@bfs.de: 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,0x7fffebd0) 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,0x7fffeb80) 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 signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
Quoting Reindl Harald h.rei...@thelounge.net: 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 I've already established that the issue is MySQL in conjuration with certain config in hosts.allow. I have also resolve my problem. I only continue looking at this for curiosity, because Walter asked me to do some other test and to do my part for MySQL and the community. Also given MySQL supports tcp wrappers, it should work or that code should be remove from MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 19:02, schrieb a.sm...@ukgrid.net: Quoting Reindl Harald h.rei...@thelounge.net: 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 I've already established that the issue is MySQL in conjuration with certain config in hosts.allow. I have also resolve my problem. I only continue looking at this for curiosity, because Walter asked me to do some other test and to do my part for MySQL and the community. Also given MySQL supports tcp wrappers, it should work or that code should be remove from MySQL... REMOVE IT to see if this is the problem should be remove from MySQL is another question and depends on where the error is triggered, if it is the tcp-wrapper from BSD and not happening on another OS there has to be notihing removed from mysql because it is on BSD side remove and disable all crap around mysqld (tcp-wrappers, crond, watchdogs...) to locate the poblem and if mysqld runs normal after that enable one after one to look what exactly is triggering the problem - this is the way debugging works since computers exists signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
Hi Walter/all, ok nailed it, the issue is the default hosts.allow installed on FreeBSD, and specifically the last section that denies everything. By default it looks like this: # The rest of the daemons are protected. ALL : ALL \ : severity auth.info \ : twist /bin/echo You are not welcome to use %d from %h. The twist command breaks it. In theory this is just meant to send a custom message back to the application calling the tcp wrapper library. I'm not sure if this should work in theory or not, but the twist command is also meant to close the connection so possibly the behaviour I see is normal and just not compatible with MySQL. Anyway, its not a great default for FreeBSD given that MySQL also installs by default with support for tcp wrappers. The two together results in a broken configuration. thanks Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
Am 10.09.2011 19:21, schrieb a.sm...@ukgrid.net: Hi Walter/all, ok nailed it, the issue is the default hosts.allow installed on FreeBSD, and specifically the last section that denies everything. By default it looks like this: # The rest of the daemons are protected. ALL : ALL \ : severity auth.info \ : twist /bin/echo You are not welcome to use %d from %h. The twist command breaks it. In theory this is just meant to send a custom message back to the application calling the tcp wrapper library. I'm not sure if this should work in theory or not, but the twist command is also meant to close the connection so possibly the behaviour I see is normal and just not compatible with MySQL. Anyway, its not a great default for FreeBSD given that MySQL also installs by default with support for tcp wrappers. The two together results in a broken configuration. well, and that is why i said nobody is using hosts.allow in real life if you want to protect anything use packet-filters i have seen so many peopole typing something in hosts.allow and not realizing that the service is not using tcp-wrappers which means there is no protection - additionaly most peopole doe snot test their configurations really well the point of not testing configurations affects you too because if you would have tested this the issue would have been happened after the first connection long before go in production signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier from a troubleshooting perspective)... The system has loads of free RAM (8GB total). Really the system isn't giving me much to go in in terms of clues Andy. Quoting Suresh Kuna sureshkumar...@gmail.com: Can yo paste the complete error log, Ram memory size and configuration file here and make sure the machine has enough memory to run the services. Check the sys log for what is happening just before the service restart. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
can you remove it from service and start it normally using mysqld_safe with log warnings enabled in the cnf file. On Fri, Sep 9, 2011 at 4:16 PM, a.sm...@ukgrid.net wrote: Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier from a troubleshooting perspective)... The system has loads of free RAM (8GB total). Really the system isn't giving me much to go in in terms of clues Andy. Quoting Suresh Kuna sureshkumar...@gmail.com: Can yo paste the complete error log, Ram memory size and configuration file here and make sure the machine has enough memory to run the services. Check the sys log for what is happening just before the service restart. -- Thanks Suresh Kuna MySQL DBA
Re: MySQL daemons restarting every 7 minutes
Yep, but its basically identical to the info in the logs when its restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so the error info differs due to the version now. Here is the log output: 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G 110909 17:27:36 InnoDB: Completed initialization of buffer pool 110909 17:27:36 InnoDB: highest supported file format is Barracuda. 110909 17:27:36 InnoDB: Waiting for the background threads to start 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002830' at position 293541, relay log './tau-relay-bin.000920' position: 253 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave@kappa:3306',replication started in log 'mysql-bin.002830' at position 293541 Just not giving any hit of a problem thanks Andy. Quoting Suresh Kuna sureshkumar...@gmail.com: can you remove it from service and start it normally using mysqld_safe with log warnings enabled in the cnf file. On Fri, Sep 9, 2011 at 4:16 PM, a.sm...@ukgrid.net wrote: Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier from a troubleshooting perspective)... The system has loads of free RAM (8GB total). Really the system isn't giving me much to go in in terms of clues Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
jesus christ can you post a WHOLE log this is only a normal start, there is no single line about stop Am 09.09.2011 18:30, schrieb a.sm...@ukgrid.net: Yep, but its basically identical to the info in the logs when its restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so the error info differs due to the version now. Here is the log output: 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G 110909 17:27:36 InnoDB: Completed initialization of buffer pool 110909 17:27:36 InnoDB: highest supported file format is Barracuda. 110909 17:27:36 InnoDB: Waiting for the background threads to start 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002830' at position 293541, relay log './tau-relay-bin.000920' position: 253 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave@kappa:3306',replication started in log 'mysql-bin.002830' at position 293541 Just not giving any hit of a problem thanks Andy. Quoting Suresh Kuna sureshkumar...@gmail.com: can you remove it from service and start it normally using mysqld_safe with log warnings enabled in the cnf file. On Fri, Sep 9, 2011 at 4:16 PM, a.sm...@ukgrid.net wrote: Hi, that really is the complete error log, that exact same info gets repeated over and over, there is zero in the syslog and I get this behaviour when running with no my.cnf (I do obviously have one but I tried without and it I still see the prob, so that probably makes things easier from a troubleshooting perspective)... The system has loads of free RAM (8GB total). Really the system isn't giving me much to go in in terms of clues Andy. -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: MySQL daemons restarting every 7 minutes
No need for that really is there? I posted what was requested. The part for the shutdown: 110909 17:27:31 InnoDB: Starting shutdown... 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 110909 17:27:32 mysqld_safe mysqld from pid file /var/db/mysql/tau.pid ended 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G 110909 17:27:36 InnoDB: Completed initialization of buffer pool 110909 17:27:36 InnoDB: highest supported file format is Barracuda. 110909 17:27:36 InnoDB: Waiting for the background threads to start 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002830' at position 293541, relay log './tau-relay-bin.000920' position: 253 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave_user@kappa:3306',replication started in log 'mysql-bin.002830' at position 293541 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL daemons restarting every 7 minutes
can you check for any table crashes in the db by using mysqlcheck. and enable the general log for the database. On Fri, Sep 9, 2011 at 10:37 PM, a.sm...@ukgrid.net wrote: No need for that really is there? I posted what was requested. The part for the shutdown: 110909 17:27:31 InnoDB: Starting shutdown... 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 110909 17:27:32 mysqld_safe mysqld from pid file /var/db/mysql/tau.pid ended 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G 110909 17:27:36 InnoDB: Completed initialization of buffer pool 110909 17:27:36 InnoDB: highest supported file format is Barracuda. 110909 17:27:36 InnoDB: Waiting for the background threads to start 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002830' at position 293541, relay log './tau-relay-bin.000920' position: 253 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave_user@kappa:3306',**replication started in log 'mysql-bin.002830' at position 293541 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?** unsub=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA
Re: MySQL daemons restarting every 7 minutes
Can yo paste the complete error log, Ram memory size and configuration file here and make sure the machine has enough memory to run the services. Check the sys log for what is happening just before the service restart. On Wed, Sep 7, 2011 at 10:51 PM, a.sm...@ukgrid.net wrote: Hi, as of yesterday the MySQL Daemons keep restarting every 7 mins or so on one of my FreeBSD servers. The only work carried out recently related to MySQL on this server was to temporarily disable replication (its a slave) of one DB, and then re-enable it (via restore of data and updating the log file and pos). Now I keep seeing this: 110907 18:03:58 mysqld_safe mysqld restarted 110907 18:03:58 [Note] Plugin 'FEDERATED' is disabled. 110907 18:03:58 InnoDB: Initializing buffer pool, size = 2.0G 110907 18:03:59 InnoDB: Completed initialization of buffer pool 110907 18:03:59 InnoDB: Started; log sequence number 0 44233 110907 18:03:59 [Note] Event Scheduler: Loaded 0 events 110907 18:03:59 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002818' at position 46048, relay log './tau-relay-bin.37' position: 251 110907 18:03:59 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.1.58' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.1.58 110907 18:03:59 [Note] Slave I/O thread: connected to master 'slave@kappa:3306',replication started in log 'mysql-bin.002818' at position 46048 Not seeing any other info, such as why the daemons stopped, just this repeated over and over... I didn't find much useful info searching on the internet, came up with this: http://bugs.mysql.com/bug.php?**id=26895http://bugs.mysql.com/bug.php?id=26895 but its an unresolved bug. I have tried, restoring all DBs from a working server and that didn't work. So wouldnt seem to be related to the contents of the databases. System is FreeBSD 8.2 amd64, MySQL 5.1.58 (I upgrade this from 5.1.51 as a try and fix it quick approach but no joy). Any one chip in from experience what this may be?? I'm considering upgrading to 5.5 to give that a try... thanks in advance, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?** unsub=sureshkumar...@gmail.comhttp://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA
MySQL daemons restarting every 7 minutes
Hi, as of yesterday the MySQL Daemons keep restarting every 7 mins or so on one of my FreeBSD servers. The only work carried out recently related to MySQL on this server was to temporarily disable replication (its a slave) of one DB, and then re-enable it (via restore of data and updating the log file and pos). Now I keep seeing this: 110907 18:03:58 mysqld_safe mysqld restarted 110907 18:03:58 [Note] Plugin 'FEDERATED' is disabled. 110907 18:03:58 InnoDB: Initializing buffer pool, size = 2.0G 110907 18:03:59 InnoDB: Completed initialization of buffer pool 110907 18:03:59 InnoDB: Started; log sequence number 0 44233 110907 18:03:59 [Note] Event Scheduler: Loaded 0 events 110907 18:03:59 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002818' at position 46048, relay log './tau-relay-bin.37' position: 251 110907 18:03:59 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.1.58' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.1.58 110907 18:03:59 [Note] Slave I/O thread: connected to master 'slave@kappa:3306',replication started in log 'mysql-bin.002818' at position 46048 Not seeing any other info, such as why the daemons stopped, just this repeated over and over... I didn't find much useful info searching on the internet, came up with this: http://bugs.mysql.com/bug.php?id=26895 but its an unresolved bug. I have tried, restoring all DBs from a working server and that didn't work. So wouldnt seem to be related to the contents of the databases. System is FreeBSD 8.2 amd64, MySQL 5.1.58 (I upgrade this from 5.1.51 as a try and fix it quick approach but no joy). Any one chip in from experience what this may be?? I'm considering upgrading to 5.5 to give that a try... thanks in advance, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL Daemons
Hi all, I'm administrating a LAMPhp system and have there values below.. Session Count : 6437 (find /tmp -name \sess*\ | wc -l) (session timeout is 30 mins.) MySQL Daemon Count : 85 (ps -ef | grep mysql | wc -l) Apache Daemon Count : 106 (ps -ef | grep httpd | wc -l) As you can see I have lots of mysql daemons running which are mostly on sleep. I don't want these daemons to use RAM. Can you offer any solutions? Also are the above values seems ok? Thanks. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Running MySQL Daemons with same data files
Dear All, I am working in Linux 8.0 and running mysql 4.0.16. I am trying to access same data files from the two mysql daemons. I mean there are two PC's running with mysql and one NAS server where data files are kept. To run mysql on the machines I first mount the NAS file system and then run it like shellsafe_mysqld --datadir=$PATH_TO_DATA_FILE) Daemons are running well but there is problems with synchronization of the data files i.e when i insert some tuples in the tables its not immediately writing then to file its kept in the cache only and when I try to see from the other machine its displaying the old tuples. I want after every transaction or query the database update the data files, how can I do this? And always read from the data files for select operations. My main aim is no cache operation to use the mysql as file system(for every operation file operations only), I know it will degrade the database performance but its the requirement OR if there is any other way by which I can achieve this, please tell me. regards bhartendu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2 mysql daemons starting - both with different configs
Hi, I have copied the file ./support-files/mysql.server to /etc/init.d/mysql_server. I have edited the /etc/init.d/mysql_server to set the basedir to /usr/local/mysql and the datadir to /usr/local/mysql/var When I compiled mysql I set the --with-mysqld-user=mysqldba flag. I run (as root) /etc/init.d/mysql_server start I see $ ps -ef | grep mysql mysqldba 20884 20719 0 11:55:31 pts/10:00 -ksh mysqldba 20880 20865 0 11:55:11 pts/10:00 /usr/local/mysql/libexec/mysqld - -basedir=/usr/local/mysql --datadir=/usr/local root 20865 1 0 11:55:11 pts/10:00 /bin/sh /usr/local/mysql/bin/safe _mysqld --datadir=/usr/local/mysql/var --pid-f $ as you can see the the parent (safe_mysqld) sets --datadir=/usr/local/mysql/var (correct) however the children processe owned by mysqldba sets datadir=/usr/local/ (why not /usr/local/mysql/var ) My Questions are.. Why is the root processes of mysql not owned by mysqldba ? do I need to add an su - mysqldba at the start of the mysql_server script ? why is mysqld setting --datadir=/usr/locl when the script sets datadir=/usr/local/mysql/var ? Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 2 mysql daemons starting - both with different configs
At 12:15 +0100 7/28/02, Matt Darcy wrote: Hi, I have copied the file ./support-files/mysql.server to /etc/init.d/mysql_server. I have edited the /etc/init.d/mysql_server to set the basedir to /usr/local/mysql and the datadir to /usr/local/mysql/var When I compiled mysql I set the --with-mysqld-user=mysqldba flag. I run (as root) /etc/init.d/mysql_server start I see $ ps -ef | grep mysql mysqldba 20884 20719 0 11:55:31 pts/10:00 -ksh mysqldba 20880 20865 0 11:55:11 pts/10:00 /usr/local/mysql/libexec/mysqld - -basedir=/usr/local/mysql --datadir=/usr/local root 20865 1 0 11:55:11 pts/10:00 /bin/sh /usr/local/mysql/bin/safe _mysqld --datadir=/usr/local/mysql/var --pid-f $ as you can see the the parent (safe_mysqld) sets --datadir=/usr/local/mysql/var (correct) however the children processe owned by mysqldba sets datadir=/usr/local/ (why not /usr/local/mysql/var ) My Questions are.. Why is the root processes of mysql not owned by mysqldba ? do I need to add an su - mysqldba at the start of the mysql_server script ? root starts safe_mysqld, which starts mysqld, which switches its user ID to mysqldba. safe_mysqld doesn't changed its ID, which is why it shows up as root. why is mysqld setting --datadir=/usr/locl when the script sets datadir=/usr/local/mysql/var ? I suspect what you're seeing is simply an artifact of ps chopping off output lines. The full command probably is a little different. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple mysql daemons in process
Hello list, I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple mysql daemons in process
This is an artifact of Linux's thread implementation. man 2 clone Also it's not using -that- much memory. Note the SHARE (for memory shared between processes) column. It's not pretty, but it's totally harmless. NOTE: There's always -some- weirdness that goes on with threads implementations between different systems. On Linux, this is it. -M On Tue, Apr 23, 2002 at 11:51:49AM +0800, Patrick Hsieh wrote: I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K total, 840808K used,59656K free, 277532K buffers Swap: 498004K total, 327808K used, 170196K free, 221132K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 31277 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:04 mysqld 31279 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:07 mysqld 31280 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31281 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31282 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31283 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31284 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31285 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:12 mysqld 31286 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 31287 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:01 mysqld 31288 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:00 mysqld 31738 mysql 9 0 300M 30M 3004 S 0.0 3.5 4:11 mysqld 7110 mysql 10 0 300M 30M 3004 S 0.5 3.5 6:22 mysqld 12137 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:59 mysqld 16802 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld 16841 mysql 9 0 300M 30M 3004 S 0.0 3.5 0:02 mysqld It seems mysqld has used all of my memory. Any idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php