Versions Compared

Old Version 3

changes.mady.by.user richard.nahm

Saved on

compared with

New Version Current

changes.mady.by.user richard.nahm

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

All the versions of ALTIBASE HDB 

Symptom

Situation

...

Altibase Server

...

In the Altibase server log, the following logs can be checked.

...

The following situations occur on the Altibase client side.

  • The error message can be checkedwhen checked when the client sends a request to the Altibase server.
    Therefore, it may occur after the time left on the Altibase server-side (altibase_boot.log).

  • The connection to the Altibase server is disconnected during SELECT (when Fetch is requested).

  • When an application processes a fetch result and requests a FETCH back to the database, a disconnected error occurs.

  • The session has been closed by the server in the client log. (For ALTIBASE HDB 5.5.1 or later versions)

  • The Server closed the connection in the client log. (For ALTIBASE HDB 5.5.1 or later versions.)

...

  • "Communication link failure during fetch in APRE, SQLCLISQL CLI, ODBC, and CAPI. Server closed the connection." occurs.

  • This applies to ALTIBASE HDB version 5 or later

    Code Block
    titleAPRE
    languagebash
    FETCH ERROR         : [-331843] Communication link failure. Server closed the connection.
    Code Block
    titleSQLCLI, ODBC
    languagebash
    Error : SELECT * FROM EMP
Diagnostic Record 1
     SQLSTATE     : 08S01
     Message text : Communication link failure. Server closed the connection.
     Message len  : 57
     Native error : 0x51043

  • SESC (ALTIBASE HDB 4 ~ 5.1.5)

    Code Block
    titleSESC
    languagebash
    $ ./cursor2
