Hi All,
I am currently using SQLite in my application as in Multi-process environment. I.e. my application will contain multi-process which will handle add/delete request to a single db - (bulk.db). I am using the busy_handler concept (with 5ms delay) for locking issues. However, during testing, when 5 processes is up and running, I by chance changed the file permission of bulk.db (chmod 444 bulk.db) to read only. Now I see that the sqlite_exe is not able to trap the read-only mode error of the database (while it tries to add records) and is just returning a busy_handler and thus in loop. Bottom line, if you are using busy_handler and if DB file permission is changed to read-only (manually) instead of throwing an error, SQLite will continue triggering busy_handler. Thus not able to handle this situation. Can any one help me in solving this scenario? Thanks and Regards, Kiran Kumar M Huawei Technologies India Private Limited Bangalore - 560008. "Programmers seem to think the shortest distance between two points is the great circle route on a spherical distortion of Euclidean space" ____________________________________________________________________________ ____________________________________________________________________________ ___________ This e-mail and attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient's) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ____________________________________________________________________________ ____________________________________________________________________________ ___________
