Re: [BUGS] BUG #1009: ERROR: could not open segment 1 of relation...

#1

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:

Quote:

The errors are similar to:
"psql:daily_update.sql:332: ERROR: could not open segment 1 of relation "summ_stubcount" (target block 3538944): No such file or directory"
Note that summ_stubcount is an index.

This appears to indicate corrupted internal pointers within that index.
Have you tried REINDEXing the problem index? Have you checked for
hardware problems?

Quote:

The error usually occurs within running the script the first few times
and the actualy query it blows up on varies.

If you've got a script that can reproduce the problem on another machine,
I'd be interested to look at it. Otherwise I'm inclined to write this
off as flaky hardware.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1009: ERROR: could not open segment 1 of relation...

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1009: ERROR: could not open segment 1 of relation... - 12-17-2003 , 11:47 AM