From: Hakan Kuecuekyilmaz Date: February 19 2009 6:41am Subject: [ERROR]: iuds6.tst failure on lu0009 List-Archive: http://lists.mysql.com/falcon/569 Message-Id: <20090219064139.CBBEF6F9C0@lu0009.mysql.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_499cff23.U52EvNPwPj2z8jsREX+79dCZN91bN9QOKZtZZF0WPRZSTQT8" --=_499cff23.U52EvNPwPj2z8jsREX+79dCZN91bN9QOKZtZZF0WPRZSTQT8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline There was a crash on lu0009 --=_499cff23.U52EvNPwPj2z8jsREX+79dCZN91bN9QOKZtZZF0WPRZSTQT8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="master.err" CURRENT_TEST: systems.load_engines 090218 9:40:23 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead. 090218 9:40: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. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090218 9:40:23 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090218 9:40:23 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 090218 9:40:23 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 090218 9:40:24 InnoDB: Started; log sequence number 0 0 090218 9:40:24 [Warning] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld: unknown option '--loose-skip-ndbcluster' 090218 9:40:24 [Note] Event Scheduler: Loaded 0 events 090218 9:40:24 [Note] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld: ready for connections. Version: '6.0.10-alpha''-log' socket: '/data0/fsqa/cb/mysql-6.0.10-alpha/mysql-test/var/tmp/master.sock' port: 9306 'MySQL-Community-Server' 090218 9:40:29 [Note] Event Scheduler: scheduler thread started with id 2 [Falcon] Error: assertion (insertIntoTree(NULL, record, record->recordNumber)) failed at line 3816 in file Table.cpp 090218 9:42:01 - 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=1048576 read_buffer_size=131072 max_used_connections=55 max_threads=151 thread_count=51 connection_count=50 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60622 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x7f43c404a6d0 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 = 0x4b3f70e0 thread_stack 0x40000 /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(my_print_stacktrace+0x29) [0xaca969] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(handle_segfault+0x378) [0x67e8b8] /lib/libpthread.so.0 [0x7f43f0f450f0] /lib/libpthread.so.0(raise+0x2b) [0x7f43f0f44fab] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(Error::error(char const*, ...)+0x104) [0x880c34] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(Table::backlogRecord(RecordVersion*)+0x214) [0x89a774] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(SavePoint::backlogRecord(RecordVersion*)+0x30) [0x921200] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(Transaction::backlogRecords()+0x16c) [0x8a802c] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(Transaction::addRecord(RecordVersion*)+0x158) [0x8a8318] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(Table::fetchForUpdate(Transaction*, Record*, bool)+0x300) [0x89d450] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(StorageDatabase::nextRow(StorageTable*, int, bool)+0x60) [0x888210] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(StorageInterface::rnd_next(unsigned char*)+0x79) [0x87c129] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(rr_sequential(READ_RECORD*)+0x21) [0x77d501] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(mysql_delete(THD*, TABLE_LIST*, Item*, st_sql_list*, unsigned long long, unsigned long long, bool)+0x899) [0x723849] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(mysql_execute_command(THD*)+0x18fe) [0x68ff3e] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x36e) [0x693ade] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xad1) [0x694a01] /data0/fsqa/cb/mysql-6.0.10-alpha/sql/mysqld(handle_one_connection+0x1a9) [0x6875b9] /lib/libpthread.so.0 [0x7f43f0f3d3ea] /lib/libc.so.6(clone+0x6d) [0x7f43efeafcbd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x3e4b9f8 = delete from tb0_eng2 where f1=@tmp_num thd->thread_id=508 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. Writing a core file --=_499cff23.U52EvNPwPj2z8jsREX+79dCZN91bN9QOKZtZZF0WPRZSTQT8--