Re: [sqlite] Sqlite error code 14 when using 3.31.0+

out when the problem starts. I don't get the message in versions <= 3.30.1. (from the applications log) SQLite Version: 3.31.0 INFO: Database opened: /tmp/database.sqlite WARNING: SQLITE error code: 14 cannot open file at line 36982 of [3bfa9cc97d] WARNING: SQLITE error code: 14 os_unix.c:36

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

ssage in versions <= 3.30.1. (from the applications log) SQLite Version: 3.31.0 INFO: Database opened: /tmp/database.sqlite WARNING: SQLITE error code: 14 cannot open file at line 36982 of [3bfa9cc97d] WARNING: SQLITE error code: 14 os_unix.c:36982: (40) openDirectory(/tmp) - errno 40 is ELO

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

en the problem starts. >> I don't get the message in versions <= 3.30.1. >> >> (from the applications log) >> SQLite Version: 3.31.0 >> INFO: Database opened: /tmp/database.sqlite >> WARNING: SQLITE error code: 14 cannot open file at line 36982 of >&

Re: [sqlite] Sqlite error code 14 when using 3.31.0+

.30.1. > > (from the applications log) > SQLite Version: 3.31.0 > INFO: Database opened: /tmp/database.sqlite > WARNING: SQLITE error code: 14 cannot open file at line 36982 of > [3bfa9cc97d] > WARNING: SQLITE error code: 14 os_unix.c:36982: (40) openDirectory(/tmp) - >

[sqlite] Sqlite error code 14 when using 3.31.0+

e opened: /tmp/database.sqlite WARNING: SQLITE error code: 14 cannot open file at line 36982 of [3bfa9cc97d] WARNING: SQLITE error code: 14 os_unix.c:36982: (40) openDirectory(/tmp) - It seems related to opening the WAL file. Anything I should change when using sqlite &

Re: [sqlite] Error/Result code documentation

On Wed, Feb 26, 2020 at 11:09 AM Dominique Devienne wrote: > Hi. In the doc excerpt below from https://www.sqlite.org/rescode.html > are the $n*Code variables supposed to be expanded with a numeric > value, and there's a little issue in the doc generation? Thanks, --DD Thanks for the fix Richard.

[sqlite] Error/Result code documentation

Hi. In the doc excerpt below from https://www.sqlite.org/rescode.html are the $n*Code variables supposed to be expanded with a numeric value, and there's a little issue in the doc generation? Thanks, --DD 4. Primary Result Code List The $nPrimCode result codes ... 5. Extended Result Code List The

[sqlite] Error? ext/misc series.c and spellfix.c

sqlite3_vtab_config(db, SQLITE_INNOCUOUS) should that not be sqlite3_vtab_config(db, SQLITE_VTAB_INNOCUOUS)? Which explains why my quick patch in the pragma.c xConnect code to make all pragma vtabs innocuous didn't work (I copied from series.c) :) rc = sqlite3_declare_vtab(db, zBuf); if( r

Re: [sqlite] Error 19 with Caret ^ INSERT

>Behalf Of André Borchert >Sent: Saturday, 5 October, 2019 22:56 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Error 19 with Caret ^ INSERT > >Hello, > >in my C# program which uses DllImport for sqlite.dll (3.29) I get Error >19 (SQLITE_CONSTRAINT) with this statem

Re: [sqlite] Error 19 with Caret ^ INSERT

On 6 Oct 2019, at 5:56am, André Borchert wrote: > The odd thing is that the sql statement works just fine when I use DB Browser > for SQLite. Try the SQLite command line tool. That's written by the team which maintains SQLite itself, and it should give the connonically correct result. If it

[sqlite] Error 19 with Caret ^ INSERT

Hello, in my C# program which uses DllImport for sqlite.dll (3.29) I get Error 19 (SQLITE_CONSTRAINT) with this statement: INSERT INTO CompanyDetails (RIC) VALUES('AMBEUR.IP^G19') The ^ symbol is part of the text I want to save, its not a filter or so, its just plain text. The odd thing is th

Re: [sqlite] error: unable to read database header

te to the file, at which point there will be a header for .dbinfo to read. -Original Message- From: sqlite-users On Behalf Of Alexander Gabriel Sent: Friday, August 30, 2019 10:54 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] error: unable to read database header

