Re: [sqlite] SQLite disk I/O error

[Richard Hipp]

On Wed, Jan 1, 2014 at 10:06 AM, Tal Tabakman wrote:

> Hi Richard,
>
> per your reply (attached below)
>
> we are printing the last error message using sqlite_errmsg ... is it
> enough ?
>
> anyway, the errors varies
>
> for example once I got an error when inserting to a table and then I
> got this for example:
>
> "Could no execute SQL statement: PRAGMA synchronous = 0 ; . Error :
> disk I/O error "
>
>
> does it help ?
>

No, not really.  sqlite3_extended_errcode() might help a little.  But
actually implementing a warning and error log would give us better
information.



>
> Could be a lot of things.  Depends on what you are doing, what system you
> are running on, etc.
>
> Can you enable the error log (http://www.sqlite.org/errlog.html) so that
> we
> can get more information?
>
>
>
> >* seems like that the work dir in which I generate the DB has more space
> in*
>
>
>
> On Wed, Jan 1, 2014 at 3:19 PM, Tal Tabakman 
> wrote:
>
> > Hi guys
> > what is the reason for getting errors of type  "SQLite disk I/O error"
> > when doing operation like insert on sqlite DB.
> > seems like that the work dir in which I generate the DB has more space in
> > it.
> >
> > any advice will be appreciated,
> >
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite disk I/O error

[Tal Tabakman]

Hi Richard,

per your reply (attached below)

we are printing the last error message using sqlite_errmsg ... is it enough ?

anyway, the errors varies

for example once I got an error when inserting to a table and then I
got this for example:

"Could no execute SQL statement: PRAGMA synchronous = 0 ; . Error :
disk I/O error "


does it help ?

Could be a lot of things.  Depends on what you are doing, what system you
are running on, etc.

Can you enable the error log (http://www.sqlite.org/errlog.html) so that we
can get more information?



>* seems like that the work dir in which I generate the DB has more space in*



On Wed, Jan 1, 2014 at 3:19 PM, Tal Tabakman  wrote:

> Hi guys
> what is the reason for getting errors of type  "SQLite disk I/O error"
> when doing operation like insert on sqlite DB.
> seems like that the work dir in which I generate the DB has more space in
> it.
>
> any advice will be appreciated,
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite disk I/O error

[Richard Hipp]

On Wed, Jan 1, 2014 at 8:19 AM, Tal Tabakman  wrote:

> Hi guys
> what is the reason for getting errors of type  "SQLite disk I/O error" when
> doing operation like insert on sqlite DB.
>

Could be a lot of things.  Depends on what you are doing, what system you
are running on, etc.

Can you enable the error log (http://www.sqlite.org/errlog.html) so that we
can get more information?



> seems like that the work dir in which I generate the DB has more space in
> it.
>
> any advice will be appreciated,
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite disk I/O error

[Tal Tabakman]

Hi guys
what is the reason for getting errors of type  "SQLite disk I/O error" when
doing operation like insert on sqlite DB.
seems like that the work dir in which I generate the DB has more space in
it.

any advice will be appreciated,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite - disk I/O error only on virtual machine

[Krzysztof]

Problem solved. It was shared folder issue
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite - disk I/O error only on virtual machine

[Krzysztof]

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
(this is Free Pascal / Lazarus wrapper for SQLite):

  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 don't know if this is problem in sqlite or in my Free Pascal wrapper. I
also reported it on FPC mailing list

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