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. ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| 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. |
| |||
| 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 |
| ||||
| 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. |
| Thread Tools | |
| Display Modes | |
|
|