| Re: Compatcting Database: Fatal disk space error [message #25888 is a reply to message #25882] |
Fri, 24 June 2005 04:09   |
keneisman
Messages: 68
Registered: May 2005
Karma:
|
Member |
|
|
That didn't work.
I've attached dumps of the msg table before and after the compact.
You can see that it looks like, in forums with only one message, the length value is being doubled and placed in the foff column (440 = 2*220). In forums with multiple messages, the lowest changed foff - the lowest original foff is a multiple (2X in one case and 3X in the other) of the sum of the lengths of all the messages in the forum. (6142-1500 = 2(1547+774))
Are these message offsets/lenghts stored in any other tables or files?
If there is anything else I can do to help track this down, please let me know.
Thanks
Ken
-
Attachment: msg_chg.txt
(Size: 4.08KB, Downloaded 653 times)
-
Attachment: msg_orig.txt
(Size: 4.08KB, Downloaded 615 times)
[Updated on: Fri, 24 June 2005 04:11] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]