[19-Feb-2026 15:56:03 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1452,"tournoi_id":1,"e1":2,"e2":3,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":1,"points_e2":1,"vainqueur_id":null,"elim_loser_id":null,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1029","date":"2026-02-19 15:51:24","tournoi":"1","equipe":"2","emarge":"1","j":"0","points":"0","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1030","date":"2026-02-19 15:51:24","tournoi":"1","equipe":"3","emarge":"1","j":"0","points":"0","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":1,"new_points_e1":1,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":1,"new_points_e2":1,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 15:56:03 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1452,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1452 LIMIT 1"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1452,"sent_to":[16,18],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 15:56:04 Europe/Paris] Étape 4 OK match 1452 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 15:56:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1453,"tournoi_id":1,"e1":4,"e2":1,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":1,"points_e2":1,"vainqueur_id":null,"elim_loser_id":null,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1031","date":"2026-02-19 15:51:24","tournoi":"1","equipe":"4","emarge":"1","j":"0","points":"0","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1028","date":"2026-02-19 15:51:24","tournoi":"1","equipe":"1","emarge":"1","j":"0","points":"0","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":1,"new_points_e1":1,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":1,"new_points_e2":1,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1453,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1453 LIMIT 1"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1453,"sent_to":[17,1],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 15:56:04 Europe/Paris] Étape 4 OK match 1453 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":1}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Qualification computed | ctx={"tournoi_id":1,"N":4,"Q":2,"p":2,"num_prelim_matches":0,"stage_label":"Finale"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Qualified_ids | ctx={"qualified_ids":[1,2]}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Elim_pairs | ctx={"pairs":[[1,2]]}
[19-Feb-2026 15:56:04 Europe/Paris] ========== TRIGGER STEP 5 : Transition Qualifications -> Éliminatoire ==========
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] TRIGGER_CTX step=5 | ctx={"tournoi_id":1,"stage_label":"Finale","pairs_count":1}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Non qualifiés éliminés | ctx={"tournoi_id":1,"sql":"UPDATE Tournoi_Equipe SET elimine = 1, elimine_date = NOW() \n\t                WHERE tournoi = 1 \n\t                AND emarge = 1 \n\t                AND equipe NOT IN (1,2) \n\t                AND elimine = 0"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Match éliminatoire créé | ctx={"tournoi_id":1,"a":1,"b":2,"table":1,"date":"2026-02-19 15:56:00","phase":"Éliminatoire : Finale"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Phase tournoi mise à jour | ctx={"tournoi_id":1,"sql":"UPDATE Tournoi \n\t            SET texte_phase_en_cours = 'Éliminatoire : Finale' \n\t            WHERE id = 1 LIMIT 1"}
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Notif globale éliminatoire envoyée | ctx={"tournoi_id":1,"players_count":4,"message":"Lancement de la phase Éliminatoire : Finale"}
[19-Feb-2026 15:56:04 Europe/Paris] Tournoi 1 : transition Qualifications -> Éliminatoires effectuée, matches créés = 1, qualifiés = 2 (total équipes = 4)
[19-Feb-2026 15:56:04 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":3}
[2026-02-19 15:56:04] 

ÉTAPE 1

ÉTAPE 2

ÉTAPE 3
ÉTAPE 4
ÉTAPE 5

ÉTAPE 6/7 (Passage tours & Fin tournoi)


--- FIN DU SCRIPT
=== END LOG 2026-02-19 15:56:04 ===