Обсуждение: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
The following bug has been logged online: Bug reference: 4121 Logged by: Boldinov Email address: bldnv@mail.ru PostgreSQL version: 8.1.5 Operating system: Windows Server 2003 Standart Description: ERROR: could not open relation 1663/16403/469917: Invalid argument Details: 2008-04-21 14:35:41 ERROR: could not open relation 1663/16403/469917: Invalid argument 2008-04-21 14:35:41 STATEMENT: SELECT _Reference130._IDRRef AS f_3, _Reference130._Description AS f_4 FROM _Reference130 WHERE _Reference130._IDRRef = '\\200"\\000\\033x0\\004\\032\\021\\334\\250\\246\\360\\024\\017_'::bytea AND (FALSE = TRUE OR EXISTS( SELECT 0 AS f_2 FROM ( SELECT TRUE AS _f_1 ) _V8TblAli1 INNER JOIN _InfoReg16060 _InfoReg16060_Q_000_T_002 ON _InfoReg16060_Q_000_T_002._Fld16061_TYPE = '\\010'::bytea AND _InfoReg16060_Q_000_T_002._Fld16061_RTRef = '\\000\\000\\000\\236'::bytea AND _InfoReg16060_Q_000_T_002._Fld16061_RRRef = _Reference130._OwnerIDRRef AND _InfoReg16060_Q_000_T_002._Fld16062RRef = '\\205Y\\011U\\377\\362\\015\\220D''_3\\367\\352\\200\\247'::bytea AND _InfoReg16060_Q_000_T_002._Fld16063_TYPE = '\\010'::bytea AND (_InfoReg16060_Q_000_T_002._Fld16063_RTRef || _InfoReg16060_Q_000_T_002._Fld16063_RRRef) IN ('\\000\\000\\0002'::bytea || '\\200"\\000\\033x0\\004\\032\\021\\334\\262\\273<\\265)4'::bytea,'\\000\\00 0\\0002'::bytea || '\\245\\230\\272~\\361\\313\\223fG\\034\\011\\207X\\325q\\016'::bytea,'\\000 \\000\\000\\324'::bytea || '\\257\\332\\000\\004#R\\244\\374\\021\\334\\206\\326\\355\\252j\\360'::byte a) AND _InfoReg16060_Q_000_T_002._Fld16065 = TRUE))
Re: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
От
Zdenek Kotala
Дата:
Try to look into base/16403/ directory and check if file 469917 exists. And run select relname from pg_class where relfilenode=469917 to determine which relation (table) is affected. Zdenek PS: 8.1 version of PostgreSQL is not supported on win. Use 8.3 Boldinov napsal(a): > The following bug has been logged online: > > Bug reference: 4121 > Logged by: Boldinov > Email address: bldnv@mail.ru > PostgreSQL version: 8.1.5 > Operating system: Windows Server 2003 Standart > Description: ERROR: could not open relation 1663/16403/469917: > Invalid argument > Details: > > 2008-04-21 14:35:41 ERROR: could not open relation 1663/16403/469917: > Invalid argument > 2008-04-21 14:35:41 STATEMENT: SELECT > _Reference130._IDRRef AS f_3, > _Reference130._Description AS f_4 > FROM > _Reference130 > WHERE > _Reference130._IDRRef = > '\\200"\\000\\033x0\\004\\032\\021\\334\\250\\246\\360\\024\\017_'::bytea > AND (FALSE = TRUE OR > EXISTS( > SELECT > 0 AS f_2 > FROM > ( > SELECT > TRUE AS _f_1 > ) _V8TblAli1 > INNER JOIN _InfoReg16060 _InfoReg16060_Q_000_T_002 > ON _InfoReg16060_Q_000_T_002._Fld16061_TYPE = '\\010'::bytea AND > _InfoReg16060_Q_000_T_002._Fld16061_RTRef = '\\000\\000\\000\\236'::bytea > AND _InfoReg16060_Q_000_T_002._Fld16061_RRRef = _Reference130._OwnerIDRRef > AND _InfoReg16060_Q_000_T_002._Fld16062RRef = > '\\205Y\\011U\\377\\362\\015\\220D''_3\\367\\352\\200\\247'::bytea AND > _InfoReg16060_Q_000_T_002._Fld16063_TYPE = '\\010'::bytea AND > (_InfoReg16060_Q_000_T_002._Fld16063_RTRef || > _InfoReg16060_Q_000_T_002._Fld16063_RRRef) IN ('\\000\\000\\0002'::bytea || > '\\200"\\000\\033x0\\004\\032\\021\\334\\262\\273<\\265)4'::bytea,'\\000\\00 > 0\\0002'::bytea || > '\\245\\230\\272~\\361\\313\\223fG\\034\\011\\207X\\325q\\016'::bytea,'\\000 > \\000\\000\\324'::bytea || > '\\257\\332\\000\\004#R\\244\\374\\021\\334\\206\\326\\355\\252j\\360'::byte > a) AND _InfoReg16060_Q_000_T_002._Fld16065 = TRUE)) >