Hi Sergei
Thank you for your explanation. I can understand for the lock wait
message, but I have no DETAIL section in my entire log file. Why ?
I have plenty of STATEMENT sections ...
Thanks in advance
Best Regards
Didier ROS
-Message d'origine-
De : s...@
Hi
I have executed grep command on the entire logfile for pid 24803. See the
attached file
NB : I have no DETAIL section in my entire log file. Is it normal ?
Best Reagrds
Didier ROS
-Message d'origine-
De : pry...@telsasoft.com [mailto:pry...@telsasoft.com]
Envoyé : samedi 2
Hello
Postgresql does not log statement parameters on log_lock_wait. Because this is
not implemented:
https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/storage/lmgr/proc.c#L1461
Compare with errdetail_params routine in this file:
https://github.com/postgres/postgres/blob/REL_1
Justin Pryzby writes:
> On Fri, Mar 01, 2019 at 06:47:06PM +, ROS Didier wrote:
>> log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db=%d,client=%h'
> On Sat, Mar 02, 2019 at 01:14:44PM +, ROS Didier wrote:
>> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
>> user=pgbd_preint_sg2,db=pgbd
On Fri, Mar 01, 2019 at 06:47:06PM +, ROS Didier wrote:
> log_line_prefix = '%t [%p]: [%l-1] [%x] user=%u,db=%d,client=%h'
On Sat, Mar 02, 2019 at 01:14:44PM +, ROS Didier wrote:
> 2019-03-01 14:53:37 CET [24803]: [129-1] [3686]
> user=pgbd_preint_sg2,db=pgbd_preint_sg2 LOG: process 2480
Did16 wrote
> Hi
>The SQL is not executed from a trigger.
>Here is an extract of my log file :
>>>
>
> 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 aft
Hi
The SQL is not executed from a trigger.
Here is an extract of my log file :
>>
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
