This thread has been locked.

If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.

fsync problems

Hi,

I'm using the 816x/389x EVM with a SATA SSD, running a SQLITE embedded database linked into my application.  The SQLITE database resides on the SSD.  The SSD is formatted as ext3 and mounted as ext3 async, barrier=1, so I'm using manual fsync calls to flush data to the SSD.  I've been running a simple test that writes a single cell of data to the database, issues fsync, then I power cycle the EVM.  When my app comes up I query the cell I changed.  The problem is that sometimes the new data is in the db cell and sometimes it is not.  

I've run with the SQLITE db configured to not do any syncing (SYNCHRONOUS OFF, no fsync calls), sync only at "critical" points (SYNCHRONOUS NORMAL), and to sync on any write (SYNCHRONOUS FULL).  In FULL mode, I have not seen this problem, but I see it in NORMAL or OFF mode.  Since SQLITE is issuing fsync in FULL mode, I don't see why I wouldn't see the problem with FULL mode -- possibly if I dig more it would turn out that it does happen with FULL mode.

My question for this forum is has anyone seen any problems of this type with the TI Linux PSP's fsync?  Has it been tested on this EVM and known to be reliable?  Does TI believe it should work?

Persistence of data on the SSD is a critical feature of our system.

Thank you,

Tim