Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-08-09 Thread Justin Workman
On Tue, Aug 8, 2017 at 8:17 PM, Tom Lane wrote: > Peter Geoghegan writes: > > On Thu, Jan 19, 2017 at 5:45 PM, Peter Geoghegan wrote: > >> A customer is on 9.6.1, and complains of a segfault observed at least > >> 3 times. > > ... > > For the sake of the archives: this now looks very much like

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-08-08 Thread Tom Lane
Peter Geoghegan writes: > On Thu, Jan 19, 2017 at 5:45 PM, Peter Geoghegan wrote: >> A customer is on 9.6.1, and complains of a segfault observed at least >> 3 times. > ... > For the sake of the archives: this now looks very much like the issue > that Tom just fixed with commit > 9bf4068cc321a4d4

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-08-08 Thread Peter Geoghegan
On Thu, Jan 19, 2017 at 5:45 PM, Peter Geoghegan wrote: > A customer is on 9.6.1, and complains of a segfault observed at least > 3 times. > I can use GDB to get details of the instruction pointer that appeared > in the kernel trap error, which shows a function from the expanded > value represent

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-02-16 Thread Amit Kapila
On Thu, Feb 16, 2017 at 11:45 AM, Justin Workman wrote: >> It would help to know the data types of the columns involved in this >> query; but just eyeballing it, it doesn't look like it involves any >> array operations, so it's pretty hard to believe that the expanded-object >> code could have got

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-02-16 Thread Justin Workman
> > It would help to know the data types of the columns involved in this > query; but just eyeballing it, it doesn't look like it involves any > array operations, so it's pretty hard to believe that the expanded-object > code could have gotten invoked intentionally. (The mere presence of > an arra

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-02-03 Thread Peter Geoghegan
On Thu, Jan 19, 2017 at 6:39 PM, Tom Lane wrote: > If $customer wants a quick fix, I'd suggest seeing whether disabling > parallel query makes the problem go away. That might be a good first > step anyway, just to narrow down where the problem lies. I no longer work at Heroku, and so can do very

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-01-20 Thread Robert Haas
On Thu, Jan 19, 2017 at 9:39 PM, Tom Lane wrote: > If I had to bet on the basis of this much info, I would bet that the > parallel-query infrastructure is dropping the ball somewhere and > transmitting a corrupted datum that accidentally looks like it is > an expanded-object reference. There's co

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-01-19 Thread Tom Lane
Peter Geoghegan writes: > A customer is on 9.6.1, and complains of a segfault observed at least > 3 times. In all cases, the logs look like this: > ... > I can use GDB to get details of the instruction pointer that appeared > in the kernel trap error, which shows a function from the expanded > val