Hi,

I noticed strange behavior when running application on virtualbox linux mint 14 64bit machine. This occur only when I attach second database to sqlite3connection and then call SQLTransaction.Commit. This is my code:

  try
    FConn := TMySqlite3Connection.Create(Self);
    FConn.Transaction := SQLTransaction1;
    FConn.DatabaseName :=
IncludeTrailingBackslash(ProgramDirectory)+'db1.sqlite';
    FConn.Connected := True;
    FConn.ExecSQLNoTrans('attach database '+
      QuotedStr(IncludeTrailingBackslash(ProgramDirectory)+'db2.sqlite')+'
as d2');
    FConn.ExecuteDirect('create table if not exists a(col integer)');
    FConn.ExecuteDirect('create table if not exists d2.b(col integer)');
    SQLTransaction1.Commit;
  except on e: Exception do
    ShowMessage(e.Message);
  end;

Even if error occur, commit succesful created tables. When I run it on normal Linux installation (also Mint 14 64bit) then everything is ok. Both OS have same sqlite version (3.7.13) from ubuntu repo. I will post this report on sqlite mailing list too, but maybe you had similar problem.

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130307/e47595c1/attachment.html>

AFAIK these commands are automatically committed by SQLite.

see e.g.
http://sqlite.1065341.n5.nabble.com/DDL-statements-in-transactions-td37849.html

Michael.

<snip>

Try running with strace to see where exactly the problem is, IF there is really an IO problem.

Ludo

Al 07/03/13 20:50, En/na Krzysztof ha escrit:

Does the database file reside in a shared folder?
Those don't work too well in VirtualBox, at least they don't work here with a linux host and a windows xp guest.
I had to use samba on the host to share folders and even then I had to disable kernel oplocks.

Bye

Shared folder was the problem. Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20130308/10c2b823/attachment.html>