Hi Stian,
I am still having a problem with this. Taverna 2.2 now stores the
provenance to my database. However, the table "Data" is not there, which
is the reason I am doing the whole thing. Taverna 2.1.2 saves all the
workflow inputs and outputs in it. I exported the schema for this table
and added it to your script, but the table remains empty after running
Taverna 2.2.
Regards
Dennis
On 02.09.2010 17:58, Stian Soiland-Reyes wrote:
On Wed, Aug 25, 2010 at 12:22, Dennis Neumann<[email protected]> wrote:
My database Version 5.1 runs on a Windows XP machine. The user has all
privileges granted. I create a database named T2Provenance manually and
run a workflow. The connection to the database works fine, since 13
tables are created, some of them with content. Specifically, the table
inlinestringreference contains the input values of the executed
workflow. In the terminal, I get the following error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key
was too long; max key length is 1000 bytes
It is true that some of the provenance table schema changed for 2.2.0.
I believe it is the primary key of the tables Collection and
PortBinding that fails, as their composite primary keys are too large
for mySQL.
These primary keys are not ideal, but these are transitionary tables
that we were planning to remove anyway.
I've tracked this as
http://www.mygrid.org.uk/dev/issues/browse/T2-1605 and committed a fix
which should make it to the nightly build and the next release.
As a workaround for Taverna 2.2 you can try to create the tables
yourself with a modified schema. I've attached the modified schema to
this email. To install it, do like this:
r...@ralph:~# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 105
Server version: 5.1.41-3ubuntu12.6 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database T2Provenance;
Query OK, 0 rows affected (0.00 sec)
mysql> create database T2Provenance;
Query OK, 1 row affected (0.00 sec)
mysql> use T2Provenance;
Database changed
mysql> \. /home/stain/Desktop/provenance-schema.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.21 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
mysql>
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
taverna-hackers mailing list
[email protected]
Web site: http://www.taverna.org.uk
Mailing lists: http://www.taverna.org.uk/about/contact-us/
Developers Guide: http://www.taverna.org.uk/developers/
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
taverna-hackers mailing list
[email protected]
Web site: http://www.taverna.org.uk
Mailing lists: http://www.taverna.org.uk/about/contact-us/
Developers Guide: http://www.taverna.org.uk/developers/
