7.22 temporary TBLspace problem
Posted in 1997
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