Hello there,

I have a problem with IDS 9.21.UC2, OPENSERVER 5.0.7:

Now and then the machine is crashing with the online.log-message:

Assert Failed: Mutex Holder Value is not Null
Who: Session(7592, ...(User)..., 1348, -1166998708)
Thread(8152, sqlexec, b713c634, 1)
File: mt.c Line: 7049
stack trace for pid 459 written to /tmp/af.23c0ebef
See Also: /tmp/af.23c0ebef, shmem.23c0ebef.0

Here's the stack to one of the crashes written in the af-File:

0xba4b69b4 (*nosymtab*)0xba4b69b4(0xb7990140, 0x88701e1, 0x8860878, 0xb7781e50)
0x0857a768 (oninit)afhandler(0x3, 0xba4bbd90, 0x0, 0x0)
0x0857a25c (oninit)afcrash_interface(0xba4bbd90, 0x0, 0x0, 0x8822c00)
0x0855ba3f (oninit)mt_free_mutex(0xb7781e50, 0x0, 0xba4b6f70, 0x80e94b5)
0x080e7b71 (oninit)sapi_destroy_mem(0xb7a88f90, 0x887fb38, 0xb7a7b018, 0x0)
0x080e94b5 (oninit)remove_curmem(0x1e1, 0x887fb38, 0x4, 0xa)
0x082cceda (oninit)close_cursor(0xba4b6ff8, 0x83278d7, 0x8870038, 0xa)
0x082ccba6 (oninit)sq_close(0x0, 0x0, 0x0, 0x0)
0x0856213a (oninit)startup (0xffffffff, 0xba500000, 0xba4a6000, 0xfe8)
0x00000000 (*nosymtab*)0x0


I already read that this could be because the instance is having problems freeing the cache and that it could help to run oncheck -cI resp. -cD on the
tables that were accessed to in the moment on the crash. Also it should help
to rebuild the indexes of the tables affected.

Problem is, that this version is out-of-support at IBM and there are no new versions available for this platform, so I won't be able to have the SHM-Dump analysed.

Anybody got a clue what causes this problem or how it could be fixed?

Thanks in advance.

Hard to say the cause.
I don't believed this can help , but, try disable the Statment Cache ( STMT_CACHE , onmode -e off).
I know there are some bug with them on the IDS 9.4

Check all configurations of Semaphores on your O.S.

This situation occur with how frequency ?
Always on the same table?
Same SQL?
This SQL have PDQ active?

Look for on the documentation I found some bugs with relation the message "Mutex Holder Value is not Null", but all are relation with PDQ, SBLOB, Replication.
do you use anything? PDQ, SBLOB, Replication?

Thanks for your reply, but I'm not sure if disabling the statement cache is an option because this would cause a performance problem, would it not?
These crashes just occur very infrequently, one time 4 months ago, but two times last week. Perhaps it would take months before and if this happens again.
There are always other tables involved and the statements were always different.
As for the semaphores, PDQ, SBLOB, Replication, I am not sure and will check it out.
Where can I find the doumentation you were talking about? Something related to IDS 9.21 and not to 9.40 perhaps ?
I know this version is out of support, but switching to another would mean to switch to another OS as well.