On 01-Feb-2001 Sinisa Milivojevic wrote: > > HI! > > Most probably processes are waiting for the slave to get updated. > > To circumvent the problem, you should : > > - use our binary (if possible) > > - avoid LOCK TABLES, which truly is necessary only in some rare cases > > > > Regards, > > Sinisa > > ____ __ _____ _____ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] > /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ > ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ > /*/ \*\ Developers Team > Definitely not a replication problem. Just happened again (see attachment) with table locks removed (see my earlier mails). I then stopped the slave dbs and killed the associated threads on the master. What you can easily see is that the problem still persists. The database is locked for good. This is where the fun really starts. When you kill all the threads (the log daemons do recognize this and reconnect) *ALL* threads are in state system lock (see second attachment). This clearly means to me that the database lock handling is corrupted. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH
Id User Host db Command Time State Info 226 logdaemon 10.1.1.6 syslog Killed 64 System lock INSERT INTO pcp (time,host,c pu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 448 logdaemon 10.1.1.3 syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 449 logdaemon 10.1.1.4 syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 450 logdaemon 10.1.1.7 syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 451 logdaemon 10.1.1.2 syslog Query 53 System lock INSERT INTO ipchains (time,ho st,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 452 logdaemon localhost syslog Query 51 System lock INSERT INTO pcp (time,host,c pu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 453 dbmaster localhost NULL Query 0 NULL show processlist
Id User Host db Command Time State Info 223 logdaemon 10.1.1.7 syslog Query 358 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 224 logdaemon 10.1.1.4 syslog Query 417 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 225 logdaemon 10.1.1.3 syslog Query 402 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 226 logdaemon 10.1.1.6 syslog Query 415 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 227 logdaemon 10.1.1.2 syslog Query 1279 System lock INSERT INTO ipchains (time, host,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 228 logdaemon localhost syslog Query 635 System lock INSERT INTO ipchains (time, host,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 437 logreader 10.1.1.4 syslog Query 421 Opening tables select src_ip,count(src_i p) as val,count(distinct dst_ip) as tot from ipchains where time>='20010202 438 system localhost mysql Query 396 Opening tables SELECT User, Select_priv FRO M user where User = 'dbmaster' 444 dbmaster localhost NULL Query 0 NULL show processlist
--------------------------------------------------------------------- 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