[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