Mem Leak?? Please Help

[Voldemmort]

Rev: Insider 10041

DB: YTDB 550

SD2 Rev: 1708 + Insider ToC Scripts

I have been having a extrange problem lately, every day at aprox 1 PM (GMT -3) my dedicated server is being to lag a lot.

Then I try to get into it using Remote Desktop and I have to wait like 5 or 10 minutes to get into it, the mangosd.exe have already restarted itself (Freeze Detector) and it is starting up very laggy.

I have to restart the whole machine to make it work like it should.

Any one could know what is happening? It is a mem leak or something like that or what could be happening?

Thanks in advance for any help provided.

[zjlhxn1990]

Using configuration file mangosd.conf.

World Database: 127.0.0.1;3306;root;mangos;mangos

MySQL client library: 5.0.56

MySQL server ver: 5.0.51b-community-nt

ERROR:SQL: SELECT required_10045_01_mangos_spell_proc_event FROM db_version LIMIT 1

ERROR:query ERROR: Unknown column 'required_10045_01_mangos_spell_proc_event' in 'field list'

ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

ERROR:

ERROR: [A] You have: --> `9990_01_mangos_spell_chain.sql`

ERROR:

ERROR: You need: --> `10045_01_mangos_spell_proc_event.sql`

ERROR:

ERROR:You must apply all updates after [A] to to use mangos with this database.

ERROR:These updates are included in the sql/updates folder.

ERROR:Please read the included [README] in sql/updates for instructions on updating.

come on! help!

mangos Version 0.16.0 (git)

Client Version 3.3.3 (11723)

I'm rubbish

The play is set up stand-alone

[VladimirMangos]

maybe some event start in world, or at this tiem set soem cleanup in config like daily quest resets...

[Patman128]

It's really hard to know without specific details on what is running on the computer and what resources they are using.

[Voldemmort]

maybe some event start in world, or at this tiem set soem cleanup in config like daily quest resets...

Thanks for your answer Vladimir.

This is my config.

Instance.ResetTimeHour = 4

Quests.Daily.ResetHour = 6

Quests.Weekly.ResetHour = 6

It is set all to the morning, not at 13 hours so no idea what could be happening.

How can i check it is caused by an event?

[ilija]

See the event start time in event table. You maybe have autobackup on your char db or something , it cause heavy lag

[Voldemmort]

See the event start time in event table. You maybe have autobackup on your char db or something , it cause heavy lag

Hi, this is a dump of my game_event table, and I dont have any autobackup of any of my DB's, the lag or freeze is everyday around 12:58 to 13:02 when it hangs cause of the anti freeze (set to 180 minutes)

