Re: [Info-Ingres] [openroad-users] Re: Urgent - Help.
Paul White
Hi Komathie,
Your post was rejected because it was too large. Please try to keep them to around 100Kb.
Sid may want to see a full copy of the errlog, I suggest compressing it first before mailing it directly to him.
This is an Ingres issue not related to OpenROAD as far as I can tell. I’ve forwarded your mail to info-ingres (comp.databases.ingres )
I suggest you log a support call directly with Ingres corp to make sure you don’t lose data.
anyway, here is my feedback.
The top part of your errlog.log shows that machine was shutdown suddenly without a formal ingres shutdown.
That has left the iidbdb database inconsistent with an open count discrepancy.
See this line from your errlog.log
komathi-::[II\INGRES\b58 , 00a94c20]: Wed Oct 28 17:37:09 2009 E_US002B Could not open the iidbdb database.
komathi-::[II\INGRES\b58 , 00a94c20]: Wed Oct 28 17:37:09 2009 E_DM0100_DB_INCONSISTENT Database is inconsistent.
I can’t explain these other errors. It looks like you are trying to operate on the installation using a non-ingres account.
The missing charset file is a worry. Are you sure your disks are working?
komathi-::[II\NMSVR\830 , 00000002]: Wed Oct 28 17:50:45 2009 E_GC0155_GCN_SRV_FAILURE Registered server failure: class IUSVR, address II\IUSVR\9f8
komathi-::[II\NMSVR\830 , 00000007]: Wed Oct 28 17:50:47 2009 E_GC003F_PM_NOPERM User does not have the required permission in the config.dat file for the requested operation.
komathi-::[IIGCN , 00000000]: Wed Oct 28 17:54:24 2009 E_GC0105_GCN_CHAR_INIT Error while processing character set attribute file.
007f0100 Wed Oct 28 17:55:00 2009 E_UL0016_CHAR_INIT Error while processing character set attribute file.
open() failed with operating system error 2 (The system cannot find the file specified.)
komathi-::[IIGCN , 00000000]: Wed Oct 28 18:04:35 2009 E_GC0105_GCN_CHAR_INIT Error while processing character set attribute file.
007f0100 Wed Oct 28 18:05:10 2009 E_UL0016_CHAR_INIT Error while processing character set attribute file.
open() failed with operating system error 2 (The system cannot find the file specified.)
You will probably just want to rollforwarddb iidbdb from the last valid checpoint. (You have been backing up regularly and you have you have a recent checkpoint and all the appropriate journals) At this point you should obtain the services of a qualified Ingres DBA or open a support call with Ingres Corp to make sure you don’t lose important data.
kind regards
Paul
From: Komathi
[mailto:koma...@myworkplace.com.au]
Sent: Thursday, 29 October 2009 2:00 PM
To: openroa...@googlegroups.com
Subject: RE: [openroad-users] Re: Urgent - Help.
Hi Sidney, Thanks for the mail – this is my errorlog file line.
komathi-::[II\DASVR\86c , 00000000]: Tue Oct 27 19:30:19 2009 E_GC4802_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'GCD'.
komathi-::[II\DASVR\86c , 00000000]: Tue Oct 27 19:30:19 2009 E_GC4800_STARTUP Data Access Server normal startup.
komathi-::[II\NMSVR\1e0 , 00000005]: Tue Oct 27 19:30:19 2009 E_GC0153_GCN_SRV_STARTUP Server Registration: class RMCMD, address II\RMCMD\8a0
komathi-::[II\NMSVR\884 , 00000000]: Wed Oct 28 09:04:10 2009 E_GC0151_GCN_STARTUP Name Server normal startup.
komathi-::[II\NMSVR\884 , 00000000]: Wed Oct 28 09:04:10 2009 E_GC0159_GCN_BCHK_FAIL Removing server registration: class IUSVR, address