sql_listener: ASF_LISTEN failed
Posted in 2007
Topics: General Discussion
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/correctsegments
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
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape