[GRASSLIST:374] v.patch failed: "Error in sqlite3 - database is locked"
Patton, Eric
epatton at nrcan.gc.ca
Fri Mar 24 22:30:16 EST 2006
I've been working in sqlitefor the first time today and it's been going
really well. I have two vector maps that are both connected to tables
through the sqlite driver:
v.db.connect map=Class_1 -g
1 Class_1_cleaned cat /home/eric/Projects/FNBL/PERMANENT/database/Coasts
sqlite
v.db.connect map=Class_2 -g
1 Class_2_cleaned cat /home/eric/Projects/FNBL/PERMANENT/database/Coasts
sqlite
Both tables were originally csv files imported to sqlite. I made sure that
the cat columns were set up to be the integer primary keys in each table.
Here are the full table descriptions from db.describe:
db.describe table=Class_1_cleaned
table:Class_1_cleaned
description:
insert:?
delete:?
ncols:4
column:cat
description:
type:INTEGER
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:CLASS_CODE
description:
type:INTEGER
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:CLASS
description:
type:TEXT
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:Seg_Length
description:
type:DOUBLE PRECISION
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
db.describe table=Class_2_cleaned
table:Class_2_cleaned
description:
insert:?
delete:?
ncols:4
column:cat
description:
type:INTEGER
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:CLASS_CODE
description:
type:INTEGER
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:CLASS
description:
type:TEXT
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
column:Seg_Length
description:
type:DOUBLE PRECISION
len:-1
scale:0
precision:0
default:
nullok:yes
select:?
update:?
And when I try to patch the two together using v.patch -e, I get the
following error:
DBMI-SQLite driver error:
Error in sqlite3_step():
database is locked
I am not concurrently using sqlite so I'm not sure why it's reporting that
the database is locked.
Any ideas?
~ Eric.
More information about the grass-user
mailing list