Eventualamente estão ocorrendo travamentos no servidor do Elipse E3, fazendo com que todas as Viewers fiquem sem comunicação.
A configuração é do tipo Hot-Standby.
Os logs DB do momento em que ocorreu a falha são os seguintes:
SERVIDOR1:
| 799 | 2022-05-09 08:51:52.243 | 0x1990 | 0x1994 | ROWSET | [Rowset5565] ThreadRowset Created | 16 |
|---|---|---|---|---|---|---|
| 800 | 2022-05-09 08:51:52.243 | 0x1990 | 0x2B68 | ROWSET | [Rowset5565] AdoRowset Created (‘SELECT E3TimeStamp, LIC601_SP, LIC601_PV, LIC601_MV FROM HISTORICO WHERE E3TimeStamp >= dateadd(minute, -10, getdate()) ORDER BY E3TimeStamp ASC’) | 16 |
| 801 | 2022-05-09 08:51:55.060 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 802 | 2022-05-09 08:52:26.138 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 803 | 2022-05-09 08:52:50.894 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 804 | 2022-05-09 08:53:20.639 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 805 | 2022-05-09 08:53:25.031 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 806 | 2022-05-09 08:53:26.040 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 807 | 2022-05-09 08:53:28.509 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 808 | 2022-05-09 08:53:31.327 | 0x1990 | 0x19BC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 809 | 2022-05-09 08:53:36.723 | 0x1990 | 0x2B68 | ROWSET | [Rowset5565] AdoRowset Destroyed | 16 |
| 810 | 2022-05-09 08:53:36.723 | 0x1990 | 0x2B68 | ROWSET | [Rowset5565] ThreadRowset Destroyed | 16 |
| 811 | 2022-05-09 08:53:59.374 | 0x1990 | 0x1994 | ROWSET | [Rowset5566] ThreadRowset Created | 16 |
| 812 | 2022-05-09 08:53:59.374 | 0x1990 | 0x2B68 | ROWSET | [Rowset5566] AdoRowset Created (‘SELECT E3TimeStamp, LIC601_SP, LIC601_PV, LIC601_MV FROM HISTORICO WHERE E3TimeStamp >= dateadd(minute, -10, getdate()) ORDER BY E3TimeStamp ASC’) | 16 |
| 813 | 2022-05-09 08:53:59.907 | 0x1990 | 0x2B68 | ROWSET | [Rowset5566] AdoRowset Destroyed | 16 |
SERVIDOR 2:
| 28 | 2022-05-09 05:52:26.300 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
|---|---|---|---|---|---|---|
| 29 | 2022-05-09 06:00:37.581 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 30 | 2022-05-09 06:00:39.582 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 31 | 2022-05-09 06:00:41.583 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 32 | 2022-05-09 06:00:43.584 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
| 33 | 2022-05-09 06:30:59.308 | 0x21AC | 0x21DC | DB | pop data on Execution Thread failed (FILE ALREADY LOCKED) - error(80070021) E_LOCK_VIOLATION | 16 |
Alguém saberia avaliar o que ocorre?
Desde já obrigado!