Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / February 2007

Tip: Looking for answers? Try searching our database.

Server is not starting.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mr.rude@gmx.net - 22 Feb 2007 12:28 GMT
Hello,

I've some problems here starting a Ingres Database. The Problem is,
that the system is not coming up after the invocation of the ingstart
command.

The last part of the errlog.log file is:

[IIGCN, 00000000]: Thu Feb 22 08:58:18 2007 E_GC0151_GCN_STARTUP    Name
Server normal startup.
                            00000001   Thu Feb 22 08:58:19 2007
E_CLFE05_BS_CONNECT_ERR    Unable to make outgoing connection.
System communication error: Connection refused.
                            00000001   Thu Feb 22 08:58:19 2007
E_SC0124_SERVER_INITIATE    Error initiating Server.
                            00000001   Thu Feb 22 08:58:19 2007
E_SC0235_AVERAGE_ROWS    On 0. select/retrieve statements, the average
row count returned was 0.

Ther is obviously something going wrong during the startup with some
outgoing connection. Does anyone of you know how to get some more
information about what is going wrong and how the server does not
start up?

Thanks in Advance!

hmeier
Jean-Pierre Zuate - 22 Feb 2007 13:05 GMT
Hello,

What is your version ? OS ?

Try this :
- ingstop
- check if II_GCNxx_PORT is empty (xx is II_INSTALLATION)
- kill ingres all processes you can find
- if your are dealing with unix, run many times
ipcclean
and/or
ipcs | grep ingres (sometimes ipcs need options, see man for details)
and remove all segments owned by Ingres (ipcrm, see man for details)
- because your message talk about outgoing connection check the config.datand
protect.dat modification time (and check config.log too) to see if some
netutil parameters have change (and try to find why)
- ingstart

Hope this help,
Signature

Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate@gmail.com
http://www.ingres-ua.fr/

22 Feb 2007 04:28:49 -0800, mr.rude@gmx.net <mr.rude@gmx.net>:

>
> Hello,
[quoted text clipped - 30 lines]
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
mr.rude@gmx.net - 23 Feb 2007 07:46 GMT
Hello,

thanks a lot for your quick Answer.

The Version is OpenIngres 2.0 on IBM AIX.
After doing all of the steps you mentioned, the installation is still
not coming up.
The Error message about the refused connection persists.

I think the Nameserver is starting up, cause the process is in the
process-table after ingstart.
The logfile also says "Name Server normal startup."

I assume the problem is the recovery server which does not start.
The Database is in a consistent state and there are no error messages
in iircp.log

Is there a possibility that the recovery server can't open some
connections for the inter-process communication of the different
database processes?
How could i test that? Which log file should I look into?

By the way: A reboot of the system seems to fix the problem.

hmeier

> Hello,
>
[quoted text clipped - 20 lines]
> +33(0)6 11 40 11 09
> jpzu...@gmail.comhttp://www.ingres-ua.fr/
Jean-Pierre Zuate - 23 Feb 2007 11:38 GMT
Hello Mr Rude,

Well, it's a little bit strange. A link between dmfcrp (recovery) and gcc, I
do not think there is any link between recovery and Ingres/NET ... but I
don't know all the internals.

Logs files are (in $II_SYSTEM/ingres/files) :
- errlog.log
- iiacp.log (or II_ACP.LOG) : archiver log (dmfacp), responsible of
journaling process
- iircp.log (or II_RCP.LOG) : recovery process (dmfrcp)

You can also set this variables :
ingsetenv II_DBMS_LOG $II_SYSTEM/ingres/files/dbms.%p.log
- %p is mandatory to have separate logs for differents processes and since
OpenINGRES (if my remember is correct) dmfrcp is just an other iidbms. %p
mean Unix PID
- restart Ingres after that

If you say reboot correct your problem I think it could something like a bad
file allocation (system) or some system tables not correctly synchronised,
or full, or something like that. I know AIX is not like all others Unixes in
some situation cause they are dealing with their own DB and sometimes it can
give some issues (problem to gain a process number in some huge situation,
etc).

Is there is something relevant in syslog (or errpt -a if my remember is
correct) ?

Try to look in the servicedesk.ingres.com knowledge database and raise an
issue to Ingres Corp. There are many many situations in their KB and as far
as I know many support and developpers team are the same since the many
years, so they have a great and complete experience and knowledge of many
situations ...

Hope this help,
Signature

Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate@gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/

22 Feb 2007 23:46:02 -0800, mr.rude@gmx.net <mr.rude@gmx.net>:

>
> Hello,
[quoted text clipped - 53 lines]
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.