NEED HELP WITH INFORMIX ONLINE
Posted in 1995
Topics: High Availability & Replication, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL
Hello out there,
i need help with an informix-problem that takes all my energies for
about more than one week. We have to realize a project that uses
INFORMIX-ONLINE. We are using the following releases of INFORMIX for
development..
INFORMIX ESQL/C V7.1B00
INFORMIX ONLINE DYNAMIC SERVER V7.1B00
INFORMIX DEVELOPMENT SYSTEM V6.0B00
The platform we use is a SNI-RM600.
The problem looks as following:
I have an application which has to read data from two different
tables, and afterwards write data into a third table. For
database-access we use a library which can perform sql-statements that
are generated at the runtime of the application. When i start the
appliation it works good until it reaches the insert statement. The
sqlca.sqlcode has a value of -404 after trying to perform the insert
statement ($execute ......). In the logfile of the database are the
following statements.
18:38:29 Pool = 0xaa02010, Pool name = 4, Blkhdr = 0xab0b27c
18:38:29 Block magic is 13, expecting 13
18:38:29 Possible memory block trailer corruption
18:38:29 mtshpool.c, line 2536, thread 36, proc id 2698, ConditionFailed (CHEC
K_ALLOC_BLOCK), In (mt_shm_free)
Thread(36, sqlexec, 0, 1).
18:38:29 PANIC: Attempting to bring system down
and then INFORMIX-ONLINE is gone (Means that all 'oninit'-processes
are down).
I would be very pleased at your tips (ASAP). Please contact me via
e-mail.
Thank you
-----------------------------------------------------------------------------------------
Name: Peter Unmuth
Company: SIEMENS AG OESTERREICH PSE IB222
Gudrunstrasse 11
A-1100 VIENNA
AUSTRIA
EUROPE
Tel: +43/1/60171-5434
Fax: +43/1/60171-5662
X400-Adress: [/C=AT/A=ADA/P=SCN/O=SIEMENS/OU1=VIE5/OU2=PSE OE/OU3=IB2/G=Peter/S=Unmuth/]
E-Mail: peter.unmuth@banyan.siemens.co.at
Banyan.Vines: Peter Unmuth@IB2@PSE OE
-----------------------------------------------------------------------------------------
TOSHROTAPOV - (The opinions stated here represent only the author's point of view.)