Oncheck -pt

Posted in 2016

Summary

A user on IDS 11.70.FC8 (AIX 6.1) saw a daily assert warning at 07:00 ('pthdrpage:ptalloc:bad partn page', rspartn.c, TBLSpace 3149194) telling him to run oncheck -pt, which then failed with 'ISAM record not found / Error opening TblSpace'. The warning came from a CDRStop thread, from a script that stops replication, runs dbexport and restarts CDR. Art suggested restoring from archive; Fernando advised opening a PMR; Madison Pruet suspected syscdr inconsistency rather than whole-server corruption and asked for the stack trace. The poster later found related replicate errors in the log, recreated those replicates, and the tblspace error disappeared before IBM responded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

Jorge Valenzuela — Thu, 04 Feb 2016 22:34:58 — source: IIUG Forums & Mailing Lists

Hi, I see a warning in log saying Run oncheck -pr 3149194 I rub the command, and get an Isam record not found Error opening TblSpace for reading. How can I resolve this ? Thanks in advance. Enviado desde mi iPhone

↪ replying to Jorge Valenzuela

Art Kagel — Thu, 04 Feb 2016 22:49:44 — source: IIUG Forums & Mailing Lists

Restore the server from a recent archive. Your server is hosed. Or at least whatever table or index that was is hosed. Art On Feb 4, 2016 5:35 PM, "Jorge Valenzuela" <jorgervt@gmail.com> wrote: > Hi, > I see a warning in log saying > Run oncheck -pr 3149194 > > I rub the command, and get > an Isam record not found > Error opening TblSpace for reading. > > How can I resolve this ? > > Thanks in advance. > > Enviado desde mi iPhone > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f642bd84cf6b5052af98c36

↪ replying to Jorge Valenzuela

Fernando Nunes — Thu, 04 Feb 2016 23:02:45 — source: IIUG Forums & Mailing Lists

Too little information....: 1- Version? 2- Show the complete messages in online.log 3- Were you running a defrag on the a partition? Regards On Thu, Feb 4, 2016 at 10:34 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > I see a warning in log saying > Run oncheck -pr 3149194 > > I rub the command, and get > an Isam record not found > Error opening TblSpace for reading. > > How can I resolve this ? > > Thanks in advance. > > Enviado desde mi iPhone > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a113ff318d8d66b052af9baeb

↪ replying to Fernando Nunes

jorge valenzuela — Thu, 04 Feb 2016 23:38:28 — source: IIUG Forums & Mailing Lists

