pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRelation 0 does not exist
3+ messages / 2 participants
[nested] [flat]
* Relation 0 does not exist
@ 2006-02-25 07:06 Yasuhiro Furuse <yfuruse@kobeoffshore.com>
0 siblings, 1 reply; 3+ messages in thread
From: Yasuhiro Furuse @ 2006-02-25 07:06 UTC (permalink / raw)
To: pgsql-sql
Hi.
When I run SQL command, I've got the error messe 'Relation 0 doesn't exist'
and following log messages were generated.
After this error happens, I can not access database at all.
Could you kindly advise why this kind of error happens?
Regards,
y.furuse
----------------------------------------------------------------------------
---------------------------------------------------------------
[Version]
PosrgreSQL7.2.4
[SQL command]
INSERT INTO SDBA2 SELECT * FROM VHIST2 ;
[TABLE Layout]
CREATE TABLE SDBA2(
Client TEXT,
RESVNO TEXT,
DEPT TEXT,
CUSTID TEXT,
DT DATE,
TM INT,
DTM TEXT,
RESVTM TIMESTAMP,
CPLTTM TIMESTAMP,
WTM INTERVAL,
STM INTERVAL,
OBJ TEXT,
METHOD TEXT,
COMTM TEXT,
DIAG TEXT,
TREAT TEXT,
NEXT TEXT,
AG TEXT,
AGDAYS INT,
AGDT DATE,
FU TEXT,
FUDAYS INT,
FUDT DATE,
PS TEXT,
PSDAYS INT,
PSDT DATE,
STS TEXT,
COMMNT TEXT,
AGE INT,
SEX TEXT,
OCCUP TEXT,
ITYP TEXT,
ATT1 TEXT,
PRIMARY KEY(CLIENT,RESVNO)
);
[LOG message]
Feb 25 02:30:01 postgres[736]: [1] DEBUG: server process (pid 32278) was
terminated by signal 11
Feb 25 02:30:01 postgres[736]: [2] DEBUG: terminating any other active
server processes
Feb 25 02:30:01 postgres[736]: [3] DEBUG: all server processes terminated;
reinitializing shared memory and semaphores
Feb 25 02:30:01 postgres[32289]: [4] DEBUG: database system was
interrupted at 2006-02-25 01:52:52 JST
Feb 25 02:30:01 postgres[32289]: [5] DEBUG: checkpoint record is at
1/1DE7CE8C
Feb 25 02:30:01 postgres[32289]: [6] DEBUG: redo record is at 1/1DE7CE8C;
undo record is at 0/0; shutdown FALSE
Feb 25 02:30:01 postgres[32289]: [7] DEBUG: next transaction id: 6670787;
next oid: 117726
Feb 25 02:30:01 postgres[32289]: [8] DEBUG: database system was not
properly shut down; automatic recovery in progress
Feb 25 02:30:01 postgres[32289]: [9] DEBUG: ReadRecord: record with zero
length at 1/1DE7CECC
Feb 25 02:30:01 postgres[32289]: [10] DEBUG: redo is not required
Feb 25 02:30:11 postgres[32289]: [11] DEBUG: database system is ready
Feb 25 03:00:00 postgres[1006]: [4] ERROR: cannot open segment 1 of
relation pg_statistic_relid_att_index (target block 858666545): No such file
or directory
Feb 25 03:30:00 postgres[2452]: [4] ERROR: cannot open segment 1 of
relation pg_statistic_relid_att_index (target block 858666545): No such file
or directory
Feb 25 04:00:00 postgres[3896]: [4] ERROR: cannot open segment 1 of
relation pg_statistic_relid_att_index (target block 858666545): No such file
or directory
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Relation 0 does not exist
@ 2006-02-25 15:24 Alvaro Herrera <alvherre@commandprompt.com>
parent: Yasuhiro Furuse <yfuruse@kobeoffshore.com>
0 siblings, 1 reply; 3+ messages in thread
From: Alvaro Herrera @ 2006-02-25 15:24 UTC (permalink / raw)
To: Yasuhiro Furuse <yfuruse@kobeoffshore.com>; +Cc: pgsql-sql
Yasuhiro Furuse wrote:
> When I run SQL command, I've got the error messe 'Relation 0 doesn't exist'
> and following log messages were generated.
> After this error happens, I can not access database at all.
>
> Could you kindly advise why this kind of error happens?
>
> Regards,
> y.furuse
>
> ----------------------------------------------------------------------------
> ---------------------------------------------------------------
> [Version]
> PosrgreSQL7.2.4
Hmm. Who knows which one of the data-corrupting unfixed known bugs in
this ancient version caused this particular problem. I doubt you will
find much people trying to figure it out; instead, you should be looking
into doing an upgrade rather soonish.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Relation 0 does not exist
@ 2006-02-26 23:26 Yasuhiro Furuse <yfuruse@kobeoffshore.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: Yasuhiro Furuse @ 2006-02-26 23:26 UTC (permalink / raw)
To: 'Alvaro Herrera' <alvherre@commandprompt.com>; +Cc: pgsql-sql
Alvaro
Thak you for your quick reply.
> Hmm. Who knows which one of the data-corrupting unfixed
> known bugs in this ancient version caused this particular
Is this the 'unfixed know bugs' of 7.2.X ? It means the solution
is only upgrading PotgreSQL to 7.3.X ot 7.4.X ?
One more information. I have rebooted the system after this trouble
happens,
I was able to access database normally and error log messsage never
generated.
But I have not tried to run SQL command 'INSERT INTO SDBA2 SELECT * FROM
VHIST2';
since this is the production environment our clients are using now...
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Alvaro Herrera
> Sent: Sunday, February 26, 2006 12:24 AM
> To: Yasuhiro Furuse
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Relation 0 does not exist
>
> Yasuhiro Furuse wrote:
>
> > When I run SQL command, I've got the error messe 'Relation
> 0 doesn't exist'
> > and following log messages were generated.
> > After this error happens, I can not access database at all.
> >
> > Could you kindly advise why this kind of error happens?
> >
> > Regards,
> > y.furuse
> >
> >
> ----------------------------------------------------------------------
> > ------
> > ---------------------------------------------------------------
> > [Version]
> > PosrgreSQL7.2.4
>
> Hmm. Who knows which one of the data-corrupting unfixed
> known bugs in this ancient version caused this particular
> problem. I doubt you will find much people trying to figure
> it out; instead, you should be looking into doing an upgrade
> rather soonish.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-26 23:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-25 07:06 Relation 0 does not exist Yasuhiro Furuse <yfuruse@kobeoffshore.com>
2006-02-25 15:24 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-02-26 23:26 ` Yasuhiro Furuse <yfuruse@kobeoffshore.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox