Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.14
-
Linux Debian 9
MariaDB 10.3.14
with Galera with 2 nodes Master-Master
Kernel 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3.1 (2019-02-19) x86_64 GNU/Linux
Description
May 27 21:36:22 ands1 mysqld[31676]: 190527 21:36:22 [ERROR] mysqld got signal 11 ;
May 27 21:36:22 ands1 mysqld[31676]: This could be because you hit a bug. It is also possible that this binary
May 27 21:36:22 ands1 mysqld[31676]: or one of the libraries it was linked against is corrupt, improperly built,
May 27 21:36:22 ands1 mysqld[31676]: or misconfigured. This error can also be caused by malfunctioning hardware.
May 27 21:36:22 ands1 mysqld[31676]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
May 27 21:36:22 ands1 mysqld[31676]: We will try our best to scrape up some info that will hopefully help
May 27 21:36:22 ands1 mysqld[31676]: diagnose the problem, but since we have already crashed,
May 27 21:36:22 ands1 mysqld[31676]: something is definitely wrong and this may fail.
May 27 21:36:22 ands1 mysqld[31676]: Server version: 10.3.14-MariaDB-1:10.3.14+maria~stretch-log
May 27 21:36:22 ands1 mysqld[31676]: key_buffer_size=268435456
May 27 21:36:22 ands1 mysqld[31676]: read_buffer_size=4194304
May 27 21:36:22 ands1 mysqld[31676]: max_used_connections=110
May 27 21:36:22 ands1 mysqld[31676]: max_threads=502
May 27 21:36:22 ands1 mysqld[31676]: thread_count=88
May 27 21:36:22 ands1 mysqld[31676]: It is possible that mysqld could use up to
May 27 21:36:22 ands1 mysqld[31676]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 35228582 K bytes of memory
May 27 21:36:22 ands1 mysqld[31676]: Hope that's ok; if not, decrease some variables in the equation.
May 27 21:36:22 ands1 mysqld[31676]: Thread pointer: 0x7ff3380008c8
May 27 21:36:22 ands1 mysqld[31676]: Attempting backtrace. You can use the following information to find out
May 27 21:36:22 ands1 mysqld[31676]: where mysqld died. If you see no messages after this, something went
May 27 21:36:22 ands1 mysqld[31676]: terribly wrong...
May 27 21:36:22 ands1 mysqld[31676]: stack_bottom = 0x7ff3a81a4cf8 thread_stack 0x49000
May 27 21:36:22 ands1 mysqld[31676]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5575f821592e]
May 27 21:36:22 ands1 mysqld[31676]: /usr/sbin/mysqld(handle_fatal_signal+0x41f)[0x5575f7cc6a5f]
May 27 21:36:23 ands1 mysqld[31676]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4554df0e0]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x92)[0x5575f7bf95b2]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN20get_best_combinationEv+0xbf)[0x5575f7b1ac0f]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN15optimize_stage2Ev+0x173)[0x5575f7b38593]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x75)[0x5575f7b3d115]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0xd3)[0x5575f7ab0db3]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x162)[0x5575f7ab05a2]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5575f7acb587]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN15optimize_stage2Ev+0x193)[0x5575f7b385b3]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0xf75)[0x5575f7b3b755]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x37)[0x5575f7b3d0d7]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x8a3)[0x5575f7b3ef33]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0xf8)[0x5575f7b3f0a8]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(+0x48b259)[0x5575f7a02259]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1a6b)[0x5575f7ae789b]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x21a)[0x5575f7aee8da]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(+0x578189)[0x5575f7aef189]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x10f1)[0x5575f7af0741]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x131)[0x5575f7af1f11]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25a)[0x5575f7bc3dda]
May 27 21:36:23 ands1 mysqld[31676]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5575f7bc3f5d]
May 27 21:36:23 ands1 mysqld[31676]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x74a4)[0x7ff4554d54a4]
May 27 21:36:23 ands1 mysqld[31676]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7ff453c34d0f]
May 27 21:36:23 ands1 mysqld[31676]: Trying to get some variables.
May 27 21:36:23 ands1 mysqld[31676]: Some pointers may be invalid and cause the dump to abort.
May 27 21:36:23 ands1 mysqld[31676]: Query (0x7ff338049100): SELECT vue_ands_inscriptions_suivi_0.id_inscription, vue_ands_inscriptions_suivi_0.id_evenement, vue_ands_inscriptions_suivi_0.reference_i, vue_ands_inscriptions_suivi_0.desiste, vu
e_ands_inscriptions_suivi_0.civilite, vue_ands_inscriptions_suivi_0.nom, vue_ands_inscriptions_suivi_0.particule, vue_ands_inscriptions_suivi_0.prenom, vue_ands_inscriptions_suivi_0.date_naissance, vue_ands_inscriptions_suivi_0.age, vue_ands_
inscriptions_suivi_0.adresse1, vue_ands_inscriptions_suivi_0.adresse2, vue_ands_inscriptions_suivi_0.adresse3, vue_ands_inscriptions_suivi_0.code_postal, vue_ands_inscriptions_suivi_0.ville, vue_ands_inscriptions_suivi_0.pays, vue_ands_inscri
ptions_suivi_0.telephone, vue_ands_inscriptions_suivi_0.mobile, vue_ands_inscriptions_suivi_0.email, vue_ands_inscriptions_suivi_0.mineur, vue_ands_inscriptions_suivi_0.malade, vue_ands_inscriptions_suivi_0.type_referent, vue_ands_inscription
s_suivi_0.nom_referent, vue_ands_inscriptions_suivi_0.referent_valide, vue_ands_inscriptions_suivi_0.mobile_referent, vue_ands_inscriptions_suivi_0.confirm_reception_autorisation_parentale, vue_ands_inscriptions_suivi_0.photo, vue_ands_inscri
ptions_suivi_0.comite_di, vue_ands_inscriptions_suivi_0.transport, vue_ands_inscriptions_suivi_0.transport_aller, vue_ands_inscriptions_suivi_0.transport_retour, vue_ands_inscriptions_suivi_0.aller_retour, vue_ands_inscriptions_suivi_0.date_a
rrivee_i, vue_ands_inscriptions_suivi_0.date_depart_i, vue_ands_inscriptions_suivi_0.hebergement, vue_ands_inscriptions_suivi_0.nom_hebergement, vue_ands_inscriptions_suivi_0.nds, vue_ands_inscriptions_suivi_0.souhaite_servir, vue_ands_inscri
ptions_suivi_0.souhaite_participer, vue_ands_inscriptions_suivi_0.engagement, vue_ands_inscriptions_suivi_0.activite_souhait, vue_ands_inscriptions_suivi_0.activite_validee, vue_ands_inscriptions_suivi_0.pole_souhait, vue_ands_inscriptions_su
ivi_0.service_souhait, vue_ands_inscriptions_suivi_0.equipe_souhait, vue_ands_inscriptions_suivi_0.equipe_validee, vue_ands_inscriptions_suivi_0.fonc
May 27 21:36:23 ands1 mysqld[31676]: tion, vue_ands_inscriptions_suivi_0.affectation_commentaire, vue_ands_inscriptions_suivi_0.mineur_has_premiere_communion, vue_ands_inscriptions_suivi_0.mineur_autoriser_piscine, vue_ands_inscriptions_suivi
_0.mineur_autoriser_quitter_seul_activite, vue_ands_inscriptions_suivi_0.id_dossier_inscription, vue_ands_inscriptions_suivi_0.reference_di, vue_ands_inscriptions_suivi_0.nom_di, vue_ands_inscriptions_suivi_0.paiement_differe, vue_ands_inscri
ptions_suivi_0.montant_total_di, vue_ands_inscriptions_suivi_0.paiements_di, vue_ands_inscriptions_suivi_0.solde_di, vue_ands_inscriptions_suivi_0.createur_comite, vue_ands_inscriptions_suivi_0.date_creation_di, inscription_0.service_date_arr
ivee, inscription_0.service_date_depart, vue_ands_inscriptions_suivi_0.volont_id, vue_ands_inscriptions_suivi_0.nom_evenement FROM annuaire_ands.inscription inscription_0, annuaire_ands.vue_ands_inscriptions_suivi vue_ands_inscriptions_suivi
_0 WHERE inscription_0.id_inscription = vue_ands_inscriptions_suivi_0.id_inscription AND ((vue_ands_inscriptions_suivi_0.comite_di='Toulouse') AND (vue_ands_inscriptions_suivi_0.id_evenement=16)) ORDER BY inscription_0.id_inscription
May 27 21:36:23 ands1 mysqld[31676]: Connection ID (thread ID): 206609
May 27 21:36:23 ands1 mysqld[31676]: Status: NOT_KILLED
May 27 21:36:23 ands1 mysqld[31676]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,deriv
ed_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with
_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
,split_materialized=on
May 27 21:36:23 ands1 mysqld[31676]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
May 27 21:36:23 ands1 mysqld[31676]: information that should help you find out what is causing the crash.
May 27 21:36:23 ands1 kernel: [7902428.720749] mysqld[5754]: segfault at 0 ip 00005575f7bf95b2 sp 00007ff3a81a20e0 error 4 in mysqld[5575f7577000+1260000]
May 27 21:36:23 ands1 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
May 27 21:36:24 ands1 systemd[1]: mariadb.service: Unit entered failed state.
May 27 21:36:24 ands1 systemd[1]: mariadb.service: Failed with result 'signal'.
May 27 21:36:29 ands1 systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
May 27 21:36:29 ands1 systemd[1]: Stopped MariaDB 10.3.14 database server.
Attachments
Issue Links
- duplicates
-
MDEV-13607 MariaDB crash in fix_semijoin_strategies_for_picked_join_order
- Closed
- relates to
-
MDEV-18479 Assertion `join->best_read < double(1.79769313486231570815e+308L)' or server crashes in JOIN::fix_all_splittings_in_plan after EXPLAIN
- Closed