Hi,
We have 2 MySQL 4.0.16 with replication enabled (M -> S), only InnoDB
tables.
We're getting "Error reading packet from server: Client requested master to
start replication from impossible position (server_errno=1236)" in the
slave.
The master server had a problem... when it came back (with success) the log
have:
"031210 15:19:24 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 3 4169000545
InnoDB: Doing recovery: scanned up to log sequence number 3 4171205097
031210 15:19:25 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 458600006, file name
./SV07-bin.008
031210 15:19:43 InnoDB: Flushing modified pages from the buffer pool...
031210 15:19:51 InnoDB: Started"
But in the slave log:
"031210 17:02:36 Slave: connected to master 'xxxx@xxxx:xxx',replication
resumed in log 'SV07-bin.008' at position 458600006
031210 17:02:36 Error reading packet from server: Client requested master
to start replication from impossible position (server_errno=1236)
031210 17:02:36 Got fatal error 1236: 'Client requested master to start
replication from impossible position' from master when reading data from
binary log
031210 17:02:36 Slave I/O thread exiting, read up to log 'SV07-bin.008',
position 458600006"
With "show master status" (on master) I get:
File = SV07-bin.009
Position = 456371766
And with "show slave status" (on slave) I get:
Master_log_file = SV07-bin.008
Read_master_log_pos = 458600006
Relay_log_file = SV08-relay-bin.011
Relay_log_pos = 458600084
Relay_master_log = SV07-bin.008
Slave_io_running = no
Slave_sql_running = yes
Exec_master_log_pos = 458600006
Relay_log_space = 458600084
Is SV07-bin.008 corrupted? How can I debug?
Thanks,
Eduardo
| Thread |
|---|
| • Replication error (1236 - impossible position on slave) | Eduardo D Piovesam | 11 Dec |