Erreur : corrupted double-linked list

Erreur : corrupted double-linked list - Réseaux - Systèmes & Réseaux Pro

Marsh Posté le 25-11-2009 à 11:03:09    

Bonjour à tous,
 
Je poste ce message dans la catégorie Système, mais cela peut probablement n'être qu'un problème de base de données.
Mon problème: lorsque je suis connecté en SSH sur mon serveur, je vois parfois apparaître un message qui défile, sans que je n'entre aucune commande, le voici:
 

Code :
  1. nsXXXXXX:~/dump# *** glibc detected *** /usr/sbin/mysqld: corrupted double-linked list: 0x0000000001471ff0 ***
  2. ======= Backtrace: =========
  3. /lib/libc.so.6[0x7fcd2f1a6948]
  4. /lib/libc.so.6[0x7fcd2f1a8888]
  5. /lib/libc.so.6(cfree+0x76)[0x7fcd2f1a8a56]
  6. /usr/sbin/mysqld(_ZN10Field_blob7val_strEP6StringS1_+0x73)[0x5bc8a3]
  7. /usr/sbin/mysqld(_Z10field_convP5FieldS0_+0x17f)[0x6b3faf]
  8. /usr/sbin/mysqld(_ZN10Item_field13save_in_fieldEP5Fieldb+0x49)[0x54e4c9]
  9. /usr/sbin/mysqld(_Z11fill_recordP3THDPP5FieldR4ListI4ItemEb+0x4a)[0x604a7a]
  10. /usr/sbin/mysqld(_ZN12select_union9send_dataER4ListI4ItemE+0x4c)[0x6d7e6c]
  11. /usr/sbin/mysqld[0x614651]
  12. /usr/sbin/mysqld[0x6176b6]
  13. /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x89)[0x61c549]
  14. /usr/sbin/mysqld[0x61eb9d]
  15. /usr/sbin/mysqld(_ZN4JOIN4execEv+0x4e5)[0x62f7d5]
  16. /usr/sbin/mysqld(_ZN18st_select_lex_unit4execEv+0x1df)[0x6d80bf]
  17. /usr/sbin/mysqld(_Z11mysql_unionP3THDP6st_lexP13select_resultP18st_select_lex_unitm+0x68)[0x6d9428]
  18. /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x50)[0x631330]
  19. /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x208b)[0x5e567b]
  20. /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x24f)[0x5e8c3f]
  21. /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x96b)[0x5eb1bb]
  22. /usr/sbin/mysqld(handle_one_connection+0x85e)[0x5ec99e]
  23. /lib/libpthread.so.0[0x7fcd30082fc7]
  24. /lib/libc.so.6(clone+0x6d)[0x7fcd2f2025ad]
  25. ======= Memory map: ========
  26. 00400000-00b42000 r-xp 00000000 09:01 132604                             /usr/sbin/mysqld
  27. 00d41000-00dbc000 rw-p 00741000 09:01 132604                             /usr/sbin/mysqld
  28. 00dbc000-05475000 rw-p 00000000 00:00 0                                  [heap]
  29. 40084000-40085000 ---p 00000000 00:00 0
  30. 40085000-400a5000 rw-p 00000000 00:00 0
  31. 40124000-40125000 ---p 00000000 00:00 0
  32. 40125000-40145000 rw-p 00000000 00:00 0
  33. 404d8000-404d9000 ---p 00000000 00:00 0
  34. 404d9000-40cd9000 rw-p 00000000 00:00 0
  35. 40cd9000-40cda000 ---p 00000000 00:00 0
  36. 40cda000-40cfa000 rw-p 00000000 00:00 0
  37. 40cfa000-40cfb000 ---p 00000000 00:00 0
  38. 40cfb000-40d1b000 rw-p 00000000 00:00 0
  39. 40d1b000-40d1c000 ---p 00000000 00:00 0
  40. 40d1c000-40d3c000 rw-p 00000000 00:00 0
  41. 40d4a000-40d4b000 ---p 00000000 00:00 0
  42. 40d4b000-40d6b000 rw-p 00000000 00:00 0
  43. 40d6b000-40d6c000 ---p 00000000 00:00 0
  44. 40d6c000-40d8c000 rw-p 00000000 00:00 0
  45. 40d8c000-40d8d000 ---p 00000000 00:00 0
  46. 40d8d000-40dad000 rw-p 00000000 00:00 0
  47. 40faf000-40fb0000 ---p 00000000 00:00 0
  48. 40fb0000-40fd0000 rw-p 00000000 00:00 0
  49. 41464000-41465000 ---p 00000000 00:00 0
  50. 41465000-41c65000 rw-p 00000000 00:00 0
  51. 41c65000-41c66000 ---p 00000000 00:00 0
  52. 41c66000-41c86000 rw-p 00000000 00:00 0
  53. 41c86000-41c87000 ---p 00000000 00:00 0
  54. 41c87000-41ca7000 rw-p 00000000 00:00 0
  55. 41ca7000-41ca8000 ---p 00000000 00:00 0
  56. 41ca8000-41cc8000 rw-p 00000000 00:00 0
  57. 41cc8000-41cc9000 ---p 00000000 00:00 0
  58. 41cc9000-41ce9000 rw-p 00000000 00:00 0
  59. 41ce9000-41cea000 ---p 00000000 00:00 0
  60. 41cea000-41d0a000 rw-p 00000000 00:00 0
  61. 41dd8000-41dd9000 ---p 00000000 00:00 0
  62. 41dd9000-425d9000 rw-p 00000000 00:00 0
  63. 425d9000-425da000 ---p 00000000 00:00 0
  64. 425da000-42dda000 rw-p 00000000 00:00 0
  65. 42dda000-42ddb000 ---p 00000000 00:00 0
  66. 42ddb000-435db000 rw-p 00000000 00:00 0
  67. 435db000-435dc000 ---p 00000000 00:00 0
  68. 435dc000-43ddc000 rw-p 00000000 00:00 0
  69. 43ddc000-43ddd000 ---p 00000000 00:00 0
  70. 43ddd000-445dd000 rw-p 00000000 00:00 0
  71. 445dd000-445de000 ---p 00000000 00:00 0
  72. 445de000-44dde000 rw-p 00000000 00:00 0
  73. 7fccec000000-7fcceeae5000 rw-p 00000000 00:00 0
  74. 7fcceeae5000-7fccf0000000 ---p 00000000 00:00 0
  75. 7fccf4000000-7fccf71a2000 rw-p 00000000 00:00 0
  76. 7fccf71a2000-7fccf8000000 ---p 00000000 00:00 0
  77. 7fccf8003000-7fcd28000000 rw-p 00000000 00:00 0
  78. 7fcd28000000-7fcd2b4d7000 rw-p 00000000 00:00 0
  79. 7fcd2b4d7000-7fcd2c000000 ---p 00000000 00:00 0
  80. 7fcd2d77b000-7fcd2d78b000 r-xp 00000000 09:01 97847                      /lib/libresolv-2.7.so
  81. 7fcd2d78b000-7fcd2d98b000 ---p 00010000 09:01 97847
  82. ...
  83. ...etc         
  84. ...
  85. Et ca reste en attente. Je dois reprendre la main avec Ctrl+C.


 
