kero99

Are you use lucid percona repo instead karmic?

Update XtraDB install procedure (working to update percona server too)

Update post to use ACE 5.7.8 in Core Server and new install XtraDB procedure in DB Server for Ubuntu 9.10, EXT4 system is really good for mysql performance Best Regards

Yes, but solved with: diff --git a/src/game/ThreatManager.cpp b/src/game/ThreatManager.cpp index 3f506fe..1f2cc33 100644 --- a/src/game/ThreatManager.cpp +++ b/src/game/ThreatManager.cpp @@ -512,7 +512,7 @@ void ThreatManager::ProcessThreatEvent(ThreatRefStatusChangeEvent* threatRefStat setCurrentVictim(NULL); setDirty(true); } - iOwner->SendThreatRemove(hostileReference); + //iOwner->SendThreatRemove(hostileReference); iThreatContainer.remove(hostileReference); iUpdateNeed = true; iThreatOfflineContainer.addReference(hostileReference); No more grid crashes, problem come from rev 9038 Best regards

Confirmed.

For live server you need remove this assert or you always crash. No other solution for now.. =(

Temp patch update to Rev 9799 until Derex release latest version http://pastebin.com/ttvtBFR9 Best Regards

Tranks XTZGZoReX for reply, some ideas where i can put de asserts to find source of problems?, in x and y coords? or better in what other variable?, so much ppl we have this diabolic crash and i want to help to find the source of problem =) Best regards P.D: Other same crash but taxi related: http://pastebin.com/9jg19LxZ

Confirmed same crash, crash is not in Map.cpp:527 (this trace point is #2), the problem come from Map.cpp:586 (#1 Map::loaded) Some ideas? Best Regards

Hi all, since 5 month ago i have a crash that i never can fix: http://pastebin.com/wpYSPaVN I try with clean mangos, insider and GC repo, with or without Mtmaps, with 300 or 3000 player ... but always this crash appear. Today i upgrade to last mangos 3.3.3a with Insider42 patches and... crash again =(. Any idea about howto fix o what is the problem?? Best regards

Maybe than Percona repo need keys now : > wget [url]http://www.percona.com/percona-builds/RPM-GPG-KEY-percona[/url] > apt-key add RPM-GPG-KEY-percona > apt-get update > apt-get install mysql-server-5.1

Mysql in repositories is standard, Percona XtraDB Myslq is for high performance =):

Mysql Server and Windows is not a good idea... We work 1 year with mysql in a windows 2003 and then 2008 (Poor Performance, corrupted data some times and some rollback...). Try Debian with Percona Mysql 5.1, install is more simple than windows nano /etc/apt/sources.list add lines: deb [url]http://repo.percona.com/apt[/url] lenny main deb-src [url]http://repo.percona.com/apt[/url] lenny main > apt-get install mysql-server-5.1 > mysql -u root -p mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'YourRootDBPassword'; mysql> exit To edit your mysql: nano /etc/mysql/my.cnf Or use WinSCP Remember: #bind-address = 127.0.0.1 And now you can use your perfect mysql server in your favorite SQL Editor in windows Best Regards

Mangos with many custom pathes (Maybe not clean mangos related) Hi, sometimes i have two related crashes: http://pastebin.com/AKKdZwGe http://pastebin.com/zttEJv2X Maybe pet and threat related, but in crashdump i see soo big guid values for ownerid (ownerid = 17379391026692020671), is normal? and is normal have these values too in table pet_aura at caster_guid? Some ideas? Best regards

Really impresive work XTZGZoReX, i would test your patch in 3K server but without mtmaps support my CPU will die =(. Some posibility to do compatible actual ACE Mtmaps with your patch? Thank and best regards

Only char, world and realmd dont affect system performance.

Someone have some progress in this project? or really this wonderfull work is go dead?

Core patch crash server on some move items in guild banks where player=0x0 http://pastebin.com/1jUUNNcs Maybe need check for null players: if (pProto->Quality > 2 && pProto->Flags != 2048 && player) Best regards

Maybe core patch need some memleak fixs: diff --git a/src/game/Item.cpp b/src/game/Item.cpp index 2eb5c46..416604d 100644 --- a/src/game/Item.cpp +++ b/src/game/Item.cpp @@ -984,6 +984,7 @@ Item* Item::CreateItem( uint32 item, uint32 count, Player const* player ) sLog.outDetail("WoWArmory: write feed log (guid: %u, type: 2, data: %u", player->GetGUIDLow(), item); ss << "UPDATE character_feed_log SET counter=counter+1, date=NOW() WHERE guid=" << player->GetGUIDLow() << " AND type=2 AND data=" << item << " LIMIT 1"; CharacterDatabase.PExecute( ss.str().c_str() ); + delete result; } else { diff --git a/src/game/Player.cpp b/src/game/Player.cpp index bc6286e..7daa232 100644 --- a/src/game/Player.cpp +++ b/src/game/Player.cpp @@ -22053,6 +22053,7 @@ void Player::WriteWowArmoryDatabaseLog(uint32 type, uint32 data) if (result) { CharacterDatabase.PExecute("UPDATE character_feed_log SET counter=counter+1, date=NOW() WHERE guid='%u' AND type=3 AND data='%u' LIMIT 1", pGuid, data); + delete result; } else { Best Regards

Confirmed, still freeze on high population reconnect after crash =( Debian Lenny and Realmd dedicated server.

Confirm this crash

--disable-builtin-ace in your configure ^^

Maybe you need use less VMAPS: vmap.ignoreMapIds = "369, 0, 1, 571, 530" or vmap.ignoreMapIds = "0,1,13,37,169,369,449,450,530,571,582,584,586,587,588,589,590,591,592,593,594,596,597,598,606,610,612,613,614,620,621,622,623,624"

You not patch source correctly with mtmaps patch

Not normal... are you compile tbb ok?