[sqlite] error: unable to read database header. Also: My mails are being held back due to subscription to list not having worked

Hi *error: unable to read database header* Sorry for spamming this list but as it is an email list I cannot add to my original issue as for instance in github. As mentioned in my previous email I have donwloaded binaries for windows 10, run `.open test` followed by `.dbinfo` and got this error:

[sqlite] error: unable to read database header

Hi I downloaded the files for v3.29.0 into a folder. Then double clicked sqlite3.exe to open a command shell. Then typed `.open test.db` Then typed `.dbinfo` And got: `unable to read database header` What am I doing wrong? Have I created a broken database? Alex __

Re: [sqlite] Error response for automatic transaction rollback

On Aug 20, 2019, at 9:09 AM, Matt Zand wrote: > > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. It sounds like you’re looking for CREATE TRIGGER…BEFORE UPDATE…RAISE(ROLLBACK)

Re: [sqlite] Error response for automatic transaction rollback

On 8/20/19, Matt Zand wrote: > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. I don't understand what you are asking. -- D. Richard Hipp d...@sqlite.org ___

[sqlite] Error response for automatic transaction rollback

Hey guys, I wonder if version 3.29 does support error handling for sql transaction rollbacks. Also, does it support bypassing errors by forcing unconditional rollback yet. -- Cheers, Matt Zand Cell: 202-420-9192 Work: 240-200-6131 High School Technology Services DC Web Ma

[sqlite] Error in recover sqlite3 database

My sqlite3 database keeps on increasing in memory (although it is limited by memory). If I try to rebuild the database, it is giving the following error: sqlite> INSERT INTO tbllog(tbllog) VALUES('rebuild'); Error: database or disk is full Is the sol

Re: [sqlite] Error when renaming a table when an invalid view exists in the schema

main.t1 --- Date: Fri, 03 May 2019 13:27:18 -0600 From: "Keith Medcalf" To: "SQLite mailing list" Subject: Re: [sqlite] Error when renaming a table when an invalid view exists in the schema Message-ID: <802bb8bcf08af448bd5d9a4b9bf2f...@mail.dessus.

Re: [sqlite] Error when renaming a table when an invalid view exists in the schema

ays a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Tom Bassel >Sent: Friday, 3 May, 2019 12:51 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Error when

[sqlite] Error when renaming a table when an invalid view exists in the schema

Hello again everyone, I went through the ALTER TABLE docs but could not find anything describing this behavior: SQLite version 3.29.0 2019-04-27 20:30:19 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite>

Re: [sqlite] SQLite error while fetching the data from a table

Hi All, Hi Ananta Need quick help to resolve one issue i am getting now. I am a new user of SQLite. my code: connection = DriverManager.getConnection("jdbc:sqlite:C:\\sqllite\\sqlite-tools-win32-x86-328\\Stories.db"); Statement st = connection.createStatement(); ResultSet b = st.exec

Re: [sqlite] SQLite error while fetching the data from a table

On 22-4-2019 14:03, Ananta Jena wrote: Hi All, Need quick help to resolve one issue i am getting now. I am a new user of SQLite. my code: connection = DriverManager.getConnection("jdbc:sqlite:C:\\sqllite\\sqlite-tools-win32-x86-328\\Stories.db"); Statement st = connection.createStatement

[sqlite] SQLite error while fetching the data from a table

