 |
IDS Forum
Re: Informix will not start
Posted By: Art Kagel
Date: Thursday, 22 January 2009, at 3:55 p.m.
In Response To: RE: Informix will not start (Jarrod Teale)
Or at least the link should have 777 permissions set. Root ownership of the
link isn't a problem as IDS does follow the link to the actual chunk
permissions & ownerships if it can, but I suspect that with 755 permissions
on the link and 770 on the underlying chunk IDS will balk. Missed that.
Art
On Thu, Jan 22, 2009 at 3:33 PM, Jarrod Teale <Jarrod.Teale@fonterra.com>wrote:
> I suspect that they shouldn't have the execute bit set.
> Permissions should be 660.
> Also the symbolic link isn't owned by informix, so informix can't follow
> it to write to the device?
>
> I would:
> chmod 777 /opt/informix/dev/dbs0.2
> chmod 660 /dev/vg01/rlvol13
>
> Is the volume group okay? I aren't familiar with HPUX volume groups, but
> on my systems I would make sure that the volume, logical and physical
> volumes are all okay as well.
>
> And try to start again and see if the chuck passes it check.
>
> -----Original Message-----
> From: Richard Clark [mailto:clark@salem.edu]
> Sent: Friday, 23 January 2009 9:20 a.m.
> To: Jarrod Teale
> Subject: Re: Informix will not start [14617]
>
> Jarrod,
>
> They're there:
>
> ls -la /opt/informix/dev/dbs0.2
> lrwxr-xr-x 1 root common 17 Jan 17 12:24
> /opt/informix/dev/dbs0.2@ -> /dev/vg01/rlvol13
>
> ls -la /dev/vg01/rlvol13
> crwxrwx--- 1 informix informix 64 0x01000d Jan 17 14:14
> /dev/vg01/rlvol13*
>
> No SAN involved.
>
> Richard
>
> Jarrod Teale wrote:
> > So are the chunks there? Paths look to be /opt/informix/dev/dbs0.2
> > etc...
> > Are they permissions 660 and owned by informix.informix?
> >
> > If you have a SAN behind this box, are the LUN's active?
> >
> >
> >
> >
> > -----Original Message-----
> > From: Richard Clark [mailto:clark@salem.edu]
> > Sent: Friday, 23 January 2009 8:47 a.m.
> > To: Jarrod Teale
> > Subject: Re: Informix will not start [14617]
> >
> > Jarrod,
> >
> > It looks like every chunk failed sanity check. Here's the last attempt
>
> > to boot the system:
> >
> > 13:19:19 IBM Informix Dynamic Server Started.
> >
> > Thu Jan 22 13:19:20 2009
> >
> > 13:19:20 Event alarms enabled. ALARMPROG =
> > '/opt/informix/etc/no_log.sh'
> > 13:19:20 Booting Language <c> from module <> 13:19:20 Loading Module
>
> > <CNULL> 13:19:20 Booting Language <builtin> from module <> 13:19:20
> > Loading Module <BUILTINNULL>
> > 13:19:26 DR: DRAUTO is 0 (Off)
> > 13:19:27 Dynamically allocated new message shared memory segment
> > (size
> > 2588KB)
> > 13:19:27 IBM Informix Dynamic Server Version 10.00.HC5 Software
> > Serial Number AAA#B000000
> > 13:19:27 Assert Warning: chunk failed sanity check
> >
> > 13:19:27 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:27 Who: Session(1, root@sabers, 0, d390c018)
> > Thread(17, main_loop(), d38e2018, 1)
> > File: rspartn.c Line: 8672
> > 13:19:27 Results: Chunk 3 is being taken OFFLINE.
> > 13:19:27 Action: Restore chunk from archive.
> > 13:19:27 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.3f9b8ae
> > 13:19:27 See Also: /opt/informix/tmp/af.3f9b8ae
> > 13:19:28 chunk failed sanity check
> >
> > 13:19:28 I/O error, Primary Chunk '/opt/informix/dev/dbs0.2' --
> > Offline
> > (sanity)
> > 13:19:28 Assert Warning: chunk failed sanity check
> >
> > 13:19:28 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:28 Who: Session(1, root@sabers, 0, d390c018)
> > Thread(17, main_loop(), d38e2018, 1)
> > File: rspartn.c Line: 8672
> > 13:19:28 Results: Chunk 4 is being taken OFFLINE.
> > 13:19:28 Action: Restore chunk from archive.
> > 13:19:28 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.3f9b8ae
> > 13:19:29 See Also: /opt/informix/tmp/af.3f9b8ae
> > 13:19:30 chunk failed sanity check
> >
> > 13:19:30 I/O error, Primary Chunk '/opt/informix/dev/temp0.1' --
> > Offline (sanity)
> > 13:19:31 Assert Warning: chunk failed sanity check
> >
> > 13:19:31 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:31 Who: Session(1, root@sabers, 0, d390c018)
> > Thread(17, main_loop(), d38e2018, 1)
> > File: rspartn.c Line: 8672
> > 13:19:31 Results: Chunk 5 is being taken OFFLINE.
> > 13:19:31 Action: Restore chunk from archive.
> > 13:19:31 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.3f9b8ae
> > 13:19:31 See Also: /opt/informix/tmp/af.3f9b8ae
> > 13:19:32 chunk failed sanity check
> >
> > 13:19:33 I/O error, Primary Chunk '/opt/informix/dev/temp1.1' --
> > Offline (sanity)
> > 13:19:33 Assert Warning: chunk failed sanity check
> >
> > 13:19:33 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:33 Who: Session(1, root@sabers, 0, d390c018)
> > Thread(17, main_loop(), d38e2018, 1)
> > File: rspartn.c Line: 8672
> > 13:19:33 Results: Chunk 6 is being taken OFFLINE.
> > 13:19:33 Action: Restore chunk from archive.
> > 13:19:33 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.3f9b8ae
> > 13:19:33 See Also: /opt/informix/tmp/af.3f9b8ae
> > 13:19:34 chunk failed sanity check
> >
> > 13:19:35 I/O error, Primary Chunk '/opt/informix/dev/dbs1.1' --
> > Offline
> > (sanity)
> > 13:19:35 Assert Warning: chunk failed sanity check
> >
> > 13:19:35 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:35 Who: Session(1, root@sabers, 0, d390c018)
> > Thread(17, main_loop(), d38e2018, 1)
> > File: rspartn.c Line: 8672
> > 13:19:35 Results: Chunk 7 is being taken OFFLINE.
> > 13:19:35 Action: Restore chunk from archive.
> > 13:19:35 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.3f9b8ae
> > 13:19:35 See Also: /opt/informix/tmp/af.3f9b8ae
> > 13:19:36 chunk failed sanity check
> >
> > 13:19:37 I/O error, Primary Chunk '/opt/informix/dev/dbs1.2' --
> > Offline
> > (sanity)
> > 13:19:37 IBM Informix Dynamic Server Initialized -- Shared Memory
> > Initialized.
> >
> > 13:19:37 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> > listed
> > in DBSPACETEMP: 'temp0'
> > 13:19:37 Warning: Invalid (non-existent/blobspace/disabled) dbspace
> > listed
> > in DBSPACETEMP: 'temp1'
> > 13:19:37 Physical Recovery Started at Page (1:722).
> > 13:19:37 Physical Recovery Complete: 0 Pages Examined, 0 Pages
> > Restored.
> > 13:19:37 Assert Warning: pthdrpage:ptalloc:bad bfget
> > 13:19:37 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:37 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rspartn.c Line: 6725
> > 13:19:37 Results: Cannot use TBLSpace page for TBLSpace 5242881
> > 13:19:37 Action: Run 'oncheck -pt 5242881'
> > 13:19:37 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.40fb8b9
> > 13:19:37 See Also: /opt/informix/tmp/af.40fb8b9
> > 13:19:38 pthdrpage:ptalloc:bad bfget
> > 13:19:38 Assert Failed: Chunk 6 is being taken OFFLINE.
> > 13:19:38 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:38 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rspartn.c Line: 6744
> > 13:19:38 Results: Cannot Open DBspace 5.
> > 13:19:38 Action: Restore chunk from archive.
> > in DBSPACETEMP: 'temp1'
> > 13:19:37 Physical Recovery Started at Page (1:722).
> > 13:19:37 Physical Recovery Complete: 0 Pages Examined, 0 Pages
> > Restored.
> > 13:19:37 Assert Warning: pthdrpage:ptalloc:bad bfget
> > 13:19:37 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:37 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rspartn.c Line: 6725
> > 13:19:37 Results: Cannot use TBLSpace page for TBLSpace 5242881
> > 13:19:37 Action: Run 'oncheck -pt 5242881'
> > 13:19:37 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.40fb8b9
> > 13:19:37 See Also: /opt/informix/tmp/af.40fb8b9
> > 13:19:38 pthdrpage:ptalloc:bad bfget
> > 13:19:38 Assert Failed: Chunk 6 is being taken OFFLINE.
> > 13:19:38 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:38 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rspartn.c Line: 6744
> > 13:19:38 Results: Cannot Open DBspace 5.
> > 13:19:38 Action: Restore chunk from archive.
> > 13:19:38 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.40fb8b9
> > 13:19:38 See Also: /opt/informix/tmp/af.40fb8b9
> > 13:19:45 Chunk 6 is being taken OFFLINE.
> > 13:19:45 Assert Warning: Chunk 6 is being taken OFFLINE.
> > 13:19:45 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:45 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rsmirror.c Line: 1921
> > 13:19:45 Results: DBspace dbs1 is disabled.
> > 13:19:45 Action: Restore DBspace dbs1
> > 13:19:45 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.40fb8b9
> > 13:19:46 See Also: /opt/informix/tmp/af.40fb8b9
> > 13:19:46 Chunk 6 is being taken OFFLINE.
> > 13:19:47 Cannot Open DBspace 5.
> > 13:19:47 Logical Recovery Started.
> > 13:19:47 10 recovery worker threads will be started.
> > 13:19:47 Assert Failed: Dynamic Server must abort
> > 13:19:47 IBM Informix Dynamic Server Version 10.00.HC5
> > 13:19:47 Who: Session(16, root@sabers, 0, d390da80)
> > Thread(39, fast_rec, d38e63f0, 1)
> > File: rslog.c Line: 3654
> > 13:19:47 Results: Dynamic Server must abort
> > 13:19:47 Action: Reinitialize shared memory
> > 13:19:47 stack trace for pid 9345 written to
> > /opt/informix/tmp/af.40fb8b9
> > 13:19:47 See Also: /opt/informix/tmp/af.40fb8b9
> > 13:19:54 rslog.c, line 3654, thread 39, proc id 9345, Dynamic Server
> > must abort.
> > 13:19:54 PANIC: Attempting to bring system down
> > 13:19:54 semctl: errno = 22
> > ......
> >
> >
> > Jarrod Teale wrote:
> >
> >> Can you post the last 20 lines or so of the online log - it should
> >> have something in there about the engine starting / failing.
> >> Jarrod Teale
> >> Fonterra NZ
> >>
> >> -----Original Message-----
> >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>
> >> RICHARD CLARK
> >> Sent: Friday, 23 January 2009 8:19 a.m.
> >> To: ids@iiug.org
> >> Subject: Informix will not start [14616]
> >>
> >> I'm trying to get Informix 10 to start on an HP-UX 11.2 system. The
> >> message I get at boot time is:
> >>
> >> Starting Informix OnLine engine(s)
> >> Output from "/sbin/rc3.d/S97informix start":
> >> ----------------------------
> >> "/sbin/rc3.d/S97informix start" FAILED
> >>
> >> If I run oninit -v everything looks ok (succeeds). But no oninit
> >> process shows up.
> >>
> >> If I try to run sql I get the message:
> >>
> >> The appl process cannot connect to the database server sabers.
> >> See error number -25588.
> >> Database cars not found or not correct format
> >>
> >> onconf:
> >> DBSERVERNAME sabers
> >>
> >> sqlhosts:
> >> sabers onipcshm 10.81.101.1 sabers
> >> carsi_tcp onsoctcp 10.81.101.1 istarcarsi
> >>
> >> The command dbspace brings up nothing.
> >>
> >> Richard Clark
> >>
> >> *********************************************************************
> >> *
> >> **
> >> *******
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >>
> >>
> > **********************************************************************
> > **
> > *******
> >
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> >>
> >>
> >
> > --
> > Richard Clark
> > CX Administrator
> > Salem Academy & College
> >
> >
> >
> > DISCLAIMER:
> > This email contains confidential information and may be legally
> privileged. If you are not the intended recipient or have received this
> email in error, please notify the sender immediately and destroy this
> email.
> > You may not use, disclose or copy this email or its attachments in any
> way.
> > Any opinions expressed in this email are those of the author and are
> not necessarily those of the Fonterra Co-operative Group.
> > http://www.fonterra.com/
> >
> >
>
> --
> Richard Clark
> CX Administrator
> Salem Academy & College
>
> DISCLAIMER:
> This email contains confidential information and may be legally privileged.
> If
> you are not the intended recipient or have received this email in error,
> please notify the sender immediately and destroy this email.
> You may not use, disclose or copy this email or its attachments in any way.
> Any opinions expressed in this email are those of the author and are not
> necessarily those of the Fonterra Co-operative Group.
> http://www.fonterra.com/
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
--001636c5aa41a019ee0461186a98
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
