Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
Hi everybody: I have OTRS 2.4.5 on a SuSE. The error message pops out when trying to install the FAQ module. Ive set max_allowed_packet = 32M on /etc/my.cnf Its still pulling the same error. Any ideas? Adrián Fernández Leiro Departamento de Sistemas INVERAVANTE Avda. Linares Rivas 1, Bajo 15005 LA CORUÑA-ESPAÑA Tel. 981 25 74 81 / 981 12 62 29 Fax. 981 25 18 86
Hi,
Did you restart your mysql service after that modification?
What does OTRS state when you go into the support assessment page?
Regards,
David
2009/10/27 Adrián Fernández Leiro
Hi everybody:
I have OTRS 2.4.5 on a SuSE.
The error message pops out when trying to install the FAQ module.
I’ve set max_allowed_packet = 32M on /etc/my.cnf
It’s still pulling the same error.
Any ideas?
*Adrián Fernández Leiro*
*Departamento de Sistemas*
*INVERAVANTE*
*Avda. Linares Rivas 1, Bajo*
*15005 LA CORUÑA-ESPAÑA*
*Tel. 981 25 74 81 / 981 12 62 29*
*Fax. 981 25 18 86*
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Yes, rcmysql restart.
It says Check "max_allowed_packet" setting. "max_allowed_packet" should be
higher then 7 MB (it's 0 MB).
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
long_query_time=1
log-slow-queries=/var/log/mysql/mysql-slow.log
De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de
David Holder
Enviado el: martes, 27 de octubre de 2009 11:07
Para: User questions and discussions about OTRS.
Asunto: Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes,
SQL: 'INSERT INTO web_uploa
Hi,
Did you restart your mysql service after that modification?
What does OTRS state when you go into the support assessment page?
Regards,
David
2009/10/27 Adrián Fernández Leiro
It is possibile that is passed as command line argument a different value ?
ps auxwww | grep mysql ?
2009/10/27 Adrián Fernández Leiro
Yes, “rcmysql restart”.
It says Check "max_allowed_packet" setting. "max_allowed_packet" should be higher then 7 MB (it's 0 MB).
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
long_query_time=1
log-slow-queries=/var/log/mysql/mysql-slow.log
*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *David Holder *Enviado el:* martes, 27 de octubre de 2009 11:07 *Para:* User questions and discussions about OTRS. *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
Hi,
Did you restart your mysql service after that modification?
What does OTRS state when you go into the support assessment page?
Regards,
David
2009/10/27 Adrián Fernández Leiro
Hi everybody:
I have OTRS 2.4.5 on a SuSE.
The error message pops out when trying to install the FAQ module.
I’ve set max_allowed_packet = 32M on /etc/my.cnf
It’s still pulling the same error.
Any ideas?
*Adrián Fernández Leiro*
*Departamento de Sistemas*
*INVERAVANTE*
*Avda. Linares Rivas 1, Bajo*
*15005 LA CORUÑA-ESPAÑA*
*Tel. 981 25 74 81 / 981 12 62 29*
*Fax. 981 25 18 86*
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
:~ # ps auxwww | grep mysql
root 27391 0.0 0.0 3024 724 pts/0 S+ 13:05 0:00 grep
mysql
root 28025 0.0 0.1 8040 1488 ? S Oct08 0:00 /bin/sh
/usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid
--socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 28069 0.0 2.3 137452 25148 ? Sl Oct08 9:13
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306
--socket=/var/lib/mysql/mysql.sock
De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de
Marco Vannini
Enviado el: martes, 27 de octubre de 2009 12:14
Para: User questions and discussions about OTRS.
Asunto: Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes,
SQL: 'INSERT INTO web_uploa
It is possibile that is passed as command line argument a different value
? ps auxwww | grep mysql ?
2009/10/27 Adrián Fernández Leiro
Try setting it runtime with
*SET GLOBAL max_allowed_packet=16M;*
*
*
*
*
2009/10/27 Adrián Fernández Leiro
:~ # ps auxwww | grep mysql
root 27391 0.0 0.0 3024 724 pts/0 S+ 13:05 0:00 grep mysql
root 28025 0.0 0.1 8040 1488 ? S Oct08 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 28069 0.0 2.3 137452 25148 ? Sl Oct08 9:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *Marco Vannini *Enviado el:* martes, 27 de octubre de 2009 12:14
*Para:* User questions and discussions about OTRS. *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
It is possibile that is passed as command line argument a different value ? ps auxwww | grep mysql ?
2009/10/27 Adrián Fernández Leiro
Yes, “rcmysql restart”.
It says Check "max_allowed_packet" setting. "max_allowed_packet" should be higher then 7 MB (it's 0 MB).
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
long_query_time=1
log-slow-queries=/var/log/mysql/mysql-slow.log
*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *David Holder *Enviado el:* martes, 27 de octubre de 2009 11:07 *Para:* User questions and discussions about OTRS. *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
Hi,
Did you restart your mysql service after that modification?
What does OTRS state when you go into the support assessment page?
Regards,
David
2009/10/27 Adrián Fernández Leiro
Hi everybody:
I have OTRS 2.4.5 on a SuSE.
The error message pops out when trying to install the FAQ module.
I’ve set max_allowed_packet = 32M on /etc/my.cnf
It’s still pulling the same error.
Any ideas?
*Adrián Fernández Leiro*
*Departamento de Sistemas*
*INVERAVANTE*
*Avda. Linares Rivas 1, Bajo*
*15005 LA CORUÑA-ESPAÑA*
*Tel. 981 25 74 81 / 981 12 62 29*
*Fax. 981 25 18 86*
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4547 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
or if it fails *SET GLOBAL max_allowed_packet=16*1024*1024;*
**
On Tue, Oct 27, 2009 at 2:17 PM, Marco Vannini
Try setting it runtime with
*SET GLOBAL max_allowed_packet=16M;*
*
*
*
*
2009/10/27 Adrián Fernández Leiro
:~ # ps auxwww | grep mysql
root 27391 0.0 0.0 3024 724 pts/0 S+ 13:05 0:00 grep mysql
root 28025 0.0 0.1 8040 1488 ? S Oct08 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 28069 0.0 2.3 137452 25148 ? Sl Oct08 9:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *Marco Vannini *Enviado el:* martes, 27 de octubre de 2009 12:14
*Para:* User questions and discussions about OTRS. *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
It is possibile that is passed as command line argument a different value ? ps auxwww | grep mysql ?
2009/10/27 Adrián Fernández Leiro
Yes, “rcmysql restart”.
It says Check "max_allowed_packet" setting. "max_allowed_packet" should be higher then 7 MB (it's 0 MB).
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 16M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
long_query_time=1
log-slow-queries=/var/log/mysql/mysql-slow.log
*De:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *En nombre de *David Holder *Enviado el:* martes, 27 de octubre de 2009 11:07 *Para:* User questions and discussions about OTRS. *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO web_uploa
Hi,
Did you restart your mysql service after that modification?
What does OTRS state when you go into the support assessment page?
Regards,
David
2009/10/27 Adrián Fernández Leiro
Hi everybody:
I have OTRS 2.4.5 on a SuSE.
The error message pops out when trying to install the FAQ module.
I’ve set max_allowed_packet = 32M on /etc/my.cnf
It’s still pulling the same error.
Any ideas?
*Adrián Fernández Leiro*
*Departamento de Sistemas*
*INVERAVANTE*
*Avda. Linares Rivas 1, Bajo*
*15005 LA CORUÑA-ESPAÑA*
*Tel. 981 25 74 81 / 981 12 62 29*
*Fax. 981 25 18 86*
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4547 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
It works with SET GLOBAL max_allowed_packet=16*1024*1024;, thanks!
De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de
Marco Vannini
Enviado el: martes, 27 de octubre de 2009 14:19
Para: User questions and discussions about OTRS.
Asunto: Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes,
SQL: 'INSERT INTO web_uploa
or if it fails SET GLOBAL max_allowed_packet=16*1024*1024;
On Tue, Oct 27, 2009 at 2:17 PM, Marco Vannini
participants (3)
-
Adrián Fernández Leiro -
David Holder -
Marco Vannini