[MDEV-21433] After running several days our application wasn't able to connect to MariaDB server anymore. Created: 2020-01-07  Updated: 2022-07-26  Resolved: 2020-02-14

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Michael Graf Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback


 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

 Comments   
Comment by Vladislav Vaintroub [ 2020-01-07 ]

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.

Comment by Michael Graf [ 2020-01-08 ]

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

Generated at Thu Feb 08 09:07:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.