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

bugzilla-daemon at portal.open-bio.org bugzilla-daemon at portal.open-bio.org
Mon Nov 5 21:49:09 UTC 2007


------- 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,

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.

More information about the Biopython-dev mailing list