Thank you a lot for your answer.
Do you known more about this bug? Is there any other documentation?
Does it affect other code? Will apple fix it soon?
My currenct solution was using sqlite 3.7.1
Regards
Gilles Vollant
Le jeudi 1 décembre 2011, James Berry a écrit :
> Gilles,
>
> This is due t
Le jeudi 1 décembre 2011, James Berry a écrit :
> Gilles,
>
> This is due to bugs in llvm when compiling for arm6 with thumb mode
enabled. Passing -mno-thumb to the compiler will solve the problem.
>
> James
>
> On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:
>
>> Hello,
>>
>> I'm using a recom
(you only need to turn off thumb mode for the arm6 architecture) -jdb
On Nov 30, 2011, at 8:02 PM, James Berry wrote:
> Gilles,
>
> This is due to bugs in llvm when compiling for arm6 with thumb mode enabled.
> Passing -mno-thumb to the compiler will solve the problem.
>
> James
>
> On Nov 30
Gilles,
This is due to bugs in llvm when compiling for arm6 with thumb mode enabled.
Passing -mno-thumb to the compiler will solve the problem.
James
On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote:
> Hello,
>
> I'm using a recompiled version of SQLite in one project (I need FTS3 and now
>
Hello,
I'm using a recompiled version of SQLite in one project (I need FTS3 and now
FTS4 support, which is not avaiable in the sqlite included in iOS).
So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet.
I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion
targetin
Hello Richard,
Thanks again.
Wednesday, November 30, 2011, 5:37:32 PM, you wrote:
RH> On Wed, Nov 30, 2011 at 5:31 PM, Teg wrote:
>> Since we're on this topic
>>
>> If I open a 30 GB DB file, then attach a new empty DB and then
>> select/insert all the data from the full DB to th
On Wed, Nov 30, 2011 at 5:31 PM, Teg wrote:
> Since we're on this topic
>
> If I open a 30 GB DB file, then attach a new empty DB and then
> select/insert all the data from the full DB to the empty one, the WAL
> file grows to 4 times the size of the source file. Why is that?
>
> I
Since we're on this topic
If I open a 30 GB DB file, then attach a new empty DB and then
select/insert all the data from the full DB to the empty one, the WAL
file grows to 4 times the size of the source file. Why is that?
I don't believe I use any manual checkpointing. Just let WA
On 30 Nov 2011, at 7:01pm, Richard Hipp wrote:
> The wal file persists until the last connection to the database closes,
> then the wal file is deleted.
Actually this is the key to a lot of questions about this. If your WAL file is
taking up too much space, quit and restart your app. Or have
So how about the "pragma wal_trim" that does a checkpoint, grabs the lock,
trims, and drops the lock?
Or some other new keyword?
The WAL file never gets trimmed (just reused apparently) so having an explicit
way to trim it without having to close and reopen the database would seem quite
hand
Hello Richard,
That's what I was hoping to hear. Thanks,
Wednesday, November 30, 2011, 2:01:46 PM, you wrote:
RH> On Wed, Nov 30, 2011 at 1:39 PM, Teg wrote:
>> Hello Richard,
>>
>> Appreciate the reply but, it doesn't address my question (unless I'm
>> missing something). I get that checkpo
On Wed, Nov 30, 2011 at 1:39 PM, Teg wrote:
> Hello Richard,
>
> Appreciate the reply but, it doesn't address my question (unless I'm
> missing something). I get that checkpointing doesn't reduce the size
> of the WAL. Assuming a single writer and no readers, If I perform a
> transaction that gen
On Wed, Nov 30, 2011 at 1:21 PM, Black, Michael (IS) wrote:
> Maybe we need a "pragma wal_trim" ?? This would automatically trim it
> after a checkpoint? Or make it an explicit action?
>
checkpoint cannot trim. This is because of the rule that checkpoints will
never block either readers or wr
On Wed, Nov 30, 2011 at 1:30 PM, Adolfo Jiménez Millán wrote:
> Pavel:
>
> Thanks for your answer.
>
> By the way, there are a similar error when using the directive
> SQLITE_OMIT_ANALYZE
>
SQLITE_OMIT_ANALYZE won't work with the amalgamation because the
amalgamation is generated code, and differ
Hello Richard,
Appreciate the reply but, it doesn't address my question (unless I'm
missing something). I get that checkpointing doesn't reduce the size
of the WAL. Assuming a single writer and no readers, If I perform a
transaction that generates a WAL file. Does it eventually get deleted
when I
Pavel:
Thanks for your answer.
By the way, there are a similar error when using the directive
SQLITE_OMIT_ANALYZE
=0A--
Adolfo.
>
> Mensaje original
> De: Pavel Ivanov
> Para: a...@zator.com, General Discussion of SQLite Database
>
> Fecha: Wed, 30 Nov 2011 16:33:42 +0100
> Asun
Maybe we need a "pragma wal_trim" ?? This would automatically trim it after a
checkpoint? Or make it an explicit action?
Waiting for another write before truncating it seems too late and not a logical
thing to expect.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
A
On Wed, Nov 30, 2011 at 1:04 PM, Teg wrote:
> Hello Richard,
>
> When does the WAL get trimmed down? If my transaction completes, does
> the WAL file get deleted? I've seen the WAL grow to 4 times my actual
> DB size so, I don't really want 160 Gigs of WAL hanging out when the
> process that
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 wrote:
> On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP >wrote:
>
> > Hello,
> >
> > I have sqlite configure to do
Hello Richard,
When does the WAL get trimmed down? If my transaction completes, does
the WAL file get deleted? I've seen the WAL grow to 4 times my actual
DB size so, I don't really want 160 Gigs of WAL hanging out when the
process that generated it is only run once a month.
Wednesday, Novem
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/30/2011 03:41 PM, Pavel Ivanov wrote:
>> I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at
>> possibilities of making the insertions faster.
>
> Prepare your statement in the form
>
> INSERT INTO table_name (val1, val2, ...)
> I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at
> possibilities of making the insertions faster.
Prepare your statement in the form
INSERT INTO table_name (val1, val2, ...) VALUES (?1, ?2, ...)
Then for each row you want to insert you will bind necessary values,
execute
This will be fixed in next version. See
http://www.sqlite.org/src/info/5dbfaed8c3.
Pavel
On Wed, Nov 30, 2011 at 6:29 AM, Adolfo Jiménez Millán wrote:
> Hi all:
>
> Using MS VC++ 98, I try to compile the 3.7.9 amalgamation, using the
> SQLITE_OMIT_WAL directive, but then I get an error:
>
> sq
On Wed, Nov 30, 2011 at 4:02 PM, Richard Hipp wrote:
> On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP >wrote:
>
> > 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 ar
On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP wrote:
> 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 stati
On 11/30/2011 06:55 AM, Andy Spencer wrote:
I have seen documentation that SQLite uses POSIX advisory locks to
implement locking on Unix.
I have an issue in that attempts to operate on a sqlite database on a
Linux file system that has setgid bit (set group ID on execution) set
on the database fi
sworddrag...@aol.com wrote:
> I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on
> empty files it will create a default database (for
> example "touch /tmp/test.txt && sqlite3 /tmp/test.txt VACUUM").
>
> If this behaviour is wanted there should be an option to disable
I have seen documentation that SQLite uses POSIX advisory locks to
implement locking on Unix.
I have an issue in that attempts to operate on a sqlite database on a
Linux file system that has setgid bit (set group ID on execution) set
on the database file (e.g. chmod g+s) causes database operations
I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on
empty files it will create a default database (for example "touch /tmp/test.txt
&& sqlite3 /tmp/test.txt VACUUM").
If this behaviour is wanted there should be an option to disable this because
it could destroy complet
There is too much ambiguity with regards to needid; poor coding|edit
checking on my part. When I label everything properly, then the query runs
successfully (darn fast, too). I also changed the replacement tag @depth
to @dpth. When I was examining everything with notepad++, it highlighted
@depth
Sorry I mean MS V.Studio C++ 2008 (not 98)
--
A.J.Millán
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi all:
Using MS VC++ 98, I try to compile the 3.7.9 amalgamation, using the
SQLITE_OMIT_WAL directive, but then I get an error:
sqlite3.c(131886) : error C2129: static function 'void
sqlite3PagerClearCache(Pager *)' declared but not defined.
I've used some other directives, but all of them c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello there!
In os_unix.c, the following logic appears in unixSync:
/* Also fsync the directory containing the file if the DIRSYNC flag
** is set. This is a one-time occurrance. Many systems (examples: AIX)
** are unable to fsync a directory
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 reduci
On 30 Nov 2011, at 8:33am, Christoph P.U. Kukulies wrote:
> Does anybody know of additions to SQLITE (.NET) to provide for XML
> import/export.
SQLITE is just the bit that talks to SQLite databases. You can find some other
.NET library which does XML import/export and write some programming t
Does anybody know of additions to SQLITE (.NET) to provide for XML
import/export.
TIA
Christoph
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
36 matches
Mail list logo