[Biopython-dev] [Bug 2390] Error importing Swiss Prot in BioSQL

[bugzilla-daemon at portal.open-bio.org]

http://bugzilla.open-bio.org/show_bug.cgi?id=2390





------- Comment #10 from Biosql at hotmail.com  2007-11-05 16:49 EST -------
I'm using the DButils.py for now and it's working fine. 

Now, I've checked the uploading problem with the BioSQL database and it seems
to me that It's getting stuck right at the beginning of the import with this
sql query : 

INSERT INTO biodatabase (name, authority, description) VALUES ('Swiss', NULL,
NULL)

So, I've tried to repeat the same sql query in manual mode and I'm getting this
error :

1205, 'Lock wait timeout exceeded; try restarting transaction'

This error seems to be related to Innodb transaction. 

Since, I'm very newb with InnoDB, cuz I've always been using MyISAM table I
really don't know what to do. Well, at least I'm gonna read on InnoDB table. 

Thanks !


-- 
Configure bugmail: http://bugzilla.open-bio.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.