[sqlite] Occasional "cannot commit - no transaction is active"

I'm running SQLite 3.6.22 on Linux, with shared cache enabled and multiple sqlite3 connections open from multiple threads (a dedicated connection in each thread - no connection sharing between threads). In one thread I'm executing a set of SQL statements, bracketed by BEGIN and COMMIT. That set

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses) [BUG?]

Hi Luke, Luke Evans wrote: > Hi Marcus, > > Well, I'd certainly be interested in looking at your code. Can you mail a > zip, or post to a web or file hosting site? Thanks. ok, please try this: http://www.exomio.de/SqliteSpeedTest.c I havent tried yet to compare the numbers when using one

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses) [BUG?]

Hi Marcus, Well, I'd certainly be interested in looking at your code. Can you mail a zip, or post to a web or file hosting site? Thanks. Your results seem to broadly agree with mine: multithreaded querying can save a percentage of time (10-30%?) over the same queries issued serially with no

Re: [sqlite] sqlite3 delete does not delete everything?

On Mar 11, 2010, at 12:18 PM, Skand wrote: >> >> Run REINDEX on your database. >> >> Get SQLite 3.6.23 and use that in place of 3.3.6 moving forward. >> > > REINDEX throws following error: > > SQL error: indexed columns are not unique > > Is there a graceful way to fix this? Run sqlite3

Re: [sqlite] sqlite3 delete does not delete everything?

D. Richard Hipp wrote: > > > On Mar 11, 2010, at 11:42 AM, Skand wrote: > >> >> >> D. Richard Hipp wrote: >>> >>> >>> On Mar 11, 2010, at 11:13 AM, Skand wrote: >>> >>> sqlite> select count(*) from ip_domain_table where ttl < 99 ; 1605343 >>> >>> What does

Re: [sqlite] Sqlite without 64-bit integers?

Hi, I am having the same problem here. Did someone tested the solution gave by mattias? Are there any problems? Mattias Ohlsson-3 wrote: > > I'm trying to use the SQLite database in an embedded system that does not > have 64-bit integers, i.e. long long, which is used in SQLite. I've >

Re: [sqlite] sqlite3 delete does not delete everything?

On Mar 11, 2010, at 11:42 AM, Skand wrote: > > > D. Richard Hipp wrote: >> >> >> On Mar 11, 2010, at 11:13 AM, Skand wrote: >> >> >>> >>> sqlite> select count(*) from ip_domain_table where ttl < >>> 99 ; >>> >>> 1605343 >> >> What does "PRAGMA integrity_check" show you at this point?

Re: [sqlite] sqlite3 delete does not delete everything?

On 11 Mar 2010, at 4:44pm, Skand wrote: > sqlite> SELECT ttl,typeof(ttl) FROM ip_domain_table WHERE ttl < 99 > LIMIT 10 > ...> ; > 1266895620|integer Okay, that's not the problem, but your response to Richard's post does betray the problem and should attract a useful response.

Re: [sqlite] sqlite3 delete does not delete everything?

Simon Slavin-3 wrote: > > > >> sqlite> select * from ip_domain_table where ttl < 99 limit 1; >> 107.35.138.41|127.2.0.2|1266895619 > > Although you have defined your column type as INTEGER, it's possible that > you have some values in that column which are of other types. Even the >

Re: [sqlite] sqlite3 delete does not delete everything?

D. Richard Hipp wrote: > > > On Mar 11, 2010, at 11:13 AM, Skand wrote: > > >> >> sqlite> select count(*) from ip_domain_table where ttl < 99 ; >> >> 1605343 > > What does "PRAGMA integrity_check" show you at this point? > > The integrity check shows 395 lines similar to: "rowid

Re: [sqlite] sqlite3 delete does not delete everything?

On 11 Mar 2010, at 4:13pm, Skand wrote: > sqlite> select count(*) from ip_domain_table where ttl < 99 ; > > 258 > > sqlite> select * from ip_domain_table where ttl < 99 limit 1; > 107.35.138.41|127.2.0.2|1266895619 Although you have defined your column type as INTEGER, it's

Re: [sqlite] sqlite3 delete does not delete everything?

On Mar 11, 2010, at 11:13 AM, Skand wrote: > > Hi Folks, > > Whats going on here? I would expect the following delete to delete > everything under 99. > > sqlite> .schema > > CREATE TABLE ip_domain_table (ip_domain TEXT, answer TEXT, ttl > INTEGER, > PRIMARY KEY(ip_domain, answer,

Re: [sqlite] sqlite3 delete does not delete everything?

On Mar 11, 2010, at 11:13 PM, Skand wrote: > > Hi Folks, > > Whats going on here? I would expect the following delete to delete > everything under 99. > > sqlite> .schema > > CREATE TABLE ip_domain_table (ip_domain TEXT, answer TEXT, ttl > INTEGER, > PRIMARY KEY(ip_domain, answer,

[sqlite] sqlite3 delete does not delete everything?

Hi Folks, Whats going on here? I would expect the following delete to delete everything under 99. sqlite> .schema CREATE TABLE ip_domain_table (ip_domain TEXT, answer TEXT, ttl INTEGER, PRIMARY KEY(ip_domain, answer, ttl)); sqlite> select count(*) from ip_domain_table where ttl <

Re: [sqlite] SQLite file format

On Thu, Mar 11, 2010 at 9:46 AM, Diana Chan wrote: > I have some questions about SQLite.  I would like to know if it's possible > to use SQLite as storage for huge genomic datasets. These datasets are > currently in netcdf format. I'm wondering if it's possible to convert

[sqlite] SQLite file format

I have some questions about SQLite. I would like to know if it's possible to use SQLite as storage for huge genomic datasets. These datasets are currently in netcdf format. I'm wondering if it's possible to convert them to the SQLite file saved format.

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses) [BUG?]

I have followed the discussion about this issue with interest since my usage of sqlite involves threads and sharedcache mode as well. I have also generated a little speed test program that uses multible threads and shared cache to read *some* rows out of the sqlite DB. It might not help here but

Re: [sqlite] SQLITE

On Mar 11, 2010, at 8:46 AM, mona.alsha...@gmail.com wrote: > Hello, > Thanks for your fast reply. > > I just did uninstalled itunes, restarted my pc then downloaded it > again facing same problem. > > When I click Microsoft online solution they direct me to SQlite but > I don't know which

Re: [sqlite] SQLITE

On Mar 11, 2010, at 8:20 AM, Muna Al Shaikh wrote: > > Hello, > > I need help, every time i open my iTunes and go to iTune store i got > an error . and when i search for a solution i get directed to SQlite > website.. but there are many files and i dont really know which one > to choose