forum.vmspython.org Forum Index forum.vmspython.org
Forum system
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Sqllite3 DB locked?

 
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> Python for OpenVMS
View previous topic :: View next topic  
Author Message
RonPeters



Joined: 18 Sep 2008
Posts: 9

PostPosted: Fri Nov 04, 2011 11:56 pm    Post subject: Sqllite3 DB locked? Reply with quote

Hello JFP,

When I try to execute any command using Sqlite3 I am receiving a database is locked error. I am using OpenVMS 8.4 IA64. Py 2.7.2
I have tried the following to no success on an OSD5 disk:
"PYTHON_FILE_SHARING" = "1"
$ define DECC$FILE_SHARING ENABLE

Do you have any ideas? Could it be some tmp directory isn't set correctly?

Thanks!
/ARon

Code:

python
Python 2.7.2+ (default, Oct  4 2011, 07:32:05) [DECC] on OpenVMS
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> mydb = 'test.db'
>>> c = sqlite3.connect(mydb)
>>> cur = c.cursor()
>>> cur.execute('CREATE TABLE mytable (Id INTEGER PRIMARY KEY, Date TEXT, Entry TEXT)')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
_sqlite3.OperationalError: database is locked
>>> cur.close()
>>> quit()

Back to top
View user's profile Send private message
jfp



Joined: 12 Jul 2004
Posts: 636

PostPosted: Sat Nov 05, 2011 8:13 am    Post subject: Reply with quote

Hello,

On a OpenVMS 8.3 IA64:
Code:
$ python
Python 2.7.2+ (default, Oct 26 2011, 20:24:26) [DECC] on OpenVMS
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> mydb = 'test.db'
>>> c = sqlite3.connect(mydb)
>>> cur = c.cursor()
>>> cur.execute('CREATE TABLE mytable (Id INTEGER PRIMARY KEY, Date TEXT, Entry
TEXT)')
<_sqlite3.Cursor object at 0x1587988>
>>>  Exit


I will try to find a 8.4 system to try to reproduce the problem.


JF
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> Python for OpenVMS All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group