| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> | 
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Strange failure in LWLock on skink in REL9_5_STABLE | 
| Date: | 2018-09-21 02:39:43 | 
| Message-ID: | CAEepm=0vLh5oX2Ve+wS5BiauEoRA2j5R3G7CRwBRxYzc+9zg5g@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hello,
Andres pinged me off-list to point out this failure after my commit fb389498be:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-09-20%2005%3A24%3A34
Change Set for this build:
fb389498be Tue Sep 18 11:19:22 2018 UTC  Allow DSM allocation to be interrupted.
The failure looks like this:
! FATAL:  semop(id=332464133) failed: Invalid argument
! CONTEXT:  SQL statement "CREATE TEMP TABLE brin_result (cid tid)"
! PL/pgSQL function inline_code_block line 22 at SQL statement
! PANIC:  queueing for lock while waiting on another one
! server closed the connection unexpectedly
! This probably means the server terminated abnormally
! before or while processing the request.
! connection to server was lost
I don't immediately see any connection between that particular commit,
which relates to the treatment of signals while allocating a DSM
segment, and the location of the first failure, which is in a
statement that is creating a temporary table.  On the other hand skink
has been very stable lately.  I'm also not sure how the FATAL error
and the PANIC are related (LWLockQueueSelf() has discovered that
MyProc->lwWaiting is already set).  Though it's possible that the root
problem was something happening in any of the other parallel tests
running, I don't see how any of those (lock security_label tablesample
object_address rowsecurity collate spgist privileges matview
replica_identity brin gin gist groupingsets) would reach code touched
by that commit in 9.5, but I don't currently have any other ideas
about what happened here.
-- 
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-09-21 02:41:24 | Re: logical decoding bug when mapped relation with toast contents is rewritten repeatedly | 
| Previous Message | Tsunakawa, Takayuki | 2018-09-21 02:28:07 | RE: Changing the setting of wal_sender_timeout per standby |