Re: IDS 7.30 do not start - NT
Posted in 2005
Topics: High Availability & Replication, Backup & Restore, Installation, Setup & Upgrades, Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Logging & Checkpoints, Versions, Editions & End-of-Life
if the backup / restore was done using ontape or onbar and you see
> 16:02:43 bfcheck: bad page: pg_addr b0a0908 != bp->bf_pagenum 200191
then you hit a MAJOR bug. (or your io subsystem has a huge problem..)
DO contact TS.
Superboer
AVO schreef:
> Hallo,
>
> the NT installation was made new. The informix-Server was installed
> new. the log-file and onconfig was restored and the database chunks was
> restored (not with informix-tools). I think the backup of the database
> chunks was not correct, i made it not myself.
>
> Andreas
>
> --------------------------------------------------------------
> here are some entries in the log file:
>
> 15:56:07 Assert Failed: pthdrpage:ptalloc:bad partn page
> 15:56:07 Informix Dynamic Server Version 7.30.TC9
> 15:56:07 Who: Session(17, informix@ntserv1.nt_dom1, 179, 0)
> Thread(38, oncheck, 0, 1)
> File: R:\\rsam\\rspartn.c Line: 5134
> 15:56:07 Results: Cannot use TBLSpace page for TBLSpace 2097202
> 15:56:07 Action: Run 'oncheck -pt 2097202'
> 15:56:16 See Also: af.268af7
> 15:56:16 pthdrpage:ptalloc:bad partn page
> 15:56:46 Assert Failed: Page Check Error in rsread:bad data page
> 15:56:46 Informix Dynamic Server Version 7.30.TC9
> 15:56:46 Who: Session(19, informix@ntserv1.nt_dom1, 258, 0)
> Thread(40, sqlexec, 0, 1)
> File: R:\\rsam\\rsdebug.c Line: 943
> 15:56:46 Results: Possible inconsistencies in> 'verlag:"informix".syscolumns'
> 15:56:46 Action: Run 'oncheck -cD 2097155'
> 15:56:54 See Also: af.288b1d, shmem.288b1d.0
> 15:56:54 Page Check Error in rsread:bad data page
> 15:58:32 Assert Failed: pthdrpage:ptalloc:bad partn page
> 15:58:32 Informix Dynamic Server Version 7.30.TC9
> 15:58:32 Who: Session(22, informix@ntserv1.nt_dom1, 86, 0)
> Thread(43, oncheck, 0, 1)
> File: R:\\rsam\\rspartn.c Line: 5134
> 15:58:32 Results: Cannot use TBLSpace page for TBLSpace 2097202
> 15:58:32 Action: Run 'oncheck -pt 2097202'
> 15:58:40 See Also: af.2b8b87
> 15:58:40 pthdrpage:ptalloc:bad partn page
> 16:02:03 Assert Failed: pthdrpage:ptalloc:bad partn page
> 16:02:03 Informix Dynamic Server Version 7.30.TC9
> 16:02:03 Who: Session(23, informix@ntserv1.nt_dom1, 167, 0)
> Thread(44, oncheck, 0, 1)
> File: R:\\rsam\\rspartn.c Line: 5134
> 16:02:03 Results: Cannot use TBLSpace page for TBLSpace 2097202
> 16:02:03 Action: Run 'oncheck -pt 2097202'
> 16:02:15 See Also: af.2c8c5a
> 16:02:15 pthdrpage:ptalloc:bad partn page
> 16:02:43 Assert Failed: pthdrpage:ptalloc:bad partn page
> 16:02:43 Informix Dynamic Server Version 7.30.TC9
> 16:02:43 Who: Session(24, informix@ntserv1.nt_dom1, 246, 0)
> Thread(45, oncheck, 0, 1)
> File: R:\\rsam\\rspartn.c Line: 5134
> 16:02:43 Results: Cannot use TBLSpace page for TBLSpace 2097202
> 16:02:43 Action: Run 'oncheck -pt 2097202'
> 16:02:58 See Also: af.2d8c82
> 16:02:58 pthdrpage:ptalloc:bad partn page
> 16:03:13 Checkpoint Completed: duration was 0 seconds.
> 16:08:23 Checkpoint Completed: duration was 0 seconds.>
>
> -------------------------------------------------------------------------------------------------------------
> HERE ARE THE af.2d8c82
>
> 16:02:43 bfcheck: bad page: pg_addr b0a0908 != bp->bf_pagenum 200191> buffer header
> 0c4bd0c0: 00000000 00000000 00000000 b821490c ........ .....!I.
> 0c4bd0d0: b821490c fca54b0c 38c1000c 02800000 .!I...K. 8.......
> 0c4bd0e0: 00000406 00000000 00000000 01001003 ........ ........
> 0c4bd0f0: 00000000 00000000 91012000 01000000 ........ .. .....
> 0c4bd100: 0020660c . f.
> page
> 0c662000: 08090a0b 0c0d0e0f 10111213 14151617 ........ ........
> ..............
> 0c662fe0: e8e9eaeb ecedeeef f0f1f2f3 f4f5f6f7 ........ ........
> 0c662ff0: f8f9fafb fcfdfeff 00010203 04050607 ........ ........
> chunk info
> 0d91c438: 02000300 00000000 00ff0700 45000000 ........ ....E...
> 0d91c448: 02000000 40002300 443a5c49 464d5844 ....@.#. D:\\IFMXD
> 0d91c458: 4154415c 6f6c5f73 63686965 6c655c64 ATA\\ol_s chiele\\d
> 0d91c468: 6273315f 6461742e 30303000 00300000 bs1_dat. 000..0..
> 0d91c478: e98a0000 f85aab0d 1b000000 94baaa0d .....Z.. ........
> 0d91c488: f0df950d 98baaa0d 14fd6700 e98a0000 ........ ..g.....
> 0d91c498: f85aab0d 1b000000 94baaa0d f0df950d .Z...... ........
> 0d91c4a8: d8a91300 02000000 0050000c 1a000000 ........ .P......
> 0d91c4b8: a8baaa0d c1fc6700 c49c7b00 f0060501 ......g. ..{.....
> 0d91c4c8: e59c7b00 f0060501 05000000 00000000 ..{..... ........
> 0d91c4d8: 82000000 01000000 00d00b00 00100000 ........ ........
> 0d91c4e8: 00000000 00000000 00000000 00000000 ........ ........
> aio req
> 0d974718: 00000000 00000000 00000000 00000000 ........ ........
> 0d974728: 00000000 00000000 d848970d 5845970d ........ .H..XE..
> 0d974738: f8010000 41494f72 65710000 00000000 ....AIOr eq......
> 0d974748: d1070000 00000000 01000000 00000000 ........ ........
> 0d974758: 00000000 02000000 00000000 00000000 ........ ........
> 0d974768: 00000000 8c47970d 00000000 00000000 .....G.. ........
> 0d974778: 00000000 00000000 00000000 00000000 ........ ........
> 0d974788: 00000000 ....
> aio op
> 0d97478c: 00000000 00000000 00000000 00000000 ........ ........
> 0d97479c *
> 0d9747bc: 00000000 00000000 00000000 ........ ....
> page from (primary) disk
> 0dcad800: 08090a0b 0c0d0e0f 10111213 14151617 ........ ........
> 0dcad810: 18191a1b 1c1d1e1f 20212223 24252627 ........ !"#$%&'
> 0dcad820: 28292a2b 2c2d2e2f 30313233 34353637 ()*+,-./ 01234567
> 0dcad830: 38393a3b 3c3d3e3f 40414243 44454647 89:;<=>? @ABCDEFG
> 0dcad840: 48494a4b 4c4d4e4f 50515253 54555657 HIJKLMNO PQRSTUVW
> 0dcad850: 58595a5b 5c5d5e5f 60616263 64656667 XYZ[\\]^_ `abcdefg
> 0dcad860: 68696a6b 6c6d6e6f 70717273 74757677 hijklmno pqrstuvw
> 0dcad870: 78797a7b 7c7d7e7f 80818283 84858687 xyz{|}~. ........
> ...
> 0dcae790: 98999a9b 9c9d9e9f a0a1a2a3 a4a5a6a7 ........ ........
> 0dcae7a0: a8a9aaab acadaeaf b0b1b2b3 b4b5b6b7 ........ ........
> 0dcae7b0: b8b9babb bcbdbebf c0c1c2c3 c4c5c6c7 ........ ........
> 0dcae7c0: c8c9cacb cccdcecf d0d1d2d3 d4d5d6d7 ........ ........
> 0dcae7d0: d8d9dadb dcdddedf e0e1e2e3 e4e5e6e7 ........ ........
> 0dcae7e0: e8e9eaeb ecedeeef f0f1f2f3 f4f5f6f7 ........ ........
> 0dcae7f0: f8f9fafb fcfdfeff 00010203 04050607 ........ ........
> mirror chunk info
> 0d91c798: 02000000 00000000 00ff0700 00000000 ........ ........
> 0d91c7a8: 02000000 30002400 453a5c49 464d5844 ....0.$. E:\\IFMXD
> 0d91c7b8: 4154415c 6f6c5f73 63686965 6c655c64 ATA\\ol_s chiele\\d
> 0d91c7c8: 6273315f 6d697272 2e303032 00000000 bs1_mirr .002....
> 0d91c7d8: 94baaa0d f0df950d 98baaa0d 14fd6700 ........ ......g.
> 0d91c7e8: f28a0000 305bab0d 1a000000 94baaa0d ....0[.. ........
> 0d91c7f8: f0df950d d8a91300 02000000 0050000c ........ .....P..
> 0d91c808: 19000000 a8baaa0d c1fc6700 c49c7b00 ........ ..g...{.
> 0d91c818: f0060501 e59c7b00 f0060501 bcbaaa0d ......{. ........
> 0d91c828: b59d7b00 1d000000 ffff0000 00000000 ..{..... ........
> 0d91c838: 00000000 00000000 00000000 00000000 ........ ........
> 0d91c848 *
> mir
Superboer wrote:
> if the backup / restore was done using ontape or onbar and you see
>
>>16:02:43 bfcheck: bad page: pg_addr b0a0908 != bp->bf_pagenum 200191>
> then you hit a MAJOR bug. (or your io subsystem has a huge problem..)
>
> DO contact TS.
>
> AVO schreef:
>>here are some entries in the log file:
>>15:56:07 Informix Dynamic Server Version 7.30.TC9
IDS 7.30.TC9 is relatively unlikely to be supported. 7.31.TDx, yes;
7.31.TCx, rather less so; but for 7.30.anything - if the OP doesn't have
a support extension in place, he probably is not supported, and
contacting Tech Support may not get him very far. However, trying to do
so is probably the best way to find out - I just don't want hopes raised
only to be dashed by reality.
I previously commented that the IDS version (now known to be 7.30.TC9)
and the NT fix pack are both important. And also, you will need to know
whether this version of IDS was certified for the fix pack.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
7.30 has been obsolete for some time
its been obsolete since March 2003 http://www-306.ibm.com/software/data/informix/support/plc/
Related threads
- Re: Re: Crash course for an Oracle DBA
- Re: IDS 10 erratic run times
- Client SDK
- DB2 DOUBLES THE PERFORMANCE OF ORACLE 10G