need help with fpm and

Events happening in the community are now at Drupal community events on www.drupal.org.
jean84's picture

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.

perusio's picture

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_packet is 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.cnf reload mysqlor do it in the running instance with a SQL statement like:

SET max_allowed_packets = 32M

Do SHOW variables LIKE 'max_allowed_packet'.

thankyou i have it now :)

jean84's picture

thankyou i have it now :)

Nginx

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: