error 38300 loading messages
After an OS reinstall on Solaris 9 (IDS 9.40), logical log backups failed with only "Error 38300 loading messages" shown. Replies pointed out that message 38300 lives in archive.iem and that the wording suggests the tool couldn't load its message file at all. The poster checked and found archive.iem (plus six other files) missing from $INFORMIXDIR/msg/en_us/0333. Restoring the file from another installation of the same version made log backups work again.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi folks, hoping someone can help me out on this. Platform Solaris 9 Sparc, IDS 9.40 UC6 (old, I know) Can't backup logical logs, all I see is the error message in the subject. Any idea how to debug (or better solve this) ? Situation : due to a faulty remove, the OS had to be reinstalled completely. All of informix was on a separate disk on the SAN, after some configuration (/etc/profile, /etc/system, /etc/services, ..) DB was up again and is running but the logical logs are filling up and the backup is failing. Already searched for the error-message but no meaningfull results; Any feedback will be appreciated. Thanks. Best regards, Jacques Lapeire
hello what is the error message ?
Hi, the error message is what's in the subject : "Error 38300 loading messages", that's all Jacques -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Monday, December 13, 2010 9:17 PM To: ids@iiug.org Subject: Re: error 38300 loading messages [22203] hello what is the error message ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi I am guessing here. Maybe cant find file. on our system we have file -rwxr-xr-x 1 root sys 5038 May 20 2010 Messagefiles -rw-r--r-- 1 root sys 5050 May 20 2010 Messagefiles.installed in dir /opt/informix/etc
On Mon, Dec 13, 2010 at 12:24, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > I am guessing here. Maybe cant find file. on our system we have file > -rwxr-xr-x 1 root sys 5038 May 20 2010 Messagefiles > -rw-r--r-- 1 root sys 5050 May 20 2010 Messagefiles.installed > in dir > /opt/informix/etc > Message 38300 should be in archive.iem: # Error file: archive.iem .38300 Archive API error: already open There are two possibilities - an archive is already in progress, or (more likely) the program is preloading messages and because it fails to find the first message, reports that as the problem. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> 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." --001636c5c2411cb035049751d368
Thanks Jonathan, it seems you're in the right direction. Apparently the file archive.iem (and 6 other files too) is missing on the system. I'm just installing the same version on an other system to capture the missing files. Best regards, Jacques -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Leffler Sent: Monday, December 13, 2010 11:00 PM To: ids@iiug.org Subject: Re: error 38300 loading messages [22213] On Mon, Dec 13, 2010 at 12:24, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > I am guessing here. Maybe cant find file. on our system we have file > -rwxr-xr-x 1 root sys 5038 May 20 2010 Messagefiles > -rw-r--r-- 1 root sys 5050 May 20 2010 Messagefiles.installed > in dir > /opt/informix/etc > Message 38300 should be in archive.iem: # Error file: archive.iem ..38300 Archive API error: already open There are two possibilities - an archive is already in progress, or (more likely) the program is preloading messages and because it fails to find the first message, reports that as the problem. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> 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." --001636c5c2411cb035049751d368 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Ok guys thanks for any reply, indeed that was the problem, the file $INFORMIXDIR/msg/en_us/0333/archive.iem was missing. After a restore of the file, backups are running again. Best regards, Jacques -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Leffler Sent: Monday, December 13, 2010 11:00 PM To: ids@iiug.org Subject: Re: error 38300 loading messages [22213] On Mon, Dec 13, 2010 at 12:24, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > I am guessing here. Maybe cant find file. on our system we have file > -rwxr-xr-x 1 root sys 5038 May 20 2010 Messagefiles > -rw-r--r-- 1 root sys 5050 May 20 2010 Messagefiles.installed > in dir > /opt/informix/etc > Message 38300 should be in archive.iem: # Error file: archive.iem ..38300 Archive API error: already open There are two possibilities - an archive is already in progress, or (more likely) the program is preloading messages and because it fails to find the first message, reports that as the problem. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> 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." --001636c5c2411cb035049751d368 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.