Onspaces Segmentation fault
After reinstalling IDS 10.00.UC4 on SUSE 9, the instance initialized and came online, but onspaces (and later oncheck, ontape, onmonitor) died with a segmentation fault. Suggestions included checking for stale shared-memory segments (ipcs -m), SHMMAX and other kernel parameters, and whether other Informix products or old paths/environment variables interfered. The poster found the cause himself: the hostname entry in sqlhosts. Replacing the server/host name with the literal IP address made all the on* utilities work (an FQDN had not helped). Why the earlier install worked with the name was never explained.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all,
I have just finished reinstalling my IDS 10 for linux, on suse 9 for
workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus
its mirror was created fine.
But when i type onspaces (with or without the parameters), puff!!! the thing
throws "Segmentation Error". Any ideas?
PS: My first installation was working perfectly on the same hardware and OS.
My online.log reads like this:
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:51:16 --1312172 Kbytes
Message Log File: /home/informix/online.log
15:03:22 Booting Language <builtin> from module <>
15:03:22 Loading Module <BUILTINNULL>
15:03:27 DR: DRAUTO is 0 (Off)
15:03:27 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number
AAA#B000000
15:03:29 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
15:03:29 Physical Recovery Started at Page (1:1779).
15:03:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:03:29 Logical Recovery Started.
15:03:29 10 recovery worker threads will be started.
15:03:32 Logical Recovery has reached the transaction cleanup phase.
15:03:32 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:03:33 Dataskip is now OFF for all dbspaces
15:03:33 Checkpoint Completed: duration was 0 seconds.
15:03:33 Checkpoint loguniq 2, logpos 0x372018, timestamp: 0xef52
15:03:33 Maximum server connections 0
15:03:33 On-Line Mode
Please help.
Paul
Did you check dead/detached memoty segments (ipcs -m) ? Also, SHMMAX kernel
parameter ?
Did you reboot the system and tried onspaces ?
----- Original Message ----
From: PAUL GATHOGO <pgathogo@gmail.com>
To: ids@iiug.org
Sent: Friday, December 29, 2006 11:10:56 PM
Subject: Onspaces Segmentation fault [8059]
Hi all,
I have just finished reinstalling my IDS 10 for linux, on suse 9 for
workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus
its mirror was created fine.
But when i type onspaces (with or without the parameters), puff!!! the thing
throws "Segmentation Error". Any ideas?
PS: My first installation was working perfectly on the same hardware and OS.
My online.log reads like this:
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:51:16 --1312172 Kbytes
Message Log File: /home/informix/online.log
15:03:22 Booting Language <builtin> from module <>
15:03:22 Loading Module <BUILTINNULL>
15:03:27 DR: DRAUTO is 0 (Off)
15:03:27 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number
AAA#B000000
15:03:29 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
15:03:29 Physical Recovery Started at Page (1:1779).
15:03:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:03:29 Logical Recovery Started.
15:03:29 10 recovery worker threads will be started.
15:03:32 Logical Recovery has reached the transaction cleanup phase.
15:03:32 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:03:33 Dataskip is now OFF for all dbspaces
15:03:33 Checkpoint Completed: duration was 0 seconds.
15:03:33 Checkpoint loguniq 2, logpos 0x372018, timestamp: 0xef52
15:03:33 Maximum server connections 0
15:03:33 On-Line Mode
Please help.
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
When i execute ipcs -m i get the following, though i can't interpret:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 655360 informix 600 262144 1 dest
0x52574801 720897 root 660 33554432 13
0x52574802 753666 root 660 33554432 13
0x52574803 786435 root 660 33554432 13
0x52574804 819204 root 660 33554432 13
0x52574805 851973 root 660 33554432 13
0x52574806 884742 root 660 33554432 13
0x52574807 917511 root 660 33554432 13
0x52574808 950280 root 660 33554432 13
0x52574809 983049 root 660 33554432 13
0x5257480a 1015818 root 660 33554432 13
...
and many more .
help me to read that,
Where do you set the SHMMAX kernel parameter?
Yes i restarted the box, but still onspaces is throwing the same error!
PS: It was working perfectly before i reinstalled !
Paul
Did you check your Linux kernel parameters ?
Compare them with the other installation and/or the release notes.
I don't know in SUSE but in Red Hat they are in the /etc/sysctl.conf file.
Regards,
Victor Fabian Miramontes
PAUL GATHOGO <pgathogo@gmail.com> escribió:
Hi all,
I have just finished reinstalling my IDS 10 for linux, on suse 9 for
workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus
its mirror was created fine.
But when i type onspaces (with or without the parameters), puff!!! the thing
throws "Segmentation Error". Any ideas?
PS: My first installation was working perfectly on the same hardware and OS.
My online.log reads like this:
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:51:16 --1312172 Kbytes
Message Log File: /home/informix/online.log
15:03:22 Booting Language from module <>
15:03:22 Loading Module
15:03:27 DR: DRAUTO is 0 (Off)
15:03:27 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number
AAA#B000000
15:03:29 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
15:03:29 Physical Recovery Started at Page (1:1779).
15:03:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:03:29 Logical Recovery Started.
15:03:29 10 recovery worker threads will be started.
15:03:32 Logical Recovery has reached the transaction cleanup phase.
15:03:32 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:03:33 Dataskip is now OFF for all dbspaces
15:03:33 Checkpoint Completed: duration was 0 seconds.
15:03:33 Checkpoint loguniq 2, logpos 0x372018, timestamp: 0xef52
15:03:33 Maximum server connections 0
15:03:33 On-Line Mode
Please help.
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
miramontes, By the by, i did not reinstall Linux, i reinstalled IDS, so am jsut using the old Linux kernel settings which worked perfectly with my previous installation of IDS. any more ideas Paul
I am on leave until 10 Jan '07.
>>> ids 12/30/06 01:42 >>>
When i execute ipcs -m i get the following, though i can't interpret:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 655360 informix 600 262144 1 dest
0x52574801 720897 root 660 33554432 13
0x52574802 753666 root 660 33554432 13
0x52574803 786435 root 660 33554432 13
0x52574804 819204 root 660 33554432 13
0x52574805 851973 root 660 33554432 13
0x52574806 884742 root 660 33554432 13
0x52574807 917511 root 660 33554432 13
0x52574808 950280 root 660 33554432 13
0x52574809 983049 root 660 33554432 13
0x5257480a 1015818 root 660 33554432 13
....
and many more .
help me to read that,
Where do you set the SHMMAX kernel parameter?
Yes i restarted the box, but still onspaces is throwing the same error!
PS: It was working perfectly before i reinstalled !
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
______________________
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate,
distribute or copy this message.
If you have received this message in error, please notify us immediately
(Phone 0800 665 463 or info@linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any
attachments, after its transmission from LINZ.
Thank you.
________________________________________________________________________________
______________________
I am on leave until 10 Jan '07.
>>> ids 12/30/06 01:10 >>>
Hi all,
I have just finished reinstalling my IDS 10 for linux, on suse 9 for
workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs
plus
its mirror was created fine.
But when i type onspaces (with or without the parameters), puff!!! the
thing
throws "Segmentation Error". Any ideas?
PS: My first installation was working perfectly on the same hardware and
OS.
My online.log reads like this:
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:51:16
--1312172 Kbytes
Message Log File: /home/informix/online.log
15:03:22 Booting Language <builtin> from module <>
15:03:22 Loading Module <BUILTINNULL>
15:03:27 DR: DRAUTO is 0 (Off)
15:03:27 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial
Number
AAA#B000000
15:03:29 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
15:03:29 Physical Recovery Started at Page (1:1779).
15:03:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:03:29 Logical Recovery Started.
15:03:29 10 recovery worker threads will be started.
15:03:32 Logical Recovery has reached the transaction cleanup phase.
15:03:32 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:03:33 Dataskip is now OFF for all dbspaces
15:03:33 Checkpoint Completed: duration was 0 seconds.
15:03:33 Checkpoint loguniq 2, logpos 0x372018, timestamp: 0xef52
15:03:33 Maximum server connections 0
15:03:33 On-Line Mode
Please help.
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
______________________
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate,
distribute or copy this message.
If you have received this message in error, please notify us immediately
(Phone 0800 665 463 or info@linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any
attachments, after its transmission from LINZ.
Thank you.
________________________________________________________________________________
______________________
I am on leave until 10 Jan '07.
>>> ids 12/30/06 01:26 >>>
Did you check dead/detached memoty segments (ipcs -m) ? Also, SHMMAX
kernel
parameter ?
Did you reboot the system and tried onspaces ?
----- Original Message ----
From: PAUL GATHOGO <pgathogo@gmail.com>
To: ids@iiug.org
Sent: Friday, December 29, 2006 11:10:56 PM
Subject: Onspaces Segmentation fault [8059]
Hi all,
I have just finished reinstalling my IDS 10 for linux, on suse 9 for
workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs
plus
its mirror was created fine.
But when i type onspaces (with or without the parameters), puff!!! the
thing
throws "Segmentation Error". Any ideas?
PS: My first installation was working perfectly on the same hardware and
OS.
My online.log reads like this:
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:51:16
--1312172 Kbytes
Message Log File: /home/informix/online.log
15:03:22 Booting Language <builtin> from module <>
15:03:22 Loading Module <BUILTINNULL>
15:03:27 DR: DRAUTO is 0 (Off)
15:03:27 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial
Number
AAA#B000000
15:03:29 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
15:03:29 Physical Recovery Started at Page (1:1779).
15:03:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
15:03:29 Logical Recovery Started.
15:03:29 10 recovery worker threads will be started.
15:03:32 Logical Recovery has reached the transaction cleanup phase.
15:03:32 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:03:33 Dataskip is now OFF for all dbspaces
15:03:33 Checkpoint Completed: duration was 0 seconds.
15:03:33 Checkpoint loguniq 2, logpos 0x372018, timestamp: 0xef52
15:03:33 Maximum server connections 0
15:03:33 On-Line Mode
Please help.
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
______________________
This message contains information, which is confidential and may be subject to
legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate,
distribute or copy this message.
If you have received this message in error, please notify us immediately
(Phone 0800 665 463 or info@linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any
attachments, after its transmission from LINZ.
Thank you.
________________________________________________________________________________
______________________
Did you reinstall IDS on the same directory ? If not, could any environment variable be still referencing the old directory ? Did you install another IDS product (like 4gl, isql, etc) ? Database engine must be the last one to be installed. Anyway, check kernel parameters against release notes. Just in case. Regards, Victor PAUL GATHOGO <pgathogo@gmail.com> escribió: miramontes, By the by, i did not reinstall Linux, i reinstalled IDS, so am jsut using the old Linux kernel settings which worked perfectly with my previous installation of IDS. any more ideas Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
Victor,
When i Uninstalled IDS i even removed user informix plus his home directory
where i had installed IDS, and when i reinstalled back i placed it under the
same directory structure ( /home/informix ).
I did't install any other products, i used a straight installation process on
the IDS 10 CD (java installation - ids_install .
Did i mention to you that i have another server with the same specs and setup
and it's running perfectly!
PS: I had a bit of a hiccup during installation, the IDS was unable to resolve
the server name in the (/home/informix/etc/sqlhosts) file, i had to give it an
absolute IP address for it to accept! Later on i went and changed a value in
the /etc/nsmatch.conf file which i guess hold values on the way suse resolves
ip address and server names, then went and changed back my
(/home/informix/etc/sqlhosts)to have the server name, and when i oninit'ed, it
worked...
any hints?
by the way most of the oncommands are not working they are throwing the same
error, eg. oncheck -pe, ontape, onmonitor etc
Paul
Happy New Year!
I finally managed to fix this problem "Segmentation Fault", i reallized that
if i use the server name in the sqlhosts file then for reasons that i don't
know am unable to run most of the commands (onspaces, ontape, onmonitor etc),
but if i replace the server name and actuall IP address then everything works
perfectly!!!
Now that everything is working and am able to create my spaces, can someone
explain to me why the first IDS installation was able to work with the server
name? and this second installation can only worki with absolute IP address!!!!
Informix developers please assist on this one.
Thanks
Paul
On 1/1/07, PAUL GATHOGO <pgathogo@gmail.com> wrote:
> I finally managed to fix this problem "Segmentation Fault", i reallized that
> if i use the server name in the sqlhosts file then for reasons that i don't
> know am unable to run most of the commands (onspaces, ontape, onmonitor etc),
> but if i replace the server name and actuall IP address then everything works
> perfectly!!!
So, what is in your sqlhosts file - and what is set in
$INFORMIXSERVER, and what example command lines fail. On Linux, you
may need to use the FQDN (fully-qualified domain name -
machine.subdomain.domain.tld - in the sqlhosts file.
> Now that everything is working and am able to create my spaces, can someone
> explain to me why the first IDS installation was able to work with the server
> name? and this second installation can only worki with absolute IP
address!!!!
>
> Informix developers please assist on this one.
What works? What doesn't?
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
On sqlhosts file i have the absolute IP address (182.23.x.x), while on the
$INFORMIXSERVER i have the actual db instance name which is different from the
actual machine name.
Earlier on i had tried to place the FQDN which is in the /etc/HOSTNAME file
but still it refused to work!
Commands like onspaces, ontape, onmonitor could not work, till i changed to an
absolute IP address on the sqlhosts file !!!
But still i don't understand why it worked on the first installation and on
the second reinstallation it failed!
Thanks
Paul