Unable to Insert Row
Unable to Insert Row
От:
Sam Stearns <samtstearns@gmail.com>
Дата:
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
Fwd: Unable to Insert Row
От:
Sam Stearns <samtstearns@gmail.com>
Дата:
---------- Forwarded message ---------- From: Sam Stearns Date: Tue, May 3, 2011 at 6:32 PM Subject: Re: [ADMIN] Unable to Insert Row To: Adarsh Sharma 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 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 >> >> > >
Re: Unable to Insert Row
От:
Sam Stearns <samtstearns@gmail.com>
Дата:
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 wrote: > ---------- Forwarded message ---------- > From: Sam Stearns > Date: Tue, May 3, 2011 at 6:32 PM > Subject: Re: [ADMIN] Unable to Insert Row > To: Adarsh Sharma > > > 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 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 >>> >>> >> >> >
Re: Unable to Insert Row
От:
Sam Stearns <samtstearns@gmail.com>
Дата:
Dump/restore of table resolved this problem. On Wed, May 4, 2011 at 8:22 AM, Sam Stearns 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 wrote: >> ---------- Forwarded message ---------- >> From: Sam Stearns >> Date: Tue, May 3, 2011 at 6:32 PM >> Subject: Re: [ADMIN] Unable to Insert Row >> To: Adarsh Sharma >> >> >> 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 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 >>>> >>>> >>> >>> >> >
Re: Unable to Insert Row
От:
"Ross J. Reedstrom" <reedstrm@rice.edu>
Дата:
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 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 wrote: > >> ---------- Forwarded message ---------- > >> From: Sam Stearns > >> Date: Tue, May 3, 2011 at 6:32 PM > >> Subject: Re: [ADMIN] Unable to Insert Row > >> To: Adarsh Sharma > >> > >> > >> 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 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 >
Re: Unable to Insert Row
От:
Sam Stearns <samtstearns@gmail.com>
Дата:
Noted. Thanks, Ross. On Fri, May 6, 2011 at 2:02 AM, Ross J. Reedstrom 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 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 wrote: >> >> ---------- Forwarded message ---------- >> >> From: Sam Stearns >> >> Date: Tue, May 3, 2011 at 6:32 PM >> >> Subject: Re: [ADMIN] Unable to Insert Row >> >> To: Adarsh Sharma >> >> >> >> >> >> 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 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 >