[OregonCore]Crash a la déconnection
Bonjour , après test avec gdb voilà le backtrace full en console :

Citation :No symbol table info available.
#1 0xb7938751 in raise () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#2 0xb793bb82 in abort () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#3 0xb796f18d in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#4 0xb7979281 in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#5 0xb79796da in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#6 0xb797b7ed in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#7 0xb797dc8c in malloc () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#8 0xb7981150 in strdup () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#9 0x0856d9fc in bool Database::AsyncQuery<CharacterHandler, unsigned int>(CharacterHandler*, void (CharacterHandler::*)(ACE_Refcounted_Auto_Ptr<QueryResult, ACE_Null_Mutex>, unsigned int), unsigned int, char const*) ()
No symbol table info available.
#10 0x0856db95 in bool Database::AsyncPQuery<CharacterHandler, unsigned int>(Cha

Et notre fonction qui me semble crasher [code=cpp]void WorldSession::HandleCharEnumOpcode(WorldPacket & /*recv_data*/)
{
// get all the data necessary for loading all characters (along with their pets) on the account
CharacterDatabase.AsyncPQuery(&chrHandler, &CharacterHandler::HandleCharEnumCallback, GetAccountId(),
!sWorld.getConfig(CONFIG_DECLINED_NAMES_USED) ?
// ------- Query Without Declined Names --------
// 0 1 2 3 4 5 6 7
"SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, "
// 8 9 10 11 12 13 14
"characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, "
// 15 16 17 18 19
"characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.equipmentCache "
"FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' "
"LEFT JOIN guild_member ON characters.guid = guild_member.guid "
"WHERE characters.account = '%u' ORDER BY characters.guid"
:
// --------- Query With Declined Names ---------
// 0 1 2 3 4 5 6 7
"SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, "
// 8 9 10 11 12 13 14
"characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, "
// 15 16 17 18 19 20
"characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.equipmentCache, character_declinedname.genitive "
"FROM characters LEFT JOIN character_pet ON characters.guid = character_pet.owner AND character_pet.slot='0' "
"LEFT JOIN character_declinedname ON characters.guid = character_declinedname.guid "
"LEFT JOIN guild_member ON characters.guid = guild_member.guid "
"WHERE characters.account = '%u' ORDER BY characters.guid",
GetAccountId());
}[/code]

