IDS on Linux sporadic connection problems
IDS 9.40.UC7 on Linux 2.6 gave sporadic shared-memory (onipcshm) connection failures from client tools like dbschema: error -25588 "appl process cannot connect to Dynamic Server" plus errno 22 (Invalid argument), occurring intermittently while TCP (onsoctcp) connections always worked. Changing sqlhosts entries made no difference. The cause was identified as Linux's Exec Shield address randomization, which makes shmat() fail to attach at the configured address. Setting the environment variable INFORMIXSHMBASE=-1 (with SHMBASE 0x44000000 in onconfig) eliminated the errors.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for the first time
I have sporadic connection problems when running dbutilities (e.g. dbschema)
over shared memory connections:
dbschema -d <database> -t <table>runs fine several times, than it takes a few seconds and returns with
the following error message:
-25588 - The appl process cannot connect to Dynamic Server <dbservername>
22 - Invalid argument
After that the command runs fine several times again.
When setting INFORMIXSERVER to a value for a TCP/IP connection (onsoctcp)
I don't get these errors.
Does anybody know similar problems?
Is the only way to avoid these errors not to use shared memory connections?
Here some more details of my configuration:
onconfig has the following settings:
SERVERNUM 0
NETTYPE (empty)
RESIDENT 0
MULTIPROCESSOR 0
NUMCPUVPS 1
SINGLE_CPU_VP 0
NOAGE 0
AFF_SPROC 0
SHMBASE 0x44000000L
SHMVIRTSIZE 64000
SHMADD 16384
EXTSHMADD 8192
SHMTOTAL 0
onstat -g seg shows no additionally allocated shared memory segments, onlythe three segments allocated at IDS startup (resident/virtual/message).
There are no error messages in the console or message log files.
SHMMAX is set to 1000000000 therefore all shared memory segments are allocated
as one single segment each (ipcs -m shows three segments).
Regards,
Andreas Kutsche
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
I changed the sqlhosts file, but it didn't help.
atuxi32wwwtcp onipcshm atuxi32 33333
The problem still exists: dbschema runs successful
a few times, than it returns the connection error
and than it runs successful again.
Some(one) other ideas?
Regards,
Andreas
>
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
-----Urspr|ngliche Nachricht-----
> Von: Gentry, Mark [mailto:mark.gentry@staples.com]
> Gesendet: Donnerstag, 03. November 2005 14:12
> An: KUTSCHE Andreas (HZ422); ids@iiug.org
> Betreff: RE: IDS on Linux sporadic connection problems [5958]
>
>
> Try something like this for a sqlhosts file:
>
> online_prd onipcshm jetta 5964
> online_mir onipcshm jetta onlineshm_mir
> online_trn onipcshm jetta 5990
> onlinetcp_jet1 onsoctcp jetta onlinetcp_jet1>
> where the 59xx are not in /etc/services
>
> then use dbaccess and try to connect and see tables
> change ur environment for INFORMIXSERVER for the tcp
> connection and do the
> dbaccess thing again.
>
> -----Original Message-----
> From: Andreas.KUT.... [mailto:andreas.kutsche@spar.at]
> Sent: Thursday, November 03, 2005 7:59 AM
> To: ids@iiug.org
> Subject: IDS on Linux sporadic connection problems [5958]
>
> Hello,
>
> after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for
> the first time
> I have sporadic connection problems when running dbutilities
> (e.g. dbschema)
> over shared memory connections:
>
> dbschema -d <database> -t <table>> runs fine several times, than it takes a few seconds and returns with
> the following error message:
> -25588 - The appl process cannot connect to Dynamic Server
> <dbservername>
> 22 - Invalid argument
> After that the command runs fine several times again.
>
> When setting INFORMIXSERVER to a value for a TCP/IP
> connection (onsoctcp)
> I don't get these errors.
>
> Does anybody know similar problems?
> Is the only way to avoid these errors not to use shared
> memory connections?
>
>
>
> Here some more details of my configuration:
>
> onconfig has the following settings:
>
> SERVERNUM 0
> NETTYPE (empty)
> RESIDENT 0
> MULTIPROCESSOR 0
> NUMCPUVPS 1
> SINGLE_CPU_VP 0
> NOAGE 0
> AFF_SPROC 0
> SHMBASE 0x44000000L
> SHMVIRTSIZE 64000
> SHMADD 16384
> EXTSHMADD 8192
> SHMTOTAL 0>
> onstat -g seg shows no additionally allocated shared memory> segments, only
> the three segments allocated at IDS startup
> (resident/virtual/message).
>
> There are no error messages in the console or message log files.
>
> SHMMAX is set to 1000000000 therefore all shared memory segments are
> allocated
> as one single segment each (ipcs -m shows three segments).
>
> Regards,
> Andreas Kutsche
> -------------------------------------------
> SPAR Oesterreichische Warenhandels-AG
> Hauptzentrale
> Europastrasse 3
> A - 5015 Salzburg
>
> Tel: +43 662 4470 24223
> Mobile: +43 664 6259575
> E-Mail: Andreas.KUTSCHE@spar.at
> Internet: http://www.spar.at
> -------------------------------------------
Hi,
"Exec Shield Randomize feature" THAT'S IT !!!
After setting INFORMIXSHMBASE to -1
no more errors occur.
Many thanks to Martin Fuerderer,
Andreas
>
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
-----Urspr|ngliche Nachricht-----
> Von: Martin Fuerderer [mailto:MARTINFU@de.ibm.com]
> Gesendet: Donnerstag, 03. November 2005 15:48
> An: KUTSCHE Andreas (HZ422)
> Cc: forum.subscriber@iiug.org; ids@iiug.org
> Betreff: Re: IDS on Linux sporadic connection problems [5958]
>
>
> Hi,
>
> please make sure that your problems are not due to
> the Exec Shield Randomize feature. See following e-mail
> excerpt for more info on this:
>
> ------------------------------------------------------
> The "Exec Shield Randomize" Feature (in RHEL 3 Update 3)
> From: "MAEVE DEVINE" maevedevine@yahoo.com
> Sent by: forum.subscriber@iiug.org
> Date: 28.06.2005 09:26
> To: ids@iiug.org
> Subject: Re: Creating a temp dbspace failing on RedHat ES 4.0 [5284]
>
> Thanks for all the replies, and huge thanks to Sandor Szabo
> who got this
> working.
>
> 1. Set an enviroment variable INFORMIXSHMBASE to -1
> 2. In the ONCONFIG, set SHMBASE to 0x44000000
>
> After that it all works fine.
>
> Details from Sandor:
>
> RHEL 3 Update 3 added a new feature "Exec Shield Randomize"
> and turned it on by default. IBM Informix application with this
> release
> will unpredictably fail to connect to a local IBM
> Informix database
> instance because shmat() will fail to attach shared memory at the
> configured location.
>
> If you use SHM communication then I would recommend setting
> environment variable INFORMIXSHMBASE to -1 because of the
> exec-shield-randomize feature.... for example:
>
> export INFORMIXSHMBASE=-1>
> This will use the SHMBASE of 0x44000000 which should be set
> in $ONCONFIG.
> --------------------------------------------------------------
>
> TIA,
> Martin
> --
> Martin Fuerderer
> IBM Informix Development Munich, Germany
> Information Management
>
> forum.subscriber@iiug.org wrote on 03.11.2005 13:59:16:
> > Hello,
> >
> > after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for
> the first
> time
> > I have sporadic connection problems when running dbutilities (e.g.
> dbschema)
> > over shared memory connections:
> >
> > dbschema -d <database> -t <table>> > runs fine several times, than it takes a few seconds and
> returns with
> > the following error message:
> > -25588 - The appl process cannot connect to Dynamic Server
> <dbservername>
> > 22 - Invalid argument
> > After that the command runs fine several times again.
> >
> > When setting INFORMIXSERVER to a value for a TCP/IP connection
> (onsoctcp)
> > I don't get these errors.
> >
> > Does anybody know similar problems?
> > Is the only way to avoid these errors not to use shared memory
> connections?
> >
> > Here some more details of my configuration:
> >
> > onconfig has the following settings:
> >
> > SERVERNUM 0
> > NETTYPE (empty)
> > RESIDENT 0
> > MULTIPROCESSOR 0
> > NUMCPUVPS 1
> > SINGLE_CPU_VP 0
> > NOAGE 0
> > AFF_SPROC 0
> > SHMBASE 0x44000000L
> > SHMVIRTSIZE 64000
> > SHMADD 16384
> > EXTSHMADD 8192
> > SHMTOTAL 0> >
> > onstat -g seg shows no additionally allocated shared> memory segments,
> only
> > the three segments allocated at IDS startup
> (resident/virtual/message).
> >
> > There are no error messages in the console or message log files.
> >
> > SHMMAX is set to 1000000000 therefore all shared memory
> segments are
> allocated
> > as one single segment each (ipcs -m shows three segments).
> >
> > Regards,
> > Andreas Kutsche
> > -------------------------------------------
> > SPAR Oesterreichische Warenhandels-AG
> > Hauptzentrale
> > Europastrasse 3
> > A - 5015 Salzburg
> >
> > Tel: +43 662 4470 24223
> > Mobile: +43 664 6259575
> > E-Mail: Andreas.KUTSCHE@spar.at
> > Internet: http://www.spar.at
> > -------------------------------------------
Are you
running NIS? What flavor of Linux?
Informix uses Unix authentication as does DB2. We have seen sporadic
connection times even if NIS is setup to look local hosts first on Linux. It
is my understanding that there is a SUSE 9 patch that just came out to help
with this problem.
Debbie Butler
Turner Broadcasting
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On
Behalf Of Andreas.KUT....
Sent: Thursday, November 03, 2005 9:07 AM
To: ids@iiug.org
Subject: RE: RE: IDS on Linux sporadic connection problems [5960]
I changed the sqlhosts file, but it didn't help.
atuxi32wwwtcp onipcshm atuxi32 33333
The problem still exists: dbschema runs successful
a few times, than it returns the connection error
and than it runs successful again.
Some(one) other ideas?
Regards,
Andreas
>
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
-----Urspr|ngliche Nachricht-----
> Von: Gentry, Mark [mailto:mark.gentry@staples.com]
> Gesendet: Donnerstag, 03. November 2005 14:12
> An: KUTSCHE Andreas (HZ422); ids@iiug.org
> Betreff: RE: IDS on Linux sporadic connection problems [5958]
>
>
> Try something like this for a sqlhosts file:
>
> online_prd onipcshm jetta 5964
> online_mir onipcshm jetta onlineshm_mir
> online_trn onipcshm jetta 5990
> onlinetcp_jet1 onsoctcp jetta onlinetcp_jet1>
> where the 59xx are not in /etc/services
>
> then use dbaccess and try to connect and see tables
> change ur environment for INFORMIXSERVER for the tcp
> connection and do the
> dbaccess thing again.
>
> -----Original Message-----
> From: Andreas.KUT.... [mailto:andreas.kutsche@spar.at]
> Sent: Thursday, November 03, 2005 7:59 AM
> To: ids@iiug.org
> Subject: IDS on Linux sporadic connection problems [5958]
>
> Hello,
>
> after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for
> the first time
> I have sporadic connection problems when running dbutilities
> (e.g. dbschema)
> over shared memory connections:
>
> dbschema -d <database> -t <table>> runs fine several times, than it takes a few seconds and returns with
> the following error message:
> -25588 - The appl process cannot connect to Dynamic Server
> <dbservername>
> 22 - Invalid argument
> After that the command runs fine several times again.
>
> When setting INFORMIXSERVER to a value for a TCP/IP
> connection (onsoctcp)
> I don't get these errors.
>
> Does anybody know similar problems?
> Is the only way to avoid these errors not to use shared
> memory connections?
>
>
>
> Here some more details of my configuration:
>
> onconfig has the following settings:
>
> SERVERNUM 0
> NETTYPE (empty)
> RESIDENT 0
> MULTIPROCESSOR 0
> NUMCPUVPS 1
> SINGLE_CPU_VP 0
> NOAGE 0
> AFF_SPROC 0
> SHMBASE 0x44000000L
> SHMVIRTSIZE 64000
> SHMADD 16384
> EXTSHMADD 8192
> SHMTOTAL 0>
> onstat -g seg shows no additionally allocated shared memory> segments, only
> the three segments allocated at IDS startup
> (resident/virtual/message).
>
> There are no error messages in the console or message log files.
>
> SHMMAX is set to 1000000000 therefore all shared memory segments are
> allocated
> as one single segment each (ipcs -m shows three segments).
>
> Regards,
> Andreas Kutsche
> -------------------------------------------
> SPAR Oesterreichische Warenhandels-AG
> Hauptzentrale
> Europastrasse 3
> A - 5015 Salzburg
>
> Tel: +43 662 4470 24223
> Mobile: +43 664 6259575
> E-Mail: Andreas.KUTSCHE@spar.at
> Internet: http://www.spar.at
> -------------------------------------------
Hi,
"Exec Shield Randomize feature" THAT'S IT !!!
After setting INFORMIXSHMBASE to -1
no more errors occur.
Many thanks to Martin Fuerderer,
Andreas
> >
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
-----Urspr|ngliche Nachricht-----
> > Von: Martin Fuerderer [mailto:MARTINFU@de.ibm.com]
> > Gesendet: Donnerstag, 03. November 2005 15:48
> > An: KUTSCHE Andreas (HZ422)
> > Cc: forum.subscriber@iiug.org; ids@iiug.org
> > Betreff: Re: IDS on Linux sporadic connection problems [5958]
> >
> >
> > Hi,
> >
> > please make sure that your problems are not due to
> > the Exec Shield Randomize feature. See following e-mail
> > excerpt for more info on this:
> >
> > ------------------------------------------------------
> > The "Exec Shield Randomize" Feature (in RHEL 3 Update 3)
> > From: "MAEVE DEVINE" maevedevine@yahoo.com
> > Sent by: forum.subscriber@iiug.org
> > Date: 28.06.2005 09:26
> > To: ids@iiug.org
> > Subject: Re: Creating a temp dbspace failing on RedHat ES 4.0 [5284]
> >
> > Thanks for all the replies, and huge thanks to Sandor Szabo
> > who got this
> > working.
> >
> > 1. Set an enviroment variable INFORMIXSHMBASE to -1
> > 2. In the ONCONFIG, set SHMBASE to 0x44000000
> >
> > After that it all works fine.
> >
> > Details from Sandor:
> >
> > RHEL 3 Update 3 added a new feature "Exec Shield Randomize"
> > and turned it on by default. IBM Informix application with this
> > release
> > will unpredictably fail to connect to a local IBM
> > Informix database
> > instance because shmat() will fail to attach shared
> memory at the
> > configured location.
> >
> > If you use SHM communication then I would recommend setting
> > environment variable INFORMIXSHMBASE to -1 because of the
> > exec-shield-randomize feature.... for example:
> >
> > export INFORMIXSHMBASE=-1> >
> > This will use the SHMBASE of 0x44000000 which should be set
> > in $ONCONFIG.
> > --------------------------------------------------------------
> >
> > TIA,
> > Martin
> > --
> > Martin Fuerderer
> > IBM Informix Development Munich, Germany
> > Information Management
> >
> > forum.subscriber@iiug.org wrote on 03.11.2005 13:59:16:
> > > Hello,
> > >
> > > after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for
> > the first
> > time
> > > I have sporadic connection problems when running
> dbutilities (e.g.
> > dbschema)
> > > over shared memory connections:
> > >
> > > dbschema -d <database> -t <table>> > > runs fine several times, than it takes a few seconds and
> > returns with
> > > the following error message:
> > > -25588 - The appl process cannot connect to Dynamic Server
> > <dbservername>
> > > 22 - Invalid argument
> > > After that the command runs fine several times again.
> > >
> > > When setting INFORMIXSERVER to a value for a TCP/IP connection
> > (onsoctcp)
> > > I don't get these errors.
> > >
> > > Does anybody know similar problems?
> > > Is the only way to avoid these errors not to use shared memory
> > connections?
> > >
> > > Here some more details of my configuration:
> > >
> > > onconfig has the following settings:
> > >
> > > SERVERNUM 0
> > > NETTYPE (empty)
> > > RESIDENT 0
> > > MULTIPROCESSOR 0
> > > NUMCPUVPS 1
> > > SINGLE_CPU_VP 0
> > > NOAGE 0
> > > AFF_SPROC 0
> > > SHMBASE 0x44000000L
> > > SHMVIRTSIZE 64000
> > > SHMADD 16384
> > > EXTSHMADD 8192
> > > SHMTOTAL 0> > >
> > > onstat -g seg shows no additionally allocated shared> > memory segments,
> > only
> > > the three segments allocated at IDS startup
> > (resident/virtual/message).
> > >
> > > There are no error messages in the console or message log files.
> > >
> > > SHMMAX is set to 1000000000 therefore all shared memory
> > segments are
> > allocated
> > > as one single segment each (ipcs -m shows three segments).
> > >
> > > Regards,
> > > Andreas Kutsche
> > > -------------------------------------------
> > > SPAR Oesterreichische Warenhandels-AG
> > > Hauptzentrale
> > > Europastrasse 3
> > > A - 5015 Salzburg
> > >
> > > Tel: +43 662 4470 24223
> > > Mobile: +43 664 6259575
> > > E-Mail: Andreas.KUTSCHE@spar.at
> > > Internet: http://www.spar.at
> > > -------------------------------------------
Andreas.KUT.... wrote:
>Hello,
>
>after installing IDS 9.40.UC7 on Linux (2.6.9-11 i686) for the first time
>I have sporadic connection problems when running dbutilities (e.g. dbschema)
>over shared memory connections:
>
>dbschema -d <database> -t <table>>runs fine several times, than it takes a few seconds and returns with
>the following error message:
>-25588 - The appl process cannot connect to Dynamic Server <dbservername>
>22 - Invalid argument
>After that the command runs fine several times again.
>
>When setting INFORMIXSERVER to a value for a TCP/IP connection (onsoctcp)
>I don't get these errors.
>
>Does anybody know similar problems?
>Is the only way to avoid these errors not to use shared memory connections?
>
>
>
>Here some more details of my configuration:
>
>onconfig has the following settings:
>
>SERVERNUM 0
>NETTYPE (empty)
>RESIDENT 0
>MULTIPROCESSOR 0
>NUMCPUVPS 1
>SINGLE_CPU_VP 0
>NOAGE 0
>AFF_SPROC 0
>SHMBASE 0x44000000L
>SHMVIRTSIZE 64000
>SHMADD 16384
>EXTSHMADD 8192
>SHMTOTAL 0>
>onstat -g seg shows no additionally allocated shared memory segments, only>the three segments allocated at IDS startup (resident/virtual/message).
>
>There are no error messages in the console or message log files.
>
>SHMMAX is set to 1000000000 therefore all shared memory segments are allocated
>as one single segment each (ipcs -m shows three segments).
>
>Regards,
>Andreas Kutsche
>-------------------------------------------
>SPAR Oesterreichische Warenhandels-AG
>Hauptzentrale
>Europastrasse 3
>A - 5015 Salzburg
>
>Tel: +43 662 4470 24223
>Mobile: +43 664 6259575
>E-Mail: Andreas.KUTSCHE@spar.at
>Internet: http://www.spar.at
>-------------------------------------------
>
>
>
>
>
Hi,
Try export INFORMIXSHMBASE=-1
Dimitar Bachvarov
[demime 1.01d removed an attachment of type text/x-vcard which had a name of
dimitar.bachvarov.vcf]
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