Exciting new Replication Error

[Eric]

Slave SQL thread initialized, starting replication in log 'www200-bin.008' at position 38717817, relay log './s142-17-103-3-relay-bin.056' position: 9212273
021114 16:34:12 Error in Log_event::read_log_event(): 'read error', data_len=161,event_type=2
021114 16:34:12 Slave SQL thread: I/O error reading event(errno: -1 cur_log->error: 122)
021114 16:34:12 Error reading relay log event: Aborting slave SQL thread because of partial event read
021114 16:34:12 Could not parse log event entry, check the master for binlog corruption
This may also be a network problem, or just a bug in the master or slave code.
021114 16:34:12 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'www200-bin.008' position 38717817
021114 16:34:12 Slave SQL thread exiting, replication stopped in log 'www200-bin.008' at position 38717817
021114 16:34:17 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'www200-bin.008' at position 38748768


I don't have a clue what this could mean. I had a screw up where I made a unique index on the master, but the database table on the slave had data that was not unique while the master data was unique. I backed up the table on the slave, deleted the data from the master table, deleted the data from the slave table, restarted the slave, it worked, removed both indexes on the slave and master... Then I copied the data back to the slave table. Now I get the above messages, and typing either slave start, or slave stop hangs endlessly.

Thanks,


Eric

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php