La base crashe par intermittence, quelque fois par jour, un peu aléatoirement. (Je ne peux pas la redémarrer, je suis obligé de killer le processus et de démarrer mysql.)
Du coup, comme je vois /usr/sbin/mysqld dans l'erreur, je me dis que c'est bien la base qui pose problème.
Une des pistes serait que je n'ai pas fait gaffe et que j'ai monté la base avec un fichier de backup, et ce en production, cad que les visiteurs tapaient dans mysql alors que la base était en train de se "construire".
 
Avez-vous une idée du pourquoi de cette erreur (qui fait probablement crasher mysql) ?
 
Merci beaucoup pour votre aide.

Reply

Marsh Posté le 25-11-2009 à 11:03:09   

Reply

Marsh Posté le 03-05-2010 à 22:58:20    

Bonsoir,
 
J'ai exactement le même problème. Le crash arrive tous les 2-3 jours.
As-tu trouvé une solution ?
Quelqu'un aurait-il une piste ?

Reply

Marsh Posté le 04-05-2010 à 08:48:22    

Non pour ma part, pas trouvé de réelle solution désolé.
J'ai juste relancé la réinstall complète du serveur. Et j'ai optimisé un petit peu la BDD ainsi que mes requetes. Ca ne bugge plus. Seulement ca tombe qq fois, mais c'est dû au trafic important je pense.


