Re: [sqlite] Memory leak in csv.c virtual table module

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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 :)

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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:

Re: [sqlite] memory leak?

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

Re: [sqlite] memory leak?

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 ___

Re: [sqlite] memory leak

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

Re: [sqlite] Memory leak in online backup api

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

Re: [sqlite] Memory leak in online backup api

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. >

Re: [sqlite] memory leak in transactions

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 =

Re: [sqlite] memory leak in transactions

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

Re: [sqlite] memory leak in transactions

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

Re: [sqlite] Memory leak?

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

Re: [sqlite] Memory leak in SQlite

#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

Re: [sqlite] Memory leak in SQlite

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

Re: [sqlite] Memory leak in sqlite 3.7.0

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 >>

Re: [sqlite] Memory leak in sqlite 3.7.0

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

Re: [sqlite] Memory leak in sqlite 3.7.0

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

Re: [sqlite] Memory leak in sqlite 3.7.0

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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.

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

> 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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

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

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

> 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

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

, 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 resort to

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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

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 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

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

e-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 the wall: &

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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: [sqlite

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1 On Fri, 26 Jun 2009 17:07:16 -0400, "Greg Morehead" <gmoreh...@premiumpower.com> wrote: > >If I close then reopen the database all my memory is recovered. > >Is this by design??? Yes, what you see is p

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 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?

Re: [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 intending on keeping a connection open most of time.

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

, 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

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

: 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

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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] Memory leak

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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,

Re: [sqlite] Memory leak with sqlite3_exec on qnx 6.4.1

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

Re: [sqlite] Memory Leak on select ?

<[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,

Re: [sqlite] memory leak on sqlite3_open

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

Re: [sqlite] memory leak

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'

Re: [sqlite] memory leak

--- [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

RE: [sqlite] memory leak

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

Re: [sqlite] memory leak

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== >

Re: [sqlite] memory leak

--- 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

Re: [sqlite] memory leak

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); > } >

Re: [sqlite] memory leak

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

[sqlite] RE:Re: [sqlite] RE:Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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, that solved all the problems related

[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, that solved all the problems related to sqlite3_exec memory problems with a select statement, baut the memory problems are not solved at all,

Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

] 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 executes you

[sqlite] RE:Re: [sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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

[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, that solved all the problems related to sqlite3_exec memory problems with a select statement, baut the memory problems are not solved at all,

[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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

[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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

[sqlite] RE:[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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

[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

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

Re: [sqlite] RE: SQLite memory leak on Windows CE

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

Re: [sqlite] RE: SQLite memory leak on Windows CE

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: <sqlite-users@sqlite.org> Sent: Wednesday, March 15, 2006 6:18 AM Subject: [sqlite

[sqlite] RE: SQLite memory leak on Windows CE

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

Re: [sqlite] Memory Leak

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

Re: [sqlite] Memory Leak

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

Re: [sqlite] Memory Leak

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