Re: [sqlite] compiling for android

2017-09-11 Thread Christian Czech 

Hi,

it guess it must be some special settings. We used sqlite quite some 
time now and the last build problem we got with ndk is quite long time ago.


Regards,
Christian

---
derago e. K., Gartenstr. 4, D-79807 Lottstetten, Amtsgericht Freiburg/Br. 
HRA621012, weitere Informationen unter http://www.derago.com/Impressum. Diese 
E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn 
Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten 
haben, informieren Sie bitte sofort den Absender und vernichten Sie diese 
E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail 
ist nicht gestattet.

Am 11.09.2017 um 17:28 schrieb Dan Kennedy:

On 09/11/2017 05:20 AM, Mark Sibly wrote:

Hi,

I just encountered a problem trying to build the sqlite amalgamation
package for android with the latest NDK (v15.2.4203891) on windows 10.

The compiler couldn't find mmap, which was causing a ton of errors.

I solved it by sticking this at the top-ish of sqlite3.c

#if __ANDROID__
#include 
#endif


Thanks for reporting this. Which version are you trying to build?

Are you building with any special options - SQLITE_OMIT_WAL or similar?

When things are working right, sys/mman.h should be included if 
required by the amalgamation equivalent of this line:


  http://www.sqlite.org/src/artifact/489aa972ccc34?ln=99

Can you post the first couple of compiler errors?

Dan.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VACUUM causes Out of memory error

2016-11-03 Thread Christian Czech 

sqlite is a great tool! And I  also use (and bought) the SEE version.

This bug in a release version did a lot of damage to us.

Especially frustrating was that nobody really cared when I reported it:

-

We have a problem with the latest stable release of SQLite. When 
compiled for 32 bit under windows and vacuum a database file larger than 
2GB, memory storage usage gets up to 2GB and than vacuum crashes with 
not enough memory. It seems that a temp file is not generated, not for 
standard and not for Wal database.


Anybody else got into this issue?



I only want to thank Stephan for reporting the same problem seperately 8 
days later and for getting the attention.


And Dan for fixing it.

In Pre-release Snapshot sqlite-snapshot-201611021450.tar.gz bug is 
really fixed. No issues anymore thanks finally!


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Christian Czech 

I already reported this in this forum a while ago but nobody cared.

It is only in the 32bit version when RAM usage gets over 2GB on windows. On 
64 bit of course this does not come up if u have enough ram. It is only 
with 3.15.0. It is easy to reproduce.


Problem is that intermediate temp file is never used. Regardless of settings.

It is a fundamental bug. I hope one day it gets fixed. Otherwise 3.15.0 is 
useless.




Am 2. November 2016 13:14:51 schrieb "Hennekens, Stephan" 
:



Hello,

Since last version of sqlite  (3.15.0) VACUUM causes an 'Out of memory' 
error, at least on my bigger databases (> 1 Gb). I came across this error 
when I installed the latest DISQLite3 version 
(http://www.yunqa.de/delphi/products/sqlite3/index). I was also able to 
reproduce the error when using Sqlite3.dll directly via a Delphi wrapper class.
In case needed you can download a compressed 2 GB file from here: 
http://www.synbiosys.alterra.nl/downloads/lvd.7z


Regards,

Stephan Hennekens
Wageningen Environmental Research (Alterra), The Netherlands
Tel: +31 (0)317 485887 | Mobile: +31 (0)6 20921403 | WUR internal: 85887
Skype: stephan.hennekens






___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in latest sqlite Release vacuum crashes?

2016-10-27 Thread Christian Czech 

Am 27.10.2016 um 14:00 schrieb sqlite-users-requ...@mailinglists.sqlite.org:

On 10/25/2016 01:25 AM, Christian Czech wrote:

>We have a problem with the latest stable release of SQLite. When
>compiled for 32 bit under windows and vacuum a database file larger
>than 2GB, memory storage usage gets up to 2GB and than vacuum crashes
>with not enough memory. It seems that a temp file is not generated,
>not for standard and not for Wal database.
>
>Anybody else got into this issue?

Is SQLite, due to some combination of the SQLITE_TEMP_STORE compile time
option and "PRAGMA temp_store" command, configured to use in-memory temp
files?

https://www.sqlite.org/compile.html#temp_store
No. I even explicitly set it off. But no change. When I use sqlite.c/h 
from previous stable version and do not change any settings, it works 
normally and the temp file is created.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug in latest sqlite Release vacuum crashes?

2016-10-24 Thread Christian Czech 
We have a problem with the latest stable release of SQLite. When compiled 
for 32 bit under windows and vacuum a database file larger than 2GB, memory 
storage usage gets up to 2GB and than vacuum crashes with not enough 
memory. It seems that a temp file is not generated, not for standard and 
not for Wal database.


Anybody else got into this issue?

Regards,
cc



Am 24. Oktober 2016 2:00:16 nachm. schrieb 
sqlite-users-requ...@mailinglists.sqlite.org:



Send sqlite-users mailing list submissions to
sqlite-users@mailinglists.sqlite.org

To subscribe or unsubscribe via the World Wide Web, visit
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
or, via email, send a message with subject or body 'help' to
sqlite-users-requ...@mailinglists.sqlite.org

You can reach the person managing the list at
sqlite-users-ow...@mailinglists.sqlite.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sqlite-users digest..."


Today's Topics:

   1. Re: Import 5000 xml files in a sqlite database file
  (Sylvain Pointeau)
   2. Re: Import 5000 xml files in a sqlite database file
  (Eduardo Morras)
   3. Development environment reccomendation (Philip Rhoades)
   4. How does the pager know whether its memory cache is still
  valid? (Rowan Worth)
   5. Re: How does the pager know whether its memory cache  is  still
  valid? (Clemens Ladisch)
   6. Re: How does the pager know whether its memory cache is still
  valid? (Rowan Worth)
   7. Best way to wipe out data of a closed database (Max Vlasov)
   8. Warning automatic index on (Werner Kleiner)
   9. Re: Warning automatic index on (Rowan Worth)
  10. Re: Development environment reccomendation (Simon Slavin)
  11. Re: Best way to wipe out data of a closed database (Simon Slavin)
  12. Re: Best way to wipe out data of a closed database (Richard Hipp)
  13. Re: Import 5000 xml files in a sqlite database file (Kevin Youren)
  14. Re: Warning automatic index on (Simon Slavin)
  15. Re: Import 5000 xml files in a sqlite database file
  (Preguntón Cojonero Cabrón)
  16. Re: Virtual table acting as wrapper of a regular table
  (Hick Gunter)
  17. Re: Warning automatic index on (Richard Hipp)
  18. Re: Best way to wipe out data of a closed database (Max Vlasov)
  19. Re: Best way to wipe out data of a closed database (Max Vlasov)


--

Message: 1
Date: Sun, 23 Oct 2016 18:03:57 +0200
From: Sylvain Pointeau 
To: SQLite mailing list 
Subject: Re: [sqlite] Import 5000 xml files in a sqlite database file
Message-ID: