Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Assert Failed: semop: errno = 22

    Posted 04/25/23 06:49 AM

    Greetings.

    I have a customer who is running the Innovator-C edition:
    IBM Informix Dynamic Server Version 14.10.FC9W1IE -- On-Line -- Up 00:20:31 -- 8388608 Kbytes
    Running on Ubuntu 22.04.2 LTS Server

    The engine had been running without a glitch for over a month when they had to reboot everything due to power failure this morning.
    After running normally for about 40 minutes it crashed:

    2023-04-25 09:41:20.245  Assert Failed: semop: errno = 22

    2023-04-25 09:41:20.246  Assert Failed: semop: errno = 22

    2023-04-25 09:41:20.246  IBM Informix Dynamic Server Version 14.10.FC9W1IE
    2023-04-25 09:41:20.246   Who: Session(112, timd@REY, 2480, 0x471bd2a8)
                    Thread(137, sqlexec, 4717d150, 8)
                    File: mt_fn.c Line: 1533
    2023-04-25 09:41:20.246  stack trace for pid 1393 written to /opt/informix/tmp/af.471a03f
    2023-04-25 09:41:20.247  IBM Informix Dynamic Server Version 14.10.FC9W1IE
    2023-04-25 09:41:20.247   Who: Thread(0, idle, 0, 17)
                    File: mt_fn.c Line: 1653
    2023-04-25 09:41:20.247  stack trace for pid 1402 written to /opt/informix/tmp/af.11a03f
    2023-04-25 09:41:20.260   See Also: /opt/informix/tmp/af.11a03f
    2023-04-25 09:41:20.314   See Also: /opt/informix/tmp/af.471a03f

    I suspect the Assert Failed: semop: errno = 22 is the root cause for this. 
    All SHMEM and SEM paramaters are OK.

    Does anyone know what might cause this? Apparently 22 is "invalid argument"

    Best regards,
    -Snorri



    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: Assert Failed: semop: errno = 22

    Posted 04/25/23 12:52 PM

    This was 

    IT38242: REMOVEIPC TO BE SET TO NO IN /ETC/SYSTEMD/LOGIND.CONF OTHERWISE IPC RESOURCES MAY BE REMOVED CAUSING INSTANCE FAILURE



    ------------------------------
    Snorri Bergmann
    ------------------------------