[postgres@noeyypvd pg_log]$ grep 24803 postgresql.log 2019-03-01 14:44:40 CET [24803]: [1-1] [0] user=[unknown],db=[unknown] LOG: connection received: host=127.0.0.1 port=39664 2019-03-01 14:44:40 CET [24803]: [2-1] [0] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: connection authorized: user=pgbd_preint_sg2 database=pgbd_preint_sg2 2019-03-01 14:49:36 CET [24793]: [192-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24803]: [3-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3018 after 1000.117 ms 2019-03-01 14:49:36 CET [24803]: [4-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24803]: [5-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,55) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:36 CET [24803]: [6-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:36 CET [24678]: [135-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24810]: [37-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24698]: [102-1] [2895] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24715]: [114-1] [2932] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24689]: [133-1] [2982] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24795]: [56-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24768]: [137-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24809]: [133-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24776]: [107-1] [3001] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24800]: [65-1] [2986] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24711]: [177-1] [2969] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24774]: [224-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24676]: [32-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24786]: [16-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24725]: [102-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:36 CET [24681]: [18-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24772. Wait queue: 24800, 24711, 24793, 24774, 24809, 24676, 24776, 24803, 24786, 24725, 24681, 24678, 24810, 24698, 24715, 24689, 24795, 24768. 2019-03-01 14:49:38 CET [24803]: [7-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3018 after 2791.920 ms 2019-03-01 14:49:38 CET [24803]: [8-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,55) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:38 CET [24803]: [9-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:39 CET [24800]: [72-1] [2986] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24793]: [199-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24809]: [140-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24776]: [114-1] [3001] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24803]: [10-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 2969 after 1006.713 ms 2019-03-01 14:49:39 CET [24803]: [11-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24803]: [12-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,57) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:39 CET [24803]: [13-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:39 CET [24725]: [109-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24678]: [142-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24810]: [44-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24689]: [140-1] [2982] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24795]: [63-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24774]: [231-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24676]: [39-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24786]: [23-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24681]: [25-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24768]: [144-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:39 CET [24715]: [121-1] [2932] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795. 2019-03-01 14:49:41 CET [24804]: [44-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24711. Wait queue: 24800, 24793, 24774, 24809, 24676, 24776, 24786, 24768, 24715, 24803, 24681, 24725, 24678, 24810, 24689, 24795, 24804. 2019-03-01 14:49:41 CET [24803]: [14-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 2969 after 3243.200 ms 2019-03-01 14:49:41 CET [24803]: [15-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,57) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:41 CET [24803]: [16-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:42 CET [24768]: [151-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24715]: [128-1] [2932] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24774]: [238-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24809]: [147-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24676]: [46-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24786]: [30-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24681]: [32-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24810]: [51-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24795]: [70-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24793]: [206-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24776]: [121-1] [3001] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24803]: [17-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 2986 after 1005.934 ms 2019-03-01 14:49:42 CET [24803]: [18-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24803]: [19-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,59) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:42 CET [24803]: [20-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:42 CET [24725]: [116-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24678]: [149-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24689]: [147-1] [2982] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:42 CET [24804]: [51-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24800. Wait queue: 24774, 24809, 24676, 24786, 24681, 24768, 24810, 24715, 24795, 24793, 24776, 24803, 24725, 24678, 24689, 24804. 2019-03-01 14:49:45 CET [24803]: [21-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 2986 after 3189.594 ms 2019-03-01 14:49:45 CET [24803]: [22-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,59) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:45 CET [24803]: [23-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:46 CET [24768]: [158-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24776]: [128-1] [3001] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24803]: [24-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 2932 after 1006.212 ms 2019-03-01 14:49:46 CET [24803]: [25-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24803]: [26-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,61) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:46 CET [24803]: [27-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:46 CET [24725]: [123-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24689]: [154-1] [2982] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24804]: [58-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [21446]: [4-1] [3057] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24774]: [245-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24809]: [154-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24676]: [53-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24681]: [39-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24810]: [58-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24795]: [77-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24678]: [156-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24793]: [213-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24786]: [37-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24714]: [84-1] [3056] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:46 CET [24766]: [44-1] [3059] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766. 2019-03-01 14:49:47 CET [24791]: [58-1] [3063] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24776, 24774, 24803, 24809, 24725, 24676, 24689, 24768, 24804, 24681, 21446, 24810, 24795, 24678, 24793, 24786, 24714, 24766, 24791. 2019-03-01 14:49:48 CET [24803]: [28-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 2932 after 3461.027 ms 2019-03-01 14:49:48 CET [24803]: [29-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,61) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:48 CET [24803]: [30-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:49 CET [24776]: [135-1] [3001] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24803]: [31-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 2982 after 1001.169 ms 2019-03-01 14:49:49 CET [24803]: [32-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24803]: [33-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,63) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:49 CET [24803]: [34-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:49 CET [24725]: [130-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24804]: [65-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24810]: [65-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24793]: [220-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24786]: [44-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24714]: [91-1] [3056] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24791]: [65-1] [3063] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [21446]: [11-1] [3057] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24774]: [252-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24809]: [161-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24676]: [60-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24681]: [46-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24795]: [84-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24678]: [163-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24766]: [51-1] [3059] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24768]: [165-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:49 CET [24775]: [163-1] [3068] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24689. Wait queue: 24776, 21446, 24803, 24725, 24804, 24810, 24793, 24786, 24714, 24791, 24774, 24809, 24676, 24681, 24795, 24678, 24766, 24768, 24775. 2019-03-01 14:49:51 CET [24803]: [35-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 2982 after 2999.332 ms 2019-03-01 14:49:51 CET [24803]: [36-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,63) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:51 CET [24803]: [37-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:52 CET [21446]: [18-1] [3057] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24803]: [38-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3001 after 1007.895 ms 2019-03-01 14:49:52 CET [24803]: [39-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24803]: [40-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,65) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:52 CET [24803]: [41-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:52 CET [24775]: [170-1] [3068] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24725]: [137-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24804]: [72-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24786]: [51-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24791]: [72-1] [3063] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24678]: [170-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24768]: [172-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24777]: [9-1] [3070] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [21445]: [79-1] [3074] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24809]: [168-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24774]: [259-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24681]: [53-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24676]: [67-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24795]: [91-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24766]: [58-1] [3059] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24793]: [227-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24810]: [72-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:52 CET [24714]: [98-1] [3056] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714. 2019-03-01 14:49:53 CET [21450]: [88-1] [3080] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 24803, 24725, 24804, 24786, 24791, 24678, 24768, 21446, 24775, 24777, 21445, 24809, 24774, 24681, 24676, 24795, 24766, 24793, 24810, 24714, 21450. 2019-03-01 14:49:54 CET [24803]: [42-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3001 after 3126.443 ms 2019-03-01 14:49:54 CET [24803]: [43-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,65) in relation "t_shared_liste_valeurs" 2019-03-01 14:49:54 CET [24803]: [44-1] [3022] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:49:55 CET [24681]: [60-1] [3010] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24774]: [266-1] [2951] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24809]: [175-1] [2959] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24766]: [65-1] [3059] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24795]: [98-1] [2985] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24676]: [74-1] [2991] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [21450]: [95-1] [3080] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24804]: [79-1] [3050] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24725]: [144-1] [3015] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24786]: [58-1] [3012] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [21446]: [25-1] [3057] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24714]: [105-1] [3056] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24810]: [79-1] [2988] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24775]: [177-1] [3068] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24777]: [16-1] [3070] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [21445]: [86-1] [3074] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24791]: [79-1] [3063] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24678]: [177-1] [3025] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24768]: [179-1] [2950] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:55 CET [24793]: [234-1] [2999] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445. 2019-03-01 14:49:57 CET [24677]: [4-1] [3090] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24681, 24774, 24809, 24766, 24791, 24678, 24795, 24676, 24768, 24793, 21450, 24810, 24714, 24804, 24725, 24786, 21446, 24775, 24777, 21445, 24677. 2019-03-01 14:53:04 CET [24690]: [179-1] [3587] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [24776]: [212-1] [3592] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [24787]: [60-1] [3583] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [21446]: [137-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [24714]: [154-1] [3591] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [24803]: [45-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3586 after 1005.750 ms 2019-03-01 14:53:04 CET [24803]: [46-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [24803]: [47-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,56) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:04 CET [24803]: [48-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:04 CET [24773]: [116-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:04 CET [21448]: [193-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24693. Wait queue: 24690, 24776, 24787, 24773, 21448, 21446, 24714, 24803. 2019-03-01 14:53:06 CET [24803]: [49-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3586 after 2162.326 ms 2019-03-01 14:53:06 CET [24803]: [50-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,56) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:06 CET [24803]: [51-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:07 CET [24690]: [186-1] [3587] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [21446]: [144-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24776]: [219-1] [3592] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24803]: [52-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3591 after 1005.111 ms 2019-03-01 14:53:07 CET [24803]: [53-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24803]: [54-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,57) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:07 CET [24803]: [55-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:07 CET [24787]: [67-1] [3583] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24773]: [123-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [21448]: [200-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24813]: [219-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24714. Wait queue: 24690, 21446, 24776, 24803, 24787, 24773, 21448, 24813. 2019-03-01 14:53:07 CET [24803]: [56-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3591 after 1646.225 ms 2019-03-01 14:53:07 CET [24803]: [57-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,57) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:07 CET [24803]: [58-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:08 CET [21446]: [151-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24803]: [59-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3592 after 1000.159 ms 2019-03-01 14:53:08 CET [24803]: [60-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24803]: [61-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,59) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:08 CET [24803]: [62-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:08 CET [24770]: [112-1] [3616] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [21448]: [207-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24773]: [130-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24690]: [193-1] [3587] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24787]: [74-1] [3583] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:08 CET [24813]: [226-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24776. Wait queue: 21448, 24690, 24773, 24787, 24813, 24770, 21446, 24803. 2019-03-01 14:53:09 CET [24803]: [63-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3592 after 2043.253 ms 2019-03-01 14:53:09 CET [24803]: [64-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,59) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:09 CET [24803]: [65-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:10 CET [24787]: [81-1] [3583] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24813]: [233-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [21448]: [214-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24773]: [137-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24715]: [135-1] [3624] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24770]: [119-1] [3616] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24803]: [66-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3587 after 1010.537 ms 2019-03-01 14:53:10 CET [24803]: [67-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24803]: [68-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,61) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:10 CET [24803]: [69-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:10 CET [21446]: [158-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:10 CET [24781]: [65-1] [3618] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24690. Wait queue: 24787, 24813, 24770, 24803, 21446, 21448, 24781, 24773, 24715. 2019-03-01 14:53:13 CET [24803]: [70-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3587 after 3344.263 ms 2019-03-01 14:53:13 CET [24803]: [71-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,61) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:13 CET [24803]: [72-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:14 CET [24803]: [73-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3583 after 1000.164 ms 2019-03-01 14:53:14 CET [24803]: [74-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24803]: [75-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,63) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:14 CET [24803]: [76-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:14 CET [24770]: [126-1] [3616] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [21446]: [165-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24781]: [72-1] [3618] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24715]: [142-1] [3624] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24813]: [240-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24773]: [144-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [21448]: [221-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24787. Wait queue: 24781, 24813, 24715, 24803, 24770, 21446, 24773, 21448. 2019-03-01 14:53:14 CET [24803]: [77-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3583 after 1877.704 ms 2019-03-01 14:53:14 CET [24803]: [78-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (2,63) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:14 CET [24803]: [79-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:15 CET [24715]: [149-1] [3624] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [24813]: [247-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [24803]: [80-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3618 after 1005.329 ms 2019-03-01 14:53:15 CET [24803]: [81-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [24803]: [82-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while locking tuple (2,65) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:15 CET [24803]: [83-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:15 CET [24770]: [133-1] [3616] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [21446]: [172-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [24773]: [151-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:15 CET [21448]: [228-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24781. Wait queue: 24803, 24770, 24773, 21446, 24715, 21448, 24813. 2019-03-01 14:53:16 CET [24716]: [225-1] [3636] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24716, 24730. 2019-03-01 14:53:16 CET [24730]: [205-1] [3637] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24716, 24730. 2019-03-01 14:53:16 CET [24803]: [84-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3618 after 1951.464 ms 2019-03-01 14:53:16 CET [24803]: [85-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while locking tuple (2,65) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:16 CET [24803]: [86-1] [3604] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:17 CET [24773]: [158-1] [3571] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [21448]: [235-1] [3601] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24813]: [254-1] [3614] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24770]: [140-1] [3616] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [21446]: [179-1] [3502] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24730]: [210-1] [3637] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24810]: [203-1] [3646] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24853]: [226-1] [3647] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24715]: [156-1] [3624] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:17 CET [24716]: [230-1] [3636] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24803. Wait queue: 24813, 24770, 24773, 21446, 21448, 24715, 24716, 24730, 24810, 24853. 2019-03-01 14:53:27 CET [24786]: [121-1] [3666] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [21443]: [226-1] [3671] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [24730]: [252-1] [3637] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [24683]: [165-1] [3652] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [24810]: [245-1] [3646] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [24715]: [177-1] [3672] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 2480 . 2019-03-01 14:53:27 CET [24803]: [87-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3659 after 1000.920 ms 2019-03-01 14:53:27 CET [24803]: [88-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24783. Wait queue: 21443, 24715, 24730, 24683, 24810, 24786, 24803. 2019-03-01 14:53:27 CET [24803]: [89-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,15) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:27 CET [24803]: [90-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:27 CET [24803]: [91-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3659 after 1007.654 ms 2019-03-01 14:53:27 CET [24803]: [92-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,15) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:27 CET [24803]: [93-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:28 CET [21443]: [233-1] [3671] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24715]: [184-1] [3672] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24683]: [172-1] [3652] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24803]: [94-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3637 after 1000.897 ms 2019-03-01 14:53:28 CET [24803]: [95-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24803]: [96-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,17) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:28 CET [24803]: [97-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:28 CET [24810]: [252-1] [3646] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24786]: [128-1] [3666] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24730. Wait queue: 24810, 21443, 24715, 24683, 24803, 24786, 21449. 2019-03-01 14:53:28 CET [24803]: [98-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3637 after 1090.211 ms 2019-03-01 14:53:28 CET [24803]: [99-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,17) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:28 CET [24803]: [100-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:30 CET [21449]: [107-1] [3694] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 21443. Wait queue: 24786, 24715, 24803, 24683, 21449. 2019-03-01 14:53:30 CET [24715]: [191-1] [3672] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 21443. Wait queue: 24786, 24715, 24803, 24683, 21449. 2019-03-01 14:53:30 CET [24803]: [101-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3671 after 1010.911 ms 2019-03-01 14:53:30 CET [24803]: [102-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 21443. Wait queue: 24786, 24715, 24803, 24683, 21449. 2019-03-01 14:53:30 CET [24803]: [103-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,21) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:30 CET [24803]: [104-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:30 CET [24683]: [179-1] [3652] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 21443. Wait queue: 24786, 24715, 24803, 24683, 21449. 2019-03-01 14:53:30 CET [24786]: [135-1] [3666] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 21443. Wait queue: 24786, 24715, 24803, 24683, 21449. 2019-03-01 14:53:30 CET [24803]: [105-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3671 after 1055.215 ms 2019-03-01 14:53:30 CET [24803]: [106-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,21) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:30 CET [24803]: [107-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:31 CET [24715]: [198-1] [3672] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24786. Wait queue: 24715, 24803, 24683, 21449. 2019-03-01 14:53:31 CET [24803]: [108-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3666 after 1001.632 ms 2019-03-01 14:53:31 CET [24803]: [109-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24786. Wait queue: 24715, 24803, 24683, 21449. 2019-03-01 14:53:31 CET [24803]: [110-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,23) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:31 CET [24803]: [111-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:31 CET [24683]: [186-1] [3652] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24786. Wait queue: 24715, 24803, 24683, 21449. 2019-03-01 14:53:31 CET [21449]: [114-1] [3694] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24786. Wait queue: 24715, 24803, 24683, 21449. 2019-03-01 14:53:31 CET [24803]: [112-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3666 after 1037.226 ms 2019-03-01 14:53:31 CET [24803]: [113-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,23) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:31 CET [24803]: [114-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:33 CET [24803]: [115-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3652 after 1000.091 ms 2019-03-01 14:53:33 CET [24803]: [116-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24683. Wait queue: 21449, 24803, 24715. 2019-03-01 14:53:33 CET [24803]: [117-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,27) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:33 CET [24803]: [118-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:33 CET [21449]: [121-1] [3694] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24683. Wait queue: 21449, 24803, 24715. 2019-03-01 14:53:33 CET [24803]: [119-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3652 after 1295.683 ms 2019-03-01 14:53:33 CET [24803]: [120-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,27) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:33 CET [24803]: [121-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:35 CET [24786]: [142-1] [3711] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24786, 24803. 2019-03-01 14:53:35 CET [24803]: [122-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3709 after 1000.093 ms 2019-03-01 14:53:35 CET [24803]: [123-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24715. Wait queue: 24786, 24803. 2019-03-01 14:53:35 CET [24803]: [124-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,31) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:35 CET [24803]: [125-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:36 CET [24803]: [126-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3709 after 1179.512 ms 2019-03-01 14:53:36 CET [24803]: [127-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,31) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:36 CET [24803]: [128-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:37 CET [24803]: [129-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 still waiting for ShareLock on transaction 3711 after 1000.476 ms 2019-03-01 14:53:37 CET [24803]: [130-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 DETAIL: Process holding the lock: 24786. Wait queue: 24803. 2019-03-01 14:53:37 CET [24803]: [131-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,33) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:37 CET [24803]: [132-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 14:53:37 CET [24803]: [133-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 24803 acquired ShareLock on transaction 3711 after 1250.440 ms 2019-03-01 14:53:37 CET [24803]: [134-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 CONTEXT: while rechecking updated tuple (3,33) in relation "t_shared_liste_valeurs" 2019-03-01 14:53:37 CET [24803]: [135-1] [3686] user=pgbd_preint_sg2,db=pgbd_preint_sg2 STATEMENT: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 2019-03-01 15:40:09 CET [24803]: [136-1] [0] user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: disconnection: session time: 0:55:29.501 user=pgbd_preint_sg2 database=pgbd_preint_sg2 host=127.0.0.1 port=39664