아래에 언급된 오류가 발생합니다.
max_allowed_packet 지정된 구조에 대한 mysql 측의 max_allowed_packet 크기가 증가되었습니다.
증가에도 불구하고 해당 오류가 발생합니다.
다른 실수에 대해서는 어떻게 해야 할지 모르겠습니다.
지정된 오류 이후 mysqld를 다시 시작하면 오류가 수정되지만 며칠 후에 다시 발생합니다.
여러분의 지원을 바랍니다.
> Server Error
>
> The server has encountered an error. Please excuse the inconvenience.
>
> **Error Message Error filling report**
>
> **Error Trace** com.jaspersoft.jasperserver.api.JSException: Error filling
> report at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1266)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745) Caused by:
> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for: VHSingleTractors. at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> ... 11 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet
> for query is too large (3842 > 1024). You can change this value on the
> server by setting the max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> ... 17 more
>
> **Error Message** net.sf.jasperreports.engine.JRException: Error executing
> SQL statement for: VHSingleTractors.
>
> **Error Trace** net.sf.jasperreports.engine.JRException: Error executing
> SQL statement for: VHSingleTractors. at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745) Caused by:
> com.mysql.jdbc.PacketTooBigException: Packet for query is too large
> (3842 > 1024). You can change this value on the server by setting the
> max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> ... 17 more
>
> **Error Message** com.mysql.jdbc.PacketTooBigException: Packet for query
> is too large (3842 > 1024). You can change this value on the server by
> setting the max_allowed_packet' variable.
>
> **Error Trace** com.mysql.jdbc.PacketTooBigException: Packet for query is
> too large (3842 > 1024). You can change this value on the server by
> setting the max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)