Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

consistency.pl and purge.pl inconsistencies

Quote Reply
consistency.pl and purge.pl inconsistencies
Hi,

This is just an observation:

purged messages for a user and the count was somewhere around 2500 or so.

regularly purged trash folder.

before doing all this consistency.pl --fix was run to ensure that all is well.

However, ran consistency.pl and found following:

2734 messages were on disk and not in the database

0 messages were in the database but not on disk
validate table inconsistancies: 0
msgtrack table inconsistancies: 0
msgs table inconsistancies: 1
msgs_threads table inconsistancies: 0
msgdata table inconsistancies: 0
msgsearch table inconsistancies: 0
msgs_remote table inconsistancies: 0
pop_accounts table inconsistancies: 0
sigs table inconsistancies: 0
address table inconsistancies: 0
filter table inconsistancies: 0
users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0
sessions table inconsistancies: 0
folders table inconsistancies: 0

Does sit mean that purge from admin is not removing the messages from the disk?

Have run consistency.pl again to synchro everything.

Obviously all the while consistency.pl was being run the site was disabled. Again with everything synchronized, again did a purge messages (Trash 1 Messages Deleted):

consistency.pl gave following result:

2 messages were on disk and not in the database

0 messages were in the database but not on disk
validate table inconsistancies: 0
msgtrack table inconsistancies: 0
msgs table inconsistancies: 0
msgs_threads table inconsistancies: 0
msgdata table inconsistancies: 0
msgsearch table inconsistancies: 0
msgs_remote table inconsistancies: 0
pop_accounts table inconsistancies: 0
sigs table inconsistancies: 0
address table inconsistancies: 0
filter table inconsistancies: 0
users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0
sessions table inconsistancies: 0
folders table inconsistancies: 0

Again did purge messages for a user: 265 messages purged.

Ran consistency.pl and got following:

681 messages were on disk and not in the database

0 messages were in the database but not on disk
validate table inconsistancies: 0
msgtrack table inconsistancies: 0
msgs table inconsistancies: 0
msgs_threads table inconsistancies: 0
msgdata table inconsistancies: 0
msgsearch table inconsistancies: 0
msgs_remote table inconsistancies: 0
pop_accounts table inconsistancies: 0
sigs table inconsistancies: 0
address table inconsistancies: 0
filter table inconsistancies: 0
users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0
sessions table inconsistancies: 0
folders table inconsistancies: 0

So there is some bit of inconsistency between purge and consistency.pl

What could be the reasons?

However, when admin does all the deleting (empty folder) by going to the user account from admin then there are no inconsistencies. So i believe, Purge.pm or something else needs a closer look. It is definitely leading to inconsistencies wrt the mesages on disk and database. For example for a given user when the folder is emptied (85 messages) and also the trash after that, the consistency.pl gives:

0 messages were on disk and not in the database

0 messages were in the database but not on disk
validate table inconsistancies: 0
msgtrack table inconsistancies: 0
msgs table inconsistancies: 0
msgs_threads table inconsistancies: 0
msgdata table inconsistancies: 0
msgsearch table inconsistancies: 0
msgs_remote table inconsistancies: 0
pop_accounts table inconsistancies: 0
sigs table inconsistancies: 0
address table inconsistancies: 0
filter table inconsistancies: 0
users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0
sessions table inconsistancies: 0
folders table inconsistancies: 0

Which is perfectly OK.

It is only the "Purge" operation which is leading to all sorts of inconsistencies.

Any comments.....

Thnx

Anup

Last edited by:

anup123: Mar 14, 2003, 11:10 PM
Subject Author Views Date
Thread consistency.pl and purge.pl inconsistencies anup123 8966 Mar 14, 2003, 10:46 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
anup123 8545 Mar 19, 2003, 1:54 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
anup123 8550 Mar 22, 2003, 2:08 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8475 Apr 13, 2003, 11:55 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8463 Apr 15, 2003, 12:11 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8449 Apr 15, 2003, 2:48 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8409 Apr 16, 2003, 3:11 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8537 Apr 16, 2003, 3:31 AM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8453 Apr 16, 2003, 8:22 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8376 May 1, 2003, 7:32 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8327 May 2, 2003, 2:26 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8352 May 2, 2003, 10:10 PM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8297 May 3, 2003, 5:16 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8308 May 4, 2003, 5:05 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 8301 May 4, 2003, 10:22 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 8283 May 5, 2003, 3:01 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
pugdog 8351 May 5, 2003, 4:01 AM
Post Re: [pugdog] consistency.pl and purge.pl inconsistencies
anup123 8282 May 5, 2003, 5:11 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
anup123 8286 May 21, 2003, 3:55 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
brewt 8345 May 21, 2003, 5:36 PM
Post Re: [brewt] consistency.pl and purge.pl inconsistencies
anup123 8241 May 21, 2003, 5:56 PM
Post Re: [brewt] consistency.pl and purge.pl inconsistencies
anup123 8225 May 21, 2003, 8:31 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
brewt 8209 May 27, 2003, 4:26 PM
Thread Re: [brewt] consistency.pl and purge.pl inconsistencies
anup123 8165 May 28, 2003, 1:09 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
brewt 8200 May 28, 2003, 1:50 AM
Thread Re: [brewt] consistency.pl and purge.pl inconsistencies
anup123 7324 May 30, 2003, 12:15 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
aghajunaid1 7265 Jun 5, 2003, 7:12 AM
Post Re: [aghajunaid1] consistency.pl and purge.pl inconsistencies
anup123 7222 Jun 5, 2003, 9:25 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 7234 Jun 5, 2003, 2:02 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7240 Jun 5, 2003, 2:34 PM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 7238 Jun 5, 2003, 11:06 PM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7210 Jun 6, 2003, 2:50 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 7236 Jun 6, 2003, 3:24 AM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7261 Jun 6, 2003, 3:47 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 7282 Jun 6, 2003, 4:17 AM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
dearnet 7260 Jun 6, 2003, 4:19 AM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7162 Jun 6, 2003, 4:39 AM
Thread Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7210 Jun 6, 2003, 5:10 AM
Thread Re: [anup123] consistency.pl and purge.pl inconsistencies
dearnet 7265 Jun 6, 2003, 6:52 AM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7180 Jun 6, 2003, 12:19 PM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7176 Jun 6, 2003, 2:12 PM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7181 Jun 6, 2003, 4:31 AM
Post Re: [dearnet] consistency.pl and purge.pl inconsistencies
anup123 7200 Jun 7, 2003, 1:03 PM
Post Re: [brewt] consistency.pl and purge.pl inconsistencies
anup123 7190 Jun 6, 2003, 2:22 PM
Post Re: [brewt] consistency.pl and purge.pl inconsistencies
dearnet 7200 Jun 6, 2003, 3:05 AM