AnsweredAssumed Answered

JLAN with MySql OutofMemoryError with large files

Question asked by jacob.alvarez on Jun 13, 2008
Hi,

I want to use JLAN to store 1GB media files into a mysql database.

Files are written correcty, but when they are read an outOfMemory exception is throwed:


[FTP0] Returning ftp=/blob/super.dat, share=blob, path=\super.dat
[FTP0]  Error during transfer, org.alfresco.jlan.server.filesys.FileOfflineException: File data not available
[FTP0] Error status=550, msg=Invalid path /blob/super.dat
Exception in thread "DBLdr_RD_6" java.lang.OutOfMemoryError: Java heap space
   at com.mysql.jdbc.Buffer.getBytes(Buffer.java:198)
   at com.mysql.jdbc.Buffer.readLenByteArray(Buffer.java:318)
   at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1375)
   at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2369)
   at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:451)
   at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2076)
   at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1451)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1787)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3179)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1207)
   at org.alfresco.jlan.server.filesys.db.mysql.MySQLDBInterface.loadFileData(MySQLDBInterface.java:3316)
   at org.alfresco.jlan.server.filesys.db.DBFileLoader.loadFile(DBFileLoader.java:900)
   at org.alfresco.jlan.server.filesys.db.BackgroundLoadSave$ThreadWorker.run(BackgroundLoadSave.java:259)
   at java.lang.Thread.run(Unknown Source)

Does anybody knows how to fix this ??

Thanks !

Outcomes