devgroup-ru / yii2-deferred-tasks

Yii2 extension for handling deferred tasks (background cron jobs)

yii2-deferred-tasks

This is an extension for yii2 framework for running deferred tasks in background from cron.

Tasks can be either yii console commands or system cli commands.

More details coming soon.

WARNING

Use of mysql persistent connect isn't recommended. Use at your own risk.

• MySQL “Gone Away” Error with Persistent PHP Connection
• Handling PDO Lost MySQL Connection Error

yii2-deferred-tasks's Issues

Long tasks lead to MySQL has gone away

How to catch the error:

1. Create very long task(more then connection timeout in mysql)
2. When task is done - deferred-tasks tries to update DeferredQueue record
3. MySQL has gone away and closed connection

How to fix:
Reopen connection to MySQL after task process exited.
In deep - before https://github.com/DevGroup-ru/yii2-deferred-tasks/blob/master/src/commands/DeferredController.php#L232 and https://github.com/DevGroup-ru/yii2-deferred-tasks/blob/master/src/commands/DeferredController.php#L251 we need to add something like:

Yii::$app->db->close();
Yii::$app->db->open();

This construction should be in separate function.

Also, please check if this error appears on persistent connections(see this issue on how to configure it). If it is so - check for persistent connection and don't reconnect.

Automatic HOME directory detection

On posix systems we can try to call posix_getpwuid:

php > var_dump(posix_getpwuid(posix_getuid()));
array(7) {
  'name' =>
  string(9) "bethrezen"
  'passwd' =>
  string(8) "********"
  'uid' =>
  int(501)
  'gid' =>
  int(20)
  'gecos' =>
  string(21) "Alexander Kozhevnikov"
  'dir' =>
  string(16) "/Users/bethrezen"
  'shell' =>
  string(8) "/bin/zsh"
}

Home directory is in dir.
Some additional checks like if we running posix OS or if dir is filled are needed too.
If we haven't set home directory with Yii::$app->params['deferred.env'] and it is determined with such method - use it.

runImmediateTask - add windows support

DeferredHelper::runImmediateTask needs windows support:

• get and handle exit code
• forward output (stderr, stdout)