Re: 7.22 temporary TBLspace problem
In article <5nmnrd$sbj$1@tst.hk.super.net>, Mr Cheuk Kong Lo
<cklo@news.hk.super.net> writes
>I'm receving the following error recently, when performing the engine
>shutdown and restart.
>
>19:14:41 Dropping temporary TBLspace 30015b, recovering 8 pages.
>19:14:41 Dropping temporary TBLspace 30015c, recovering 8 pages.
>19:14:41 Dropping temporary TBLspace 30015d, recovering 8 pages.
>19:14:41 Assert Failed: WARNING! Errors occurred while cleaning dbspace>'datadbs informix'
>19:14:41 Who: Session(1, informix@j30, 0, 1074110484)
> Thread(8, main_loop(), 40038014, 3)
>19:14:41 Results: Unused temp tables and/or deferred indexes may remain
>19:14:41 Action: Cleanup will be reattempted during next initialization
>19:14:41 See Also: /tmp/af.888a0
>
>19:56:13 Assert Failed: WARNING! pthdrpage:ptalloc:bad partn page
>19:56:13 Who: Session(16, informix@foobar, 100270, 1074112236)
> Thread(41, oncheck, 40039d9c, 1)
>19:56:13 Results: Cannot use TBLSpace page for TBLSpace 3146019
>19:56:13 Action: Run 'oncheck -pt 3146019'
>19:56:13 See Also: /tmp/af.29925d>
>So I follow the oncheck -pt <id> and still the same error.
>
>This is on IBM AIX v4 platform. Anyone knows how it may be cure and prevent?
>
>Thanks.
>
>Chris
>
Possibly you have
a) a bad sopt of the disk
b) an Informix bug
c) some other hardware related error
Talk to Informix..
--
David Williams