No its Redhat, and i have made absolutly no updates :( -----Original Message----- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: 8. oktober 2003 15:23 To: Søren Neigaard Cc: '[EMAIL PROTECTED]' Subject: Re: Sudden error when replicationg - please help
you are not using Debian testing by any chance? If so last time I did an apt-get upgrade it broke mysql and I fixed it by doing a reinstall. On Wed, 2003-10-08 at 14:13, Søren Neigaard wrote: > I have a slave that has been running for a long time without any problems, > but now its not replicating any more. So I tried to do a "LOAD DATA MASTER;" > which always gives me this error now: > > Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: > 3306 > 031008 15:07:59 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at > position 357019 > 031008 15:08:14 Slave I/O thread exiting, read up to log 'mysql-bin.006', > position 357019 > 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number > of deleted records > 031008 15:08:14 Run recovery again without -q > 031008 15:08:14 Note: Retrying repair of: './otamanager/otafrontenduser' > with keycache > 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number > of deleted records > 031008 15:08:14 Run recovery again without -q > 031008 15:08:14 Note: Retrying repair of: './otamanager/profile' with > keycache > 031008 15:08:16 Slave I/O thread: connected to master > '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at > position 357019 > > I have tried to do a "REPAIR TABLE otafrontenduser,profile EXTENDED;" but no > success (its says ok, but the replication does still not work). > > Why and what are these errors, and what can I do? > > Med venlig hilsen/Best regards > Søren Neigaard > System Architect > ................................ > Mobilethink A/S > Arosgaarden > Åboulevarden 23, 4.sal > DK - 8000 Århus C > Telefon: +45 86207800 > Direct: +45 86207810 > Fax: +45 86207801 > Email: [EMAIL PROTECTED] > Web: www.mobilethink.dk > ................................ -- **************************************************************** * Ben Edwards Tel +44 (0)1179 553 551 ICQ 42000477 * * Homepage - nothing of interest here http://gurtlush.org.uk * * Webhosting for the masses http://www.serverone.co.uk * * Critical Site Builder http://www.criticaldistribution.com * * online collaborative web authoring content management system * * Get alt news/views films online http://www.cultureshop.org * * i-Contact Progressive Video http://www.videonetwork.org * * Fun corporate graphics http://www.subvertise.org * * Bristol Indymedia http://bristol.indymedia.org * * Bristol's radical news http://www.bristle.org.uk * **************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
