Related to my previous reply. I just found the validateSMGR tool Avaya gave in the past when we troubleshot a certificate problem. That tool showed some errors.
Here's an example (below). Does anyone have a copy of the rollbackPreparedTransactions.sh they mention? I looked for the Avaya ETSS web site but it looks like it no longer exists so I don't know where I can get a copy of that tool/script.
Also, I just happened to find a file in the /tmp folder called output.txt and when I looked at it, I see it's a great text file with all the config I know we have in SMGR like the SIP entities we've defined, call routing info, etc. This one is not up to date and if we can't get the web page back, I'll need all the details about what we have configured. I don't recall how that output.txt file came to be, but do you guys know how to export the SMGR config so I have a copy of all the entries for things like the SIP entities we've added, routing info and so on?
All jboss EARs deployed? 15 of 23 EARs [ FAILED ]
======================
2 known cases.
Case 1:
There has been issues where SMGR has been not able to fully boot and therefore the webpage does not come back after a reboot.
UI not accessible issue is due to JBoss startup stuck at some application deployment due to some prepared transactions not getting committed.
Stop jboss service and restart postgresql service and run below mentioned command as user root:
su - postgres -c "psql -d avmgmt -c \"select count(*) from pg_prepared_xacts;\""
If the output gives a non-zero count then there are prepared transactions that are not getting committed.
There is a script internal to Avaya that can fix this. Avaya ETSS' wiki provides a script called
rollbackPreparedTransactions.sh which fixes this for you.
Here's an example (below). Does anyone have a copy of the rollbackPreparedTransactions.sh they mention? I looked for the Avaya ETSS web site but it looks like it no longer exists so I don't know where I can get a copy of that tool/script.
Also, I just happened to find a file in the /tmp folder called output.txt and when I looked at it, I see it's a great text file with all the config I know we have in SMGR like the SIP entities we've defined, call routing info, etc. This one is not up to date and if we can't get the web page back, I'll need all the details about what we have configured. I don't recall how that output.txt file came to be, but do you guys know how to export the SMGR config so I have a copy of all the entries for things like the SIP entities we've added, routing info and so on?
All jboss EARs deployed? 15 of 23 EARs [ FAILED ]
======================
2 known cases.
Case 1:
There has been issues where SMGR has been not able to fully boot and therefore the webpage does not come back after a reboot.
UI not accessible issue is due to JBoss startup stuck at some application deployment due to some prepared transactions not getting committed.
Stop jboss service and restart postgresql service and run below mentioned command as user root:
su - postgres -c "psql -d avmgmt -c \"select count(*) from pg_prepared_xacts;\""
If the output gives a non-zero count then there are prepared transactions that are not getting committed.
There is a script internal to Avaya that can fix this. Avaya ETSS' wiki provides a script called
rollbackPreparedTransactions.sh which fixes this for you.
Comment