Unix Technical Forum

sql_listener: ASF_LISTEN failed

This is a discussion on sql_listener: ASF_LISTEN failed within the Informix forums, part of the Database Server Software category; --> Hi, I am giving oninit -ivy. I am using Informix 9.4. on HP Tru64. It is showing no error. ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 04:10 PM
saikat_in@hotmail.com
 
Posts: n/a
Default sql_listener: ASF_LISTEN failed

Hi,

I am giving oninit -ivy. I am using Informix 9.4. on HP Tru64. It is
showing no error. After that I am using onstat -d command. It is
showing

"shared memory not initialized for INFORMIXSERVER ifmx_db"

My online.log contains following:

System error = 48.
15:09:34 sql_listener: ASF_LISTEN failed

15:09:34 Attempting to bring listener thread down.

15:09:34 Server stopped.

15:09:34 IBM Informix Dynamic Server Stopped.

15:09:34 mt_shm_remove: WARNING: may not have removed all/correct
segments

Please provide me help.

Saikat

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 04:10 PM
tarod35
 
Posts: n/a
Default Re: sql_listener: ASF_LISTEN failed

On Feb 18, 8:31 am, saikat...@hotmail.com wrote:
> Hi,
>
> I am giving oninit -ivy. I am using Informix 9.4. on HP Tru64. It is
> showing no error. After that I am using onstat -d command. It is
> showing
>
> "shared memory not initialized for INFORMIXSERVER ifmx_db"
>
> My online.log contains following:
>
> System error = 48.
> 15:09:34 sql_listener: ASF_LISTEN failed
>
> 15:09:34 Attempting to bring listener thread down.
>
> 15:09:34 Server stopped.
>
> 15:09:34 IBM Informix Dynamic Server Stopped.
>
> 15:09:34 mt_shm_remove: WARNING: may not have removed all/correct
> segments
>
> Please provide me help.
>
> Saikat


Hi,
your memory segments are online, you have removed,
give "ipcs"

---- Segmentos memoria compartida ----
key shmid propietario perms bytes nattch
estado
0x52594801 294912 root 660 670736384 36
0x52594802 327681 root 660 71680000 36
0x52594803 360450 root 666 1908736 36

------ Matrices semáforo -------
key semid propietario perms nsems
0x00000000 294912 root 660 37
0x00000000 327681 root 666 100
0x00000000 360450 root 666 82

------ Colas de mensajes -----
key msqid propietario perms bytes utilizados mensajes

for example delete:
ipcrm -m 294912
or
ipcrm -s 294912


chema.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 04:11 PM
stefan@weideneder.de
 
Posts: n/a
Default Re: sql_listener: ASF_LISTEN failed

Hi,

sounds strange, but check if you have mistyped "onsoctcp" either in
sqlhosts or your $ONCONFIG file:

NETTYPE soctcp,1,50,NET


sqlhosts file

.... onsoctcp ... ...

Best regards

Stefan

On 18 Feb., 08:31, saikat...@hotmail.com wrote:
> Hi,
>
> I am giving oninit -ivy. I am using Informix 9.4. on HP Tru64. It is
> showing no error. After that I am using onstat -d command. It is
> showing
>
> "shared memory not initialized for INFORMIXSERVER ifmx_db"
>
> My online.log contains following:
>
> System error = 48.
> 15:09:34 sql_listener: ASF_LISTEN failed
>
> 15:09:34 Attempting to bring listener thread down.
>
> 15:09:34 Server stopped.
>
> 15:09:34 IBM Informix Dynamic Server Stopped.
>
> 15:09:34 mt_shm_remove: WARNING: may not have removed all/correct
> segments
>
> Please provide me help.
>
> Saikat



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 04:11 PM
Jonathan Leffler
 
Posts: n/a
Default Fwd: sql_listener: ASF_LISTEN failed

I sent this on Sunday (rather early) just to Saikat - and not to c.d.i
or informix-list@iiug.org; oops.

---------- Forwarded message ----------
From: Jonathan Leffler <jleffler.iiug@gmail.com>
Date: Feb 18, 2007 12:12 AM
Subject: Re: sql_listener: ASF_LISTEN failed
To: "saikat_in@hotmail.com" <saikat_in@hotmail.com>


On 17 Feb 2007 23:31:28 -0800, saikat_in@hotmail.com
<saikat_in@hotmail.com> wrote:
> I am giving oninit -ivy. I am using Informix 9.4. on HP Tru64. It is
> showing no error. After that I am using onstat -d command. It is
> showing
>
> "shared memory not initialized for INFORMIXSERVER ifmx_db"
>
> My online.log contains following:
>
> System error = 48.
> 15:09:34 sql_listener: ASF_LISTEN failed
>
> 15:09:34 Attempting to bring listener thread down.
>
> 15:09:34 Server stopped.
>
> 15:09:34 IBM Informix Dynamic Server Stopped.
>
> 15:09:34 mt_shm_remove: WARNING: may not have removed all/correct
> segments


What is system error 48 on HP Tru64 Unix? You may have to grep for 48
in /usr/include/errno.h or /usr/include/sys/errno.h.

However, at a guess, you are attempting to use a network configuration
that isn't supported. Maybe the sqlhosts file says service
humptydumpty and there is no such service, or ... but the meaning of
the error message 48 will help direct your attention.

On MacOS X, error 48 is EADDRINUSE; that would mean that some other
process is already listening on the port your server is trying to
listen on - you've got two instances of IDS trying to listen to the
same port (a complete no-no).

> Please provide me help.


Hit the send key once - not three or more times.

Read http://www.catb.org/~esr/faqs/smart-questions.html


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
NB: Please do not use this email for correspondence - I don't read it
every week, even.


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
NB: Please do not use this email for correspondence - I don't read it
every week, even.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:02 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com