mjuric/lsd — Issue #10: "Exception: Another transaction is already ongoing" (even though there isn't)
Author: ericmorganson
Created: 2011-11-18 10:23:29+00:00
State: open

I am getting an error any time I try to create a table or have any query that ends in "into database" in our defaults LSD directory. The error is

"Exception: Another transaction is already ongoing" (full text below).

But nothing else is going on in LSD world. There are no queries. But we have had some jobs crash (particularly a query that had 'into' database"). I cannot make a new database in that directory. I can, however, do anything I want if I use --db=BLAH to set a new directory. We have restarted the computer since this problem started. So I think there must be some half finished file somewhere. But I have clear my temp and cache directories.

lsd-admin create table --comp blosc --comp-level 5 --primary-key obj_id --spatial-keys ra,dec zdrops_small obj_id:u8 ra:f8 dec:f8 y:f4 erry:f4 stdevy:f4 nok:i2 mjdy:5f4
Traceback (most recent call last):
File "/a41217d5/LSD/stable/bin/lsd-admin", line 580, in
args.func(args)
File "/a41217d5/LSD/stable/bin/lsd-admin", line 121, in do_create_table
with db.transaction():
File "/usr/local/misc/python/Python-2.7.2/lib/python2.7/contextlib.py", line 17, in __enter__
return self.gen.next()
File "/a41217d5/LSD/stable/lib/python2.7/site-packages/lsd/join_ops.py", line 1834, in transaction
self.begin_transaction()
File "/a41217d5/LSD/stable/lib/python2.7/site-packages/lsd/join_ops.py", line 1760, in begin_transaction
raise Exception('Another transaction is already ongoing')
Exception: Another transaction is already ongoing