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
create_data.sh
Description: application/shellscript
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