Hi All, Need quick help to resolve one issue i am getting now. I am a new user of SQLite. my code: connection = DriverManager.getConnection("jdbc:sqlite:C:\\sqllite\\sqlite-tools-win32-x86-328\\Stories.db"); Statement st = connection.createStatement(); ResultSet b = st.executeQuery("select

Re: [sqlite] Error in docs

On Tue, Apr 9, 2019 at 9:41 AM Richard Hipp wrote: > On 4/9/19, Dominique Devienne wrote: > >> > >> It defines the table and view: > >> CREATE TABLE t1(a INT, b TEXT, c REAL); > >> CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11; > >> > >> It then states "The affinity of the v1.x

Re: [sqlite] Error in docs

On 4/9/19, Dominique Devienne wrote: >> >> It defines the table and view: >> CREATE TABLE t1(a INT, b TEXT, c REAL); >> CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11; >> >> It then states "The affinity of the v1.x column will be the same as the >> affinity of t1.b (INTEGER), since

Re: [sqlite] Error in docs

On Mon, Apr 8, 2019 at 7:58 PM Jim Dossey wrote: > I think I found an error in the documentation here: > https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries > < > https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries > > > > It defines the table

[sqlite] Error in docs

I think I found an error in the documentation here: https://www.sqlite.org/datatype3.html#column_affinity_for_views_and_subqueries It defines the table and view: CREATE TABLE t1(a INT, b TEXT, c REAL); CREATE VIEW v

[sqlite] Error message "Attempt to write to read-only database"

Hi, first post here. Got a perplexing problem with SQLite and no, the database is perfectly writable. In my app I use a different database as main database that unfortunately doesn't have an FTS. Therefore, I'm using an SQLite database as index. The SQLite database is very simple: CREATE VIRT

Re: [sqlite] SQLite error (5): database is locked

On 4 Feb 2019, at 3:15pm, Urs Wagner wrote: > SQLite error (5): database is locked occurs? Can't answer your question, but … If you're getting unexpected locks, have you set a timeout on every connection to that database ? That gets rid of most

[sqlite] SQLite error (5): database is locked

Hello Is it possible to get a C# exception when the error SQLite error (5): database is locked occurs? I am using the entity framework with multiple thread and a global mutex. I would like to know which call generates the locking error. Thanks

Re: [sqlite] SQLite error (5): database is locked

On Tue, 15 Jan 2019 at 02:54, Simon Slavin wrote: > The "just-in-time" idea mentioned in your question doesn't work in real > life, since constantly checking mutex status keeps one core completely > busy, using lots of power and generating lots of heat. > Technically "just-in-time" could be impl

Re: [sqlite] SQLite error (5): database is locked

On 14 Jan 2019, at 7:04pm, Tim Streater wrote: > Hmm, from my attempt at interpreting the source code I gained the impression > that the handler used exponential backoff for the first few attempts, but > then used a constant period for the rest (up to the set limit). Is this not > the case? I

Re: [sqlite] SQLite error (5): database is locked

On 14 Jan 2019, at 18:54, Simon Slavin wrote: > SQLite's own busy_timeout routine (the one you get if you don't supply your > own) uses exponential backoff. It first sleeps for a very small amount of > time, then checks the lock. If access is still prevented it sleeps longer, > then checks again.

Re: [sqlite] SQLite error (5): database is locked

On 14 Jan 2019, at 6:34pm, Thomas Kurz wrote: >> pragma_busy_timeout > > Does setting the busy_timeout retry periodically (e.g. every x milliseconds), > or is there some automatism that ensures that the requested operation is done > just-in-time as soon as the previous/blocking operation is fi

Re: [sqlite] SQLite error (5): database is locked

> pragma_busy_timeout Does setting the busy_timeout retry periodically (e.g. every x milliseconds), or is there some automatism that ensures that the requested operation is done just-in-time as soon as the previous/blocking operation is finished? ___

Re: [sqlite] SQLite error (5): database is locked

olume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Urs Wagner >Sent: Monday, 14 January, 2019 02:24 >To: SQLite mailing list >Subject: [sqlite] SQLite error (5): database is locked > >Hallo > >I use

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

On 14 Jan 2019, at 11:14am, Urs Wagner wrote: >ProviderConnectionString = @"data source=" + _dataBase + > ";PRAGMA foreign_keys = ON;PRAGMA locking_mode = EXCLUSIVE;PRAGMA > schema.synchronous = NORMAL; PRAGMA schema.journal_mode = DELETE; PRAGMA > busy_timeout = 10" I am

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

