On Saturday 05 March 2011 18:37:30 Andres Freund wrote:
> On Saturday 05 March 2011 17:46:13 Tom Lane wrote:
> > Andres Freund <and...@anarazel.de> writes:
> I am currently looking at the other one. Its quite strange:
The backtrace during the operations described earlier:
0 index_getprocinfo (irel=0x7f5426cbc820, attnum=1, procnum=1) at indexam.c:875
#1 0x000000000048ab14 in _bt_mkscankey_nodata (rel=0x7f5426cbc820) at
nbtutils.c:123
#2 0x00000000007eb628 in tuplesort_begin_index_btree (indexRel=0x7f5426cbc820,
enforceUnique=0 '\000', workMem=1048576,
randomAccess=0 '\000') at tuplesort.c:753
#3 0x000000000048c94c in _bt_spoolinit (index=0x7f5426cbc820, isunique=0
'\000', isdead=0 '\000') at nbtsort.c:165
#4 0x0000000000487074 in btbuild (fcinfo=0x7fff68ab2220) at nbtree.c:116
#5 0x00000000007ca99a in OidFunctionCall3 (functionId=338,
arg1=139999404896344, arg2=139999404869664, arg3=30080592) at fmgr.c:1711
#6 0x00000000004d598d in index_build (heapRelation=0x7f5426cc3058,
indexRelation=0x7f5426cbc820, indexInfo=0x1cafe50, isprimary=0 '\000')
at index.c:1729
#7 0x00000000004d4c5c in index_create (heapRelation=0x7f5426cc3058,
indexRelationName=0x1d41c90 "foo_abc", indexRelationId=626424,
indexInfo=0x1cafe50, indexColNames=0x1cb0318, accessMethodObjectId=403,
tableSpaceId=0, collationObjectId=0x1cb03b8,
classObjectId=0x1cb03d8, coloptions=0x1cb03f8, reloptions=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') at index.c:1063
#8 0x000000000057397f in DefineIndex (heapRelation=0x1d41ca8,
indexRelationName=0x1d41c90 "foo_abc", indexRelationId=0,
accessMethodName=0x1d41d10 "btree", tableSpaceName=0x0,
attributeList=0x1d41d28, predicate=0x0, options=0x0, exclusionOpNames=0x0,
unique=0 '\000', primary=0 '\000', isconstraint=0 '\000', deferrable=0
'\000', initdeferred=0 '\000', is_alter_table=0 '\000',
check_rights=1 '\001', skip_build=0 '\000', quiet=0 '\000', concurrent=0
'\000') at indexcmds.c:395
#9 0x00000000006d3d74 in standard_ProcessUtility (parsetree=0x1d30ff0,
queryString=0x1d303c0 "CREATE INDEX foo_abc ON foo (a, b,c);",
params=0x0, isTopLevel=1 '\001', dest=0x1d31390,
completionTag=0x7fff68ab2dc0 "") at utility.c:954
#10 0x00000000006d2db3 in ProcessUtility (parsetree=0x1d30ff0,
queryString=0x1d303c0 "CREATE INDEX foo_abc ON foo (a, b,c);", params=0x0,
isTopLevel=1 '\001', dest=0x1d31390, completionTag=0x7fff68ab2dc0 "") at
utility.c:334
#11 0x00000000006d1e82 in PortalRunUtility (portal=0x1cade40,
utilityStmt=0x1d30ff0, isTopLevel=1 '\001', dest=0x1d31390,
completionTag=0x7fff68ab2dc0 "") at pquery.c:1184
#12 0x00000000006d2029 in PortalRunMulti (portal=0x1cade40, isTopLevel=1
'\001', dest=0x1d31390, altdest=0x1d31390,
completionTag=0x7fff68ab2dc0 "") at pquery.c:1315
#13 0x00000000006d15ff in PortalRun (portal=0x1cade40,
count=9223372036854775807, isTopLevel=1 '\001', dest=0x1d31390,
altdest=0x1d31390,
completionTag=0x7fff68ab2dc0 "") at pquery.c:813
#14 0x00000000006cb935 in exec_simple_query (query_string=0x1d303c0 "CREATE
INDEX foo_abc ON foo (a, b,c);") at postgres.c:1018
#15 0x00000000006cfa47 in PostgresMain (argc=2, argv=0x1c79da8,
username=0x1c79c40 "andres") at postgres.c:3902
#16 0x000000000068444e in BackendRun (port=0x1cb1e20) at postmaster.c:3590
#17 0x0000000000683b1a in BackendStartup (port=0x1cb1e20) at postmaster.c:3275
#18 0x0000000000680e9a in ServerLoop () at postmaster.c:1449
#19 0x0000000000680677 in PostmasterMain (argc=3, argv=0x1c76ef0) at
postmaster.c:1110
#20 0x00000000005fb12d in main (argc=3, argv=0x1c76ef0) at main.c:199
(gdb)
Andres
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
