Error 25588 - on IDS7.31, Solaris 7 
Author Message
 Error 25588 - on IDS7.31, Solaris 7

Something I can maybe add, is that the program aborts on line 0

Program stopped at "m_medres.4gl", line number 0.

Quote:
-----Original Message-----
From: Dirk Moolman
Sent: 04 January 2002 15:15

Subject: Error 25588 - on IDS7.31, Solaris 7

I have a strange problem on my server which I can't seem to track down.

I have my poll threads set up as follows -
NETTYPE         ipcshm,5,400,CPU
NETTYPE         tlitcp,3,400,NET

I have only one program that started giving me the error 25588 The appl
process cannot connect to the database server 'online'

where "online" is the name of my INFORMIXSERVER for shared
memory connections.
At first I thought I was experiencing a NETTYPE problem, so I
changed it.
(It was originally set to ipcshm,,999,CPU)

Changing it to 5,400 didn't help. I am still getting the error. When I
change my INFORMIXSERVER to use tcp connections, the program works fine.
This also happens under all usernames, including informix.
The program doesn't connect to any other instances, but it does use a
synonym to another database in the same instance (the synonym is new). I
wrote a test program using the same synonym, and it works fine using a
shared memory connection, so that rules out the synonym.

I even recompiled the program just to be sure, but no luck.
All other programs run fine and aren't affected (??)

Any ideas ?

Dirk Moolman
Database Administrator - MXGroup

"When you make the finding yourself - even if you're the last person
on Earth to see the light - you'll never forget it."
-Carl Sagan  



Tue, 22 Jun 2004 21:20:15 GMT
 Error 25588 - on IDS7.31, Solaris 7

I have a strange problem on my server which I can't seem to track down.

I have my poll threads set up as follows -
NETTYPE         ipcshm,5,400,CPU
NETTYPE         tlitcp,3,400,NET

I have only one program that started giving me the error 25588
The appl process cannot connect to the database server 'online'

where "online" is the name of my INFORMIXSERVER for shared
memory connections.
At first I thought I was experiencing a NETTYPE problem, so I
changed it.
(It was originally set to ipcshm,,999,CPU)

Changing it to 5,400 didn't help. I am still getting the error.
When I change my INFORMIXSERVER to use tcp connections, the program works
fine.
This also happens under all usernames, including informix.
The program doesn't connect to any other instances, but it does
use a synonym to another database in the same instance (the synonym
is new).
I wrote a test program using the same synonym, and it works fine
using a shared memory connection, so that rules out the synonym.

I even recompiled the program just to be sure, but no luck.
All other programs run fine and aren't affected (??)

Any ideas ?

Dirk Moolman
Database Administrator - MXGroup

"When you make the finding yourself - even if you're the last person
on Earth to see the light - you'll never forget it."
-Carl Sagan  



Tue, 22 Jun 2004 21:15:25 GMT
 Error 25588 - on IDS7.31, Solaris 7

In my environment (SOLARIS 8, ids 7.31.ud1) I got the same error, the
solution was

NETTYPE ipcshm,x,y,NET and not CPU

If you set the INFORMIXSERVER to the network access the program work?

I hope this help you.

Gustavo Tobares
Administrador de Sistemas y  DBA
Centro de Computos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940

-----Mensaje original-----

Enviado el: Viernes, 04 de Enero de 2002 10:15 a.m.

Asunto: Error 25588 - on IDS7.31, Solaris 7

I have a strange problem on my server which I can't seem to track down.

I have my poll threads set up as follows -
NETTYPE         ipcshm,5,400,CPU
NETTYPE         tlitcp,3,400,NET

I have only one program that started giving me the error 25588
The appl process cannot connect to the database server 'online'

where "online" is the name of my INFORMIXSERVER for shared
memory connections.
At first I thought I was experiencing a NETTYPE problem, so I
changed it.
(It was originally set to ipcshm,,999,CPU)

Changing it to 5,400 didn't help. I am still getting the error.
When I change my INFORMIXSERVER to use tcp connections, the program works
fine.
This also happens under all usernames, including informix.
The program doesn't connect to any other instances, but it does
use a synonym to another database in the same instance (the synonym
is new).
I wrote a test program using the same synonym, and it works fine
using a shared memory connection, so that rules out the synonym.

