Server Crash / MySQL issues

[allenbailey]

Hello there, I wonder if anyone is able to help. I love the SPP TBC server it's superb. However I seem to have an issue which is resulting in the errors below which prevents the server fucntioning till I restart. If anyone can offer any clues as to what is happening I'd very much appreciate it. I'd love to be able to run this server consistently. I suppose I 'notice' the MySQL error but there are crash logs which I guess might well be the reason for the errors reading comms cackets?

It always works after restart and sometimes stays up for a several hours but always ultimately crashes with the same error.

I attach .log / .dump files below.

Thanks for any help.

6.779451Z 0 [Note] Server hostname (bind-address): '*'; port:

6.779451Z 0 [Note] IPv6 is available.
6.779451Z 0 [Note]   - '::' resolves to '::';
6.779451Z 0 [Note] Server socket created on IP: '::'.
6.841851Z 0 [Note] Event Scheduler: Loaded 0 events
6.841851Z 0 [Note] Server\Database\bin\mysqld: ready for conne

 socket: ''  port: 3310  MySQL Community Server (GPL)
7.419052Z 0 [Note] InnoDB: Buffer pool(s) load completed at 23

5.258737Z 8 [Note] Aborted connection 8 to db: 'tbccharacters'
: 'localhost' (Got an error reading communication packets)
5.258737Z 13 [Note] Aborted connection 13 to db: 'tbcrealmd' u
'localhost' (Got an error reading communication packets)
5.258737Z 14 [Note] Aborted connection 14 to db: 'tbclogs' use
ocalhost' (Got an error reading communication packets)
5.258737Z 16 [Note] Aborted connection 16 to db: 'tbclogs' use
ocalhost' (Got an error reading communication packets)
5.258737Z 12 [Note] Aborted connection 12 to db: 'tbcrealmd' u
'localhost' (Got an error reading communication packets)
5.258737Z 11 [Note] Aborted connection 11 to db: 'tbcplayerbot
st: 'localhost' (Got an error reading communication packets)
5.258737Z 9 [Note] Aborted connection 9 to db: 'tbccharacters'
: 'localhost' (Got an error reading communication packets)
5.258737Z 10 [Note] Aborted connection 10 to db: 'tbcplayerbot
st: 'localhost' (Got an error reading communication packets)
5.258737Z 6 [Note] Aborted connection 6 to db: 'tbcmangos' use
ocalhost' (Got an error reading communication packets)
5.258737Z 7 [Note] Aborted connection 7 to db: 'tbcmangos' use
ocalhost' (Got an error reading communication packets)

[7b053e41_mangosd.exe_[27-10_0-49-31].dmp](https://github.com/celguar/mangosbot-bots/files/13188636/7b053e41_mangosd.exe_.27-10_0-49-31.dmp)
[7b053e41_mangosd.exe_[27-10_0-49-31].txt](https://github.com/celguar/mangosbot-bots/files/13188637/7b053e41_mangosd.exe_.27-10_0-49-31.txt)

[celguar]

Hello! This is from your crash log Physical Memory: 5071 MB (Available: 499 MB) I'm afraid it just ran out of RAM

[celguar]

You can try lower bots amount maybe

[allenbailey]

Thanks very much for taking the time to look at my logs. What I find interestign is that soemtimes the serevr will crash after just 20mins or so and other times it will crash after a few days. Any ideas what might be causing the quick crashes?

On Tue, 21 Nov 2023 at 07:50, celguar @.***> wrote:

Hello! This is from your crash log Physical Memory: 5071 MB (Available: 499 MB) I'm afraid it just ran out of RAM

— Reply to this email directly, view it on GitHub https://github.com/celguar/mangosbot-bots/issues/302#issuecomment-1820397493, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA26SCDSMCAILQ6OPSTC3UDYFRMM7AVCNFSM6AAAAAA6SWPWIGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRQGM4TONBZGM . You are receiving this because you authored the thread.Message ID: @.***>

-- It is in fact nothing short of a miracle that the modern methods of instruction have not yet entirely strangled the holy curiosity of inquiry. It is a very grave mistake to think that the enjoyment of seeing and searching can be promoted by means of coercion and a sense of duty.

Albert Einstein

[celguar]

random bots activity is random, and their traveling around the world loads different parts of the map. So sometimes if they spread across more zones than before it increases RAM usage. You can try disable bots AutoDoQuests, maybe it helps.