Bug 5509 - Error retrieving data from database for id (Globus 4.0.4)
: Error retrieving data from database for id (Globus 4.0.4)
Status: RESOLVED FIXED
: RFT
RFT
: 4.0.3
: Sun Windows XP
: P3 normal
: ---
Assigned To:
:
:
:
:
  Show dependency treegraph
 
Reported: 2007-08-30 10:55 by
Modified: 2007-08-30 12:13 (History)


Attachments


Note

You need to log in before you can comment on or make changes to this bug.


Description From 2007-08-30 10:55:31
I tried to assign to version 4.0.4 but that wasn't available.

I have installed gt4.0.4-sun4u_sol_5.9-installer.tar

I've got the rft database running (with mysql Ver 14.12, and
mysql-connector-java-3.1.13-bin.jar) but accessing the rft database causes an
exception.

I've set the mysql database as shown at
http://www.globus.org/toolkit/docs/4.0/admin/docbook/ch10.html#s-rft-admin-mysql

But, trying the rft test as described at
http://www.globus.org/toolkit/docs/4.0/admin/docbook/quickstart.html#q-rft-configure

I get the following exception:

rft -h semantic -f transfer.xfr
Number of transfers in this request: 1
Subscribed for overall status
Termination time to set: 60 minutes
Exception in thread "main" Error during startup processing. Caused by AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode:
 faultString: java.rmi.RemoteException: Error in start; nested exception is:
        org.globus.transfer.reliable.service.database.RftDBException: Error
retrieving data from database for id:
 "1" [Caused by: Unknown type '16 in column 7 of 20 in binary-encoded
result set.]
 faultActor:
 faultNode:
 faultDetail:
        {http://xml.apache.org/axis/}stackTrace:java.rmi.RemoteException: Error
in start; nested exception is:
        org.globus.transfer.reliable.service.database.RftDBException: Error
retrieving data from database for id:
 "1" [Caused by: Unknown type '16 in column 7 of 20 in binary-encoded
result set.]
        at
org.globus.transfer.reliable.service.ReliableFileTransferImpl.start(ReliableFileTransferImpl.java:137)

Below is an extract of the mysql dump of the rftDatabase. Some data has been
sucessfully stored:

-- MySQL dump 10.10
-- Host: localhost    Database: rftDatabase
-- Server version    5.0.16-max

-- Table structure for table `factory`

CREATE TABLE `factory` (
  `total_transfers` float default NULL,
  `total_bytes` float default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Table structure for table `request`

CREATE TABLE `request` (
  `id` int(11) NOT NULL,
  `concurrency` int(11) default '1',
  `termination_time` float default NULL,
  `proxy_loc` varchar(500) default NULL,
  `username` varchar(200) default NULL,
  `started` bit(1) default '\0',
  `all_or_none` bit(1) default '\0',
  `maxattempts` int(11) default '1',
  `delegated_epr` varchar(1200) default NULL,
  `user_subject` varchar(500) default NULL,
  PRIMARY KEY  (`id`),
  KEY `request_tindex` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `request` VALUES
(1,1,1.18849e+12,'4fdef1e0-570b-11dc-8253-ff32994a1a2a','kingsnj','','\0',10,'<DelegatedEPR><ns1:Address
xmlns:ns1=\"http://schemas.xmlsoap.org/ws/2004/03/addressing\">https://132.146.233.12:8443/wsrf/services/DelegationService</ns1:Address><ns2:ReferenceProperties
xmlns:ns2=\"http://schemas.xmlsoap.org/ws/2004/03/addressing\"><ns1:DelegationKey
xmlns:ns1=\"http://www.globus.org/08/2004/delegationService\">4f524240-570b-11dc-8253-ff32994a1a2a</ns1:DelegationKey></ns2:ReferenceProperties><ns3:ReferenceParameters
xmlns:ns3=\"http://schemas.xmlsoap.org/ws/2004/03/addressing\"/></DelegatedEPR>\n','/O=Grid/OU=GlobusTest/OU=simpleCA-semantic.info.bt.co.uk/OU=info.bt.co.uk/CN=Nick');

-- Table structure for table `requestid`

CREATE TABLE `requestid` (
  `request_id` int(11) NOT NULL,
  PRIMARY KEY  (`request_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `restart`
--

CREATE TABLE `restart` (
  `transfer_id` int(11) NOT NULL default '0',
  `marker` varchar(500) default NULL,
  PRIMARY KEY  (`transfer_id`),
  KEY `restart_tindex` (`transfer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `transfer` (
  `id` int(11) NOT NULL,
  `request_id` int(11) NOT NULL,
  `source_url` varchar(500) NOT NULL,
  `dest_url` varchar(500) default NULL,
  `status` int(11) default '4',
  `attempts` int(11) default '0',
  `user_name` varchar(500) default NULL,
  `dcau` bit(1) default '\0',
  `parallel_streams` int(11) default '1',
  `tcp_buffer_size` int(11) default '0',
  `block_size` int(11) default '16000',
  `notpt` bit(1) default '\0',
  `binary_mode` bit(1) default '',
  `source_subject` varchar(500) default NULL,
  `dest_subject` varchar(500) default NULL,
  `retry_time` float default '0',
  `size` float default '0',
  `fault` varchar(1000) default NULL,
  `permissions` int(11) default NULL,
  `ignore_file_perm_errors` bit(1) default '\0',
  PRIMARY KEY  (`id`),
  KEY `transfer_tindex` (`request_id`,`attempts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


/*!40000 ALTER TABLE `transfer` DISABLE KEYS */;
LOCK TABLES `transfer` WRITE;
INSERT INTO `transfer` VALUES
(1,1,'gsiftp://semantic:2811/tmp/rftTest.tmp','gsiftp://semantic:2811/tmp/rftTest_Done.tmp',4,0,'null','',1,16000,16000,'\0','','null','null',0,0,NULL,NULL,'\0');
UNLOCK TABLES;

-- Table structure for table `transferid`

CREATE TABLE `transferid` (
  `transfer_id` int(11) NOT NULL,
  PRIMARY KEY  (`transfer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
------- Comment #1 From 2007-08-30 11:28:51 -------
This is resolved by replacing the older version of the connector with
mysql-connector-java-5.0.7-bin.jar
------- Comment #2 From 2007-08-30 12:13:16 -------
Thanks for both the report and resolution.  I've updated the RFT documentation
not to refer to version 3.1 specifically, but to point generically at
http://dev.mysql.com/downloads/connector/j/ for the latest connector version. 
I also added a note about the existence of this bug for older versions of
connector/j.