XFileSharing Pro - Please explain: DB to File and File to DB consistancy check

Message
Author
qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

Please explain: DB to File and File to DB consistancy check

#1 Postby qq_bbq » Jul 31, 2010 6:21 am

What are some examples that would cause these to not match between file and database?

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

Re: Please explain: DB to File and File to DB consistancy ch

#2 Postby ankurs » Jul 31, 2010 8:48 am

qq_bbq wrote:What are some examples that would cause these to not match between file and database?
DB to File
file corrupt/deleted & is in db

File to DB
file didnt delete & is not in db

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

Re: Please explain: DB to File and File to DB consistancy ch

#3 Postby qq_bbq » Jul 31, 2010 5:21 pm

ankurs wrote:
qq_bbq wrote:What are some examples that would cause these to not match between file and database?
DB to File
file corrupt/deleted & is in db

File to DB
file didnt delete & is not in db
I doubt file corrupt is one of the reason.

Why would a file not delete?

PowerChaos
Posts: 521
Joined: Dec 19, 2009 5:12 pm

#4 Postby PowerChaos » Aug 01, 2010 4:14 pm

db to file is to check if al files in the database still exist on the hard drive (are they still avaible)

file to db does the same , but it checks the files and see if they are avaible in the database


it happends sometimes that it is not able to delete files (mysql overload ?? , mysql buzzy and action got terminated ?? , any other reason that gives a read error ??)

if that happends , then that file will give a error when trying to download (if exist in database)

if the file was not able to add to the database as above example, then you will get a error when trying to get a file

it is a good thing to to use it when you move files betwean servers , so it checks if all files are pointed to the right server

hopley this explained it

Greetings From PowerChaos

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

#5 Postby qq_bbq » Aug 01, 2010 6:43 pm

There is a bug on the file check. When you move file and it times out. The file is partially moved already. So it is on both servers but the file to db check can't detect this and does not delete the other copy.