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
wrote:
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.
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
__________ Información de ESET NOD32 Antivirus, versión de la base de
firmas de virus 4546 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
http://www.eset.com
---------------------------------------------------------------------
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.
http://www.eset.com
---------------------------------------------------------------------
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.
http://www.eset.com
---------------------------------------------------------------------
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 4548 (20091027) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
http://www.eset.com
