Strange problem with different sqlite versions accessing the same database

View: New views
3 Messages — Rating Filter:   Alert me  

Strange problem with different sqlite versions accessing the same database

by Yuzem :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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.

Re: Strange problem with different sqlite versions accessing the same database

by Yuzem :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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?

Re: Strange problem with different sqlite versions accessing the same database

by Pavel Ivanov-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> 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