pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to Insert Row
6+ messages / 2 participants
[nested] [flat]
* Unable to Insert Row
@ 2011-05-03 06:53 Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-03 06:53 UTC (permalink / raw)
To: pgsql-admin
Howdy,
Environment:
Postgres 8.3.14
Solaris 10
When attempting to insert a row, the following error is received:
ERROR: could not open relation with OID 926167091
This OID does not exist anywhere in the database. Most inserts on
this table are successful. It is only for 2 particular id's where the
inserts are failing with this error. The id column is indexed. I
have tried vacuum analyzing the database. Still get the error. I
have NOT tried re-indexing yet. Some googling says a restart of
postgres fixes it. I would like to get your thoughts first 'though,
please.
Thank you,
Sam
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fwd: Unable to Insert Row
@ 2011-05-03 09:03 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-03 09:03 UTC (permalink / raw)
To: pgsql-admin
---------- Forwarded message ----------
From: Sam Stearns <samtstearns@gmail.com>
Date: Tue, May 3, 2011 at 6:32 PM
Subject: Re: [ADMIN] Unable to Insert Row
To: Adarsh Sharma <adarsh.sharma@orkash.com>
Thanks, Adarsh.
I don't see any references to a repair command in the 8.3 doco.
On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
> Try again after repairing the tables with the repair command.
>
> Best Regards,
> Adarsh
>
> Sam Stearns wrote:
>>
>> Howdy,
>>
>> Environment:
>>
>> Postgres 8.3.14
>> Solaris 10
>>
>> When attempting to insert a row, the following error is received:
>>
>> ERROR: could not open relation with OID 926167091
>>
>> This OID does not exist anywhere in the database. Most inserts on
>> this table are successful. It is only for 2 particular id's where the
>> inserts are failing with this error. The id column is indexed. I
>> have tried vacuum analyzing the database. Still get the error. I
>> have NOT tried re-indexing yet. Some googling says a restart of
>> postgres fixes it. I would like to get your thoughts first 'though,
>> please.
>>
>> Thank you,
>>
>> Sam
>>
>>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to Insert Row
@ 2011-05-03 22:52 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-03 22:52 UTC (permalink / raw)
To: pgsql-admin
Does anyone else have any ideas on how to solve this problem besides
this mysterious repair command?
On Tue, May 3, 2011 at 6:33 PM, Sam Stearns <samtstearns@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Sam Stearns <samtstearns@gmail.com>
> Date: Tue, May 3, 2011 at 6:32 PM
> Subject: Re: [ADMIN] Unable to Insert Row
> To: Adarsh Sharma <adarsh.sharma@orkash.com>
>
>
> Thanks, Adarsh.
>
> I don't see any references to a repair command in the 8.3 doco.
>
> On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
>> Try again after repairing the tables with the repair command.
>>
>> Best Regards,
>> Adarsh
>>
>> Sam Stearns wrote:
>>>
>>> Howdy,
>>>
>>> Environment:
>>>
>>> Postgres 8.3.14
>>> Solaris 10
>>>
>>> When attempting to insert a row, the following error is received:
>>>
>>> ERROR: could not open relation with OID 926167091
>>>
>>> This OID does not exist anywhere in the database. Most inserts on
>>> this table are successful. It is only for 2 particular id's where the
>>> inserts are failing with this error. The id column is indexed. I
>>> have tried vacuum analyzing the database. Still get the error. I
>>> have NOT tried re-indexing yet. Some googling says a restart of
>>> postgres fixes it. I would like to get your thoughts first 'though,
>>> please.
>>>
>>> Thank you,
>>>
>>> Sam
>>>
>>>
>>
>>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to Insert Row
@ 2011-05-04 22:53 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-04 22:53 UTC (permalink / raw)
To: pgsql-admin
Dump/restore of table resolved this problem.
On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns@gmail.com> wrote:
> Does anyone else have any ideas on how to solve this problem besides
> this mysterious repair command?
>
> On Tue, May 3, 2011 at 6:33 PM, Sam Stearns <samtstearns@gmail.com> wrote:
>> ---------- Forwarded message ----------
>> From: Sam Stearns <samtstearns@gmail.com>
>> Date: Tue, May 3, 2011 at 6:32 PM
>> Subject: Re: [ADMIN] Unable to Insert Row
>> To: Adarsh Sharma <adarsh.sharma@orkash.com>
>>
>>
>> Thanks, Adarsh.
>>
>> I don't see any references to a repair command in the 8.3 doco.
>>
>> On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
>>> Try again after repairing the tables with the repair command.
>>>
>>> Best Regards,
>>> Adarsh
>>>
>>> Sam Stearns wrote:
>>>>
>>>> Howdy,
>>>>
>>>> Environment:
>>>>
>>>> Postgres 8.3.14
>>>> Solaris 10
>>>>
>>>> When attempting to insert a row, the following error is received:
>>>>
>>>> ERROR: could not open relation with OID 926167091
>>>>
>>>> This OID does not exist anywhere in the database. Most inserts on
>>>> this table are successful. It is only for 2 particular id's where the
>>>> inserts are failing with this error. The id column is indexed. I
>>>> have tried vacuum analyzing the database. Still get the error. I
>>>> have NOT tried re-indexing yet. Some googling says a restart of
>>>> postgres fixes it. I would like to get your thoughts first 'though,
>>>> please.
>>>>
>>>> Thank you,
>>>>
>>>> Sam
>>>>
>>>>
>>>
>>>
>>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to Insert Row
@ 2011-05-05 16:32 Ross J. Reedstrom <reedstrm@rice.edu>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ross J. Reedstrom @ 2011-05-05 16:32 UTC (permalink / raw)
To: pgsql-admin
On Thu, May 05, 2011 at 08:23:16AM +0930, Sam Stearns wrote:
> Dump/restore of table resolved this problem.
Yeah, the 'repair' advice was probably bleed over from some other open
source database that suffers from table corruption more regularly.
Any sort of on disk corruption in a postgresql DB leads me to start
looking at my hardware very carefully: seldom is it the software that is
at fault, at least in this case.
Ross
--
Ross Reedstrom, Ph.D. reedstrm@rice.edu
Systems Engineer & Admin, Research Scientist phone: 713-348-6166
Connexions http://cnx.org fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE
>
> On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns@gmail.com> wrote:
> > Does anyone else have any ideas on how to solve this problem besides
> > this mysterious repair command?
> >
> > On Tue, May 3, 2011 at 6:33 PM, Sam Stearns <samtstearns@gmail.com> wrote:
> >> ---------- Forwarded message ----------
> >> From: Sam Stearns <samtstearns@gmail.com>
> >> Date: Tue, May 3, 2011 at 6:32 PM
> >> Subject: Re: [ADMIN] Unable to Insert Row
> >> To: Adarsh Sharma <adarsh.sharma@orkash.com>
> >>
> >>
> >> Thanks, Adarsh.
> >>
> >> I don't see any references to a repair command in the 8.3 doco.
> >>
> >> On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
> >>> Try again after repairing the tables with the repair command.
> >>>
> >>> Best Regards,
> >>> Adarsh
> >>>
> >>> Sam Stearns wrote:
> >>>>
> >>>> Howdy,
> >>>>
> >>>> Environment:
> >>>>
> >>>> Postgres 8.3.14
> >>>> Solaris 10
> >>>>
> >>>> When attempting to insert a row, the following error is received:
> >>>>
> >>>> ERROR: could not open relation with OID 926167091
> >>>>
> >>>> This OID does not exist anywhere in the database. Most inserts on
> >>>> this table are successful. It is only for 2 particular id's where the
> >>>> inserts are failing with this error. The id column is indexed. I
> >>>> have tried vacuum analyzing the database. Still get the error. I
> >>>> have NOT tried re-indexing yet. Some googling says a restart of
> >>>> postgres fixes it. I would like to get your thoughts first 'though,
> >>>> please.
> >>>>
> >>>> Thank you,
> >>>>
> >>>> Sam
> >>>>
> >>>>
> >>>
> >>>
> >>
> >
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to Insert Row
@ 2011-05-05 22:39 Sam Stearns <samtstearns@gmail.com>
parent: Ross J. Reedstrom <reedstrm@rice.edu>
0 siblings, 0 replies; 6+ messages in thread
From: Sam Stearns @ 2011-05-05 22:39 UTC (permalink / raw)
To: Ross J. Reedstrom <reedstrm@rice.edu>; +Cc: pgsql-admin
Noted. Thanks, Ross.
On Fri, May 6, 2011 at 2:02 AM, Ross J. Reedstrom <reedstrm@rice.edu> wrote:
> On Thu, May 05, 2011 at 08:23:16AM +0930, Sam Stearns wrote:
>> Dump/restore of table resolved this problem.
>
> Yeah, the 'repair' advice was probably bleed over from some other open
> source database that suffers from table corruption more regularly.
>
> Any sort of on disk corruption in a postgresql DB leads me to start
> looking at my hardware very carefully: seldom is it the software that is
> at fault, at least in this case.
>
> Ross
> --
> Ross Reedstrom, Ph.D. reedstrm@rice.edu
> Systems Engineer & Admin, Research Scientist phone: 713-348-6166
> Connexions http://cnx.org fax: 713-348-3665
> Rice University MS-375, Houston, TX 77005
> GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE
>
>>
>> On Wed, May 4, 2011 at 8:22 AM, Sam Stearns <samtstearns@gmail.com> wrote:
>> > Does anyone else have any ideas on how to solve this problem besides
>> > this mysterious repair command?
>> >
>> > On Tue, May 3, 2011 at 6:33 PM, Sam Stearns <samtstearns@gmail.com> wrote:
>> >> ---------- Forwarded message ----------
>> >> From: Sam Stearns <samtstearns@gmail.com>
>> >> Date: Tue, May 3, 2011 at 6:32 PM
>> >> Subject: Re: [ADMIN] Unable to Insert Row
>> >> To: Adarsh Sharma <adarsh.sharma@orkash.com>
>> >>
>> >>
>> >> Thanks, Adarsh.
>> >>
>> >> I don't see any references to a repair command in the 8.3 doco.
>> >>
>> >> On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
>> >>> Try again after repairing the tables with the repair command.
>> >>>
>> >>> Best Regards,
>> >>> Adarsh
>> >>>
>> >>> Sam Stearns wrote:
>> >>>>
>> >>>> Howdy,
>> >>>>
>> >>>> Environment:
>> >>>>
>> >>>> Postgres 8.3.14
>> >>>> Solaris 10
>> >>>>
>> >>>> When attempting to insert a row, the following error is received:
>> >>>>
>> >>>> ERROR: could not open relation with OID 926167091
>> >>>>
>> >>>> This OID does not exist anywhere in the database. Most inserts on
>> >>>> this table are successful. It is only for 2 particular id's where the
>> >>>> inserts are failing with this error. The id column is indexed. I
>> >>>> have tried vacuum analyzing the database. Still get the error. I
>> >>>> have NOT tried re-indexing yet. Some googling says a restart of
>> >>>> postgres fixes it. I would like to get your thoughts first 'though,
>> >>>> please.
>> >>>>
>> >>>> Thank you,
>> >>>>
>> >>>> Sam
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2011-05-05 22:39 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-03 06:53 Unable to Insert Row Sam Stearns <samtstearns@gmail.com>
2011-05-03 09:03 ` Sam Stearns <samtstearns@gmail.com>
2011-05-03 22:52 ` Sam Stearns <samtstearns@gmail.com>
2011-05-04 22:53 ` Sam Stearns <samtstearns@gmail.com>
2011-05-05 16:32 ` Ross J. Reedstrom <reedstrm@rice.edu>
2011-05-05 22:39 ` Sam Stearns <samtstearns@gmail.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