Re: [sqlite] sqlite3_column_* with error handling

2018-09-13 Thread Brian Vincent
On Tue, Sep 4, 2018 at 4:11 PM Keith Medcalf wrote: > > On Tuesday, 4 September, 2018 14:00, Clemens Ladisch > wrote: > > >Keith Medcalf wrote: > >> 6) If the column type is SQLITE_BLOB > >> a) Retrieve the column value pointer using column_blob > >> b) If the returned pointer is

Re: [sqlite] sqlite3_column_* with error handling

2018-09-13 Thread Brian Vincent
On Tue, Sep 4, 2018 at 1:31 PM Keith Medcalf wrote: > > Well, that is not exactly true. If you attempt to retrieve the column > values properly, either no errors can occur or if they do, they are obvious. > > 1) Query the column_type > 2) If the column_type is SQLITE_NULL then return a NULL

Re: [sqlite] sqlite3_column_* with error handling

2018-09-13 Thread Brian Vincent
On Wed, Sep 5, 2018 at 5:22 AM Richard Hipp wrote: > On 9/4/18, Brian Vincent wrote: > > Hi, I'm currently writing a Go sqlite package, go-sqlite-lite. I think > it > > provides a good "pure" SQLite experience with Go. > > > > If I want to make sure t

[sqlite] sqlite3_column_* with error handling

2018-09-04 Thread Brian Vincent
l in this manner? Thanks, Brian Vincent ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

2016-07-14 Thread Brian Vincent
I've reproduced the issue using both SERIALIZED and MULTITHREADED modes. The issue here doesn't seem to have anything to do with the threading modes. The issue is related to shared caches, and waiting on a b-tree lock while holding the global SQLITE_MUTEX_STATIC_OPEN lock. - Brian Vincent

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

2016-07-11 Thread Brian Vincent
king about this problem clearly, or if you would like me to test some things or write a simple test case. Thanks, Brian Vincent On Sat, Jul 9, 2016 at 5:58 AM Olivier Mascia <o...@integral.be> wrote: > > Le 9 juil. 2016 à 12:33, Simon Slavin <slav...@bigfraud.org> a écrit : &g

[sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

2016-07-08 Thread Brian Vincent
sqlite3BtreeOpen () #3 0x7f2b7306bc77 in openDatabase () Thanks, Brian Vincent ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: Sqlite seg fault, probably after database gets corrupt

2013-08-01 Thread Brian Vincent
valid concern? -Brian Vincent On Thu, Aug 1, 2013 at 2:19 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Aug 1, 2013 at 2:20 PM, Brian Vincent <bra...@gmail.com> wrote: > > > I think I can describe, is a > > possibly way that a corrupt database is causi

[sqlite] Bug report: Sqlite seg fault, probably after database gets corrupt

2013-08-01 Thread Brian Vincent
Let me first say that we sometimes see databases that go corrupt. I haven't pinpointed the cause yet, but what I think I can describe, is a possibly way that a corrupt database is causing sqlite to segfault. I use a java wrapper for sqlite. I've seen this exact segfault happen on an older