Export FromQuery not queued correctly with database connection

[arthurshlain]

Hi there.

With QUEUE_CONNECTION=sync in my .env file the both headings() and map() methods of my export class was called successful.

But when I use QUEUE_CONNECTION=database the result .xlsx file contains just ids in first column.

There is no failed jobs in database.

( new BillsExport( $village_id, $from, $to ) )
            ->store( 'public/' . $filePath )
            ->chain( [
                new NotifyUserOfCompletedExport( request()->user(), url( 'storage/' . $filePath ) ),
            ] );

My export class:

class BillsExport implements FromQuery, ShouldQueue, WithHeadings, WithMapping, ShouldAutoSize {

    use Exportable;

    public  $village_id = 0;
    public  $from = null;
    public  $to = null;

    public function __construct( $village_id, $from = null, $to = null ) {

        TelegramBot::sendMessage('BillExport __construct() called');

        $this->village_id = $village_id;
        $this->from       = $from;
        $this->to         = $to;
    }

    public function failed( Throwable $exception ): void {
        TelegramBot::sendMessage( 'BillsExport exception: ' . $exception->getMessage() );
    }

    public function query() {

        $from = $this->from;
        $to = $this->to;

        TelegramBot::sendMessage('BillExport query() called');

        return Bill::query()

                   ->with('user')

                   ->whereVillageId( $this->village_id )

                   ->when( $from !== null, function ( $q ) use ( $from ) {
                       return $q->where( 'date', '>=', $from );
                   } )

                   ->when( $to !== null, function ( $q ) use ( $to ) {
                       return $q->where( 'date', '<=', $to );
                   } );
    }

    public function headings(): array {

        TelegramBot::sendMessage('BillExport headings() called');

        return [
            '#',
            'Owner',
            'Plot',
            'Amount',
            'Date',
        ];
    }

    public function map( $bill ): array {

        TelegramBot::sendMessage('BillExport map() called');

        return [
            $bill->number,
            $bill->user->fullName,
            $bill->user->plotsCommaSeparated(),
            $bill->amount_total,
            $bill->date
        ];
    }

}

My supervisor conf file:

[program:app-worker]
process_name=%(program_name)s_%(process_num)02d
command=php /var/www/app.domain/artisan queue:work --queue=default --sleep=15 --tries=3
autostart=true
autorestart=true
user=user
numprocs=1
redirect_stderr=true
stdout_logfile=/var/www/app.domain/worker.log
stopwaitsecs=15

Result with QUEUE_CONNECTION=database

BillExport __construct() called
BillExport query() called

Result with QUEUE_CONNECTION=sync

BillExport __construct() called
BillExport query() called
BillExport headings() called
BillExport query() called
BillExport map() called
BillExport map() called
BillExport map() called
BillExport map() called

What could be the problem?

[arthurshlain]

Solved by sudo supervisorctl reload