mysql:11236
From: 有限会社シーエムジェイ 瀧本 <有限会社シーエムジェイ 瀧本 <takimoto@xxxxxxxxxx>>
Date: Wed, 23 Mar 2005 02:59:09 +0900
Subject: [mysql 11236] safe mysqld が頻発
初めまして、どうしても解決できない問題 がありましてMLに参加させていただきました 1月くらいよりmysql.logに Number of processes running now: 0 050321 19:45:42 mysqld restarted /usr/libexec/mysqld: ready for connections mysqld got signal 11; key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=2 max_connections=100 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80d6d67 0x4004a194 0x40188c28 0x40188995 0x80e8938 0x80f497d 0x80f8049 0x80f0a46 0x80dd62d 0x80e0a45 0x80dc93c 0x80dbef8 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x84c2180 = select cid, title, url from `main_dsp`,`count_dsp` where `main_dsp`.id=`count_dsp`.cid and genre=3 order by incount desc,outcount desc thd->thread_id=4 <一部割愛してます> 今月になってからは Number of processes running now: 3 mysqld process hanging, pid 9205 - killed mysqld process hanging, pid 9205 - killed mysqld process hanging, pid 9205 - killed 050321 21:07:28 mysqld restarted 050321 21:07:28 Can't start server: Bind on TCP/IP port: Address already in use 050321 21:07:28 Do you already have another mysqld server running on port: 3306 ? 050321 21:07:28 Aborting 050321 21:07:28 /usr/libexec/mysqld: Shutdown Complete 050321 21:07:28 mysqld ended となりサービスが落ちてしまう現象が発生しております、落ちることは頻発では ないですが多いときは1日2、3度あります。また最近どんどん頻度が多くなって きました。同様の環境が2台ありまして同時期に発生し状況も同様です 環境は TLS8S + MYSQL3.23.58 X86です、同様の事象を解決例などございましたらお教え願いたくお願い申し上げます。 有限会社シーエムジェイ 瀧本