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.
My logical backups are not happening ? Any ideas.

Jack A wrote:
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:

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

Regards.

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

Jack:

I would like clarify that the return error code "-142" is from
Informix/onbar and nothing to do with Informix Error # that can be found
under finderr utility.

The error code -142 will be returned when $INFORMIXDIR/etc/sm_versions file
is missing while onbar takes backup.
You can use following command to create the sm_versions file and try
starting logical log backup manually and test it.

ln -s $INFORMIXDIR/etc/sm_versions.std $INFORMIXDIR/etc/sm_versions

or

cp -p $INFORMIXDIR/etc/sm_versions.std $INFORMIXDIR/etc/sm_versions
chmod 775 $INFORMIXDIR/etc/sm_versions

onbar -b -l # To backup logical log from command line.

Error code -142 description:

BAR_FILE_OPEN 0x8e (142)

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

If you need full list of onbar error codes with description, please let me
know.

Thank You
Ramesh Vasudevan





"Jack A"
<jacka8 (AT) excite (DOT) co To: informix-list (AT) iiug (DOT) org
m> cc:
Sent by: Subject: Log Backups - Error 142 problem
owner-informix-li
st (AT) iiug (DOT) org


08/24/03 02:20 PM
Please respond to
"Jack A"






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.
My logical backups are not happening ? Any ideas.








sending to informix-list

Jack:

There is one more piece that I missed also - the following link need to be
created in order to correct the -142 error code


ln -s {backupsoftwareinstalldirectory}/bin/infxbsa.so /usr/lib/ibsad001.so

Please check with UNIX Admin or team who manages backup software
(example:veritas, sqlbacktrack ..) and find the directory
where they have installed the software.

This will resolve the issue.

Thank You
Ramesh Vasudevan





"Jack A"
<jacka8 (AT) excite (DOT) co To: informix-list (AT) iiug (DOT) org
m> cc:
Sent by: Subject: Log Backups - Error 142 problem
owner-informix-li
st (AT) iiug (DOT) org


08/24/03 02:20 PM
Please respond to
"Jack A"






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.
My logical backups are not happening ? Any ideas.








sending to informix-list

Thanks. Will let you know how it goes.
<ramesh.vasudevan (AT) verizon (DOT) com> wrote

Brice Avila wrote:

Wow!
7.x guy here
The old backup and restore guide was VERY diferent!

Thank you for pointing this.

Regards.