Postgresql error: could not open segment 1 of relation base/20983/2416
Posted
by
kokonut
on Stack Overflow
See other posts from Stack Overflow
or by kokonut
Published on 2011-01-09T15:35:57Z
Indexed on
2011/01/09
15:53 UTC
Read the original article
Hit count: 196
postgresql
|postgis
I'm running a Postgresql query and getting the following error:
ActiveRecord::StatementInvalid (PGError: ERROR: could not open segment 1 of relation base/20983/24161 (target block 5046584): No such file or directory
The query is of the format 'SELECT "locations".* FROM "locations" WHERE ("locations"."id" IN (115990, 78330, 77891, 78248, ...)' with about 600 ids in the IN clause - not an optimal query I know but it's what I have to work with for the moment!
The server is running PostgreSQL 8.4.6 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.1-4ubuntu9) 4.4.1, 64-bit. Postgis 1.5 is also installed, and the locations table contains a geometry column.
Anyone have any idea what could be causing the error? Thanks!
© Stack Overflow or respective owner