[Warning]: Connection to Char Server lost. - Hercules bug tracker archive

Issue information

Issue ID

#8651

Status

Invalid

Severity

None

Started

Makoto

Apr 25, 2015 0:41

Last Post

Haru

Apr 28, 2015 18:07

Confirmation

N/A

Makoto - Apr 25, 2015 0:41

Hello again this problem starts happening when i update my Hercules!

Its very similar on what's happening with this [url="https://rathena.org/board/tracker/issue-8317-warning-connection-to-char-server-lost/"]https://rathena.org/board/tracker/issue-8317-warning-connection-to-char-server-lost/[/url] (but not on the song one since i tried it)

Server runs smoothly after like 12-48 hours then sometimes char-server will get disconnected on the map-server. I don't know how to reproduce it and on our test server this problem happens too (which is i am the only one who's online and not doing anything.)

I hope someone can confirm this.

This post has been edited by Makoto on Apr 25, 2015 1:01

Dastgir - Apr 25, 2015 1:37

Maybe char-server got crashed?

malufett - Apr 25, 2015 3:36

any console message? maybe its network issue...

:meow:

Dastgir - Apr 25, 2015 4:12

[quote name="malufett" timestamp="1429932981"]
any console message? maybe its network issue...

:meow:
[/quote]How can it be network issue if they are on same machine?

malufett - Apr 25, 2015 4:31

[quote name="Dastgir" timestamp="1429935141"][quote name="malufett" timestamp="1429932981"]

any console message? maybe its network issue...

:meow:[/quote]How can it be network issue if they are on same machine?[/quote]

yes it does if the ip used is not localhost..always happens to me when someone is playing around with my router or net is not stable,,,

:meow:

Makoto - Apr 25, 2015 18:40

Its not really crashing. Its just get disconnected i did revert all hercs commit starts from 28 and my test server works just fine.

Makoto - Apr 26, 2015 6:24

[code=auto:0] Info]: Character 'Hatsune Miku' logged off. [Warning]: Connection to Char Server lost. [Info]: Closed connection from '112.198.64.10'. [Status]: Connecting to 127.0.0.1:6121 [Status]: Logging in to char server... [Warning]: Connection to Char Server lost. [Status]: Connecting to 127.0.0.1:6121 [Status]: Logging in to char server... [Error]: MAYDAY! failed to delete status 53 from CID:163078/AID:2006339 [Warning]: clif_process_message: Player 'Sinha' sent an unterminated name! [Info]: Character 'Lemorey' logged off. [Info]: Character 'syscosin' logged off. [Error]: MAYDAY! failed to delete status 53 from CID:165275/AID:2008349 [Warning]: Connection to Char Server lost. [Info]: Character 'xRyuu' logged off. [Status]: Connecting to 127.0.0.1:6121 [Status]: Logging in to char server... [Info]: Character 'Vengeance' logged off. [Info]: Character 'FritzReia' logged off. [Error]: MAYDAY! failed to delete status 53 from CID:170050/AID:2011572 [Error]: MAYDAY! failed to delete status 53 from CID:168578/AID:2005992 [Error]: MAYDAY! failed to delete status 53 from CID:171072/AID:2011617 [Info]: Closed connection from '112.203.191.41'. [Error]: script:delitem: failed to delete 1 items (AID=2004726 item_id=7342). [Debug]: Source (NPC): Historian#prt02 at morocc_in (45,126) [Error]: MAYDAY! failed to delete status 53 from CID:161626/AID:2007211 [Warning]: Connection to Char Server lost. [Info]: Character 'YxxxAxxxP' logged off. [Status]: Connecting to 127.0.0.1:6121 [Status]: Logging in to char server... [Info]: Character 'DontHurtMe' logged off. [Info]: Character 'Hellcard' logged off. [Error]: MAYDAY! failed to delete status 54 from CID:171072/AID:2011617 [/code]
This error only happen last week, I'm not sure why my character gets disconnect with the map-server.

Makoto - Apr 28, 2015 8:11

[img]http://i.imgur.com/JVRLTZR.png[/img]

[url="http://pastebin.com/raw.php?i=QyMTzKPj"]http://pastebin.com/raw.php?i=QyMTzKPj[/url]

This post has been edited by Makoto on Apr 28, 2015 8:12

Makoto - Apr 28, 2015 8:29

BTW
We reinstall our SQL server and main server (with Debian 7)
- Also fresh Hercules with our commits.

[img]http://i.imgur.com/uXIH9pK.png[/img]

Still throwing this char-server down.

Haru - Apr 28, 2015 8:40

Judging by the backtrace you show (considering it's taken in a moment the char server was seemingly frozen), it sounds like the char server is spending most of its time waiting for SQL queries to complete.

Is the SQL server hosted on the same machine as the char server? If it isn't, could the network be a bottleneck? Otherwise, what's the system load on the machine? Are there many processes in iowait?

Makoto - Apr 28, 2015 8:52

Its hosted on the same machine and i am using 127.0.01

daim - Apr 28, 2015 14:01

hi,

Is this problem slove? It seem i also having this issue.

Thanks

Dastgir - Apr 28, 2015 16:31

[quote name="daim" timestamp="1430229696"]
hi,

Is this problem slove? It seem i also having this issue.

Thanks
[/quote]No,
Do you know way to reproduce this?

Haru - Apr 28, 2015 18:07

As far as I'm aware, it's solved. (wasn't a Hercules problem, but rather, an unresponsive MySQL server)
Closing. Please reopen if needed.