...Omitted...
16      1001     2300000.00
17      2001     1400000.00
FETCH ERROR              : [-331843] Communication link failure (0
CURSOR CLOSE ERROR Error : [-594098] Connection does not exist
DISCONN ERROR            : [0]

...

  • In ALTIBASE HDB 4.3.9, the following error occurs during FETCH execution and the application may be stopped.

    Panel
    borderStyledotted
    borderColorgrey

    $ java SimpleSQL
    ...Omitted...
      ENO, DNO, SALARY : 20 40020
    FETCH ERROR CODE    : 0
    FETCH ERROR MESSAGE : Altibase JDBC $Revision: 24725 $ ERROR:read time out
    java.sql.SQLException: Altibase JDBC $Revision: 24725 $ ERROR:read time out
            at Altibase.jdbc.driver.cmProtocol.fireIOError(cmProtocol.java:87)
            at Altibase.jdbc.driver.cmProtocolTCP.execFetch(cmProtocolTCP.java:817)
            at Altibase.jdbc.driver.AltibaseConnection.execFetch(AltibaseConnection.java:298)
            at Altibase.jdbc.driver.AltibaseResultSet.next(AltibaseResultSet.java:1126)
            at SimpleSQL.main(SimpleSQL.java:105)

  • From ALTIBASE HDB 5 to 6.1.1, an error occurs during FETCH, and a disconnection error occurs whenever an application sends a request to the Altibase server afterward.

    Panel
    bgColorwhite
    titleBGColorgreywhite
    borderStyledotted
    titleJDBC-ALTIBASE HDB 5, 6.1.1 Occurrence type 1
    borderColorgrey

    $ java SimpleSQL
    ...Omitted...
      ENO, DNO, SALARY : 19 40021800000
      ENO, DNO, SALARY : 20 40020
    FETCH ERROR CODE    : 0
    FETCH ERROR MESSAGE : The connection is reset by the peer. (errno:232)
    java.sql.SQLException: 연결이 peer에 의해 재설정됩니다The connection is reset by the peer. (errno:232)
            at Altibase.jdbc.driver.ex.exception(ex.java:52)
            at Altibase.jdbc.driver.ex.exception(ex.java:37)
            at Altibase.jdbc.driver.cmnTCP.recv(cmnTCP.java:130)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:247)
            at Altibase.jdbc.driver.cmp.writeFetchRequest(cmp.java:1066)
            at Altibase.jdbc.driver.ABConnection.writeFetchRequest(ABConnection.java:335)
            at Altibase.jdbc.driver.ABResultSet.fetchPosition(ABResultSet.java:1184)
            at Altibase.jdbc.driver.ABResultSet.next(ABResultSet.java:719)
            at SimpleSQL.main(SimpleSQL.java:105)
    sPreStmt.close ERROR CODE    : 0
    sPreStmt.close ERROR MESSAGE : Broken pipe. (errno:32)
    java.sql.SQLException: 파이프가 손상되었습니다The pipe is damaged. (errno:32)
            at Altibase.jdbc.driver.ex.exception(ex.java:52)
            at Altibase.jdbc.driver.ex.exception(ex.java:37)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:153)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:246)
            at Altibase.jdbc.driver.cmp.free(cmp.java:1085)
            at Altibase.jdbc.driver.ABConnection.free(ABConnection.java:346)
            at Altibase.jdbc.driver.ABStatement.close(ABStatement.java:174)
            at SimpleSQL.main(SimpleSQL.java:133)
    sCon.close ERROR CODE    : 0
    sCon.close ERROR MESSAGE : Broken pipe. (errno:32)
    java.sql.SQLException: 파이프가 손상되었습니다The pipe is damaged. (errno:32)
            at Altibase.jdbc.driver.ex.exception(ex.java:52)
            at Altibase.jdbc.driver.ex.exception(ex.java:37)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:153)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:246)
            at Altibase.jdbc.driver.cmp.disconnect(cmp.java:775)
            at Altibase.jdbc.driver.ABConnection.close(ABConnection.java:226)       
            at SimpleSQL.main(SimpleSQL.java:142)

    Panel
    titleBGColorwhite
    borderStyledotted
    titleJDBC-ALTIBASE HDB 5, 6.1.1 Occurrence type 2
    borderColorgrey
    titleColorgreywhite

    $ java SimpleSQL
    ...Omitted...
      ENO, DNO, SALARY : 19 40021800000
      ENO, DNO, SALARY : 20 40020
    FETCH ERROR CODE    : 331817
    FETCH ERROR MESSAGE : Communication link failure
    java.sql.SQLException: Communication link failure
            at Altibase.jdbc.driver.ex.exception(ex.java:57)
            at Altibase.jdbc.driver.ex.exception(ex.java:32)
            at Altibase.jdbc.driver.ex.test(ex.java:83)
            at Altibase.jdbc.driver.cmnTCP.recv(cmnTCP.java:110)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:253)
            at Altibase.jdbc.driver.cmp.writeFetchRequest(cmp.java:1167)
            at Altibase.jdbc.driver.ABConnection.writeFetchRequest(ABConnection.java:628)
            at Altibase.jdbc.driver.ABResultSet.fetchPosition(ABResultSet.java:1184)
            at Altibase.jdbc.driver.ABResultSet.next(ABResultSet.java:719)
            at SimpleSQL.main(SimpleSQL.java:105)
    sPreStmt.close ERROR CODE    : 331817
    sPreStmt.close ERROR MESSAGE : Broken pipe
    java.sql.SQLException: Broken pipe
            at Altibase.jdbc.driver.ex.exception(ex.java:76)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:156)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:252)
            at Altibase.jdbc.driver.cmp.free(cmp.java:1186)
            at Altibase.jdbc.driver.ABConnection.free(ABConnection.java:655)
            at Altibase.jdbc.driver.ABStatement.close(ABStatement.java:179)
            at SimpleSQL.main(SimpleSQL.java:134)
    Caused by: java.io.IOException: Broken pipe
            at sun.nio.ch.FileDispatcher.write0(Native Method)
            at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)
            at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:69)
            at sun.nio.ch.IOUtil.write(IOUtil.java:26)
            at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:336)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:147)
            ... 5 more
    sCon.close ERROR CODE    : 331817
    sCon.close ERROR MESSAGE : Broken pipe
    java.sql.SQLException: Broken pipe
            at Altibase.jdbc.driver.ex.exception(ex.java:76)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:156)
            at Altibase.jdbc.driver.cmp.flush(cmp.java:252)
            at Altibase.jdbc.driver.cmp.disconnect(cmp.java:877)
            at Altibase.jdbc.driver.ABConnection.close(ABConnection.java:366)
            at SimpleSQL.main(SimpleSQL.java:143)
    Caused by: java.io.IOException: Broken pipe
            at sun.nio.ch.FileDispatcher.write0(Native Method)
            at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)
            at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:69)
            at sun.nio.ch.IOUtil.write(IOUtil.java:26)
            at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:336)
            at Altibase.jdbc.driver.cmnTCP.send(cmnTCP.java:147)
            ... 4 more

  • From ALTIBASE HDB 6.3.1, the session has been closed by the server error message that occurs during FETCH execution, and a connection disconnection error occurs whenever a request is sent to the Altibase server.

    Panel
    bgColorwhite
    titleBGColorgreywhite
    borderStyledotted
    titleJDBC - ALTIBASE HDB 6.3.1
    borderColorgrey

    FETCH ERROR CODE    : 4163
    FETCH ERROR MESSAGE : The session has been closed by the server
    java.sql.SQLException: The session has been closed by the server
            at Altibase.jdbc.driver.ex.Error.processServerError(Error.java:320)
            at Altibase.jdbc.driver.AltibaseForwardOnlyResultSet.next(AltibaseForwardOnlyResultSet.java:151)
            at SimpleSQL.main(SimpleSQL.java:105)
    sPreStmt.close ERROR CODE    : 334337
    sPreStmt.close ERROR MESSAGE : Communication link failure: There was no response from the server, and the channel has reached end-of-stream.
    java.sql.SQLException: Communication link failure: There was no response from the server, and the channel has reached end-of-stream.
            at Altibase.jdbc.driver.ex.Error.throwSQLExceptionInternal(Error.java:162)
            at Altibase.jdbc.driver.ex.Error.throwSQLException(Error.java:102)
            at Altibase.jdbc.driver.cm.CmChannel.readFromSocket(CmChannel.java:1042)
            at Altibase.jdbc.driver.cm.CmChannel.receivePacket(CmChannel.java:1001)
            at Altibase.jdbc.driver.cm.CmChannel.sendAndReceive(CmChannel.java:821)
            at Altibase.jdbc.driver.cm.CmProtocol.freeStatement(CmProtocol.java:424)
            at Altibase.jdbc.driver.AltibaseStatement.close(AltibaseStatement.java:436)
            at SimpleSQL.main(SimpleSQL.java:133)
    sCon.close ERROR CODE    : 334337
    sCon.close ERROR MESSAGE : Communication link failure: Broken pipe
    java.sql.SQLException: Communication link failure: Broken pipe
            at Altibase.jdbc.driver.ex.Error.throwCommunicationErrorException(Error.java:237)
            at Altibase.jdbc.driver.cm.CmChannel.sendPacket(CmChannel.java:921)
            at Altibase.jdbc.driver.cm.CmChannel.sendAndReceive(CmChannel.java:819)
            at Altibase.jdbc.driver.cm.CmProtocol.disconnect(CmProtocol.java:95)
            at Altibase.jdbc.driver.AltibaseConnection.disconnect(AltibaseConnection.java:616)
            at Altibase.jdbc.driver.AltibaseConnection.close(AltibaseConnection.java:601)
            at SimpleSQL.main(SimpleSQL.java:142)
    Caused by: java.net.SocketException: Broken pipe
            at java.net.SocketOutputStream.socketWrite0(Native Method)
            at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
            at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
            at java.nio.channels.Channels$WritableByteChannelImpl.write(Channels.java:292)
            at Altibase.jdbc.driver.cm.CmChannel.sendPacket(CmChannel.java:916)
            ... 5 more

...