On 14 Nov 2018, at 4:20am, Sharma, Tanuj [AUTOSOL/FMP/IN]
wrote:
> I want to know why auto_checkpoint is not working when there is no Primary
> Key in the table.
If, during your testing, you're using existing database files, please create
new ones each time.
Can you please publish your sche
On 11/13/18, Sharma, Tanuj [AUTOSOL/FMP/IN] wrote:
> I have observed that when I don't have any primary key in the database table
> then WAL auto_checkpoint doesn't work
That's surprising because the WAL logic does not have anything to do
with primary keys. Those are two completely independent s
Dear SQL Developers / Users,
I am using Sqlite3 in our project. My database has journal_mode set to WAL and
has one writer & multiple readers. During normal mode of operation, only
writing process is accessing database and there is no active reader connection
I have observed that when I don't ha
> On Nov 13, 2018, at 2:18 AM, Hegde, Deepakakumar (D.)
> wrote:
>
> #0 sqlite3DbMallocRawNN (db=db@entry=0x1dea20, n=176093659143
> ) at
> /workspace/workspace/Trigger-Build-Host_Job/host/yunos6.0/third_party/sqlite/sqlite3.c:24732
176093659143 = 0x290007
Looks kind of like it was su
> it is almost guaranteed to corrupt the database file if more than one
connection tries to access it at the same time.
I understand the risks and reasons, but have had numerous databases on our
Windows network accessed by 20+ users throughout the day without issue.
Thanks,
Chris
On Sun, Nov 1
On Sun, 2018-11-11 at 00:49 +, am...@juno.com wrote:
> [EXTERNAL SOURCE]
>
>
>
> November 10, 2018 Dear Good People: I work for a company that has a many
> locations with more than one person in every location. I want to share the
> databases I have built using SQLITE with some of
> the pe
Hi All,
We are facing a problem in which sqlite library function sqlite3DbMallocRawNN()
is getting crashed inside the sqlite3_prepare_v2() function to prepare the
statement.
As per the analysis "n" value input to this seems to have a big value causing
the crash. checked the input value to sqli
On 11/13/18, Hegde, Deepakakumar (D.) wrote:
> Hi All,
>
>
> We are facing a problem in which sqlite library function
> sqlite3DbMallocRawNN() is getting crashed inside the sqlite3_prepare_v2()
> function to prepare the statement.
This sort of thing is almost always the result of heap corruption
Ok, now I understand. Thank you (and Richard) very much.
- Original Message -
From: Keith Medcalf
To: SQLite mailing list
Sent: Tuesday, November 13, 2018, 14:06:11
Subject: [sqlite] Broken Foreign key
On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked:
>May I ask why parent ke
On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked:
>May I ask why parent keys *must* have indexes? I don't see any
>correlation between enforcing a client/parent-relationship and the
>necessity for an index. I'm just asking to better understand. To me
>it is clear that the parent column is
My guess on the requirement on the Parent Key needing a Unique Index is
that every insert into the child field needs to verify that there IS a
corresponding value in the parent key, and it would be SO inefficient
(in general) to need to do a full table scan to verify this, that it is
required to ha
May I ask why parent keys *must* have indexes? I don't see any correlation
between enforcing a client/parent-relationship and the necessity for an index.
I'm just asking to better understand. To me it is clear that the parent column
is to be declared as PRIMARY KEY or UNIQUE, but why does it nee
You do not need to define a column as UNIQUE and also put a UNIQUE INDEX on it.
create table a
(
b unique
);
is merely syntactic sugar for
create table a
(
b
);
create unique index sqlite_autoindex_a_1 on a (b);
so declaring something with a unique constraint on a column and also explic
I see. That version of the database is missing primary key option4_name...
Why did it suddenly start failing without the primary key index when it was
working for a very long time ...
it's almost like something removed the primary key
table|option4_name|CREATE TABLE `option4_name` (`name_id` cha
sqlite-users@mailinglists.sqlite.org
From: Hegde, Deepakakumar (D.)
Sent: Tuesday, November 13, 2018 3:48 PM
To: 'SQLite mailing list'; General Discussion of SQLite Database
Subject: Sqlite Crash in sqlite3DbMallocRawNN.
Hi All,
We are facing a problem in whic
Hi All,
We are facing a problem in which sqlite library function sqlite3DbMallocRawNN()
is getting crashed inside the sqlite3_prepare_v2() function to prepare the
statement.
As per the analysis "n" value input to this seems to have a big value causing
the crash. checked the input value to sq
16 matches
Mail list logo