[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1467,"tournoi_id":1,"e1":9,"e2":10,"table":"1"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"9":{"nom":"Équipe 9","createur":"10","membre":"0"},"10":{"nom":"Équipe 10","createur":"11","membre":"0"}},"msg_e1":"Tu joues contre l'équipe Équipe 10 sur la table 1 !","msg_e2":"Tu joues contre l'équipe Équipe 9 sur la table 1 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1467,"sent_to":[10,11]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1468,"tournoi_id":1,"e1":5,"e2":1,"table":"2"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"1":{"nom":"Les Niçois #1","createur":"1","membre":"0"},"5":{"nom":"Les Marseillais #5","createur":"2","membre":"3"}},"msg_e1":"Tu joues contre l'équipe Les Niçois #1 sur la table 2 !","msg_e2":"Tu joues contre l'équipe Les Marseillais #5 sur la table 2 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1468,"sent_to":[2,3,1]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1469,"tournoi_id":1,"e1":12,"e2":6,"table":"3"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"6":{"nom":"Équipe de testeurs #6","createur":"7","membre":"0"},"12":{"nom":"Équipe 12","createur":"13","membre":"0"}},"msg_e1":"Tu joues contre l'équipe Équipe de testeurs #6 sur la table 3 !","msg_e2":"Tu joues contre l'équipe Équipe 12 sur la table 3 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1469,"sent_to":[13,7]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1470,"tournoi_id":1,"e1":11,"e2":2,"table":"4"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"2":{"nom":"L'équipe surprise #2","createur":"16","membre":"0"},"11":{"nom":"Équipe 11","createur":"12","membre":"0"}},"msg_e1":"Tu joues contre l'équipe L'équipe surprise #2 sur la table 4 !","msg_e2":"Tu joues contre l'équipe Équipe 11 sur la table 4 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1470,"sent_to":[12,16]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1471,"tournoi_id":1,"e1":4,"e2":8,"table":"5"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"4":{"nom":"La Balle Production #4","createur":"17","membre":"0"},"8":{"nom":"Équipe 8","createur":"9","membre":"0"}},"msg_e1":"Tu joues contre l'équipe Équipe 8 sur la table 5 !","msg_e2":"Tu joues contre l'équipe La Balle Production #4 sur la table 5 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1471,"sent_to":[17,9]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 2 : Début match (notif) ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=2 | ctx={"match_id":1472,"tournoi_id":1,"e1":3,"e2":7,"table":"6"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Teams match start | ctx={"teams":{"3":{"nom":"Équipe de Yohan #3","createur":"18","membre":"0"},"7":{"nom":"Équipe 7","createur":"8","membre":"0"}},"msg_e1":"Tu joues contre l'équipe Équipe 7 sur la table 6 !","msg_e2":"Tu joues contre l'équipe Équipe de Yohan #3 sur la table 6 !"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Notifs envoyées début match | ctx={"match_id":1472,"sent_to":[18,8]}
[19-Feb-2026 16:26:03 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1461,"tournoi_id":1,"e1":12,"e2":2,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:03 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1043","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"12","emarge":"1","j":"1","points":"1","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":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:03 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1461,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1461 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1461,"sent_to":[13,16],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1461 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1462,"tournoi_id":1,"e1":5,"e2":4,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1036","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"5","emarge":"1","j":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1035","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"4","emarge":"1","j":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1462,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1462 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1462,"sent_to":[2,3,17],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1462 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1463,"tournoi_id":1,"e1":11,"e2":10,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1042","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"11","emarge":"1","j":"1","points":"1","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":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1463,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1463 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1463,"sent_to":[12,11],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1463 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1464,"tournoi_id":1,"e1":1,"e2":7,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1032","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"1","emarge":"1","j":"1","points":"1","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":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1464,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1464 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1464,"sent_to":[1,8],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1464 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1465,"tournoi_id":1,"e1":3,"e2":9,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1034","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"3","emarge":"1","j":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1040","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"9","emarge":"1","j":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1465,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1465 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1465,"sent_to":[18,10],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1465 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1466,"tournoi_id":1,"e1":6,"e2":8,"s1_raw":"0","s2_raw":"0","phase_text":"Qualifications"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":false,"conteste":false,"egalite":true}
[19-Feb-2026 16:26: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 16:26:04 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1037","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"6","emarge":"1","j":"1","points":"1","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":"1","points":"1","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":2,"new_points_e1":2,"new_ratio_e1":0,"new_elim_e1":0,"new_j_e2":2,"new_points_e2":2,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1466,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=NULL WHERE id=1466 LIMIT 1"}
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1466,"sent_to":[7,9],"isElim":false,"conteste":false,"egalite":true,"vainqueur_id":null,"elim_loser_id":null}
[19-Feb-2026 16:26:04 Europe/Paris] Étape 4 OK match 1466 — phaseElim=0, s1=0, s2=0, gagnant=NULL, elim=NULL
[19-Feb-2026 16:26:04 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":3}
[2026-02-19 16:26:04] 

ÉTAPE 1

ÉTAPE 2
Notifs envoyées pour match 1467 (tournoi 1) : table 1
Notifs envoyées pour match 1468 (tournoi 1) : table 2
Notifs envoyées pour match 1469 (tournoi 1) : table 3
Notifs envoyées pour match 1470 (tournoi 1) : table 4
Notifs envoyées pour match 1471 (tournoi 1) : table 5
Notifs envoyées pour match 1472 (tournoi 1) : table 6

ÉTAPE 3
ÉTAPE 4
ÉTAPE 5

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


--- FIN DU SCRIPT
=== END LOG 2026-02-19 16:26:04 ===