Tag Archives: error mysql

[Solved] Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘event read from binlog did not pass crc check; the first event

mysql copy error from the library:

Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'event read from binlog did not pass crc check; the first event '' at 4, the last event read from './mysql-bin.031260' at 506629253, the last byte read from './mysql-bin.031260' at 506637422.'

 

Check the log file on the main library:

mysqlbinlog --verify-binlog-checksum /data/mysqldb/mysql-bin.031260

 

Error:

ERROR: Error in Log_event::read_log_event(): 'Event crc check failed! Most likely there is event corruption.', data_len: 8169, event_type: 30
ERROR: Could not read entry at offset 506629253: Error in log format or read error.
WARNING: The range of printed events ends with a row event or a table map event that does not have the STMT_END_F flag set.
This might be because the last statement was not fully written to the log, or because you are using a --stop-position or --stop-datetime that refers to an event in the middle of a statement.
The event(s) from the partial statement have not been written to output.

 

It can be seen that there is a problem with the binlog on the main library, so this can only be rebuilt from the library. Rebuild master-slave replication.

If there is no error in the verification on the main library, you can disable verification on the slave library to solve the problem:

stop slave;

set global binlog_checksum=0;

start slave;

 

Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’

Using druid to connect to MySQL and report errors: errorcode 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’ using password:yes

At first, we checked the account password or permissions. However, we found that all the configurations were correct. As a result, we found that db.properties There are a few more spaces in the user and password , for a long time, take warning, later configuration must pay attention to the space