…is disconnected with my application. The error is given below. Because there …mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql… at biopayroll.rep_emp_attendance_register$4.actionPerformed(rep_emp_attendance_register.java…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… session: transaction2 > START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(29); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction transaction2…, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the… 94 95 96 97 98 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is…
Post: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
… to see MySQL 5.4.2 in the funny state. When you see bug happening you would see MySQL log flooded with error messages like this: 091119 23:03:34 [ERROR] Error in accept: Resource temporarily unavailable 091119 23:03:34 [ERROR] Error… [ERROR] Error in accept: Resource temporarily unavailable filling out disk space Depending on the case you may be able to connect to MySQL…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… setting up ext2/3/4 file system is sticking to defaults when it comes to behavior on errors. By default these filesystems… good for system running mySQL Server. As far as I understand this problem is limited to EXT2/3/4 while over systems… to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now lets…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… glad to announce the release of Percona XtraBackup 1.6.4 on 19 December, 2011 (Downloads are available here and from… xtrabackup binary against more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona… not check that MySQL datadir was empty before –copy-back was run. With this bug fix, innobackupex will now error out of…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which…of size 8 at 0xff27758 by thread #4 ==9090== at 0x6B67C51: log_io_complete (sync0sync.ic…(os0file.c:4408) ==9090== by 0x6BC459F: srv_error_monitor_thread (srv0srv.c:1673) ==9090== by …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… existed for basically forever in Innodb (the MySQL manual discusses it back in the 4.1 manual), and is from a time… itself dumps the contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== 090420 12:09:32…_VARCHAR DATA_ENGLISH len 0; N_COLS: DATA_INT len 4; DB_ROW_ID: DATA_SYS prtype 256 len 6; DB…
Post: DBD::mysql 4.014 breaks pt-table-checksum 2.0
February 21, 2012 By Leave a Comment
…::mysql 4.014 breaks pt-table-checksum 2.0. The cause is unknown, but the effect is a lot of errors like: DBD::mysql…::mysql to any version except 4.014. To see which version of DBD::mysql a system has, execute: perl -MDBD::mysql -e ‘print $DBD::mysql…. It seems, although I have not verified this, that DBD::mysql 4.014 has some sort of caching mechanism which causes it…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB: Error: tablespace id… Page Header Name Size Description FIL_PAGE_SPACE_OR_CHKSUM 4 /* in < MySQL-4.0.14 space id the page belongs to (== 0… ibdata was updated MySQL will fail to start with error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to add…
