Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21433

After running several days our application wasn't able to connect to MariaDB server anymore.

Details

    Description

      After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

      The error message is:
      Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

      Do you know any reason how this can happen ?
      What can we analyze on the system to narrow down the problem ?

      After the restart of the MariaDB server all was fine again.

      Operating system: Windows server 2008 R2
      MariaDB server: 10.3.18

      Attachments

        Activity

          migra Michael Graf created issue -
          migra Michael Graf made changes -
          Field Original Value New Value
          Description After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the the system to narrow down the problem ?
          migra Michael Graf made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          migra Michael Graf made changes -
          Description After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the the system to narrow down the problem ?
          After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?
          migra Michael Graf made changes -
          Description After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?
          After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?

          After the restart of the MariaDB server all was fine again.
          migra Michael Graf made changes -
          Description After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?

          After the restart of the MariaDB server all was fine again.
          After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?

          After the restart of the MariaDB server all was fine again.

          Operating system: Windows server 2008 R2
          MariaDB server: 5.3.18
          wlad Vladislav Vaintroub added a comment - - edited

          migra, generally take a network trace, e.g with Wireshark to see what happened, if you know that the server is up and the address is correct.
          you also can try a telnet on the server:port combination, to see if server wrote a "welcome" packet.

          if there is any kind of deadlock, a memory dump, or stacktrace dump can help.

          I'd like to point out though, that we no longer support either MariaDB 5.3 nor Windows server 2008 R2.

          wlad Vladislav Vaintroub added a comment - - edited migra , generally take a network trace, e.g with Wireshark to see what happened, if you know that the server is up and the address is correct. you also can try a telnet on the server:port combination, to see if server wrote a "welcome" packet. if there is any kind of deadlock, a memory dump, or stacktrace dump can help. I'd like to point out though, that we no longer support either MariaDB 5.3 nor Windows server 2008 R2.
          migra Michael Graf added a comment -

          Sorry, the correct used version is 10.3.18 and not 5.3.18.

          migra Michael Graf added a comment - Sorry, the correct used version is 10.3.18 and not 5.3.18.
          valerii Valerii Kravchuk made changes -
          Description After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?

          After the restart of the MariaDB server all was fine again.

          Operating system: Windows server 2008 R2
          MariaDB server: 5.3.18
          After running several days (about 3 weeks) our application wasn't able to connect to MariaDB server anymore.

          The error message is:
          Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0)

          Do you know any reason how this can happen ?
          What can we analyze on the system to narrow down the problem ?

          After the restart of the MariaDB server all was fine again.

          Operating system: Windows server 2008 R2
          MariaDB server: 10.3.18
          julien.fritsch Julien Fritsch made changes -
          Epic Colour ghx-label-11
          Epic Name Can't connect to MariaDB server
          Epic Status To Do [ 10100 ]
          Fixing Priority 250
          Issue Type Epic [ 5 ] Bug [ 1 ]
          elenst Elena Stepanova made changes -
          Labels need_feedback
          elenst Elena Stepanova made changes -
          Component/s Server [ 13907 ]
          Fix Version/s N/A [ 14700 ]
          Resolution Incomplete [ 4 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 102822 ] MariaDB v4 [ 157168 ]

          People

            Unassigned Unassigned
            migra Michael Graf
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.