I even recompiled the program just to be sure, but no luck.
All other programs run fine and aren't affected (??)

Any ideas ?

Dirk Moolman
Database Administrator - MXGroup

"When you make the finding yourself - even if you're the last person
on Earth to see the light - you'll never forget it."
-Carl Sagan  



Tue, 22 Jun 2004 21:45:02 GMT
 Error 25588 - on IDS7.31, Solaris 7

Quote:
-----Original Message-----

>In my environment (SOLARIS 8, ids 7.31.ud1) I got the same error, the
solution was

>NETTYPE     ipcshm,x,y,NET and not CPU

>If you set the INFORMIXSERVER to the network access the program work?

>I hope this help you.

Thanks Gustavo, I just wonder why this is happening. It doesn't really
make sense to me. I know that tcp connections sometimes give problems
on type CPU poll threads, and shared memory connections sometimes
give problems on type NET poll threads, but mine is not set up like
this, so it should be fine - strange.

And the strangest of all, it only happens with one program.

Let's see what the others have to say .....

Thanks for the e-mail

-----Mensaje original-----

Enviado el: Viernes, 04 de Enero de 2002 10:15 a.m.

Asunto: Error 25588 - on IDS7.31, Solaris 7

I have a strange problem on my server which I can't seem to track down.

I have my poll threads set up as follows -
NETTYPE         ipcshm,5,400,CPU
NETTYPE         tlitcp,3,400,NET

I have only one program that started giving me the error 25588 The appl
process cannot connect to the database server 'online'

where "online" is the name of my INFORMIXSERVER for shared
memory connections.
At first I thought I was experiencing a NETTYPE problem, so I
changed it.
(It was originally set to ipcshm,,999,CPU)

Changing it to 5,400 didn't help. I am still getting the error. When I
change my INFORMIXSERVER to use tcp connections, the program works fine.
This also happens under all usernames, including informix.
The program doesn't connect to any other instances, but it does use a
synonym to another database in the same instance (the synonym is new). I
wrote a test program using the same synonym, and it works fine using a
shared memory connection, so that rules out the synonym.

I even recompiled the program just to be sure, but no luck.
All other programs run fine and aren't affected (??)

Any ideas ?

Dirk Moolman
Database Administrator - MXGroup

"When you make the finding yourself - even if you're the last person
on Earth to see the light - you'll never forget it."
-Carl Sagan  



Tue, 22 Jun 2004 22:34:56 GMT
 Error 25588 - on IDS7.31, Solaris 7

Hi again, in one application (4gl) a got this error (25588), the application
have big arrays, this is a BUG (130299) [Errror -25888 using big arrays &
shared memory connections]

The solution given by Technical Support was:

set INFORMIXSHMBASE to 8192 or 16834

The bug descripcion:

----------------------------------------------------------------------------
--------------------------------------------------------------------------
Bug:  131502 4GL ANS ESQ/C PROGRAMS THAT HAS BIG SIZE ARRAY VARIABLE CAN'T
 ATTACH TO THE ENGINE SHARED MEMORY AND GIVE ERROR 25588

Description:
4GL and ESQL/C programs that define an array of big size can't attach to
shared memory segment and give error 25588
----------------------------------------------------------------------------
--------------------------------------------------------------------------

En este momento no existe una version de motor donde este error se encuentre
corregido, pero la
solucion es colocar la variable de ambiente INFORMIXSHMBASE seteada a 8192,
si no esto no
le corrige el problema entonces debera incrementar el valor de
INFORMIXSHMBASE a 16834.

Si Ustedes desean obtener mas informacion de esta variable de ambiente, por
favor consultar
el manual "Informix Guide to SQL" version 7.3 en la pagina 3-56.

------------------

free translation:  this error is present in every version of the engine, the
solution is try to set de environment variable INFORMIXSHMBASE=8192.  

In my environment, the solution was INFORMIXSHMBASE=16834

Hi hope this give some help.

Gustavo Tobares
Administrador de Sistemas y  DBA
Centro de Computos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940

-----Mensaje original-----

Enviado el: Viernes, 04 de Enero de 2002 11:35 a.m.

