[postgis-tickets] [PostGIS] #4144: If during writing tables that contains PostGIS geometry fields AUTOVACUUM is launched, it crashes and force PostgreSQL to restart.

PostGIS trac at osgeo.org
Fri Aug 10 01:38:34 PDT 2018 

#4144: If during writing tables that contains PostGIS geometry fields AUTOVACUUM
is launched, it crashes and force PostgreSQL to restart.
----------------------+--------------------------
  Reporter:  zancos   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS GDAL
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+--------------------------

Comment (by zancos):

 I have tried to get some bt captures before the failure, but they are
 probably useless.

 {{{
 Continuing.

 Program received signal SIGINT, Interrupt.
 0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix/syscall-
 template.S:84
 84      in ../sysdeps/unix/syscall-template.S
 #0  0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix
 /syscall-template.S:84
 #1  0x000055ebcdb5dcb9 in WaitEventSetWaitBlock (nevents=1,
 occurred_events=0x7ffe6ff53b10, cur_timeout=-1, set=0x55ebceb20ea8) at
 ./build/../src/backend/storage/ipc/latch.c:1053
 #2  WaitEventSetWait (set=0x55ebceb20ea8, timeout=timeout at entry=-1,
 occurred_events=occurred_events at entry=0x7ffe6ff53b10,
 nevents=nevents at entry=1) at
 ./build/../src/backend/storage/ipc/latch.c:1007
 #3  0x000055ebcda91e90 in secure_read (port=0x55ebceb5e540,
 ptr=0x55ebce0cffc0 <PqRecvBuffer>, len=8192) at
 ./build/../src/backend/libpq/be-secure.c:149
 #4  0x000055ebcda9bdc3 in pq_recvbuf () at
 ./build/../src/backend/libpq/pqcomm.c:940
 #5  0x000055ebcda9cc75 in pq_getbyte () at
 ./build/../src/backend/libpq/pqcomm.c:983
 #6  0x000055ebcdb7fb1d in SocketBackend (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:326
 #7  ReadCommand (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:499
 #8  PostgresMain (argc=<optimized out>, argv=argv at entry=0x55ebceb690e0,
 dbname=<optimized out>, username=<optimized out>) at
 ./build/../src/backend/tcop/postgres.c:4017
 #9  0x000055ebcd8f4bd8 in BackendRun (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4342
 #10 BackendStartup (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4016
 #11 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1721
 #12 0x000055ebcdb1d492 in PostmasterMain (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/postmaster/postmaster.c:1329
 #13 0x000055ebcd8f5f44 in main (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/main/main.c:228
 Continuing.

 Program received signal SIGINT, Interrupt.
 0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix/syscall-
 template.S:84
 84      in ../sysdeps/unix/syscall-template.S
 #0  0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix
 /syscall-template.S:84
 #1  0x000055ebcdb5dcb9 in WaitEventSetWaitBlock (nevents=1,
 occurred_events=0x7ffe6ff53b10, cur_timeout=-1, set=0x55ebceb20ea8) at
 ./build/../src/backend/storage/ipc/latch.c:1053
 #2  WaitEventSetWait (set=0x55ebceb20ea8, timeout=timeout at entry=-1,
 occurred_events=occurred_events at entry=0x7ffe6ff53b10,
 nevents=nevents at entry=1) at
 ./build/../src/backend/storage/ipc/latch.c:1007
 #3  0x000055ebcda91e90 in secure_read (port=0x55ebceb5e540,
 ptr=0x55ebce0cffc0 <PqRecvBuffer>, len=8192) at
 ./build/../src/backend/libpq/be-secure.c:149
 #4  0x000055ebcda9bdc3 in pq_recvbuf () at
 ./build/../src/backend/libpq/pqcomm.c:940
 #5  0x000055ebcda9cc75 in pq_getbyte () at
 ./build/../src/backend/libpq/pqcomm.c:983
 #6  0x000055ebcdb7fb1d in SocketBackend (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:326
 #7  ReadCommand (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:499
 #8  PostgresMain (argc=<optimized out>, argv=argv at entry=0x55ebceb690e0,
 dbname=<optimized out>, username=<optimized out>) at
 ./build/../src/backend/tcop/postgres.c:4017
 #9  0x000055ebcd8f4bd8 in BackendRun (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4342
 #10 BackendStartup (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4016
 #11 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1721
 #12 0x000055ebcdb1d492 in PostmasterMain (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/postmaster/postmaster.c:1329
 #13 0x000055ebcd8f5f44 in main (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/main/main.c:228
 Breakpoint 1 at 0x55ebcdc87b40: file
 ./build/../src/backend/utils/error/elog.c, line 414.
 Continuing.

 Program received signal SIGINT, Interrupt.
 0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix/syscall-
 template.S:84
 84      in ../sysdeps/unix/syscall-template.S
 #0  0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix
 /syscall-template.S:84
 #1  0x000055ebcdb5dcb9 in WaitEventSetWaitBlock (nevents=1,
 occurred_events=0x7ffe6ff53b10, cur_timeout=-1, set=0x55ebceb20ea8) at
 ./build/../src/backend/storage/ipc/latch.c:1053
 #2  WaitEventSetWait (set=0x55ebceb20ea8, timeout=timeout at entry=-1,
 occurred_events=occurred_events at entry=0x7ffe6ff53b10,
 nevents=nevents at entry=1) at
 ./build/../src/backend/storage/ipc/latch.c:1007
 #3  0x000055ebcda91e90 in secure_read (port=0x55ebceb5e540,
 ptr=0x55ebce0cffc0 <PqRecvBuffer>, len=8192) at
 ./build/../src/backend/libpq/be-secure.c:149
 #4  0x000055ebcda9bdc3 in pq_recvbuf () at
 ./build/../src/backend/libpq/pqcomm.c:940
 #5  0x000055ebcda9cc75 in pq_getbyte () at
 ./build/../src/backend/libpq/pqcomm.c:983
 #6  0x000055ebcdb7fb1d in SocketBackend (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:326
 #7  ReadCommand (inBuf=0x7ffe6ff53d10) at
 ./build/../src/backend/tcop/postgres.c:499
 #8  PostgresMain (argc=<optimized out>, argv=argv at entry=0x55ebceb690e0,
 dbname=<optimized out>, username=<optimized out>) at
 ./build/../src/backend/tcop/postgres.c:4017
 #9  0x000055ebcd8f4bd8 in BackendRun (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4342
 #10 BackendStartup (port=0x55ebceb5e540) at
 ./build/../src/backend/postmaster/postmaster.c:4016
 #11 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1721
 #12 0x000055ebcdb1d492 in PostmasterMain (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/postmaster/postmaster.c:1329
 #13 0x000055ebcd8f5f44 in main (argc=5, argv=0x55ebceb1ee10) at
 ./build/../src/backend/main/main.c:228
 Continuing.

 Program received signal SIGQUIT, Quit.
 0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix/syscall-
 template.S:84
 84      in ../sysdeps/unix/syscall-template.S
 #0  0x00007f67416570a3 in __epoll_wait_nocancel () at ../sysdeps/unix
 /syscall-template.S:84
 Backtrace stopped: Cannot access memory at address 0x7ffe6ff53a38
 Detaching from program: /usr/lib/postgresql/9.6/bin/postgres, process 5678

 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4144#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-tickets mailing list