100623 10:00:23 mysqld_safe Starting mysqld daemon with databases from /Mysql_SAN/mysql_5130_datadir/optimus/var 100623 10:00:23 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 10:00:23 [Warning] One can only use the --user switch if running as root 100623 10:00:23 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 16 MB InnoDB: Database physically writes the file full: wait... 100623 10:00:23 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 16 MB InnoDB: Database physically writes the file full: wait... InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 100623 10:00:24 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... 100623 10:00:24 InnoDB: Started; log sequence number 90 1704544268 100623 10:00:24 [Note] Event Scheduler: Loaded 0 events 100623 10:00:24 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 68f05eb3fa5856b100000000019edf380100000002000000000000000300000001000000000000000100000000000000e08b55bb00000000010000008344510700000000306576616c2e63003c000000000000000000000060e1117704000000680c00b4480000000000000000000000; asc h ^ XV 8 U DQ 0eval.c < ` w h H ;TRANSACTION 0 188172220, ACTIVE 0 sec, process no 29216, OS thread id 1638427 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 25611, query id 57995222 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:00:39 InnoDB: Assertion failure in thread 1638427 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:00:39 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=28 max_threads=50 threads_connected=12 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xaa31208 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 = 0xbc5ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xae5d5408 is an invalid pointer thd->thread_id=25611 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:00:39 mysqld_safe Number of processes running now: 0 100623 11:00:39 mysqld_safe mysqld restarted 100623 11:00:39 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:00:39 [Warning] One can only use the --user switch if running as root InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 100623 11:00:39 InnoDB: Retrying to lock the first data file InnoDB: Log scan progressed past the checkpoint lsn 90 2227982504 100623 11:00:40 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2232352786 100623 11:00:41 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 100623 11:00:43 InnoDB: Started; log sequence number 90 2232352786 100623 11:00:43 [Note] Event Scheduler: Loaded 0 events 100623 11:00:43 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 68005ab3fa182bb300000000000000000100000002000000000000000300000001000000000000000100000000000000e08b55bb00000000010000008344510700000000000000000000000000000000000000000000000060e111770400000068acdcb3000000000000000000000000; asc h Z + U DQ ` w h ;TRANSACTION 0 188174175, ACTIVE 0 sec, process no 29268, OS thread id 311316 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 73, query id 179143 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:00:53 InnoDB: Assertion failure in thread 311316 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:00:53 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=12 max_threads=50 threads_connected=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xabb127a0 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 = 0xbd3ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xb428f40 = UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFN thd->thread_id=73 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:00:53 mysqld_safe Number of processes running now: 0 100623 11:00:53 mysqld_safe mysqld restarted 100623 11:00:53 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:00:53 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2227982518 100623 11:00:53 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2233225216 InnoDB: Doing recovery: scanned up to log sequence number 90 2234533748 100623 11:00:54 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 100623 11:00:57 InnoDB: Started; log sequence number 90 2234533748 100623 11:00:57 [Note] Event Scheduler: Loaded 0 events 100623 11:00:57 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 68725cb3fad8fdb100000000019ee98f0100000002000000000000000300000001000000000000000100000000000000e08b55bb98cea9b3010000008344510700000000306576616c2e63003c000000000000000000000060e1117704000000688cfcb3480000000000000000000000; asc hr\ U DQ 0eval.c < ` w h H ;TRANSACTION 0 188203913, ACTIVE 0 sec, process no 29310, OS thread id 409626 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 627, query id 8248195 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',_latin1'06355RF0025' COLLATE 'latin1_swedish_ci'),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100600856' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100600856' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',_latin1'1B334' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',_latin1'1B334' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:05:11 InnoDB: Assertion failure in thread 409626 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:05:11 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=23 max_threads=50 threads_connected=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xa79d77e8 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 = 0xbc7ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xacc35f90 is an invalid pointer thd->thread_id=627 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:05:11 mysqld_safe Number of processes running now: 0 100623 11:05:11 mysqld_safe mysqld restarted 100623 11:05:11 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:05:11 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2262407409 100623 11:05:11 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2264577893 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 12 row operations to undo InnoDB: Trx id counter is 0 188204288 100623 11:05:12 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 100623 11:05:14 InnoDB: Started; log sequence number 90 2264577893 InnoDB: Starting in background the rollback of uncommitted transactions 100623 11:05:14 InnoDB: Rolling back trx with id 0 188203868, 12 rows to undo InnoDB: Rolling back of trx id 0 188203868 completed 100623 11:05:14 InnoDB: Rollback of non-prepared transactions completed 100623 11:05:14 [Note] Event Scheduler: Loaded 0 events 100623 11:05:14 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 680c5bb3fad87db2040040204c1207b40100000002000000000000000300000001000000000000000100000000000000e08b55bb00000000010000008344510700000000306576616c2e63003c000000000000000000000060e111770400000068acd0b3480000000000000000000000; asc h [ } @ L U DQ 0eval.c < ` w h H ;TRANSACTION 0 188222696, ACTIVE 0 sec, process no 29377, OS thread id 393241 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 448, query id 2299050 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100603715' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100603715' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',_latin1'1B344' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',_latin1'1B344' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:06:56 InnoDB: Assertion failure in thread 393241 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:06:56 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=20 max_threads=50 threads_connected=17 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xac3a86e8 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 = 0xbc9ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xa6882b80 is an invalid pointer thd->thread_id=448 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:06:56 mysqld_safe Number of processes running now: 0 100623 11:06:57 mysqld_safe mysqld restarted 100623 11:06:57 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:06:57 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2279782545 100623 11:06:57 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2280832032 InnoDB: 2 transaction(s) which must be rolled back or cleaned up InnoDB: in total 36 row operations to undo InnoDB: Trx id counter is 0 188222976 100623 11:06:57 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 100623 11:06:58 InnoDB: Rolling back trx with id 0 188220064, 24 rows to undo 100623 11:06:58 InnoDB: Started; log sequence number 90 2280832032 InnoDB: Rolling back of trx id 0 188220064 completed 100623 11:06:58 InnoDB: Rolling back trx with id 0 188213972, 12 rows to undo InnoDB: Rolling back of trx id 0 188213972 completed 100623 11:06:58 InnoDB: Rollback of non-prepared transactions completed 100623 11:06:58 [Note] Event Scheduler: Loaded 0 events 100623 11:06:58 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 688662b3fa9811b210000000120000000100000002000000000000000000000001000000000000000100000000000000e08b55bb00000000010000008344510700000000000000000000000000000000000000000000000060e111770400000068c41db4000000000000000000000000; asc h b U DQ ` w h ;TRANSACTION 0 188228664, ACTIVE 0 sec, process no 29426, OS thread id 491551 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 1019, query id 2321125 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',_latin1'1A224' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',_latin1'1A224' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:09:35 InnoDB: Assertion failure in thread 491551 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:09:35 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=25 max_threads=50 threads_connected=22 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xa7c09fe0 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 = 0xbbdff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xc52f378 = UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifs thd->thread_id=1019 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:09:35 mysqld_safe Number of processes running now: 0 100623 11:09:35 mysqld_safe mysqld restarted 100623 11:09:35 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:09:35 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2284242967 100623 11:09:35 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2285278688 InnoDB: 3 transaction(s) which must be rolled back or cleaned up InnoDB: in total 25 row operations to undo InnoDB: Trx id counter is 0 188229120 100623 11:09:35 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 100623 11:09:37 InnoDB: Rolling back trx with id 0 188228634, 8 rows to undo 100623 11:09:37 InnoDB: Started; log sequence number 90 2285278688 InnoDB: Rolling back of trx id 0 188228634 completed 100623 11:09:37 InnoDB: Rolling back trx with id 0 188228386, 5 rows to undo InnoDB: Rolling back of trx id 0 188228386 completed 100623 11:09:37 InnoDB: Rolling back trx with id 0 188227923, 12 rows to undo InnoDB: Rolling back of trx id 0 188227923 completed 100623 11:09:37 InnoDB: Rollback of non-prepared transactions completed 100623 11:09:37 [Note] Event Scheduler: Loaded 0 events 100623 11:09:37 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 68e66db38c4093b2020000000100000001000000020000000000000003000000010000000000000001000000000000002f51a7bc00000000010000008344510700000000000000000000000000000000000000000000000060e111770400000068ecd7b3000000000000000000000000; asc h m @ /Q DQ ` w h ;TRANSACTION 0 188230501, ACTIVE 0 sec, process no 29465, OS thread id 360471 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 33, query id 14725 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100601977' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',_latin1'1A224' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',_latin1'1A224' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:09:47 InnoDB: Assertion failure in thread 360471 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:09:47 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=15 max_threads=50 threads_connected=13 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xabf9df70 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 = 0xbcdff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xaab0f428 is an invalid pointer thd->thread_id=33 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:09:47 mysqld_safe Number of processes running now: 0 100623 11:09:47 mysqld_safe mysqld restarted 100623 11:09:47 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:09:47 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2284242967 100623 11:09:47 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2286281305 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 22 row operations to undo InnoDB: Trx id counter is 0 188230912 100623 11:09:47 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 100623 11:09:49 InnoDB: Rolling back trx with id 0 188230373, 22 rows to undo 100623 11:09:49 InnoDB: Started; log sequence number 90 2286281305 InnoDB: Rolling back of trx id 0 188230373 completed 100623 11:09:49 InnoDB: Rollback of non-prepared transactions completed 100623 11:09:49 [Note] Event Scheduler: Loaded 0 events 100623 11:09:49 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 688c64b3fad842b1010000008414ecb30100000002000000000000000300000001000000000000000100000000000000e08b55bb6f6e5f640100000083445107000000000d0a202028206c6f636174696f6e5f636f64652060e11177040000006840aeb36c6f6361000000005f6e616d; asc h d B U on_d DQ ( location_code ` w h@ loca _nam;TRANSACTION 0 188232155, ACTIVE 0 sec, process no 29492, OS thread id 196621 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 12, query id 282220 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100602313' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100602313' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',_latin1'2A280' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',_latin1'2A280' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:10:03 InnoDB: Assertion failure in thread 196621 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:10:03 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=10 max_threads=50 threads_connected=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x9c2e8f8 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 = 0xbe1ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x9f24858 = UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100602313' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100602313' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifs thd->thread_id=12 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:10:03 mysqld_safe Number of processes running now: 0 100623 11:10:03 mysqld_safe mysqld restarted 100623 11:10:03 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:10:03 [Warning] One can only use the --user switch if running as root InnoDB: Log scan progressed past the checkpoint lsn 90 2286733326 100623 11:10:03 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2287909312 100623 11:10:03 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 100623 11:10:05 InnoDB: Started; log sequence number 90 2287909312 100623 11:10:05 [Note] Event Scheduler: Loaded 0 events 100623 11:10:05 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution len 112; hex 687857b38c00e8b0010000008432c2b301000000020000000000000003000000010000000000000001000000000000002f51a7bc0700010001000000834451070000000007000100746d702f2373716c373334635f34343860e111770400000068f4d9b360000000000000000c000000; asc hxW 2 /Q DQ tmp/#sql734c_448` w h ` ;TRANSACTION 0 188564837, ACTIVE 0 sec, process no 29641, OS thread id 819221 unlock_row, thread declared inside InnoDB 495 mysql tables in use 6, locked 6 11 lock struct(s), heap size 1024, 5 row lock(s) MySQL thread id 17336, query id 60618920 optimussso.fjdc.com 192.168.0.147 tsduser Sending data UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100604660' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100604660' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_order_no = NAME_CONST('p_internal_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_external_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.external_order_no = NAME_CONST('p_external_order_no',NULL) END AND CASE IFNULL( NAME_CONST('p_customer_code',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.customer_code = NAME_CONST('p_customer_code',NULL) END AND CASE IFNULL( NAME_CONST('p_internal_id',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.internal_id = NAME_CONST('p_internal_id',NULL) END AND ifsr.stock_status = IFNULL( NAME_CONST('p_item_status',NULL),ifsr.stock_status) AND iltilm .location_code = NAME_CONST('p_location_code',_latin1'FJML_MFG1' COLLATE 'latin1_swedish_ci') AND iltilm.location_inventory_location_mapping_id = IFNULL( NAME_CONST('p_inventory_mapping_id',12) ,iltilm .location_inventory_location_mapping_id) AND iltilm.inventory_location_code = iilm.inventory_location_code AND ifsr.from_inv_location_id = iltilm.location_inventory_location_mapping_id AND clm.location_code = iltilm.location_code AND ifsr.trans_type = (select parameter_id FROM core_parameter_master WHERE param_code = 'INVENTORY_TRANSACTION_TYPE' AND sequence_number = 2) AND DATE(ifsr.transaction_date) <= NAME_CONST('p_date_to',_binary'2010-06-23' COLLATE 'binary') 100623 11:50:27 InnoDB: Assertion failure in thread 819221 in file btr/btr0pcur.c line 217 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. 100623 11:50:27 - mysqld got signal 6 ; 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=8388600 read_buffer_size=2097152 max_used_connections=22 max_threads=50 threads_connected=15 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 213307 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xac23b110 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 = 0xbd1ff90c thread_stack 0x30000 [0x8362b9d] [0x80eb931] [0x824680c] [0x8396008] [0x8396510] [0x82fd924] [0x82c5204] [0x825390b] [0x814f53a] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f4db] [0x814f60e] [0x814f932] [0x8162336] [0x8163463] [0x81772c4] [0x80fde8c] [0x821ef7e] [0x821ed3e] [0x822115a] [0x821c0ac] [0x821d5f7] [0x80fd4eb] [0x810200c] [0x8102dde] [0x8103894] [0x80f3a65] [0x8241145] [0x83b560a] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xccfcf40 = UPDATE fg_reconciliation_details frd, inv_fg_stock_register ifsr, inv_location_to_inventory_location_mapping iltilm, inv_inventory_location_master iilm, core_location_master clm SET frd.issue_quantity = ifsr.quantity WHERE frd.design_no = ifsr.design_no AND frd.grn_no = ifsr.grn_no AND frd.stock_status = ifsr.stock_status AND frd.to_location_id = ifsr.from_inv_location_id -- AND frd.receipt_request_id =ifsr.receipt_request_id AND ifsr.design_no = IFNULL( NAME_CONST('p_design_no',NULL),ifsr.design_no) AND ifsr.variant_no = IFNULL( NAME_CONST('p_variant_no',NULL),ifsr.variant_no) AND CASE IFNULL( NAME_CONST('p_bag_number',_latin1'BG100604660' COLLATE 'latin1_swedish_ci'),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifsr.bag_number = NAME_CONST('p_bag_number',_latin1'BG100604660' COLLATE 'latin1_swedish_ci') END AND CASE IFNULL( NAME_CONST('p_internal_order_no',NULL),'NULL') WHEN 'NULL' THEN 1=1 ELSE ifs thd->thread_id=17336 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. You are running a statically-linked LinuxThreads binary on an NPTL system. This can result in crashes on some distributions due to LT/NPTL conflicts. You should either build a dynamically-linked binary, or force LinuxThreads to be used with the LD_ASSUME_KERNEL environment variable. Please consult the documentation for your distribution on how to do that. 100623 11:50:27 mysqld_safe Number of processes running now: 0 100623 11:50:27 mysqld_safe mysqld restarted 100623 11:50:27 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 100623 11:50:27 [Warning] One can only use the --user switch if running as root InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 100623 11:50:27 InnoDB: Retrying to lock the first data file InnoDB: Log scan progressed past the checkpoint lsn 90 2595061529 100623 11:50:28 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... InnoDB: Doing recovery: scanned up to log sequence number 90 2598582049 InnoDB: 2 transaction(s) which must be rolled back or cleaned up InnoDB: in total 58 row operations to undo InnoDB: Trx id counter is 0 188565248 100623 11:50:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 100623 11:50:31 InnoDB: Rolling back trx with id 0 188564801, 20 rows to undo 100623 11:50:31 InnoDB: Started; log sequence number 90 2598582049 InnoDB: Rolling back of trx id 0 188564801 completed 100623 11:50:31 InnoDB: Rolling back trx with id 0 188548748, 38 rows to undo InnoDB: Rolling back of trx id 0 188548748 completed 100623 11:50:31 InnoDB: Rollback of non-prepared transactions completed 100623 11:50:32 [Note] Event Scheduler: Loaded 0 events 100623 11:50:32 [Note] /home/user/sw/mysql-5.1.30/libexec/mysqld: ready for connections. Version: '5.1.30-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution