Strange problem with different sqlite versions accessing the same database

[Yuzem]

I have one database on a shared folder across the network.
The database is accessed by two different computers with different sqlite versions.
There was no problem until I updated the OS on one of the computer.
Now I have:
1: Ubuntu Hardy - sqlite3 3.4.2
2: Ubuntu Karmic - sqlite3 3.6.16

The newest version works correctly but the older doesn't save any changes.
If I do an update and then a select in the same connection I can see the changes but they don't get saved.

Some times when accessing the database with one version the database was different than when accessing with the other, and I know that it was the same database, I even check the size. After some time, the database goes back to be the same for the two versions.

I have no idea why this is happening...
Any help is welcome and sorry for my english.

[Yuzem]

Ok, I have replaced the older version and now I have the same sqlite version on both computers but the problem persist. Changes don't get saved on the computer that access the database trough the network.

Any idea?

[Pavel Ivanov-2]

> Any idea?

Apparently you have problematic implementation of network drive.
Generally it's a very bad idea to use SQLite with file on network
drive because SQLite uses file system locking mechanisms which are
pretty bad working on network drives.

Pavel

On Tue, Nov 10, 2009 at 8:00 PM, Yuzem <naujnitram@...> wrote:

>
> Ok, I have replaced the older version and now I have the same sqlite version
> on both computers but the problem persist. Changes don't get saved on the
> computer that access the database trough the network.
>
> Any idea?
> --
> View this message in context: http://old.nabble.com/Strange-problem-with-different-sqlite-versions-accessing-the-same-database-tp26257575p26294299.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@...
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users