I'm trying to run a script that fills a sqlite3 database.
The script creates a lock with `lockfile` , fills the database and
releases the lock.
$cat test.sh
#!/bin/sh
lockfile /commun/data/_tmp.idp448.lock
sqlite3 /commun/data/stats.sqlite "create table if not exists
timeBeginDB(target text UNIQUE NOT NULL,inserted int);"
rm -f /commun/data/_tmp.idp448.lock
whoami
without qsub the script works without any problem :
[lindenb]$ sh test.sh
lindenb
when qsub is invoked:
$ qsub -cwd -S /bin/sh test.sh
Your job 673 ("test.sh") has been submitted
$ cat test.sh.o673
lindenb
$ cat test.sh.e673
Error: database is locked
which is a sqlite3 error.
Do you have any idea, suggestion of what, on the SGE side, could be the
cause of that problem, this difference of behavior ?
Thank you
Pierre
_______________________________________________
users mailing list
[email protected]
https://gridengine.org/mailman/listinfo/users
