Solved Help on identifying ManagementConsoleJS issue

[damith]

Hi All,

I was given 500 Bad Gateway when I was trying to login to management console, then after a system reboot (to restore services) I saw following log items on log backups.

Kindly help on understanding this issue.

00:23:52.642|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:ConnectionThread. Accepting new connection
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:ConnectionThread. Connection from: '127.0.0.1' has been accepted
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:ConnectionThread. Configuring new socket.
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:ConnectionThread. Starting new application
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:Start management threads for avbs3cx7cs:0/PbxConfigTool
05:04:34.076|7fc13d7fa700| Info|DBServ.cpp(546): SL:Application connected:avbs3cx7cs:0/PbxConfigTool
05:04:34.076|7fc13d7fa700| Info|DBServ.cpp(79): avbs3cx7cs:0/PbxConfigTool from 127.0.0.1:48694 to 127.0.0.1:5485 Connection accepted.
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:Startup completed for avbs3cx7cs:0/PbxConfigTool
05:04:34.076|7fc163200700| Info|DBServ.cpp(546): SL:ConnectionThread. Initialization of new connection is completed.
05:04:44.279|7fc13d7fa700| Info|DBServ.cpp(546): SL:Receive failed: socket closed
05:04:44.280|7fc13d7fa700| Info|DBServ.cpp(546): SL:Remote disconnect: "avbs3cx7cs:0/PbxConfigTool" stopped
05:04:44.280|7fc13d7fa700| Info|DBServ.cpp(72): avbs3cx7cs:0/PbxConfigTool disconnected
08:36:19.713|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:36:35.717|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:37:37.722|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:39:29.729|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:40:23.734|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:41:05.738|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:42:05.743|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:42:37.747|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:46:11.757|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
08:59:29.789|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
09:00:00.839|7fc1629ff700|Error|DBProvPostgress.cpp(788): INSERT FAILED:codec2gateway
insert into codec2gateway (priority,fkidgateway,fkidcodec) values(0,4,1) RETURNING *
ERROR: duplicate key value violates unique constraint "codec2gateway_fkidgateway_priority_key"
DETAIL: Key (fkidgateway, priority)=(4, 0) already exists.
09:00:11.793|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
09:00:19.796|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
09:00:51.801|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
09:01:05.945|7fc1629ff700|Error|DBProvPostgress.cpp(788): INSERT FAILED:codec2gateway
insert into codec2gateway (priority,fkidgateway,fkidcodec) values(0,4,1) RETURNING *
ERROR: duplicate key value violates unique constraint "codec2gateway_fkidgateway_priority_key"
DETAIL: Key (fkidgateway, priority)=(4, 0) already exists.
09:01:29.805|7fc1629ff700| Info|DBProvPostgress.cpp(1448): The record inserted to non-OM table 'eventlog' will be ignored by notification process
09:01:38.629|7fc13f7fe700| Info|DBServ.cpp(546): SL:Receive failed: socket closed
09:01:38.629|7fc13f7fe700| Info|DBServ.cpp(546): SL:Remote disconnect: "avbs3cx7cs:0/ManagementConsoleJS" stopped
09:01:38.629|7fc13f7fe700| Info|DBServ.cpp(72): avbs3cx7cs:0/ManagementConsoleJS disconnected

 

[AWS2P]

Please help us to understand better your starting point answering this:
https://www.3cx.com/community/threads/information-to-provide-when-requesting-help.67558/

 

[damith]

Hi,

Thank you very much for offering help. I was able to find the issue. It was due to concurrent sessions which was doing trunk modifications.

Please help us to understand better your starting point answering this:
https://www.3cx.com/community/threads/information-to-provide-when-requesting-help.67558/