mysql:14886
From: Tetsuro IKEDA <Tetsuro IKEDA <ikdttr@xxxxxxxxxx>>
Date: Tue, 26 May 2009 18:51:24 +0900
Subject: [mysql 14886] Re: バッチ処理のUPDATEでmysqld got signal 11が発生する
こんにちは。池田です。 32bitOSだからではとの指摘がありましたが、ログに、 > thd: 0xc7064b8 > stack_bottom = 0x24c513b8 thread_stack 0x30000 とでていることから32bitOSであることは間違いないですね。 key_buffer_size=2147483648 ←2GB このkey_buffer_sizeを1.5GBあるいは1GBくらいに減らして 見てはどうでしょう。 2009/05/26 17:16 浅山雄三 <ALCYONE@xxxxxxxxxx>: > 浅山と申します。いつもお世話になります。 > > 約20万件のデータをバッチ処理でUPDATEしている途中でmysqld got > signal 11となり、コネクションが切れてしまいます。同じデータで何回か実行 > してみましたが、ある時は数千件目、またある時は10数万件目と、実行する度 > にsignal 11が発生するレコードが違っています。 > signal 11を回避する何かいい手立てがありましたらお教えください。 > > 【環境】 > REDHAT 5.1 > MySQL 5.1.32 > PHP 5.2.8 > > 【エラー・ログ】 > 090526 6:13:28 - mysqld got signal 11 ; > This could be because you hit a bug. It is also possible that this > binary > or one of the libraries it was linked against is corrupt, improperly > built, > or misconfigured. This error can also be caused by malfunctioning > hardware. > We will try our best to scrape up some info that will hopefully help > diagnose > the problem, but since we have already crashed, something is definitely > wrong > and this may fail. > > key_buffer_size=2147483648 > read_buffer_size=2097152 > max_used_connections=2 > max_threads=200 > threads_connected=2 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = > 2917622 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > thd: 0xc7064b8 > 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_bottom = 0x24c513b8 thread_stack 0x30000 > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at 0xa0bf070 = update tp_catalog set ngram = '〜〜' > thd->thread_id=669 > thd->killed=NOT_KILLED > The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html > contains > information that should help you find out what is causing the crash. > 090526 06:13:28 mysqld_safe Number of processes running now: 0 > 090526 06:13:28 mysqld_safe mysqld restarted > InnoDB: The log sequence number in ibdata files does not match > InnoDB: the log sequence number in the ib_logfiles! > 090526 6:13:29 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 090526 6:13:29 InnoDB: Started; log sequence number 0 468460067 > 090526 6:13:29 [Note] Event Scheduler: Loaded 0 events > 090526 6:13:29 [Note] /opac/pp/mysql/bin/bin/mysqld: ready for > connections. > Version: '5.1.32' socket: '/tmp/mysql.sock' port: 3306 MySQL > Community Server (GPL) > > > > 2009年5月26日 17:11:29 (^o^)浅山雄三 > > >
14884 2009-05-26 17:16 [<ALCYONE@xxxxxxxxxx>] バッチ処理のUPDATEでmysqld got signal 11が発生する 14885 2009-05-26 17:32 ┣[Katsutoshi Nakatomi ] -> 14886 2009-05-26 18:51 ┗[Tetsuro IKEDA <ikdtt] 14888 2009-05-27 09:24 ┗[<ALCYONE@xxxxxxxxxx>] 14889 2009-05-28 12:52 ┗[<ALCYONE@xxxxxxxxxx>] Re: バッチ処理のUPDATEでmysqld got signal 11が発生する 【再発】 14890 2009-06-05 10:49 ┗[<ALCYONE@xxxxxxxxxx>] Re: バッチ処理のUPDATEでmysqld got signal 11が発生する 【再発】他に類似事象?有り 14891 2009-06-05 11:39 ┗["Kaname Kuji\(Y7\)" ] 14892 2009-06-05 12:16 ┗[<ALCYONE@xxxxxxxxxx>] 14893 2009-06-05 12:44 ┗["Kaname Kuji\(Y7\)" ] 14894 2009-06-05 12:53 ┗[<ALCYONE@xxxxxxxxxx>] 14895 2009-06-05 14:44 ┗["Kaname Kuji\(Y7\)" ] 14913 2009-06-10 12:57 ┗[<ALCYONE@xxxxxxxxxx>]