web stats
max_allowed_packet - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-28-2015, 11:44 AM
johnjohn johnjohn is offline
OBX.1 Kenobi
 
Join Date: Aug 2014
Posts: 31
johnjohn is on a distinguished road
Default max_allowed_packet

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,
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 07:05 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation