FAQ.caslavka.cz

ID #1268

according to:
Client asks master to start replication from impossible position
MySQL replication dies with fatal error 1236: Client requested master to start replication from impossible position

usually caused by crashed master - it lost binlog cache from memory and started new binlog file

1) inspect situation
- sql command "START SLAVE" returns no error
- sql command "SHOW SLAVE STATUS" shows "Read_Master_Log_Pos" bigger than master binlog filesize (located on MASTER) - eg. mysql-bin.001468

2) check next binlog file (on MASTER)

SHOW BINLOG EVENTS in 'mysqld-bin.001469' from 0 LIMIT 10;

3) start SLAVE from next binlog

slave stop;
CHANGE MASTER TO MASTER_LOG_FILE='mysqld-bin.001469', MASTER_LOG_POS=4;
slave start;

Můžete ohodnotit tuto odpověď:

Průměrné hodnocení: 0 (0 Votes)

naprosto nepoužitelná 1 2 3 4 5 velmi užitečná

komentář k odpovědi

Jméno:
E-mailová adresa:
Komentář:

Prosím, opište všechny znaky z obrázku