IDS Forum

Re: Rollforward of logs failing

Posted By: Art Kagel
Date: Tuesday, 22 January 2013, at 10:08 a.m.

In Response To: RE: Rollforward of logs failing (Schleicher, Keith)

Great news! I suppose I don't have to have to tell you that 9.40 is VERY
out-of-date and out-of-support. You REALLY should plan an upgrade to a
supported release (11.50.xxx or 11.70.xxx). Not only are these versions
supported and provide many new features that can improve performance for
you, but they are faster by a significant margin than v9.40.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Tue, Jan 22, 2013 at 10:00 AM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:

> We do have a backup, but we discovered that there were some mismatch
> errors=
> on the disk array. Once those were fixed the database instance came up wi=
> thout issue.
>
> Keith Schleicher
> IT Database Administrator
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com=A0
>
> For more information, use our DBA Wiki page link below:
>
> http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen=
> t#DatabaseManagement
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> K=
> agel
> Sent: Tuesday, January 22, 2013 9:56 AM
> To: ids@iiug.org
> Subject: Re: Rollforward of logs failing [29356]
>
> This is odd. The errno =3D 28 that is reported below means "no space left
> o=
> n device" on almost all UNIX variants including HPUX. What tha has to do
> wi=
> th the read operation that apparently failed, I don't know.=20
>
> Check that all of the chunk file paths exist, that if they are links the
> ta=
> rget files or devices are there, that the privileges on the target
> files/de=
> vices are correct (0660), and that you can read them (us "dd
> if=3D<chunkpat=
> h> of=3D/dev/null bs=3D2k count=3D1000" to test the files/devices).=20
> If all is correctly mounted but you get errors from dd, then yes your
> disks=
> are possibly hosed. Do you have an archive?=20
>
> Art=20
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/=20
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> an=
> d do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> othe=
> r organization with which I am associated either explicitly, implicitly,
> or=
> by inference. Neither do those opinions reflect those of other individuals=
> affiliated with any entity with which I am affiliated nor those of the ent=
> ities themselves.=20
>
> On Tue, Jan 22, 2013 at 3:23 AM, Schleicher, Keith < Keith.Schleicher@sears
> =
> hc.com> wrote:=20
>
> > We had a power outage that affected one of our Informix instances. We=20
> > tried bringing it up, but the database seems to be stuck in Fast=20
> > Recovery mode and I am getting the following error messages:
> >=20
> > 00:15:46 I/O read chunk 19, pagenum 836337, pagecnt 1 --> errno =3D 28
> > 00:15:46 Assert Warning: pthdrpage:ptalloc:bad bfget
> > 00:15:46 IBM Informix Dynamic Server Version 9.40.HC6X1
> > 00:15:46 Who: Session(19, informix@spkwms01, 0, c844ccb8)
> >=20
> > Thread(78, xchg_1.8, c84271d4, 7)
> >=20
> > File: rspartn.c Line: 5899
> > 00:15:46 Results: Cannot use TBLSpace page for TBLSpace 7341178
> > 00:15:46 Action: Run 'oncheck -pt 7341178'=20
> > 00:15:46 stack trace for pid 8370 written to=20
> > /opt/informix/informixdumps/af.43632bf
> > 00:15:47 See Also: /opt/informix/informixdumps/af.43632bf
> > 00:15:48 pthdrpage:ptalloc:bad bfget
> > 00:15:49 Rollforward of log record failed. iserrno =3D 172
> > 00:15:49 Log Record: log =3D 1265071, pos =3D 0xf0684, type =3D=20
> > OLDRSAM:ADDITEM(28), trans =3D 241
> > 00:15:49 Rollforward of log record failed. iserrno =3D 172
> > 00:15:49 Log Record: log =3D 1265071, pos =3D 0xf0684, type =3D=20
> > OLDRSAM:ADDITEM(28), trans =3D 241
> >=20
> > Is this an issue with the disk, or possibly the database itself is=20
> > corrupted?
> > Is there any way for me to get the instance online quickly so that we=20
> > can take a look at which tables are affected by this? Does it look=20
> > like the data is corrupted and we won't be able to get it back? Any=20
> > insight to this would be helpful.
> >=20
> > Informix version: 9.40.HC6X1
> > OS Version: HP UX-11i
> >=20
> > Keith Schleicher
> > IT Database Administrator
> > Cell: 224-210-8358
> > Blackberry:=20
> > 2242108358@messaging.sprintpcs.com<mailto:=20
> > 2242108358@messaging.sprintpcs.com>
> > Page:=20
> > 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com>
> >=20
> > For more information, use our DBA Wiki page link below:=20
> >=20
> >=20
> >=20
>
> http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen=
> t#DatabaseManagement=20
> > <
> > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana
> > gement
> > >=20
> >=20
> > This message, including any attachments, is the property of Sears=20
> > Holdings Corporation and/or one of its subsidiaries. It is=20
> > confidential and may contain proprietary or legally privileged=20
> > information. If you are not the intended recipient, please delete it=20
> > without reading the contents. Thank you.
> >=20
> >=20
> >=20
> >=20
>
> ***************************************************************************=
> ****=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20
> >=20
> >=20
>
> --f46d0447882db7b3a404d3e1c732=20
>
>
> ***************************************************************************=
> ****
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
> This message, including any attachments, is the property of Sears Holdings
> =
> Corporation and/or one of its subsidiaries. It is confidential and may
> cont=
> ain proprietary or legally privileged information. If you are not the
> inten=
> ded recipient, please delete it without reading the contents. Thank you.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--f46d0447f05e64b6c804d3e1f2a4

Messages In This Thread

• Rollforward of logs failing
  Schleicher, Keith -- Tuesday, 22 January 2013, at 3:23 a.m.
  • Re: Rollforward of logs failing
    Marcus Haarmann -- Tuesday, 22 January 2013, at 3:31 a.m.
    • RE: Rollforward of logs failing
      Schleicher, Keith -- Tuesday, 22 January 2013, at 3:36 a.m.
      • Re: Rollforward of logs failing
        Marcus Haarmann -- Tuesday, 22 January 2013, at 4:11 a.m.
        • RE: Rollforward of logs failing
          Schleicher, Keith -- Tuesday, 22 January 2013, at 7:39 a.m.
  • Re: Rollforward of logs failing
    Art Kagel -- Tuesday, 22 January 2013, at 9:56 a.m.
    • RE: Rollforward of logs failing
      Schleicher, Keith -- Tuesday, 22 January 2013, at 10:00 a.m.
      • Re: Rollforward of logs failing
        Art Kagel -- Tuesday, 22 January 2013, at 10:08 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.