Je comprend pas ce qui crash sérieux
Tu as essayé de passer la requête dans ton moteur SQL à la main.. en mettant une valeur pour tester ?
Les deux fonctionnent ouai , ça crash a chaque déconnection du client ... La galère
Édition :
J'ai changé le core (nu) , et ça me le fait aussi . Comment je peux refaire ma DB characters (car ça vient apparemment de là) sans tout perdre ?
Édition :
Code :
*** glibc detected *** /home/asedic/OC/bin/oregon-core: corrupted double-linked list: 0x0f377938 ***
======= Backtrace: =========
/lib/i686/cmov/libc.so.6(+0x6b281)[0xb7979281]
/lib/i686/cmov/libc.so.6(+0x6b6da)[0xb79796da]
/lib/i686/cmov/libc.so.6(+0x6ca55)[0xb797aa55]
/lib/i686/cmov/libc.so.6(cfree+0x6d)[0xb797dbbd]
/home/asedic/OC/bin/oregon-core(_ZN14SqlTransaction7ExecuteEP8Database+0x65)[0x85b6015]
/home/asedic/OC/bin/oregon-core(_ZN12SqlAsyncTask4callEv+0x2b)[0x85b074b]
/home/asedic/OC/bin/oregon-core(_ZN14SqlDelayThread3runEv+0x62)[0x85b05b2]
/home/asedic/OC/bin/oregon-core(_ZN9ACE_Based6Thread10ThreadTaskEPv+0x12)[0x85b8202]
/home/asedic/lib/libACE-5.8.1.so(_ZN21ACE_OS_Thread_Adapter6invokeEv+0x65)[0xb7efb7d5]
/home/asedic/lib/libACE-5.8.1.so(ace_thread_adapter+0x11)[0xb7ea5201]
/lib/i686/cmov/libpthread.so.0(+0x5955)[0xb7a59955]
/lib/i686/cmov/libc.so.6(clone+0x5e)[0xb79d9e7e]
======= Memory map: ========
08048000-089f0000 r-xp 00000000 08:01 11944050   /home/asedic/OC/bin/oregon-core
089f0000-089fb000 rw-p 009a8000 08:01 11944050   /home/asedic/OC/bin/oregon-core
089fb000-0f729000 rw-p 00000000 00:00 0          [heap]
ae400000-ae421000 rw-p 00000000 00:00 0
ae421000-ae500000 ---p 00000000 00:00 0
ae5ac000-ae5ad000 ---p 00000000 00:00 0
ae5ad000-aedad000 rwxp 00000000 00:00 0
aedad000-aedae000 ---p 00000000 00:00 0
aedae000-af5ae000 rwxp 00000000 00:00 0
af5ae000-af79d000 r--p 00000000 08:01 1213743    /usr/lib/locale/locale-archive
af79d000-af79e000 ---p 00000000 00:00 0
af79e000-aff9e000 rwxp 00000000 00:00 0
aff9e000-aff9f000 ---p 00000000 00:00 0
aff9f000-b079f000 rwxp 00000000 00:00 0
b079f000-b07a0000 ---p 00000000 00:00 0
b07a0000-b0fa0000 rwxp 00000000 00:00 0
b0fa0000-b238e000 rw-p 00000000 00:00 0
b24b7000-b24b8000 ---p 00000000 00:00 0
b24b8000-b2cb8000 rwxp 00000000 00:00 0
b2cb8000-b3cd6000 rw-p 00000000 00:00 0
b3e2d000-b3f4a000 rw-p 00000000 00:00 0
b3f8b000-b5f1a000 rw-p 00000000 00:00 0
b5f1a000-b5f1b000 ---p 00000000 00:00 0
b5f1b000-b671b000 rwxp 00000000 00:00 0
b671b000-b671c000 ---p 00000000 00:00 0
b671c000-b6f1c000 rwxp 00000000 00:00 0
b6f1c000-b6f26000 r-xp 00000000 08:01 6234225    /lib/i686/cmov/libnss_files-2.11.2.so
b6f26000-b6f27000 r--p 00009000 08:01 6234225    /lib/i686/cmov/libnss_files-2.11.2.so
b6f27000-b6f28000 rw-p 0000a000 08:01 6234225    /lib/i686/cmov/libnss_files-2.11.2.so
b6f28000-b6f29000 ---p 00000000 00:00 0
b6f29000-b7729000 rwxp 00000000 00:00 0
b7729000-b772b000 rw-p 00000000 00:00 0
b772b000-b773e000 r-xp 00000000 08:01 6234213    /lib/i686/cmov/libnsl-2.11.2.so
b773e000-b773f000 r--p 00012000 08:01 6234213    /lib/i686/cmov/libnsl-2.11.2.so
b773f000-b7740000 rw-p 00013000 08:01 6234213    /lib/i686/cmov/libnsl-2.11.2.so
b7740000-b7742000 rw-p 00000000 00:00 0
b7742000-b774b000 r-xp 00000000 08:01 6234197    /lib/i686/cmov/libcrypt-2.11.2.so
b774b000-b774c000 r--p 00008000 08:01 6234197    /lib/i686/cmov/libcrypt-2.11.2.so
b774c000-b774d000 rw-p 00009000 08:01 6234197    /lib/i686/cmov/libcrypt-2.11.2.so
b774d000-b7774000 rw-p 00000000 00:00 0
b7774000-b7776000 r-xp 00000000 08:01 6234198    /lib/i686/cmov/libdl-2.11.2.so
b7776000-b7777000 r--p 00001000 08:01 6234198    /lib/i686/cmov/libdl-2.11.2.so
b7777000-b7778000 rw-p 00002000 08:01 6234198    /lib/i686/cmov/libdl-2.11.2.so
b7778000-b7779000 rw-p 00000000 00:00 0
b7779000-b7780000 r-xp 00000000 08:01 6234203    /lib/i686/cmov/librt-2.11.2.so
b7780000-b7781000 r--p 00006000 08:01 6234203    /lib/i686/cmov/librt-2.11.2.so
b7781000-b7782000 rw-p 00007000 08:01 6234203    /lib/i686/cmov/librt-2.11.2.so
b7782000-b77b9000 r-xp 00000000 08:01 6234171    /lib/libncurses.so.5.7
b77b9000-b77bc000 rw-p 00036000 08:01 6234171    /lib/libncurses.so.5.7
b77bc000-b78f5000 r-xp 00000000 08:01 11666589   /home/asedic/lib/libcrypto.so.0.9.8
b78f5000-b790b000 rw-p 00139000 08:01 11666589   /home/asedic/lib/libcrypto.so.0.9.8
b790b000-b790e000 rw-p 00000000 00:00 0
b790e000-b7a4e000 r-xp 00000000 08:01 6234193    /lib/i686/cmov/libc-2.11.2.so
b7a4e000-b7a50000 r--p 0013f000 08:01 6234193    /lib/i686/cmov/libc-2.11.2.so
b7a50000-b7a51000 rw-p 00141000 08:01 6234193    /lib/i686/cmov/libc-2.11.2.so
b7a51000-b7a54000 rw-p 00000000 00:00 0
b7a54000-b7a69000 r-xp 00000000 08:01 6234221    /lib/i686/cmov/libpthread-2.11.2.so
b7a69000-b7a6a000 r--p 00014000 08:01 6234221    /lib/i686/cmov/libpthread-2.11.2.so
b7a6a000-b7a6b000 rw-p 00015000 08:01 6234221    /lib/i686/cmov/libpthread-2.11.2.so
b7a6b000-b7a6d000 rw-p 00000000 00:00 0
b7a6d000-b7a8a000 r-xp 00000000 08:01 6234245    /lib/libgcc_s.so.1
b7a8a000-b7a8b000 rw-p 0001c000 08:01 6234245    /lib/libgcc_s.so.1
b7a8b000-b7a8c000 rw-p 00000000 00:00 0
b7a8c000-b7ab0000 r-xp 00000000 08:01 6234185    /lib/i686/cmov/libm-2.11.2.so
b7ab0000-b7ab1000 r--p 00023000 08:01 6234185    /lib/i686/cmov/libm-2.11.2.so
b7ab1000-b7ab2000 rw-p 00024000 08:01 6234185    /lib/i686/cmov/libm-2.11.2.so
b7ab2000-b7b9b000 r-xp 00000000 08:01 1205649    /usr/lib/libstdc++.so.6.0.13
b7b9b000-b7b9f000 r--p 000e9000 08:01 1205649    /usr/lib/libstdc++.so.6.0.13
b7b9f000-b7ba0000 rw-p 000ed000 08:01 1205649    /usr/lib/libstdc++.so.6.0.13
b7ba0000-b7ba7000 rw-p 00000000 00:00 0
b7ba7000-b7bba000 r-xp 00000000 08:01 1204282    /usr/lib/libz.so.1.2.3.4
b7bba000-b7bbb000 rw-p 00013000 08:01 1204282    /usr/lib/libz.so.1.2.3.4
b7bbb000-b7c00000 r-xp 00000000 08:01 11666592   /home/asedic/lib/libssl.so.0.9.8
b7c00000-b7c04000 rw-p 00044000 08:01 11666592   /home/asedic/lib/libssl.so.0.9.8
b7c04000-b7db8000 r-xp 00000000 08:01 1205864    /usr/lib/libmysqlclient_r.so.16.0.0
b7db8000-b7db9000 ---p 001b4000 08:01 1205864    /usr/lib/libmysqlclient_r.so.16.0.0
b7db9000-b7dbd000 r--p 001b4000 08:01 1205864    /usr/lib/libmysqlclient_r.so.16.0.0
b7dbd000-b7e02000 rw-p 001b8000 08:01 1205864    /usr/lib/libmysqlclient_r.so.16.0.0
b7e02000-b7e04000 rw-p 00000000 00:00 0
b7e04000-b7f9b000 r-xp 00000000 08:01 11670087   /home/asedic/lib/libACE-5.8.1.so
b7f9b000-b7fa6000 rw-p 00197000 08:01 11670087   /home/asedic/lib/libACE-5.8.1.so
b7fa6000-b7fa7000 rw-p 00000000 00:00 0
b7fa7000-b7fd5000 r-xp 00000000 08:01 6234252    /lib/libreadline.so.5.2
b7fd5000-b7fd9000 rw-p 0002e000 08:01 6234252    /lib/libreadline.so.5.2
b7fd9000-b7fe3000 rw-p 00000000 00:00 0
b7fe3000-b7ffe000 r-xp 00000000 08:01 6234246    /lib/ld-2.11.2.so
b7ffe000-b7fff000 r--p 0001a000 08:01 6234246    /lib/ld-2.11.2.so
b7fff000-b8000000 rw-p 0001b000 08:01 6234246    /lib/ld-2.11.2.so
bffdf000-c0000000 rwxp 00000000 00:00 0          [stack]
ffffe000-fffff000 r-xp 00000000 00:00 0          [vdso]

