Hi,
I've been back-porting SQLite 3.x to CentOS 4.7 for some development
work. I've been taking the SRPMS from koji.fedoraproject.org and
rebuilding them.
All has been fine through v3.6.7 but when I tried to recently upgrade to
3.6.10 (by just updating the SPEC file and rebuilding), the YUM u
I am not sure agree. Companies that don't upgrade DBI releases are
unlikely to upgrade DBD drivers more frequently; and they're always free
to use older DBD releases. We don't want to hold developers hostage to
the tendency of a few companies to be slow in upgrades.
At my workplace, a large c
Hello Richard
I'm using a heavily-modified version of threadtest1.c from the SQLite
test suite to run on my embedded platform. I think Noah may be on to
something (thanks Noah!) - I looked at the stacktrace and found that the
specific sqlite3OsRead() call he mentioned was triggering my bad VFS
rea
On Jan 16, 2009, at 6:54 PM, D. Richard Hipp wrote:
>
> On Jan 16, 2009, at 6:43 PM, Noah Hart wrote:
>
>> Just a random thought ... This is new code in pager.c,
>> and if Pager->journalOff is at the end of the file,
>> then perhaps it could cause his problem.
>>
>> **
>> ** To work
On Jan 16, 2009, at 6:43 PM, Noah Hart wrote:
> Just a random thought ... This is new code in pager.c,
> and if Pager->journalOff is at the end of the file,
> then perhaps it could cause his problem.
>
>**
>** To work around this, if the journal file does appear to
> contain
>
Just a random thought ... This is new code in pager.c,
and if Pager->journalOff is at the end of the file,
then perhaps it could cause his problem.
**
** To work around this, if the journal file does appear to
contain
** a valid header following Pager.journalOff, then wr
On Jan 16, 2009, at 5:38 PM, Dave Toll wrote:
> Hello list
>
>
>
> I recently upgraded from SQLite 3.6.7 to 3.6.10 and I'm now noticing
> some apparently undesirable behaviour. I'm running on an embedded
> system
> with my own VFS implementation, and I see in my tests that SQLite is
> now
> t
Hello list
I recently upgraded from SQLite 3.6.7 to 3.6.10 and I'm now noticing
some apparently undesirable behaviour. I'm running on an embedded system
with my own VFS implementation, and I see in my tests that SQLite is now
trying to read journal files at an offset beyond the end of the file.
I am currently using Sqlite version 2.8.13. We have one thread that constantly
inserts data to sqlite tables. I have a UI application that reads data from
the same database, I sometimes get an error from the UI app: "Attempted to read
or write protected memory. This is often indication that o
Dao, Trien (STP) wrote:
>> I have two tables - header and detail tables - that are a master
>> -detail type setup, with header ID item is the FK to rowID in the
>> detail table. Deleting a record in the header table, would that
>> also delete the records in the detail table?
Not automatically, b
> -Original Message-
> From: Dao, Trien (STP)
> Sent: Friday, January 16, 2009 10:32 AM
> To: 'sqlite-users-boun...@sqlite.org'
> Subject: Question on delete record in a master-detail type tables
>
> I have two tables - header and detail tables - that are a master -deta
On Fri, Jan 16, 2009 at 02:46:54PM -0500, D. Richard Hipp wrote:
> >> Yes. FTS3 is not robust against malloc failures. FTS3 will
> >> sometimes segfault following a malloc failure. This is a known
> >> issue. We are working on it.
> >
> > Is that true only when one uses FTS3?
> >
> > Or is it t
Hi,
I'm running a multi-threaded application and am running into some
concurrency issues. I have thread "A" which is attempting to do
thousands of reads that take approximately 20-50ms each. Thread "B" is
writing to the database and each write takes a few seconds. Currently,
it appears that
On Jan 16, 2009, at 2:24 PM, Nicolas Williams wrote:
> On Fri, Jan 16, 2009 at 02:22:35PM -0500, D. Richard Hipp wrote:
>>
>> On Jan 16, 2009, at 2:07 PM, Nicolas Williams wrote:
>>
>>> On Sat, Jan 17, 2009 at 02:04:47AM +0700, Dan wrote:
> What do those mean? Are these errors a problem?
>>>
Is it safe to ship 3.6.10 with FTS3 compiled in?
Oh, I've found ticket #2762, which helps explain what I'm seeing.
Basically, SQLite 3.6.9 (haven't tried 3.6.10 yet, though obviously I
must) and earlier had bugs in FTS3 where FTS3 was using malloc()/
free()/... directly from libc instead of sqlit
Hello!
В сообщении от Friday 16 January 2009 18:25:34 jose isaias cabrera написал(а):
> Did not come attached... Will you send it again?
Source:
http://mobigroup.ru/dload/sqlite3.6.7/env.c
Full source:
http://mobigroup.ru/dload/sqlite3.6.7/sqlite-3.6.7.tar.bz2
Compiled:
http://mobigroup.ru/dloa
On Fri, Jan 16, 2009 at 02:22:35PM -0500, D. Richard Hipp wrote:
>
> On Jan 16, 2009, at 2:07 PM, Nicolas Williams wrote:
>
> > On Sat, Jan 17, 2009 at 02:04:47AM +0700, Dan wrote:
> >>> What do those mean? Are these errors a problem?
> >>
> >> Are you compiling with SQLITE_ENABLE_FTS3 defined?
On Jan 16, 2009, at 2:07 PM, Nicolas Williams wrote:
> On Sat, Jan 17, 2009 at 02:04:47AM +0700, Dan wrote:
>>> What do those mean? Are these errors a problem?
>>
>> Are you compiling with SQLITE_ENABLE_FTS3 defined?
>
> Yes. Would that make a difference?
Yes. FTS3 is not robust against mallo
On Sat, Jan 17, 2009 at 02:04:47AM +0700, Dan wrote:
> > What do those mean? Are these errors a problem?
>
> Are you compiling with SQLITE_ENABLE_FTS3 defined?
Yes. Would that make a difference?
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
On Fri, Jan 16, 2009 at 01:14:28PM -0500, D. Richard Hipp wrote:
> > What do those mean? Are these errors a problem?
>
> These are simulated malloc() failures. They are important for
> embedded devices (which tend to run out of memory) but not so much on
> Solaris. When was the last time yo
On Jan 17, 2009, at 12:58 AM, Nicolas Williams wrote:
> Failures on these tests: malloc-1.transient.40 malloc-10.transient.40
>malloc-14.transient.40 malloc-17.transient.41
> malloc-20.transi ent.40 malloc-26.transient.40
>
> malloc-1.transient.40..
On Jan 16, 2009, at 12:58 PM, Nicolas Williams wrote:
> Failures on these tests: malloc-1.transient.40 malloc-10.transient.40
>malloc-14.transient.40 malloc-17.transient.41
> malloc-20.transi ent.40 malloc-26.transient.40
>
> malloc-1.transient.40..
Failures on these tests: malloc-1.transient.40 malloc-10.transient.40
malloc-14.transient.40 malloc-17.transient.41
malloc-20.transi ent.40 malloc-26.transient.40
malloc-1.transient.40...
Expected: [1 1]
Got: [0 {1 2.3 4.5 hi there^@ 6 7.0 0.8
On Fri, Jan 16, 2009 at 09:43:36AM +0100, Christophe Leske wrote:
> sqlite> .o cl1.sql
^^
This says: send output of queries to a file called "cl1.sql".
> sqlite> .dump cl1%
And this says: dump the named table.
> sqlite> select * from cl1;
And the output of this will still go
> After you complete your ".dump" do:
>
> .output stdout
>
Ok, that was stupid, my apologies.
Yet somehow this used to work i think...
Still, when rereading the dumped table, it does not reread the values
correctly for the rtree table.
I am sorry, I must go now, I can provide further in
On Jan 16, 2009, at 3:42 AM, Christophe Leske wrote:
>
>> Try instead:
>>
>>.dump cl1%
> Apparently, this doesn´t help either. Once I tried to export the
> table, the application refuses to show the entries in the table.
>
> The database i am opening here is correct, it holds data in cl1
Did not come attached... Will you send it again?
- Original Message -
From: "Alexey Pechnikov"
To: "General Discussion of SQLite Database"
Sent: Friday, January 16, 2009 5:47 AM
Subject: Re: [sqlite] need a CURRENT_USER() function
> Hello!
>
> В сообщении от Friday 16 January 2009 00
On Jan 16, 2009, at 3:43 AM, Christophe Leske wrote:
>
> Do you want me to mail you the corrupted database for further
> inspection? I also understand that this is not the right place for
> bugreports eventually.
No. Email me the original, uncorrupted database and instructions for
how to make
On Fri, Jan 16, 2009 at 11:52:01AM +0100, Mohamed Zayed scratched on the wall:
> Hi,
>
> I wender if you ever have experienced this kind of problem. In fact, I used
> to create a database which
> contains about 1.5 Millions records.
>
> The problem is, when I do this on :
> Linux 2.6.9-34.ELsmp #
As a (new) user I followed the advice looking at the tcl test examples
to understand how to move text files to an sql database using blobs or
incrblobs.
Net result is I can't unerstand or do it.
Please has someone got a tcl script(s) that loads and unloads files? -
further perhaps reading and
"Pramoda M. A"
wrote in message
news:f7846b8f3c78c049b6a1dff861f6c16f031cd...@kcinblrexb01.kpit.com
> How to use BEGIN and COMMIT in my C program?
They are statements. You exectue them as you would any other statement,
like INSERT or UPDATE.
Igor Tandetnik
__
HI ,
We are using freescale 1.MX31 board and Windows CE OS. We have ported
sqlite 3.6.5.
But system is hanging after porting.
My colleagues saying that malloc functions used by sqlite itself causing
the problem.
Is it true?
Can anybody please help me in this regard?
Pramoda.M.A
> Try instead:
>
> .dump cl1%
Apparently, this doesn´t help either. Once I tried to export the table, the
application refuses to show the entries in the table.
The database i am opening here is correct, it holds data in cl1 prior to
opening it for this step here:
Microsoft Windows XP [Ver
Hi,
I would like to highlight the fact the in large corporations, bumping
DBI to new version is a major issue, as the module serve as a
foundation for hundreds of applications, which must be retested on every
change. As a result, large companies will bump DBI version every few
years.
Also, large
Jim Dodgen schrieb:
> I'm a strong believer in the "continuous improvement" philosophy. Keep up
> the good work.
>
Same here. Better fix stuff as you know of it.
Please keep up the great work with SQlite, i never used such a good and
sturdy tool that just did what it was supposed to do.
I th
Hi All,
How to use BEGIN and COMMIT in my C program?
Main()
{
BEGIN;
Sqlite3_exec(db, - - - -);
COMMIT;
}
Is it valid?
Pramoda.M.A
KPIT Cummins Infosystems Limited | Bengaluru
___
s
Mohamed Zayed writes:
>
> Hi,
>
...
> The problem is, when I do this on :
> Linux 2.6.9-34.ELsmp #1 SMP Sun Mar 19 13:54:02 CST 2006 i686 i686 i386
> GNU/Linux
>
> it takes less than 10 minutes
>
> However when, I do it on :
> Linux 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86
Hi,
I wender if you ever have experienced this kind of problem. In fact, I used
to create a database which
contains about 1.5 Millions records.
The problem is, when I do this on :
Linux 2.6.9-34.ELsmp #1 SMP Sun Mar 19 13:54:02 CST 2006 i686 i686 i386
GNU/Linux
it takes less than 10 minutes
How
Hello!
В сообщении от Friday 16 January 2009 00:23:18 Hoover, Jeffrey написал(а):
> Can anyone tell me set-by-step how to add a CURRENT_USER() function to
> SQLLITE that will return the current linux login?
See attached file.
Best regards, Alexey.
___
Hello!
В сообщении от Thursday 15 January 2009 20:07:49 D. Richard Hipp написал(а):
> All this is to say that we believe that SQLite version 3.6.10 is the
> most stable, most thoroughly tested, and bug-free version of SQLite
> that has ever existed. Please do not be freaked out by three releas
Hello!
В сообщении от Friday 16 January 2009 00:16:43 Thomas Hertweck написал(а):
> It would not make sense to delay bug fixes, but have you ever thought
> about using a different version number scheme? In the Linux kernel
> development
Linux kernel versions compability is bad and so version numb
writes:
>
> Yes its generating the binary
>
> But how can i make sure that the binary is for ARM
>
> I can able to run the binary in X86 environment. (Actually it should not run
> in x86)
>
Look like you aren't using the cross-compiler - that ./configure
statement should let your 'make' use t
Hi Jeffrey,
use something like this:
struct passwd *who;
if ((who = getpwuid(getuid ())) != NULL)
{
oUserName = who->pw_name;
}
where oUserName is the desired result.
See http://www.sqlite.org/capi3ref.html#sqlite3_create_function how to
define your function.
Martin
> Try instead:
>
> .dump cl1%
Apparently, this doesn´t help either. Once I tried to export the table,
the application refuses to show the entries in the table.
The database i am opening here is correct, it holds data in cl1 prior to
opening it for this step here:
Microsoft Windows XP [Vers
44 matches
Mail list logo
