|
Replication event checksum verification failed while reading from network
|
|||
---|---|---|---|
#18+
На мастере удалили бинлоги старые, после этого на реплике получаю такую ошибку: 190419 7:58:50 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.022615' at position 267490449, relay log './mysqld-relay-bin.000001' position: 4 190419 7:58:50 [Note] Slave I/O thread: connected to master 'replication@x.x.x.x:3306',replication started in log 'mysql-bin.022615' at position 267490449 190419 7:58:51 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network. Internal MariaDB error code: 1743 190419 7:58:51 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595 190419 7:58:51 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.022615', position 267521588 190419 7:58:57 [Note] Slave I/O thread: connected to master 'replication@x.x.x.x:3306',replication started in log 'mysql-bin.022615' at position 267521588 190419 7:58:58 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network. Internal MariaDB error code: 1743 190419 7:58:58 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595 190419 7:58:58 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.022615', position 267521588 Пробовал сделать [quote] slave stop; slave reset all; set global binlog_checksum=NONE; set global slave_sql_verify_checksum=0; CHANGE MASTER TO MASTER_HOST='x.x.x.x', MASTER_USER='replication', MASTER_PASSWORD='nments', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.022615', MASTER_LOG_POS=267490449, MASTER_CONNECT_RETRY=10; ... |
|||
:
Нравится:
Не нравится:
|
|||
19.04.2019, 08:07 |
|
Replication event checksum verification failed while reading from network
|
|||
---|---|---|---|
#18+
Не дописал, случайно отправилось slave stop; slave reset all; set global binlog_checksum=NONE; set global slave_sql_verify_checksum=0; CHANGE MASTER TO MASTER_HOST='x.x.x.x', MASTER_USER='replication', MASTER_PASSWORD='nments', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.022615', MASTER_LOG_POS=267490449, MASTER_CONNECT_RETRY=10; start slave Но ошибка та же. бинлог mysql-bin.022615 на мастере еще есть. Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04 Можно как-то запустить репликацию ? ... |
|||
:
Нравится:
Не нравится:
|
|||
19.04.2019, 08:09 |
|
Replication event checksum verification failed while reading from network
|
|||
---|---|---|---|
#18+
Есть еще вариант что побился сам бинлог, тк удалили старые из-за того что на сервере закончилось место. ... |
|||
:
Нравится:
Не нравится:
|
|||
19.04.2019, 08:14 |
|
Replication event checksum verification failed while reading from network
|
|||
---|---|---|---|
#18+
Да бинлог битый Event crc check failed! Most likely there is event corruption.' at offset: 267521588 data_len: 1034 event_type: 23 Те видимо реплику надо с нуля восстанавливать ... |
|||
:
Нравится:
Не нравится:
|
|||
19.04.2019, 09:14 |
|
|
start [/forum/topic.php?fid=47&fpage=36&tid=1829184]: |
0ms |
get settings: |
8ms |
get forum list: |
13ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
40ms |
get topic data: |
13ms |
get forum data: |
3ms |
get page messages: |
37ms |
get tp. blocked users: |
2ms |
others: | 313ms |
total: | 435ms |
0 / 0 |