Asunto: RE: Error 25588 - on IDS7.31, Solaris 7

Quote:
-----Original Message-----

>In my environment (SOLARIS 8, ids 7.31.ud1) I got the same error, the
solution was

>NETTYPE     ipcshm,x,y,NET and not CPU

>If you set the INFORMIXSERVER to the network access the program work?

>I hope this help you.

Thanks Gustavo, I just wonder why this is happening. It doesn't really
make sense to me. I know that tcp connections sometimes give problems
on type CPU poll threads, and shared memory connections sometimes
give problems on type NET poll threads, but mine is not set up like
this, so it should be fine - strange.

And the strangest of all, it only happens with one program.

Let's see what the others have to say .....

Thanks for the e-mail

-----Mensaje original-----

Enviado el: Viernes, 04 de Enero de 2002 10:15 a.m.

Asunto: Error 25588 - on IDS7.31, Solaris 7

I have a strange problem on my server which I can't seem to track down.

I have my poll threads set up as follows -
NETTYPE         ipcshm,5,400,CPU
NETTYPE         tlitcp,3,400,NET

I have only one program that started giving me the error 25588 The appl
process cannot connect to the database server 'online'

where "online" is the name of my INFORMIXSERVER for shared
memory connections.
At first I thought I was experiencing a NETTYPE problem, so I
changed it.
(It was originally set to ipcshm,,999,CPU)

Changing it to 5,400 didn't help. I am still getting the error. When I
change my INFORMIXSERVER to use tcp connections, the program works fine.
This also happens under all usernames, including informix.
The program doesn't connect to any other instances, but it does use a
synonym to another database in the same instance (the synonym is new). I
wrote a test program using the same synonym, and it works fine using a
shared memory connection, so that rules out the synonym.

I even recompiled the program just to be sure, but no luck.
All other programs run fine and aren't affected (??)

Any ideas ?

Dirk Moolman
Database Administrator - MXGroup

"When you make the finding yourself - even if you're the last person
on Earth to see the light - you'll never forget it."
-Carl Sagan  



Tue, 22 Jun 2004 23:26:00 GMT
 Error 25588 - on IDS7.31, Solaris 7

Quote:
> Hi again, in one application (4gl) a got this error (25588), the
application
> have big arrays, this is a BUG (130299) [Errror -25888 using big arrays &
> shared memory connections]

> The solution given by Technical Support was:

> set INFORMIXSHMBASE to 8192 or 16834

Yeah, I've got a few applications that dynamically allocate great big gobs
of memory before they attempt to attach to the Informix shared memory
segments - by then, their break address was waaaaaay past whatever address
the APIs were trying to shmat() to.   Bumped INFORMIXSHMBASE way up and it
went away.  Then I switched to TLI connections ( because I was tired of
watching truss outputs looking for specific addresses ) and stopped worrying
about it all together =)


Wed, 23 Jun 2004 11:25:57 GMT
 Error 25588 - on IDS7.31, Solaris 7
Are you sure that was SHMBASE, the standard Solaris SHMBASE does not
normally need to be altered.

Quote:

> Hi again, in one application (4gl) a got this error (25588), the application
> have big arrays, this is a BUG (130299) [Errror -25888 using big arrays &
> shared memory connections]

> The solution given by Technical Support was:

> set INFORMIXSHMBASE to 8192 or 16834

> The bug descripcion:

> ----------------------------------------------------------------------------
> --------------------------------------------------------------------------
> Bug:  131502 4GL ANS ESQ/C PROGRAMS THAT HAS BIG SIZE ARRAY VARIABLE CAN'T
>  ATTACH TO THE ENGINE SHARED MEMORY AND GIVE ERROR 25588

> Description:
> 4GL and ESQL/C programs that define an array of big size can't attach to
> shared memory segment and give error 25588
> ----------------------------------------------------------------------------
> --------------------------------------------------------------------------

> En este momento no existe una version de motor donde este error se encuentre
> corregido, pero la
> solucion es colocar la variable de ambiente INFORMIXSHMBASE seteada a 8192,
> si no esto no
> le corrige el problema entonces debera incrementar el valor de
> INFORMIXSHMBASE a 16834.

