max_allowed_packet

mercredi 28 janvier 2015

I am using Mirth 3.0.1.7051 got an error of

[2015-01-28 14:38:25,970] ERROR (com.mirth.connect.donkey.server.channel.Channel:1 526): An error occurred in channel ccda_advocare_emr (285c5e1b-d912-410d-9f7d-1faad38ed696) while processing message ID 3232 from the source queue

java.lang.RuntimeException: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1446183 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

at com.mirth.connect.donkey.server.channel.Channel.ha ndleDestinationChainThrowable(Channel.java:1497)

at com.mirth.connect.donkey.server.channel.Channel.pr ocess(Channel.java:1424)

at com.mirth.connect.donkey.server.channel.Channel.pr ocessSourceQueue(Channel.java:1524)

at com.mirth.connect.donkey.server.channel.Channel.ru n(Channel.java:1511)

at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1446183 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. insertContent(JdbcDao.java:244)

at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. insertMessageContent(JdbcDao.java:172)

at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.executeTasks(BufferedDao.java:98)

at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:74)

at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:61)

at com.mirth.connect.donkey.server.channel.Destinatio nChain.call(DestinationChain.java:286)

at com.mirth.connect.donkey.server.channel.Channel.pr ocess(Channel.java:1422)

... 3 moreCaused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1446183 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3865)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:25 51)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2731)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2815)

at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375)

at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359)

at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. insertContent(JdbcDao.java:241)

... 9 more

I cannot find where I can change the max_allowed_packet. Can you point me to the right direction. Thanks,





max_allowed_packet

0 commentaires:

Enregistrer un commentaire