Errors dropping temp table space
Posted in 1998
Topics: High Availability & Replication, Storage & Space Management, Error Codes & Troubleshooting
I have this problem, and Informix Italy did not give me no answer
(I've been waiting since 50 days).
When bringing OnLine 7.20 on line, in the log file I see a series of errors
like this:
Assert Failed: WARNING! pthdrpage:ptalloc:bad partn page
Who: Session(........)
Thread(.........)Results: Cannot use TBLSpace page for TBLSpace 1049655
Action: Run 'oncheck -pt 1049655'
See Also: /tmp/af.d35bc
Running oncheck -pt I have a: 'Error opening TBLSpace'.
Looking in the af* file I see that it concerns some temp tables created by
the users with the 'create temp table'. These table should be destroyed
at the end of each user's session. Some tables perhaps have problems and
Informix
is not able to have back the space allocated for them (this is what I
think).
When the users' session are ended, Informix doesn't see anymore these
tables and so oncheck -pt can not be succesfull.
All the other oncheck I perform are OK (-cI,-cc,-cD,-ce,-cr).
Each time I bring Informix on line I have the same errors. I CAN NOT drop
and recreate the dbspace (it is rootdbspace). Now I have created a tempdbs
to store these temp table.
But How can I recover this space in rootdbs and stop with these errors ???
Thanks a lot in advance
Marco Traini