('1','2009-06-20 19:59:36','2020-12-30 22:59:36','525600','20158','341','Festival de Fuego del Solsticio de Verano');
('2','2009-12-15 11:00:00','2020-12-30 22:59:36','525600','25920','141','¡Festival de Invierno!');
('3','2010-01-31 00:01:00','2020-12-31 03:00:00','131040','10078','376','Feria de la Luna Negra (Bosque de Terokkar)');
('4','2010-02-28 00:01:00','2020-12-31 03:00:00','131040','10078','374','Feria de la Luna Negra (Bosque de Elwynn)');
('5','2010-01-03 00:01:00','2020-12-31 03:00:00','131040','10078','375','Feria de la Luna Negra (Mulgore)');
('6','2009-12-31 21:59:36','2020-12-30 22:59:36','525600','120','0','Año Nuevo');
('7','2010-02-14 11:00:00','2020-12-30 22:59:36','525600','30240','327','Festival Lunar');
('8','2010-02-07 05:01:00','2020-12-21 04:00:00','525600','18778','335','Amor en el Aire');
('9','2010-04-04 04:01:00','2020-12-30 22:59:36','525600','10078','181','Pascua');
('10','2010-05-02 04:01:00','2020-12-30 22:59:36','525600','10078','201','Semana de los Niños');
('11','2009-09-27 04:01:00','2020-12-30 22:59:36','525600','10078','321','Festival de La Cosecha');
('12','2009-10-18 05:00:00','2020-12-30 22:59:36','525600','20099','324','Halloween');
('22','0000-00-00 00:00:00','0000-00-00 00:00:00','482400','43200','0','Refuerzos para Anh Qiraj');
('17','0000-00-00 00:00:00','0000-00-00 00:00:00','525600','28800','0','Invasión de la Plaga');
('13','0000-00-00 00:00:00','0000-00-00 00:00:00','525600','28800','0','Invasión de Elementales');
('14','2009-11-08 18:50:00','2020-12-31 03:00:00','10080','120','0','Va a Comenzar el Gran Espectáculo de Pesca en Tuercespia');
('16','2007-08-05 03:00:00','2020-12-31 03:00:00','180','120','0','Captura el Botín de Gurubashi Arena');
('15','2009-11-08 19:00:00','2020-12-31 03:00:00','10080','120','301','Gran Espectáculo de Pesca en Tuercespia');
('18','2009-11-20 05:01:00','2020-12-30 22:59:36','60480','5758','283','Llamamiento a las Armas: ¡Valle de Alterac!');
('19','2009-11-27 05:01:00','2020-12-30 22:59:36','60480','5758','284','Llamamiento a las Armas: ¡Garganta Grito de Guerra!');
('20','2009-11-06 05:01:00','2020-12-30 22:59:36','60480','5758','285','Llamamiento a las Armas: ¡Cuenca de Arathi!');
('21','2009-11-13 05:01:00','2020-12-30 22:59:36','60480','5758','353','Llamamiento a las Armas: ¡Ojo de la Tormenta!');
('24','2009-03-06 09:05:00','2009-12-31 19:59:36','7200','60','0','¡Los Lobos Atacan Orgrimmar (Grupo Dos)!');
('23','2009-03-06 03:59:36','2020-12-30 22:59:36','1440','60','0','¡Los Lobos Atacan Orgrimmar (Grupo Uno)!');
('26','2009-09-20 04:01:00','2020-12-31 03:00:00','525600','20158','372','¡Festival de la Cerveza!');
('28','2007-08-12 16:59:36','2009-12-31 19:59:36','7200','60','0','¡La Legión Ardiente ataca Ventormenta!');
('31','2009-12-06 02:01:00','2020-12-30 22:59:36','131040','4320','0','Construcción de la Feria de la Luna Negra (Bosque de Elwynn)');
('27','2009-03-06 09:00:00','2020-12-30 22:59:36','7200','60','0','¡Ventormenta se Defiende de la Legión Ardiente!');
('25','2007-08-12 10:59:44','2009-12-31 19:59:36','7200','60','0','¡Orgrimmar se defiende de los Lobos!');
('34','2008-05-15 11:59:37','2020-01-01 00:59:36','10080','5','0','Concierto de los L70ETC en Bosque Terokkar');
('35','2008-03-23 21:59:37','2020-12-30 22:59:36','86400','21600','0','Locura de Espadas, Gri\\'lek');
('36','2008-04-06 20:59:37','2020-12-30 22:59:36','86400','21600','0','Locura de Espadas, Hazza\\'rah');
('37','2008-04-20 20:59:37','2020-12-30 22:59:36','86400','21600','0','Locura de Espadas, Renataki');
('38','2008-05-04 20:59:37','2020-12-30 22:59:36','86400','21600','0','Locura de Espadas, Wushoolay');
('29','2010-05-01 21:00:00','2020-12-30 22:59:36','1440','720','0','Anochece, ¡Vienen los Hombres Lobo a Piroleña!');
('32','2009-09-19 04:01:00','2020-08-24 04:59:36','525600','1439','0','Día de los Piratas');
('40','2009-11-01 06:00:00','2020-12-30 22:59:36','525600','1379','409','Día de los Muertos');
('41','2009-11-08 06:00:00','2020-12-30 22:59:36','545760','10019','404','Generosidad del Peregrino');
('42','2010-01-22 00:01:00','2020-12-31 01:00:00','60480','5758','420','Call to Arms: Isle of Conquest!');
('43','2009-12-06 15:15:00','2020-12-31 06:00:00','60','5','0','Hammerfall Under Attack');
('44','2009-12-06 15:15:00','2020-12-31 06:00:00','5','5','0','Thrallmar Demon Attack');
('45','2010-01-02 19:00:00','2020-12-26 20:00:00','10080','60','424','Kalu\\'ak Fishing Derby');
('30','2010-01-15 00:01:00','2020-12-30 23:00:00','60480','5758','400','Call to Arms: Strand of the Ancients!');

[Voldemmort]

It's really hard to know without specific details on what is running on the computer and what resources they are using.

I have the dedicated server just for the server, it has running MySQL, mangosd, realmd, and apache running, no more, it is a windows server 2008 x64 with 12 Gb of ram and an i7 core running.

[ilija]

Windows.. But anyways , try to disable this events

('29','2010-05-01 21:00:00','2020-12-30 22:59:36','1440','720','0','Anochece, ¡Vienen los Hombres Lobo a Piroleña!');
('23','2009-03-06 03:59:36','2020-12-30 22:59:36','1440','60','0','¡Los Lobos Atacan Orgrimmar (Grupo Uno)!');

you can delete them or set end time to null

Maybe it helps , what crashlog you get?

[Voldemmort]

I erase that events and still having that issue.

The gameserver freeze at 12:58 and start eating my ram, until it got almost all of my ram and the anti freeze close it, and restart very laggy, after the antifreeze close it, I'm able to get into the machine again with Remote Desktop, then I have to manually restart the machine and then it will work fine again until the next day.

These are some examples of the Crash Logs I'm getting.

http://pastebin.com/jhCYKrUH

http://pastebin.com/jH6twGcA

http://pastebin.com/bCA4cneX

[Patman128]

Those logs don't really help at all because they don't really tell anything besides the freeze detector killing mangos.

[Voldemmort]

Yeah I know . thats why i didnt put any log in the first post, but ilija ask for them, O provide him of them.

Anyway, do u have any idea of what is causing this?

Is there anyway to set log level to max when the server is running without having to restart it? Like a command or something like that? So i could get a full Server Log before it crash to see what is causing that.

[freghar]

Well if the entire OS has frozen, it means (on windows) some heavy kernel I/O involved (or waiting for that I/O). My best guess is world.log logfile enabled.

[Voldemmort]

Ok I think I have found the problem.

The problem is with the Instance Reset Time, when the core is resseting the instances of all players.

I have enable today ".server log filter all on" and when the core freezes there was running some querys for the instance reset, like set instance reset time = XXXXXXXX

Do you know any solution for this problem?

[Voldemmort]

Hey, I manage to get some screens while the server was lagging.

Here are them.

http://img97.imageshack.us/img97/2338/crash1.png

http://img31.imageshack.us/img31/1471/crash2h.png

http://img682.imageshack.us/img682/2835/crash3.png

http://img692.imageshack.us/img692/6012/crash4.png

http://img36.imageshack.us/img36/7797/crash5.png

http://img693.imageshack.us/img693/6717/crash6.png

All images as a nice album .

http://img97.imageshack.us/g/crash1.png/

Thanks for any help someone could provide me, I have run the following SQL's in the chars DB to see if it helps to solve the lag.

TRUNCATE `character_instance`;
TRUNCATE `groups`;
TRUNCATE `group_instance`;
TRUNCATE `group_member`;
TRUNCATE `instance`;
TRUNCATE `instance_reset`;