Bitcoin Forum
June 14, 2024, 04:15:56 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Delete  (Read 1710 times)
gweedo (OP)
Legendary
*
Offline Offline

Activity: 1498
Merit: 1000


View Profile
June 22, 2014, 04:04:33 AM
Last edit: June 22, 2014, 03:21:44 PM by gweedo
 #1

Delete
Bitsky
Hero Member
*****
Offline Offline

Activity: 576
Merit: 514


View Profile
June 22, 2014, 07:28:46 AM
 #2

InnoDB is a pain when it comes to errors.

It looks like a sequence counter was reset and now the engine spits out errors.
Maybe you can fix it by shoveling in GB of data:
http://dba.stackexchange.com/questions/8011/any-better-way-out-of-mysql-innodb-log-in-the-future

Or you could try to recover the data and do a import to a clean database:
http://www.percona.com/software/mysql-innodb-data-recovery-tools
http://www.chriscalender.com/?p=49

How big is the database? Maybe it would be easier to just roll in the most recent backup; or dump from a slave.

Bounty: Earn up to 68.7 BTC
Like my post? Feel free to drop a tip to 1BitskyZbfR4irjyXDaGAM2wYKQknwX36Y
mike29
Newbie
*
Offline Offline

Activity: 22
Merit: 0


View Profile
June 22, 2014, 09:47:45 AM
 #3

this is was an attack  there is no such kind of error! just tell me where your data base is hosted ?
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!