search

alphaville / jaqpot3

A brand new version of jaqpot - fully OpenTox API (1.2) compliant (see http://opentox.ntua.gr ) - lots of new features
http://opentox.ntua.gr
2 stars 1 forks source link

255 is too short for error messages #10

Closed alphaville closed 13 years ago

alphaville commented 13 years ago

Got the following exception...

SEVERE: null org.opentox.toxotis.database.exception.DbException: failed to execute statement at org.opentox.toxotis.database.engine.error.AddErrorReport.write(AddErrorReport.java:39) at org.opentox.jaqpot3.www.services.RunnableTaskService.updateFailedTask(RunnableTaskService.java:45) at org.opentox.jaqpot3.www.services.TrainingService.run(TrainingService.java:121) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'message' at row 1 at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.java:743) at org.opentox.toxotis.database.engine.error.AddErrorReport.write(AddErrorReport.java:30) ... 8 more

In this case the task cannot be updated to 'error/failed' and appears to be running indefinitely.

alphaville commented 13 years ago

Ok. Converted that to TEXT.