With the latest server
testdb=# select version();
version
----------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.5devel_HEAD_20150329_0154_2c33e0fbceb0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.9.2, 64-bit
(1 row)
I get a crash while restoring a trgm GIN index.
The attached bash creates 2 test tables (t5, t6).
A dumpfile, created thus:
pg_dump -F c -v -h /tmp -p 6545 -t t6 -f ~/pg_stuff/dumps/testdb_t6.dump testdb
cannot be restored in an empty database: it crashed the server (see below).
A restore of the smaller table t5 does not crash the system; the indexing is then OK.
Restore:
pg_restore -v -O -x -d testdb ~/pg_stuff/dumps/testdb_t6.dump
I get this crash from restoring :
2015-03-29 17:32:55.846 CEST 8016 LOG: database system is ready to accept connections
TRAP: BadArgument("!(((CurrentMemoryContext) != ((void *)0) && (((((const Node*)((CurrentMemoryContext)))->type) ==
T_AllocSetContext))))", File: "mcxt.c", Line: 813)
2015-03-29 17:35:02.459 CEST 8016 LOG: server process (PID 8062) was terminated by signal 6: Aborted
2015-03-29 17:35:02.459 CEST 8016 DETAIL: Failed process was running: CREATE INDEX t6_trgm_re_idx ON t6 USING gin (txt
gin_trgm_ops);
2015-03-29 17:35:02.459 CEST 8016 LOG: terminating any other active server processes
2015-03-29 17:35:02.502 CEST 8016 LOG: all server processes terminated; reinitializing
2015-03-29 17:35:02.710 CEST 8114 LOG: database system was interrupted; last known up at 2015-03-29 17:32:55 CEST
2015-03-29 17:35:02.735 CEST 8114 LOG: database system was not properly shut down; automatic recovery in progress
2015-03-29 17:35:02.828 CEST 8114 LOG: redo starts at 0/270E550
2015-03-29 17:35:05.665 CEST 8114 LOG: invalid magic number 0000 in log segment 000000010000000000000010, offset
7716864
2015-03-29 17:35:05.665 CEST 8114 LOG: redo done at 0/1075AD90
2015-03-29 17:35:05.665 CEST 8114 LOG: last completed transaction was at log time 2015-03-29 17:34:11.149606+02
2015-03-29 17:35:10.296 CEST 8016 LOG: database system is ready to accept connections
So it would seem the CREATE INDEX is the actual problem (I haven't tried that command separately).
Erik Rijkers
