Auxiliary VPMS can ping but cannot login. Primary VPMS cannot get infomation from auxiliary VPMS, causing the alarm.
The alarm POM_00366 is "Auxiliary epm has failed multiple database sync attempts".
Primary database sync with other servers ,but auxiliary only sync with primary vpms database.
The alarm means the database has been locked and can not sync to primary database.
Usually , any process which needs to write database will lock the table it request .But after the process end ,it will release the resource it requested and release the loc. So other process can use the database .
However ,sometimes, the resource can not be released timely ,so it may cause other process to wait . In this case ,the auxiliary database is in using by other process and lock the table .
So when primary database try to sync, it will get alarm .
If there is no deadlock, the source will be released in some time ,and the issue can be solved without any action .
In this case we see the AUX failed to sync 3 times:
10/1/20 10:59:23 AM MDT EPM EP Media Server Manager Warning POMS_00365 Auxiliary EPM AUX-EPM failed database sync attempt Method=OMSPoller::poll,
10/1/20 10:59:31 AM MDT EPM EP Media Server Manager Warning POMS_00365 Auxiliary EPM AUX-EPM failed database sync attempt Method=OMSPoller::poll,
10/1/20 10:59:53 AM MDT EPM EP Media Server Manager Error POMS_00366 Auxiliary EPM AUX-EPM has failed multiple database sync attempts, exceeding the maximum of 3 attempts Method=OMSPoller::poll,
But then succeeds:
10/1/20 11:01:02 AM MDT EPM EP Media Server Manager Info POMS_00367 Auxiliary EPM AUX-EPM has again completed database sync attempts since its last successful sync at Thu Oct 01 10:57:15 MDT 2020 ,
If the there is deadlock ,we need to detect the deadlock and end the process .
The easiest method it reboot the server
