Hi,
there is no comment on "PANIC: queueing for lock while waiting on anot=
her
one" in lwlock.c
Postgres Version is 9.5.3.
2016-07-25 18:32:54 CEST [45824]: [185-1]
user=3Dsvc_sqlbalancer_worker,db=3Dadr,client=3D::1 FATAL: *semop(id=3D=
6389799)
failed: Identifier removed*
2016-07-25 18:32:54 CEST [45824]: [186-1]
user=3Dsvc_sqlbalancer_worker,db=3Dadr,client=3D::1 CONTEXT: SQL state=
ment
"create temp table ausfall_ereignis_tmp as
2016-07-25 18:32:54 CEST [45824]: [187-1]
user=3Dsvc_sqlbalancer_worker,db=3Dadr,client=3D::1 STATEMENT: SELECT =
* FROM
svc_sqlbalancer.fx_run_work(50119)
2016-07-25 18:32:54 CEST [45824]: [188-1]
user=3Dsvc_sqlbalancer_worker,db=3Dadr,client=3D::1 *PANIC: queueing f=
or lock
while waiting on another one*
2016-07-25 18:32:55 CEST [12024]: [176-1] user=3D,db=3D,client=3D L=
OG:
server process (PID 45824) was terminated by signal 6: Aborted
2016-07-25 18:33:16 CEST [12024]: [179-1] user=3D,db=3D,client=3D L=
OG: all
server processes terminated; reinitializing
2016-07-25 18:33:16 CEST [12024]: [180-1] user=3D,db=3D,client=3D L=
OG: could
not remove shared memory segment "/PostgreSQL.605661915": No such file =
or
directory
2016-07-25 18:33:16 CEST [12024]: [181-1] user=3D,db=3D,client=3D L=
OG:
semctl(5144577, 0, IPC_RMID, ...) failed: Invalid argument
2016-07-25 18:33:16 CEST [12024]: [182-1] user=3D,db=3D,client=3D L=
OG:
semctl(5177346, 0, IPC_RMID, ...) failed: Invalid argument
2016-07-25 18:33:16 CEST [12024]: [183-1] user=3D,db=3D,client=3D L=
OG:
semctl(5210115, 0, IPC_RMID, ...) failed: Invalid argument
Regards, Jens=