121220 10:09:41 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000549' at position 879903578 121220 10:09:41 [Note] /usr/libexec/mysqld: Normal shutdown 121220 10:09:41 [Note] Event Scheduler: Purging the queue. 0 events 121220 10:13:45 InnoDB: Starting shutdown... 121220 10:13:49 InnoDB: Shutdown completed; log sequence number 1 416723474 121220 10:13:49 [Note] /usr/libexec/mysqld: Shutdown complete 121220 10:13:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 10:13:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 10:13:58 InnoDB: Initializing buffer pool, size = 128.0M 121220 10:13:58 InnoDB: Completed initialization of buffer pool 121220 10:13:58 InnoDB: Started; log sequence number 1 416723474 121220 10:13:58 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:13:58 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:13:58 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000549' at position 879903578, relay log '/var/lib/mysqllogs/relay-log.000050' position: 879903721 121220 10:13:58 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000549' at position 909376859 121220 10:13:58 [Note] Event Scheduler: Loaded 0 events 121220 10:13:58 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 10:27:39 [Note] /usr/libexec/mysqld: Normal shutdown 121220 10:27:39 [Note] Event Scheduler: Purging the queue. 0 events 121220 10:27:39 [Note] Slave I/O thread killed while reading event 121220 10:27:39 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 56922209 121220 10:27:39 [Note] Error reading relay log event: slave SQL thread was killed 121220 10:27:39 InnoDB: Starting shutdown... 121220 10:27:44 InnoDB: Shutdown completed; log sequence number 1 416723484 121220 10:27:44 [Note] /usr/libexec/mysqld: Shutdown complete 121220 10:27:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 10:34:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 10:34:51 InnoDB: Initializing buffer pool, size = 128.0M 121220 10:34:51 InnoDB: Completed initialization of buffer pool 121220 10:34:51 InnoDB: Started; log sequence number 1 416723484 121220 10:34:52 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:34:52 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:34:52 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 56922209, relay log '/var/lib/mysqllogs/relay-log.000054' position: 56922352 121220 10:34:52 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 56922209 121220 10:34:52 [Note] Event Scheduler: Loaded 0 events 121220 10:34:52 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 10:40:39 [Note] /usr/libexec/mysqld: Normal shutdown 121220 10:40:39 [Note] Event Scheduler: Purging the queue. 0 events 121220 10:40:39 [Note] Error reading relay log event: slave SQL thread was killed 121220 10:40:39 [Note] Slave I/O thread killed while reading event 121220 10:40:39 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 57066786 121220 10:40:39 InnoDB: Starting shutdown... 121220 10:40:42 InnoDB: Shutdown completed; log sequence number 1 416723494 121220 10:40:42 [Note] /usr/libexec/mysqld: Shutdown complete 121220 10:40:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 10:43:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 10:43:36 InnoDB: Initializing buffer pool, size = 128.0M 121220 10:43:36 InnoDB: Completed initialization of buffer pool 121220 10:43:37 InnoDB: Started; log sequence number 1 416723494 121220 10:43:37 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:43:37 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:43:37 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 57066786, relay log '/var/lib/mysqllogs/relay-log.000056' position: 144827 121220 10:43:37 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 57066786 121220 10:43:37 [Note] Event Scheduler: Loaded 0 events 121220 10:43:37 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 10:47:52 [Note] /usr/libexec/mysqld: Normal shutdown 121220 10:47:52 [Note] Event Scheduler: Purging the queue. 0 events 121220 10:47:52 [Note] Error reading relay log event: slave SQL thread was killed 121220 10:47:52 [Note] Slave I/O thread killed while reading event 121220 10:47:52 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 57148547 121220 10:47:52 InnoDB: Starting shutdown... 121220 10:47:54 InnoDB: Shutdown completed; log sequence number 1 416723504 121220 10:47:54 [Note] /usr/libexec/mysqld: Shutdown complete 121220 10:47:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 10:50:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 10:50:49 InnoDB: Initializing buffer pool, size = 128.0M 121220 10:50:49 InnoDB: Completed initialization of buffer pool 121220 10:50:49 InnoDB: Started; log sequence number 1 416723504 121220 10:50:49 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:50:49 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 10:50:50 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 57148547, relay log '/var/lib/mysqllogs/relay-log.000058' position: 82011 121220 10:50:50 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 57148547 121220 10:50:50 [Note] Event Scheduler: Loaded 0 events 121220 10:50:50 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 11:37:38 [Note] /usr/libexec/mysqld: Normal shutdown 121220 11:37:38 [Note] Event Scheduler: Purging the queue. 0 events 121220 11:37:38 [Note] Error reading relay log event: slave SQL thread was killed 121220 11:37:38 [Note] Slave I/O thread killed while reading event 121220 11:37:38 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 57544119 121220 11:37:38 InnoDB: Starting shutdown... 121220 11:37:42 InnoDB: Shutdown completed; log sequence number 1 416723514 121220 11:37:42 [Note] /usr/libexec/mysqld: Shutdown complete 121220 11:37:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 11:40:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 11:40:37 InnoDB: Initializing buffer pool, size = 128.0M 121220 11:40:37 InnoDB: Completed initialization of buffer pool 121220 11:40:38 InnoDB: Started; log sequence number 1 416723514 121220 11:40:38 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 11:40:38 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 11:40:38 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 57544119, relay log '/var/lib/mysqllogs/relay-log.000060' position: 395822 121220 11:40:38 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 57544119 121220 11:40:38 [Note] Event Scheduler: Loaded 0 events 121220 11:40:38 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 12:42:19 [Note] /usr/libexec/mysqld: Normal shutdown 121220 12:42:19 [Note] Event Scheduler: Purging the queue. 0 events 121220 12:42:19 [Note] Error reading relay log event: slave SQL thread was killed 121220 12:42:19 [Note] Slave I/O thread killed while reading event 121220 12:42:19 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 78668219 121220 12:42:19 InnoDB: Starting shutdown... 121220 12:42:21 InnoDB: Shutdown completed; log sequence number 1 416723524 121220 12:42:21 [Note] /usr/libexec/mysqld: Shutdown complete 121220 12:42:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 12:45:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 12:45:15 InnoDB: Initializing buffer pool, size = 128.0M 121220 12:45:15 InnoDB: Completed initialization of buffer pool 121220 12:45:15 InnoDB: Started; log sequence number 1 416723524 121220 12:45:16 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 12:45:16 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 12:45:16 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 78668219, relay log '/var/lib/mysqllogs/relay-log.000062' position: 21124350 121220 12:45:16 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 78668219 121220 12:45:16 [Note] Event Scheduler: Loaded 0 events 121220 12:45:16 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 14:14:47 [Note] /usr/libexec/mysqld: Normal shutdown 121220 14:14:47 [Note] Event Scheduler: Purging the queue. 0 events 121220 14:14:47 [Note] Error reading relay log event: slave SQL thread was killed 121220 14:14:47 [Note] Slave I/O thread killed while reading event 121220 14:14:47 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 80176167 121220 14:14:47 InnoDB: Starting shutdown... 121220 14:14:49 InnoDB: Shutdown completed; log sequence number 1 416723534 121220 14:14:49 [Note] /usr/libexec/mysqld: Shutdown complete 121220 14:14:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 14:17:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 14:17:43 InnoDB: Initializing buffer pool, size = 128.0M 121220 14:17:43 InnoDB: Completed initialization of buffer pool 121220 14:17:44 InnoDB: Started; log sequence number 1 416723534 121220 14:17:44 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 14:17:44 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 14:17:44 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 80176167, relay log '/var/lib/mysqllogs/relay-log.000064' position: 1508198 121220 14:17:44 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 80176167 121220 14:17:44 [Note] Event Scheduler: Loaded 0 events 121220 14:17:44 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121220 15:56:42 [Note] /usr/libexec/mysqld: Normal shutdown 121220 15:56:42 [Note] Event Scheduler: Purging the queue. 0 events 121220 15:56:42 [Note] Error reading relay log event: slave SQL thread was killed 121220 15:56:42 [Note] Slave I/O thread killed while reading event 121220 15:56:42 [Note] Slave I/O thread exiting, read up to log 'bin-log.000550', position 81634084 121220 15:56:42 InnoDB: Starting shutdown... 121220 15:56:45 InnoDB: Shutdown completed; log sequence number 1 416723544 121220 15:56:45 [Note] /usr/libexec/mysqld: Shutdown complete 121220 15:56:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121220 15:59:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121220 15:59:38 InnoDB: Initializing buffer pool, size = 128.0M 121220 15:59:38 InnoDB: Completed initialization of buffer pool 121220 15:59:38 InnoDB: Started; log sequence number 1 416723544 121220 15:59:38 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 15:59:38 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121220 15:59:39 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000550' at position 81634084, relay log '/var/lib/mysqllogs/relay-log.000066' position: 1458167 121220 15:59:39 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000550' at position 81634084 121220 15:59:39 [Note] Event Scheduler: Loaded 0 events 121220 15:59:39 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 121221 7:54:26 [Note] /usr/libexec/mysqld: Normal shutdown 121221 7:54:26 [Note] Slave I/O thread killed while reading event 121221 7:54:26 [Note] Slave I/O thread exiting, read up to log 'bin-log.000561', position 1056744049 121221 7:54:26 [Note] Event Scheduler: Purging the queue. 0 events 121221 7:54:53 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000561' at position 1056744049 121221 08:00:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121221 8:00:27 InnoDB: Initializing buffer pool, size = 128.0M 121221 8:00:27 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 121221 8:00:27 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: Last MySQL binlog file position 0 59903237, file name /var/log/mysql/bin-log.000533 121221 8:00:28 InnoDB: Started; log sequence number 1 416723554 121221 8:00:28 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 121221 8:00:28 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 121221 8:00:28 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000561' at position 1056744049, relay log '/var/lib/mysqllogs/relay-log.000100' position: 1056744192 121221 8:00:28 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000561' at position 1056744049 121221 8:00:28 [Note] Event Scheduler: Loaded 0 events 121221 8:00:28 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130107 9:29:39 [Note] Error reading relay log event: slave SQL thread was killed 130107 9:29:39 [Note] Slave I/O thread killed while reading event 130107 9:29:39 [Note] Slave I/O thread exiting, read up to log 'bin-log.000801', position 537707418 130107 9:29:49 [Note] /usr/libexec/mysqld: Normal shutdown 130107 9:29:49 [Note] Event Scheduler: Purging the queue. 0 events 130107 09:36:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130107 9:36:00 InnoDB: Initializing buffer pool, size = 128.0M 130107 9:36:00 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130107 9:36:00 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: Last MySQL binlog file position 0 59903237, file name /var/log/mysql/bin-log.000533 130107 9:36:01 InnoDB: Started; log sequence number 1 416723944 130107 9:36:01 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130107 9:36:01 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130107 9:36:01 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000801' at position 537707418, relay log '/var/lib/mysqllogs/relay-log.000843' position: 29127560 130107 9:36:01 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000801' at position 537707418 130107 9:36:01 [Note] Event Scheduler: Loaded 0 events 130107 9:36:01 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130111 9:29:41 [Note] Error reading relay log event: slave SQL thread was killed 130111 9:29:41 [Note] Slave I/O thread killed while reading event 130111 9:29:41 [Note] Slave I/O thread exiting, read up to log 'bin-log.000845', position 29137326 130111 9:29:51 [Note] /usr/libexec/mysqld: Normal shutdown 130111 9:29:51 [Note] Event Scheduler: Purging the queue. 0 events 130111 09:35:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130111 9:35:38 InnoDB: Initializing buffer pool, size = 128.0M 130111 9:35:38 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130111 9:35:38 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: Last MySQL binlog file position 0 59903237, file name /var/log/mysql/bin-log.000533 130111 9:35:39 InnoDB: Started; log sequence number 1 416724030 130111 9:35:39 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130111 9:35:39 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130111 9:35:39 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000845' at position 29137326, relay log '/var/lib/mysqllogs/relay-log.000976' position: 29137469 130111 9:35:39 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000845' at position 29137326 130111 9:35:39 [Note] Event Scheduler: Loaded 0 events 130111 9:35:39 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130111 9:40:14 [ERROR] /usr/libexec/mysqld: Table './CSMed/LMSBillDetail' is marked as crashed and should be repaired 130111 9:40:14 [ERROR] Slave SQL: Error 'Table './CSMed/LMSBillDetail' is marked as crashed and should be repaired' on query. Default database: 'CSMed'. Query: 'CREATE TEMPORARY TABLE TMP1 SELECT LMSBillDetail.CostCenterFID, LMSBillDetail.CostUnit, SUM(LMSBillDetail.Cnt) AS Anzahl, SUM(LMSBillDetail.Amount) AS Summe , SUM(CostVarPeriod.CostLevel1*LMSBillDetail.Cnt) AS CostLevel1, SUM(CostVarPeriod.CostLevel2*LMSBillDetail.Cnt) AS CostLevel2, SUM(CostVarPeriod.CostLevel3*LMSBillDetail.Cnt) AS CostLevel3 FROM LMSBillDetail LEFT JOIN CostVarPeriod ON (LMSBillDetail.CostUnit = CostVarPeriod.CostUnit AND LMSBillDetail.CostCenterFID = CostVarPeriod.CostCenterFID AND LMSBillDetail.CostCenterSub = CostVarPeriod.CostCenterSub AND LMSBillDetail.FKidLocation = CostVarPeriod.FKidLocation) LEFT JOIN Customer 130111 9:40:14 [Warning] Slave: Table './CSMed/LMSBillDetail' is marked as crashed and should be repaired Error_code: 145 130111 9:40:14 [Warning] Slave: Table 'LMSBillDetail' is marked as crashed and should be repaired Error_code: 1194 130111 9:40:14 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin-log.000845' position 43817180 130113 1:24:41 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001034' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130113 1:24:41 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 130113 1:25:41 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001034' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130113 1:25:41 [ERROR] /usr/libexe130114 8:52:42 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000845' at position 43817180, relay log '/var/lib/mysqllogs/relay-log.000978' position: 14680104 130114 8:52:42 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 130114 8:52:42 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin-log.000864' at position 137768679 130114 8:52:42 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001035' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130114 8:52:42 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 130114 8:52:46 [ERROR] Slave SQL: Error 'Got error -1 from storage engine' on query. Default database: 'CSMed'. Query: 'CREATE TEMPORARY TABLE TMP1 SELECT LMSBillDetail.CostCenterFID, LMSBillDetail.CostUnit, SUM(LMSBillDetail.Cnt) AS Anzahl, SUM(LMSBillDetail.Amount) AS Summe , SUM(CostVarPeriod.CostLevel1*LMSBillDetail.Cnt) AS CostLevel1, SUM(CostVarPeriod.CostLevel2*LMSBillDetail.Cnt) AS CostLevel2, SUM(CostVarPeriod.CostLevel3*LMSBillDetail.Cnt) AS CostLevel3 FROM LMSBillDetail LEFT JOIN CostVarPeriod ON (LMSBillDetail.CostUnit = CostVarPeriod.CostUnit AND LMSBillDetail.CostCenterFID = CostVarPeriod.CostCenterFID AND LMSBillDetail.CostCenterSub = CostVarPeriod.CostCenterSub AND LMSBillDetail.FKidLocation = CostVarPeriod.FKidLocation) LEFT JOIN Customer ON Customer.FID = LMSBillDetail.CustomerF 130114 8:52:46 [Warning] Slave: Got error -1 from storage engine Error_code: 1030 130114 8:52:46 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin-log.000845' position 43817180 130114 8:53:42 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 130114 8:53:42 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin-log.000864' at position 140398337 130114 8:53:43 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001036' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130114 8:53:43 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 130114 8:54:43 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 130114 8:54:43 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin-log.000864' at position 214616969 130114 8:54:44 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001037' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130114 8:54:44 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 130114 8:55:44 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 130114 8:55:44 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin-log.000864' at position 321491898 130114 8:56:19 [ERROR] /usr/libexec/mysqld: Disk is full writing '/var/lib/mysqllogs/relay-log.001043' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) 130114 8:56:19 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs 130114 8:57:19 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000845' at position 43817180, relay log '/var/lib/mysqllogs/relay-log.000978' position: 14680104 130114 8:57:19 [ERROR] /usr/libexec/mysqld: Disk is full writing130114 10:14:14 [Note] Slave I/O thread exiting, read up to log 'bin-log.000866', position 233472415 130114 10:14:44 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000845' at position 51735737, relay log '/var/lib/mysqllogs/relay-log.000978' position: 22598661 130114 10:14:44 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000866' at position 233472415 130114 10:15:03 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000845' at position 97170631 130114 10:15:03 [Note] Slave I/O thread exiting, read up to log 'bin-log.000867', position 9261438 130114 10:15:42 [Note] /usr/libexec/mysqld: Normal shutdown 130114 10:15:42 [Note] Event Scheduler: Purging the queue. 0 events 130114 10:15:46 InnoDB: Starting shutdown... 130114 10:15:48 InnoDB: Shutdown completed; log sequence number 1 416724040 130114 10:15:48 [Note] /usr/libexec/mysqld: Shutdown complete 130114 10:15:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 130114 10:18:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130114 10:18:45 InnoDB: Initializing buffer pool, size = 128.0M 130114 10:18:45 InnoDB: Completed initialization of buffer pool 130114 10:18:46 InnoDB: Started; log sequence number 1 416724040 130114 10:18:46 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:18:46 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:18:46 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000845' at position 97170631, relay log '/var/lib/mysqllogs/relay-log.000978' position: 68033555 130114 10:18:46 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000867' at position 9261438 130114 10:18:46 [Note] Event Scheduler: Loaded 0 events 130114 10:18:46 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130114 10:41:20 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000847' at position 494283760 130114 10:41:20 [Note] Slave I/O thread killed while reading event 130114 10:41:20 [Note] Slave I/O thread exiting, read up to log 'bin-log.000897', position 545388743 130114 10:41:30 [Note] /usr/libexec/mysqld: Normal shutdown 130114 10:41:30 [Note] Event Scheduler: Purging the queue. 0 events 130114 10:41:41 InnoDB: Starting shutdown... 130114 10:41:49 InnoDB: Shutdown completed; log sequence number 1 416724060 130114 10:41:49 [Note] /usr/libexec/mysqld: Shutdown complete 130114 10:41:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 130114 10:44:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130114 10:45:00 InnoDB: Initializing buffer pool, size = 128.0M 130114 10:45:00 InnoDB: Completed initialization of buffer pool 130114 10:45:00 InnoDB: Started; log sequence number 1 416724060 130114 10:45:00 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:45:00 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:45:01 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000847' at position 494283760, relay log '/var/lib/mysqllogs/relay-log.000983' position: 494283903 130114 10:45:01 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000897' at position 545388743 130114 10:45:01 [Note] Event Scheduler: Loaded 0 events 130114 10:45:01 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130114 10:46:54 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000847' at position 599609831 130114 10:46:54 [Note] Slave I/O thread killed while reading event 130114 10:46:54 [Note] Slave I/O thread exiting, read up to log 'bin-log.000897', position 545438611 130114 10:47:05 [Note] /usr/libexec/mysqld: Normal shutdown 130114 10:47:05 [Note] Event Scheduler: Purging the queue. 0 events 130114 10:47:12 InnoDB: Starting shutdown... 130114 10:47:16 InnoDB: Shutdown completed; log sequence number 1 416724070 130114 10:47:16 [Note] /usr/libexec/mysqld: Shutdown complete 130114 10:47:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 130114 10:50:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130114 10:50:16 InnoDB: Initializing buffer pool, size = 128.0M 130114 10:50:16 InnoDB: Completed initialization of buffer pool 130114 10:50:17 InnoDB: Started; log sequence number 1 416724070 130114 10:50:17 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:50:17 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 10:50:17 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000847' at position 599609831, relay log '/var/lib/mysqllogs/relay-log.000983' position: 599609974 130114 10:50:17 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000897' at position 545438611 130114 10:50:17 [Note] Event Scheduler: Loaded 0 events 130114 10:50:17 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130114 14:38:42 [Note] Slave SQL thread exiting, replication stopped in log 'bin-log.000866' at position 601356315 130114 14:38:42 [Note] Slave I/O thread killed while reading event 130114 14:38:42 [Note] Slave I/O thread exiting, read up to log 'bin-log.000897', position 567041666 130114 14:38:53 [Note] /usr/libexec/mysqld: Normal shutdown 130114 14:38:53 [Note] Event Scheduler: Purging the queue. 0 events 130114 14:45:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130114 14:45:17 InnoDB: Initializing buffer pool, size = 128.0M 130114 14:45:17 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130114 14:45:17 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: Last MySQL binlog file position 0 59903237, file name /var/log/mysql/bin-log.000533 130114 14:45:18 InnoDB: Started; log sequence number 1 416724080 130114 14:45:18 [Warning] 'user' entry 'root@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 14:45:18 [Warning] 'user' entry '@RZ-CSMED11' ignored in --skip-name-resolve mode. 130114 14:45:18 [Note] Slave SQL thread initialized, starting replication in log 'bin-log.000866' at position 601356315, relay log '/var/lib/mysqllogs/relay-log.001044' position: 367884150 130114 14:45:18 [Note] Slave I/O thread: connected to master 'repl@rz-csmed12:3306',replication started in log 'bin-log.000897' at position 567041666 130114 14:45:18 [Note] Event Scheduler: Loaded 0 events 130114 14:45:18 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 130114 14:45:58 [ERROR] Got error 134 when reading table './CSMedNWD/LMSLabDetail' 130114 14:45:58 [ERROR] Slave SQL: Error 'Got error 134 from storage engine' on query. Default database: 'CSMedNWD'. Query: 'INSERT INTO LMSPTypeLabDiv ( FKidLocation, PractType, LabDivisionFID, ArcYear, ArcMonth, Cnt ) SELECT C.FKidLocation, C.PractType, L.LabDivisionFID, L.ArcYear, L.ArcMonth, SUM(L.Cnt) FROM LMSLabDetail AS L INNER JOIN Customer AS C ON C.FID = L.CustomerFID AND C.FKidLocation = L.FKidLocation WHERE L.FKidLocation = '13' AND L.ArcYear = '2012' AND L.ArcMonth = '11' AND L.LabGroup != 'LG' GROUP BY C.PractType, L.LabDivisionFID, L.ArcYear, L.ArcMonth', Error_code: 1030 130114 14:45:58 [Warning] Slave: Got error 134 from storage engine Error_code: 1030 130114 14:45:58 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin-log.000866' position 601368558