SQL issues on NAS

Hello my friends,

I noticed there is a similar thread in the Bugs subforum but I decided to create a new thread because my issues seem to be different.

When I create a library on my local drive everything works fine. Creating the library on my mounted network share results in an empty .ydb file. This is independend of the files in the library folder. The files in the folder are created but can't seem to be written.

I tried debugging and was able to find the point where it differs from creating the library on the local drive.

in data_base_management.cpp in createTables:

After exec() when creating on local drive the .ydb file is created with content. On my nas the file is empty (0kb) with a .ydb-journal file next to it.

Do you have any idea what might cause this? Unfortunaly I have no experience with sql,

Hi 7o9,

thank you very much for taking the time to debug this and making such an detailed post. I'm not sure what's causing this either, so we'll need to run some test in order to reproduce the issue. Could you provide us with the following info?

- Linux distribution
- how did you install YACReader?
- how and where do you mount your NAS on your machine? (full path, mount command)
- the output of "ls -la" in the .yacreaderlibrary folder

Best regards,

selmf

Thanks for your reply,

- distri and Kernel: 4.1.6-1-MANJARO x86_64

- via package manager. Version is 8.0-2. For debugging I used the latest source from bitucket. Both show the same problem.

- fstab: mount with "sudo mount //192.168.2.86/media"

-

According to the Archlinux Wiki which should also be relevant for Manjaro using uid and guid in the mount options "[...]may cause input ouput errors in programs that try to fetch data from network drives."

wiki.archlinux.org/index.php/Samba


Could you check if the problem is still present when you do a manual mount without fstab as described in the Archlinux Wike article?

I mounted with "sudo mount.cifs //192.168.2.86/media /mnt/media/ -o user=xxx" same results. I also tried mounting a different network share and mounting as admin and starting YAC as root. Sadly didn't work either. Something seems to lock onto something. I can delete the .yacreaderlibrary folder while the programm is running when I use a local drive. But with the network share it says the resource is busy.

Looks like there is a problem with sqlite's file locking behavior. Please try adding the mount parameter "nolock" to your fstab or manual mount options and retry.

Great it's working now!

Sorry if this was an obvious problem. I'm rather new to linux.

Thanks for your help!

Nice to hear that it is working again

No, it wasn't an obvious problem. It's rather a problem that can occur in some cases when a sqlite database is located on a network filesystem. Your feedback, especially the part where you mentioned the lock on the database file helped me to track down the solution I gave you and might help others suffering from similar problems. So thank you for reporting the issue

Just because I just ran into the same problem and was confused why there is no 'nolock' option: It has been removed and the equivalent option is 'nobrl' (which resolved the issue for me).