Server won't start....possibly changed parameter
Larry reported that on Solaris 10 SPARC his IDS server hung during oninit -v right after "Checking config parameters...succeeded" (never reaching the shared-memory allocation step), with online.log only showing the Workgroup Edition warning that shared memory had been capped at 16 GB; no segments or semaphores appeared in ipcs. Suggestions included: buffers/SHMVIRTSIZE too large to fit under SHMTOTAL or the licence cap (the licence warning can mask a real SHMTOTAL overrun), setting INFORMIXSERVER to a shared-memory sqlhosts entry, and diagnosing with truss or pstack on the hung oninit processes (onstat would not work with no shared memory). No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 7.50.FC5WE
Solaris 10 Sparc
I am not sure if someone made a change somewhere, but when I try to restart a
database it just hangs with no special messages. I need help figuring it out.
> oninit -v
> Checking group membership to determine server run mode......succeeded
> Reading configuration file
'/opt/informix/production/onconfig.prod2'....succeeded
> Creating /INFORMIXTMP/.infxdirs....succeeded
> Checking config parameters....succeeded
Then it hangs.
The online.log...
IBM Informix Dynamic Server Started
Warning: The IBM IDS Workgroup Edition license restriction limits the total
shared memory size for this server to 16777216 KB
The size has been reset to the limit to bring up the database server.
Everything is hung at this point and `ipcs` shows no memory nor semiphores
have been created for the database.
Any suggestions on where I go from here to figure out why it is hanging and
not starting?
Larry
can you do onstat -g stk all ???
Madison Pruet
Retired and Loving it
On Tuesday, February 7, 2017 2:52 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
IDS 7.50.FC5WE
Solaris 10 Sparc
I am not sure if someone made a change somewhere, but when I try to restart a
database it just hangs with no special messages. I need help figuring it out.
> oninit -v
> Checking group membership to determine server run mode......succeeded
> Reading configuration file
'/opt/informix/production/onconfig.prod2'....succeeded
> Creating /INFORMIXTMP/.infxdirs....succeeded
> Checking config parameters....succeeded
Then it hangs.
The online.log...
IBM Informix Dynamic Server Started
Warning: The IBM IDS Workgroup Edition license restriction limits the total
shared memory size for this server to 16777216 KB
The size has been reset to the limit to bring up the database server.
Everything is hung at this point and `ipcs` shows no memory nor semiphores
have been created for the database.
Any suggestions on where I go from here to figure out why it is hanging and
not starting?
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
and onstat -g ath ???
Madison Pruet
Retired and Loving it
On Tuesday, February 7, 2017 3:23 PM, Madison Pruet <madison_pruet@yahoo.com>
wrote:
can you do onstat -g stk all ???
Madison Pruet
Retired and Loving it
On Tuesday, February 7, 2017 2:52 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
IDS 7.50.FC5WE
Solaris 10 Sparc
I am not sure if someone made a change somewhere, but when I try to restart a
database it just hangs with no special messages. I need help figuring it out.
> oninit -v
> Checking group membership to determine server run mode......succeeded
> Reading configuration file
'/opt/informix/production/onconfig.prod2'....succeeded
> Creating /INFORMIXTMP/.infxdirs....succeeded
> Checking config parameters....succeeded
Then it hangs.
The online.log...
IBM Informix Dynamic Server Started
Warning: The IBM IDS Workgroup Edition license restriction limits the total
shared memory size for this server to 16777216 KB
The size has been reset to the limit to bring up the database server.
Everything is hung at this point and `ipcs` shows no memory nor semiphores
have been created for the database.
Any suggestions on where I go from here to figure out why it is hanging and
not starting?
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Is it possible that your buffer caches are so large that when the engine
reduced virtual memory to fit under 16GB there isn't enough memory to start
up?
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, Feb 7, 2017 at 3:51 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> IDS 7.50.FC5WE
>
> Solaris 10 Sparc
>
> I am not sure if someone made a change somewhere, but when I try to
> restart a
> database it just hangs with no special messages. I need help figuring it
> out.
>
> > oninit -v>
> > Checking group membership to determine server run mode......succeeded
>
> > Reading configuration file
> '/opt/informix/production/onconfig.prod2'....succeeded
>
> > Creating /INFORMIXTMP/.infxdirs....succeeded
>
> > Checking config parameters....succeeded
>
> Then it hangs.
>
> The online.log...
>
> IBM Informix Dynamic Server Started
>
> Warning: The IBM IDS Workgroup Edition license restriction limits the total
> shared memory size for this server to 16777216 KB
>
> The size has been reset to the limit to bring up the database server.
>
> Everything is hung at this point and `ipcs` shows no memory nor semiphores
> have been created for the database.
>
> Any suggestions on where I go from here to figure out why it is hanging and
> not starting?
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a114434a01b154c0547f78bad
It's a long shot, but if you have your INFORMIXSERVER environment variable
set to a TCP connection when you start up the engine, then set it to a
shared memory value (if you have one configured in the sqlhosts) and try
again.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Tuesday, February 07, 2017 1:52 PM
To: ids@iiug.org
Subject: Server won't start....possibly changed parameter [38598]
IDS 7.50.FC5WE
Solaris 10 Sparc
I am not sure if someone made a change somewhere, but when I try to restart
a database it just hangs with no special messages. I need help figuring it
out.
> oninit -v
> Checking group membership to determine server run mode......succeeded
> Reading configuration file
'/opt/informix/production/onconfig.prod2'....succeeded
> Creating /INFORMIXTMP/.infxdirs....succeeded
> Checking config parameters....succeeded
Then it hangs.
The online.log...
IBM Informix Dynamic Server Started
Warning: The IBM IDS Workgroup Edition license restriction limits the total
shared memory size for this server to 16777216 KB
The size has been reset to the limit to bring up the database server.
Everything is hung at this point and `ipcs` shows no memory nor semiphores
have been created for the database.
Any suggestions on where I go from here to figure out why it is hanging and
not starting?
Larry
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Original post:
IDS 7.50.FC5WE
Solaris 10 Sparc
I am not sure if someone made a change somewhere, but when I try to restart a
database it just hangs with no special messages. I need help figuring it out.
> oninit -v
> Checking group membership to determine server run mode......succeeded
> Reading configuration file
'/opt/informix/production/onconfig.prod2'....succeeded
> Creating /INFORMIXTMP/.infxdirs....succeeded
> Checking config parameters....succeeded
Then it hangs.
The online.log...
IBM Informix Dynamic Server Started
Warning: The IBM IDS Workgroup Edition license restriction limits the total
shared memory size for this server to 16777216 KB
The size has been reset to the limit to bring up the database server.
Everything is hung at this point and `ipcs` shows no memory nor semiphores
have been created for the database.
Any suggestions on where I go from here to figure out why it is hanging and
not starting?
Larry
Response:
So from the oninit -v you included, the next line on a successful startup I
believe should be this:
Reading configuration file
'/vobs/tristarm/sqldist/etc/onconfig.pmr29264'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
So if you aren't seeing the "allocation and attaching to..." message it would
seem that the server is trying to do that part. As root you could try and to a
truss -f -o outfile oninit -v and check the output file to see if the server
is stuck in some OS library call. Alternatively when the oninit command hangs
you could get the pid's of any oninit processes and try and us /bin/pstack to
see what stack traces are reported for the oninits to try and get an idea of
what they are doing. Don't think you would be able to run any onstat's yet if
the shared memory segments haven't been created.
Jacques Renaut
IBM Informix
I've gotten the erroneous (at least in my case) -->
"Warning: The IBM IDS Workgroup Edition license restriction limits the
total shared memory size for this server to 16777216 KB"
when the problem is actually SHMTOTAL has been exceeded by SHMVIRTSIZE plus
buffer total MEM.
The actual error does appear in the online.log, just not on (in) the
console.
So the change (increase) in buffer size is still the likely culprit, even
though it has nothing to do with
licensing and such ...
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
Kagel
Sent: Tuesday, February 07, 2017 4:37 PM
To: ids@iiug.org
Subject: Re: Server won't start....possibly changed par.... [38601]
Is it possible that your buffer caches are so large that when the engine
reduced virtual memory to fit under 16GB there isn't enough memory to start
up?
Art
Art S. Kagel, President and Principal Consultant ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
On Tue, Feb 7, 2017 at 3:51 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> IDS 7.50.FC5WE
>
> Solaris 10 Sparc
>
> I am not sure if someone made a change somewhere, but when I try to
> restart a database it just hangs with no special messages. I need help
> figuring it out.
>
> > oninit -v>
> > Checking group membership to determine server run
> > mode......succeeded
>
> > Reading configuration file
> '/opt/informix/production/onconfig.prod2'....succeeded
>
> > Creating /INFORMIXTMP/.infxdirs....succeeded
>
> > Checking config parameters....succeeded
>
> Then it hangs.
>
> The online.log...
>
> IBM Informix Dynamic Server Started
>
> Warning: The IBM IDS Workgroup Edition license restriction limits the
> total shared memory size for this server to 16777216 KB
>
> The size has been reset to the limit to bring up the database server.
>
> Everything is hung at this point and `ipcs` shows no memory nor
> semiphores have been created for the database.
>
> Any suggestions on where I go from here to figure out why it is
> hanging and not starting?
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a114434a01b154c0547f78bad
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g