FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Error running compactor for private messages in 2.7.1
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Re: Error running compactor for private messages in 2.7.1 [message #27976 is a reply to message #27974] Mon, 03 October 2005 19:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
yes, the problem was finally fixed by this patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/www_root/adm/co mpact.php?v=1.59


FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #27978 is a reply to message #27976] Mon, 03 October 2005 21:14 Go to previous messageGo to next message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
WOW! Are you gonna tell me now that all my messages are lost too? As I went from having a sizable directory of message files

total 12
-rw-r--r-- 1 nobody nogroup 430 Oct 3 20:18 msg_350000
-rw-r--r-- 1 nobody nogroup 185 Oct 3 18:35 msg_450000
-rw-rw-rw- 1 nobody nogroup 1394 Oct 3 19:30 private
-rw-r--r-- 1 nobody nogroup 0 Oct 3 18:17 private_tmp

to this?

someone just informed me that all message bodies are gone and I discovered this.

Our users have posted a total of 8872 messages inside 1237 topics.
Most users ever online was 6 on Mon, 03 October 2005 20:49
We have 233 registered user(s).


Never ask a geek why, just nod your head and slowly back away.

[Updated on: Mon, 03 October 2005 21:15]

Report message to a moderator

Re: Error running compactor for private messages in 2.7.1 [message #27983 is a reply to message #27978] Tue, 04 October 2005 09:02 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The message bodies are stored inside the msg_* files, if those files don't have the data, you don't have the message bodies.

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #27992 is a reply to message #27983] Tue, 04 October 2005 10:14 Go to previous messageGo to next message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
So you are telling me that 2.7.3RC1 killed our messages. I need to make sure what I am telling the community at this point.

What is that patch supposed to do for me? Do I still need it?


Never ask a geek why, just nod your head and slowly back away.

[Updated on: Tue, 04 October 2005 10:14]

Report message to a moderator

Re: Error running compactor for private messages in 2.7.1 [message #27993 is a reply to message #27992] Tue, 04 October 2005 11:11 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The goal of the patch is to fix the problem so that it does not happen again if you run the compactor. Normally running the compactor is not necessary, this tool is only necessary in the event you are short on disk space and have in the past deleted large number of messages. In that case the compactor is able to reclaim some space, by removing the "empty" spots left in the msg files.

Ideally at this point you could go back to the backups of the forum, if you don't have those, then I'm afraid the message bodies are gone.


FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28057 is a reply to message #27250] Sun, 09 October 2005 19:13 Go to previous messageGo to next message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
You cant blame me. I dont trust the release notes. Is this fixed in 2.7.3RC2?

I found an old hard drive from 2 months ago. we lost 1099 messages, 130 topics, 23 registered users

I just want to make sure that this bug is fixed in 2.7.3RC2

TIA


Never ask a geek why, just nod your head and slowly back away.
Re: Error running compactor for private messages in 2.7.1 [message #28073 is a reply to message #28057] Mon, 10 October 2005 10:58 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Yes, it is fixed.

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28087 is a reply to message #28073] Mon, 10 October 2005 14:09 Go to previous messageGo to next message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
ty ty ty ty ty ty ty ty ty ty ty ty ty ty ty ...and... ty ty ty ty ty ty Very Happy

Never ask a geek why, just nod your head and slowly back away.
Re: Error running compactor for private messages in 2.7.1 [message #28438 is a reply to message #27250] Mon, 24 October 2005 17:14 Go to previous messageGo to next message
konkers is currently offline  konkers   United States
Messages: 1
Registered: October 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Accepting that all my messages are gone, what is the best way to clear out a forum of it's bodyless messages?
Re: Error running compactor for private messages in 2.7.1 [message #28439 is a reply to message #27250] Mon, 24 October 2005 19:54 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

I get this with Version 2.7.3.RC3.

I had to view the source of the page because it was locked down and unscrollable.

Quote:

<br>Disabling the forum for the duration of maintenance run<br><br>Please wait while forum is being compacted.<br>This may take a while depending on the size of your forum.<br>
Compacting normal messages...<br>
10% done<br>
ETA: 27 seconds<br>
20% done<br>
ETA: 28 seconds<br>
30% done<br>
ETA: 25.666666666667 seconds<br>
40% done<br>
ETA: 24 seconds<br>
50% done<br>
ETA: 21 seconds<br>
60% done<br>
ETA: 17.333333333333 seconds<br>
70% done<br>
ETA: 13.714285714286 seconds<br>
80% done<br>
ETA: 9.5 seconds<br>
90% done<br>
ETA: 5 seconds<br>
100% Done<br>
Compacting private messages...<br>
(/usr/fudforum/include/theme/default/db.inc:73<br />
/var/www/html/ccgw/forum/adm/compact.php:158<br />
) 1061: Duplicate key name 'fud_pmsg_foff_idx'<br />
Query: CREATE INDEX fud_pmsg_foff_idx ON fud_pmsg (foff)<br />
_POST: array (
'conf' =&gt; 'Yes',
'SQ' =&gt; '1b2e0c0d5556729874774abdc6c39baa',
)<br />
Server Version: 4.0.21-standard<br />



-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28440 is a reply to message #27250] Mon, 24 October 2005 20:05 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Ok, figured out that the table index it was complaining about was left over from a previous bombed compact attempt.

After removing the index, here is my log. This is with 2.7.3RC3

Quote:

<b>Warning</b>: fopen(/usr/fudforum/messages/private): failed to open stream: No such file or directory in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>200</b><br />
<br />
<b>Warning</b>: fseek(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>201</b><br />
<br />
<b>Warning</b>: fread(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>202</b><br />
<br />
<b>Warning</b>: fclose(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>203</b><br />
FATAL ERROR: system has ran out of disk space<br>


As a result, all my messages have no bodies


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!

[Updated on: Mon, 24 October 2005 20:06]

Report message to a moderator

Re: Error running compactor for private messages in 2.7.1 [message #28447 is a reply to message #27250] Tue, 25 October 2005 09:03 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Latest update. I looked in private.inc and found that it was trying to open the messages/private directory, which did not exist. I did create a new template set with 2.7.2, and I guess that directory was not created. Might want to look into that.

Anyway, after clearing the fud_pmsg_foff_idx index again and re-running the compact messages, here is the latest log:

Quote:

ETA: 27 seconds<br>
20% done<br>
ETA: 24 seconds<br>
30% done<br>
ETA: 23.333333333333 seconds<br>
40% done<br>
ETA: 22.5 seconds<br>
50% done<br>
ETA: 20 seconds<br>
60% done<br>
ETA: 16.666666666667 seconds<br>
70% done<br>
ETA: 13.285714285714 seconds<br>
80% done<br>
ETA: 9.25 seconds<br>
90% done<br>
ETA: 4.8888888888889 seconds<br>
100% Done<br>
Compacting private messages...<br>
FATAL ERROR: system has ran out of disk space<br>


Nothing left for me to track down


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28452 is a reply to message #28438] Tue, 25 October 2005 10:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
konkers wrote on Mon, 24 October 2005 17:14

Accepting that all my messages are gone, what is the best way to clear out a forum of it's bodyless messages?

Delete records from the message table and run the consistency checker.


FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28454 is a reply to message #28447] Tue, 25 October 2005 10:52 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Do you have any files inside the messages/ directory?

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28456 is a reply to message #27250] Tue, 25 October 2005 11:00 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Yes, quite a few 0-length files that run from msg_10000 to msg_990000.

There's a 0-length private_tmp, and a private directory that is empty.


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28458 is a reply to message #28456] Tue, 25 October 2005 11:17 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
private directory?! That should not be there, that should be a filename not directory name. That would explain why you were getting compacting errors on private messages.

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28459 is a reply to message #27250] Tue, 25 October 2005 11:22 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

private directory removed. Re-ran the compact utility:

Quote:

<b>Warning</b>: fopen(/usr/fudforum/messages/private): failed to open stream: No such file or directory in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>200</b><br />
<br />
<b>Warning</b>: fseek(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>201</b><br />
<br />
<b>Warning</b>: fread(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>202</b><br />
<br />
<b>Warning</b>: fclose(): supplied argument is not a valid stream resource in <b>/usr/fudforum/include/theme/default/private.inc</b> on line <b>203</b><br />
FATAL ERROR: system has ran out of disk space<br>


What actually creates this file again then?

EDIT: I originally ran into this problem and mistaken thought it was looking for a directory, so created it manually. So the problem now is that private didn't exist.


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!

[Updated on: Tue, 25 October 2005 11:28]

Report message to a moderator

Re: Error running compactor for private messages in 2.7.1 [message #28460 is a reply to message #28459] Tue, 25 October 2005 11:32 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The file is created by the act of posting a 1st private message. Until this action it taken the file does not exist.

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28463 is a reply to message #27250] Tue, 25 October 2005 11:51 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Ok, recreated the problem, deleted the index, and re-ran the compact utility.

Still getting this far:
Quote:

ETA: 5.4444444444444 seconds<br>
100% Done<br>
Compacting private messages...<br>
FATAL ERROR: system has ran out of disk space<br>


Checked permissions on the messages dir. apache is owner and has write permission.

One question. I was going through the table structure and am having a sudden horrible realization that the only copy of the text of my 130000 messages are stored in these message files, NOT in the database. So all this time I've been making backups of the database and not these message files, so have no way of restoring my messages.

Is this correct?


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28464 is a reply to message #28463] Tue, 25 October 2005 11:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Do you still have the "private" directory?

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28465 is a reply to message #27250] Tue, 25 October 2005 12:07 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

Nope removed that and sent a PM to myself to recreate it before running the last compact.

-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28466 is a reply to message #27250] Tue, 25 October 2005 12:13 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

The problem as I see it, is that I have all these msg_* files that are 0 length and a huge number of records that expect data to be in these files.

Somehow all these files got corrupt.


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28472 is a reply to message #27250] Tue, 25 October 2005 13:32 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

1. Deleted contents of messages folder

2. Found a year old copy of the messages folder and copied them into the messages folder:

[root@server1 fudforum]# ls -l messages
total 44908
-rw-r--r--    1 root     root     43634470 Oct 25 12:30 msg_1
-rw-r--r--    1 root     root      2297485 Oct 25 12:30 private


3. Run the v2.7.3.RC3 message compactor

Dies with a disk out of space error and the following messages folder:


[root@server1 fudforum]# ls -l messages
total 2276
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_10000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_100000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1000000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1010000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1020000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1030000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1040000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1050000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1060000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1070000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1080000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1090000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_110000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1100000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1110000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1120000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1130000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1140000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1160000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1170000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1180000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1190000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_120000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1200000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1210000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1220000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1230000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1240000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1250000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1260000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1270000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1290000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_130000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1330000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1340000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1350000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1360000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1370000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1380000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1390000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_140000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1400000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1410000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1430000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1440000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1460000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1490000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1500000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1510000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1540000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1550000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_1560000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1580000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_160000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1610000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1620000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1650000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1660000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_170000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1710000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_1750000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_20000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_200000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_220000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_230000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_240000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_250000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_260000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_270000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_280000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_290000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_30000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_300000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_310000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_320000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_330000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_340000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_350000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_370000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_380000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_390000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_40000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_400000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_410000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_420000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_430000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_440000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_450000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_460000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_470000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_480000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_490000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_500000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_510000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_520000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_540000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_550000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_560000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_570000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_580000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_590000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_60000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_600000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_610000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_620000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_630000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_640000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_650000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_660000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_670000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_680000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_690000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_70000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_700000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_710000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_720000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_730000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_740000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_750000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_760000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_770000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_780000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_790000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_80000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_800000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_810000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_820000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_830000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_840000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_850000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_860000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_870000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_880000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_890000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_90000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_900000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_910000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_920000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_930000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_940000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_950000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:32 msg_960000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_970000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_980000
-rw-rw-rw-    1 apache   apache          0 Oct 25 12:33 msg_990000
-rw-r--r--    1 root     root      2297485 Oct 25 12:30 private
-rw-r--r--    1 apache   apache      27729 Oct 25 12:33 private_tmp


I'd say this is not fixed.


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28478 is a reply to message #28472] Tue, 25 October 2005 17:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
How many message have a file_id sql table record equal to 1?

FUDforum Core Developer
Re: Error running compactor for private messages in 2.7.1 [message #28479 is a reply to message #27250] Tue, 25 October 2005 17:55 Go to previous messageGo to next message
BugLaden is currently offline  BugLaden   United States
Messages: 208
Registered: February 2002
Location: New Windsor, Md.
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user

mysql> select count(*) from fud_msg where file_id = 1;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.23 sec)


-=BugLaden
CCG Workshop, LLC
Play Hobby and Strategy Games Online!
Re: Error running compactor for private messages in 2.7.1 [message #28480 is a reply to message #28479] Tue, 25 October 2005 18:03 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is why the other files are empty, no messages inside your forum reference msg_1 file.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
Pages (2): [ «    1  2]  Switch to threaded view of this topic Create a new topic
Previous Topic: Removing poll option resets total_votes
Next Topic: Undefined variable: forum_title error when replying
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 19 19:52:48 EDT 2017

Total time taken to generate the page: 0.01207 seconds