Misuse of shell builtins error

[samehdoush]

laravel 9.48
laravel-backup: v[8.1.5]
php 8.1
Bare Metal server 4 core
cpanel [108.0.6] & CentOS v7.9.2009

$schedule->command("backup:run --only-db")->daily()->withoutOverlapping()

Backup failed because The dump process failed with a none successful exitcode. Exitcode ======== 2: Misuse of shell builtins  Output ====== <no output>  Error Output ============ mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)

ackup failed because: The dump process failed with a none successful exitcode.
Exitcode
========
2: Misuse of shell builtins

Output
======
<no output>

Error Output
============
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227

   'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
            'dump' => [
                'dump_binary_path' => '/usr/bin/' ,
                'use_single_transaction',
                'timeout' => 60 * 5, // 5 minute timeout
                // 'exclude_tables' => ['table1', 'table2'],
                // 'add_extra_option' => '--optionname=optionvalue', // for example '--column-statistics=0'
            ]
        ],

A month ago it was working fine only today it started like this?
Is there anything i can do?
It appears that this task has been blocked

[goellner]

are you using an AWS RDS database by any chance? have the same problem since a few days

[samehdoush]

no i am using vultr and i have another hosting on a2hosting
The issue is on both

[2acode]

Hi,
same here.
PHP 8.1.2
MySQL 8.0.31
Laravel 9.48.0
Laravel-Backup 8.1.6
Database: AWS LS database, Aruba VM with local database

After the update the problem occurred:
2: Misuse of shell builtins
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)

Thanks

[2acode]

Adding RELOAD privileges throws another error:
mysqldump: Couldn't execute 'FLUSH TABLES WITH READ LOCK'

At the moment the only solution I've found is to disable 'useSingleTransaction' in the database dump configuration.

[goellner]

could be related to this: #1635 (comment)

[samehdoush]

@goellner @2acode
The solution for my case was as follows:
Delete: use_single_transaction from database.php

   'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
            'dump' => [
                'dump_binary_path' => '/usr/bin/' ,
             //   'use_single_transaction', delete this 
                'timeout' => 60 * 5, // 5 minute timeout

            ]
        ],