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

ÉTAPE 1

ÉTAPE 2
Notifs envoyées pour match 1461 (tournoi 1) : table 1
Notifs envoyées pour match 1462 (tournoi 1) : table 2
Notifs envoyées pour match 1463 (tournoi 1) : table 3
Notifs envoyées pour match 1464 (tournoi 1) : table 4
Notifs envoyées pour match 1465 (tournoi 1) : table 5
Notifs envoyées pour match 1466 (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:21:03 ===