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

Connection Timed Out

Discussion in 'Database Admin' started by Jack@dba, Jul 29, 2017.

  1. Jack@dba

    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)
     
  2.  
  3. Rob Fitzpatrick

    Rob Fitzpatrick ProgressTalk.com Sponsor

Share This Page