Re: [sqlite] database disk image is malformed

database really is corrupt or whether your program is getting spurious error messages. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Mit freundlichen Grüßen Andrea

Re: [sqlite] unable to use date fields in sqlite

Hi Steve, beside what I said in my last statement, you should also have a look at https://www.sqlite.org/datatype3.html https://www.sqlite.org/lang_datefunc.html This may help you to understand, how SQLite handles specific data types, that might be understood (or at least be handled) dif

Re: [sqlite] unable to use date fields in sqlite

Am 23.07.2019 um 16:22 schrieb Steve Leonard: > > 1) I imported a new table using dbbrowser for sqlite from a csv file > one of the fields is named myfdat and the first record contains > '12/01/2011' > > 2) the import created a table with the field myfdt as type text and > the value matches the csv

Re: [sqlite] sqlite3_close() drops wal and shm files despite of other processes holding DB open

cquire the locks. I will report back, when I know more! Andreas Am 11.07.2019 um 18:07 schrieb Andreas Kretzer: > I'm using SQLITE3 (V3.29.0) on an arm embedded linux (2.6.39) on an ext3 > filesystem. > > Several processes hold the DB open and the "-wal" and "-shm"

Re: [sqlite] [EXTERNAL] Re: sqlite3_close() drops wal and shm files despite of other processes holding DB open

still within a transaction. > > The parent process then needs to terminate, releasing the locks it still had. > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Andreas Kretzer > Sent: Dienstag, 16. Juli 20

Re: [sqlite] sqlite3_close() drops wal and shm files despite of other processes holding DB open

ook! I think, this problem is solved - I have to change the order of the startup. Maybe I even open the DB, read the configuration and close it again, before opening it again after being daemonized. Andreas Am 16.07.2019 um 12:21 schrieb Andreas Kretzer: > Interessting insights! > > D

Re: [sqlite] sqlite3_close() drops wal and shm files despite of other processes holding DB open

c.db-shm root:~> At least, this explains why closing the second process (lcd_manager) will close the DB completely,  removing the '-shm' and '-wal' file. I will now investigate, why the first process doesn't acquire the locks. I will report back, when I know more!

[sqlite] sqlite3_close() drops wal and shm files despite of other processes holding DB open

). What else can I check? Two or more sqlite3 CLI processes started in parallel don't exhibit this behavior. Thanks Andreas -- Mit freundlichen Grüßen Andreas Kretzer   ETB Electronic Team Beratungs- und Vertriebs GmbH   Berliner Straße 8a 15537 Erkner   FON   +49 3362 889349-12