From: | Boris Sagadin <sagadin(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14917: process hang on create index |
Date: | 2017-11-20 08:24:53 |
Message-ID: | CAF8kEZu3f=RXJgLmbGD12TZ4CiBmmpEEfK=R8nikoNN20XCAxw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thanks Tom, I made a few traces on the process, one at the beginning and a
few later when it seems stuck, below is the output.
Continuing.
Program received signal SIGINT, Interrupt.
get_next_seq (seq=0x7ffedb17ec10, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:196
196 strcoll_l.c: No such file or directory.
#0 get_next_seq (seq=0x7ffedb17ec10, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:196
#1 0x00007f530bcb8cd4 in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:598
#2 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#3 0x00007f530dd3671d in bttextfastcmp_locale (x=139995244067904,
y=139994821917520, ssup=0x7f530e7268b8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#4 0x00007f530dd845b0 in ApplySortComparator (ssup=0x7f530e7268b8,
isNull2=<optimized out>, datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#5 comparetup_index_btree (a=0x7f4abbe940c8, b=0x7f4ab76ba048,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3537
#6 0x00007f530dd81e0b in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:150
#7 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#8 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#9 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#10 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#11 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#12 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#13 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#14 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#15 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#16 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#17 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#18 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#19 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#20 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#21 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#22 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#23 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#24 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#25 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:59
59 ../locale/weight.h: No such file or directory.
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:59
#1 get_next_seq (seq=0x7ffedb17ec00, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cfb in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:600
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139994913656534,
y=139994895554246, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81e0b in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:150
#8 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#9 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#10 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#11 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#12 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#13 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#14 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#15 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#16 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#17 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#18 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#19 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#20 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#21 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#22 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#23 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#24 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#25 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#26 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#27 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:82
82 in ../locale/weight.h
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:82
#1 get_next_seq (seq=0x7ffedb17eb10, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cd4 in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:598
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139994815226649,
y=139994751671529, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81dd6 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:140
#8 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#9 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#10 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#11 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#12 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#13 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#14 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#15 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#16 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#17 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#18 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#19 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#20 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#21 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#22 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#23 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#24 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#25 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#26 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#27 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#28 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:42
42 in ../locale/weight.h
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:42
42 in ../locale/weight.h
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:42
#1 get_next_seq (seq=0x7ffedb17eb10, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cd4 in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:598
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139995304437865,
y=139994751671529, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81dd6 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:140
#8 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#9 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#10 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#11 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#12 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#13 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#14 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#15 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#16 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#17 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#18 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#19 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#20 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#21 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#22 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#23 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#24 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#25 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#26 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#27 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#28 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
0x00007f530bcb7c0a in findidx (len=18446744073709551614, cpp=<synthetic
pointer>) at ../locale/weight.h:93
93 in ../locale/weight.h
#0 0x00007f530bcb7c0a in findidx (len=18446744073709551614, cpp=<synthetic
pointer>) at ../locale/weight.h:93
#1 get_next_seq (seq=0x7ffedb17ea90, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cd4 in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:598
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139995151449433,
y=139995298339177, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81dd6 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=187172, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:140
#8 0x00007f530dd81cd0 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#9 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#10 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#11 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#12 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#13 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#14 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#15 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#16 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#17 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#18 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#19 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#20 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#21 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#22 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#23 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#24 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#25 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#26 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#27 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#28 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#29 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:59
59 in ../locale/weight.h
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:59
#1 get_next_seq (seq=0x7ffedb17ea80, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cfb in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:600
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139994775433737,
y=139995035445657, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81e0b in qsort_tuple (a=a(at)entry=0x7f4ab875ef00,
n=<optimized out>, n(at)entry=66431, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:150
#8 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=187172, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#9 0x00007f530dd81cd0 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#10 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#11 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#12 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#13 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#14 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#15 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#16 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#17 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#18 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#19 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#20 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#21 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#22 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#23 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#24 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#25 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#26 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#27 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#28 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#29 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#30 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:48
48 in ../locale/weight.h
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:48
#1 get_next_seq (seq=0x7ffedb17ea00, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cfb in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:600
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139995142867225,
y=139995284610761, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81e0b in qsort_tuple (a=a(at)entry=0x7f4ab875ef00,
n=<optimized out>, n(at)entry=17292, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:150
#8 0x00007f530dd81cd0 in qsort_tuple (a=a(at)entry=0x7f4ab875ef00,
n=<optimized out>, n(at)entry=66431, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#9 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=187172, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#10 0x00007f530dd81cd0 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#11 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#12 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#13 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#14 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#15 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#16 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#17 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#18 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#19 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#20 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#21 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#22 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#23 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#24 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#25 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#26 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#27 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#28 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#29 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#30 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#31 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Continuing.
Program received signal SIGINT, Interrupt.
findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:48
48 in ../locale/weight.h
#0 findidx (len=18446744073709551614, cpp=<synthetic pointer>) at
../locale/weight.h:48
#1 get_next_seq (seq=0x7ffedb17ea00, nrules=nrules(at)entry=4,
rulesets=rulesets(at)entry=0x7f5307925f88
"\001\002\001\005\001\001\001\005\002\002\002\005",
weights=weights(at)entry=0x7f5307926394
"", table=0x7f5307925f94, extra=0x7f5307953d18 "",
indirect=indirect(at)entry=0x7f530795bb7c)
at strcoll_l.c:198
#2 0x00007f530bcb8cfb in __GI___strcoll_l (s1=<optimized out>,
s2=<optimized out>, l=<optimized out>) at strcoll_l.c:600
#3 0x00007f530bcab810 in __GI_strcoll (s1=<optimized out>, s2=<optimized
out>) at strcoll.c:36
#4 0x00007f530dd3671d in bttextfastcmp_locale (x=139994798856841,
y=139995455839593, ssup=0x7f530e7268f8) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/adt/varlena.c:1957
#5 0x00007f530dd8478d in ApplySortComparator (ssup=0x7f530e7268f8,
isNull2=0 '\000', datum2=<optimized out>, isNull1=<optimized out>,
datum1=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/include/utils/sortsupport.h:238
#6 comparetup_index_btree (a=<optimized out>, b=<optimized out>,
state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:3571
#7 0x00007f530dd81dd6 in qsort_tuple (a=a(at)entry=0x7f4ab8855590,
n=<optimized out>, n(at)entry=24377, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:140
#8 0x00007f530dd81ef1 in qsort_tuple (a=0x7f4ab87c4438,
a(at)entry=0x7f4ab875ef00,
n=<optimized out>, n(at)entry=66431, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#9 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=187172, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#10 0x00007f530dd81cd0 in qsort_tuple (a=a(at)entry=0x7f4ab849b788,
n=<optimized out>, n(at)entry=470554, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#11 0x00007f530dd81ef1 in qsort_tuple (a=a(at)entry=0x7f4ab76ba048,
n=<optimized out>, n(at)entry=1077010, cmp_tuple=cmp_tuple(at)entry=0x7f530dd84510
<comparetup_index_btree>, state=state(at)entry=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:191
#12 0x00007f530dd81cd0 in qsort_tuple (a=0x7f4ab76ba048, n=<optimized out>,
cmp_tuple=0x7f530dd84510 <comparetup_index_btree>,
state=state(at)entry=0x7f530e726598)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/qsort_tuple.c:177
#13 0x00007f530dd86644 in tuplesort_performsort (state=0x7f530e726598) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/sort/tuplesort.c:1599
#14 0x00007f530da5127d in _bt_leafbuild (btspool=0x7f530e723c70,
btspool2=0x0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtsort.c:213
#15 0x00007f530da4c531 in btbuild (fcinfo=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/access/nbtree/nbtree.c:137
#16 0x00007f530dd619fc in OidFunctionCall3Coll
(functionId=functionId(at)entry=338,
collation=collation(at)entry=0, arg1=arg1(at)entry=139994693811608,
arg2=arg2(at)entry=139994693838656, arg3=arg3(at)entry=139994701390800) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/utils/fmgr/fmgr.c:1649
#17 0x00007f530da9360d in index_build
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelation=indexRelation(at)entry=0x7f530dff2740,
indexInfo=indexInfo(at)entry=0x7f530e7263d0,
isprimary=isprimary(at)entry=0 '\000', isreindex=isreindex(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:2025
#18 0x00007f530da94d0f in index_create
(heapRelation=heapRelation(at)entry=0x7f530dfebd98,
indexRelationName=indexRelationName(at)entry=0x7f530e7261d8
"idx_space024484_fast", indexRelationId=82152332, indexRelationId(at)entry=0,
relFileNode=<optimized out>, indexInfo=indexInfo(at)entry=0x7f530e7263d0,
indexColNames=indexColNames(at)entry=0x7f530e7228c8,
accessMethodObjectId=accessMethodObjectId(at)entry=403,
tableSpaceId=tableSpaceId(at)entry=0,
collationObjectId=collationObjectId(at)entry=0x7f530e722948,
classObjectId=classObjectId(at)entry=0x7f530e722960,
coloptions=coloptions(at)entry=0x7f530e722978, reloptions=reloptions(at)entry=0,
isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000',
initdeferred=0 '\000', allow_system_table_mods=0 '\000', skip_build=0
'\000', concurrent=0 '\000', is_internal=0 '\000', if_not_exists=0 '\000')
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/catalog/index.c:1100
#19 0x00007f530db1f472 in DefineIndex (relationId=relationId(at)entry=82144139,
stmt=stmt(at)entry=0x7f530e726148, indexRelationId=indexRelationId(at)entry=0,
is_alter_table=is_alter_table(at)entry=0 '\000',
check_rights=check_rights(at)entry=1 '\001', skip_build=skip_build(at)entry=0
'\000', quiet=quiet(at)entry=0 '\000') at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/commands/indexcmds.c:607
#20 0x00007f530dc6b638 in ProcessUtilitySlow
(parsetree=parsetree(at)entry=0x7f530e6f0778,
queryString=queryString(at)entry=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=params(at)entry=0x0,
completionTag=completionTag(at)entry=0x7ffedb180150 "", dest=<optimized out>)
at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:1259
#21 0x00007f530dc6a3b9 in standard_ProcessUtility
(parsetree=0x7f530e6f0778, queryString=0x7f530e6efb18 "CREATE INDEX
idx_space024484_fast ON space024484 USING btree (k, n);",
context=<optimized out>, params=0x0, dest=<optimized out>,
completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/utility.c:892
#22 0x00007f530dc67501 in PortalRunUtility (portal=0x7f530e6646b8,
utilityStmt=0x7f530e6f0778, isTopLevel=<optimized out>,
dest=0x7f530e6f0b18, completionTag=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1183
#23 0x00007f530dc68146 in PortalRunMulti (portal=portal(at)entry=0x7f530e6646b8,
isTopLevel=isTopLevel(at)entry=1 '\001', dest=dest(at)entry=0x7f530e6f0b18,
altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150
"") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:1314
#24 0x00007f530dc68d15 in PortalRun (portal=portal(at)entry=0x7f530e6646b8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001', dest=dest(at)entry=0x7f530e6f0b18, altdest=altdest(at)entry=0x7f530e6f0b18,
completionTag=completionTag(at)entry=0x7ffedb180150 "") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/pquery.c:812
#25 0x00007f530dc66815 in exec_simple_query (query_string=0x7f530e6efb18
"CREATE INDEX idx_space024484_fast ON space024484 USING btree (k, n);") at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:1096
#26 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f530e646578,
dbname=0x7f530e646428 "postgres", username=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/tcop/postgres.c:4049
#27 0x00007f530da0795c in BackendRun (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:4264
#28 BackendStartup (port=0x7f530e68b9c0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:3938
#29 ServerLoop () at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1703
#30 0x00007f530dc0b53d in PostmasterMain (argc=5, argv=<optimized out>) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/postmaster/postmaster.c:1311
#31 0x00007f530da08662 in main (argc=5, argv=0x7f530e6451f0) at
/build/postgresql-9.5-MJQSVS/postgresql-9.5-9.5.10/build/../src/backend/main/main.c:228
Detaching from program: /usr/lib/postgresql/9.5/bin/postgres, process 15726
On Sat, Nov 18, 2017 at 4:54 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Boris Sagadin <sagadin(at)gmail(dot)com> writes:
> > I don't know how to create a small, reproducible example, customer
> > personal data is contained.
>
> Well, then you're going to have to do your own debugging, because the
> information you've provided so far is just about useless for identifying
> the problem.
>
> One place to start is by collecting a few stack traces while it seems to
> be looping:
>
> https://wiki.postgresql.org/wiki/Generating_a_stack_trace_
> of_a_PostgreSQL_backend
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2017-11-20 09:39:13 | Re: BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker |
Previous Message | Amit Kapila | 2017-11-20 07:56:50 | Re: 10.1: hash index size exploding on vacuum full analyze |