pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Przemysław Szustak <przemyslaw.szustak@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16283: crash on create index segmentation fault
Date: Fri, 28 Feb 2020 22:00:21 +0100
Message-ID: <20200228210021.znum3xr3kprj3qec@development> (raw)
In-Reply-To: <CAJo3-jhK01fAJdWaDh9n7wQju+ZAEFhTzRa=Y54nLfW1zN+EOA@mail.gmail.com>
References: <16283-89418c2816e96f07@postgresql.org>
	<20200228162620.pfrugnfk527bml6y@development>
	<CAJo3-jhZF2ZngRND8s-AUoM8VYPTruqw2rJfPJE6xXJw-iOO=Q@mail.gmail.com>
	<20200228181135.hkbtwdlvxfv37khn@development>
	<CAJo3-jhK01fAJdWaDh9n7wQju+ZAEFhTzRa=Y54nLfW1zN+EOA@mail.gmail.com>

On Fri, Feb 28, 2020 at 08:58:19PM +0100, Przemysław Szustak wrote:
>I updated info on github logs because now system was generated new core
>dump.
>
>How can I get you more information? I don't now how to debug it.
>

Well, it's hard to say what exactly is happening, without getting a
better backtrace. Your system is apparently missing debug symbols, so
you need to do something like

   sudo aptitude install postgresql-10-dbg

or something like that. And the same for postgis, I assume. Then
generate the backtrace again (using the existing core file).

You might also attach gdb to the running backend, trigger the issue
and do more investigation there.

1) determine the PID of the backend handling your connection

   db=# select pg_backend_pid();

2) attach GDB to the process

   $ gdb -p $PID
   (gdb) c

3) Run the query using the same backend, once it triggers you'll be able
to do 'bt' in the gdb shell and inspect variables.

This needs the debug symbols too, though.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





view thread (12+ messages)  latest in thread

Message-ID: <20200228210021.znum3xr3kprj3qec@development>
Permalink:  ../20200228210021.znum3xr3kprj3qec@development/
Also on:    postgresql.org/message-id/20200228210021.znum3xr3kprj3qec@development

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, przemyslaw.szustak@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16283: crash on create index segmentation fault
  In-Reply-To: <20200228210021.znum3xr3kprj3qec@development>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox