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 <marco.vannini@gmail.com> wrote:
Try setting it runtime with
SET GLOBAL max_allowed_packet=16M;
2009/10/27 Adrián Fernández Leiro <aleiro@inveravante.com>
:~ # 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 <aleiro@inveravante.com>
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 <aleiro@inveravante.com>
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.
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.
---------------------------------------------------------------------
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) __________
---------------------------------------------------------------------
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