SEO

#1 (**permalink**) 04-19-2008, 06:30 PM

The automated log backup script log_full.sh is not working for me. The
output from the message log is:

14:06:21 Logical Log 2257 Complete.
14:06:22 Process exited with return code 142: /bin/sh /bin/sh -c
/opt/ids2k/v9r
21uc5/etc/log_full.sh 2 23 "Logical Log 2257 Complete." "Logical Log 2257
Comple
te."

The onbar log has the following messages

2003-08-24 14:16:33 6268 6266 Could not open XBSA library
/usr/lib/ibsad001.so.
2003-08-24 14:16:33 6268 6266 Unable to open file
/opt/ids2k/v9r21uc5/etc/sm_versions
No such file or directory
2003-08-24 14:16:33 6268 6266 /opt/ids2k/v9r21uc5/bin/onbar_d complete,
returning 142 (0x8e)

Error 142 says the following :

-142 ISAM error: overflow of tblspace page.
> An internal error (probably obsolete) occurred. If the error recurs,
please
> note all circumstances and contact Informix Technical Support.
> Please advise if this is alarming or if the exit code indeed pertains to
this
> error message.

My logical backups are not happening ? Any ideas.

#2 (**permalink**) 04-19-2008, 06:30 PM

Jack A wrote:
> The automated log backup script log_full.sh is not working for me. The
> output from the message log is:
>
> 14:06:21 Logical Log 2257 Complete.
> 14:06:22 Process exited with return code 142: /bin/sh /bin/sh -c
> /opt/ids2k/v9r
> 21uc5/etc/log_full.sh 2 23 "Logical Log 2257 Complete." "Logical Log 2257
> Comple
> te."
>
> The onbar log has the following messages
>
> 2003-08-24 14:16:33 6268 6266 Could not open XBSA library
> /usr/lib/ibsad001.so.
> 2003-08-24 14:16:33 6268 6266 Unable to open file
> /opt/ids2k/v9r21uc5/etc/sm_versions
> No such file or directory
> 2003-08-24 14:16:33 6268 6266 /opt/ids2k/v9r21uc5/bin/onbar_d complete,
> returning 142 (0x8e)
>
> Error 142 says the following :
>
> -142 ISAM error: overflow of tblspace page.
> > An internal error (probably obsolete) occurred. If the error recurs,
> please
> > note all circumstances and contact Informix Technical Support.
> > Please advise if this is alarming or if the exit code indeed pertains to
> this
> > error message.
>
> My logical backups are not happening ? Any ideas.
>
>

The 142 error is sent by onbar. You cannot search it with finderr. It's not the same error.
The 142 onbar error means:

#define BAR_FILE_OPEN 0x8e /* (142) open() failed, usually fatal */

(you should be able to find a web page with all onbar errors by googling a bit... I've posted it here sometime ago, but I don't have the bookmark with me)

The onbar error matches perfectly with the information on onbar.log:

> 2003-08-24 14:16:33 6268 6266 Unable to open file
> /opt/ids2k/v9r21uc5/etc/sm_versions

So... You have a bad onbar configuration. Please re-check it. This file should contain some info specific to your storage manager.

Regards.

#3 (**permalink**) 04-19-2008, 06:31 PM

> The 142 onbar error means:
>
> #define BAR_FILE_OPEN 0x8e /* (142) open() failed, usually fatal */
>
> (you should be able to find a web page with all onbar errors by googling a bit... I've posted it here sometime ago, but I don't have the bookmark with me)

Or you can look in chapter 11 of the Backup and Restore Manual and
learn that it is:

"142 ON-Bar was unable to open a file. Verify that the named file
exists and that the permissions are correct. Check the ON-Bar activity
log for an operating-system error message."

From the messages before the error 142 it looks like your
BAR_BSALIB_PATH and/or your $INFORMIXDIR/etc/sm_versions file(s) are
mis-configured. Since both of these files are configured by
information from your storage manager, I'd suggest you call your
storage manager vendor's technical support organization first. Hope
this information helps.

Brice Avila
Minneapolis, Minnesota

#4 (**permalink**) 04-19-2008, 06:31 PM

Brice Avila wrote:
>>The 142 onbar error means:
>>
>>#define BAR_FILE_OPEN 0x8e /* (142) open() failed, usually fatal */
>>
>>(you should be able to find a web page with all onbar errors by googling a bit... I've posted it here sometime ago, but I don't have the bookmark with me)
>
>
> Or you can look in chapter 11 of the Backup and Restore Manual and
> learn that it is:
[...]
> Brice Avila
> Minneapolis, Minnesota

Wow!
7.x guy here

The old backup and restore guide was VERY diferent!

Thank you for pointing this.

Regards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Log Backups - Error 142 problem