[sqlite] SQLite crashes

On the SQLITE_OMIT_LOOKASIDE macro. On Fri, Nov 27, 2015 at 2:45 PM, Richard Hipp wrote: > The lookaside memory allocator is a fast memory pool used by > individual database connections for short-lived memory allocations. > It makes SQLite run faster, but by bypassing the system >

[sqlite] SQLite crashes

> (1) Recompile with the following compile-time options: -DSQLITE_DEBUG > -DSQLITE_OMIT_LOOKASIDE > > (2) Enable whatever AddressSanitizer tools > (https://en.wikipedia.org/wiki/AddressSanitizer) you have available on your > platform, in addition to (1) above. > > (3) If you do not have an

[sqlite] SQLite crashes

On 11/27/15, Harmen de Jong - CoachR Group B.V. wrote: >> (1) Recompile with the following compile-time options: -DSQLITE_DEBUG >> -DSQLITE_OMIT_LOOKASIDE >> >> (2) Enable whatever AddressSanitizer tools >> (https://en.wikipedia.org/wiki/AddressSanitizer) you have available on >> your platform,

[sqlite] SQLite crashes

On 20 Nov 2015, at 3:07pm, Harmen de Jong - CoachR Group B.V. wrote: > SQLITE crashes at least once a day on a heavily loaded database Can you run PRAGMA integrity_check on the database ? If you don't want to tie up your live copy, copy it somewhere else and run the PRAGMA on the copy.

[sqlite] SQLite crashes

SQLITE crashes at least once a day on a heavily loaded database (database size is approximately: 17 GB). On the same server we are running several other instances of SQLite that have databases that are much bigger in size with approximately the same load, however these are not crashing. The

[sqlite] SQLite crashes

On 11/20/15, Harmen de Jong - CoachR Group B.V. wrote: > > Any ideas on how we could further investigate these crashes? > (1) Recompile with the following compile-time options: -DSQLITE_DEBUG -DSQLITE_OMIT_LOOKASIDE (2) Enable whatever AddressSanitizer tools

Re: [sqlite] Sqlite crashes on FTS query

On Sat, Mar 23, 2013 at 6:12 PM, Tamás Kovács wrote: > Here's how to reproduce it: > - Get the latest sqlite shell for windows: > http://www.sqlite.org/2013/sqlite-shell-win32-x86-3071600.zip > - Download and extract this database: > https://dl.dropbox.com/u/242199/db.zip > -

Re: [sqlite] Sqlite crashes on FTS query

At 23:12 23/03/2013, you wrote: ´¯¯¯ Here's how to reproduce it: - Get the latest sqlite shell for windows: http://www.sqlite.org/2013/sqlite-shell-win32-x86-3071600.zip - Download and extract this database: https://dl.dropbox.com/u/242199/db.zip - Run this query: SELECT rowid FROM ad_text

[sqlite] Sqlite crashes on FTS query

Here's how to reproduce it: - Get the latest sqlite shell for windows: http://www.sqlite.org/2013/sqlite-shell-win32-x86-3071600.zip - Download and extract this database: https://dl.dropbox.com/u/242199/db.zip - Run this query: SELECT rowid FROM ad_text WHERE title MATCH 'text:t60 NEAR/6 lenovo';

Re: [sqlite] SQLite crashes due to invalid pointer

On Sun, Dec 12, 2010 at 3:28 AM, Wanadoo Hartwig < hartwig.wiesm...@wanadoo.nl> wrote: > Hi, > > sorry, but I thought that there would have been an automatic conversion to > a float. The comparison is not 1 but a floating point literal like 1.0. > I'm thinking you are making other assumptions as

Re: [sqlite] SQLite crashes due to invalid pointer

Hi, sorry, but I thought that there would have been an automatic conversion to a float. The comparison is not 1 but a floating point literal like 1.0. Am 12.12.2010 um 03:49 schrieb Richard Hipp: > On Sat, Dec 11, 2010 at 7:07 PM, Wanadoo Hartwig < > hartwig.wiesm...@wanadoo.nl> wrote: > >>

Re: [sqlite] SQLite crashes due to invalid pointer

On Sat, Dec 11, 2010 at 7:07 PM, Wanadoo Hartwig < hartwig.wiesm...@wanadoo.nl> wrote: > Hi, > > take the following SQL statement: > > UPDATE tableA SET column1=(SELECT column2 FROM tableB WHERE > function1(column3) < 1 ORDER BY function1(column3) LIMIT 1); > > Actually, this statement does not

[sqlite] SQLite crashes due to invalid pointer

Hi, take the following SQL statement: UPDATE tableA SET column1=(SELECT column2 FROM tableB WHERE function1(column3) < 1 ORDER BY function1(column3) LIMIT 1); Actually, this statement does not make sense because the ORDER BY expression does not fulfill the requirements of an ORDER BY

Re: [sqlite] SQLite crashes when trying to INSERT into table with wrong default value

On Sep 30, 2009, at 1:33 PM, ste...@schallerl.com wrote: > Hi all, > > i've got a table: > CREATE TABLE [usr_user] ([id] INTEGER PRIMARY KEY AUTOINCREMENT, > [name] TEXT, [email] TEXT, [password] TEXT, [createDate] DATETIME > DEFAULT (NOW())) Looks like the same problem as this one:

[sqlite] SQLite crashes when trying to INSERT into table with wrong default value

Hi all, i've got a table: CREATE TABLE [usr_user] ([id] INTEGER PRIMARY KEY AUTOINCREMENT, [name] TEXT, [email] TEXT, [password] TEXT, [createDate] DATETIME DEFAULT (NOW())) see the problem? i figured out myself that "NOW()" as a default value doesn't work (i'm new with sqlite, coming from

Re: [sqlite] SQLite Crashes

> I put a pointer to the mozilla bug report here: I probably should have mentioned our bug report as well. It's bug 408518 [1]. > These stack traces don't make any sense to me either. The definition > of sqlite3_enable_shared_cache() in SQLite cvs is: That, and as far as I can tell it's ever

Re: [sqlite] SQLite Crashes

On Mar 2, 2008, at 4:42 AM, Shawn Wilsher wrote: > Hey all, > > Over at Mozilla we've been seeing a large amount of crashes in > sqlite3_enable_shared_cache. The stack frames don't make a whole lot > of sense to me, so I thought I'd inform you and hope that you might > have a better idea as to

[sqlite] SQLite Crashes

Hey all, Over at Mozilla we've been seeing a large amount of crashes in sqlite3_enable_shared_cache. The stack frames don't make a whole lot of sense to me, so I thought I'd inform you and hope that you might have a better idea as to what is going on. If you have any questions, feel free to

Re: [sqlite] Sqlite crashes when i imort huge list

On 6/26/06, C.Peachment <[EMAIL PROTECTED]> wrote: >>The use of sequential numbers as the trailing part of the 'word' >>results in a continual rebalancing of the b-tree with each insertion. >Is that right considering it looks like you have not created an index on >the word column before

RE: [sqlite] Sqlite crashes when i imort huge list

On Mon, 26 Jun 2006 11:20:59 +0100, Brandon, Nicholas (UK) wrote: >>The use of sequential numbers as the trailing part of the 'word' >>results in a continual rebalancing of the b-tree with each insertion. >Is that right considering it looks like you have not created an index on >the word

RE: [sqlite] Sqlite crashes when i imort huge list

>The use of sequential numbers as the trailing part of the 'word' >results in a continual rebalancing of the b-tree with each insertion. Is that right considering it looks like you have not created an index on the word column before inserting the data? Nick

Re: [sqlite] Sqlite crashes when i imort huge list

Aha, sorry Richard, it seems you may have been right. I downloaded a different gui call SQLite Administrator and it is importing now. The first gui i used, used 100% of my cpu and crashes, this new one doesn't use much but it is a sloow process.Have been running it for about 10 mins

Re: [sqlite] Sqlite crashes when i imort huge list

Thanks guys, Richard: The reason i didn't mention the software is because all guis just create the text commands anyway so they all do the same thing. I doubt it is a problem with the gui i used which was "SQLite database browser". Chris: Thanks for that but i dont know how that helps me. Are

Re: [sqlite] Sqlite crashes when i imort huge list

There was a small error in my previous post. The 'begin transaction;' line was missed when I copied the text out of the script and editted it to remove the code around the text. On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote: >I am using the sqlite gui and click import table from csv. I

Re: [sqlite] Sqlite crashes when i imort huge list

On Sat, 24 Jun 2006 20:10:58 -0700 (PDT), onemind wrote: >I am using the sqlite gui and click import table from csv. I select a txt >file that contain over 200,000 words in a list. Sqlite works fine with a >smaller list of 200-300 words but when i import my big list, it hangs for >ages or

[sqlite] Sqlite crashes when i imort huge list

Hi, I am using the sqlite gui and click import table from csv. I select a txt file that contain over 200,000 words in a list. Sqlite works fine with a smaller list of 200-300 words but when i import my big list, it hangs for ages or completely crashes my computer. Does anyone know how i can

Re: [sqlite] SQLite crashes during rapid inserts!

At 2:07 PM +0100 6/24/04, Chris Ulliott wrote: Hi all, I am using the SQLite DB with MS VC++ v 6. In the code below you can see I am looping around a ODBC connection to an access database and I am inserting those records into my new SQLite database. My problem is SQLite.dll causes an access

[sqlite] SQLite crashes during rapid inserts!

Hi all, I am using the SQLite DB with MS VC++ v 6. In the code below you can see I am looping around a ODBC connection to an access database and I am inserting those records into my new SQLite database. My problem is SQLite.dll causes an access violation after inserting about 190 records. Does