mysqld.exe!remove_table_from_cache(THD * thd=0x0664ce08, const char * db=0x0669e338, const char * table_name=0x0669e108, unsigned int flags=0) Line 8235 + 0x2 bytes C++ mysqld.exe!lock_table_name(THD * thd=0x0664ce08, TABLE_LIST * table_list=0x0669e160, bool check_in_use=true) Line 1056 C++ mysqld.exe!lock_table_names(THD * thd=0x0664ce08, TABLE_LIST * table_list=0x0669e160) Line 1137 + 0x9 bytes C++ mysqld.exe!lock_table_names_exclusively(THD * thd=0x0664ce08, TABLE_LIST * table_list=0x0669e160) Line 1175 + 0x10 bytes C++ mysqld.exe!mysql_rm_table_part2(THD * thd=0x0664ce08, TABLE_LIST * tables=0x0669e160, bool if_exists=true, bool drop_temporary=false, bool drop_view=false, bool dont_log_query=false) Line 1592 + 0x16 bytes C++ mysqld.exe!mysql_rm_table(THD * thd=0x0664ce08, TABLE_LIST * tables=0x0669e160, char if_exists='', char drop_temporary=0) Line 1497 + 0x23 bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x0664ce08) Line 3146 + 0x1d bytes C++ mysqld.exe!mysql_parse(THD * thd=0x0664ce08, const char * inBuf=0x0661f4d9, unsigned int length=37, const char * * found_semicolon=0x0785fe60) Line 5634 C++ mysqld.exe!Query_log_event::do_apply_event(const Relay_log_info * rli=0x066376b0, const char * query_arg=0x0661f4d9, unsigned int q_len_arg=107269640) Line 2429 C++ mysqld.exe!Query_log_event::do_apply_event(const Relay_log_info * rli=0x066376b0) Line 2262 C++ mysqld.exe!apply_event_and_update_pos(Log_event * ev=0x0661f430, THD * thd=0x0664ce08, Relay_log_info * rli=0x066376b0, bool skip=true) Line 1937 C++ mysqld.exe!exec_relay_log_event(THD * thd=0x0785fec8, Relay_log_info * rli=0x00000000) Line 2058 + 0xa bytes C++ mysqld.exe!handle_slave_sql(void * arg=0x066364a0) Line 2717 + 0xe bytes C++ mysqld.exe!pthread_start(void * param=0x066a3fe0) Line 85 + 0x3 bytes C mysqld.exe!_threadstart(void * ptd=0x06642d10) Line 196 + 0x6 bytes C E:\mysql-5.1.24-rc-win32\bin>mysqld --console --skip-name-resolve --skip-name-resolve --server-id=3 --port=3307 --old-passwords=1 --auto_increment_increment=2 080610 16:21:36 InnoDB: Started; log sequence number 0 31349907 080610 16:21:36 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=xp64-relay-bin' to avoid this problem. 080610 16:21:36 [Note] Slave SQL thread initialized, starting replication in log 'xp64-bin.000005' at position 2525185, relay log '.\xp64-relay-bin.000428' position: 2525329 080610 16:21:37 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:3306',replication started in log 'xp64-bin.000005' at position 23792720 080610 16:21:37 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT ','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z 080610 16:21:37 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 080610 16:21:37 [Note] mysqld: ready for connections. Version: '5.1.24-rc-community' socket: '' port: 3307 MySQL Community Server (GPL) 080610 16:33:42 [ERROR] Slave SQL: Error 'Can't update table 'tbl_week_ticks' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.' on opening table `test`.`tbl_week_ticks`, Error_code: 1442 080610 16:33:42 [Warning] Slave: Can't update table 'tbl_week_ticks' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. Error_code: 1442 080610 16:33:42 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'xp64-bin.000005' position 24404451 080610 16:33:42 InnoDB: Error: MySQL is freeing a thd InnoDB: though trx->n_mysql_tables_in_use is 2 InnoDB: and trx->mysql_n_tables_locked is 2. TRANSACTION 0 204668, not started, OS thread id 2504 mysql tables in use 2, locked 2 MySQL thread id 2, query id 179118 Waiting for slave mutex on exit len 808; hex 065c6e051c7079000000000001000000c6904e48030000000100000001000000000000007c1f0300ffffffff0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000ffffffffffffffff000000000000000000000000497d700400000000000000000000000000000000b0d961060000000034599f00000000000000000000000000c80900004c0e000002000000020000000000000000000000102700000000000000000000000000000000000000000000000000000000000080ec4d05000000000a00000000000000804d4c0501000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040a84d0500000000000000000000000040aa4d05000000000000000000000000000000000000000068a46306000000000000000058ee4d05e08e4d05f4cc84008f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000; asc \n py ¦ NH |               I}p ¦+a 4Yƒ + L ' 8M ML @¿M @¬M hñc XeM aÄM (¦ä ;080610 16:38:52 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080610 16:38:52 [Note] Slave I/O thread killed while reading event 080610 16:38:52 [Note] Slave I/O thread exiting, read up to log 'xp64-bin.000005', position 55318882 080610 16:38:53 [Note] Slave SQL thread initialized, starting replication in log 'xp64-bin.000005' at position 24404451, relay log '.\xp64-relay-bin.000430' position: 611981 080610 16:38:53 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:3306',replication started in log 'xp64-bin.000005' at position 55318882 080610 16:41:26 InnoDB: Warning: MySQL is trying to drop table `test`.`tbl_delayed_ticks` InnoDB: though there are still open handles to it. InnoDB: Adding the table to the background drop queue. 080610 16:41:26 [ERROR] Slave SQL: Error 'Table 'tbl_delayed_ticks' already exists' on query. Default database: 'test'. Query: 'CREATE TABLE `tbl_delayed_ticks` ( `i_id` int(10) unsigned NOT NULL DEFAULT '0', `i_timediff` int(11) DEFAULT '0', PRIMARY KEY (`i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1', Error_code: 1050 080610 16:41:26 [Warning] Slave: Table 'tbl_delayed_ticks' already exists Error_code: 1050 080610 16:41:26 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'xp64-bin.000005' position 27407929 080610 16:43:42 [Note] Slave SQL thread initialized, starting replication in log 'xp64-bin.000005' at position 27407929, relay log '.\xp64-relay-bin.000430' position: 3615459 080610 16:43:42 [ERROR] Slave SQL: Error 'Table 'tbl_delayed_ticks' already exists' on query. Default database: 'test'. Query: 'CREATE TABLE `tbl_delayed_ticks` ( `i_id` int(10) unsigned NOT NULL DEFAULT '0', `i_timediff` int(11) DEFAULT '0', PRIMARY KEY (`i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1', Error_code: 1050 080610 16:43:42 [Warning] Slave: Table 'tbl_delayed_ticks' already exists Error_code: 1050 080610 16:43:42 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'xp64-bin.000005' position 27407929 080610 16:43:45 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080610 16:43:45 [Note] Slave I/O thread killed while reading event 080610 16:43:45 [Note] Slave I/O thread exiting, read up to log 'xp64-bin.000005', position 55318882 080610 16:44:04 [Note] Slave SQL thread initialized, starting replication in log 'xp64-bin.000005' at position 27407929, relay log '.\xp64-relay-bin.000430' position: 3615459 080610 16:44:04 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:3306',replication started in log 'xp64-bin.000005' at position 55318882 080610 16:44:04 - mysqld got exception 0xc0000005 ; 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=131072 max_used_connections=2 max_threads=151 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337707 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x664ce08 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... 0051C493 mysqld.exe!??? 0089D7D4 mysqld.exe!??? 0040D6A2 mysqld.exe!??? 0040D6A2 mysqld.exe!??? B261E900 Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0661F4D9=drop table if exists `tbl_week_ticks` thd->thread_id=9 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. #some general initialization settings #i|1|set foreign_key_checks=0| i|1|/*!50001 set global innodb_flush_log_at_trx_commit=0 */| #i|1|set global max_connections=1000| #i|1|set global max_allowed_packet=16*1024*1024| #n|1|set foreign_key_checks=0| #n|1|set session max_allowed_packet=1024*1024*1024| #dumping 2 tables i|1|drop table if exists `tbl_delayed_ticks`| i|1|CREATE TABLE `tbl_delayed_ticks` ( `i_id` int(10) unsigned NOT NULL DEFAULT '0', `i_timediff` int(11) DEFAULT '0', PRIMARY KEY (`i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1| n|1|begin| n|5|insert ignore into `tbl_delayed_ticks` set `i_id` = abs(?), `i_timediff` = ?|mediumint,mediumint n|1|commit| i|1|drop table if exists `tbl_week_ticks`| i|1|CREATE TABLE `tbl_week_ticks` ( `i_id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `i_unit_id` int(11) DEFAULT '0', `i_customer_id` smallint(5) unsigned DEFAULT '0', `d_lat` double DEFAULT '0', `d_lon` double DEFAULT '0', `d_velocity` double DEFAULT '0', `d_heading` double DEFAULT '0', `b_validpos` tinyint(1) DEFAULT '0', `dt_timestamp` datetime DEFAULT '0000-00-00 00:00:00', `i_sensor_input` smallint(6) DEFAULT NULL, `i_socket_id` int(11) DEFAULT '0', `i_distance` int(10) unsigned NOT NULL DEFAULT '0', `i_sats_used` tinyint(1) unsigned DEFAULT '0', `d_altitude` double DEFAULT '0', PRIMARY KEY (`i_id`), KEY `Unit` (`i_unit_id`,`dt_timestamp`), KEY `Customer` (`i_customer_id`,`dt_timestamp`), KEY `Index_timestamp` (`dt_timestamp`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1| n|1|begin| n|5|insert ignore into `tbl_week_ticks` set `i_unit_id` = ?, `i_customer_id` = ?, `d_lat` = ?, `d_lon` = ?, `d_velocity` = ?, `d_heading` = ?, `b_validpos` = ?, `dt_timestamp` = '?', `i_sensor_input` = ?, `i_socket_id` = ?, `i_distance` = abs(?), `i_sats_used` = ?, `d_altitude` = ?|mediumint,smallint,double,double,double,double,tinyint,datetime,smallint,mediumint,mediumint,tinyint,double n|1|commit| n|1|rollback| #dumping stored procedures #dumping stored functions #dumping triggers i|1|/*!50003 drop trigger `timediff`*/| i|1|/*!50003 create trigger `timediff` AFTER INSERT on tbl_week_ticks for each row BEGIN IF ABS((unix_timestamp(now())-unix_timestamp(NEW.dt_timestamp))) > 20 THEN INSERT INTO tbl_delayed_ticks SET i_id=NEW.i_id, i_timediff=(unix_timestamp(now())-unix_timestamp(NEW.dt_timestamp)); END IF; end */| #dumping events gypsy --queryfile=s.sql --generate-queryfile=0 --threads=1 --duration=6000 --shuffle-queries=1