On Thu, Mar 25, 2010 at 21:32, Jeffrey L. Tilson <[email protected]> wrote: > 2) Today I had the InnoDB engine installed. I went ahead and had the > tables recreated and manually altered them to use InnoDB with the > following syntax. > >> ALTER TABLE t1 ENGINE = InnoDB; > > I reran the test but got the same type of error.
Uhm.. that was not it, then! >> mysql> select queueEntry_id from Job; >> +---------------+ >> | queueEntry_id | >> +---------------+ >> | 1 | >> | 2 | >> | 3 | >> | 4 | >> | 5 | >> | 6 | >> | 7 | >> +---------------+ >> 7 rows in set (0.00 sec) >> >> mysql> select * from QueueEntry; >> +----+--------------------------------------+ >> | id | queue_id | >> +----+--------------------------------------+ >> | 2 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> | 3 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> | 4 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> | 5 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> | 6 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> | 7 | 42664a50-5b88-4bb5-9ead-40a0cf1cdd9c | >> +----+--------------------------------------+ >> 6 rows in set (0.00 sec) If I remember correctly, the job is *supposed* to be removed from QueueEntry once it is finished..? The question is why it is not also cleared from Job. When you upgraded, did you copy over the old database, or did Taverna Remote Execution Service create it from scratch? If you do create it from scratch, does the table declaration look the same..? (I can't see why not) So all you changed was to upgrade the mySQL installation, and use a new mysql-jdbc JAR? Before this never happened? Perhaps there is a Hibernate dialect difference for the new MySQL, but I doubt that could be it. I would have to look at the code, this is a while ago for me! -- Stian Soiland-Reyes, myGrid team School of Computer Science The University of Manchester ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ taverna-hackers mailing list [email protected] Web site: http://www.taverna.org.uk Mailing lists: http://www.taverna.org.uk/taverna-mailing-lists/ Developers Guide: http://www.mygrid.org.uk/tools/developer-information
