[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1467,"tournoi_id":1,"e1":9,"e2":10,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1040","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"9","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1041","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"10","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1467,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1467 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1467,"sent_to":[10,11],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1467 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1468,"tournoi_id":1,"e1":5,"e2":1,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1036","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"5","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1032","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"1","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1468,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1468 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1468,"sent_to":[2,3,1],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1468 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1469,"tournoi_id":1,"e1":12,"e2":6,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1043","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"12","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1037","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"6","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1469,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1469 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1469,"sent_to":[13,7],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1469 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1470,"tournoi_id":1,"e1":11,"e2":2,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1042","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"11","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1033","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"2","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1470,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1470 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1470,"sent_to":[12,16],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1470 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1471,"tournoi_id":1,"e1":4,"e2":8,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1035","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"4","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1039","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"8","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1471,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1471 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1471,"sent_to":[17,9],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1471 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1472,"tournoi_id":1,"e1":3,"e2":7,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:31:02 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 16:31:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1034","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"3","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1038","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"7","emarge":"1","j":"2","points":"2","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1472,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1472 LIMIT 1"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1472,"sent_to":[18,8],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:31:02 Europe/Paris] Étape 4 OK match 1472 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":1}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Qualification computed | ctx={"tournoi_id":1,"N":12,"Q":8,"p":8,"num_prelim_matches":0,"stage_label":"Quarts de finale"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Qualified_ids | ctx={"qualified_ids":[1,2,3,4,5,6,7,8]}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Elim_pairs | ctx={"pairs":[[1,8],[2,7],[3,6],[4,5]]}
[19-Feb-2026 16:31:02 Europe/Paris] ========== TRIGGER STEP 5 : Transition Qualifications -> Éliminatoire ==========
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] TRIGGER_CTX step=5 | ctx={"tournoi_id":1,"stage_label":"Quarts de finale","pairs_count":4}
[19-Feb-2026 16:31:02 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,3,4,5,6,7,8) \n\t                AND elimine = 0"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Match éliminatoire créé | ctx={"tournoi_id":1,"a":1,"b":8,"table":1,"date":"2026-02-19 16:31:00","phase":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Match éliminatoire créé | ctx={"tournoi_id":1,"a":2,"b":7,"table":2,"date":"2026-02-19 16:31:00","phase":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Match éliminatoire créé | ctx={"tournoi_id":1,"a":3,"b":6,"table":3,"date":"2026-02-19 16:31:00","phase":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Match éliminatoire créé | ctx={"tournoi_id":1,"a":4,"b":5,"table":4,"date":"2026-02-19 16:31:00","phase":"Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:31:02 Europe/Paris] [DBG] Phase tournoi mise à jour | ctx={"tournoi_id":1,"sql":"UPDATE Tournoi \n\t            SET texte_phase_en_cours = 'Éliminatoire : Quarts de finale' \n\t            WHERE id = 1 LIMIT 1"}
[19-Feb-2026 16:31:03 Europe/Paris] [DBG] Notif globale éliminatoire envoyée | ctx={"tournoi_id":1,"players_count":13,"message":"Lancement de la phase Éliminatoire : Quarts de finale"}
[19-Feb-2026 16:31:03 Europe/Paris] Tournoi 1 : transition Qualifications -> Éliminatoires effectuée, matches créés = 4, qualifiés = 8 (total équipes = 12)
[19-Feb-2026 16:31:03 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":3}
[2026-02-19 16:31:03] 

É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 16:31:03 ===