sqlite: &quot;php artisan db&quot; works but &quot;db:show&quot; fails. no such table: dbstat

Level 55

@bbenz check this one https://github.com/canonical/microk8s/pull/2966

maybe you need to update sqlite to have latest changes

Level 1

I think dbstat is enabled though. I am able to run SELECT * FROM dbstat when I open a sqlite3 database from the command line.

I ran the following command to see if it's enabled:

echo "PRAGMA compile_options;" | sqlite3 | grep -i dbstat

And ENABLE_DBSTAT_VTAB appeared in the output. Unless I'm missing something, I think this should be working? Does laravel/php use the system's sqlite or does it use some other built in sqlite engine?

Level 102

Can you try composer update to get the newest laravel version. Maybe there is a hot fix

Level 1

I tried that, but it's actually more broken on the most updated version. When I update from v9.29.0 to v9.34.0 the command php artisan db stops working too. I get the following output:

  ERROR  No host specified for this database connection.
  Use the [--read] and [--write] options to specify a read or write connection.

The flags --read and --write do not solve the problem.

php artisan db --read

   ErrorException

  Undefined array key "read"

  at vendor/laravel/framework/src/Illuminate/Database/Console/DbCommand.php:78
     74▕             $connection = (new ConfigurationUrlParser)->parseConfiguration($connection);
     75▕         }
     76▕
     77▕         if ($this->option('read')) {
  ➜  78▕             if (is_array($connection['read']['host'])) {
     79▕                 $connection['read']['host'] = $connection['read']['host'][0];
     80▕             }
     81▕
     82▕             $connection = array_merge($connection, $connection['read']);

      +15 vendor frames
  16  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

At least on v9.24.0 I can get the database to work. I'm on MacOS, if that's relevant.

Level 102

@bbenz Hm yeah that seems to be a new bug. But db:show works in the newest it seems

Level 102

Can you try giving it a fake host in the config?

'sqlite' => [
            'driver' => 'sqlite',
            'url' => env('DATABASE_URL'),
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
            'host' => 'a', //fake
        ],

Level 1

@Sinnbeck Interesting, that brings php artisan db back online but db:show is still not working in the newest version for me. I'm still getting the original error pertaining to dbstat.

Level 102

@bbenz That is indeed strange. It works for me on linux. Maybe another mac user can give it a shot?

Level 1

@Sinnbeck I just fired up a linux machine and set up my project there, it seems like none of these issues exist on v9.29 or v9.34 so I guess it's either a Mac issue or there's something strange going on with my setup.

Level 102

@bbenz Is it the same project you tested on or a new one?

Level 1

@Sinnbeck Same project