Save 
Join IIUG
 for   
 

Informix News
29 July 09 - Wall Street Journal - IBM to Acquire SPSS, Adding to Acquisitions... Read
11 February 09 - InformationWeek - IBM Drifts Slowly Toward Mainstream Cloud Computing... Read
11 February 09 - CNNMoney.com - IBM to Deliver Software via Cloud Computing With Amazon Web Services... Read
07 January 09 - Huliq News - IBM Power Servers Helps Bank of Chengdu Build Up Core Banking System.. Read
04 December 08 - Steeleye - Multicarta achieves 99.997% uptime for its Informix-based Credit Card Authorization Centre... Read
16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read
14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read

End of Support Dates
IDS 7.31 - 30 Sep 2009
IDS 9.40 - 30 Apr 2009
IDS 10.00 - 30 Sep 2010
Subscribe to notifications

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

IDS 11.50 Crashing

Posted By: VIKAS HIVARKAR
Date: Thursday, 2 July 2009, at 4:40 a.m.

Hi,

IDS 11.50.FC4 on Solaris 10

We migrated out test instance from IDS 11.10.FC3 to 11.50.FC4.
After changing the softlinks and copying the onconfig and sqlhosts the new instance was started simply with "oninit -v".

I could not see any error while the conversion process and the end lines were
"Conversion Completed Successfully"
"On-Line Mode"

I did a level 0 backup, rebooted the instance two time and every thing was looking good untill aftersome time, I found that the instance went down.

The online.log shows

12:27:35 stack trace for pid 10196 written to /opt/informix/lt3/dump/af.3f53a17
12:27:35 Assert Failed: No Exception Handler
12:27:35 IBM Informix Dynamic Server Version 11.50.FC4
12:27:35 Who: Session(1, informix@cseloukdudb05, 0, 1689fe028)

Thread(13, main_loop(), 1689bb028, 1)

File: mtex.c Line: 491
12:27:35 Results: Exception Caught. Type: MT_EX_OS, Context: mem
12:27:35 Action: Please notify IBM Informix Technical Support.
12:27:35 See Also: /opt/informix/lt3/dump/af.3f53a17
12:27:39 mtex.c, line 491, thread 13, proc id 10196, No Exception Handler.
12:27:39 Assert Failed: Page Check Error in rsread:bad data page
12:27:39 IBM Informix Dynamic Server Version 11.50.FC4
12:27:39 Who: Session(24, informix@, 0, 168a059e0)

Thread(79, dbWorker1, 1689cec08, 3)

File: rsdebug.c Line: 1080
12:27:39 Results: Possible inconsistencies in 'sysadmin:"informix".sysprocbody'
12:27:39 Action: Run 'oncheck -cD 1048770'
12:27:39 stack trace for pid 10198 written to /opt/informix/lt3/dump/af.4373a1b
12:27:39 The Master Daemon Died
12:27:39 See Also: /opt/informix/lt3/dump/af.4373a1b
12:27:39 SCHAPI: Error -397 System catalog (sysprocbody) corrupted.
12:27:39 SCHAPI: Type: TASK, Name: post_alarm_message, Location: NULL.
12:27:39 SCHAPI: Error -105 ISAM error: bad isam file format.
12:27:39 SCHAPI: Type: TASK, Name: post_alarm_message, Location: NULL.
12:27:39 SCHAPI: Error -7530 Missing parenthesis in the signature specified for user-defined routine lookup
12:27:39 SCHAPI: Type: TASK, Name: post_alarm_message, Location: NULL.
12:27:39 SCHAPI: Error -105 ISAM error: bad isam file format.
12:27:39 SCHAPI: Type: TASK, Name: post_alarm_message, Location: NULL.
12:27:39 SCHAPI: Type: TASK, Name: post_alarm_message, Error Message: Unable to find function[ procedure ph_dbs_alert ] .
12:27:39 PANIC: Attempting to bring system down
14:44:41 IBM Informix Dynamic Server Started.
14:44:41 Requested shared memory segment size rounded from 1517568KB to 1540096KB
14:44:41 Shared memory segment will use large pages with intimate shared memory (ISM) if available
14:44:42 Segment locked: addr=10a000000, size=1577058304

The effords to take instance up (oninit) failed with error:

14:57:12 IBM Informix Dynamic Server Version 11.50.FC4 Software Serial Number AAA#B000000
14:57:12 Logical Log File not found.
14:57:12 oninit: Fatal error in shared memory initialization

14:57:12 IBM Informix Dynamic Server Stopped.

14:57:12 mt_shm_remove: WARNING: may not have removed all/correct segments

I checked for "ipcs |grep informix" and did "onmode -ky" 2 times but of no use.
The logfile and other file permissions were intact and nothing seems to be changed externally.

I restored the instance with the level 0 backup and took it online and runned UPDATE STATISTICS on every database, again every thing looked good untill today morning when i started another leve 0 backup which failed and instance crashed.

The online.log now shows

09:56:09 Level 0 Archive started on rootdbs, physdbs, logdbs, datadbs2, datadbs8
09:56:10 Assert Warning: Archive detects that page 1:13 is corrupt.
09:56:10 IBM Informix Dynamic Server Version 11.50.FC4
09:56:10 Who: Session(31, informix@cseloukdudb05, 10585, 168a06ea8)

Thread(236, arcbackup1, 1689d04f8, 3)

File: rsarcbu.c Line: 3819
09:56:10 stack trace for pid 15153 written to /opt/informix/lt3/dump/af.4d4681a
09:56:10 See Also: /opt/informix/lt3/dump/af.4d4681a
09:56:11 Archive detects that page 1:13 is corrupt.
09:56:11 Assert Warning: Archive detects that page 1:14 is corrupt.
09:56:11 IBM Informix Dynamic Server Version 11.50.FC4
09:56:11 Who: Session(31, informix@cseloukdudb05, 10585, 168a06ea8)

Thread(236, arcbackup1, 1689d04f8, 3)

File: rsarcbu.c Line: 3819
09:56:11 stack trace for pid 15153 written to /opt/informix/lt3/dump/af.4d4681a
09:56:11 See Also: /opt/informix/lt3/dump/af.4d4681a
09:56:11 Archive detects that page 1:14 is corrupt.
09:56:11 Assert Warning: Archive detects that page 1:15 is corrupt.
09:56:11 IBM Informix Dynamic Server Version 11.50.FC4
09:56:11 Who: Session(31, informix@cseloukdudb05, 10585, 168a06ea8)

Thread(236, arcbackup1, 1689d04f8, 3)

File: rsarcbu.c Line: 3819
09:56:11 stack trace for pid 15153 written to /opt/informix/lt3/dump/af.4d4681a
09:56:11 See Also: /opt/informix/lt3/dump/af.4d4681a
09:56:11 Archive detects that page 1:15 is corrupt.
09:56:12 Assert Warning: Archive detects that page 1:16 is corrupt.
09:56:12 IBM Informix Dynamic Server Version 11.50.FC4
09:56:12 Who: Session(31, informix@cseloukdudb05, 10585, 168a06ea8)

Thread(236, arcbackup1, 1689d04f8, 3)

File: rsarcbu.c Line: 3819
.
.
.

I checked the kernel parameters from machine notes can could not see any change.

Any Help on this is appriciated

Regards
Vikas

Messages In This Thread

  • IDS 11.50 Crashing
    VIKAS HIVARKAR -- Thursday, 2 July 2009, at 4:40 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.