---------------
Direct-download.com, le moteur de recherche pour Mega
Reply

Marsh Posté le 04-05-2010 à 10:01:56    

Ok, merci pour les précisions.
Pour ma part, le bug ne doit pas venir d'un trop grand trafic puisque apparemment le nombre de connections max est à 5 au moment du plantage. De plus je ne vois pas non plus de pic de charge. C'est vraiment étrange...
Je vais voir si ça arrive encore. Je mets la partie intéressante de mon syslog ici si jamais ça intéresse quelqu'un.
 

May  3 18:16:02 r32872 mysqld[30820]: *** glibc detected *** /usr/sbin/mysqld: corrupted double-linked list: 0x0000000001525ff0 ***
May  3 18:16:02 r32872 mysqld[30820]: ======= Backtrace: =========
May  3 18:16:02 r32872 mysqld[30820]: /lib/libc.so.6[0x7fbf866fd928]
May  3 18:16:02 r32872 mysqld[30820]: /lib/libc.so.6[0x7fbf866ff868]
May  3 18:16:02 r32872 mysqld[30820]: /lib/libc.so.6(cfree+0x76)[0x7fbf866ffa36]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_mi_write_blob_record+0x6c)[0x8607ec]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(mi_write+0x69a)[0x86397a]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld[0x61e5e8]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld[0x617832]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x89)[0x61c6e9]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld[0x617832]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x89)[0x61c6e9]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld[0x617832]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x89)[0x61c6e9]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld[0x61ed3d]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x7b5)[0x62fc45]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12a)[0x62c9fa]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x153)[0x6315d3]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x208b)[0x5e580b]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x24f)[0x5e8dcf]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x96b)[0x5eb34b]
May  3 18:16:02 r32872 mysqld[30820]: /usr/sbin/mysqld(handle_one_connection+0x85e)[0x5ecb2e]
May  3 18:16:02 r32872 mysqld[30820]: /lib/libpthread.so.0[0x7fbf875d9fc7]
May  3 18:16:02 r32872 mysqld[30820]: /lib/libc.so.6(clone+0x6d)[0x7fbf8675959d]
May  3 18:16:02 r32872 mysqld[30820]: ======= Memory map: ========
May  3 18:16:02 r32872 mysqld[30820]: 00400000-00b42000 r-xp 00000000 08:01 229540                             /usr/sbin/mysqld
May  3 18:16:02 r32872 mysqld[30820]: 00d41000-00dbc000 rw-p 00741000 08:01 229540                             /usr/sbin/mysqld
May  3 18:16:02 r32872 mysqld[30820]: 00dbc000-018c2000 rw-p 00000000 00:00 0                                  [heap]
May  3 18:16:02 r32872 mysqld[30820]: 400d4000-400d5000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 400d5000-400f5000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4052e000-4052f000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4052f000-4054f000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 406b3000-406b4000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 406b4000-40eb4000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 40eb4000-40eb5000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 40eb5000-416b5000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416b5000-416b6000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416b6000-416d6000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416d6000-416d7000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416d7000-416f7000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416f7000-416f8000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 416f8000-41718000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 41970000-41971000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 41971000-41991000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 41a48000-41a49000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 41a49000-42249000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 42249000-4224a000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4224a000-42a4a000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 42a4a000-42a4b000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 42a4b000-4324b000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4324b000-4324c000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4324c000-43a4c000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 43a4c000-43a4d000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 43a4d000-4424d000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4424d000-4424e000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 4424e000-44a4e000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf78000000-7fbf78105000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf78105000-7fbf7c000000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf80000000-7fbf80d16000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf80d16000-7fbf84000000 ---p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf84098000-7fbf8429d000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf845ad000-7fbf8606b000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8606b000-7fbf86075000 r-xp 00000000 08:01 205131                     /lib/libnss_files-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86075000-7fbf86275000 ---p 0000a000 08:01 205131                     /lib/libnss_files-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86275000-7fbf86277000 rw-p 0000a000 08:01 205131                     /lib/libnss_files-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86277000-7fbf86280000 r-xp 00000000 08:01 205128                     /lib/libnss_nis-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86280000-7fbf86480000 ---p 00009000 08:01 205128                     /lib/libnss_nis-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86480000-7fbf86482000 rw-p 00009000 08:01 205128                     /lib/libnss_nis-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86482000-7fbf86489000 r-xp 00000000 08:01 205133                     /lib/libnss_compat-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86489000-7fbf86688000 ---p 00007000 08:01 205133                     /lib/libnss_compat-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86688000-7fbf8668a000 rw-p 00006000 08:01 205133                     /lib/libnss_compat-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8668a000-7fbf867d4000 r-xp 00000000 08:01 205144                     /lib/libc-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf867d4000-7fbf869d3000 ---p 0014a000 08:01 205144                     /lib/libc-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf869d3000-7fbf869d6000 r--p 00149000 08:01 205144                     /lib/libc-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf869d6000-7fbf869d8000 rw-p 0014c000 08:01 205144                     /lib/libc-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf869d8000-7fbf869dd000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf869dd000-7fbf869f3000 r-xp 00000000 08:01 205089                     /lib/libgcc_s.so.1
May  3 18:16:02 r32872 mysqld[30820]: 7fbf869f3000-7fbf86bf3000 ---p 00016000 08:01 205089                     /lib/libgcc_s.so.1
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86bf3000-7fbf86bf4000 rw-p 00016000 08:01 205089                     /lib/libgcc_s.so.1
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86bf4000-7fbf86c76000 r-xp 00000000 08:01 205149                     /lib/libm-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86c76000-7fbf86e75000 ---p 00082000 08:01 205149                     /lib/libm-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86e75000-7fbf86e77000 rw-p 00081000 08:01 205149                     /lib/libm-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86e77000-7fbf86f68000 r-xp 00000000 08:01 222947                     /usr/lib/libstdc++.so.6.0.10
May  3 18:16:02 r32872 mysqld[30820]: 7fbf86f68000-7fbf87167000 ---p 000f1000 08:01 222947                     /usr/lib/libstdc++.so.6.0.10
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87167000-7fbf8716d000 r--p 000f0000 08:01 222947                     /usr/lib/libstdc++.so.6.0.10
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8716d000-7fbf87170000 rw-p 000f6000 08:01 222947                     /usr/lib/libstdc++.so.6.0.10
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87170000-7fbf87183000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87183000-7fbf87198000 r-xp 00000000 08:01 205143                     /lib/libnsl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87198000-7fbf87397000 ---p 00015000 08:01 205143                     /lib/libnsl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87397000-7fbf87399000 rw-p 00014000 08:01 205143                     /lib/libnsl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87399000-7fbf8739b000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8739b000-7fbf873a3000 r-xp 00000000 08:01 205142                     /lib/libcrypt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf873a3000-7fbf875a3000 ---p 00008000 08:01 205142                     /lib/libcrypt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf875a3000-7fbf875a5000 rw-p 00008000 08:01 205142                     /lib/libcrypt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf875a5000-7fbf875d3000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf875d3000-7fbf875e9000 r-xp 00000000 08:01 205147                     /lib/libpthread-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf875e9000-7fbf877e9000 ---p 00016000 08:01 205147                     /lib/libpthread-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf877e9000-7fbf877eb000 rw-p 00016000 08:01 205147                     /lib/libpthread-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf877eb000-7fbf877ef000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf877ef000-7fbf877f1000 r-xp 00000000 08:01 205136                     /lib/libdl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf877f1000-7fbf879f1000 ---p 00002000 08:01 205136                     /lib/libdl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf879f1000-7fbf879f3000 rw-p 00002000 08:01 205136                     /lib/libdl-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf879f3000-7fbf879fb000 r-xp 00000000 08:01 205124                     /lib/libwrap.so.0.7.6
May  3 18:16:02 r32872 mysqld[30820]: 7fbf879fb000-7fbf87bfa000 ---p 00008000 08:01 205124                     /lib/libwrap.so.0.7.6
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87bfa000-7fbf87bfc000 rw-p 00007000 08:01 205124                     /lib/libwrap.so.0.7.6
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87bfc000-7fbf87c12000 r-xp 00000000 08:01 222954                     /usr/lib/libz.so.1.2.3.3
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87c12000-7fbf87e12000 ---p 00016000 08:01 222954                     /usr/lib/libz.so.1.2.3.3
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87e12000-7fbf87e13000 rw-p 00016000 08:01 222954                     /usr/lib/libz.so.1.2.3.3
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87e13000-7fbf87e1b000 r-xp 00000000 08:01 205135                     /lib/librt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf87e1b000-7fbf8801a000 ---p 00008000 08:01 205135                     /lib/librt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8801a000-7fbf8801c000 rw-p 00007000 08:01 205135                     /lib/librt-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf8801c000-7fbf88038000 r-xp 00000000 08:01 205138                     /lib/ld-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fbf88051000-7fbf88230000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf88233000-7fbf88237000 rw-p 00000000 00:00 0
May  3 18:16:02 r32872 mysqld[30820]: 7fbf88237000-7fbf88239000 rw-p 0001b000 08:01 205138                     /lib/ld-2.7.so
May  3 18:16:02 r32872 mysqld[30820]: 7fff5bcea000-7fff5bcff000 rw-p 00000000 00:00 0                          [stack]
May  3 18:16:02 r32872 mysqld[30820]: 7fff5bd28000-7fff5bd29000 r-xp 00000000 00:00 0                          [vdso]
May  3 18:16:02 r32872 mysqld[30820]: ffffffffff600000-ffffffffff601000 r--p 00000000 00:00 0                  [vsyscall]
May  3 18:16:02 r32872 mysqld[30820]: 100503 18:16:02 - mysqld got signal 6;
May  3 18:16:02 r32872 mysqld[30820]: This could be because you hit a bug. It is also possible that this binary
May  3 18:16:02 r32872 mysqld[30820]: or one of the libraries it was linked against is corrupt, improperly built,
May  3 18:16:02 r32872 mysqld[30820]: or misconfigured. This error can also be caused by malfunctioning hardware.
May  3 18:16:02 r32872 mysqld[30820]: We will try our best to scrape up some info that will hopefully help diagnose
May  3 18:16:02 r32872 mysqld[30820]: the problem, but since we have already crashed, something is definitely wrong
May  3 18:16:02 r32872 mysqld[30820]: and this may fail.
May  3 18:16:02 r32872 mysqld[30820]:
May  3 18:16:02 r32872 mysqld[30820]: key_buffer_size=12582912
May  3 18:16:02 r32872 mysqld[30820]: read_buffer_size=131072
May  3 18:16:02 r32872 mysqld[30820]: max_used_connections=5
May  3 18:16:02 r32872 mysqld[30820]: max_connections=50
May  3 18:16:02 r32872 mysqld[30820]: threads_connected=2
May  3 18:16:02 r32872 mysqld[30820]: It is possible that mysqld could use up to
May  3 18:16:02 r32872 mysqld[30820]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 121087 K
May  3 18:16:02 r32872 mysqld[30820]: bytes of memory
May  3 18:16:02 r32872 mysqld[30820]: Hope that's ok; if not, decrease some variables in the equation.
May  3 18:16:02 r32872 mysqld[30820]:
May  3 18:16:02 r32872 mysqld[30820]: thd=0x7fbf80c41d00
May  3 18:16:02 r32872 mysqld[30820]: Attempting backtrace. You can use the following information to find out
May  3 18:16:02 r32872 mysqld[30820]: where mysqld died. If you see no messages after this, something went
May  3 18:16:02 r32872 mysqld[30820]: terribly wrong...
May  3 18:16:02 r32872 mysqld[30820]: Cannot determine thread, fp=0x7fbf80c41d00, backtrace may not be correct.
May  3 18:16:02 r32872 mysqld[30820]: Bogus stack limit or frame pointer, fp=0x7fbf80c41d00, stack_bottom=0x40100000, thread_stack=131072, aborting backtrace.
May  3 18:16:02 r32872 mysqld[30820]: Trying to get some variables.
May  3 18:16:02 r32872 mysqld[30820]: Some pointers may be invalid and cause the dump to abort...
May  3 18:16:02 r32872 mysqld[30820]: thd->query at 0x1344970 = SELECT
...
Ici un select avec deux jointures et un order by rand()
...
May  3 18:16:02 r32872 mysqld[30820]: thd->thread_id=39819
May  3 18:16:02 r32872 mysqld[30820]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains
May  3 18:16:02 r32872 mysqld[30820]: information that should help you find out what is causing the crash.

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed