sail artisan schema:dump... 'Unknown table 'COLUMN_STATISTICS' in information_schema'

[wemersonrv]

• Sail Version: ^1.0.1
• Laravel Version: 8.62.0
• PHP Version: 8.62.0
• OS: macOS BigSur 11.5

Description:

When run sail artisan schema:dump gives me the following error:

% sail artisan schema:dump
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'meuseventos' AND TABLE_NAME = 'events';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

   Symfony\Component\Process\Exception\ProcessFailedException 

  The command "mysqldump  --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --skip-add-locks --skip-comments --skip-set-charset --tz-utc "${:LARAVEL_LOAD_DATABASE}" --routines --result-file="${:LARAVEL_LOAD_PATH}" --no-data" failed.

Exit Code: 2(Misuse of shell builtins)

Working directory: /var/www/html

Output:
================


Error Output:
================
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'meuseventos' AND TABLE_NAME = 'events';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

  at vendor/symfony/process/Process.php:270
    266▕      */
    267▕     public function mustRun(callable $callback = null, array $env = []): self
    268▕     {
    269▕         if (0 !== $this->run($callback, $env)) {
  ➜ 270▕             throw new ProcessFailedException($this);
    271▕         }
    272▕ 
    273▕         return $this;
    274▕     }

      +16 vendor frames 
  17  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

Steps To Reproduce:

1. Clone the github repository and start sail
2. run sail artisan schema:dump

My github repository: https://github.com/wemersonrv/sail-dump-issue

[saulens22]

Try looking into this: spatie/laravel-backup#92

[driesvints]

I can't reproduce this as I'm running into #250. I'll keep this open for now until we've solved #250

[driesvints]

After the fix for #250 I didn't manage to reproduce this and dumping the schema went okay for me. This is probably something specific to your use case so I'd kindly ask you to try a support channel:

• Laracasts Forums
• Laravel.io Forums
• StackOverflow
• Discord
• Larachat
• IRC
  Thanks.