Re: Assert Failure with current CVS

FWIW, I can freely reproduce this from a database dump and a short script
which defines indexes and does a vacuum. They total about 600k, if anyone
wants me to send them...

>>>>

<excerpt>At 22:38 20/11/00 -0500, Tom Lane wrote:

>Philip Warner <<pjw(at)rhyme(dot)com(dot)au> writes:

>> TRAP: Failed Assertion("!(((file) > 0 && (file) << (int) SizeVfdCache
&&

>> VfdCache[file].fileName != ((void *)0))):", File: "fd.c", Line: 967)

>> !(((file) > 0 && (file) << (int) SizeVfdCache &&
VfdCache[file].fileName !=

>> ((void *)0))) (0)

>> Server process (pid 7187) exited with status 6 at Tue Nov 21 13:44:27
2000

>

>There should be a core file from this --- backtrace please?

>

#0 0x400da0d1 in __kill () at soinit.c:27

#1 0x400d9eff in raise (sig=6) at ../sysdeps/posix/raise.c:27

#2 0x400db19b in abort () at ../sysdeps/generic/abort.c:83

#3 0x8155068 in ExcAbort () at excabort.c:27

#4 0x8154fc7 in ExcUnCaught (excP=0x81c3d58, detail=0, data=0x0,

message=0x81a3fa0 "!(((file) > 0 && (file) << (int) SizeVfdCache &&
VfdCache[file].fileName != ((void *)0)))") at exc.c:178

#5 0x815501a in ExcRaise (excP=0x81c3d58, detail=0, data=0x0,

message=0x81a3fa0 "!(((file) > 0 && (file) << (int) SizeVfdCache &&
VfdCache[file].fileName != ((void *)0)))") at exc.c:195

#6 0x81540ef in ExceptionalCondition (

conditionName=0x81a3fa0 "!(((file) > 0 && (file) << (int)
SizeVfdCache && VfdCache[file].fileName != ((void *)0)))",

exceptionP=0x81c3d58, detail=0x0, fileName=0x81a3e87 "fd.c",
lineNumber=967) at assert.c:73

#7 0x810afeb in FileSync (file=31) at fd.c:967

#8 0x81136e0 in mdcommit () at md.c:818

#9 0x8114510 in smgrcommit () at smgr.c:519

#10 0x8107fed in BufmgrCommit () at xlog_bufmgr.c:1071

#11 0x808c7f6 in RecordTransactionCommit () at xact.c:688

#12 0x80bd245 in repair_frag (vacrelstats=0x8234d44, onerel=0x8210344,
vacuum_pages=0xbfffeeac, fraged_pages=0xbfffee9c,

nindices=2, Irel=0x8234dbc) at vacuum.c:1790

#13 0x80ba26b in vacuum_rel (relid=1249, analyze=1, is_toastrel=0 '\000')
at vacuum.c:477

#14 0x80b9cf3 in vac_vacuum (VacRelP=0x0, analyze=1 '\001',
anal_cols2=0x0) at vacuum.c:245

#15 0x80b9c6c in vacuum (vacrel=0x0, verbose=0, analyze=1 '\001',
anal_cols=0x0) at vacuum.c:163

#16 0x8117a25 in ProcessUtility (parsetree=0x824529c, dest=Remote) at
utility.c:690

#17 0x8115775 in pg_exec_query_string (query_string=0x8244f50 "vacuum
analyze;", dest=Remote, parse_context=0x81fbe58)

at postgres.c:786

#18 0x8116802 in PostgresMain (argc=4, argv=0xbffff148, real_argc=3,
real_argv=0xbffffa34, username=0x8208f99 "pjw")

at postgres.c:1826

#19 0x80fd6ef in DoBackend (port=0x8208d30) at postmaster.c:2060

#20 0x80fd28a in BackendStartup (port=0x8208d30) at postmaster.c:1837

#21 0x80fc556 in ServerLoop () at postmaster.c:1027

#22 0x80fbf3d in PostmasterMain (argc=3, argv=0xbffffa34) at
postmaster.c:700

#23 0x80dc095 in main (argc=3, argv=0xbffffa34) at main.c:112

FWIW, this is quite reproducible.

</excerpt><<<<<<<<

----------------------------------------------------------------

Philip Warner | __---_____

Albatross Consulting Pty. Ltd. |----/ - \

(A.B.N. 75 008 659 498) | /(@) ______---_

Tel: (+61) 0500 83 82 81 | _________ \

Fax: (+61) 0500 83 82 82 | ___________ |

Http://www.rhyme.com.au | / \|

| --________--

PGP key available upon request, | /

and from pgp5.ai.mit.edu:11371 |/