> Si Ustedes desean obtener mas informacion de esta variable de ambiente, por
> favor consultar
> el manual "Informix Guide to SQL" version 7.3 en la pagina 3-56.

> ------------------

> free translation:  this error is present in every version of the engine, the
> solution is try to set de environment variable INFORMIXSHMBASE=8192.

> In my environment, the solution was INFORMIXSHMBASE=16834

> Hi hope this give some help.

> Gustavo Tobares
> Administrador de Sistemas y  DBA
> Centro de Computos - Red Megatone
> TE: 0342-4500972 - Fax: 0342-4500940

> -----Mensaje original-----

> Enviado el: Viernes, 04 de Enero de 2002 11:35 a.m.

> Asunto: RE: Error 25588 - on IDS7.31, Solaris 7

> -----Original Message-----

> >In my environment (SOLARIS 8, ids 7.31.ud1) I got the same error, the
> solution was

> >NETTYPE        ipcshm,x,y,NET and not CPU

> >If you set the INFORMIXSERVER to the network access the program work?

> >I hope this help you.

> Thanks Gustavo, I just wonder why this is happening. It doesn't really
> make sense to me. I know that tcp connections sometimes give problems
> on type CPU poll threads, and shared memory connections sometimes
> give problems on type NET poll threads, but mine is not set up like
> this, so it should be fine - strange.

> And the strangest of all, it only happens with one program.

> Let's see what the others have to say .....

> Thanks for the e-mail

> -----Mensaje original-----

> Enviado el: Viernes, 04 de Enero de 2002 10:15 a.m.

> Asunto: Error 25588 - on IDS7.31, Solaris 7

> I have a strange problem on my server which I can't seem to track down.

> I have my poll threads set up as follows -
> NETTYPE         ipcshm,5,400,CPU
> NETTYPE         tlitcp,3,400,NET

> I have only one program that started giving me the error 25588 The appl
> process cannot connect to the database server 'online'

> where "online" is the name of my INFORMIXSERVER for shared
> memory connections.
> At first I thought I was experiencing a NETTYPE problem, so I
> changed it.
> (It was originally set to ipcshm,,999,CPU)

> Changing it to 5,400 didn't help. I am still getting the error. When I
> change my INFORMIXSERVER to use tcp connections, the program works fine.
> This also happens under all usernames, including informix.
> The program doesn't connect to any other instances, but it does use a
> synonym to another database in the same instance (the synonym is new). I
> wrote a test program using the same synonym, and it works fine using a
> shared memory connection, so that rules out the synonym.

> I even recompiled the program just to be sure, but no luck.
> All other programs run fine and aren't affected (??)

> Any ideas ?

> Dirk Moolman
> Database Administrator - MXGroup

> "When you make the finding yourself - even if you're the last person
> on Earth to see the light - you'll never forget it."
> -Carl Sagan

--
Paul Watson             #          
Oninit Ltd              # Growing old is mandatory
Tel: +44 1436 672201    # Growing up is optional
Fax: +44 1436 678693    #
www.oninit.com          #


Wed, 23 Jun 2004 18:50:09 GMT
 Error 25588 - on IDS7.31, Solaris 7

Quote:
> Are you sure that was SHMBASE, the standard Solaris SHMBASE does not
> normally need to be altered.

Not SHMBASE - that's where the engine's processes attach the shared memory
segments.  INFORMIXSHMBASE is a user-space environment variable that
specifies the address where applications will attach the shared memory
segments, if they're using shared memory connections.

I forget what the default address was.....0x00800000 maybe on Sol 2.6 (
never tried 7 or 8, used TLI connections ).  I ended up using 0x0a000000.



Thu, 24 Jun 2004 04:05:52 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Netbackup (Solaris 7 & 8, IDS7.31)

2. Enterprise Replication on IDS7.31

3. IDS7.31.x (64 bit version)

4. IDS7.31.x (64 bit version)

5. Locks on IDS7.31

6. IDS7.31, NT, logging user from some computer

7. informix IDS7.31 crawling

8. jbuilder3 and ids7.31

9. HP-UX 10.20, IDS7.31 and KAIO problem

10. IDS7.31 upgrade conversion

11. Error during connection to dbaccess - 25588

12. Error: 25588


 
Powered by phpBB® Forum Software