Connection Timed Out

Jack@dba

Member
HI

Today one of our database went down.We already faced this type of issue previously this is second time.

After checking we restarted Database everything came normal.

1) How to overcome this errors what exactly the issue here?
2) Can we reproduce this errors

Version : 9.1e
OS: AIX 5.3

23:26:46 SQLSRV2 5: SYSTEM ERROR: Memory violation. (49)
23:27:17 BROKER 0: Disconnecting dead server 5. (2525)
23:30:00 SRV 2: Login usernum 1085, userid pgresdba, on p5lp5 batch. (742)
23:30:01 SRV 2: Login usernum 1084, userid pgresdba, on p5lp5 batch. (742)
23:30:01 SRV 2: Logout usernum 1084, userid pgresdba, on p5lp5 batch. (739)
23:30:35 SRV 2: Logout usernum 1085, userid pgresdba, on p5lp5 batch. (739)
23:35:00 Usr 43: Login by pgresdba on batch. (452)
23:35:11 Usr 43: Logout by pgresdba on batch. (453)
23:35:12 Usr 43: Login by pgresdba on batch. (452)
23:35:15 SRV 26: Connection timed out on socket=110 for usernum 1, attempt disconnect. (1280)
23:35:15 SRV 26: Error reading socket=110 ret=-1 errno=22. (795)
23:35:15 SRV 26: Error reading socket=110 ret=-1 errno=22. (795)
23:35:48 Usr 43: Logout by pgresdba on batch. (453)
23:35:50 Usr 43: Login by pgresdba on batch. (452)
23:37:01 Usr 43: Logout by pgresdba on batch. (453)
 
Top