suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT32526 Status: Closed

QUERYING DATA FROM SYSMASTER:SYSCONBLOCK GENERATES ASSERT FAILURE

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
Executing below query on sysmaster:sysconblock causes assert
failure:

> echo "select * from sysconblock" | dbaccess sysmaster
Database selected.
No rows found.
Database closed.

Which generates log as below

> onstat -m
IBM Informix Dynamic Server Version 14.10.FC3DE -- On-Line -- Up
64 days 01:49:09 -- 256508 Kbytes
Message Log File:
/informixdir/tmp/online.log
03/31/20 16:36:04 Tue Mar 31 - loguniq 168, logpos 0x526018,
timestamp: 0xdf303a Interval: 10773
03/31/20 16:36:04 Maximum server connections 3
03/31/20 16:36:04 Checkpoint Statistics - Avg. Txn Block Time
0.000, # Txns blocked 0, Plog used 7, Llog used 2
03/31/20 16:41:04 Checkpoint Completed: duration was 0 seconds.
03/31/20 16:41:04 Tue Mar 31 - loguniq 168, logpos 0x589018,
timestamp: 0xdf39c0 Interval: 10774
03/31/20 16:41:04 Maximum server connections 3
03/31/20 16:41:04 Checkpoint Statistics - Avg. Txn Block Time
0.000, # Txns blocked 0, Plog used 342, Llog used 99
03/31/20 16:49:53 Assert Failed: Condition Failed (Bad
allocation size (0) for pool 'mt' (0x44ffe040)), In
(mt_shm_malloc_segid)
03/31/20 16:49:53 IBM Informix Dynamic Server Version
14.10.FC3DE
03/31/20 16:49:53  Who: Session(374, informix@hostname, 25688,
0x45fbf988)
               Thread(6871, sqlexec, 45f7a548, 1)
               File: mtshpool.c Line: 4710
03/31/20 16:49:53  Action: Please notify IBM Informix Technical
Support.
03/31/20 16:49:53 stack trace for pid 30514 written to
/informixdir/tmp/af.1ebf5890
03/31/20 16:49:53  See Also:
/informixdir/tmp/af.1ebf5890, shmem.1ebf5890.0
03/31/20 16:49:59 Condition Failed (Bad allocation size (0) for
pool 'mt' (0x44ffe040)), In (mt_shm_malloc_segid)

Assert Failure file contains the following stack:

afstack
afhandler
affail_interface
mem_asfail
mt_shm_malloc_segid
mt_malloc
mt_realloc
mt_aio_vfprintf
gcv_vfprintf
ex_gcv_print
smi_opexplain
smi_storeexplainflags
prconblock
pstread
rsread
fmread
readseq_single
gettupl
scan_next
getrow
fetchrow
exfetch
sql_nfetch
sq_nfetch
sqmain
spawn_thread
th_init_initgls
startup
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC4.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 14.10.xC4.                         *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC4.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 14.10.xC4.                         *
****************************************************************
Comment
Fixed in Informix Server 14.10.xC4.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.04.2020
09.06.2020
09.06.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download