Connection timed out errors

Posted by durgaprasad m on 29-Jul-2017 10:26

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.
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)

All Replies

Posted by cjbrandt on 29-Jul-2017 12:41

The db log probably has additional information showing why the db went down.  

I'd skip trying to reproduce an SQL error on version 9.1e and put my efforts into upgrading to 11.7.

This thread is closed