|
Packet for query is too large - my.cnf doesn't fix
Hi all.
I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm running into this error:
"com.mysql.jdbc.PacketTooBigException: Packet for query is too large"
Before everyone jumps on me to check the archives...I've already changed the my.cnf to 16, 32, and 64M respectively. Neither worked. I changed the sizes, restarted the mysqld and same error occurs when trying to upload anything over 1mb via the upload applet in the opencms management console.
Any ideas? Am I missing something obvious right under my nose?
Thanks,
Brad
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
Some parts of this message have been removed.
Learn more about Nabble's security policy.
Could there be multiple instances of my.cnf?
Hi all.
I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm running into this
error:
"com.mysql.jdbc.PacketTooBigException: Packet for query is too large"
Before everyone jumps on me to check the archives...I've already changed the
my.cnf to 16, 32, and 64M respectively. Neither worked. I changed
the sizes, restarted the mysqld and same error occurs when trying to upload
anything over 1mb via the upload applet in the opencms management console.
Any ideas? Am I missing something obvious right under my nose?
Thanks,
Brad
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
I wondered about that but I didn't find any. I did a find / -name my.cnf as root. All it found was the one in /etc. On Wed, Jul 23, 2008 at 6:53 PM, Kim, Allan < jak009@...> wrote:
Could there be multiple instances of my.cnf?
Hi all.
I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm running into this
error:
"com.mysql.jdbc.PacketTooBigException: Packet for query is too large"
Before everyone jumps on me to check the archives...I've already changed the
my.cnf to 16, 32, and 64M respectively. Neither worked. I changed
the sizes, restarted the mysqld and same error occurs when trying to upload
anything over 1mb via the upload applet in the opencms management console.
Any ideas? Am I missing something obvious right under my nose?
Thanks,
Brad
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
-- I am the guardian standing at the gates and evil shall not pass, it will not cast it shadow on me and mine, and I will not fear it. -bclemmons
"Maj.Haywood:There is a war on. How is it you are heading west? Hawkeye: Well, we face to the north and, real sudden like, turn left." - Last of the Mohicans
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
Hi Brad,
i assume, you already checked that. But to be
sure.
Did you check the values of the server variables
(especially the max_allowed_packet) during runtime with a tool like MySQLFront
or MySQL-Administrator? Maybe your changes are somehow not taken over by
your DB server.
Regards
Kai
I wondered about that but I didn't find any. I did a find /
-name my.cnf as root. All it found was the one in /etc.
On Wed, Jul 23, 2008 at 6:53 PM, Kim, Allan < jak009@...> wrote:
Could there be
multiple instances of my.cnf?
Hi all.
I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm
running into this error:
"com.mysql.jdbc.PacketTooBigException: Packet
for query is too large"
Before everyone jumps on me to check the
archives...I've already changed the my.cnf to 16, 32, and 64M
respectively. Neither worked. I changed the sizes, restarted the
mysqld and same error occurs when trying to upload anything over 1mb via the
upload applet in the opencms management console.
Any ideas? Am I
missing something obvious right under my
nose?
Thanks,
Brad
_______________________________________________
This
mail is sent to you from the opencms-dev mailing list
To change your list
options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
-- I am the guardian standing at the gates and evil shall not
pass, it will not cast it shadow on me and mine, and I will not fear it.
-bclemmons "Maj.Haywood:There is a war on. How is it you are heading
west? Hawkeye: Well, we face to the north and, real sudden like, turn left."
- Last of the Mohicans _______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
Hi Brad,
> anything over 1mb via the upload applet in the opencms management console.
Please check if the error occurs also when you don't use the upload applet and use the simple HTTP-upload instead. You can adjust the upload-method in your preferences.
Best regards,
Uwe König
--
Uwe König < u.koenig@...>
--
ifu Hamburg - material flows and software
ifu Institut fuer Umweltinformatik Hamburg GmbH
Grosse Bergstrasse 219, 22767 Hamburg, Germany
Managing Director: Jan Hedemann, Commercial Register: Hamburg, HRB 52629
www.ifu.com - www.umberto.de - www.sabento.com - www.e-sankey.com
>>> e!Sankey - software for easy drawing of Sankey diagrams.
>>> Visit http://www.e-sankey.com_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
Actually, I checked the my.cnf manually and it shows the change (64M instead of 16M) for that variable. I also tried to change via MySQL-Administrator, but the option to change that value in the gui is grayed out and it appears to be defaulted to 1M which is frustrating since a cat or vi on the my.cnf shows 16M.
-brad On Thu, Jul 24, 2008 at 2:59 AM, Schliemann, Kai < K.Schliemann@...> wrote:
Hi Brad,
i assume, you already checked that. But to be
sure.
Did you check the values of the server variables
(especially the max_allowed_packet) during runtime with a tool like MySQLFront
or MySQL-Administrator? Maybe your changes are somehow not taken over by
your DB server.
Regards
Kai
Von: opencms-dev-bounces@...
[mailto:opencms-dev-bounces@...] Im Auftrag von Brad Clemmons
Jr
Gesendet: Donnerstag, 24. Juli 2008 01:17
An: The OpenCms
mailing list
Betreff: Re: [opencms-dev] Packet for query is too large
- my.cnf doesn't fix
I wondered about that but I didn't find any. I did a find /
-name my.cnf as root. All it found was the one in /etc.
On Wed, Jul 23, 2008 at 6:53 PM, Kim, Allan < jak009@...> wrote:
Could there be
multiple instances of my.cnf?
Hi all.
I'm running OpenCMS 7.0.4 with mysql 5 on Cent0S5 and I'm
running into this error:
"com.mysql.jdbc.PacketTooBigException: Packet
for query is too large"
Before everyone jumps on me to check the
archives...I've already changed the my.cnf to 16, 32, and 64M
respectively. Neither worked. I changed the sizes, restarted the
mysqld and same error occurs when trying to upload anything over 1mb via the
upload applet in the opencms management console.
Any ideas? Am I
missing something obvious right under my
nose?
Thanks,
Brad
_______________________________________________
This
mail is sent to you from the opencms-dev mailing list
To change your list
options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
-- I am the guardian standing at the gates and evil shall not
pass, it will not cast it shadow on me and mine, and I will not fear it.
-bclemmons "Maj.Haywood:There is a war on. How is it you are heading
west? Hawkeye: Well, we face to the north and, real sudden like, turn left."
- Last of the Mohicans
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
-- I am the guardian standing at the gates and evil shall not pass, it will not cast it shadow on me and mine, and I will not fear it. -bclemmons
"Maj.Haywood:There is a war on. How is it you are heading west? Hawkeye: Well, we face to the north and, real sudden like, turn left." - Last of the Mohicans
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
I didn't think to try the HTTP-upload. I will try that as well. Thanks -brad On Thu, Jul 24, 2008 at 3:09 AM, Uwe König < u.koenig@...> wrote:
Hi Brad,
> anything over 1mb via the upload applet in the opencms management console.
Please check if the error occurs also when you don't use the upload applet and use the simple HTTP-upload instead. You can adjust the upload-method in your preferences.
Best regards,
Uwe König
--
Uwe König <u.koenig@...>
--
ifu Hamburg - material flows and software
ifu Institut fuer Umweltinformatik Hamburg GmbH
Grosse Bergstrasse 219, 22767 Hamburg, Germany
Managing Director: Jan Hedemann, Commercial Register: Hamburg, HRB 52629
www.ifu.com - www.umberto.de - www.sabento.com - www.e-sankey.com
>>> e!Sankey - software for easy drawing of Sankey diagrams.
>>> Visit http://www.e-sankey.com
-- I am the guardian standing at the gates and evil shall not pass, it will not cast it shadow on me and mine, and I will not fear it. -bclemmons "Maj.Haywood:There is a war on. How is it you are heading west?
Hawkeye: Well, we face to the north and, real sudden like, turn left." - Last of the Mohicans
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
|
Re: Packet for query is too large - my.cnf doesn't fix
Well, I got it working. I ended up just ignoring the my.cnf and working the max_packet_size variable into the init script. Thanks for all the help guys. Still don't know why it's not taking the value from the my.cnf but it's at least working now.
-brad On Thu, Jul 24, 2008 at 1:49 PM, Brad Clemmons Jr < brad.clemmons@...> wrote:
I didn't think to try the HTTP-upload. I will try that as well. Thanks -bradOn Thu, Jul 24, 2008 at 3:09 AM, Uwe König < u.koenig@...> wrote:
Hi Brad,
> anything over 1mb via the upload applet in the opencms management console.
Please check if the error occurs also when you don't use the upload applet and use the simple HTTP-upload instead. You can adjust the upload-method in your preferences.
Best regards,
Uwe König
--
Uwe König <u.koenig@...>
--
ifu Hamburg - material flows and software
ifu Institut fuer Umweltinformatik Hamburg GmbH
Grosse Bergstrasse 219, 22767 Hamburg, Germany
Managing Director: Jan Hedemann, Commercial Register: Hamburg, HRB 52629
www.ifu.com - www.umberto.de - www.sabento.com - www.e-sankey.com
>>> e!Sankey - software for easy drawing of Sankey diagrams.
>>> Visit http://www.e-sankey.com
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
