I'm new to the list, so apologies if this has been posted before.
I am using sqlite3 3.7.17 on Linux Slackware64 14.1. I use the sqlite3 command
every 10 minutes to query several Thunderbird calendar databases. Occasionally,
I
have a message, "Error: database is locked"; understandable since
ine, read-only
>
> On Mon, Apr 25, 2016 at 2:33 PM, Mark Foley wrote:
>
> > I'm new to the list, so apologies if this has been posted before.
> >
> > I am using sqlite3 3.7.17 on Linux Slackware64 14.1. I use the sqlite3
> > command
> > every 10 minutes to q
ommand line, read-only
>
> On 25 Apr 2016, at 1:33pm, Mark Foley wrote:
>
> > I am using sqlite3 3.7.17 on Linux Slackware64 14.1. I use the sqlite3
> > command every 10 minutes to query several Thunderbird calendar databases.
> > Occasionally, I
> > have a m
ng the timeout
value to stdout).
I wonder, then, why I get a lock error if the database is read-only in the first
place?
THX --Mark
-Original Message-
> Date: Mon, 25 Apr 2016 08:42:26 -0400
> From: Richard Hipp
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line
tegory
Green Category
Blue Category
Purple Category
Blue Category,Holidays
Personal
Didn't give an error and didn't echo the 5000 to stdout. Do you suppose that
will work?
--Mark
-Original Message-
> Date: Mon, 25 Apr 2016 09:10:58 -0400
> From: Richard Hipp
> To: SQLite mailing l
vin
> Date: Mon, 25 Apr 2016 14:12:27 +0100
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On 25 Apr 2016, at 2:00pm, Mark Foley wrote:
>
> > problem is that the PRAGMA
> > statement echo the timeout value to stdout:
> >
400
> From: Richard Hipp
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On 4/25/16, Mark Foley wrote:
> >
> > I wonder, then, why I get a lock error if the database is read-only in the
> > first
> > place?
>
eferring to the "*file:*" syntax?
--Mark
-Original Message-
> Date: Mon, 25 Apr 2016 15:14:56 +0200
> From: Dominique Devienne
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On Mon, Apr 25, 2016 at 2:53 PM, Mark Foley w
OK, I'm at 3.7.17, so too old for .once.
--Mark
-Original Message-
> Date: Mon, 25 Apr 2016 09:32:48 -0400
> From: Richard Hipp
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On 4/25/16, Mark Foley wrote:
> >
>
OK, I'll go with that and see if I get any more lock errors.
--Mark
-Original Message-
From: Simon Slavin <slav...@bigfraud.org>
Date: Mon, 25 Apr 2016 14:30:26 +0100
To: SQLite mailing list
On 25 Apr 2016, at 2:28pm, Mark Foley wrote:
> As I just wrote to Richard Hip
mail.com>
To: SQLite mailing list
Subject: Re: [sqlite] sqlite3 command line, read-only
On Mon, Apr 25, 2016 at 3:35 PM, Mark Foley wrote:
> On Mon, 25 Apr 2016 15:14:56 Dominique Devienne
> wrote:
> > Please (re)read the example I included. --DD
> > C:\Users\DDevienne>s
t; Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On Mon, Apr 25, 2016 at 4:28 PM, Mark Foley wrote:
>
> > I'm running this on Linux. That Windows notation doesn't work.
> >
> > sqlite3
> > "*file:*/mnt/tmp/Users/.../AppData/Roaming/Thunderbird/Prof
workstation drives with the intention of changing files.
--Mark
-Original Message-
> From: Simon Slavin
> Date: Mon, 25 Apr 2016 17:15:20 +0100
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On 25 Apr 2016, at 5:12pm, Mark Foley wrot
m: Dominique Devienne <ddevie...@gmail.com>
To: SQLite mailing list
Subject: Re: [sqlite] sqlite3 command line, read-only
On Mon, Apr 25, 2016 at 6:12 PM, Mark Foley wrote:
> Nope: still error:
>
> sqlite3 \
> '*file:*/mnt/tmp/Users/hcarr.HPRS.000/AppData/Roaming/Thunderbird/
I'm back with more read-only issues.
Thanks to postings on this list, I've made progress, but still more issues.
Using the sqlite3 command-line, I'm attempted to open,
read-only, a database located on a Windows 7 workstations, from a Linux server.
I am mounting the Windows volume r/o:
mount
22:31:11 -0600
> From: Scott Robison
> To: SQLite mailing list
> Subject: Re: [sqlite] sqlite3 command line, read-only
>
> On Apr 26, 2016 8:16 PM, "Mark Foley" wrote:
> >
> > I'm back with more read-only issues.
> >
> > Thanks to postings
16 matches
Mail list logo