问题描述:开启ogg投递进程时报错OGG-01224,如下所示:
1、异常重现
GGSCI (leo-oracle-19c) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:02
EXTRACT ABENDED PUMYSQL 00:00:00 04:54:03
GGSCI (leo-oracle-19c) 4> start pumysql
Sending START request to Manager ...
Extract group PUMYSQL starting.
GGSCI (leo-oracle-19c) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:08
EXTRACT ABENDED PUMYSQL 00:00:00 04:54:09
2024-07-16 21:52:54 ERROR OGG-01224 TCP/IP error 113 (No route to host), endpoint: 192.168.133.35:7810.
2024-07-16 21:52:54 ERROR OGG-01668 PROCESS ABENDING.
2、异常原因
目标端防火墙开启导致,目标端防火墙状态如下:
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2024-07-16 20:10:09 CST; 1h 44min ago
Docs: man:firewalld(1)
Main PID: 885 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─885 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid
Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Hint: Some lines were ellipsized, use -l to show in full.
3、解决方案
--关闭目标端防火墙
[root@leo-mysql-ogg ~]# systemctl stop firewalld
[root@leo-mysql-ogg ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@leo-mysql-ogg ~]#
[root@leo-mysql-ogg ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
Jul 16 20:10:06 leo-mysql-ogg systemd[1]: Starting firewalld - dynamic firewall daemon...
Jul 16 20:10:09 leo-mysql-ogg systemd[1]: Started firewalld - dynamic firewall daemon.
Jul 16 20:10:10 leo-mysql-ogg firewalld[885]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be remo...g it now.
Jul 16 21:55:12 leo-mysql-ogg systemd[1]: Stopping firewalld - dynamic firewall daemon...
Jul 16 21:55:16 leo-mysql-ogg systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.
--重启源端投递进程
GGSCI (leo-oracle-19c) 10> start pumysql
Sending START request to Manager ...
Extract group PUMYSQL starting.
GGSCI (leo-oracle-19c) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:06
EXTRACT RUNNING PUMYSQL 00:00:00 04:56:59
GGSCI (leo-oracle-19c) 12> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:01
EXTRACT RUNNING PUMYSQL 00:00:00 00:00:01
GGSCI (leo-oracle-19c) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTORCL 00:00:00 00:00:08
EXTRACT RUNNING PUMYSQL 00:00:00 00:00:09
说明:如下所示,源端投递进程成功开启.
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.
- 52.
- 53.
- 54.
- 55.
- 56.
- 57.
- 58.
- 59.
- 60.
- 61.
- 62.
- 63.
- 64.
- 65.
- 66.
- 67.
- 68.
- 69.
- 70.
- 71.
- 72.
- 73.
- 74.
- 75.
- 76.
- 77.
- 78.
- 79.
- 80.
- 81.
- 82.
- 83.
- 84.
- 85.
- 86.
- 87.
- 88.
- 89.
- 90.
- 91.
- 92.
- 93.
- 94.
- 95.
- 96.
- 97.
- 98.
- 99.
- 100.