EPAP GUI : View RTDB Shows Not Connected to PDBA

Asset ID:	1-71-2288055.1
Update Date:	2017-08-07
Keywords:

Solution Type Technical Instruction Sure

Solution 2288055.1 : EPAP GUI : View RTDB Shows Not Connected to PDBA

Applies to:

Oracle Communications EAGLE (Software) - Version EPAP 15.0 and later
Information in this document applies to any platform.

Goal

One of the non-provisionned EPAP sites in customer network shows PDBA status as "not connected" in View RTDB section of EPAP GUI. The servers are taking updates and db is all coherent state.

While login to GUI and selecting the view rtdb shows that the "not connected to PDBA" for both the PDB addresses.

Solution

Restart the "gs" process and the issue resolved. Now the "view rtdb " option display both the remote PDBA.

[root@mps-aqp-a ~]# ps -ef | grep gs
root 4504 1 0 2015 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/TKLC/epap/db/pdb --port=3307 --socket=/var/TKLC/epap/db/pdb/mysql.sock --pid-file=/var/TKLC/epap/db/pdb/mysqld.pid --set-variable=wait_timeout=86400 --set-variable=max_connections=300 --user=mysql --innodb_data_home_dir=/var/TKLC/epap/db/pdb --innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G;ibdata9:2G;ibdata10:2G;ibdata11:2G;ibdata12:2G;ibdata13:2G;ibdata14:2G;ibdata15:2G;ibdata16:2G;ibdata17:2G;ibdata18:2G;ibdata19:2G;ibdata20:2G;ibdata21:2G;ibdata22:2G;ibdata23:2G;ibdata24:2G;ibdata25:2G --innodb_log_group_home_dir=/var/TKLC/epap/db/pdb --innodb_log_arch_dir=/var/TKLC/epap/db/pdb --set-variable=innodb_mirrored_log_groups=1 --set-variable=innodb_log_files_in_group=2 --set-variable=innodb_log_file_size=64M --set-variable=innodb_log_buffer_size=8M --set-variable=innodb_buffer_pool_size=128M --long_query_time=1 --log-slow-queries=/var/TKLC/epap/logs/slow-queries.log --innodb_flush_log_at_trx_commit=1 --innodb_log_archive=0 --set-variable=innodb_additional_mem_pool_size=2M --set-variable=innodb_file_io_threads=4 --set-variable=innodb_lock_wait_timeout=50
mysql 4587 4504 0 2015 ? 00:01:18 /usr/sbin/mysqld --basedir=/ --datadir=/var/TKLC/epap/db/pdb --user=mysql --pid-file=/var/TKLC/epap/db/pdb/mysqld.pid --skip-locking --set-variable=wait_timeout=86400 --set-variable=max_connections=300 --innodb_data_home_dir=/var/TKLC/epap/db/pdb --innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G;ibdata9:2G;ibdata10:2G;ibdata11:2G;ibdata12:2G;ibdata13:2G;ibdata14:2G;ibdata15:2G;ibdata16:2G;ibdata17:2G;ibdata18:2G;ibdata19:2G;ibdata20:2G;ibdata21:2G;ibdata22:2G;ibdata23:2G;ibdata24:2G;ibdata25:2G --innodb_log_group_home_dir=/var/TKLC/epap/db/pdb --innodb_log_arch_dir=/var/TKLC/epap/db/pdb --set-variable=innodb_mirrored_log_groups=1 --set-variable=innodb_log_files_in_group=2 --set-variable=innodb_log_file_size=64M --set-variable=innodb_log_buffer_size=8M --set-variable=innodb_buffer_pool_size=128M --long_query_time=1 --log-slow-queries=/var/TKLC/epap/logs/slow-queries.log --innodb_flush_log_at_trx_commit=1 --innodb_log_archive=0 --set-variable=innodb_additional_mem_pool_size=2M --set-variable=innodb_file_io_threads=4 --set-variable=innodb_lock_wait_timeout=50
root 5483 644 0 05:11 pts/0 00:00:00 grep gs
epapdev 8069 7964 0 2015 ? 00:31:29 /opt/TKLCappl/bin/gs
[root@mps-aqp-a ~]# pkill gs
[root@mps-aqp-a ~]# ps -ef | grep gs
root 4504 1 0 2015 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/TKLC/epap/db/pdb --port=3307 --socket=/var/TKLC/epap/db/pdb/mysql.sock --pid-file=/var/TKLC/epap/db/pdb/mysqld.pid --set-variable=wait_timeout=86400 --set-variable=max_connections=300 --user=mysql --innodb_data_home_dir=/var/TKLC/epap/db/pdb --innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G;ibdata9:2G;ibdata10:2G;ibdata11:2G;ibdata12:2G;ibdata13:2G;ibdata14:2G;ibdata15:2G;ibdata16:2G;ibdata17:2G;ibdata18:2G;ibdata19:2G;ibdata20:2G;ibdata21:2G;ibdata22:2G;ibdata23:2G;ibdata24:2G;ibdata25:2G --innodb_log_group_home_dir=/var/TKLC/epap/db/pdb --innodb_log_arch_dir=/var/TKLC/epap/db/pdb --set-variable=innodb_mirrored_log_groups=1 --set-variable=innodb_log_files_in_group=2 --set-variable=innodb_log_file_size=64M --set-variable=innodb_log_buffer_size=8M --set-variable=innodb_buffer_pool_size=128M --long_query_time=1 --log-slow-queries=/var/TKLC/epap/logs/slow-queries.log --innodb_flush_log_at_trx_commit=1 --innodb_log_archive=0 --set-variable=innodb_additional_mem_pool_size=2M --set-variable=innodb_file_io_threads=4 --set-variable=innodb_lock_wait_timeout=50
mysql 4587 4504 0 2015 ? 00:01:18 /usr/sbin/mysqld --basedir=/ --datadir=/var/TKLC/epap/db/pdb --user=mysql --pid-file=/var/TKLC/epap/db/pdb/mysqld.pid --skip-locking --set-variable=wait_timeout=86400 --set-variable=max_connections=300 --innodb_data_home_dir=/var/TKLC/epap/db/pdb --innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G;ibdata9:2G;ibdata10:2G;ibdata11:2G;ibdata12:2G;ibdata13:2G;ibdata14:2G;ibdata15:2G;ibdata16:2G;ibdata17:2G;ibdata18:2G;ibdata19:2G;ibdata20:2G;ibdata21:2G;ibdata22:2G;ibdata23:2G;ibdata24:2G;ibdata25:2G --innodb_log_group_home_dir=/var/TKLC/epap/db/pdb --innodb_log_arch_dir=/var/TKLC/epap/db/pdb --set-variable=innodb_mirrored_log_groups=1 --set-variable=innodb_log_files_in_group=2 --set-variable=innodb_log_file_size=64M --set-variable=innodb_log_buffer_size=8M --set-variable=innodb_buffer_pool_size=128M --long_query_time=1 --log-slow-queries=/var/TKLC/epap/logs/slow-queries.log --innodb_flush_log_at_trx_commit=1 --innodb_log_archive=0 --set-variable=innodb_additional_mem_pool_size=2M --set-variable=innodb_file_io_threads=4 --set-variable=innodb_lock_wait_timeout=50
epapdev 5602 5567 0 05:12 ? 00:00:00 /opt/TKLCappl/bin/gs
root 5613 644 0 05:12 pts/0 00:00:00 grep gs

System health is found ok post gs restart and all db is found coherent state, refer the screen shot attached.

Attachments

This solution has no attachment