SET GLOBAL max_allowed_packet=16M;
:~ # 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,
David2009/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/