Page 1 of 1

Java - Sqlite - FAT32 formatted usb flash drive

Posted: Fri Jan 12, 2018 3:21 pm
by jotis76
Hi, i am new here so hello to the community.

I have a java program running on a raspberry pi 3, that uses sqlite on an external USB flash drive
to save its data. The flash drive is formatted with FAT32 and connected to the raspberry's usb hub.
Now my issues, it happens some times i have one new record inserted double, or when i update
some records not all of them are updated!!! This not happens all the time...
On the hub i have also connected a usb GPS mice to get gps coordinates every second,
the raspberry is inside a vehicle. And a official 7" touch screen is also connected.
At first i had the flash drive formatted in ext4 and there was no connected gps mice(no coordinates needed)
and everything was functioning OK. I don't know if it is important, the raspberry shows the under voltage icon.

I am trying to figure out what can cause this...

Any ideas are welcome