Program received signal SIGABRT, Aborted.
[Switching to Thread 0xb6f1bb70 (LWP 829)]
0xffffe430 in __kernel_vsyscall ()

J'ai refais le backtrace Heureux
Édition :
Et le bt full
Code :
#0  0xffffe430 in __kernel_vsyscall ()
No symbol table info available.
#1  0xb7938751 in raise () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#2  0xb793bb82 in abort () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#3  0xb796f18d in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#4  0xb7979281 in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#5  0xb79796da in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#6  0xb797aa55 in ?? () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#7  0xb797dbbd in free () from /lib/i686/cmov/libc.so.6
No symbol table info available.
#8  0x085b6015 in SqlTransaction::Execute(Database*) ()
No symbol table info available.
#9  0x085b074b in SqlAsyncTask::call() ()
No symbol table info available.
#10 0x085b05b2 in SqlDelayThread::run() ()
No symbol table info available.
#11 0x085b8202 in ACE_Based::Thread::ThreadTask(void*) ()
C'est pas parce que tu a un core nu que c'est forcément la db.
D'ailleurs, il est défini que la db peut être fautive: c'est au core de corriger l'erreur.

Il y a de la corruption mémoire là dedans. C'est pas réellement un crash conventionnel.
Je comprend pas le backtrace , c'est un peu embettant pour la suite . J'aimerai bien savoir quelle fonction crash pour éssayer de comprendre d'où ça vient
Des fois faut faire table rase.. teste avec un core nu et db vierge ...
J'ai testé avec le même core que celui de prod , et une db characters vierge -> Aucun crash
J'ai testé avec avec le core de prod , la db characters vierge mais la table characters du serveur de prod -> Crash

J'en ai donc conclus que ça venait de là . Ce matin j'ai vu qu'il cherchait une colonne "data" dans characters que je n'avais pas dans les .sql donnés par oregon . J'ai créé cette colonne a la main mais ça a pas changé grand chose
Ahh ben cherche pas....

Ta table characters n’est pas à jour....

Et il ne faut PAS la rajouter.. elle n'existe plus.

Oregon est basé sur trinity je crois. et ils ont viré ce champ.

T'es bon pour trouver un convertisseur.
ben le code cherche cette colonne justement je comprend pas ...
ERf trop bizarre moi ej n'ai plus de colonne data.

Dans ce cas alors c'est une rétro conversion et c’est encore plus la merde....

Niveau emmerdement , fais plutôt une RAZ de ta table et basta.

Tu y perdras moins de temps.

Retourner en haut Accueil