Hi, I Answered after the questions. 1- Version? It{s an IBM Unix Server AIX 6.1. With Informix1170fc8. 2- Show the complete messages in online.log 07:00:00 Assert Warning: pthdrpage:ptalloc:bad partn page 07:00:00 IBM Informix Dynamic Server Version 11.70.FC8GE 07:00:00 Who: Session(46862, informix@PRIMARIO, 0, 700000040602408) Thread(51344, CDRStop, 7000000405d3350, 1) File: rspartn.c Line: 8385 07:00:00 Results: Cannot use TBLSpace page for TBLSpace 3149194 07:00:00 Action: Run 'oncheck -pt 3149194' I see this error everry day at the same hour 7:00:00. At this hour I execute an script than stop a replicación, then executes a dbexport and restart the replicación with cdr start command. I thing the error ocurrs when the cdr stop command is executed. 3- Were you running a defrag on the a partition? No I´m not running any defrag, I only running the script. Thanks in advance. On 4 February 2016 at 15:02, Fernando Nunes <domusonline@gmail.com> wrote: > Too little information....: > 1- Version? > 2- Show the complete messages in online.log > 3- Were you running a defrag on the a partition? > > Regards > > On Thu, Feb 4, 2016 at 10:34 PM, Jorge Valenzuela <jorgervt@gmail.com> > wrote: > > > Hi, > > I see a warning in log saying > > Run oncheck -pr 3149194 > > > > I rub the command, and get > > an Isam record not found > > Error opening TblSpace for reading. > > > > How can I resolve this ? > > > > Thanks in advance. > > > > Enviado desde mi iPhone > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001a113ff318d8d66b052af9baeb > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113a865c8d0364052afa3aa6

↪ replying to jorge valenzuela

Fernando Nunes — Fri, 05 Feb 2016 00:11:32 — source: IIUG Forums & Mailing Lists

You should open a PMR... Just curious, the partnum is always the same? On Thu, Feb 4, 2016 at 11:38 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, I Answered after the questions. > 1- Version? It{s an IBM Unix Server AIX 6.1. With Informix1170fc8. > > 2- Show the complete messages in online.log > > 07:00:00 Assert Warning: pthdrpage:ptalloc:bad partn page > 07:00:00 IBM Informix Dynamic Server Version 11.70.FC8GE > 07:00:00 Who: Session(46862, informix@PRIMARIO, 0, 700000040602408) > > Thread(51344, CDRStop, 7000000405d3350, 1) > > File: rspartn.c Line: 8385 > 07:00:00 Results: Cannot use TBLSpace page for TBLSpace 3149194 > 07:00:00 Action: Run 'oncheck -pt 3149194' > > I see this error everry day at the same hour 7:00:00. At this hour I > execute an script > than stop a replicación, then executes a dbexport and restart the > replicación with cdr start command. > I thing the error ocurrs when the cdr stop command is executed. > > 3- Were you running a defrag on the a partition? > No I´m not running any defrag, I only running the script. > > Thanks in advance. > > On 4 February 2016 at 15:02, Fernando Nunes <domusonline@gmail.com> wrote: > > > Too little information....: > > 1- Version? > > 2- Show the complete messages in online.log > > 3- Were you running a defrag on the a partition? > > > > Regards > > > > On Thu, Feb 4, 2016 at 10:34 PM, Jorge Valenzuela <jorgervt@gmail.com> > > wrote: > > > > > Hi, > > > I see a warning in log saying > > > Run oncheck -pr 3149194 > > > > > > I rub the command, and get > > > an Isam record not found > > > Error opening TblSpace for reading. > > > > > > How can I resolve this ? > > > > > > Thanks in advance. > > > > > > Enviado desde mi iPhone > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --001a113ff318d8d66b052af9baeb > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113a865c8d0364052afa3aa6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e010d9616f024ba052afab053

↪ replying to Fernando Nunes

Jorge Valenzuela — Fri, 05 Feb 2016 00:30:30 — source: IIUG Forums & Mailing Lists

Yes its aleays the same. Enviado desde mi iPhone > El 04/02/2016, a las 4:11 p.m., Fernando Nunes <domusonline@gmail.com> escribió: > > You should open a PMR... Just curious, the partnum is always the same? > > On Thu, Feb 4, 2016 at 11:38 PM, jorge valenzuela <jorgervt@gmail.com> > wrote: > >> Hi, I Answered after the questions. >> 1- Version? It{s an IBM Unix Server AIX 6.1. With Informix1170fc8. >> >> 2- Show the complete messages in online.log >> >> 07:00:00 Assert Warning: pthdrpage:ptalloc:bad partn page >> 07:00:00 IBM Informix Dynamic Server Version 11.70.FC8GE >> 07:00:00 Who: Session(46862, informix@PRIMARIO, 0, 700000040602408) >> >> Thread(51344, CDRStop, 7000000405d3350, 1) >> >> File: rspartn.c Line: 8385 >> 07:00:00 Results: Cannot use TBLSpace page for TBLSpace 3149194 >> 07:00:00 Action: Run 'oncheck -pt 3149194' >> >> I see this error everry day at the same hour 7:00:00. At this hour I >> execute an script >> than stop a replicación, then executes a dbexport and restart the >> replicación with cdr start command. >> I thing the error ocurrs when the cdr stop command is executed. >> >> 3- Were you running a defrag on the a partition? >> No I´m not running any defrag, I only running the script. >> >> Thanks in advance. >> >>> On 4 February 2016 at 15:02, Fernando Nunes <domusonline@gmail.com> wrote: >>> >>> Too little information....: >>> 1- Version? >>> 2- Show the complete messages in online.log >>> 3- Were you running a defrag on the a partition? >>> >>> Regards >>> >>> On Thu, Feb 4, 2016 at 10:34 PM, Jorge Valenzuela <jorgervt@gmail.com> >>> wrote: >>> >>>> Hi, >>>> I see a warning in log saying >>>> Run oncheck -pr 3149194 >>>> >>>> I rub the command, and get >>>> an Isam record not found >>>> Error opening TblSpace for reading. >>>> >>>> How can I resolve this ? >>>> >>>> Thanks in advance. >>>> >>>> Enviado desde mi iPhone > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> >>> --001a113ff318d8d66b052af9baeb > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> --001a113a865c8d0364052afa3aa6 > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --089e010d9616f024ba052afab053 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Jorge Valenzuela

Madison Pruet — Fri, 05 Feb 2016 00:37:11 — source: IIUG Forums & Mailing Lists

I think that I asked to see the stack trace that was generated as described in the assert warning. I no longer have access to code as I am retired, but I do remember quite a bit about the function names and their purpose. I might be able to help a bit, but need to get access to the stack when the assert warning was generated. I'm not sure why it would be occurring during cdr stop because cdr stop is mainly closing stuff and any corruption would have been detected at server startup. By the way, I'm pretty sure that the stack trace would be required by any PMR as well. I'm not sure that your total system is corrupt, but it may be that the syscdr database has some inconsistency. I'll be looking forward for your reply with the stack trace. Madison Pruet Retired and Loving it On Thursday, February 4, 2016 4:35 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: Hi, I see a warning in log saying Run oncheck -pr 3149194 I rub the command, and get an Isam record not found Error opening TblSpace for reading. How can I resolve this ? Thanks in advance. Enviado desde mi iPhone ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Art Kagel

Madison Pruet — Fri, 05 Feb 2016 00:38:30 — source: IIUG Forums & Mailing Lists

Let's wait until we see the stack trace. ;-) Madison Pruet Retired and Loving it On Thursday, February 4, 2016 4:50 PM, Art Kagel <art.kagel@gmail.com> wrote: Restore the server from a recent archive. Your server is hosed. Or at least whatever table or index that was is hosed. Art On Feb 4, 2016 5:35 PM, "Jorge Valenzuela" <jorgervt@gmail.com> wrote: > Hi, > I see a warning in log saying > Run oncheck -pr 3149194 > > I rub the command, and get > an Isam record not found > Error opening TblSpace for reading. > > How can I resolve this ? > > Thanks in advance. > > Enviado desde mi iPhone > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f642bd84cf6b5052af98c36 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jorge Valenzuela

Madison Pruet — Fri, 05 Feb 2016 00:42:11 — source: IIUG Forums & Mailing Lists

Is it possible that you tried to run dbexport/dbimport on the syscdr database? Madison Pruet Retired and Loving it On Thursday, February 4, 2016 6:34 PM, Madison Pruet <madison_pruet@yahoo.com> wrote: I think that I asked to see the stack trace that was generated as described in the assert warning. I no longer have access to code as I am retired, but I do remember quite a bit about the function names and their purpose. I might be able to help a bit, but need to get access to the stack when the assert warning was generated. I'm not sure why it would be occurring during cdr stop because cdr stop is mainly closing stuff and any corruption would have been detected at server startup. By the way, I'm pretty sure that the stack trace would be required by any PMR as well. I'm not sure that your total system is corrupt, but it may be that the syscdr database has some inconsistency. I'll be looking forward for your reply with the stack trace. Madison Pruet Retired and Loving it On Thursday, February 4, 2016 4:35 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: Hi, I see a warning in log saying Run oncheck -pr 3149194 I rub the command, and get an Isam record not found Error opening TblSpace for reading. How can I resolve this ? Thanks in advance. Enviado desde mi iPhone ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jorge Valenzuela

jorge valenzuela — Wed, 10 Feb 2016 18:38:48 — source: IIUG Forums & Mailing Lists

Hi, I see, that in the log file, after this error, was another errors with replicates. I recreate this replicates and the error of the TBLSpace always disappared. Also I had asking for a PRM, but before IBM contacted me, the problem was resolved. Thanks. On 4 February 2016 at 16:30, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Yes its aleays the same. > > Enviado desde mi iPhone > > > El 04/02/2016, a las 4:11 p.m., Fernando Nunes <domusonline@gmail.com> > escribió: > > > > You should open a PMR... Just curious, the partnum is always the same? > > > > On Thu, Feb 4, 2016 at 11:38 PM, jorge valenzuela <jorgervt@gmail.com> > > wrote: > > > >> Hi, I Answered after the questions. > >> 1- Version? It{s an IBM Unix Server AIX 6.1. With Informix1170fc8. > >> > >> 2- Show the complete messages in online.log > >> > >> 07:00:00 Assert Warning: pthdrpage:ptalloc:bad partn page > >> 07:00:00 IBM Informix Dynamic Server Version 11.70.FC8GE > >> 07:00:00 Who: Session(46862, informix@PRIMARIO, 0, 700000040602408) > >> > >> Thread(51344, CDRStop, 7000000405d3350, 1) > >> > >> File: rspartn.c Line: 8385 > >> 07:00:00 Results: Cannot use TBLSpace page for TBLSpace 3149194 > >> 07:00:00 Action: Run 'oncheck -pt 3149194' > >> > >> I see this error everry day at the same hour 7:00:00. At this hour I > >> execute an script > >> than stop a replicación, then executes a dbexport and restart the > >> replicación with cdr start command. > >> I thing the error ocurrs when the cdr stop command is executed. > >> > >> 3- Were you running a defrag on the a partition? > >> No I´m not running any defrag, I only running the script. > >> > >> Thanks in advance. > >> > >>> On 4 February 2016 at 15:02, Fernando Nunes <domusonline@gmail.com> > wrote: > >>> > >>> Too little information....: > >>> 1- Version? > >>> 2- Show the complete messages in online.log > >>> 3- Were you running a defrag on the a partition? > >>> > >>> Regards > >>> > >>> On Thu, Feb 4, 2016 at 10:34 PM, Jorge Valenzuela <jorgervt@gmail.com> > >>> wrote: > >>> > >>>> Hi, > >>>> I see a warning in log saying > >>>> Run oncheck -pr 3149194 > >>>> > >>>> I rub the command, and get > >>>> an Isam record not found > >>>> Error opening TblSpace for reading. > >>>> > >>>> How can I resolve this ? > >>>> > >>>> Thanks in advance. > >>>> > >>>> Enviado desde mi iPhone > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> -- > >>> Fernando Nunes > >>> Portugal > >>> > >>> http://informix-technology.blogspot.com > >>> My email works... but I don't check it frequently... > >>> > >>> --001a113ff318d8d66b052af9baeb > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> --001a113a865c8d0364052afa3aa6 > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --089e010d9616f024ba052afab053 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143ff34e01433052b6ebd0d