error 922 during backup using veritas
Onbar backups to Veritas NetBackup first failed with an XBSA BSACreateObject error after NetBackup was killed, and thereafter every scheduled backup died immediately with "could not fork server connection, SQLCODE -922" (cannot get name of current working directory), although running onbar_d manually worked. Suggestions were to check permissions on $INFORMIXDIR and its parent directories, the Veritas setup, and whether the NetBackup filesystem was full, plus to involve the NetBackup admin. The poster resolved it by adding "cd $INFORMIXDIR/bin" to the backup script before invoking onbar -b -L 0.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi Guys,
I encountered problem during creating a backup using onbar... it is working
fine before but it suddenly stopped
with the error below:
2009-09-11 11:27:03 520418 163852 /opt/informix/infx/bin/onbar_d -b -L 0
2009-09-11 11:27:03 520418 163852 Working with veritas-netbackup as generic
storage manager.
2009-09-11 11:27:04 520418 163852 Begin level 0 backup rootdbs.
2009-09-11 11:27:04 520418 163852 Successfully connected to Storage Manager.
2009-09-11 11:28:24 520418 163852 XBSA Error: (BSACreateObject) A system error
occurred. Aborting XBSA session.
2009-09-11 11:28:25 520418 163852 /opt/informix/infx/bin/onbar_d complete,
returning 3 (0x03)
Finished Fri Sep 11 11:28:26 MDT 2009
exit 3
------
since then, i encountered this error and the backup can't continue.....
2009-09-11 23:05:09 520238 532714 /opt/informix/infx/bin/onbar_d -b -L 0
2009-09-11 23:05:09 520238 532714 Working with veritas-netbackup as generic
storage manager.
2009-09-11 23:05:09 520238 532714 Unable to open connection to database
server: could not fork
server connection, SQLCODE -922.
2009-09-11 23:05:09 520238 532714 /opt/informix/infx/bin/onbar_d complete,
returning 130 (
0x82)
-922 Cannot get name of current working directory.
A problem exists with the current working directory on this system or
on another computer system that your application is using. Possibly
your account does not have read access to the directory, or possibly
the file system that contains it is improperly mounted. Exit your
application, and retry. If the problem persists, see your system
administrator for assistance.
I really appreciate if someone from the group can answer my question asap..
any idea how it happened?
thanks a lot...
On Wed, Sep 16, 2009 at 01:48, JACK PAPA <informix2009@gmail.com> wrote:
> Hi Guys,
>
> I encountered problem during creating a backup using onbar... it is working
> fine before but it suddenly stopped
> with the error below:
>
> 2009-09-11 11:27:03 520418 163852 /opt/informix/infx/bin/onbar_d -b -L 0
> 2009-09-11 11:27:03 520418 163852 Working with veritas-netbackup as generic
> storage manager.
> 2009-09-11 11:27:04 520418 163852 Begin level 0 backup rootdbs.
> 2009-09-11 11:27:04 520418 163852 Successfully connected to Storage
> Manager.
> 2009-09-11 11:28:24 520418 163852 XBSA Error: (BSACreateObject) A system
> error
> occurred. Aborting XBSA session.
> 2009-09-11 11:28:25 520418 163852 /opt/informix/infx/bin/onbar_d complete,
> returning 3 (0x03)
>
> Finished Fri Sep 11 11:28:26 MDT 2009
> exit 3
>
> ------
>
> since then, i encountered this error and the backup can't continue.....
>
> 2009-09-11 23:05:09 520238 532714 /opt/informix/infx/bin/onbar_d -b -L 0
> 2009-09-11 23:05:09 520238 532714 Working with veritas-netbackup as generic
> storage manager.
> 2009-09-11 23:05:09 520238 532714 Unable to open connection to database
> server: could not fork
> server connection, SQLCODE -922.
> 2009-09-11 23:05:09 520238 532714 /opt/informix/infx/bin/onbar_d complete,
> returning 130 (
> 0x82)
>
> -922 Cannot get name of current working directory.
>
> A problem exists with the current working directory on this system or
> on another computer system that your application is using. Possibly
> your account does not have read access to the directory, or possibly
> the file system that contains it is improperly mounted. Exit your
> application, and retry. If the problem persists, see your system
> administrator for assistance.
>
> I really appreciate if someone from the group can answer my question asap..
> any idea how it happened?
>
> thanks a lot...
>
Someone changed the permissions on something critical. You should look hard
at the permissions of $INFORMIXDIR and the directories under it, and the
directories leading to it.
If it isn't there, then look at the permissions related to the Veritas
software.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>;
- "I'm willing to admit that I may not always be right, but I am never
wrong."
--00c09f88cf90afa03c0473cf6e81
Hi, I have checked all the possible directories in $INFORMIXDIR/bin and $INFORMIXDIR/etc and i can't which file causes that error.... Can you be more specific? In veritas, i have verified also and it looks fine. Please let me know some more hint on this... thanks
Ok, This is the complete scenario... Our Netbackup suddenly stopped. 2009-09-11 11:12:44 352660 368876 Process 352660 received signal 15. Process will exit after cl eanup. ................ ................ ................. 2009-09-11 11:24:32 516360 536788 Successfully connected to Storage Manager. 2009-09-11 11:27:01 516360 536788 XBSA Error: (BSACreateObject) A system error occurred. Aborti ng XBSA session. 2009-09-11 11:27:02 516360 536788 /home/informix/bin/onbar_d complete, returning 3 (0x 03) ------------------------------------ Then, we encountered the -922 error since then and backup is failing... "-922 Cannot get name of current working directory." A problem exists with the current working directory on this system or on another computer system that your application is using. Possibly your account does not have read access to the directory, or possibly the file system that contains it is improperly mounted. Exit your application, and retry. If the problem persists, see your system administrator for assistance." i did verify each files, directories but still the same scenario... If i try manually execution of the backup using "onbar_d -b -L 0", i have no problem... please help!!!
If this was working with no problems before and you didn't change anything with Informix, please check with your netbackup administrator... If it was all working before, someone changed something - if not you, then netbackup admin, or maybe system admin? As others have said, the IBM Informix backup and restore manuals are very good. Also have your Netbackup admin open a ticket with Netbackup support, they were very good the last time I worked with them regarding Informix & Netbackup. Norma Jean -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Friday, September 18, 2009 12:55 AM To: ids@iiug.org Subject: Re: error 922 during backup using veritas [17082] Ok, This is the complete scenario... Our Netbackup suddenly stopped. 2009-09-11 11:12:44 352660 368876 Process 352660 received signal 15. Process will exit after cl eanup. ................. ................. .................. 2009-09-11 11:24:32 516360 536788 Successfully connected to Storage Manager. 2009-09-11 11:27:01 516360 536788 XBSA Error: (BSACreateObject) A system error occurred. Aborti ng XBSA session. 2009-09-11 11:27:02 516360 536788 /home/informix/bin/onbar_d complete, returning 3 (0x 03) ------------------------------------ Then, we encountered the -922 error since then and backup is failing... "-922 Cannot get name of current working directory." A problem exists with the current working directory on this system or on another computer system that your application is using. Possibly your account does not have read access to the directory, or possibly the file system that contains it is improperly mounted. Exit your application, and retry. If the problem persists, see your system administrator for assistance." i did verify each files, directories but still the same scenario... If i try manually execution of the backup using "onbar_d -b -L 0", i have no problem... please help!!! ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
I have also heard where the Netbackup server file system fills up and fails a db backup. Bob ----- Original Message ----- From: "Norma Jean Sebastian" <nsebastian@flinnsci.com> To: ids@iiug.org Sent: Friday, September 18, 2009 8:24:55 AM GMT -05:00 US/Canada Eastern Subject: RE: error 922 during backup using veritas [17085] If this was working with no problems before and you didn't change anything with Informix, please check with your netbackup administrator... If it was all working before, someone changed something - if not you, then netbackup admin, or maybe system admin? As others have said, the IBM Informix backup and restore manuals are very good. Also have your Netbackup admin open a ticket with Netbackup support, they were very good the last time I worked with them regarding Informix & Netbackup. Norma Jean -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Friday, September 18, 2009 12:55 AM To: ids@iiug.org Subject: Re: error 922 during backup using veritas [17082] Ok, This is the complete scenario... Our Netbackup suddenly stopped. 2009-09-11 11:12:44 352660 368876 Process 352660 received signal 15. Process will exit after cl eanup. .................. .................. ................... 2009-09-11 11:24:32 516360 536788 Successfully connected to Storage Manager. 2009-09-11 11:27:01 516360 536788 XBSA Error: (BSACreateObject) A system error occurred. Aborti ng XBSA session. 2009-09-11 11:27:02 516360 536788 /home/informix/bin/onbar_d complete, returning 3 (0x 03) ------------------------------------ Then, we encountered the -922 error since then and backup is failing... "-922 Cannot get name of current working directory." A problem exists with the current working directory on this system or on another computer system that your application is using. Possibly your account does not have read access to the directory, or possibly the file system that contains it is improperly mounted. Exit your application, and retry. If the problem persists, see your system administrator for assistance." i did verify each files, directories but still the same scenario... If i try manually execution of the backup using "onbar_d -b -L 0", i have no problem... please help!!! ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Good idea about the FS being full (or perhaps tape issues)... these could be messages that netbackup is giving and lost in translation to Informix... The OP (JACK PAPA) might also want to check with netbackup admin to see about some cross-training. Depending on the netbackup admin, he/she may allow you/Informix DBA to run some netbackup commands at command line or better yet, have a view-only GUI frontend for Netbackup so Informix DBA can review DB backups (not necessarily to change netbackup policies/schedules but just to see job run results and be able to drill down on error messages). I suggest this because the netbackup admin did it for us at my previous job so I know it's possible with netbackup. If your Informix engine is messaging about the problem, the netbackup application is certainly messaging as well.... You need to see both sides of the story (Informix & netbackup) to really figure it out. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of rroussey@comcast.net Sent: Friday, September 18, 2009 9:43 AM To: ids@iiug.org Subject: Re: error 922 during backup using veritas [17089] I have also heard where the Netbackup server file system fills up and fails a db backup. Bob ----- Original Message ----- From: "Norma Jean Sebastian" <nsebastian@flinnsci.com> To: ids@iiug.org Sent: Friday, September 18, 2009 8:24:55 AM GMT -05:00 US/Canada Eastern Subject: RE: error 922 during backup using veritas [17085] If this was working with no problems before and you didn't change anything with Informix, please check with your netbackup administrator... If it was all working before, someone changed something - if not you, then netbackup admin, or maybe system admin? As others have said, the IBM Informix backup and restore manuals are very good. Also have your Netbackup admin open a ticket with Netbackup support, they were very good the last time I worked with them regarding Informix & Netbackup. Norma Jean -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Friday, September 18, 2009 12:55 AM To: ids@iiug.org Subject: Re: error 922 during backup using veritas [17082] Ok, This is the complete scenario... Our Netbackup suddenly stopped. 2009-09-11 11:12:44 352660 368876 Process 352660 received signal 15. Process will exit after cl eanup. ................... ................... .................... 2009-09-11 11:24:32 516360 536788 Successfully connected to Storage Manager. 2009-09-11 11:27:01 516360 536788 XBSA Error: (BSACreateObject) A system error occurred. Aborti ng XBSA session. 2009-09-11 11:27:02 516360 536788 /home/informix/bin/onbar_d complete, returning 3 (0x 03) ------------------------------------ Then, we encountered the -922 error since then and backup is failing... "-922 Cannot get name of current working directory." A problem exists with the current working directory on this system or on another computer system that your application is using. Possibly your account does not have read access to the directory, or possibly the file system that contains it is improperly mounted. Exit your application, and retry. If the problem persists, see your system administrator for assistance." i did verify each files, directories but still the same scenario... If i try manually execution of the backup using "onbar_d -b -L 0", i have no problem... please help!!! ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
after adding the command below prior to "onbar -b -L 0", error -922 did not
show again...
cd $INFORMIXDIR/bin
Thanks a lot for all your help and idea sharing.
Regards,