Re: Fwd: Core dump with nested CREATE TEMP TABLE - Mailing list pgsql-hackers

On 9/1/15 1:08 AM, Michael Paquier wrote:
> On Sun, Aug 30, 2015 at 1:06 AM, Jim Nasby wrote:
>> Steps to reproduce:
>> Download https://github.com/BlueTreble/test_factory/archive/crash.zip
>> Unzip, cd into directory
>> pgxn install pgtap (or just make test)
>
> FWIW, make test fails:
> ! ERROR:  42703: column "c_data_table_name" does not exist
> ! LINE 4:     , c_data_table_name
>
>> make install if you didn't do make test
>> psql -f crash.sql
>
> As does this one with the same error. I am not exactly sure what I am missing.
> Regards,

Well nuts, pretty sure that means the error isn't reproducing for you. 
:/ Do you maybe have unusual config options or postgresql.conf options?

Here's a log of how I can reproduce from a just-pulled copy of HEAD:
decibel@decina:[17:22]~/pgsql/HEAD (master $=)$head config.log |grep ./conf  $ ./configure
--with-includes=/opt/local/include
 
--with-libraries=/opt/local/lib --with-perl --with-python 
--enable-depend -C --enable-tap-tests 
--prefix=/Users/decibel/pgsql/HEAD/i --with-pgport=5555 --enable-debug 
CC=ccache clang -Qunused-arguments -fcolor-diagnostics --enable-cassert 
CFLAGS=-O0 --no-create --no-recursion
decibel@decina:[17:22]~/pgsql/HEAD (master $=)$

make; make install; pg_ctl init; pg_ctl start; createdb

decibel@decina:[17:20]~/tmp$mv ~/Downloads/test_factory-crash.zip .
decibel@decina:[17:20]~/tmp$open test_factory-crash.zip
decibel@decina:[17:20]~/tmp$cd test_factory-crash/
decibel@decina:[17:20]~/tmp/test_factory-crash$pgHEAD
decibel@decina:[17:20]~/tmp/test_factory-crash$make test
rm -rf  sql/test_factory--0.1.1.sql
rm -rf results/ regression.diffs regression.out tmp_check/ log/
cp sql/test_factory.sql sql/test_factory--0.1.1.sql
/bin/sh 
/Users/decibel/pgsql/HEAD/i/lib/pgxs/src/makefiles/../../config/install-sh 
-c -d '/Users/decibel/pgsql/HEAD/i/share/extension'
/bin/sh 
/Users/decibel/pgsql/HEAD/i/lib/pgxs/src/makefiles/../../config/install-sh 
-c -d '/Users/decibel/pgsql/HEAD/i/share/doc/extension'
/usr/bin/install -c -m 644 .//test_factory.control 
'/Users/decibel/pgsql/HEAD/i/share/extension/'
/usr/bin/install -c -m 644 .//doc/test_factory.asc 
'/Users/decibel/pgsql/HEAD/i/share/doc/extension/'
/Users/decibel/pgsql/HEAD/i/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress 
--inputdir=./ --bindir='/Users/decibel/pgsql/HEAD/i/bin' 
--inputdir=test --load-language=plpgsql --dbname=contrib_regression base
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
NOTICE:  database "contrib_regression" does not exist, skipping
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== installing plpgsql                     ==============
CREATE LANGUAGE
============== running regression test queries        ==============
test base                     ... FAILED (test process exited with exit 
code 2)

====================== 1 of 1 tests failed.
======================

The differences that caused some tests to fail can be viewed in the
file "/Users/decibel/tmp/test_factory-crash/regression.diffs".  A copy 
of the test summary that you see
above is saved in the file 
"/Users/decibel/tmp/test_factory-crash/regression.out".

make: [installcheck] Error 1 (ignored)
*** /Users/decibel/tmp/test_factory-crash/test/expected/base.out    Sat Aug 
29 08:50:08 2015
--- /Users/decibel/tmp/test_factory-crash/results/base.out    Tue Sep  1 
17:21:04 2015
***************
*** 1,18 ****  \set ECHO none
! ok 1 - Create customer table
! ok 2 - Register test customers
! ok 3 - Create function customer__add
! ok 4 - Create invoice table
! ok 5 - Register test invoices
! ok 6 - customer table is empty
! ok 7 - invoice table is empty
! ok 8 - invoice factory output
! ok 9 - invoice table content
! ok 10 - customer table content
! ok 11 - invoice factory second call
! ok 12 - invoice table content stayed constant
! ok 13 - customer table content stayed constant
! ok 14 - Test function factory
! ok 15 - customer table has new row
! ok 16 - truncate invoice
! ok 17 - invoice factory get remains the same after truncate
--- 1,10 ----  \set ECHO none
! ok 1 - Register test customers
! ok 2 - Create function customer__add
! ok 3 - Register test invoices
! ok 4 - customer table is empty
! ok 5 - invoice table is empty
! server closed the connection unexpectedly
!     This probably means the server terminated abnormally
!     before or while processing the request.
! connection to server was lost

======================================================================

decibel@decina:[17:21]~/tmp/test_factory-crash$
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com