IDS Forum

Re: Storage Area Network Fails for Unix/Netware

Posted By: PEter
Date: Thursday, 31 May 2007, at 4:26 p.m.

In Response To: Re: Storage Area Network Fails for Unix/Netware (CHARLES KIRBY)

CHARLES KIRBY wrote:
> 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)
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Are all your filesystems on the SAN ? I mean your standard linux
filesytems as well not just your dbspaces/chunks?
Do you have any applications next to IDS doing any I/O on the SAN disks ?

To do a simple test ... just do a dd or cp to a location on one of
your SAN filesystem and change the channels on the HBA card...If that
fails then you know you have an I/O issue during channel switch of the
fibre controller and which is mostlikely an linux kernel /driver issue..

If not then from the top of my head....there is a setting the $ONCONFIG
where you can instruct IDS what to do when a chunk gets offline
...(could be wrong for version 9.xx though ))

HTH,

Peter

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.