我搭建了一套基于半同步復制的主從架構但是在系統運行的程序中主庫會莫名其妙 crash
mysql 版本 8.0.21
主庫的 mysqld.log 日志
2021-01-10T16:05:28.228747+08:00 576 [ERROR] [MY-011161] [Server] Semi-sync master failed on net_flush() before waiting for slave reply.
2021-01-10T16:05:28.232772+08:00 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001158 - Got an error reading communication packets
2021-01-10T16:05:28.233979+08:00 577 [ERROR] [MY-011161] [Server] Semi-sync master failed on net_flush() before waiting for slave reply.
2021-01-10T16:05:28.237914+08:00 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001158 - Got an error reading communication packets
2021-01-10T16:05:29.239638+08:00 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001158 - Got an error reading communication packets
08:05:29 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x213b8ad]
/usr/sbin/mysqld(handle_fatal_signal+0x313) [0xff5083]
/lib64/libpthread.so.0(+0xf630) [0x7f71a7d37630]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
從庫的mysqld.log 日志
2021-01-10T16:05:29.499786+08:00 405170 [ERROR] [MY-010557] [Repl] Error reading packet from server for channel 'my_sr02': Lost connection to MySQL server during query (server_errno=2013)
2021-01-10T16:05:29.499847+08:00 405170 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2021-01-10T16:05:29.500007+08:00 405170 [ERROR] [MY-010584] [Repl] Slave I/O for channel 'my_sr02': error reconnecting to master '[email protected]:3306' - retry-time: 60 retries: 1 message: Can't connect to MySQL server on '10.2.20.2' (111), Error_code: MY-002003
2021-01-10T16:06:29.500822+08:00 405170 [System] [MY-010592] [Repl] Slave for channel 'my_sr02': connected to master '[email protected]:3306',replication resumed in log 'binlog.000003' at position 1884879
求教各位大佬這是什么問題導致的,如何解決
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/247411.html
標籤：MySQL
上一篇：MySqlHelper.ExecuteNonQuery(MySqlConnection connection...只能執行一次？
下一篇：求大佬救救俺