IDS Forum

Re: Storage Area Network Fails for Unix/Netware

Posted By: CHARLES KIRBY
Date: Thursday, 31 May 2007, at 3:55 p.m.

In Response To: Re: Storage Area Network Fails for Unix/Netware (Peter van Eck)

Here we are... more than enough information in the online.log;
Certainly, you can see it lost contact with the logical logs drive space:

I wonder if Informix is overly quick to declare a dbspace off limits? Perhaps the time it takes for SecurePath to flip still isn't adequate for Informix!

BTW: dbspaces are created in a tyical fashion, and linked with soft links.

02:40:54 Maximum server connections 42
08:44:10 Assert Warning: I/O error, Primary Chunk '/opt/informix/links/nysd/llog_db1' -- Offline
08:44:10 IBM Informix Dynamic Server Version 9.40.UC8
08:44:10 Who: Session(19694, root@nysdlei2.nysd.circ2.dcn, 13784, 0x5aaf6df8)

Thread(19759, sqlexec, 5aace930, 1)

File: rsbuff.c Line: 4742
08:44:10 Results: Chunk is now unusable
08:44:10 Action: Repair and restore from mirror or archive
08:44:10 stack trace for pid 3206 written to /var/log/informix/af.51172a2a
08:44:10 See Also: /var/log/informix/af.51172a2a
08:44:13 I/O error, Primary Chunk '/opt/informix/links/nysd/llog_db1' -- Offline
08:44:14 Assert Failed: INFORMIX-OnLine Must ABORT

Critical media failure.
08:44:14 IBM Informix Dynamic Server Version 9.40.UC8
08:44:14 Who: Session(19694, root@nysdlei2.nysd.circ2.dcn, 13784, 0x5aaf6df8)

Thread(19759, sqlexec, 5aace930, 3)

File: rsmirror.c Line: 1812
08:44:14 stack trace for pid 3208 written to /var/log/informix/af.51172a2a
08:44:14 See Also: /var/log/informix/af.51172a2a
08:44:23 rsmirror.c, line 1812, thread 19759, proc id 3208, INFORMIX-OnLine Must ABORT

Critical media failure..
08:44:23 Fatal error in ADM VP at mt.c:12419
08:44:23 Unexpected virtual processor termination, pid = 3208, exit = 0x100

08:44:24 PANIC: Attempting to bring system down
08:44:24 semctl: errno = 22

08:44:24 semctl: errno = 22

ROOTNAME rootdbs # Root dbspace name
ROOTPATH /opt/informix/links/nysd/root_db1
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 600000 # Size of root dbspace (Kbytes)

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

LOGFILES 16 # Number of logical log files
LOGSIZE 10000 # Logical log size (Kbytes)

SERVERNUM 10 # Unique id corresponding to a OnLine instance
DBSERVERNAME nysd_ecf # List of alternate dbservernames
DBSERVERALIASES nysd_shm # Name of default database server
NETTYPE soctcp,2,128,CPU # Configure poll thread(s) for nettype
NETTYPE ipcshm,1,128,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 3 # 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

LOCKS 550000 # Maximum number of locks
BUFFERS 150000 # Maximum number of shared buffers
NUMAIOVPS 32 # Number of IO vps
PHYSBUFF 90 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
CLEANERS 16 # Number of buffer cleaner processes
SHMBASE 0x44000000 # Shared memory base address
SHMVIRTSIZE 128000 # initial virtual shared memory segment size
SHMADD 64000 # Size of new shared memory segments (Kbytes)
SHMTOTAL 1200000 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 1800 # Check point interval (in sec)
LRUS 128 # Number of LRU queues
LRU_MAX_DIRTY 2.000000 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1.000000 # LRU percent dirty end cleaning limit
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)

Messages In This Thread

• Storage Area Network Fails for Unix/Netware
  CHARLES KIRBY -- Thursday, 31 May 2007, at 10:31 a.m.
  • Re: Storage Area Network Fails for Unix/Netware
    Obnoxio The Clown -- Thursday, 31 May 2007, at 11:34 a.m.
    • Re: Storage Area Network Fails for Unix/Netware
      CHARLES KIRBY -- Thursday, 31 May 2007, at 1:13 p.m.
      • Re: Storage Area Network Fails for Unix/Netware
        Obnoxio The Clown -- Thursday, 31 May 2007, at 1:16 p.m.
  • Re: Storage Area Network Fails for Unix/Netware
    TILMAN MODEL-BOSCH -- Thursday, 31 May 2007, at 1:11 p.m.
    • Re: Storage Area Network Fails for Unix/Netware
      CHARLES KIRBY -- Thursday, 31 May 2007, at 1:30 p.m.
      • Re: Storage Area Network Fails for Unix/Netware
        Peter van Eck -- Thursday, 31 May 2007, at 2:00 p.m.
        • Re: Storage Area Network Fails for Unix/Netware
          CHARLES KIRBY -- Thursday, 31 May 2007, at 3:55 p.m.
          • Re: Storage Area Network Fails for Unix/Netware
            PEter -- Thursday, 31 May 2007, at 4:26 p.m.
  • Re: Storage Area Network Fails for Unix/Netware
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Friday, 1 June 2007, at 8:16 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.