Hi Caleb It looks like you might be hitting the MySQL TEXT field size limit of 2^16 bytes (65536). Altering the column type should solve this, to MEDIUMTEXT or LONGTEXT. You would have to do this manually. Alternatively you could look at using a database that doesn't have this limitation for TEXT fields (PostgreSQL I believe has an unlimited TEXT field length). If you do want to continue with MySQL then please let us know, and we could look at modifying the MySQL field type used for this table column. Regards Steve -----Original Message----- From: Caleb Derven [mailto:[email protected]] Sent: 19 April 2010 16:34 To: [email protected] Subject: [Fedora-commons-users] StorageDeviceException errors
Hello All - I am brand new to Fedora and in setting up a test instance have been consistently encountering errors related to StorageDeviceException. We've been trying to ingest base64-encoded objects in archival format (exported from another production instance running here) and with large objects (2MB +) the following error occurs: In the client the error appears as: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of ivrla:2277 In fedora.log: ERROR in fedora.log: ERROR 2010-04-19 15:46:30.520 [http-8080-2] (DefaultDOManager) Error updating FieldSearch index . Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'dcRelation' at row 1 There is nothing in the mysql error logs; in mysql.log I can see iteration through the dcRelation tags until the point when the process fails. The files I've been trying to ingest have multiple (2000+) dcRelation tags. However, when I arbitrarily reduce the number of dcRelation tags in the objects from the 2000 mark to around 350, the objects are successfully ingested (ingests with anything over 350 are typically failing). In the MySQL database the dcRelation field in the doFields table does have a data type of TEXT. Would altering the column datatype fix this issue? Any help or suggestions would be much appreciated. Best Regards, Caleb Caleb Derven Systems Librarian James Joyce Library University College Dublin Belfield Dublin 4 tel: +353-1-7167637 e-mail: <mailto:[email protected]> [email protected]
------------------------------------------------------------------------------
_______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
