Hello,
I use SQLite 3.5.2 on ARM9 embedded system. ( Linux 2.4 )
My program sometimes meets segmentation fault ! ( randomly, maybe several
hours, maybe several days ! )
Here is a clip from GDB:
-- snip --
(gdb) backtrace
#0 syncJournal (pPager=0x102028) at src/pager.c:2417
#1 0x0007cbbc in sqlit
I compiled your program with MinGW gcc 3.4.2 on Windows with
sqlite-amalgamation-3_5_3.zip.
gcc -I. ged.c sqlite3.c -o ged.exe
It runs fine. If another sqlite3 process issues a query like:
select * from test;
while ged.exe is running, then ged.exe will exit with:
Creating 10 rows...
Overall sqlite is losing its credits.
Now when i run sqlite in multithread & multi process
mode system experiences a infinite loop in the
busy handler. Also there is no log which tell
which process/thread has acquired the lock,hence needing complete system halt
and restart. This observed in 3.4.0
about this synchronization of multiple writers, can you please explain on how
to make this possible? or your just saying that i need to make a daemon that
will eventually synchronize the writers?
John Stanton-3 wrote:
>
> Multiple writers merely have to be synchronized.
>
> arbalest06 wrote:
Joanne Pham wrote:
Hi John,
Thanks a lot for your response.
Make sure I am understanding your answer related to SQLITE_BUSY. So I need to
change my code from
Open the database connection
BEGIN
insert ...using sqlite3_step
insert ...using sqlite3_step
END
to
Open the database c
looks like the link target and desc were reversed in the Nov 27 news item ...
the target is "download" and the description is "download.html" when it
should be the other way around
also, are old releases archived somewhere ? i cant seem to find an "archives"
or "old releases" link on the front
On Wed, 28 Nov 2007 15:03:01 -0500, "Shawn Milochik"
<[EMAIL PROTECTED]> wrote:
>Hi. I just joined the list. I'm a developer who mainly works on the Linux
>command line with Makefiles, Perl one-liners, and some Perl and Python
>scripts. Nearly 100% of what I do is processing tab-delimited files.
>
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> article ::= blocks.
>
> blocks ::= block.
> blocks ::= blocks block.
>
> block ::= heading.
> block ::= paragraph.
>
> heading ::= HEADING_START text HEADING_END.
> heading ::= HEADING_START text.
> heading ::= HEADING_START.
>
> paragraph ::= text N
Hi John,
Thanks a lot for your response.
Make sure I am understanding your answer related to SQLITE_BUSY. So I need to
change my code from
Open the database connection
BEGIN
insert ...using sqlite3_step
insert ...using sqlite3_step
END
to
Open the database connection
BEGIN
If performance is very important to you and you have a need for SQL
elsewhere consider using the Sqlite virtual table interface. Your
virtual table can be a flat file which is memory mapped and you use
either a regex or fast string search on it. You will have a result in
milliseconds. You co
On 11/28/07, Shawn Milochik <[EMAIL PROTECTED]> wrote:
> I have a couple of questions, but I am going to lurk a bit first. However,
> is there an archive? I didn't receive one by e-mailing the automated help
> address for this list. I'd like to see if the answers are there first.
Welcome :)
Ther
On 11/28/07, Spiros Ioannou <[EMAIL PROTECTED]> wrote:
> > egrep gets to work with a flat text file, which it can easily read
> > sequentially and get optimal performance from the OS's file
> > buffering/cache management. It only needs to read a piece of the file
> > and scan for patterns, repeat
Spiros Ioannou <[EMAIL PROTECTED]> wrote:
> John Stanton wrote:
> > Sqlite does cater for text searching. Look at FTS.
>
> This is not text searching. No stemming, etc etc is required. Column has
> exactly 1 word, and the 'LIKE' substring matching is performed at the
> words' first characters (
You could use a BEGIN IMMEDIATE to lock the DB before you launch the
transaction and loop on SQLITE_BUSY or use the plain BEGIN which will
allow reads during the transaction and not lock the DB until you issue a
COMMIT (the END). Just loop on the BUSY on the END SQL statement until
the user wh
Hi. I just joined the list. I'm a developer who mainly works on the Linux
command line with Makefiles, Perl one-liners, and some Perl and Python
scripts. Nearly 100% of what I do is processing tab-delimited files.
I live in Reading, PA. My main hobby is magic -- the art of illusion, not
the card g
John Stanton wrote:
Sqlite does cater for text searching. Look at FTS.
This is not text searching. No stemming, etc etc is required. Column has
exactly 1 word, and the 'LIKE' substring matching is performed at the
words' first characters (not end-characters).
Thanks,
-Spiros
--
Hi All,
Here my statements to insert rows into the database
Open the database connection
BEGIN
insert ...using sqlite3_step
insert ...using sqlite3_step
END
So at the time I issued "END" transaction I got the error message SQLITE_BUSY
so I need to issue the "END" transaction
Hi All,
I have used "BEGIN" and "END" Transaction to insert the data to SQLite database.
BEGIN
insert ...
insert ...
END
When I issued the "END" operation the error message return back is
"SQLITE_BUSY".
What should I do if I want to handle SQLITE_BUSY /retry the transactio
Trevor Talbot wrote:
On 11/27/07, Spiros Ioannou <[EMAIL PROTECTED]> wrote:
I had a 135MB, 1256132 lines, '@' separated text file containing
various words and text fields (like a dictionary).
Example record:
[EMAIL PROTECTED]@[EMAIL PROTECTED],[EMAIL PROTECTED] altana : μικρός ανθόκηπος
- εξώ
Multiple writers merely have to be synchronized.
arbalest06 wrote:
so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the same time right?..
Igor Tandetnik wrote:
arbalest06 <[EMAIL PROTECTED]> wrote:
q#1: is it possible that mu
Firstly, thank you all for your answers,
egrep gets to work with a flat text file, which it can easily read
sequentially and get optimal performance from the OS's file
buffering/cache management. It only needs to read a piece of the file
and scan for patterns, repeating until done. The only st
I am trying to write a Wiki parser with Lemon. The Lemon features suite my
needs perfectly, but I am unfortunately stuck with the problem of parsing
conflicts.
All conflicts seem caused by repeat constructs like this:
text ::= textpiece.
text ::= text textpiece.
The complete grammar follow
Hello all,
Got a problem when trying to install the sqlite-3.5.3 build using port for
GNU Darwin :
---> Verifying checksum(s) for sqlite3
Error: Checksum (sha1) mismatch for sqlite-3.5.3.tar.gz
Error: Target org.macports.checksum returned: Unable to verify file
checksums
Error: Status 1 encounte
On Nov 28, 2007, at 11:01 PM, Mark Brown wrote:
Hi-
Could someone please tell me how I can run the SQLite tests? I see
them in
CVS, but I'm not sure what to do with them. Since I'm running on
vxWorks, I
think they would provide an excellent way for me to know what
problems I may
have
Hi-
Could someone please tell me how I can run the SQLite tests? I see them in
CVS, but I'm not sure what to do with them. Since I'm running on vxWorks, I
think they would provide an excellent way for me to know what problems I may
have with my particular OS implementation.
Thanks,
Mark
Simon Davies wrote:
> Compiled your snippet using VS2005 on XP, sqlite 3.4.2 -
> ran to completion with no errors
Yeah, I had no errors when I ran this using the native exports from the
System.Data.SQLite.dll .NET wrapper from http://sqlite.phxsoftware.com
This also uses the 3.4.2 library.
I can
Hi Ged,
Compiled your snippet using VS2005 on XP, sqlite 3.4.2 -
ran to completion with no errors
Rgds,
Simon
PS Took nrly 2 hrs. Added "BEGIN" and "COMMIT" around insert loop,
reduced time to 10 seconds
On 27/11/2007, Ged Murphy <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi,
>
>
>
> I am doing some pr
Joe & Igor - thanks for the tips!
Mark
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 27, 2007 5:39 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: Distinguishing empty-result SELECT
> from INSERT, UPDATE, DELETE, etc.
>
> See also
Thanks for addressing this, Richard.
Preset the legacy_file_format pragma to the value of the
primary database so that a VACUUM will not unknowingly
alter the setting. Ticket #2804.
http://www.sqlite.org/cvstrac/chngview?cn=4574
Could you please update the PRAGMA documentation to reflect t
On 11/28/07, arbalest06 <[EMAIL PROTECTED]> wrote:
> ok..thanx for that..now if process A is writing into the database, and
> process B attempts to write, does sqlite take note of B's attempt and gives
> the permission to B when A is done? like would it be a queue that the first
> process that att
ok..thanx for that..now if process A is writing into the database, and
process B attempts to write, does sqlite take note of B's attempt and gives
the permission to B when A is done? like would it be a queue that the first
process that attempted to write should be given priority to write? or is it
>so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the >>same time right?..
--Yes
-Sreedhar
Igor Tandetnik wrote:
>
> arbalest06 <[EMAIL PROTECTED]> wrote:
>> q#1: is it possible that multiple users can write into the database
>
arbalest06 <[EMAIL PROTECTED]> wrote:
so there is really no way that multiple processes can write into the
database?..
Correct.
but multiple processes can read at the same time right?..
Right.
Igor Tandetnik
-
To
so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the same time right?..
Igor Tandetnik wrote:
>
> arbalest06 <[EMAIL PROTECTED]> wrote:
>> q#1: is it possible that multiple users can write into the database
>> at the same time?
>
arbalest06 <[EMAIL PROTECTED]> wrote:
q#1: is it possible that multiple users can write into the database
at the same time?
No.
q#2: if users A, B, C are writing to the database at the same time,
They can't.
q#3: if users A, B, C are writing to the database at the same time,
They can't.
There is no association of this flag and code in sqlite3.5.2,
does this really have any impact while building sqlite?
regards
ragha
**
This email and its attachments contain confidential information from H
good day!
thanx guys for helping me out..i got it working already..i just
misunderstood your solutions, that's why it took me a while to get it
right.. =^D
now i have another question, still related to this topic, but more on
theoretical..
q#1: is it possible that multiple users can write into
>> Imagine that a SQLite3 database opened in a custom application with a
>> registered a collation sequence named "unknown" has created the following
>> table:
>>
>> CREATE TABLE a (b COLLATE unknown);
>>
>> Now open this table in the default SQLite3 CLI. Up to here, everything works
>> as ex
38 matches
Mail list logo
