Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    3

    Unanswered: Dies occasionally informix 7.31

    Hi, my informix 7.31 TD5 dies occasionally an returns.

    Informix Dynamic Server Version 7.31.TD5 -- On-Line -- Up 1 days 08:00:38 -- 333440 Kbytes

    Message Log File: c:\informix\ol_serverimqc.log
    15:43:55 Checkpoint Completed: duration was 0 seconds.
    15:43:55 Checkpoint loguniq 3246, logpos 0x1649018

    15:48:55 Checkpoint Completed: duration was 0 seconds.
    15:48:55 Checkpoint loguniq 3246, logpos 0x18dc018

    15:49:38 Logical Log 3246 Complete.
    15:53:55 Checkpoint Completed: duration was 0 seconds.
    15:53:55 Checkpoint loguniq 3247, logpos 0x908360

    15:58:55 Checkpoint Completed: duration was 0 seconds.
    15:58:55 Checkpoint loguniq 3247, logpos 0xfc5018

    16:00:19 Assert Failed: No Exception Handler
    16:00:19 Informix Dynamic Server Version 7.31.TD5
    16:00:19 Who: Session(2, informix@, 0, 0)
    Thread(7, soctcppoll, 0, 14)
    Exception at Addr: 0x7c8224b2, TOS: 0x102758e4, FP:0xdb0a18, Exc: c0000005
    16:00:19 Results: Exception Caught. Type: MT_EX_OS, Context: mem
    16:00:19 Action: Please notify Informix Technical Support.


    Informix Dynamic Server Version 7.31.TD5 -- On-Line -- Up 1 days 08:00:38 -- 333440 Kbytes

    Stack for thread: 7 soctcppoll
    base: 0x10270000
    len: 24576
    pc: 0x006a5bae
    tos: 0x10275dd4
    state: running
    vp: 14

    0x006e63f0 (oninit)_NT_PollCreateWindow(0x10275e98, 0x10275e48, 0x6e63f0, 0x170114)
    0x10062668 (***nosymtab***)0x10062668
    Changing data structure forced command termination.


    C:\informix\bin\onstat -g ses 2:

    Informix Dynamic Server Version 7.31.TD5 -- On-Line -- Up 1 days 08:00:39 -- 333440 Kbytes

    session #RSAM total used
    id user tty pid hostname threads memory memory
    2 informix - 0 - 0 8192 5744

    Memory pools count 1
    name class addr totalsize freesize #allocfrag #freefrag
    2 V 10258018 8192 2448 9 1

    name free used name free used
    overhead 0 120 scb 0 96
    gentcb 0 576 ostcb 0 40
    sqscb 0 4864 fragman 0 48


    What´s the problem?
    Thanks.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    good question!!! (lol) ...

    copy here your onconfig to get more information...

    if you can, upgrade to 7.31 TD9 or my personal suggestion: go to Unix/Linux, works better is more faster than windows....
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Nov 2007
    Posts
    3
    Informix Dynamic Server Version 7.31.TD5 -- On-Line -- Up 3 days 22:12:23 -- 341632 Kbytes

    Configuration File: C:\informix/etc/ONCONFIG.ol_serverimqc
    #************************************************* *************************
    #
    # INFORMIX SOFTWARE, INC.
    #
    # Title: onconfig.std
    # Description: Informix Dynamic Server Configuration Parameters
    #
    #************************************************* *************************

    # Root Dbspace Configuration

    ROOTNAME rootdbs # Root dbspace name
    ROOTPATH c:\datos\IFMXDATA\ol_serverimqc\rootdbs_dat.000 # Path for device containing root dbspace
    ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
    ROOTSIZE 1024000 # Size of root dbspace (Kbytes)

    # Disk Mirroring Configuration Parameters

    MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
    MIRRORPATH # Path for device containing mirrored root
    MIRROROFFSET 0 # Offset into mirrored device (Kbytes)

    # Physical Log Configuration

    PHYSDBS rootdbs # Location (dbspace) of physical log
    PHYSFILE 100000 # Physical log file size (Kbytes)

    # Logical Log Configuration

    LOGFILES 20 # Number of logical log files
    LOGSIZE 60000 # Logical log size (Kbytes)
    LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)

    # Diagnostics

    MSGPATH c:\informix\ol_serverimqc.log # System message log file path
    CONSOLE c:\informix\conol_serverimqc.log # System console message path
    ALARMPROGRAM # Alarm program path

    # System Diagnostic Script.
    # SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
    # c:\informix\etc\evidence.bat.) Set this parameter
    # if you want a different Diagnostic Script than
    # {INFORMIXDIR}\etc\evidence.bat, which is default.

    # System Archive Tape Device

    TAPEDEV C:\COPIAS\INFORMIX\archive
    #TAPEDEV NULL
    #TAPEDEV \\.\TAPE0 # Tape device path
    TAPEBLK 16 # Tape block size (Kbytes)
    TAPESIZE 100000240 # Maximum amount of data to put on tape (Kbytes)

    # Log Archive Tape Device

    LTAPEDEV C:\COPIAS\INFORMIX\logs
    #LTAPEDEV NULL
    #LTAPEDEV \\.\TAPE1 # Log tape device path
    LTAPEBLK 16 # Log tape block size (Kbytes)
    LTAPESIZE 100000240 # Max amount of data to put on log tape (Kbytes)

    # Optical

    STAGEBLOB # Informix Dynamic Server/Optical staging area
    OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL

    # System Configuration

    SERVERNUM 0 # Unique id corresponding to a server instance
    stance
    DBSERVERNAME ol_serverimqc # Name of default Dynamic Server
    DBSERVERALIASES db_serverimqc # List of alternate dbservernames

    NETTYPE onsoctcp,1,,NET # Override sqlhosts nettype parameters
    #digital NETTYPE onsoctcp,2,200,NET # Override sqlhosts nettype parameters

    DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.

    RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
    #digital RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
    MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
    NUMCPUVPS 8 # Number of user (cpu) vps
    SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one

    NOAGE 0 # Process aging
    AFF_SPROC 0 # Affinity start processor
    AFF_NPROCS 0 # Affinity number of processors

    # Shared Memory Parameters
    LOCKS 80000 # Maximum number of locks
    BUFFERS 60000 # Maximum number of shared buffers

    #digital LOCKS 40000 # Maximum number of locks
    #digital BUFFERS 10000 # Maximum number of shared buffers
    NUMAIOVPS 1 # Number of IO vps
    #digital NUMAIOVPS 2 # Number of IO vps

    PHYSBUFF 32 # Physical log buffer size (Kbytes)
    LOGBUFF 32 # Logical log buffer size (Kbytes)

    #digital PHYSBUFF 64 # Physical log buffer size (Kbytes)
    #digital LOGBUFF 64 # Logical log buffer size (Kbytes)
    LOGSMAX 20 # Maximum number of logical log files
    CLEANERS 50 # Number of buffer cleaner processes
    #digital CLEANERS 7 # Number of buffer cleaner processes
    SHMBASE 0xC000000L # Shared memory base address
    SHMVIRTSIZE 32768 # initial virtual shared memory segment size
    SHMADD 8192 # Size of new shared memory segments (Kbytes)
    SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
    CKPTINTVL 300 # Check point interval (in sec)
    LRUS 50 # Number of LRU queues
    LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
    LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
    LTXHWM 50 # Long transaction high water mark percentage
    LTXEHWM 60 # Long transaction high water mark (exclusive)
    TXTIMEOUT 300 # Transaction timeout (in sec)
    STACKSIZE 32 # Stack size (Kbytes)

    # System Page Size
    # BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
    # To determine the page size used by Dynamic Server on your platform
    # see the last line of output from the command, 'onstat -b'.


    # Recovery Variables
    # OFF_RECVRY_THREADS:
    # Number of parallel worker threads during fast recovery or an offline restore.
    # ON_RECVRY_THREADS:
    # Number of parallel worker threads during an online restore.

    OFF_RECVRY_THREADS 10 # Default number of offline worker threads
    ON_RECVRY_THREADS 1 # Default number of online worker threads

    # Data Replication Variables
    # DRAUTO: 0 manual, 1 retain type, 2 reverse type
    DRAUTO 0 # DR automatic switchover
    DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
    DRTIMEOUT 30 # DR network timeout (in sec)
    DRLOSTFOUND \tmp # DR lost+found file path

    # CDR Variables
    CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
    CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
    CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
    CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
    CDR_LOGDELTA 30 # % of log space allowed in queue memory
    CDR_NUMCONNECT 16 # Expected connections per server
    CDR_NIFRETRY 300 # Connection retry (seconds)
    CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)

    # Backup/Restore variables
    BAR_ACT_LOG c:\informix\bar_ol_serverimqc.log #Path of log file for onbar.exe
    BAR_MAX_BACKUP 0
    BAR_RETRY 1
    BAR_NB_XPORT_COUNT 10
    BAR_XFER_BUF_SIZE 15
    BAR_BSALIB_PATH c:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL

    RESTARTABLE_RESTORE ON #To support restartable restore..values on/off

    # Informix Storage Manager variables
    ISM_DATA_POOL ISMData
    ISM_LOG_POOL ISMLogs

    # Read Ahead Variables
    RA_PAGES # Number of pages to attempt to read ahead
    RA_THRESHOLD # Number of pages left before next group

    # DBSPACETEMP:
    # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
    # that the Dynamic Server SQL Engine will use to create temp tables etc.
    # If specified it must be a colon separated list of dbspaces that exist
    # when the Dynamic Server system is brought online. If not specified, or if
    # all dbspaces specified are invalid, various ad hoc queries will create
    # temporary files in /tmp instead.

    DBSPACETEMP temporal # Default temp dbspaces

    # DUMP*:
    # The following parameters control the type of diagnostics information which
    # is preserved when an unanticipated error condition (assertion failure) occurs
    # during Dynamic Server operations.
    # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

    DUMPDIR \tmp # Preserve diagnostics in this directory
    DUMPSHMEM 1 # Dump a copy of shared memory
    DUMPGCORE 0 # Dump a core image using 'gcore'
    DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
    Server)
    DUMPCNT 1 # Number of shared memory or gcore dumps for
    # a single user's session

    FILLFACTOR 90 # Fill factor for building indexes

    # method for Dynamic Server to use when determining current time
    USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)

    # Parallel Database Queries (pdq)
    MAX_PDQPRIORITY 0 # Maximum allowed pdqpriority
    DS_MAX_QUERIES 32 # Maximum number of decision support queries
    DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
    DS_MAX_SCANS 1048576 # Maximum number of decision support scans
    DATASKIP # List of dbspaces to skip

    # OPTCOMPIND
    # 0 => Nested loop joins will be preferred (where
    # possible) over sortmerge joins and hash joins.
    # 1 => If the transaction isolation mode is not
    # "repeatable read", optimizer behaves as in (2)
    # below. Otherwise it behaves as in (0) above.
    # 2 => Use costs regardless of the transaction isolation
    # mode. Nested loop joins are not necessarily
    # preferred. Optimizer bases its decision purely
    # on costs.
    OPTCOMPIND 2 # To hint the optimizer

    ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
    LBU_PRESERVE 0 # Preserve last log for log backup
    OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

    # HETERO_COMMIT (Gateway participation in distributed transactions)
    # 1 => Heterogeneous Commit is enabled
    # 0 (or any other value) => Heterogeneous Commit is disabled
    HETERO_COMMIT 0

    # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
    OPT_GOAL -1

    # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
    DIRECTIVES 1

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Theoretically that is ok .
    Just a some notes:
    - I presume your machine have 8 physical processor, it's right ?
    - Configure you CPUVPs with a value equal or less a amount of physical CPUs.
    If the machine have 2 CPUs, work with 1 or 2 CPUVP .
    - Set a value to all fields, like: NETTYPE onsoctcp,1,30,NET
    - NUMAIOVPs = 1 is terrible... at least 4 , the right calc is 2 CPUVPs for at chunk ( 10 chunks = 20 AIOVPs )

    I think that two config maybe can related with your crashs. CPUVPs and NETTYPE.
    Sorry... three .... your Windows too..


    I'm sorry not help more... but this is the only thinks I really see a big problem to your instance.

    Another vantages to migrate a Linux SO:
    - Linux is Free!
    - You can use a KERNEL I/O . Its very fast!
    - More reliable
    - More stable..
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  5. #5
    Join Date
    Nov 2007
    Posts
    3
    Thank´s I will try to change those values.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •