I'm trying to use --stream option and it throw error on my server

[jorismulliez]

Hello,

I'm using this package to load snaphots.
I create snaphots with --compress option.

On my local environment (sail), I'm able to load my snapshot in "stream" mode with success :

./vendor/bin/sail artisan snapshot:load 2024-01-19_19-48-35-production-db --stream
Snapshot `2024-01-19_19-48-35-production-db` loaded!

But on my production server there is an error :

php artisan snapshot:load 2024-01-19_19-48-35-production-db --stream

In Connection.php line 801:
                                                                                                                                            
  SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fet  
  chAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_  
  ATTR_USE_BUFFERED_QUERY attribute. (Connection: mysql, SQL: /*!50717 DEALLOCATE PREPARE s */;)                                            
                                                                                                                                            

In Connection.php line 629:
                                                                                                                                            
  SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fet  
  chAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_  
  ATTR_USE_BUFFERED_QUERY attribute.      

I tried to add corresponding option to the config/database.php file :

...
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true
            ]) : [],
...

But it has no effects.

I did a little test with a snapshot file containing only a "select" query, and the "--stream" option work on the server.

What can I do to solve this issue ?

Thanks for your help !