社区版本
obbinlog 4.2.3
obproxy 4.3.3.0-5
observer 4.2.5.1
业务测试环境,QPS TPS较高 3K左右
4号发生自动重启
201 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 4'
-rw------- 1 admin admin 1.5G Mar 4 07:46 core.35194
204 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 4'
-rw------- 1 admin admin 1.6G Mar 4 04:55 core.29368
215 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 4'
-rw------- 1 admin admin 1.3G Mar 4 09:22 core.450082
-rw------- 1 admin admin 1.3G Mar 4 01:22 core.454216
3号发生自动重启
201 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 3'
-rw------- 1 admin admin 1.4G Mar 3 04:54 core.14723
-rw------- 1 admin admin 1.3G Mar 3 12:55 core.24189
204 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 3'
-rw------- 1 admin admin 1.5G Mar 3 04:54 core.178091
215 obproxy
ll -h /home/admin/obproxy/ | grep 'Mar 3'
-rw------- 1 admin admin 1.4G Mar 3 17:22 core.414236
-rw------- 1 admin admin 1.2G Mar 3 04:55 core.418686
mysql->OB drc同步中断
目标端 执行sql出现错误!io.ReadFull(header) failed. err EOF: connection was bad,Table [biz_trace_log -> biz_trace_log]
生产环境低版本没自动重启过
obproxy 4.2.3
observer 4.2.2
测试环境有obbinlog,日志里有同步obbinlog连接失败,是否和这连接失败有关?
obproxy日志
obproxy.log 日志看不出异常
less obproxy_error.log 有大量同步binlog连接失败
2025-03-03 12:55:55.769488,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1763us,452us,0us,1247us,Y0-00007F99F0CD5390,,xxxxx.131.130:27904,,0,xxxxx.183.204:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:55.869378,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1941us,463us,0us,1419us,Y0-00007F99F0ED51D0,,xxxxx.131.130:27908,,0,xxxxx.183.204:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:55.969409,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1749us,435us,0us,1258us,Y0-00007F99F0CD5390,,xxxxx.131.130:27912,,0,xxxxx.183.204:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.045737,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1777us,388us,0us,1320us,Y0-00007F99F0ED51D0,,xxxxx.131.130:27930,,0,xxxxx.183.201:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.046422,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1551us,243us,0us,1244us,Y0-00007F99F0CD5390,,xxxxx.131.130:27920,,0,xxxxx.183.201:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.129619,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1868us,395us,0us,1400us,Y0-00007F99F0ED51D0,,xxxxx.131.130:27932,,0,xxxxx.183.201:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.245444,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1783us,470us,0us,1254us,Y0-00007F99F0CD5390,,xxxxx.131.130:27940,,0,xxxxx.183.204:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.326802,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1949us,457us,0us,1435us,Y0-00007F99F0ED51D0,,xxxxx.131.130:27944,,0,xxxxx.183.215:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.393855,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1761us,474us,0us,1220us,Y0-00007F99F0CD5390,,xxxxx.131.130:27952,,0,xxxxx.183.204:2881,Access denied for us
er '这是同步binlog账号'@'xxx.xxx.xxx.xxx' (using password: YES),
2025-03-03 12:55:56.393855,myproxy2,,,,obtest42:mysql:,OB_MYSQL,,,OB_MYSQL_COM_LOGIN,,failed,1045,,1707us,411us,0us,1220us,Y0-00007F99F0ED51D0,,xxxxx.131.130:27948,,0,xxxxx.183.204:2881,Access denied for us
:
obbinlog日志
cd /data/binlogservice/log
[root@xxxx-0005 log]# ll -h
total 1.5G
-rw-r--r-- 1 root root 2.2K Feb 27 11:13 deploy.log
-rw-r--r-- 1 root root 3.0K Feb 27 11:13 logproxy.20250227.111312104.log.gz
-rw-r--r-- 1 root root 993M Mar 4 12:13 logproxy.log
-rw-r--r-- 1 root root 4.4K Feb 27 11:13 out.log
[root@xxxx-0005 log]#
[root@xxxx-0005 log]# grep -i 'error|ediag' ./*.log
该mysql2租户 binlog实例里有warning日志,没有error|ediag级别日志
cd /data/binlogservice/run/sx8day4gzh/log
[root@xxxxx-0005 log]# grep -i 'error|ediag' ./*.log
[root@xxxxx-0005 log]#
[root@xxxxx-0005 log]#
grep -v 'info' binlog_instance.log | less
[2025-03-04 12:15:35.033612] [warning] binlog_dumper.cpp(855): [f67e3dea607b623dda281311b7d1c5bf][OBI][ddw_replica@mysql2#obtest42,obtest42,mysql2]xxxxx.131.151:8100-xxxxx.183.204:40322/118: The content of the current binlog event is incomplete, and the expected file length is 208556047
[2025-03-04 12:15:35.034474] [warning] binlog_dumper.cpp(855): [8948c154b6ea51cd54ceff9214766f1c][OBI][ddw_replica@mysql2#obtest42,obtest42,mysql2]xxxxx.131.151:8100-xxxxx.183.204:49428/103: The content of the current binlog event is incomplete, and the expected file length is 208567980
[2025-03-04 12:15:35.034900] [warning] binlog_dumper.cpp(837): [a5c06657d1105d1a8b17175aa322ec][OBI][ddw_replica@mysql2#obtest42,obtest42,mysql2]xxxxx.131.151:8100-xxxxx.183.201:63690/87: The content of the current binlog event header is incomplete, and the expected file length is 208580617,the actual value is 208580608
[2025-03-04 12:16:54.914687] [warning] binlog_dumper.cpp(855): [9d2ade96f2a27c73db10b44357e58213][OBI][ddw_replica@mysql2#obtest42,obtest42,mysql2]xxxxx.131.151:8100-xxxxx.183.204:40318/109: The content of the current binlog event is incomplete, and the expected file length is 208621576
[2025-03-04 12:18:00.272953] [warning] binlog_dumper.cpp(837): [90fd18283623a1f6c45479a42ec5c5a][OBI][ddw_replica@mysql2#obtest42,obtest42,mysql2]xxxxx.131.151:8100-xxxxx.183.201:62078/102: The content of the current binlog event header is incomplete, and the expected file length is 208629771,the actual value is 208629760
binlog_instance_libobcdc.tar.gz (11.5 MB)
201_obproxy_crash.log (19.6 MB)
core.23577.tar.gz (38.3 MB)
gdb分析的03,04号重启时的core文件结果
gdb-output03_23_46.log (6.8 KB)
gdb-output04_15_47.log (6.8 KB)
obinlog服务器信息
cat /etc/issue
\S
Kernel \r on an \m
uname -r
5.4.210-4.ve1.x86_64
cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
obproxy服务器信息
uname -r
3.10.0-957.el7.x86_64
cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
cat /etc/issue
\S
Kernel \r on an \m