I want to use a dbase record in Postgresql as a mutex in a garbage collection/file upload system.
If I tranfer an uploaded file to a directory, write all its meta information and file name in a record, the user should
have5 minutes to finish inputting the required info for the record. (I want to store in file system instead of database
table).
So there will be two processes racing against each other in the database, the web page changing the status of the
recordto 'complete', and the cron job erasing files that have status 'in-process' and are older than ten minutes.
So there will probably be 6 possible scenarios:
1/ Web site changes status before the cron job gets to the record and deltes the file, no problem.
2/ Cron job changes the record and deletes the file before the website gets to the record, no problem.
3/ Both access the the record relatively at the same time, the web site having the earlier, lower transaction number
andalso finishes first.
4/ Both access the the record relatively at the same time, the cron job having the earlier, lower transaction number
andalso finishes first.
5/ Both access the the record relatively at the same time, the web site having the later, HIGHER transaction number BUT
finishesfirst.
6/ Both access the the record relatively at the same time, the cron job having the later, HIGHER transaction number BUT
finishesfirst.
Do I have the possiblities correctly described? What happens with cases 3-6?
Thanks in advance. I RTFMed and Googled, but did not see the answer.
Dennis Gearon
Signature Warning
----------------
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
