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 :: 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
remove from 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
remove from 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
remove from 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
remove from 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?
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from 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
remove from buddy list
ignore all messages by this user
Do you have any files inside the messages/ directory?

FUDforum Core Developer
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from 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
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from 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
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from buddy list
ignore all messages by this user
Do you still have the "private" directory?

FUDforum Core Developer
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from buddy list
ignore all messages by this user
How many message have a file_id sql table record equal to 1?

FUDforum Core Developer
Message by BugLaden is ignored  [reveal message]  [reveal all messages by BugLaden]  [stop ignoring this user] Go to previous messageGo to next message
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
remove from 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: Sat May 24 18:37:14 EDT 2025

Total time taken to generate the page: 0.05386 seconds