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
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
It's seem to be a problem on Joined sub-query (or view) :
*When i run this I have not problem :
*
SELECT `evt`.`id_evenement` AS `id_evenement`,
`grpEvt`.`libelle_public` AS `nom_evenement`,
`p`.`id_personne` AS `id_personne`,
`bv_volontid`.`valeur` AS `volont_id`,
`i`.`id_inscription` AS `id_inscription`,
`i`.`reference` AS `reference_i`,
IF(`i`.`desiste` = 1, 1, 0) AS `desiste`,
concat(ifnull(`civ`.`nom_abrege`, ''), ifnull(`civ`.`exposant`, '')) AS `civilite`,
concat(ifnull(ucase(`p`.`nom`), ''), IF(octet_length(`p`.`particule`) > 0, concat(' (', `p`.`particule`, ')'), '')) AS `nom`,
ifnull(`p`.`particule`, '') AS `particule`,
`p`.`prenom` AS `prenom`,
date_format(`p`.`date_naissance`, '%d/%m/%Y') AS `date_naissance`,
YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY) AS `age`,
ifnull(`bv_p_branche`.`valeur`, '') AS `profession_branche`,
ifnull(`bv_p_metier`.`valeur`, '') AS `profession_metier`,
ifnull(`bv_p_specialite`.`valeur`, '') AS `profession_specialite`,
ucase(`c`.`adresse1`) AS `adresse1`,
ucase(`c`.`adresse2`) AS `adresse2`,
ucase(`c`.`adresse3`) AS `adresse3`,
`c`.`code_postal` AS `code_postal`,
ucase(`c`.`ville_cedex`) AS `ville`,
ucase(`c`.`pays_nom`) AS `pays`,
`c`.`telephone` AS `telephone`,
`c`.`mobile` AS `mobile`,
`c`.`email` AS `email`,
IF(
(YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY)) < 18, 1, 0) AS `mineur`,
IF(`i`.`personne_malade` = 1
OR `i`.`personne_handicapee` = 1, 1, 0) AS `malade`,
`i`.`type_referent` AS `type_referent`,
CASE
WHEN (`i`.`type_referent` = 'P'
OR `i`.`type_referent` = 'GP') THEN ifnull(`p_ref`.`nom_usage`, '')
WHEN (`i`.`type_referent` = 'REF'
AND `i`.`referent_valide` <> 0) THEN ifnull(`p_ref`.`nom_usage`, '')
ELSE ''
END AS `nom_referent`,
CASE
WHEN `i`.`type_referent` LIKE 'REF' THEN `i`.`referent_valide`
ELSE NULL
END AS `referent_valide`,
IF(`i`.`confirm_reception_autorisation_parentale` = 0, 0, 1) AS `confirm_reception_autorisation_parentale`,
IF(YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY) < 18
OR `i`.`personne_malade` = 1
OR `i`.`personne_handicapee` = 1, IF(`p`.`photo_filename` IS NOT NULL, 1, 0), NULL) AS `photo`,
`comite_dossier`.`libelle_public` AS `comite_di`,
IF(ifnull(`vit`.`id_inscription`, 0) <> 0, 'OUI', 'NON') AS `transport`,
ifnull(`vit`.`libelle_aller`, '') AS `transport_aller`,
ifnull(`vit`.`libelle_retour`, '') AS `transport_retour`,
ifnull(`vit`.`id_groupe_aller`, 0) = ifnull(`vit`.`id_groupe_ref_retour`, -1) AS `aller_retour`,
`i`.`date_arrivee` AS `date_arrivee_i`,
`i`.`date_depart` AS `date_depart_i`,
IF(`i`.`has_hebergement` = 1, 1, 0) AS `hebergement`,
ifnull(`th`.`libelle_public`, '') AS `nom_hebergement`,
ifnull(`bv_nds`.`valeur`, '') AS `nds`,
IF(`i`.`id_g_service_participation_service` IS NOT NULL, 1, 0) AS `souhaite_servir`,
IF(`i`.`id_g_service_participation_activite` IS NOT NULL, 1, 0) AS `souhaite_participer`,
IF(`i`.`id_g_service_participation_service` IS NOT NULL, 'SERVICE', IF(`i`.`id_g_service_participation_activite` IS NOT NULL, 'ACTIVITE', 'AUCUN')) AS `engagement`,
group_concat(DISTINCT ifnull(`activite_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `activite_souhait`,
group_concat(DISTINCT ifnull(`activite_valide`.`libelle_public`, '') SEPARATOR '\n') AS `activite_validee`,
group_concat(DISTINCT ifnull(`pole_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `pole_souhait`,
group_concat(DISTINCT ifnull(`pole_valide`.`libelle_public`, '') SEPARATOR '\n') AS `pole_valide`,
group_concat(DISTINCT ifnull(`service_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `service_souhait`,
group_concat(DISTINCT ifnull(`service_valide`.`libelle_public`, '') SEPARATOR '\n') AS `service_valide`,
group_concat(DISTINCT ifnull(`equipe_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `equipe_souhait`,
ifnull(`equipeval`.`libelle_public`, '') AS `equipe_validee`,
group_concat(DISTINCT ifnull(IF(`f`.`personne` IS NOT NULL, IF(`f`.`label_fonction` = 3, `labelf`.`nom_masculin`, IF(`p`.`sexe` = 'masculin', `labelf`.`nom_masculin`, `labelf`.`nom_feminin`)), ''), '') SEPARATOR '\n') AS `fonction`,
`i`.`affectation_commentaire` AS `affectation_commentaire`,
`i`.`mineur_has_premiere_communion` AS `mineur_has_premiere_communion`,
`i`.`mineur_autoriser_piscine` AS `mineur_autoriser_piscine`,
`i`.`mineur_autoriser_quitter_seul_activite` AS `mineur_autoriser_quitter_seul_activite`,
`di`.`id_dossier_inscription` AS `id_dossier_inscription`,
`di`.`reference` AS `reference_di`,
`di`.`libelle` AS `nom_di`,
IF(`di`.`paiement_differe` = 1, 'OUI', 'NON') AS `paiement_differe`,
`vue`.`montant_total` AS `montant_total_di`,
`vue`.`paiements` AS `paiements_di`,
`vue`.`solde` AS `solde_di`,
IF(`di`.`createur_comite` = 1, 'OUI', 'NON') AS `createur_comite`,
IF(`di`.`createur_central` = 1, 'OUI', 'NON') AS `createur_central`,
date_format(`di`.`date_creation`, '%d/%m/%Y') AS `date_creation_di`,
IF(`p`.`date_deces` IS NOT NULL, 'OUI', 'NON') AS `Personne Décédée`
FROM (((((((((((((((((((((((((((((((`inscription` `i`
JOIN `dossier_inscription` `di` ON(`di`.`id_dossier_inscription` = `i`.`id_dossier_inscription`))
JOIN `evenement` `evt` ON(`evt`.`id_evenement` = `di`.`id_evenement`))
JOIN `groupe` `grpEvt` ON(`grpEvt`.`id_evenement` = `evt`.`id_evenement`))
JOIN `personne` `p` ON(`p`.`id_personne` = `i`.`id_personne`))
JOIN `civilite` `civ` ON(`civ`.`id_civilite` = `p`.`civilite`))
LEFT JOIN `coordonnee` `c` ON(`c`.`personne` = `p`.`id_personne`
AND `c`.`defaut` = 1))
LEFT JOIN `groupe` `comite_dossier` ON(`comite_dossier`.`id_groupe` = `di`.`id_g_comite`))
LEFT JOIN `bonus_value` `bv_nds` ON(`bv_nds`.`id_bonus_setting` = 76
AND `bv_nds`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_volontid` ON(`bv_volontid`.`id_bonus_setting` = 92
AND `bv_volontid`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_branche` ON(`bv_p_branche`.`id_bonus_setting` = 99
AND `bv_p_branche`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_metier` ON(`bv_p_metier`.`id_bonus_setting` = 98
AND `bv_p_metier`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_specialite` ON(`bv_p_specialite`.`id_bonus_setting` = 97
AND `bv_p_specialite`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `service` `s` ON(`s`.`id_service` = `comite_dossier`.`service`))
LEFT JOIN `vue_ands_inscription_transport` `vit` ON(`vit`.`id_inscription` = `i`.`id_inscription`))
LEFT JOIN `hebergement_chambre` `hc` ON(`hc`.`id_hebergement_chambre` = `i`.`id_hebergement_chambre`))
LEFT JOIN `hebergement` `h` ON(`hc`.`id_hebergement` = `h`.`id_hebergement`))
LEFT JOIN `groupe` `th` ON(`th`.`id_hebergement` = `h`.`id_hebergement`))
LEFT JOIN `inscription_participation` `ip` ON(`ip`.`id_inscription` = `i`.`id_inscription`))
LEFT JOIN `groupe` `activite_souhait` ON(`activite_souhait`.`id_groupe` = `ip`.`id_g_activite`))
LEFT JOIN `groupe` `activite_valide` ON(`activite_valide`.`id_groupe` = `ip`.`id_g_activite`
AND `ip`.`id_fonction` IS NOT NULL))
LEFT JOIN `groupe` `pole_souhait` ON(`pole_souhait`.`id_groupe` = `ip`.`id_g_pole_souhait`))
LEFT JOIN `groupe` `service_souhait` ON(`service_souhait`.`id_groupe` = `ip`.`id_g_service_souhait`))
LEFT JOIN `groupe` `pole_valide` ON(`pole_valide`.`id_groupe` = `ip`.`id_g_pole`))
LEFT JOIN `groupe` `service_valide` ON(`service_valide`.`id_groupe` = `ip`.`id_g_service`))
LEFT JOIN `groupe` `equipe_souhait` ON(`equipe_souhait`.`id_groupe` = `ip`.`id_g_equipe_souhait`))
LEFT JOIN `groupe` `equipeval` ON(`equipeval`.`id_groupe` = `ip`.`id_g_equipe`))
LEFT JOIN `zone_geographique` `sousserv_geo` ON(`sousserv_geo`.`id_zone_geographique` = `service_souhait`.`zone_geographique`))
LEFT JOIN `fonction` `f` ON(`f`.`id_fonction` = `ip`.`id_fonction`))
LEFT JOIN `label_fonction` `labelf` ON(`f`.`label_fonction` = `labelf`.`id_label_fonction`))
LEFT JOIN `personne` `p_ref` ON(`p_ref`.`id_personne` = `i`.`id_personne_referente_calc`))
LEFT JOIN `vue_dossier_inscription_paiements` `vue` ON(`vue`.`id_dossier_inscription` = `di`.`id_dossier_inscription`))
WHERE (`sousserv_geo`.`type_zone` NOT IN (1,
2)
OR `sousserv_geo`.`type_zone` IS NULL)
AND `service_souhait`.`id_evenement` IS NULL
GROUP BY `i`.`id_inscription`
ORDER BY `p`.`nom`,
`p`.`prenom`
But when i ran this (just a join on table inscription) , the server CRASH :
SELECT ii.id_inscription FROM (SELECT `evt`.`id_evenement` AS `id_evenement`,
`grpEvt`.`libelle_public` AS `nom_evenement`,
`p`.`id_personne` AS `id_personne`,
`bv_volontid`.`valeur` AS `volont_id`,
`i`.`id_inscription` AS `id_inscription`,
`i`.`reference` AS `reference_i`,
IF(`i`.`desiste` = 1, 1, 0) AS `desiste`,
concat(ifnull(`civ`.`nom_abrege`, ''), ifnull(`civ`.`exposant`, '')) AS `civilite`,
concat(ifnull(ucase(`p`.`nom`), ''), IF(octet_length(`p`.`particule`) > 0, concat(' (', `p`.`particule`, ')'), '')) AS `nom`,
ifnull(`p`.`particule`, '') AS `particule`,
`p`.`prenom` AS `prenom`,
date_format(`p`.`date_naissance`, '%d/%m/%Y') AS `date_naissance`,
YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY) AS `age`,
ifnull(`bv_p_branche`.`valeur`, '') AS `profession_branche`,
ifnull(`bv_p_metier`.`valeur`, '') AS `profession_metier`,
ifnull(`bv_p_specialite`.`valeur`, '') AS `profession_specialite`,
ucase(`c`.`adresse1`) AS `adresse1`,
ucase(`c`.`adresse2`) AS `adresse2`,
ucase(`c`.`adresse3`) AS `adresse3`,
`c`.`code_postal` AS `code_postal`,
ucase(`c`.`ville_cedex`) AS `ville`,
ucase(`c`.`pays_nom`) AS `pays`,
`c`.`telephone` AS `telephone`,
`c`.`mobile` AS `mobile`,
`c`.`email` AS `email`,
IF(
(YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY)) < 18, 1, 0) AS `mineur`,
IF(`i`.`personne_malade` = 1
OR `i`.`personne_handicapee` = 1, 1, 0) AS `malade`,
`i`.`type_referent` AS `type_referent`,
CASE
WHEN (`i`.`type_referent` = 'P'
OR `i`.`type_referent` = 'GP') THEN ifnull(`p_ref`.`nom_usage`, '')
WHEN (`i`.`type_referent` = 'REF'
AND `i`.`referent_valide` <> 0) THEN ifnull(`p_ref`.`nom_usage`, '')
ELSE ''
END AS `nom_referent`,
CASE
WHEN `i`.`type_referent` LIKE 'REF' THEN `i`.`referent_valide`
ELSE NULL
END AS `referent_valide`,
IF(`i`.`confirm_reception_autorisation_parentale` = 0, 0, 1) AS `confirm_reception_autorisation_parentale`,
IF(YEAR(`evt`.`date_debut` - INTERVAL to_days(`p`.`date_naissance`) DAY) < 18
OR `i`.`personne_malade` = 1
OR `i`.`personne_handicapee` = 1, IF(`p`.`photo_filename` IS NOT NULL, 1, 0), NULL) AS `photo`,
`comite_dossier`.`libelle_public` AS `comite_di`,
IF(ifnull(`vit`.`id_inscription`, 0) <> 0, 'OUI', 'NON') AS `transport`,
ifnull(`vit`.`libelle_aller`, '') AS `transport_aller`,
ifnull(`vit`.`libelle_retour`, '') AS `transport_retour`,
ifnull(`vit`.`id_groupe_aller`, 0) = ifnull(`vit`.`id_groupe_ref_retour`, -1) AS `aller_retour`,
`i`.`date_arrivee` AS `date_arrivee_i`,
`i`.`date_depart` AS `date_depart_i`,
IF(`i`.`has_hebergement` = 1, 1, 0) AS `hebergement`,
ifnull(`th`.`libelle_public`, '') AS `nom_hebergement`,
ifnull(`bv_nds`.`valeur`, '') AS `nds`,
IF(`i`.`id_g_service_participation_service` IS NOT NULL, 1, 0) AS `souhaite_servir`,
IF(`i`.`id_g_service_participation_activite` IS NOT NULL, 1, 0) AS `souhaite_participer`,
IF(`i`.`id_g_service_participation_service` IS NOT NULL, 'SERVICE', IF(`i`.`id_g_service_participation_activite` IS NOT NULL, 'ACTIVITE', 'AUCUN')) AS `engagement`,
group_concat(DISTINCT ifnull(`activite_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `activite_souhait`,
group_concat(DISTINCT ifnull(`activite_valide`.`libelle_public`, '') SEPARATOR '\n') AS `activite_validee`,
group_concat(DISTINCT ifnull(`pole_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `pole_souhait`,
group_concat(DISTINCT ifnull(`pole_valide`.`libelle_public`, '') SEPARATOR '\n') AS `pole_valide`,
group_concat(DISTINCT ifnull(`service_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `service_souhait`,
group_concat(DISTINCT ifnull(`service_valide`.`libelle_public`, '') SEPARATOR '\n') AS `service_valide`,
group_concat(DISTINCT ifnull(`equipe_souhait`.`libelle_public`, '') SEPARATOR '\n') AS `equipe_souhait`,
ifnull(`equipeval`.`libelle_public`, '') AS `equipe_validee`,
group_concat(DISTINCT ifnull(IF(`f`.`personne` IS NOT NULL, IF(`f`.`label_fonction` = 3, `labelf`.`nom_masculin`, IF(`p`.`sexe` = 'masculin', `labelf`.`nom_masculin`, `labelf`.`nom_feminin`)), ''), '') SEPARATOR '\n') AS `fonction`,
`i`.`affectation_commentaire` AS `affectation_commentaire`,
`i`.`mineur_has_premiere_communion` AS `mineur_has_premiere_communion`,
`i`.`mineur_autoriser_piscine` AS `mineur_autoriser_piscine`,
`i`.`mineur_autoriser_quitter_seul_activite` AS `mineur_autoriser_quitter_seul_activite`,
`di`.`id_dossier_inscription` AS `id_dossier_inscription`,
`di`.`reference` AS `reference_di`,
`di`.`libelle` AS `nom_di`,
IF(`di`.`paiement_differe` = 1, 'OUI', 'NON') AS `paiement_differe`,
`vue`.`montant_total` AS `montant_total_di`,
`vue`.`paiements` AS `paiements_di`,
`vue`.`solde` AS `solde_di`,
IF(`di`.`createur_comite` = 1, 'OUI', 'NON') AS `createur_comite`,
IF(`di`.`createur_central` = 1, 'OUI', 'NON') AS `createur_central`,
date_format(`di`.`date_creation`, '%d/%m/%Y') AS `date_creation_di`,
IF(`p`.`date_deces` IS NOT NULL, 'OUI', 'NON') AS `Personne Décédée`
FROM (((((((((((((((((((((((((((((((`inscription` `i`
JOIN `dossier_inscription` `di` ON(`di`.`id_dossier_inscription` = `i`.`id_dossier_inscription`))
JOIN `evenement` `evt` ON(`evt`.`id_evenement` = `di`.`id_evenement`))
JOIN `groupe` `grpEvt` ON(`grpEvt`.`id_evenement` = `evt`.`id_evenement`))
JOIN `personne` `p` ON(`p`.`id_personne` = `i`.`id_personne`))
JOIN `civilite` `civ` ON(`civ`.`id_civilite` = `p`.`civilite`))
LEFT JOIN `coordonnee` `c` ON(`c`.`personne` = `p`.`id_personne`
AND `c`.`defaut` = 1))
LEFT JOIN `groupe` `comite_dossier` ON(`comite_dossier`.`id_groupe` = `di`.`id_g_comite`))
LEFT JOIN `bonus_value` `bv_nds` ON(`bv_nds`.`id_bonus_setting` = 76
AND `bv_nds`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_volontid` ON(`bv_volontid`.`id_bonus_setting` = 92
AND `bv_volontid`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_branche` ON(`bv_p_branche`.`id_bonus_setting` = 99
AND `bv_p_branche`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_metier` ON(`bv_p_metier`.`id_bonus_setting` = 98
AND `bv_p_metier`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `bonus_value` `bv_p_specialite` ON(`bv_p_specialite`.`id_bonus_setting` = 97
AND `bv_p_specialite`.`id_personne` = `p`.`id_personne`))
LEFT JOIN `service` `s` ON(`s`.`id_service` = `comite_dossier`.`service`))
LEFT JOIN `vue_ands_inscription_transport` `vit` ON(`vit`.`id_inscription` = `i`.`id_inscription`))
LEFT JOIN `hebergement_chambre` `hc` ON(`hc`.`id_hebergement_chambre` = `i`.`id_hebergement_chambre`))
LEFT JOIN `hebergement` `h` ON(`hc`.`id_hebergement` = `h`.`id_hebergement`))
LEFT JOIN `groupe` `th` ON(`th`.`id_hebergement` = `h`.`id_hebergement`))
LEFT JOIN `inscription_participation` `ip` ON(`ip`.`id_inscription` = `i`.`id_inscription`))
LEFT JOIN `groupe` `activite_souhait` ON(`activite_souhait`.`id_groupe` = `ip`.`id_g_activite`))
LEFT JOIN `groupe` `activite_valide` ON(`activite_valide`.`id_groupe` = `ip`.`id_g_activite`
AND `ip`.`id_fonction` IS NOT NULL))
LEFT JOIN `groupe` `pole_souhait` ON(`pole_souhait`.`id_groupe` = `ip`.`id_g_pole_souhait`))
LEFT JOIN `groupe` `service_souhait` ON(`service_souhait`.`id_groupe` = `ip`.`id_g_service_souhait`))
LEFT JOIN `groupe` `pole_valide` ON(`pole_valide`.`id_groupe` = `ip`.`id_g_pole`))
LEFT JOIN `groupe` `service_valide` ON(`service_valide`.`id_groupe` = `ip`.`id_g_service`))
LEFT JOIN `groupe` `equipe_souhait` ON(`equipe_souhait`.`id_groupe` = `ip`.`id_g_equipe_souhait`))
LEFT JOIN `groupe` `equipeval` ON(`equipeval`.`id_groupe` = `ip`.`id_g_equipe`))
LEFT JOIN `zone_geographique` `sousserv_geo` ON(`sousserv_geo`.`id_zone_geographique` = `service_souhait`.`zone_geographique`))
LEFT JOIN `fonction` `f` ON(`f`.`id_fonction` = `ip`.`id_fonction`))
LEFT JOIN `label_fonction` `labelf` ON(`f`.`label_fonction` = `labelf`.`id_label_fonction`))
LEFT JOIN `personne` `p_ref` ON(`p_ref`.`id_personne` = `i`.`id_personne_referente_calc`))
LEFT JOIN `vue_dossier_inscription_paiements` `vue` ON(`vue`.`id_dossier_inscription` = `di`.`id_dossier_inscription`))
WHERE (`sousserv_geo`.`type_zone` NOT IN (1,
2)
OR `sousserv_geo`.`type_zone` IS NULL)
AND `service_souhait`.`id_evenement` IS NULL
GROUP BY `i`.`id_inscription`
ORDER BY `p`.`nom`,
`p`.`prenom`) AS aa, inscription AS ii WHERE ii.id_inscription = aa.id_inscription
Hope that's help ....
erbru, it seems to be the same bug as MDEV-13607/MDEV-18479, the fix should be in the next release.
I am closing this bug for now, but please comment here in case it still will be reproducible, then the bug will be reopened for further investigation.
Have others message :
mysqld[30924]: segfault at 0 ip 000055a33d6137e2 sp 00007f8cdc6330e0 error 4 in mysqld[55a33cf91000+1263000]
May 29 17:24:30 pin3 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
May 29 17:24:30 pin3 systemd[1]: mariadb.service: Unit entered failed state.
May 29 17:24:30 pin3 systemd[1]: mariadb.service: Failed with result 'signal'.
May 29 17:24:30 pin3 systemd[1]: Started Session 6450 of user root.
May 29 17:24:35 pin3 systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
May 29 17:24:35 pin3 systemd[1]: Stopped MariaDB 10.3.15 database server.
May 29 17:24:35 pin3 systemd[1]: Starting MariaDB 10.3.15 database server...
May 29 17:24:37 pin3 mysqld[30955]: WSREP: Recovered position f2d1a92e-3042-11e9-abab-82e19689b104:13879
May 29 17:24:38 pin3 mysqld[31114]: 2019-05-29 17:24:38 0 [Note] /usr/sbin/mysqld (mysqld 10.3.15-MariaDB-1:10.3.15+maria~stretch-log) starting as process 31114 ...
May 29 17:24:39 pin3 systemd[1]: Started MariaDB 10.3.15 database server.
^@May 29 17:27:16 pin3 systemd[1]: Started Session 6451 of user root.