Re: [sqlite] semi corrupt db (w/stack-traces)

On Tue, 5 Dec 2006, Kees Nuyt wrote: what would be the best method to dump this db into another one to recover? sqlite olddb .dump | sqlite newdb this worked. thanks a million. I have no idea what could cause the segfault, except perhaps a version difference between the sqlite command

Re: [sqlite] semi corrupt db

On Tue, 5 Dec 2006, Kees Nuyt wrote: On Tue, 5 Dec 2006 08:06:41 -0700 (MST), you wrote: what would be the best method to dump this db into another one to recover? sqlite olddb .dump | sqlite newdb thanks. I have no idea what could cause the segfault, except perhaps a version difference

Re: [sqlite] SQLite and McAfee Anti-Virus

On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote: Dennis Cote <[EMAIL PROTECTED]> wrote: Roger Binns wrote: The usual approach is to write a web page about it and then publish a story on Slashdot. I have to second this idea. It worked well for Poul-Henning Kamp. OK. Thanks everybody for

Re: [sqlite] SQLite and McAfee Anti-Virus

On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote: I need advice from the community. The problem is seen here: http://www.sqlite.org/cvstrac/tktview?tn=2049 http://www.sqlite.org/cvstrac/tktview?tn=1989 http://www.sqlite.org/cvstrac/tktview?tn=1841

Re: [sqlite] strange issue with broken links/hung processes in transaction

On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote: I suspect that the /var/tmp file is unrelated to your mmap/munmap problem. When SQLite needs a temporary file on Unix, it creates the file, opens it, then calls unlink(). Unix removes the inode for the file from its directory immediately so that

[sqlite] strange issue with broken links/hung processes in transaction

i have some code which uses sqlite heavily. every so often a command using with hang indefinitely, running an strace on the code shows it to be stuck in a loop doing munmap addr1 mmap #=> addr1 munmap addr2 mmap #=> addr1 munmap addr1 ... ... repeat forever...

RE: [sqlite] [ANN] rq-2.3.3

On Fri, 9 Jun 2006, Pat Wibbeler wrote: I'm curious - how does this avoid the buggy NFS fcntl() problem mentioned under FAQ 7? http://www.sqlite.org/faq.html Does it use an external locking mechanism? sortof. basically rq setups a directory like this q/db q/lock q/... here the

[sqlite] Main freelist: 1 pages missing from overflow list

i'm getting this message from PRAGMA integrity_check; "*** in database main ***\nMain freelist: 1 pages missing from overflow list" funny thing is, the database seems to function correctly - which is to say 5 or 6 processes are currently using it with no errors. what should i make of this

Re: [sqlite] Sqlite powered Web Sites

On Tue, 31 Jan 2006, Clint Bailey wrote: Can anyone point me to web sites that are powered by Sqlite? I'm curious as to how they function as compared to a MySQL, or brand M$ powered site. check out the ruby on rails list - their are a few rails sites out there using sqlite. -a -- happiness

Re: [sqlite] atomic db replacement

- Original Message - From: Lothar M=E4rkle <[EMAIL PROTECTED]> Date: Sunday, March 13, 2005 11:39 pm Subject: Re: [sqlite] atomic db replacement > > does anyone have a strategy for doing massive updates to a db and > atomicly> replacing it in a multi-process situation? > > Assuming

[sqlite] [ANN] rq-1.0.0

URLS http://raa.ruby-lang.org/project/rq/ http://www.codeforpeople.com/lib/ruby/rq/ (http://rubyforge.org/projects/rqueue/ - under construction) NAME rq v1.0.0 SYNOPSIS rq (queue | export RQ_Q=q) mode [mode_args]* [options]* DESCRIPTION ruby queue (rq) is a tool used to create instant

[sqlite] [ANN] rq-0.1.7

URLS http://raa.ruby-lang.org/project/rq/ http://www.codeforpeople.com/lib/ruby/rq/ NAME rq v0.1.7 SYNOPSIS rq (queue | export RQ_Q=q) mode [mode_args]* [options]* DESCRIPTION ruby queue (rq) is a tool used to create instant linux clusters by managing sqlite databases as nfs mounted