I have nginx and fpm installed
i try to run a drush update:
drush pm-update
Refreshing update status information ...
PHP Warning: Got a packet bigger than 'max_allowed_packet' bytes
query: INSERT INTO watchdog
(uid, type, message, variables, severity, link, location, referer, hostname, timestamp)
VALUES
(0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1569189:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_update SET data = 'a:85:{s:3:\"acl\";a:10:{s:5:\"title\";s:3:\"ACL\";s:10:\"short_name\";s:3:\"acl\";s:10:\"dc:creator\";s:6:\"salvis\";s:11:\"api_version\";s:3:\"6.x\";s:17:\"recommended_major\";s:1:\"1\";s:16:\"supported_majors\";s:1:\"1\";s:13:\"default_major\";s:1 in /usr/local/nginx/html/includes/database.mysqli.inc on line 135
PHP Stack trace:
PHP 1. {main}() /var/www/drush/drush.php:0
PHP 2. drush_main() /var/www/drush/drush.php:41
PHP 3. drush_dispatch() /var/www/drush/drush.php:101
PHP 4. call_user_func_array() /var/www/drush/includes/command.inc:204
PHP 5. drush_command() /var/www/drush/includes/command.inc:0
PHP 6. call_user_func_array() /var/www/drush/includes/command.inc:721
PHP 7. drush_invoke() /var/www/drush/includes/command.inc:0
PHP 8. drush_invoke_args() /var/www/drush/includes/command.inc:58
PHP 9. call_user_func_array() /var/www/drush/includes/command.inc:120
PHP 10. drush_pm_update() /var/www/drush/includes/command.inc:0
PHP 11. call_user_func_array() /var/www/drush/commands/pm/pm.drush.inc:1539
PHP 12. drush_invoke() /var/www/drush/commands/pm/pm.drush.inc:0
PHP 13. drush_invoke_args() /var/www/drush/includes/command.inc:58
PHP 14. call_user_func_array() /var/www/drush/includes/command.inc:120
PHP 15. drush_pm_updatecode() /var/www/drush/includes/command.inc:0
PHP 16. _pm_get_update_info() /var/www/drush/commands/pm/updatecode.pm.inc:26
PHP 17. _pm_refresh() /var/www/drush/commands/pm/update_info/drupal_6.inc:58
PHP 18. update_refresh() /var/www/drush/commands/pm/update_info/drupal_6.inc:46
PHP 19. _update_refresh() /usr/local/nginx/html/modules/update/update.module:383
PHP 20. _update_cache_set() /usr/local/nginx/html/modules/update/update.fetch.inc:81
PHP 21. db_query() /usr/local/nginx/html/modules/update/update.module:554
PHP 22. _db_query() /usr/local/nginx/html/includes/database.mysql-common.inc:42
PHP 23. trigger_error() /usr/local/nginx/html/includes/database.mysqli.inc:135
PHP 24. drupal_error_handler() /usr/local/nginx/html/includes/common.inc:0
PHP 25. watchdog() /usr/local/nginx/html/includes/common.inc:663
PHP 26. module_invoke() /usr/local/nginx/html/includes/bootstrap.inc:966
PHP 27. call_user_func_array() /usr/local/nginx/html/includes/module.inc:462
PHP 28. dblog_watchdog() /usr/local/nginx/html/includes/module.inc:0
PHP 29. db_query() /usr/local/nginx/html/modules/dblog/dblog.module:147
PHP 30. _db_query() /usr/local/nginx/html/includes/database.mysql-common.inc:42
PHP 31. trigger_error() /usr/local/nginx/html/includes/database.mysqli.inc:135
my php info looks like this:
Configuration File (php.ini) Path /etc/php5/fpm
Loaded Configuration File /etc/php5/fpm/php.ini
Scan this dir for additional .ini files /etc/php5/fpm/conf.d
Additional .ini files parsed /etc/php5/fpm/conf.d/apc.ini, /etc/php5/fpm/conf.d/curl.ini, /etc/php5/fpm/conf.d/gd.ini, /etc/php5/fpm/conf.d/mcrypt.ini, /etc/php5/fpm/conf.d/mysql.ini, /etc/php5/fpm/conf.d/mysqli.ini, /etc/php5/fpm/conf.d/pdo.ini, /etc/php5/fpm/conf.d/pdo_mysql.ini, /etc/php5/fpm/conf.d/suhosin.ini, /etc/php5/fpm/conf.d/xdebug.ini
So i addet to
/etc/php5/fpm/conf.d/mysql.ini, and /etc/php5/fpm/conf.d/mysqli.ini,
[mysql]
max_allowed_packet=32M
[mysqld]
max_allowed_packet=16M
restart nginx
but no change seems not even to be parsed as there is no change in the php info
Comments
There's no need to do a nginx restart.
With Nginx the app (drupal) is always separated from the server. So changes done in the PHP backend are not of interest to Nginx. Even if you change the type of socket UNIX to TCP or vice-versa, you can reflect that with a mere reload.
Note that one of the obsessions that Nginx developers have is zero donwtime when upgrading/altering the running instance.
The
max_allowed_packetis a MySQL internal thing. I don't think you can set it from PHP (neither mysql or mysqli have such a runtime configuration parameter).So make the alterations in the
/etc/mysql/my.cnfreloadmysqlor do it in the running instance with a SQL statement like:SET max_allowed_packets = 32MDo
SHOW variables LIKE 'max_allowed_packet'.thankyou i have it now :)
thankyou i have it now :)