Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 4 Dec 2010, at 10:42, Dan Kennedy wrote: > On 12/04/2010 12:54 AM, Philip Graham Willoughby wrote: >> On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote: >> >>> Hi, >>> >>> I am on macosx sqlite 3.7.3 >>> >>> $ /usr/local/bin/sqlite3 test.db3 >>> SQLite version 3.7.3 >>> Enter ".help" for instructions >>> Enter SQL statements terminated with a ";" >>> sqlite> .read ./testSchema.sql >>> sqlite> .read ./TestValues.sql >>> sqlite> .read ./TestQuery.sql >>> Otterbourne Golf Course|Jane Doe|Assumed Name >>> >>> it works for me. >> >> By default, assertions are not built - did you build with SQLITE_DEBUG? >> Assuming you did, what were your other build flags and which compiler did >> you use? > > Thanks for following up on this - your post on the 26th of last > month slipped through a crack... > > Turns out the bug is in the assert(), not the production code, so > there is no problem in non-SQLITE_DEBUG builds. It's now fixed for > 3.7.4. Brilliant news, thank you for looking into it. Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 12/04/2010 12:54 AM, Philip Graham Willoughby wrote: > On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote: > >> Hi, >> >> I am on macosx sqlite 3.7.3 >> >> $ /usr/local/bin/sqlite3 test.db3 >> SQLite version 3.7.3 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> .read ./testSchema.sql >> sqlite> .read ./TestValues.sql >> sqlite> .read ./TestQuery.sql >> Otterbourne Golf Course|Jane Doe|Assumed Name >> >> it works for me. > > By default, assertions are not built - did you build with SQLITE_DEBUG? > Assuming you did, what were your other build flags and which compiler did you > use? Thanks for following up on this - your post on the 26th of last month slipped through a crack... Turns out the bug is in the assert(), not the production code, so there is no problem in non-SQLITE_DEBUG builds. It's now fixed for 3.7.4. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
sorry yes I didn't compile with SQLITE_DEBUG I just did it, and I have the same error: $ /usr/local/bin/sqlite3 tst.db3 SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Assertion failed: (memIsValid(&u.bq.r.aMem[i])), function sqlite3VdbeExec, file sqlite3.c, line 64507. Abort trap On Sat, Dec 4, 2010 at 11:20 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > I used: > CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' > ./configure --disable-dependency-tracking > > my compiler is: > $ gcc --version > i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) > Copyright (C) 2007 Free Software Foundation, Inc. > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
I used: CFLAGS='-arch i686 -arch x86_64' LDFLAGS='-arch i686 -arch x86_64' ./configure --disable-dependency-tracking my compiler is: $ gcc --version i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664) Copyright (C) 2007 Free Software Foundation, Inc. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 2 Dec 2010, at 20:43, Sylvain Pointeau wrote: > Hi, > > I am on macosx sqlite 3.7.3 > > $ /usr/local/bin/sqlite3 test.db3 > SQLite version 3.7.3 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .read ./testSchema.sql > sqlite> .read ./TestValues.sql > sqlite> .read ./TestQuery.sql > Otterbourne Golf Course|Jane Doe|Assumed Name > > it works for me. By default, assertions are not built - did you build with SQLITE_DEBUG? Assuming you did, what were your other build flags and which compiler did you use? Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
Hi, I am on macosx sqlite 3.7.3 $ /usr/local/bin/sqlite3 test.db3 SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Otterbourne Golf Course|Jane Doe|Assumed Name it works for me. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 26 Nov 2010, at 10:28, Philip Graham Willoughby wrote: > On 25 Nov 2010, at 14:06, Dan Kennedy wrote: > >> On 11/25/2010 03:45 PM, Philip Graham Willoughby wrote: >>> Hi all, >>> >>> I'm noticing a new failure with SQLite 3.7.3 as compared to the previous >>> version I was using, 3.6.23.1. >> >> Are you able to share the database and the query that causes >> the assert() to fail? > > Here is a database and the query which causes the assert to fail: > > Database: http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/Test.base > Query SQL: > http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/TestQuery.sql > > If for any reason you wanted to recreate the DB the SQL to do so are these: > > Schema SQL: > http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/testSchema.sql > Data SQL: > http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/TestValues.sql > > My original schema is somewhat more complex so I have cut out some parts > which are not relevant to this problem. In attempting to create a cut-down > version I also tried removing players 2 and 3 from the CardsPlayers and > CardsPlayer[AB] tables, which caused the query to run successfully. I cannot > tell from that whether the problem is triggered by the presence of any values > in those tables or by the presence of relevant values in those tables. > > With a new empty database and these SQL statements with SQLite version 3.6.12 > (or 3.7.3 without SQLITE_DEBUG) I see this: > > SQLite version 3.6.12 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .read ./testSchema.sql > sqlite> .read ./TestValues.sql > sqlite> .read ./TestQuery.sql > Otterbourne Golf Course|Jane Doe|Assumed Name > sqlite> > > With a new empty database and these SQL statements with SQLite version 3.7.3 > (with SQLITE_DEBUG) I see this: > > SQLite version 3.7.3 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .read ./testSchema.sql > sqlite> .read ./TestValues.sql > sqlite> .read ./TestQuery.sql > Assertion failed: (memIsValid(&u.bq.r.aMem[i])), function sqlite3VdbeExec, > file sqlite3.c, line 64507. > Abort > > SQLite 3.7.3 fails in that manner when I run just the query on the 3.6.12 > database; similarly SQLite 3.6.12 gets the right answer when it queries the > 3.7.3 database. I infer from this that the data stored is fine it's just a > problem at query-time. I apologise for repeating my earlier message (above), but I didn't see any responses to it on the list so I'm beginning to wonder if it actually made it out of my email client. I'd appreciate any feedback; even knowing whether it is or is not reproducible by others would be very helpful. If this is a reproducible bug, is there anything else I need to do to report it? Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 25 Nov 2010, at 14:06, Dan Kennedy wrote: > On 11/25/2010 03:45 PM, Philip Graham Willoughby wrote: >> Hi all, >> >> I'm noticing a new failure with SQLite 3.7.3 as compared to the previous >> version I was using, 3.6.23.1. > > Are you able to share the database and the query that causes > the assert() to fail? Here is a database and the query which causes the assert to fail: Database: http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/Test.base Query SQL: http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/TestQuery.sql If for any reason you wanted to recreate the DB the SQL to do so are these: Schema SQL: http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/testSchema.sql Data SQL: http://dl.dropbox.com/u/10341475/SQLiteAssertionFailure/TestValues.sql My original schema is somewhat more complex so I have cut out some parts which are not relevant to this problem. In attempting to create a cut-down version I also tried removing players 2 and 3 from the CardsPlayers and CardsPlayer[AB] tables, which caused the query to run successfully. I cannot tell from that whether the problem is triggered by the presence of any values in those tables or by the presence of relevant values in those tables. With a new empty database and these SQL statements with SQLite version 3.6.12 (or 3.7.3 without SQLITE_DEBUG) I see this: SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Otterbourne Golf Course|Jane Doe|Assumed Name sqlite> With a new empty database and these SQL statements with SQLite version 3.7.3 (with SQLITE_DEBUG) I see this: SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read ./testSchema.sql sqlite> .read ./TestValues.sql sqlite> .read ./TestQuery.sql Assertion failed: (memIsValid(&u.bq.r.aMem[i])), function sqlite3VdbeExec, file sqlite3.c, line 64507. Abort SQLite 3.7.3 fails in that manner when I run just the query on the 3.6.12 database; similarly SQLite 3.6.12 gets the right answer when it queries the 3.7.3 database. I infer from this that the data stored is fine it's just a problem at query-time. Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Assertion failure in SQLite 3.7.3 (new vs. 3.6.23.1)
On 11/25/2010 03:45 PM, Philip Graham Willoughby wrote: > Hi all, > > I'm noticing a new failure with SQLite 3.7.3 as compared to the previous > version I was using, 3.6.23.1. Are you able to share the database and the query that causes the assert() to fail? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users