[sqlite] SQLITE_CANTOPEN after days of operation

Fully opening the directory failed to fix the issue. So in summary the program works for days then dies with this in the log: (14) cannot open file at line 28488 of [f5b5a13f73] (14) os_unix.c:28488: (24) open(/usr/share/cm160) - (14) cannot open file at line 28488 of [f5b5a13f73] (14)

[sqlite] SQLITE_CANTOPEN after days of operation

Sorry didn't see previous replies before sending. I'll try next: 1) When the error occurs to create a new file in the directory 2) Check lsof of main and monitoring process to see if either is leaking files Get back to you in a few days Thanks Andy On 14 October 2015 at 08:52, Andrew

[sqlite] SQLITE_CANTOPEN after days of operation

errno 24 is EMFILE "Too many open files". You almost certainly have a file-descriptor leak. -scott On Wed, Oct 14, 2015 at 12:52 AM, Andrew Miles wrote: > Fully opening the directory failed to fix the issue. So in summary the > program works for days then dies with this in the log: > > (14)

[sqlite] Copy, drop, create tables

I am using a SQLite tables and Lazarus with the information of the current year. I december 31, after finish all the current operations, we have to copy the information in others folders for savings, and empty the former ones for the new year. I have tried some routines (copy, drop, create, etc)

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

Greetings. I just downloaded the provided Windows DLL version from the download site, v3.9.0, and when I run my program, I get "The procedure entry point sqlite3_finalize could not be located in the dynamic link library SQLITE3.DLL." and the program aborts. I had to go back to v3.8.11.1 to

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize couldnot be located

Someone is using the mailing list posts to send SPAM to the posters. Just fyi. I just received an email from someone name Alexa including pictures. The email it came from was alexa at nsadatemail.com Just an fyi. Thanks. -Original Message- From: jose isaias cabrera Sent:

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera wrote: > "The procedure entry point sqlite3_finalize could not be located in the > dynamic link library SQLITE3.DLL." > > and the program aborts. I had to go back to v3.8.11.1 to make the program > work again. Any thoughts? I thought that

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On 10/14/15, Random Coder wrote: > > There appears to be a problem with the officially provided DLL. It > only has sqlite3_json_init exported in the DLL. > Confirmed. And yet the reason for that is still a complete mystery to us SQLite developers. We are trying to figure out why the DLL build

[sqlite] SQLITE_CANTOPEN after days of operation

Yes I can see it now with lsof on the process. Ok non-sqlite issue, now to find where I'm not closing the file properly. Thanks for assistance all! Andy > errno 24 is EMFILE "Too many open files". You almost certainly have a ? file-descriptor leak. > > -scott On 14 October 2015 at 08:52,

[sqlite] [sqlite-announce] SQLite version 3.9.0

2015-10-14 21:31 GMT+02:00 D. Richard Hipp: > Please report any problems to the sqlite-users at mailinglists.sqlite.org > mailing list, or directly to me. Thanks. Why does sqlite.h #include itself? Although it doesn't

[sqlite] fts5aux?

Hi all, Are there any plans in fts5 to add support for something equivalent to fts4aux? This would be of great use to me. Thanks! Kind regards, Philip Bennefall

[sqlite] sqlite window functions extension?

Is there an extension to sqlite the provide window functions such as row_number over and partition? There are plenty of googles seeking said functionality. What am I looking to do? Using a table X, I've built a summary table, calculating a value called net_non_pieces. net_not_pieces is a qty

[sqlite] sqlite window functions extension?

On 10/14/2015 4:49 PM, Don V Nielsen wrote: > What am I looking to do? Using a table X, I've built a summary table, > calculating a value called net_non_pieces. net_not_pieces is a qty of rows > from a group rows that needs to be recoded to a different value. So what I > want to do is for each

[sqlite] sqlite window functions extension?

X has columns zip & crrt, just like crrt_net_non. These form a composite key identifying groups within x. A value "53001.R501" would be an example...53001 being the zip code and R501 being the carrier route. There are 52 rows in X that have the key 53001.R501. A calculation determined that I

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

-Original Message- From: Random Coder Sent: Wednesday, October 14, 2015 2:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera wrote: > "The

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On 10/14/15, jose isaias cabrera wrote: > -Original Message- > From: Random Coder > Sent: Wednesday, October 14, 2015 2:17 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize > could not be located > > On Wed, Oct 14,

[sqlite] sqlite window functions extension?

On 10/14/2015 5:20 PM, Don V Nielsen wrote: > X has columns zip & crrt, just like crrt_net_non. These form a composite > key identifying groups within x. A value "53001.R501" would be an > example...53001 being the zip code and R501 being the carrier route. There > are 52 rows in X that have

[sqlite] sqlite window functions extension?

Table crrt_net_non_pieces: zip crrt pkg_pieces sel_pieces non_pieces net_non_pieces 53001 R501 52 646 42 53001 R502 34 727 24 Addresses (as I have been referring to as X) is going to have too many rows (86 for

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

Thanks. Works great! Thanks. From: Richard Hipp Sent: Wednesday, October 14, 2015 5:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located On 10/14/15, jose isaias cabrera wrote: > -Original

[sqlite] sqlite window functions extension?

On 10/14/2015 6:24 PM, Don V Nielsen wrote: > zip crrt version_id NUM segment > [truncated num 1..38] > 53001 R501 0060 39xx > 53001 R501 0060 40xx > 53001 R501 0060 41xx > 53001 R501 0060 42xx > [truncated num 1..24] >

[sqlite] printf with thousands separator

I create quite a few ad hoc queries from data tables with large numbers and the default floating output is a pain to read. I can get the output format I desire with something elaborate like the following but this is too much SQL for ad hoc queries. select substr( replace( substr('

[sqlite] sqlite window functions extension?

The only reason NUM exists in the result set is so I could use it to limit the outer most select. But I am having problems with the LIMIT statement. It throws an exception no matter what table alias is used: X or x2. It says "no such column". Thanks for your time, by the way. On Wed, Oct 14,

[sqlite] sqlite window functions extension?

On 10/14/2015 9:29 PM, Don V Nielsen wrote: > But I am having problems with the LIMIT statement. It throws an exception > no matter what table alias is used: X or x2. It says "no such column". Ah, interesting. LIMIT clause doesn't appear to allow correlated subqueries; only self-contained

[sqlite] SQLite Release 3.9.0

I'm not sure what semantic versioning says about this, but why not just drop the trailing .0 and call the release 3.9? That seems cleaner and emphasizes the fact that this is a new minor version. -- Craig Maynard Los Altos, California