Re: Disabled Temp DBspace -- Revisited

mosserp@wellsfargo.com wrote: : We're running ODS 7.20.UC3 on a DEC 8200, O/S version 3.2. : The interesting part: : Browsing thru dejanews, I found that someone else had this problem over : a YEAR ago : on an AIX 4.1 platform w/ ODS 7.12.UC2. There was speculation then that : the problem : would be fixed in 7.2x. Obviously, it has not been fixed, at least not : on the DEC platform. Well, 7.20 has been out for more than a year (June 1996, as close as I can figure it). If you want a fix to a bug that was found a year ago, you have to get a version that was released less than a year ago. Your bug has been fixed in 7.14 and 7.21. FYI, 7.22 has been available on DEC since April. Maintenance on 7.1x and 7.2x goes on in parallel, therefore bugs that are fixed in 7.13, 7.14, etc may not be fixed in 7.20, 7.21, etc. : 15:22:56 Assert Failed: WARNING! pthdrpage:ptalloc:bad partn page : 15:22:56 Who: Session(24, informix@infx_srvr, 0, 97903240) : Thread(56, xchg_1.4, 5d32218, 3) : 15:22:56 Results: Cannot use TBLSpace page for TBLSpace 11534374 : 15:22:56 Action: Run 'oncheck -pt 11534374' : <<< NOTE: Here's where the real problem began. : <<< This "oncheck" just gave us: : <<< Error opening TBLspace b00026. ?????? Yes, because this was a temporary table, and therefore no longer exists. The bug is that some activity in your tempdbs was logged, and therefore, during recovery, OnLine tries to roll forward operations on a table that is no longer there. June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Ashford, England ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.