Fixed now on trunk. Thanks for the bug report.
On 4/24/18, Ralf Junker wrote:
> This SQL causes a memory leak in the csv.c virtual table module:
>
>CREATE VIRTUAL TABLE if not exists t1
> USING csv(filename='FileDoesNotExists.csv');
>
> Cause is that the zIn buffer which is allocated he
It is normal in all modern operating systems for unused memory to be allocated
to buffer cache, so over time the "free" memory Is expected to go down unless
disk activity is near quiescent. Some operating systems will combine "cache"
and "free" memory to hide this from the casual user, but I co
first thanks you reply
After running for some time i found sqlite3_memory_used return value keep
constant about 2M,but linux free memory is fewer and fewer,i make sure no
other places are leaked,why?
this whether or not a normal behavior?
if not ,how can i to analysis this problem?
Looking
my platform is armv5 not support valgrind and lint,
can you help me ?
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-
thans your reply , when find the problem,i try to use valgrind tool,but i
find this tools is not support armv5,i use mcu is AT91SAM9G25
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.or
On 12 Apr 2018, at 21:34, Simon Slavin wrote:
> On 12 Apr 2018, at 8:00pm, Warren Young wrote:
>
>> Also: http://valgrind.org/docs/manual/faq.html#faq.pronounce
>
> I didn't know that. So they want it to be pronounced like 'lint'.
> Interesting.
That they want it pronounced that way is a matte
On 12 Apr 2018, at 8:00pm, Warren Young wrote:
> Also: http://valgrind.org/docs/manual/faq.html#faq.pronounce
I didn't know that. So they want it to be pronounced like 'lint'. Interesting.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglis
On Apr 12, 2018, at 11:14 AM, Jens Alfke wrote:
>
> I'm a Mac/iOS developer so I use the 'leaks' tool and Instruments app; I
> don't know how this is done on Linux.
Valgrind: http://valgrind.org/
Also: http://valgrind.org/docs/manual/faq.html#faq.pronounce
:)
_
Trying to find memory leaks by looking at the OS memory statistics is
pointless. It's like looking at satellite photos to find a dropped contact
lens. :) The kernel's virtual memory system (on any modern OS) is very complex,
and the behavior of malloc/free in a process is also complex.
If you w
On 4/12/18, king3306 <1809860...@qq.com> wrote:
>
> 1:
> before i use insert cmd ,the linux memory and sqlite3_memory_used is
> linux: tota=29126656 used=16998400 free=12128256
> sqlite3_memory_used:1372576
>
> after i use inset cmd ,the linux memory and sqlite3_memory_used is
> linux: tota=2912665
sorry i made a mistake SQLite version 3.3.6 is linux built-in sqlite3
i use is SQLITE_VERSION"3.22.0" on arm
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://
On 4/12/18, king3306 <1809860...@qq.com> wrote:
>
> I am use SQLite version 3.3.6
Version 3.3.6 dates from 2006-06-06. Version 3.23.1 is current.
Please upgrade. Report back if you are still having problems.
--
D. Richard Hipp
d...@sqlite.org
___
sql
On 11/05/17 03:28 , Lev wrote:
> I'm fighting with some memory leak. From time to time the vsize of the
> process goes up with 100k. I have several function like this, and I
> call them in each second. My memory growth happens every 10 minutes or
> so.
>
> int dbSqliteSelectSensorsToReport(sdmd_t
On Mon, Mar 10, 2014 at 10:06 AM, techi eth wrote:
> Any hint will help me to identify root cause of leak.
>
Statically link against SQLite. Compile with -g. Use the
--leak-check=full option to valgrind.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite
Any hint will help me to identify root cause of leak.
Thanks
On Mon, Mar 10, 2014 at 2:58 PM, techi eth wrote:
> Hi,
>
> I come across memory leak with sqlite3 online backup api (Leak detected by
> valgrind tool). I have used reference code from below link for test.
> (Online backup for runnin
Thanks for your reply.
I am using version 1.0.79.0 of System.Data.sqlite
Here is how i am using it, i only use executescalar and
executenonquery, let me know if you want to see how i pass the
parameters etc.
RunBigtransaction()
{
using (IDbTransaction tran = Connection.BeginTransaction(
rui wrote:
>
> I am seeing explosive memory growth when i am using transactions using
> System.Data.SQLite.
>
The best way to address this issue is to utilize "using" blocks for any
SQLiteCommand, SQLiteDataReader, and SQLiteTransaction objects used. That way,
you won't have to wait until th
Do you have your inserts wrapped in a single transaction? It used to be that I
wasn't worrying about transactions in my projects, but I noticed things were
very slow. I realized that it was creating and committing one transaction for
each insert I was doing. When I wrapped all inserts into a
Some mistakes...
* I use also PRAGMA cache_size=100 but the some problem
On Wed, Jul 13, 2011 at 3:12 PM, Anze Rozman wrote:
> Hi!
>
> I have an application which inserts into database most of the time. Problem
> is that memory is decreasing. Aplication is in java and I use Werner's
> sqlite wra
#1 I don't see where you're freeing m_szErrorString (not real sure if it gets
malloc'd on success) -- but you do need to free it on errors for sure.
And where's your Callback function? Why are you calling SaveResultSet (which
you also don't show)? That should probably be done inside the Call
On Tue, May 10, 2011 at 2:17 PM, Ian Hardingham wrote:
> I'm sure that this is to do with the way I am using SQLite. I do not
> have time to radically change my methodology at this point, but I do
> need to fix a rather severe memory leak I'm having.
>
>
i don't see any immediate leaks in what yo
On Tuesday, July 27, 2010 6:43 PM, Richard Hipp wrote:
>> [ ... ]
>>
>> However, I have also attached journaltest2.log which I think does
>> demonstrate the memory leak. Having trawled through the full log file,
>> it
>> seems that the memory leak is coming from the FTS3 tests, so the
>> journal
On Mon, Jul 26, 2010 at 11:16 AM, Andy Gibbs wrote:
> On Monday, July 26, 2010 4:44 PM, Richard Hipp wrote:
>
>
> What do you get when you run:
>>
>> ./testfixture test/permutations.test journaltest test/memsubsys2.test
>> ./testfixture test/permutations.test inmemory_journal
>> test/memsubsy
On Monday, July 26, 2010 4:44 PM, Richard Hipp wrote:
What do you get when you run:
./testfixture test/permutations.test journaltest test/memsubsys2.test
./testfixture test/permutations.test inmemory_journal
test/memsubsys2.test
Please find the log files attached as journaltest.log an
What do you get when you run:
./testfixture test/permutations.test journaltest test/memsubsys2.test
./testfixture test/permutations.test inmemory_journal
test/memsubsys2.test
On Mon, Jul 26, 2010 at 9:47 AM, Andy Gibbs wrote:
> Hi,
>
> I'm afraid I believe I have observed a memory leak
Zachary Turner
wrote:
> I still don't understand the transactions. For example, I issue a
> single BEGIN at the start of my application and then insert about
> 500MB of data through many small inserts (about 4KB each). During
> this whole time I never issue a commit. But the main db file grows
On Wed, Jul 22, 2009 at 1:42 PM, Pavel Ivanov wrote:
>
> Again, try to call sqlite3_memory_used() several times during work of
> your application. What does it say to you?
It says it's using about 3MB. Which suggests maybe it's my application.
I believe I've identified the problem in my code but
> Assuming I don't do any manual commits, what does sqlite do with the
> data that has yet to be committed?
If you don't do commits (and "begins") of transactions by yourself
then SQLite does that automatically after each executed statement. So
when sqlite3_step returns you can be sure that everyt
On Wed, Jul 22, 2009 at 10:47 AM, Pavel Ivanov wrote:
> SQLite synchronizes with disk during every commit (either issued by
> yourself or automatic) at least 2 times (I don't know exact number).
> So it's quite natural that it spends most of the time in winSync().
> But I still didn't understand fr
just a point:
In your pseudocode you precreate statements for the
begin and commit and trying to reuse them later on.
If your real code is like this I would suggest to
take a look at this. I think it is not possible
to "re-step" a begin or commit, you may try to
recreate these statements completely
SQLite synchronizes with disk during every commit (either issued by
yourself or automatic) at least 2 times (I don't know exact number).
So it's quite natural that it spends most of the time in winSync().
But I still didn't understand from your explanation how exactly your
application works and whe
On Tue, Jul 21, 2009 at 6:45 PM, Pavel Ivanov wrote:
>> If I remove or comment out the
>> three lines with //* in the code above, I get no memory leaks.
>
> So basically you're saying that if you don't insert any data into your
> database and thus effectively don't do with your database anything an
> If I remove or comment out the
> three lines with //* in the code above, I get no memory leaks.
So basically you're saying that if you don't insert any data into your
database and thus effectively don't do with your database anything and
thus SQLite don't have to cache anything from database the
, June 29, 2009 12:06 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
> So it seems by best bet is to close and open the connection once every 5
> minutes or so?
While this might "work", I don't think you should reso
On 29 Jun 2009, at 1:11pm, Greg Morehead wrote:
> So it seems by best bet is to close and open the connection once
> every 5 minutes or so?
No. The library is unlikely to have a leak of that kind in. Are you
certain that what you're seeing is a real leak ? If so, the leak may
be in your
> So it seems by best bet is to close and open the connection once every 5
> minutes or so?
While this might "work", I don't think you should resort to that. As
Kees noted earlier, there will be performance drawbacks if you
close/re-open the database.
As others have indicated, the heap growth
ilto:sqlite-users-boun...@sqlite.org]on Behalf Of Jay A. Kreibich
> Sent: Friday, June 26, 2009 5:32 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
>
>
> On Fri, Jun 26, 2009 at 05:07:16PM -0400, Greg Morehead scratched on t
I'm looking specifically at the heap for the process I wrote.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Jay A. Kreibich
Sent: Friday, June 26, 2009 5:32 PM
To: General Discussion of SQLite Database
Subject: Re: [s
: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
On Fri, 26 Jun 2009 17:07:16 -0400, "Greg Morehead"
wrote:
>
>If I close then reopen the database all my memory is recovered.
>
>Is this by design???
Yes, what you see is probably the page cache.
>I was intendin
On Fri, Jun 26, 2009 at 05:07:16PM -0400, Greg Morehead scratched on the wall:
>
> If I close then reopen the database all my memory is recovered.
>
> Is this by design??? I was intending on keeping a connection open most of
> time.
Are you sure you're not looking at the page cache?
-j
On Fri, 26 Jun 2009 17:07:16 -0400, "Greg Morehead"
wrote:
>
>If I close then reopen the database all my memory is recovered.
>
>Is this by design???
Yes, what you see is probably the page cache.
>I was intending on keeping a connection open most of time.
That's a good idea, for at least
, June 26, 2009 4:41 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
FYI. I replaced the sqlite3_exec call with sqlite3_prepare_v2, sqlite3_step,
sqlite3_finalize.
Same results.
-Original Message-
From: sqlite-users-boun
Discussion of SQLite Database
Subject: Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
Based on the documentation in the link you sent I should only need to call free
if there was an error message.
But, since there is no harm in calling sqlite3_free on a null pointer I moved
it out of the if
: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Ribeiro, Glauber
Sent: Friday, June 26, 2009 4:17 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1
I took only a quick look, but it seems to me that
n the much larger real db's I am planning on using.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp
Sent: Friday, June 26, 2009 3:58 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] M
I took only a quick look, but it seems to me that sqlite3_free is only
being called if there is an error.
See http://sqlite.org/c3ref/exec.html
g
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Greg Morehead
Sent: Friday, June
On Jun 26, 2009, at 3:49 PM, Greg Morehead wrote:
> The extremely simple app below leaks. What am I doing wrong??
> Please help.
How do you know it is leaking memory? How are you measuring?
>
>
> #include
> #include
> #include "stdio.h"
> #include "sqlite3.h"
> #include
>
> #define TFQ_
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm using sqlite3 on embedded system.
> I've got a very very large
> memory usage.
>
> zSql =
> sqlite3_mprintf("SELECT PortNumber, RangeMin, RangeMax, Offset, MinL,
> MinLL, MaxH, MaxHH, Delay, Hysteresis, " \
>"Alarm,
>
arbalest06 <[EMAIL PROTECTED]> wrote:
>
> Is this a valid memory leak?
>
No, it is not a real leak. But we used to get complaints about
it about ever week so I reworked the code to make Valgrind stop
complaining. That happened about 6 months ago. If you run with
the latest version of SQLite V
Hi,
I think you're going to have to be a bit more rigorous about what you're
testing if you're hoping for a fix.
In your root message you posted a bit of code and said you'd found a
leak in v2.8.17 of the library.
Then you said the leak was present in v2.8.17 and v3.3.6 (the valgrind
of 'bash' p
--- [EMAIL PROTECTED] wrote:
> It appears that you are in fact running /bin/bash,
> not
> SQLite, and finding memory leaks there. Perhaps
> "sqlite3"
> is really a shell script on your system. Try
> running
> valgrind on a real sqlite3 executable and I believe
> you
> will find that there are
One quick question, is that with memory management enabled in the sqlite
compile or not? I've done some extensive memory checking with memory
management disabled and never found a leak. However, with memory management
enabled, all bets are off.
> I believe the memory leak exists. The following is
mycmos <[EMAIL PROTECTED]> wrote:
>
> I believe the memory leak exists. The following is
> excerpt from sqlite-3.3.6 in valgrind (In fact, the
> sqlite-2.8.17 in valgrind is similar):
>
> [EMAIL PROTECTED] /data/lfs/sqlite-3.3.6]# valgrind
> --leak-check=full ./sqlite3
[...]
> ==11765==
> ==11765
--- Martin Jenkins <[EMAIL PROTECTED]>写道:
> mycmos wrote:
> > When I use cat /proc/meminfo, I found the MemFree
> is
> > decreasing. Does that means some degree memory
> leak to
> > Sqlite2.8.17?
>
> No. ;)
>
> If you run "ps -ef" or "top" you'll see a list of
> all of the processes
> running
mycmos wrote:
> I am using sqlite2.8.17 for linux2.6. My program
> is as following:
>
> int main()
> {
>sqlite *db;
>
>while(1){
> db = sqlite_open("./example.db",0777,0);
> if(db == 0){
> printf("Could not open database.");
> exit(1);
> }
>
mycmos wrote:
> When I use cat /proc/meminfo, I found the MemFree is
> decreasing. Does that means some degree memory leak to
> Sqlite2.8.17?
No. ;)
If you run "ps -ef" or "top" you'll see a list of all of the processes
running on your machine. How could you associate changes in MemFree with
any
: Friday, March 17, 2006 7:08 AM
Subject: [sqlite] RE:Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on
Windows CE
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", tha
stead.
Robert
- Original Message -
From: <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Friday, March 17, 2006 7:08 AM
Subject: [sqlite] RE:Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on
Windows CE
Hi Robert,
I was talking about 3 selects satements using the same
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
ct: Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows
CE
- Original Message -
From: <[EMAIL PROTECTED]>
I have run your program on the CE emulator (Pocket PC 2003) and i got
the same memory leak.
I have inserted 2 buttons on a MFC dialog application.
The first button execu
Hi,
Thank you very much for your help, i have modify the line, it compiles, it
doesn´t fire any exception, but memory is not freed at all (works the same way)
Anyone has another idea?, i tought that SQLite was working since a long time
ago on Windows CE devices, it seems quite strange that no on
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
Hi,
I guess that you are right. Robert gave me the hint to change chae size using
the PRAGMA command, and that did solve all the problems i hadt with the
sqlite3_exec command, but it did not solved the problems related to
sqlite3_get_table.
I have been taking a look at table.c code and i am not
On March 16, 2006 12:28 pm, Jose Da Silva wrote:
I forgot a line:
char x[12] = "Hello world\0";
char *ptr;
ptr = x;
while (*ptr) {printf("%c",*ptr); ++ptr;};
> If you figure out the right sizeof(???) value to use, then I think it
> could be submitted as a bug-fix for \src\table.c
You want to mov
On March 16, 2006 08:49 am, [EMAIL PROTECTED] wrote:
> Hi Again Robert,
> I have run your program on the CE emulator (Pocket PC 2003) and i got
> the same memory leak. I have inserted 2 buttons on a MFC dialog
> application.
> The first button executes your code and the second button closes the
>
be nice to have an API to force any cached pages to be released
(maybe it already exists and I don't know about it?).
-Original Message-
From: Robert Simpson [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 16, 2006 12:13 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] RE:Re: [sql
- Original Message -
From: <[EMAIL PROTECTED]>
I have run your program on the CE emulator (Pocket PC 2003)
and i got the same memory leak.
I have inserted 2 buttons on a MFC dialog application.
The first button executes your code and the second button
closes the application.
If you exam
Hi Again Robert,
I have run your program on the CE emulator (Pocket PC 2003) and i got the same
memory leak.
I have inserted 2 buttons on a MFC dialog application.
The first button executes your code and the second button closes the
application.
If you examine the memory you will discover that t
Hi Robert,
Thank you for your test. I have not test it on the emulator but in 4 different
Windows CE devices i have at work (with different Windows CE OS versions) and
it always give me the same memory leak result.
I will run your test tomorrow at work using the emulator and i will let you
know
Hi again Robert,
I think i forgot to tell you that to detect the memory leak you must not close
the application testing program, the easiest way to detect the memory leak is:
create a simple MFC dialog project. Add 2 buttons, one for executing your
testing program an another one for close the ap
Hi Robert,
Thank you for your test. I have not test it on the emulator but in 4 different
Windows CE devices i have at work (with different Windows CE OS versions) and
it always give me the same memory leak result.
I will run your test tomorrow at work using the emulator and i will let you
know
Ok, here's what I did ...
On the desktop I created a SQLite database with one table and inserted
120,000 rows into it. I then copied it over to the CE emulator.
Then I ran the following code on the CE (Pocket PC 2003 SE) emulator:
#include
#include
#include "sqlite3.h"
int WINAPI _tWinMai
What method(s) are you using to detect the memory leak?
I'll try and test this out today and see if I can come up with anything.
Robert
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 15, 2006 6:18 AM
Subject: [sqlite] RE: SQLite memory leak on
Hi again, i have tried your advice of changing line 192 at table.c and it
didn´t work (it fires an exception). I do not think that the problem is related
to sqlite3_get_table or sqlite3_free_table source code.
To make sure, i have test it with another simple program (see the source code
below),
Problem fixed... It was in the compile/reset logic..
it just kept compiling without resetting.
Ken
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
Daren
Agreed i found an earlier post. This is just the way
the coding works for the OS posix file locking bug
work around...
I think there is still another memory issue... Not
really a leak, but rather a huge amount of excessive
allocation happening... The sqlite_compile, bind,
reset logic seems
My interpretation of your results is that you do not have a memory leak.
This is partly evidenced that all of the memory in the summary is
"still reachable"; a leak is defined as memory you have not freed but
can not reach.
I also know for a fact that SQLite maintains an in-memory cache to
spee
M. Strittmatter wrote:
> Hi,
>
> I just discovered, that there may be a little memory leak in libsqlite
> version 0.8.6 (2.3.18). I compiled a small test application (see below) with
> gcc and the tool ccmalloc
> (http://www2.inf.ethz.ch/personal/biere/projects/ccmalloc/). ccmalloc
> reported a mem
79 matches
Mail list logo