My bet is that 7.0 no longer has this problem. You may try upgrading to
7.0beta2 when it is released and give it a try. Should be very stable.
> ============================================================================
> 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 | |
> +----------------------------------+------------------------------------+
>
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
