I have > 300 000 entities to generate aliases.
I executed drush pathauto:aliases-generate all all and in 4 hours I have:

In Process.php line 1330:

The process "/usr/local/bin/drush batch-process 38 --uri=http://xn----7sblvlgns.xn--p1ai --root=/DATA/home-sites/drupal_8/web" exceeded the timeout of 14400 seconds.

pathauto:aliases-generate [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-d|--debug] [-y|--yes] [--no] [--remote-host REMOTE-HOST] [--remote-user REMOTE-USER] [-r|--root ROOT] [-l|--uri URI] [--simulate] [--pipe] [-D|--define DEFINE] [--notify] [--xh-link XH-LINK] [--druplicon] [--] [] []

[warning] Error while sending QUERY packet. PID=16321 Statement.php:59
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
#0 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Statement.php(59): PDOStatement->execute(Array)
#1 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Connection.php(634): Drupal\Core\Database\Statement->execute(Array, Array)
#2 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(357): Drupal\Core\Database\Connection->query('INSERT INTO {ca...', Array, Array)
#3 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Query/Upsert.php(106): Drupal\Core\Database\Driver\mysql\Connection->query('INSERT INTO {ca...', Array, Array)
#4 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(273): Drupal\Core\Database\Query\Upsert->execute()
#5 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(205): Drupal\Core\Cache\DatabaseBacken in /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Connection.php on line 695

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
#0 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Statement.php(59): PDOStatement->execute(Array)
#1 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Connection.php(634): Drupal\Core\Database\Statement->execute(Array, Array)
#2 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(357): Drupal\Core\Database\Connection->query('INSERT INTO {ca...', Array, Array)
#3 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Query/Upsert.php(106): Drupal\Core\Database\Driver\mysql\Connection->query('INSERT INTO {ca...', Array, Array)
#4 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(273): Drupal\Core\Database\Query\Upsert->execute()
#5 /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(205): Drupal\Core\Cache\DatabaseBacken in /DATA/home-sites/drupal_8/web/core/lib/Drupal/Core/Database/Connection.php on line 695

I think it is occured because of Drush.php:

    /**
     * Number of seconds before timeout for subprocesses. Can be customized via setTimeout() method.
     *
     * @var int
     */
    const TIMEOUT = 14400;

That could I do?

Comments

super_romeo created an issue.

ushma’s picture

i am getting the similar error. were you able to fix this?

elokudzo’s picture

Hello,
Anyone got the solution for this issue? thanks