• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Connection Timed Out

#1
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)