[19-Feb-2026 23:35:05 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1668,"tournoi_id":7,"e1":50,"e2":66,"s1_raw":"3","s2_raw":"0","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":3,"s2":0,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":50,"points_e1":0,"points_e2":0,"vainqueur_id":50,"elim_loser_id":66,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1014","date":"2026-02-17 12:29:27","tournoi":"7","equipe":"50","emarge":"1","j":"8","points":"16","ratio":"24","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"},"te2":{"id":"1050","date":"2026-02-19 20:03:00","tournoi":"7","equipe":"66","emarge":"1","j":"8","points":"4","ratio":"-11","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":16,"new_ratio_e1":24,"new_elim_e1":1,"new_j_e2":8,"new_points_e2":4,"new_ratio_e2":-11,"new_elim_e2":1}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1668,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=50 WHERE id=1668 LIMIT 1"}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1668,"sent_to":[49,99],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":50,"elim_loser_id":66}
[19-Feb-2026 23:35:05 Europe/Paris] Étape 4 OK match 1668 — phaseElim=1, s1=3, s2=0, gagnant=50, elim=66
[19-Feb-2026 23:35:05 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1669,"tournoi_id":7,"e1":61,"e2":65,"s1_raw":"3","s2_raw":"0","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":3,"s2":0,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":61,"points_e1":0,"points_e2":0,"vainqueur_id":61,"elim_loser_id":65,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1045","date":"2026-02-19 17:51:22","tournoi":"7","equipe":"61","emarge":"1","j":"8","points":"16","ratio":"19","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1049","date":"2026-02-19 19:53:23","tournoi":"7","equipe":"65","emarge":"1","j":"8","points":"7","ratio":"-4","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":16,"new_ratio_e1":19,"new_elim_e1":0,"new_j_e2":8,"new_points_e2":7,"new_ratio_e2":-4,"new_elim_e2":1}
[19-Feb-2026 23:35:05 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1669,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=61 WHERE id=1669 LIMIT 1"}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1669,"sent_to":[45,98],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":61,"elim_loser_id":65}
[19-Feb-2026 23:35:06 Europe/Paris] Étape 4 OK match 1669 — phaseElim=1, s1=3, s2=0, gagnant=61, elim=65
[19-Feb-2026 23:35:06 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1670,"tournoi_id":7,"e1":47,"e2":49,"s1_raw":"3","s2_raw":"1","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":3,"s2":1,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":47,"points_e1":0,"points_e2":0,"vainqueur_id":47,"elim_loser_id":49,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"999","date":"2026-02-06 12:07:35","tournoi":"7","equipe":"47","emarge":"1","j":"8","points":"13","ratio":"13","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"},"te2":{"id":"1013","date":"2026-02-17 08:58:27","tournoi":"7","equipe":"49","emarge":"1","j":"8","points":"7","ratio":"-2","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":13,"new_ratio_e1":13,"new_elim_e1":1,"new_j_e2":8,"new_points_e2":7,"new_ratio_e2":-2,"new_elim_e2":1}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1670,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=47 WHERE id=1670 LIMIT 1"}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1670,"sent_to":[16,48],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":47,"elim_loser_id":49}
[19-Feb-2026 23:35:06 Europe/Paris] Étape 4 OK match 1670 — phaseElim=1, s1=3, s2=1, gagnant=47, elim=49
[19-Feb-2026 23:35:06 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1671,"tournoi_id":7,"e1":52,"e2":56,"s1_raw":"0","s2_raw":"3","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":3,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":56,"points_e1":0,"points_e2":0,"vainqueur_id":56,"elim_loser_id":52,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1016","date":"2026-02-17 14:45:37","tournoi":"7","equipe":"52","emarge":"1","j":"8","points":"13","ratio":"11","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1020","date":"2026-02-17 19:02:20","tournoi":"7","equipe":"56","emarge":"1","j":"8","points":"7","ratio":"1","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":13,"new_ratio_e1":11,"new_elim_e1":1,"new_j_e2":8,"new_points_e2":7,"new_ratio_e2":1,"new_elim_e2":0}
[19-Feb-2026 23:35:06 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1671,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=56 WHERE id=1671 LIMIT 1"}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1671,"sent_to":[55,53],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":56,"elim_loser_id":52}
[19-Feb-2026 23:35:07 Europe/Paris] Étape 4 OK match 1671 — phaseElim=1, s1=0, s2=3, gagnant=56, elim=52
[19-Feb-2026 23:35:07 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1672,"tournoi_id":7,"e1":63,"e2":51,"s1_raw":"0","s2_raw":"3","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":3,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":51,"points_e1":0,"points_e2":0,"vainqueur_id":51,"elim_loser_id":63,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1047","date":"2026-02-19 19:16:27","tournoi":"7","equipe":"63","emarge":"1","j":"8","points":"12","ratio":"5","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1015","date":"2026-02-17 12:56:51","tournoi":"7","equipe":"51","emarge":"1","j":"8","points":"8","ratio":"-4","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":12,"new_ratio_e1":5,"new_elim_e1":1,"new_j_e2":8,"new_points_e2":8,"new_ratio_e2":-4,"new_elim_e2":1}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1672,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=51 WHERE id=1672 LIMIT 1"}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1672,"sent_to":[96,18],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":51,"elim_loser_id":63}
[19-Feb-2026 23:35:07 Europe/Paris] Étape 4 OK match 1672 — phaseElim=1, s1=0, s2=3, gagnant=51, elim=63
[19-Feb-2026 23:35:07 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1673,"tournoi_id":7,"e1":46,"e2":60,"s1_raw":"0","s2_raw":"3","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":3,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":60,"points_e1":0,"points_e2":0,"vainqueur_id":60,"elim_loser_id":46,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"998","date":"2026-02-05 14:32:56","tournoi":"7","equipe":"46","emarge":"1","j":"8","points":"11","ratio":"9","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"},"te2":{"id":"1044","date":"2026-02-19 17:07:00","tournoi":"7","equipe":"60","emarge":"1","j":"8","points":"8","ratio":"1","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":11,"new_ratio_e1":9,"new_elim_e1":1,"new_j_e2":8,"new_points_e2":8,"new_ratio_e2":1,"new_elim_e2":0}
[19-Feb-2026 23:35:07 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1673,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=60 WHERE id=1673 LIMIT 1"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1673,"sent_to":[28,82,94],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":60,"elim_loser_id":46}
[19-Feb-2026 23:35:08 Europe/Paris] Étape 4 OK match 1673 — phaseElim=1, s1=0, s2=3, gagnant=60, elim=46
[19-Feb-2026 23:35:08 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1674,"tournoi_id":7,"e1":64,"e2":48,"s1_raw":"3","s2_raw":"0","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":3,"s2":0,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":64,"points_e1":0,"points_e2":0,"vainqueur_id":64,"elim_loser_id":48,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1048","date":"2026-02-19 19:30:21","tournoi":"7","equipe":"64","emarge":"1","j":"8","points":"11","ratio":"6","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1004","date":"2026-02-11 21:11:35","tournoi":"7","equipe":"48","emarge":"1","j":"8","points":"10","ratio":"3","elimine":"1","elimine_date":"2026-02-19 20:20:09","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":11,"new_ratio_e1":6,"new_elim_e1":0,"new_j_e2":8,"new_points_e2":10,"new_ratio_e2":3,"new_elim_e2":1}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1674,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=64 WHERE id=1674 LIMIT 1"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1674,"sent_to":[60,44],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":64,"elim_loser_id":48}
[19-Feb-2026 23:35:08 Europe/Paris] Étape 4 OK match 1674 — phaseElim=1, s1=3, s2=0, gagnant=64, elim=48
[19-Feb-2026 23:35:08 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1675,"tournoi_id":7,"e1":54,"e2":45,"s1_raw":"3","s2_raw":"2","phase_text":"Éliminatoire : Huitièmes de finale"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":3,"s2":2,"isElim":true,"conteste":false,"egalite":false}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":54,"points_e1":0,"points_e2":0,"vainqueur_id":54,"elim_loser_id":45,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1018","date":"2026-02-17 18:06:39","tournoi":"7","equipe":"54","emarge":"1","j":"8","points":"11","ratio":"3","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"997","date":"2026-02-05 13:58:04","tournoi":"7","equipe":"45","emarge":"1","j":"8","points":"10","ratio":"8","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":8,"new_points_e1":11,"new_ratio_e1":3,"new_elim_e1":0,"new_j_e2":8,"new_points_e2":10,"new_ratio_e2":8,"new_elim_e2":1}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1675,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=54 WHERE id=1675 LIMIT 1"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1675,"sent_to":[63,27],"isElim":true,"conteste":false,"egalite":false,"vainqueur_id":54,"elim_loser_id":45}
[19-Feb-2026 23:35:08 Europe/Paris] Étape 4 OK match 1675 — phaseElim=1, s1=3, s2=2, gagnant=54, elim=45
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Aucun match elim en attente -> création next step possible | ctx={"tournoi_id":7}
[19-Feb-2026 23:35:08 Europe/Paris] Tournoi 7 : équipes restantes BEFORE next round => 61(pts:16,ratio:19,j:8), 64(pts:11,ratio:6,j:8), 54(pts:11,ratio:3,j:8), 60(pts:8,ratio:1,j:8), 56(pts:7,ratio:1,j:8)
[19-Feb-2026 23:35:08 Europe/Paris] Tournoi 7 : N impaire (5) -> bye appliqué à equipe 61 (meilleur)
[19-Feb-2026 23:35:08 Europe/Paris] Tournoi 7 : PAIRS best-vs-worst => 64vs56, 54vs60
[19-Feb-2026 23:35:08 Europe/Paris] ========== TRIGGER STEP 6 : Création tour suivant éliminatoire ==========
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] TRIGGER_CTX step=6 | ctx={"tournoi_id":7,"N":5,"pairs":[[64,56],[54,60]],"byes":[61],"round_label":"2 matchs (Tour suivant)"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Match tour suivant créé | ctx={"tournoi_id":7,"a":64,"b":56,"table":1,"date":"2026-02-19 23:35:00","phase":"Éliminatoire : 2 matchs (Tour suivant)"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Match tour suivant créé | ctx={"tournoi_id":7,"a":54,"b":60,"table":2,"date":"2026-02-19 23:35:00","phase":"Éliminatoire : 2 matchs (Tour suivant)"}
[19-Feb-2026 23:35:08 Europe/Paris] [DBG] Transaction création tour suivant OK | ctx={"tournoi_id":7,"created":2,"phase":"Éliminatoire : 2 matchs (Tour suivant)"}
[19-Feb-2026 23:35:12 Europe/Paris] [DBG] Notif globale tour suivant | ctx={"tournoi_id":7,"round_label":"2 matchs (Tour suivant)","players_count":23}
[19-Feb-2026 23:35:12 Europe/Paris] [DBG] Notif bye | ctx={"tournoi_id":7,"byeEquipeId":61,"nom":"Monk"}
[19-Feb-2026 23:35:12 Europe/Paris] Tournoi 7 : création tour suivant (2 matchs (Tour suivant)), matches créés = 2, byes = 1
[2026-02-19 23:35:12] 

É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 23:35:12 ===