Thank You for Your explanation. We do not using explicit transactions, SaveChanges takes rather a lot of time. -Original Message- From: sqlite-users On Behalf Of Barry Smith Sent: Monday, January 14, 2019 1:50 PM To: SQLite mailing list Subject: Re: [sqlite] [EXTERNAL] SQLite error (5

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

n Behalf > Of Hick Gunter > Sent: Monday, January 14, 2019 11:28 AM > To: 'SQLite mailing list' > Subject: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked > > With journal mode, SQLite supports 1 writer OR n readers; with WAL mode, > SQLite supports 1

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

in" is desired. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Urs Wagner Gesendet: Montag, 14. Jänner 2019 12:14 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked We are us

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

LETE; PRAGMA busy_timeout = 10" }; -Original Message- From: sqlite-users On Behalf Of Hick Gunter Sent: Monday, January 14, 2019 11:28 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked With journal mode, SQLite supports 1 writer OR n

Re: [sqlite] [EXTERNAL] SQLite error (5): database is locked

: Montag, 14. Jänner 2019 10:24 An: SQLite mailing list Betreff: [EXTERNAL] [sqlite] SQLite error (5): database is locked Hallo I use several tasks in C# to call Sqlite queries. No I get the error SQLite error (5): database is locked. Is it not possible to use more than one tasks with Sqlite? Regards

Re: [sqlite] SQLite error (5): database is locked

On 14 Jan 2019, at 9:23am, Urs Wagner wrote: > I use several tasks in C# to call Sqlite queries. > No I get the error SQLite error (5): database is locked. > Is it not possible to use more than one tasks with Sqlite? Please set a timeout for all connections to your database

[sqlite] SQLite error (5): database is locked

Hallo I use several tasks in C# to call Sqlite queries. No I get the error SQLite error (5): database is locked. Is it not possible to use more than one tasks with Sqlite? Regards Urs ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found

t that there's a Highway to Hell but only a Stairway to Heaven says a >lot about anticipated traffic volume. > >>-Original Message- >>From: sqlite-users [mailto:sqlite-users- >>boun...@mailinglists.sqlite.org] On Behalf Of ?? >>Sent: Thursday, 18

Re: [sqlite] Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found

eaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of ?? >Sent: Thursday, 18 October, 2018 02:56 >To: SQLite mailing list >Subject: Re: [sqlite] Erro

Re: [sqlite] Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found

way to Hell but only a Stairway to Heaven says a >lot about anticipated traffic volume. > >>-Original Message- >>From: sqlite-users [mailto:sqlite-users- >>boun...@mailinglists.sqlite.org] On Behalf Of ?? >>Sent: Wednesday, 17 October, 2018 22:26

Re: [sqlite] Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found

>To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Error: dlsym(0x7fa073e02c60, >sqlite3_sqliteicu_init): symbol not found > >I had thought I succeeded in building ICU extension because running >gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so succeeded >and libSqlite

[sqlite] Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found

I had thought I succeeded in building ICU extension because running gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so succeeded and libSqliteIcu.so was generated. But when I load it I got error Error: dlsym(0x7fa073e02c60, sqlite3_sqliteicu_init): symbol not found How do I solve that

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

> For the record, "delete the journal file" is terrible advice Agreed. In normal production environment, I wouldn't suggest that. The user was testing a database, and in my own developemtn cycle, its common when developing for a database to be in all manners of chaos states. It was purely a 'go

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/15 5:05 AM, Rowan Worth wrote: On Sat, 13 Oct 2018 at 02:20, Lars Frederiksen wrote: Any ideas? Not sure if this got resolved off-list, but based on the code you've posted I wonder if there is an "fdqGloser" as well as an "fdqGloser2", and if so what state it is in. Update: Thi

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On Sat, 13 Oct 2018 at 02:20, Lars Frederiksen wrote: > I type info into some labeledits and by pressing "Append to DB" button > this code is executed (fdqGoser2 is a FDQuery) > > fdqGloser2.Open; > fdqGloser2.Append; > fdqGloser2.FieldByName('Graesk').AsString:= ledGræsk.Text; > ... > fd

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On Sat, 13 Oct 2018 at 00:21, Chris Locke wrote: > > Database is locked > > Close your application. Is there a xxx-journal file in the same directory > as the database? (where xxx is the name of the database) > Try deleting this file. > For the record, "delete the journal file" is terrible advi

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/12 8:19 PM, Lars Frederiksen wrote: I type info into some labeledits and by pressing "Append to DB" button this code is executed (fdqGoser2 is a FDQuery) fdqGloser2.Open; fdqGloser2.Append; fdqGloser2.FieldByName('Graesk').AsString:= ledGræsk.Text; fdqGloser2.FieldByName(

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

ailinglists.sqlite.org] På vegne af Stephen Chrzanowski Sendt: 12. oktober 2018 19:47 Til: General Discussion of SQLite Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked FSCK is File System ChecK, so the equivalent in Windows Scandisk. Trace through the code to find o

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

qlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Lars Frederiksen >Sent: Friday, 12 October, 2018 06:26 >To: 'SQLite mailing list' >Subject: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database >is locked > >That is: I

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

FSCK is File System ChecK, so the equivalent in Windows Scandisk. Trace through the code to find out when exactly the SQLite is reporting the lock. Is it at a query, on opening, is it multi-thread or multi-application access? Is the query taking too long? If you're debugging and everything is w

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

se- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Chris Locke Sendt: 12. oktober 2018 18:22 Til: SQLite mailing list Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked > Database is locked Close your application. Is there a

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

o filesystem corruption? Have you tried an >> fsck? >> >> >> - Original Message - >> From: R Smith >> To: sqlite-users@mailinglists.sqlite.org < >> sqlite-users@mailinglists.sqlite.org> >> Sent: Friday, October 12, 2018, 17:35:28 >&

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Could the problem arise due to filesystem corruption? Have you tried an fsck? - Original Message - From: R Smith To: sqlite-users@mailinglists.sqlite.org Sent: Friday, October 12, 2018, 17:35:28 Subject: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked On 2018/10/12

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/12 2:44 PM, Lars Frederiksen wrote: I have tried that too! - I must admit that right now I am turning to a KISS solution: String-based database with functions and procedures in a class that handles the different jobs you do on a table. After all these old-fashioned DB's are not so p

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

? /Lars -Oprindelig meddelelse- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Radovan Antloga Sendt: 12. oktober 2018 10:10 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Try to

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Stephen Chrzanowski Sendt: 12. oktober 2018 14:37 Til: General Discussion of SQLite Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked How about moving the databases else

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

nately! > > -Oprindelig meddelelse- > Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > På vegne af Stephen Chrzanowski > Sendt: 12. oktober 2018 14:25 > Til: General Discussion of SQLite Database > Emne: Re: [sqlite] error message: [FireDAC

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Change the timeout value on the connection to 5 seconds or so. The DB will retry. The AV has its grip on it, doing a scan, and won't let anything else touch it until its done. On Fri, Oct 12, 2018 at 3:11 AM

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Try to change database name (extension). For example: mydb.sqlite mydb.sdb mydb.db3 I would use .sqlite extension and exclude that files from antivirus check. Regards Lars Frederiksen je 12.10.2018 ob

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Change the timeout value on the connection to 5 seconds or so. The DB will retry. The AV has its grip on it, doing a scan, and won't let anything else touch it until its done. On Fri, Oct 12, 2018 at 3:11 AM Lars Frederiksen wrote: > Hello, > > I have made (in Delphi) a program that writes to

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

without this error? /Lars -Oprindelig meddelelse- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Radovan Antloga Sendt: 12. oktober 2018 10:10 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Try to change database name (extension). For example: mydb.sqlite mydb.sdb mydb.db3 I would use .sqlite extension and exclude that files from antivirus check. Regards Lars Frederiksen je 12.10.2018 ob 9:11 napisal: Hello, I have made (in Delphi) a program that writes to a sqlite database. Th

[sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Hello, I have made (in Delphi) a program that writes to a sqlite database. This is a simple stand-alone solution. Now something is blocking for the programs attempt to writing to the databse. There is a an error message: [FireDAC][Phys][SQLite] Database is locked. A friend of mine has analysed

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

On 10 Sep 2018, at 12:30am, Robert Helmick wrote: > Thanks for your response. I'm using the node.js plugin. I've tried creating > a table then closing the db, and the queries executed successfully, but I > was not able to find the database file that it created. I searched the > folder structure a

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

Hi Simon, Thanks for your response. I'm using the node.js plugin. I've tried creating a table then closing the db, and the queries executed successfully, but I was not able to find the database file that it created. I searched the folder structure and was unable to find any .db file, even though t

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

On 6 Sep 2018, at 5:33pm, Robert Helmick wrote: > by default, then creates an empty database when it doesn't find the > pre-populated mydb.db file. This is why it can't find the 'plant' table, > because the newly created blank database obviously doesn't contain a > 'plant' table. However I can co

[sqlite] Error when reading from pre-populated SQLite database in Ionic project

I'm receiving an error when I try to read from a pre-populated SQLite database: `sqlite3_prepare_v2 failure: no such table 'plant'` From what I understand SQLite looks for the mydb.db file in the /www folder by default, then creates an empty database when it doesn't find the pre-populated mydb.db

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

Check the results of cordova plugin ls A common pitfall is that you have to use cordova-sqlite-ext plugin to get pre-populated database functionality. Commonly used cordova-sqlite-storage plugin does not support this feature. Second pitfall is if you have multiple Cordova sqlite plugins installed.

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

When SQLite creates an empty .db file, which directory is it in? With all your tweaking, etc, is the new database always in the same directory? Thanks, Chris On Wed, Sep 5, 2018 at 3:23 PM Robert Helmick wrote: > I'm receiving an error when I try to read from a pre-populated SQLite > database:

[sqlite] Error when reading from pre-populated SQLite database in Ionic project

I'm receiving an error when I try to read from a pre-populated SQLite database: `sqlite3_prepare_v2 failure: no such table 'plant'` From what I understand SQLite looks for the mydb.db file in the /www folder by default, then creates an empty database when it doesn't find the pre-populated mydb.db

Re: [sqlite] Error: foreign key mismatch - "loan" referencing "user"

qlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Markos >Sent: Wednesday, 1 August, 2018 16:23 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Error: foreign key mismatch - "loan" >referencing "user" > >Hi Clemens, > >The tabl

Re: [sqlite] Error: foreign key mismatch - "loan" referencing "user"

Hi Clemens, The table user stores info about all users. But some users have administrator privileges and can register a loan or a devolution in the system. On the line: FOREIGN KEY (id_admin_loan, id_admin_devolution) REFERENCES user (id_user, id_user) The id_admin_loan field is the id_u

Re: [sqlite] Error: foreign key mismatch - "loan" referencing "user"

Markos wrote: > CREATE TABLE user ( > id_user integer PRIMARY KEY, > ... > CREATE TABLE loan ( > ... > FOREIGN KEY(id_admin_loan, id_admin_devolution) REFERENCES user(id_user, > id_user) I do not understand what this is trying to accomplish. Why not two single-column FK constraint

[sqlite] Error: foreign key mismatch - "loan" referencing "user"

Hi, I am a beginner in database and I'm developing a Database (with Tcl/Tk) to control the loans of books in a reading room. I created a table to register the users: ... db1 eval {CREATE TABLE user (                        id_user integer PRIMARY KEY,                        name text

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

> On Feb 23, 2018, at 4:25 AM, Ashley Collins-Richardson > wrote: > > I am trying to add sqlite amalgamation into xcode and I keep getting the > error > error SQLite will not work correctly with the -ffast-math option of GCC. Why not just link with the copy of SQLite that’s already built into

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

I'm still getting the error --- Ashley Collins-Richardson Technical Director | Scrapbook Development Limited | www.scrapbookdev.com [1] Electric Works - Digital Campus, 3 Concourse Way, Sheffield, S1 2BJ On 2018-02-23 13:18, Simon Slavin wrote: > On 23 Feb 2018, at 12:25pm, Ashley Collins-Ric

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

got it working. thank you for your help --- Ashley Collins-Richardson Technical Director | Scrapbook Development Limited | www.scrapbookdev.com [1] Electric Works - Digital Campus, 3 Concourse Way, Sheffield, S1 2BJ On 2018-02-23 13:40, Simon Slavin wrote: > On 23 Feb 2018, at 1:38pm, Ashley

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

On 23 Feb 2018, at 1:38pm, Ashley Collins-Richardson wrote: > now I have the error 'system' is unavailable: not available on iOS Are you trying to compile the executable "sqlite3" program ? That won't run on iOS. You need to be using just the amalgamation source code, which is one .c file a

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

found that issue - you have to set the relax iee compliance to NO now I have the error 'system' is unavailable: not available on iOS --- Ashley Collins-Richardson Technical Director | Scrapbook Development Limited | www.scrapbookdev.com [1] Electric Works - Digital Campus, 3 Concourse Way, Shef

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

On 23 Feb 2018, at 1:18pm, Simon Slavin wrote: > For now, turn off all optmization: > > Select the Project folder > Build Settings > Compiler Options > Apple LLVM 8.0 Code Generation > Optimization Level > > set it to None. Whoops sorry you're using GCC not LLVM. Look for an equivalent settin

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

On 23 Feb 2018, at 12:25pm, Ashley Collins-Richardson wrote: > error SQLite will not work correctly with the -ffast-math option of GCC. For now, turn off all optmization: Select the Project folder Build Settings Compiler Options Apple LLVM 8.0 Code Generation Optimization Level set it to None

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

how do you do it ? in the other linker flage setting? --- Ashley Collins-Richardson Technical Director | Scrapbook Development Limited | www.scrapbookdev.com [1] Electric Works - Digital Campus, 3 Concourse Way, Sheffield, S1 2BJ On 2018-02-23 12:38, Richard Hipp wrote: > On 2/23/18, Ashley C

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

On 2/23/18, Ashley Collins-Richardson wrote: > Hi There, > > I am trying to add sqlite amalgamation into xcode and I keep getting the > error > > error SQLite will not work correctly with the -ffast-math option of GCC. > > I have swapped with #sqlite3.h and removed the dependencies > from the pre

[sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

Hi There, I am trying to add sqlite amalgamation into xcode and I keep getting the error error SQLite will not work correctly with the -ffast-math option of GCC. I have swapped with #sqlite3.h and removed the dependencies from the previous library but I think I'm missing something. Please advi

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

On 19 Jan 2018, at 1:48pm, R Smith wrote: > On 2018/01/19 3:36 PM, Simon Slavin wrote: > >> I hope one day to see SQLite4, in which everything done to avoid breaking >> backward compatibility is abandoned. > > That's an impossibility. > > If you mean that SQLite4 itself will not have to hono

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

On 2018/01/19 3:36 PM, Simon Slavin wrote: On 19 Jan 2018, at 12:43pm, Richard Hipp wrote: I hope one day to see SQLite4, in which everything done to avoid breaking backward compatibility is abandoned. That's an impossibility. If you mean that SQLite4 itself will not have to honour backwar

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

On 19 Jan 2018, at 12:43pm, Richard Hipp wrote: > Sometimes one has to compromise the simplicity of the > design, or to document bugs rather than fix them, in order to avoid > breaking legacy applications. I hope one day to see SQLite4, in which everything done to avoid breaking backward comp

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

On 1/19/18, Shane Dev wrote: > I missed that part of the documentation, thanks I apologize for this goofy exception to the rules. Maintaining a widely-used library like SQLite in a way that is backwards compatible is difficult. Sometimes one has to compromise the simplicity of the design, or to

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

01:32 >To: SQLite mailing list >Subject: [sqlite] "Error: NOT NULL constraint failed ..." when no >such constraint exists > >Hello, > >The following SQL works as I expect - > >sqlite> CREATE TABLE edges(parent int, child int, primary key(parent, >child))

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

I missed that part of the documentation, thanks On 19 January 2018 at 07:51, Rowan Worth wrote: > https://www.sqlite.org/withoutrowid.html > > "NOT NULL is enforced on every column of the PRIMARY KEY in a WITHOUT ROWID > table." > > It goes on to say that NOT NULL is supposed to be enforced on a

Re: [sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

https://www.sqlite.org/withoutrowid.html "NOT NULL is enforced on every column of the PRIMARY KEY in a WITHOUT ROWID table." It goes on to say that NOT NULL is supposed to be enforced on all PRIMARY KEY columns of _every_ table according to the SQL standard, but an early version of sqlite include

[sqlite] "Error: NOT NULL constraint failed ..." when no such constraint exists

Hello, The following SQL works as I expect - sqlite> CREATE TABLE edges(parent int, child int, primary key(parent, child)); sqlite> insert into edges select null, 1; sqlite> select * from edges; parent child 1 sqlite> but if I remove the superfluous rowid column from the table definitio

  1   2   3   4   5   6   7   8   9   10   >