Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

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

IDS Forum

RE: Assert Failed: Physical log recovery error

Posted By: david@smooth1.co.uk
Date: Wednesday, 16 July 2014, at 3:10 a.m.

In Response To: RE: Assert Failed: Physical log recovery error (Knox, Ernest)

Also check the os errorlog for any disk read errors.

David.

> On 16 July 2014 at 03:26 "Knox, Ernest" <Ernest.Knox@searshc.com> wrote:
>
>
> Yes. We had the EMC rep perform a full appliance scan of the disk and mirr=
> ors. We are rebooting now to see if it clears up.
>
> Thanks,
> ***************************************************************************=
> ***************
> Ernie Knox
> Sr. Technologist, I&TG - Database Management
> Sears Holdings Management Corp
> 3333 Beverly Rd.
> Hoffman Estates, IL. 60179
> Office: (847) 286-5735
> Email: Ernest.Knox@searshc.com
> Blackberry:=A02244650553@messaging.sprintpcs.com
> Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com
> Informix Primary: INFORMIXDBAPrimaryPager@searshc.com
> Informix Secondary: INFORMIXDBASecondaryPager@searshc.com
> MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com
> MySQL Primary: MYSQLDBAPrimaryPager@searshc.com
> MySQL Secondary: MYSQLDBASecondaryPager@searshc.com
>
> For more information, view our DBA Wiki page link below:
> http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen=
> t#DatabaseManagement
>
> For creating SUCCEED and/or CCMDB request, use the link below:
> https://succeed.intra.searshc.com
>
> Have I provided a WOW member experience today?
> Send a Members' First Recognition to this Associate
> Nominate this Associate for a Technology Excellence Award
>
> My Area:
> " Yes we can make a Change! "
> " IF you can think it, you can do it! "
> " IT'S always a great day to watch=A0Sports: FOOTBALL "
> GSU
> MISSION:
> " The focus of my life begins at home with family, loved ones, and friends.=
> =A0 I want to use my resources to create a
> secure environment that fosters love, learning, laughter, and mutual succes=
> s.=A0 I will protect and value integrity.=A0 I
> will admit and quickly correct my mistakes.=A0 I will be a self-starter.=A0=
> I will be a caring person.=A0 I will be a good listener
> with an open mind.=A0 I will continue to grow and learn.=A0 I will facilita=
> te and celebrate the success of others. "
> ***************************************************************************=
> ***************
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art K=
> agel
> Sent: Tuesday, July 15, 2014 10:23 PM
> To: ids@iiug.org
> Subject: Re: Assert Failed: Physical log recovery error [33398]
>
> Ernie:=20
>
> Have you tried to start it up again?=20
>
> Art
> On Jul 15, 2014 9:07 PM, "Knox, Ernest" <Ernest.Knox@searshc.com> wrote:=20
>
> > Need assistance on recovering physical log file:=20
> >=20
> > OS: HP Release B.11.11 / HP-UX
> > IDS: 9.40.HC6X1
> >=20
> > 20:31:33 IBM Informix Dynamic Server Started.=20
> > 20:31:33 Could not create single shared memory segment with resident=20
> > and non-resident par titions. Proceeding to create 2 shared memory=20
> > segments instead.
> > 20:31:38 Segment locked: addr=3D0x82e61000, size=3D970039296
> >=20
> > Tue Jul 15 20:31:40 2014
> >=20
> > 20:31:40 Event alarms enabled. ALARMPROG =3D '/informix/etc/log_full.sh'=
> =20
> > 20:31:40 Booting Language <c> from module <>
> > 20:31:40 Loading Module <CNULL>
> > 20:31:40 Booting Language <builtin> from module <>
> > 20:31:40 Loading Module <BUILTINNULL>
> > 20:31:40 Affinitied VP 1 to phys proc 1
> > 20:31:41 Affinitied VP 5 to phys proc 2
> > 20:31:41 Affinitied VP 6 to phys proc 3
> > 20:31:41 Affinitied VP 7 to phys proc 4
> > 20:31:41 Affinitied VP 8 to phys proc 5
> > 20:31:41 Affinitied VP 9 to phys proc 6
> > 20:31:46 Dynamically allocated new message shared memory segment (size
> > 2192KB)
> > 20:31:46 IBM Informix Dynamic Server Version 9.40.HC6X1 Software=20
> > Serial Number
> > AAA#B000000
> > 20:31:50 IBM Informix Dynamic Server Initialized -- Shared Memory=20
> > Initialized.
> >=20
> > 20:31:50 Started 2 btree scanners.=20
> > 20:31:50 Low priority set for the btree scanners.=20
> > 20:31:50 Btree scanner threshold set at 50000.=20
> > 20:31:50 Btree scanner range scan size set at 256000.=20
> > 20:31:50 Physical Recovery Started at Page (2:10642).=20
> > 20:31:50 HPUX Version B.11.11 -> Using flag/select style KAIO
> > 20:31:50 HP KAIO concurrent requests changed from 1000 to 2500
> > 20:32:23 Assert Failed: Physical log recovery error
> > 20:32:23 IBM Informix Dynamic Server Version 9.40.HC6X1
> > 20:32:23 Who: Session(19, informix@gnbwms01, 0, c7849298)
> >=20
> > Thread(63, fast_rec, c7822e48, 7)
> >=20
> > File: rsrecvr.c Line: 804
> > 20:32:23 Results: Physical Recovery Aborted.=20
> > 20:32:23 Action: Retry and/or restore
> > 20:32:23 stack trace for pid 5089 written to
> > /opt/informix/informixdumps/af.427c816
> > 20:32:23 See Also: /opt/informix/informixdumps/af.427c816,=20
> > shmem.427c816.0
> > 20:33:00 Invoking debugger on oninit pid 5089
> > 20:33:00
> >=20
> > Thread(63, fast_rec, 0x00000000, 7)
> > 20:33:00 oninit pid 5089 waiting for debugger
> >=20
> > gnbwms01:KMart PRD:/ifxloglogs>head -50
> > /opt/informix/informixdumps/af.427c816
> > 20:32:23 mt_aio_wait(c7cc5588)
> > 20:32:23 chunkio(4, 0xc82ef400, 0x4df3, 0, 0x1f, -937239576, 524341)=20
> > errno
> > 1
> > AIOREQ *a
> > c829c8ac: 00000000 00000000 00000001 00000000 ........ ........=20
> > c829c8bc: 00000000 00000000 00000000 00000000 ........ ........=20
> > c829c8cc: 00000000 c7cc5758 c7cc53b8 00000000 ......WX ..S.....=20
> > c829c8dc: 00000000 0000133a 41494f72 65710000 .......: AIOreq..=20
> > c829c8ec: 00000000 07d10000 00000000 00000003 ........ ........=20
> > c829c8fc: 00000501 0000000b 00000002 00000001 ........ ........=20
> > c829c90c: 00000000 00000001 c7cc5610 00000000 ........ ..V.....=20
> > c829c91c: 00000001 00000005 00000001 00000000 ........ ........=20
> > c829c92c: 00000000 00000000 ........=20
> > 20:32:23 physrecover: plog page disk read error
> > 20:32:23 physrecover error: current phyoffset 19902, sh_stamp=20
> > 0xeb1cc21e plog
> > 82eee058: 00000000 00000000 00000001 00000000 ........ ........=20
> > 82eee068: 00000000 00000000 00000000 00000000 ........ ........=20
> > 82eee078: 00000000 82eee0a4 c8213770 00000000 ........ .!7p....=20
> > 82eee088: 00000000 000016e5 706c6f67 706c0000 ........ plogpl..=20
> > 82eee098: 00000000 07d10000 00000000 00000000 ........ ........=20
> > 82eee0a8: 00000000 00000000 00000001 00000000 ........ ........=20
> > 82eee0b8: 00000000 00000000 00000000 00000000 ........ ........=20
> > 82eee0c8: 82eee148 82eee058 00000000 00000000 ...H...X ........=20
> > 82eee0d8: 000016e6 706c6f67 63757200 00000000 ....plog cur.....=20
> > 82eee0e8: 07d10000 00000000 00000001 00000000 ........ ........=20
> > 82eee0f8: 00000000 00000000 00000000 00000000 ........ ........=20
> > 82eee108: 00000000 82eee194 82eee36c 00000000 ........ ...l....=20
> > 82eee118: 00000000 00000215 706c6f67 706c0000 ........ plogpl..=20
> > 82eee128: 00000000 07d20000 00000000 00000000 ........ ........=20
> > 82eee138: 913d8000 00000000 00000000 00000000 .=3D...... ........=20
> > 82eee148: 00000000 00000000 00000001 00000000 ........ ........=20
> > 82eee158: 00000000 00000000 00000000 00000000 ........ ........=20
> > 82eee168: 00000000 82eedf44 82eee0a4 00000000 .......D ........=20
> > 82eee178: 00000000 000016e7 706c6f74 68720000 ........ plothr..=20
> > 82eee188: 00000000 07d10000 00000000 00000000 ........ ........=20
> > 82eee198: 00000000 00000000 00000001 00000000 ........ ........=20
> > 82eee1a8: 00000000 00000000 82eedf90 82eee0f0 ........ ........=20
> > 82eee1b8: 00000000 00000000 00000216 706c6f67 ........ ....plog
> > 82eee1c8: 6f746872 00000000 07d20000 00000000 othr.... ........=20
> > 82eee1d8: 00000000 913e8800 00000000 00000000 .....>.. ........=20
> > 82eee1e8: 00000000 82eee0a4 82eee148 00200000 ........ ...H. ..=20
> > 82eee1f8: 00000035 00000002 eb180276 000155cc ...5.... ...v..U.=20
> > 82eee208: 0000295d 00000000 00000000 ..)].... ....=20
> > current page
> > c82fac00: 00061dc9 001352a7 00100090 03ce04a8 ......R. ........=20
> > c82fac10: 0000048b 0000048a 800060a0 000ff91d ........ ..`.....=20
> > c82fac20: 00001089 0f018000 60a10004 1b140000 ........ `.......=20
> > c82fac30: 06451200 00064513 0000066e 1500000d .E....E. ...n....=20
> > c82fac40: 820f0000 10061b00 0010661a 00001339 ........ ..f....9
> > c82fac50: 19000013 3a030000 14540d00 001a381c ....:... .T....8.=20
> >=20
> > Thanks,
> >=20
> >=20
> >=20
> ***************************************************************************=
> ***************=20
> > Ernie Knox
> > Sr. Technologist, I&TG - Database Management Sears Holdings Management=20
> > Corp
> > 3333 Beverly Rd.=20
> > Hoffman Estates, IL. 60179
> > Office: (847) 286-5735
> > Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com>
> > Blackberry:=20
> > 2244650553@messaging.sprintpcs.com<mailto:=20
> > 2244650553@messaging.sprintpcs.com>
> > Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:=
> =20
> > InformixDBA@searshc.com<mailto:InformixDBA@searshc.com>
> > Informix Primary:=20
> > INFORMIXDBAPrimaryPager@searshc.com<mailto:=20
> > INFORMIXDBAPrimaryPager@searshc.com>
> > Informix Secondary:=20
> > INFORMIXDBASecondaryPager@searshc.com<mailto:=20
> > INFORMIXDBASecondaryPager@searshc.com>
> > MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team=
> :=20
> > MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com>
> > MySQL Primary:=20
> > MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.c
> > om>
> > MySQL Secondary:=20
> > MYSQLDBASecondaryPager@searshc.com<mailto:=20
> > MYSQLDBASecondaryPager@searshc.com>
> >=20
> > For more information, view our DBA Wiki page link below:=20
> >=20
> >=20
> >=20
> http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen=
> t#DatabaseManagement=20
> > <
> > http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Mana
> > gement
> > >=20
> >=20
> > For creating SUCCEED and/or CCMDB request, use the link below:=20
> > https://succeed.intra.searshc.com<https://succeed.intra.searshc.com/>
> >=20
> > Have I provided a WOW member experience today?=20
> > Send a Members' First Recognition to this=20
> > Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>
> > Nominate this Associate for a Technology Excellence Award<
> >=20
> http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.=
> aspx=20
> > >=20
> >=20
> > My Area:=20
> > " Yes we can make a Change! "=20
> > " IF you can think it, you can do it! "=20
> > " IT'S always a great day to watch Sports: FOOTBALL "=20
> > GSU
> > MISSION:=20
> > " The focus of my life begins at home with family, loved ones, and=20
> > friends. I want to use my resources to create a secure environment=20
> > that fosters love, learning, laughter, and mutual success.
> > I will protect and value integrity. I will admit and quickly correct=20
> > my mistakes. I will be a self-starter. I will be a caring person. I=20
> > will be a good listener with an open mind. I will continue to grow and=20
> > learn. I will facilitate and celebrate the success of others. "
> >=20
> >=20
> >=20
> ***************************************************************************=
> ***************=20
> >=20
> > This message, including any attachments, is the property of Sears=20
> > Holdings Corporation and/or one of its subsidiaries. It is=20
> > confidential and may contain proprietary or legally privileged=20
> > information. If you are not the intended recipient, please delete it=20
> > without reading the contents. Thank you.
> >=20
> >=20
> >=20
> >=20
> ***************************************************************************=
> ****=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20
> >=20
> >=20
>
> --089e0158b5d47dc9b104fe4632b2=20
>
> ***************************************************************************=
> ****
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
> This message, including any attachments, is the property of Sears Holdings =
> Corporation and/or one of its subsidiaries. It is confidential and may cont=
> ain proprietary or legally privileged information. If you are not the inten=
> ded recipient, please delete it without reading the contents. Thank you.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

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

IDS Forum is maintained by Administrator with WebBBS 5.12.