I still have this problem with replication, and i dont know how to fix it.
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).
I have attached my "SHOW SLAVE STATUS;" from the problem machine.
I have tried dropping the database, rebooting the machine, and creating a
new database, no success.
Please let me know if I need to supply more info, I have no idea on what to
do next.
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
................................
+--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File |
Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File
| Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db |
Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space |
+--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
| 172.16.1.103 | dba | 3306 | 60 | mysql-bin.037 |
11894440 | waspstat1-relay-bin.001 | 4 | mysql-bin.037
| Yes | Yes | | | 0
| | 0 | 11894440 | 4 |
+--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
