In the description of the backup API, (http://www.sqlite.org/backup.html) ,
it is said
It cannot be used to copy data to or from in-memory databases.
which is followed by
Example 1: Loading and Saving In-Memory Databases
Isn't this contradictory ? If sqlite backup API is not meant for use
The crash is a result of -O3 flag used during compiling the library.
-Sreekumar
On Sat, Mar 3, 2012 at 2:00 PM, Sreekumar TP sreekumar...@gmail.com wrote:
Its does not crash on x86. I havent built the shell for my mips device.
Sreekumar
On Mar 3, 2012 10:26 AM, Dan Kennedy danielk1
GNU C (Sourcery CodeBench 2011.03-95) version 4.5.2 (mips-linux-gnu)
compiled by GNU C version 4.3.2, GMP version 4.3.2, MPFR version
2.4.2, MPC version 0.8.1
On Mon, Mar 5, 2012 at 6:12 PM, Richard Hipp d...@sqlite.org wrote:
On Mon, Mar 5, 2012 at 7:04 AM, Sreekumar TP sreekumar
Its does not crash on x86. I havent built the shell for my mips device.
Sreekumar
On Mar 3, 2012 10:26 AM, Dan Kennedy danielk1...@gmail.com wrote:
On 03/03/2012 10:30 AM, Sreekumar TP wrote:
Could someone throw some light on this issue too?
I can't see from the stack trace why
Could someone throw some light on this issue too?
Sreekumar
On Mar 2, 2012 10:05 AM, Sreekumar TP sreekumar...@gmail.com wrote:
The backtrace
===
Program received signal SIGSEGV, Segmentation fault.
0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, yyminor=...,
pParse
Hi,
Is SELECT COUNT (DISTINCT column_name FROM table) syntax supported ?
The above causes a crash in sqlite3Parser function..
-Regards,
Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
doesnt work either.
On Thu, Mar 1, 2012 at 2:50 PM, Petite Abeille petite.abei...@gmail.comwrote:
On Mar 1, 2012, at 9:46 AM, Sreekumar TP wrote:
Is SELECT COUNT (DISTINCT column_name FROM table) syntax supported ?
try:
select count( distinct foo ) from bar
In my system, the statement causes sqlite3parser function to crash.
My compiler is mips , little endian, gcc version is 4.5.2
-Sreekumar
On Thu, Mar 1, 2012 at 2:59 PM, Simon Davies
simon.james.dav...@gmail.comwrote:
On 1 March 2012 09:22, Sreekumar TP sreekumar...@gmail.com wrote
version 3.7.7.1
The query works on x86, but fails on MIPS processor!
Sreekumar
On Thu, Mar 1, 2012 at 7:00 PM, Dan Kennedy danielk1...@gmail.com wrote:
On 03/01/2012 05:48 PM, Sreekumar TP wrote:
In my system, the statement causes sqlite3parser function to crash.
My compiler is mips
\000\000\000\000
On Thu, Mar 1, 2012 at 11:42 PM, Dan Kennedy danielk1...@gmail.com wrote:
On 03/01/2012 10:54 PM, Sreekumar TP wrote:
version 3.7.7.1
The query works on x86, but fails on MIPS processor!
Are you able to post a stack trace? Ideally generated
I have a 'database is locked' issued which can be reproduced as follows.
I have two applications opening the database in WAL mode. The threading
mode is SERIALIZED. Environment is PC/Linux.
Step1: Launch App1 followed by App 2 ( same executables)
Step 2: App1 Prepares a SELECT statement and
:
On Fri, Feb 10, 2012 at 6:47 AM, Sreekumar TP sreekumar...@gmail.com
wrote:
I have a 'database is locked' issued which can be reproduced as follows.
I have two applications opening the database in WAL mode. The threading
mode is SERIALIZED. Environment is PC/Linux.
Step1
, at 11:47am, Sreekumar TP wrote:
I have a 'database is locked' issued which can be reproduced as follows.
I have two applications opening the database in WAL mode. The threading
mode is SERIALIZED. Environment is PC/Linux.
Step1: Launch App1 followed by App 2 ( same executables
...@bigfraud.org wrote:
On 10 Feb 2012, at 1:32pm, Sreekumar TP wrote:
well, the 'wait' is a simulation of what happens in the real code.
The error is fatal to the application as it never ever recovers from it
even though the writer has finalized and terminated.
In a multi-process environment I
The last transaction should always be the final one. In a a
multiprocess/threaded application how can one make assumptions on the order
of updates?
Sreekumar
On Fri, Feb 10, 2012 at 8:16 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sreekumar TP sreekumar...@gmail.com wrote:
How
I took traces of the lock/unlock pattern -
After App1 SELECT
--
fcntl -1212610880 7 SETLK WRLCK 124 1 0 0
WAL806F9D8: acquire EXCLUSIVE-READ-LOCK[1] cnt=1 ok
fcntl -1212610880 7 SETLK UNLCK 124 1 0 0
WAL806F9D8: release EXCLUSIVE-READ-LOCK[1] cnt=1
fcntl -1212610880 7 SETLK RDLCK
There is no recovery from this situation-
If you try to rollback, you get the following error -cannot rollback
savepoint, SQL statments in progress or if you dont use SAVEPOINT -
cannot rollback, no transaction is active
If you start the transaction with BEGIN IMMEDIATE in App1, the writer in
itandet...@mvps.orgwrote:
On 2/10/2012 9:57 AM, Sreekumar TP wrote:
The last transaction should always be the final one. In a a
multiprocess/threaded application how can one make assumptions on the
order
of updates?
There are two updates in my example:
update t set count = count + 1
Can this situation be handled in sqlite - by upgrading the lock to a
writer lock ? Since both applications use the same WAL file for read and
writes, it shouldnt be a problem , because all changes will be in linear
sequence ?
Sreekumar
On Fri, Feb 10, 2012 at 10:49 PM, Sreekumar TP sreekumar
Hi,
I have a nested transaction as follows -
sqlite3_prepare_v2(db, stmt1..)
sqlite3_prepare_v2(db, stmt2..)
sqlite3_step(stmt1)
sqlite3_step(stmt2)
sqlite3_reset(stmt2)
sqlite3_step(stmt1)
(1) SQLITE , as I understand does not support nested transaction, hence the
the above statement
Why is this treated as a a single transaction?
Sreekumar
On Feb 6, 2012 6:27 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sreekumar TP sreekumar...@gmail.com wrote:
I have a nested transaction as follows -
sqlite3_prepare_v2(db, stmt1..)
sqlite3_prepare_v2(db, stmt2..)
sqlite3_step
, Igor Tandetnik itandet...@mvps.org wrote:
Sreekumar TP sreekumar...@gmail.com wrote:
Why is this treated as a a single transaction?
Well, because that's how SQLite works. Why shouldn't it be?
--
Igor Tandetnik
___
sqlite-users mailing list
so if stmt1 stmt2 are executed on different threads , but on the same
connection, they would not block each other?
Sreekumar
On Feb 6, 2012 8:08 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sreekumar TP sreekumar...@gmail.com wrote:
well, if stmt1 is a write transaction, it would aquire
Hi,
I have get the following error when a sql statment is executed ( query ) -
database disk image is malformed.
On running the quick_check pragma on the db, I get the following log -
*** in database main ***
On tree page 1595 cell 5: Rowid 2104 out of order (max larger than parent
max of 2068)
at 2:21 PM, Roger Binns rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 23/01/12 00:13, Sreekumar TP wrote:
What can I infer from these logs ?
Your database is corrupted. Here is a list of possible causes:
http://www.sqlite.org/howtocorrupt.html
Roger
that there was no checkpoint in progress when the power
was turned OFF. Hence syncs should not be a problem ?
-Sreekumar
On Mon, Jan 23, 2012 at 3:00 PM, Roger Binns rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 23/01/12 01:03, Sreekumar TP wrote
Hi,
I have ICU integrated with SQLITE.
How do I specify a diacritic insensitive search ?.
ex:- when I search for all strings that begin with 'e', the result set
should return all strings that begin with 'e' as well as the accentuated
'e'.
-Sreekumar
Hi ,
I have a strange problem. I do the following in sequence -
1. open database
2. set pragmas
3.create table
4. prepare a paremetrised statement ( SELECT ..)
5. bind values to the statement
6. step
At 5, I get the error library routine called out of sequence.
If I replace the parameterised
you have a single-threaded application
accessing database?
Pavel
On Fri, Dec 23, 2011 at 3:32 AM, Sreekumar TP sreekumar...@gmail.com
wrote:
Hi ,
I have a strange problem. I do the following in sequence -
1. open database
2. set pragmas
3.create table
4. prepare a paremetrised
I am 99% certain that it is the very first call. unless the step and reset
executed once before.(the bind , step, reset is in a loop). I will double
check this.
Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi,
If I share a database across two process , both have sqlite threading mode
to serialized, do I still need to serialize the access to the database ?
-Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
wrote:
RH On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP sreekumar...@gmail.com
wrote:
RH Because we have experimentally determined that it is faster to
overwrite an
RH existing file than to append to a file. So we don't truncate the WAL
file
RH on a checkpoint, which makes subsequent writes
Hello,
During the measurement of manual checkpoint times, I see the following
behaviour -
# of WAL frames checkpointed is over 1000
size of DB has not changed after checkpoint.(measured using fstat)
Time for the checkpoint if around 500 ms.
Why is it that eventhough 1000+ frames are
There is another reader but sharing the same connection. So checkpoint
process cannot be blocked by another reader.
On Thu, Dec 1, 2011 at 8:54 PM, Yves Goergen nospam.l...@unclassified.dewrote:
On 01.12.2011 18:58 CE(S)T, Sreekumar TP wrote:
During the measurement of manual checkpoint
Hello,
I have sqlite configure to do manual checkpoint. I do checkpoint every few
hundred records. I expect the WAL to reduce in size and become zero when
there are no more inserts done.
However, I see that the WAL file size is static and does not reduce in
size. Why isnt manual checkpoint
Hi Richard,
How does sqlite determine the right size for the WAL file? Application can
ofcourse indicate the maximum size.
-Sreekumar
On Wed, Nov 30, 2011 at 4:02 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP sreekumar...@gmail.com
wrote:
Hello
Hello,
Is it possible to insert multiple rows using a single statement ?
Kind Regards,
Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at
possibilities of making the insertions faster.
-Sreekumar
On Tue, Nov 29, 2011 at 4:36 PM, Donald Griggs dfgri...@gmail.com wrote:
Sreekumar,
Regarding:
Is it possible to insert multiple rows using a single
Hi,
I have auto vacuum switched off and do not perform a manual vacuum. In this
scenario will the database size keep increasing when records are inserted
even as records are deleted.
As I understand from the documentation,
When auto-vacuum is disabled and data is deleted data from a database,
or space in pages
are available to insert data. Is this inference valid?
Sreekumar
On Nov 18, 2011 9:09 PM, Simon Slavin slav...@bigfraud.org wrote:
On 18 Nov 2011, at 3:18pm, Sreekumar TP wrote:
I have auto vacuum switched off and do not perform a manual vacuum. In
this
scenario
And if the pages are defragmented heavily, new inserts could result in
database size increase until vacuum is performed.?
Sreekumar
On Nov 18, 2011 9:38 PM, Simon Slavin slav...@bigfraud.org wrote:
On 18 Nov 2011, at 3:51pm, Sreekumar TP wrote:
So if my database grew to 20Mb and later lots
Hi,
In case of a prepared statement that uses SELECT
, the first sqlite3_step statement consumes a lot of time (order of
magnitude can be 100 or more)
when compared to the subsequent executions of step used to iterate through
the results. Does the first execution of step cache the entire result
Hi,
I do not have a ORDER BY , only a WHERE clause. So sorting should not be
the cause for the overhead.
-Sreekumar
On Mon, Oct 17, 2011 at 9:08 AM, Simon Slavin slav...@bigfraud.org wrote:
On 17 Oct 2011, at 4:22am, Sreekumar TP wrote:
In case of a prepared statement that uses SELECT
Hi,
Which would be the quick way to clear all records in a table ( assumming
100,000 records) ?
1. Delete * from table_name
2. DROP TABLE table_name followed by CREATE TABLE
-Sreekumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
To conclude on this topic, I figured out the usage of '_' .
--Original Message--
From: Igor Tandetnik
Sender: sqlite-users-boun...@sqlite.org
To: sqlite-users@sqlite.org
ReplyTo: General Discussion of SQLite Database
Subject: Re: [sqlite] Sqlite+ICU library and usage of LIKE
Sent: Sep
Hi,
I am using ICU library to collate and pattern match strings in Russian
language. I use C api to intialise the icu library .
sqlite3IcuInit(db);
zSQL = sqlite3_snprintf(1024,temp1,SELECT icu_load_collation('ru_RU',
'RUSSIAN'););
sqlite3_prepare_v2(db,(const char *)zSQL,-1,CollationStmt,
I get the following error when I use % or _
error @ 101, 1,1,unrecognized token: 'м
On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 9/6/2011 11:41 AM, Sreekumar TP wrote:
If I modify the statement to return all strings which match 'м' , No
strings
are fetched
Some elementary issue in my code, works fine now.
Tks
-Sreekumar
2011/9/6 Sreekumar TP sreekumar...@gmail.com
I get the following error when I use % or _
error @ 101, 1,1,unrecognized token: 'м
On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik itandet...@mvps.orgwrote:
On 9/6/2011 11:41 AM
I understand that WAL mode of sqlite is not supported over network file
systems. Does this mean that if my DB is in a filesystem mounted on a NFS
server will also not work in WAL mode? If so what is the bottleneck?
Sent from BlackBerry® on Airtel
___
Well, my system configuration is such that the RFS is mounted via NFS server.
All the processes that access the DB will be on the same CPU.
--Original Message--
From: Pavel Ivanov
To: Sreekumar TP
To: General Discussion of SQLite Database
Subject: Re: [sqlite] WAL mode and Network
Hi,
1.What's the fastest way to retrieve the last record in the DB.
2. Sqlite3_step takes you to the next record. Is there an equivalent for
navigating backwards ?
Sent from BlackBerry® on Airtel
___
sqlite-users mailing list
sqlite-users@sqlite.org
Let's say there is a table in a db that holds a few thousands of records..
Records are inserted and deleted from the table. At any given point I should be
able to retrieve the 'last' record..
'Last' is probably the record which is stored at the node with max depth?
--Original
Is 'last' valid only for 'ordered' set of records?
--Original Message--
From: Igor Tandetnik
Sender: sqlite-users-boun...@sqlite.org
To: sqlite-users@sqlite.org
ReplyTo: General Discussion of SQLite Database
Subject: Re: [sqlite] Last record in db
Sent: Aug 22, 2011 18:51
I understand now.
How does sqlite insert a record ? More specifically how does sqlite update the
B-tree with the new record . Is there a linkage made between the newly inserted
record and the previous one ?
Sent from BlackBerry® on Airtel
-Original Message-
From: Simon Slavin
Hi,
I have the results from the tests (below). Alot of the time is spent in
checking file permissions and locking the file (40 %).
Inmem
% time seconds usecs/call callserrors syscall
-- --- --- - -
28.530.124727
!
access(/dev/shm/test.db-journal, F_OK) = -1 ENOENT (No such file or
directory)
access(/dev/shm/test.db-wal, F_OK) = -1 ENOENT (No such file or
directory)
-Sreekumar
On Wed, Aug 10, 2011 at 5:28 PM, Sreekumar TP sreekumar...@gmail.comwrote:
Hi,
I have the results from the tests (below). Alot
Thanks for the explanation. The journal mode was OFF which means there is
no journal file created. So why is it the check still performed ?
On Wed, Aug 10, 2011 at 10:24 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 10, 2011 at 12:40 PM, Sreekumar TP sreekumar...@gmail.com
wrote
, Sreekumar TP wrote:
Thanks for the explanation. The journal mode was OFF which means there
is
no journal file created. So why is it the check still performed ?
Because the journal mode might have been 'ON' the last time that database
was used.
On Wed, Aug 10, 2011 at 10:24 PM, Richard Hipp d
queries operations of the second
process)?
On Wed, Aug 10, 2011 at 10:54 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 10, 2011 at 1:09 PM, Simon Slavin slav...@bigfraud.org
wrote:
On 10 Aug 2011, at 6:01pm, Sreekumar TP wrote:
Thanks for the explanation. The journal mode
:
On Wed, Aug 10, 2011 at 1:35 PM, Sreekumar TP sreekumar...@gmail.com
wrote:
Ok, its getting a bit clear.
If there is only one process that is writing to the database, but has
more
than one process that reads the database, the locking mode can still be
exclusive ?
PRAGMA
Oh Yes. I missed that point !
On Wed, Aug 10, 2011 at 11:57 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 10, 2011 at 2:13 PM, Sreekumar TP sreekumar...@gmail.com
wrote:
But I sqlite can still check the number of db connections open
No it cannot.
In unix, there is no way
Pls list the compilation errors..
--Original Message--
From: Raja Kondu
Sender: sqlite-users-boun...@sqlite.org
To: sqlite-users@sqlite.org
ReplyTo: General Discussion of SQLite Database
Subject: [sqlite] sqlite-src-3070701.zip compilation issues
Sent: Aug 11, 2011 4:36 AM
Hi,
I have
Journal mode is WAL
--Original Message--
From: Roger Binns
Sender: sqlite-users-boun...@sqlite.org
To: General Discussion of SQLite Database
ReplyTo: General Discussion of SQLite Database
Subject: Re: [sqlite] In memory v/s tmpfs
Sent: Aug 9, 2011 2:42 PM
-BEGIN PGP SIGNED
HI,
I performed an experiment where I do db operations on an in-memory database and
compared it with the results from same operations on a database in tmpfs.(Same
db structure,records etc)
From the point of view of performance, I expected similar performance , tmpfs
being a little slower due
Hello,
Is there a relation between the wal index file size and the wal log file ? How
does sqlite allocate the max size for the index file. Could figure out scanning
thru the source code. However, if someone has already figured out, please share.
Sent from BlackBerry® on Airtel
2011 07:07:52
To: General Discussion of SQLite Databasesqlite-users@sqlite.org
Reply-To: General Discussion of SQLite Database sqlite-users@sqlite.org
Subject: Re: [sqlite] Sqlite-Wal file location
On Sun, Jul 31, 2011 at 11:51 PM, Sreekumar TP sreekumar...@gmail.comwrote:
Hello,
Inorder to suit
: [sqlite] Sqlite-Wal file location
On Sun, Jul 31, 2011 at 11:51 PM, Sreekumar TP sreekumar...@gmail.com
wrote:
Hello,
Inorder to suit the needs of my embedded device, I have changed the
location
of the .db-wal file from the location of the db file to tmpfs. Does
sqlite
make
Hello,
Inorder to suit the needs of my embedded device, I have changed the location
of the .db-wal file from the location of the db file to tmpfs. Does sqlite
make assumptions(persistence etc) based on the location of the file ?
___
sqlite-users
Hello,
(1) In SQLite versio 3.5.o an above we can enable the shared cache mode.
Is the shared cache shared between two processes ? OR is shared only
between the threads in the process ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
69 matches
Mail list logo