============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name :Robert E. Bruccoleri
Your email address :[EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) :Silicon Graphics Origin 2000
Operating System (example: Linux 2.0.26 ELF) :Irix 6.5.4f
PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3
Compiler used (example: gcc 2.8.0) :cc -32
Please enter a FULL description of your problem:
------------------------------------------------
While creating an index, the backend crashes. The stack dump taken
from the core image is
(dbx) where
0 _kill(0x73151, 0x6, 0x0, 0x0) ["kill.s":15, 0xfa408bc]
1 _raise(0x73151, 0x6, 0x0, 0x0) ["raise.c":27, 0xfacaa98]
2 abort(0x73151, 0x6, 0x0, 0x0) ["abort.c":52, 0xfa5e6a8]
3 ExcAbort(excP = 0x10065670, detail = 0, data = (nil), message = 0x10058598 =
"!(RelationNameCache->hctl->nkeys == 10)")
["/pg/postgresql-6.5.3/src/backend/utils/error/excabort.c":26, 0x5bad3c]
4 ExcUnCaught(excP = 0x10065670, detail = 0, data = (nil), message = 0x10058598 =
"!(RelationNameCache->hctl->nkeys == 10)")
["/pg/postgresql-6.5.3/src/backend/utils/error/exc.c":169, 0x5babe0]
5 ExcRaise(excP = 0x10065670, detail = 0, data = (nil), message = 0x10058598 =
"!(RelationNameCache->hctl->nkeys == 10)")
["/pg/postgresql-6.5.3/src/backend/utils/error/exc.c":186, 0x5bac8c]
6 ExceptionalCondition(conditionName = 0x10058598 =
"!(RelationNameCache->hctl->nkeys == 10)", exceptionP = 0x10065670, detail = (nil),
fileName = 0x100585c0 = "relcache.c", lineNumber = 1440)
["/pg/postgresql-6.5.3/src/backend/utils/error/assert.c":72, 0x5ba034]
7 RelationCacheInvalidate(onlyFlushReferenceCountZero = '')
["/pg/postgresql-6.5.3/src/backend/utils/cache/relcache.c":1440, 0x5b4f98]
> 8 ResetSystemCaches() ["/pg/postgresql-6.5.3/src/backend/utils/cache/inval.c":337,
>0x5b155c]
9 SIReadEntryData(segP = 0x81a8000, backendId = 1, invalFunction = 0x5b13a8,
resetFunction = 0x5b152c)
["/pg/postgresql-6.5.3/src/backend/storage/ipc/sinvaladt.c":665, 0x54ea24]
More (n if no)?
10 InvalidateSharedInvalid(invalFunction = 0x5b13a8, resetFunction = 0x5b152c)
["/pg/postgresql-6.5.3/src/backend/storage/ipc/sinval.c":165, 0x54d784]
11 DiscardInvalid() ["/pg/postgresql-6.5.3/src/backend/utils/cache/inval.c":518,
0x5b19a4]
12 AtStart_Cache() ["/pg/postgresql-6.5.3/src/backend/access/transam/xact.c":548,
0x46dd7c]
13 CommandCounterIncrement()
["/pg/postgresql-6.5.3/src/backend/access/transam/xact.c":514, 0x46dcd8]
14 UpdateStats(relid = 6207936, reltuples = 13885747, hasindex = '\001')
["/pg/postgresql-6.5.3/src/backend/catalog/index.c":1253, 0x47a994]
15 btbuild(heap = 0x1015efd8, index = 0x10175238, natts = 1, attnum = 0x101615d0,
istrat = 0x10175e68, pcount = 0, params = (nil), finfo = (nil), predInfo = 0x10161c88)
["/pg/postgresql-6.5.3/src/backend/access/nbtree/nbtree.c":316, 0x45c674]
16 fmgr_c(finfo = 0x7ffedfa8, values = 0x7ffedfb8, isNull = 0x7ffedfa7 = "")
["/pg/postgresql-6.5.3/src/backend/utils/fmgr/fmgr.c":175, 0x5bbd90]
17 fmgr(procedureId = 338, ... = 0x1015efd8)
["/pg/postgresql-6.5.3/src/backend/utils/fmgr/fmgr.c":336, 0x5bc24c]
18 index_build(heapRelation = 0x1015efd8, indexRelation = 0x10175238,
numberOfAttributes = 1, attributeNumber = 0x101615d0, parameterCount = 0, parameter =
(nil), funcInfo = (nil), predInfo = 0x10161c88)
["/pg/postgresql-6.5.3/src/backend/catalog/index.c":1647, 0x47b4a4]
19 index_create(heapRelationName = 0x10161340 = "comparisons_4", indexRelationName
= 0x10161318 = "comparisons_4_expected", funcInfo = (nil), attributeList =
More (n if no)?
0x101613c8, accessMethodObjectId = 403, numatts = 1, attNums = 0x101615d0,
classObjectId = 0x10161630, parameterCount = 0, parameter = (nil), predicate = (nil),
islossy = '', unique = '', primary = '')
["/pg/postgresql-6.5.3/src/backend/catalog/index.c":1091, 0x47a444]
20 DefineIndex(heapRelationName = 0x10161340 = "comparisons_4", indexRelationName =
0x10161318 = "comparisons_4_expected", accessMethodName = 0x10161358 = "btree",
attributeList = 0x101613c8, parameterList = (nil), unique = '', primary = '',
predicate = (nil), rangetable = (nil))
["/pg/postgresql-6.5.3/src/backend/commands/indexcmds.c":191, 0x48b134]
21 ProcessUtility(parsetree = 0x101613e0, dest = Remote=3)
["/pg/postgresql-6.5.3/src/backend/tcop/utility.c":400, 0x563160]
22 pg_exec_query_dest(query_string = 0x7ffee324 = "CREATE INDEX
comparisons_4_expected on comparisons_4 using btree ( expected float8_ops ) ;", dest =
Remote=3, aclOverride = '') ["/pg/postgresql-6.5.3/src/backend/tcop/postgres.c":727,
0x55fcd4]
23 pg_exec_query(query_string = 0x7ffee324 = "CREATE INDEX comparisons_4_expected
on comparisons_4 using btree ( expected float8_ops ) ;")
["/pg/postgresql-6.5.3/src/backend/tcop/postgres.c":656, 0x55faf4]
24 PostgresMain(argc = 9, argv = 0x7fff28b0, real_argc = 7, real_argv = 0x7fff2f04)
["/pg/postgresql-6.5.3/src/backend/tcop/postgres.c":1647, 0x5616d0]
25 DoBackend(port = 0x10119900)
["/pg/postgresql-6.5.3/src/backend/postmaster/postmaster.c":1628, 0x529f90]
26 BackendStartup(port = 0x10119900)
["/pg/postgresql-6.5.3/src/backend/postmaster/postmaster.c":1373, 0x529704]
More (n if no)?
27 ServerLoop() ["/pg/postgresql-6.5.3/src/backend/postmaster/postmaster.c":823,
0x528360]
28 PostmasterMain(argc = 7, argv = 0x7fff2f04)
["/pg/postgresql-6.5.3/src/backend/postmaster/postmaster.c":616, 0x527a94]
29 main(argc = 7, argv = 0x7fff2f04)
["/pg/postgresql-6.5.3/src/backend/main/main.c":101, 0x4cc2a4]
30 __istart() ["crt1tinit.s":13, 0x421000]
The failed assertion in
RelationCacheInvalidate(onlyFlushReferenceCountZero = '')
["/pg/postgresql-6.5.3/src/backend/utils/cache/relcache.c":1440, 0x5b4f98]
is
RelationCacheInvalidate:1440 Assert(RelationNameCache->hctl->nkeys == 10);
The value of RelationNameCache->hctl is
(dbx) p *RelationNameCache->hctl
struct hashhdr {
dsize = 256
ssize = 256
sshift = 8
max_bucket = 511
high_mask = 1023
low_mask = 511
ffactor = 1
nkeys = 9
nsegs = 2
keysize = 32
datasize = 4
max_dsize = -1
freeBucketIndex = 269626408
}
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Simultaneous index creation on one database coupled with copy's to
another database can cause it sporadically.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
+----------------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383 |
| President, Congenomics, Inc. | Fax: 609 737 7528 |
| 114 W Franklin Ave, Suite K1,4,5 | email: [EMAIL PROTECTED] |
| P.O. Box 314 | URL: http://www.congen.com/~bruc |
| Pennington, NJ 08534 | |
+----------------------------------+------------------------------------+
