| Compatcting Database: Fatal disk space error [message #25761] |
Mon, 20 June 2005 16:10  |
keneisman
Messages: 68
Registered: May 2005
Karma: 0
|
Member |
|
|
When runnning the Compact Messages from the Admin Control panel, I get this error:
***********************************************************
Disabling the forum for the duration of maintenance run
Please wait while forum is being compacted.
This may take a while depending on the size of your forum.
Compacting normal messages...
FATAL ERROR: system has ran out of disk space
***********************************************************
I checked the drive that all the forum files are on and it has 67 Gig free.
Any ideas? This is after I've successfully run a Forum Consistency and Rebuild Search Index.
I was running these tools because I tried editing a message and when I hit the submit button, I just got garbage.
Here's my system config:
***********************************************************
System Configuration
PHP built On: Windows NT MAIL01 5.2 build 3790
Database Version: 4.1.11-nt
PHP Version: 5.0.4
Web Server: Microsoft-IIS/6.0
WebServer to PHP interface: isapi
Forum Version: 2.6.13
Relavent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: OFF
File Uploads: ON
Magic Quotes: OFF
Register Globals: OFF
Output Buffering: Yes
Disabled Functions: none
PSpell Support: Yes
Zlib Support: Yes
**************************************************************
Thanks
Ken
[Updated on: Mon, 20 June 2005 16:11] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Compatcting Database: Fatal disk space error [message #25770 is a reply to message #25768] |
Mon, 20 June 2005 18:56  |
keneisman
Messages: 68
Registered: May 2005
Karma: 0
|
Member |
|
|
I just re-ran the upgrade script after making sure that the themes table had 'english' in the lang field and 'c' in the locale field but got the same results.
Before I run the script, the themes table looks like this:
mysql> select * from gemsforum_themes;
+----+---------+---------+---------+---------+-------------+-----------+
| id | name | theme | lang | locale | pspell_lang | theme_opt |
+----+---------+---------+---------+---------+-------------+-----------+
| 1 | default | default | english | C | en | 3 |
| 3 | Test | default | english | english | | 0 |
+----+---------+---------+---------+---------+-------------+-----------+
2 rows in set (0.00 sec)
After I run the script (and get the error messages), the themes table looks like this:
mysql> select * from gemsforum_themes
-> ;
+----+---------+---------+------+--------+-------------+-----------+
| id | name | theme | lang | locale | pspell_lang | theme_opt |
+----+---------+---------+------+--------+-------------+-----------+
| 1 | default | default | | | | 3 |
+----+---------+---------+------+--------+-------------+-----------+
1 row in set (0.00 sec)
I also checked c:\GEMSForumData\include\compiler.inc and it DOES exist.
Thanks
Ken
[Updated on: Mon, 20 June 2005 19:10] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Compatcting Database: Fatal disk space error [message #25782 is a reply to message #25773] |
Tue, 21 June 2005 13:10 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
No no, you misunderstand me.
When you 1st installed the forum you probably were using one version of MySQL library and when running upgrade using another. This means that the PHP extension communicating with MySQL couldn't handle the column name properly, making them appear as spaces causing the problem you are seeing.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Compatcting Database: Fatal disk space error [message #25787 is a reply to message #25786] |
Tue, 21 June 2005 13:24 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I suspect the error was caused by InnoDB to MyISAM conversion.
If you have backups, the best solution would be to restore the old InnoDB tables and then recreate the one table that needs to be MyISAM
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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: 0
|
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 580 times)
-
Attachment: msg_orig.txt
(Size: 4.08KB, Downloaded 538 times)
[Updated on: Fri, 24 June 2005 04:11] Report message to a moderator |
|
|
|
| Re: Compatcting Database: Fatal disk space error [message #25920 is a reply to message #25888] |
Fri, 24 June 2005 17:58 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Offsets for messages are ONLY stored inside this table.
I've so far tried to replicate the bug on latest CVS version of the forum on win32 and unix and cannot.
Try adding debug code to message writing code inside the compact.php script to see where things "go wrong".
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]