Base table not found

[anime-kun32]

Version

latest version

What happened?

found this error on render adter deploing recently

Error & Logs

[stacktrace]
#0 /srv/vendor/laravel/framework/src/Illuminate/Database/Connection.php(565): PDO->prepare()
#1 /srv/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /srv/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /srv/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#4 /srv/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\\Database\\Connection->statement()
#5 /srv/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /srv/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#7 /srv/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->table()
#8 /srv/database/migrations/2023_02_10_145413_add_is_admin_and_preferences_to_users_table.php(51): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\\Database\\Migrations\\Migration@anonymous->down()
#10 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#12 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(407): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /srv/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#14 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\\Console\\View\\Components\\Task->render()
#15 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(407): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(330): Illuminate\\Database\\Migrations\\Migrator->runDown()
#17 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(381): Illuminate\\Database\\Migrations\\Migrator->rollbackMigrations()
#18 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(361): Illuminate\\Database\\Migrations\\Migrator->resetMigrations()
#19 /srv/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/ResetCommand.php(71): Illuminate\\Database\\Migrations\\Migrator->reset()
#20 /srv/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\\Database\\Console\\Migrations\\ResetCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#21 /srv/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/ResetCommand.php(63): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#22 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\ResetCommand->handle()
#23 /srv/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#24 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /srv/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\\Container\\BoundMethod::call()
#27 /srv/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#28 /srv/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#29 /srv/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#30 /srv/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\\Console\\Command->run()
#31 /srv/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\\Console\\Command->runCommand()
#32 /srv/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/RefreshCommand.php(113): Illuminate\\Console\\Command->call()
#33 /srv/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/RefreshCommand.php(59): Illuminate\\Database\\Console\\Migrations\\RefreshCommand->runReset()
#34 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\RefreshCommand->handle()
#35 /srv/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#36 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#37 /srv/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#38 /srv/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\\Container\\BoundMethod::call()
#39 /srv/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#40 /srv/vendor/symfony/console/Command/Command.php(318): Illuminate\\Console\\Command->execute()
#41 /srv/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#42 /srv/vendor/symfony/console/Application.php(1092): Illuminate\\Console\\Command->run()
#43 /srv/vendor/symfony/console/Application.php(341): Symfony\\Component\\Console\\Application->doRunCommand()
#44 /srv/vendor/symfony/console/Application.php(192): Symfony\\Component\\Console\\Application->doRun()
#45 /srv/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#46 /srv/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#47 {main}
"} 
In Connection.php line 825:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'auth.users' does  
  n't exist (Connection: mysql, SQL: alter table `users` drop `is_admin`)      
                                                                               
In Connection.php line 565:
                                                                               

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'auth.users' does  
  n't exist

Configuration

it's deployed on render and i use tidb for msql storage

Containerization

• Docker

Integration

No response

Additional information

No response

@Bubka

[Bubka]

Hi,

it's deployed on render

What is render?

[anime-kun32]

Hi,

it's deployed on render

What is render?

it is a cl
oud service that allows you to deploy application smiliar to verce

[Bubka]

Ok thx 👍🏻
It looks like a migration rollback command has been run, which is rather unexpected.
Did the app run correctly at first? Then the error appeared?

[anime-kun32]

yeah it ran correctly i modified database.php so that it uses ssl connection to mysql

[Bubka]

Did you rebuild the cache? If not, run php artisan optimize:clear via ssh from the /srv/ folder.

Also, What changes have you made to the database.php file?

[anime-kun32]

<?php

use Illuminate\Support\Str;

return [

    /*
    |--------------------------------------------------------------------------
    | Default Database Connection Name
    |--------------------------------------------------------------------------
    |
    | Here you may specify which of the database connections below you wish
    | to use as your default connection for database operations. This is
    | the connection which will be utilized unless another connection
    | is explicitly specified when you execute a query / statement.
    |
    */

    'default' => envUnlessEmpty('DB_CONNECTION', 'mysql'),

    /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Below are all of the database connections defined for your application.
    | An example configuration is provided for each database system which
    | is supported by Laravel. You're free to add / remove connections.
    |
    */

    'connections' => [

        'sqlite' => [
            'driver' => 'sqlite',
            'url' => env('DB_URL', env('DATABASE_URL')),
            'database' => envUnlessEmpty('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
        ],

        'mysql' => [
    'driver' => 'mysql',
    'url' => env('DB_URL', env('DATABASE_URL')),
    'host' => envUnlessEmpty('DB_HOST', '127.0.0.1'),
    'port' => envUnlessEmpty('DB_PORT', '3306'),
    'database' => envUnlessEmpty('DB_DATABASE', '2fauth'),
    'username' => envUnlessEmpty('DB_USERNAME', '2fauth'),
    'password' => env('DB_PASSWORD', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => env('DB_CHARSET', 'utf8mb4'),
    'collation' => env('DB_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('DB_SSL_CA', '/etc/ssl/certs/ca-certificates.crt'),
        PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,
    ]) : [],
],


        // Disabled until 
        // 'mariadb' => [
        //     'driver' => 'mariadb',
        //     'url' => env('DB_URL', env('DATABASE_URL')),
        //     'host' => envUnlessEmpty('DB_HOST', '127.0.0.1'),
        //     'port' => envUnlessEmpty('DB_PORT', '3306'),
        //     'database' => envUnlessEmpty('DB_DATABASE', '2fauth'),
        //     'username' => envUnlessEmpty('DB_USERNAME', '2fauth'),
        //     'password' => env('DB_PASSWORD', ''),
        //     'unix_socket' => env('DB_SOCKET', ''),
        //     'charset' => env('DB_CHARSET', 'utf8mb4'),
        //     'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
        //     'prefix' => '',
        //     'prefix_indexes' => true,
        //     'strict' => true,
        //     'engine' => null,
        //     'options' => extension_loaded('pdo_mysql') ? array_filter([
        //         PDO::MYSQL_ATTR_SSL_CA => envUnlessEmpty('MYSQL_ATTR_SSL_CA', null),
        //     ]) : [],
        // ],

        'pgsql' => [
            'driver' => 'pgsql',
            'url' => env('DB_URL', env('DATABASE_URL')),
            'host' => envUnlessEmpty('DB_HOST', '127.0.0.1'),
            'port' => envUnlessEmpty('DB_PORT', '5432'),
            'database' => envUnlessEmpty('DB_DATABASE', '2fauth'),
            'username' => envUnlessEmpty('DB_USERNAME', '2fauth'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            'search_path' => 'public',
            'sslmode' => 'prefer',
        ],

        'sqlsrv' => [
            'driver' => 'sqlsrv',
            'url' => env('DB_URL', env('DATABASE_URL')),
            'host' => envUnlessEmpty('DB_HOST', 'localhost'),
            'port' => envUnlessEmpty('DB_PORT', '1433'),
            'database' => envUnlessEmpty('DB_DATABASE', '2fauth'),
            'username' => envUnlessEmpty('DB_USERNAME', '2fauth'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => env('DB_CHARSET', 'utf8'),
            'prefix' => '',
            'prefix_indexes' => true,
            // 'encrypt' => env('DB_ENCRYPT', 'yes'),
            // 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'),
        ],

        'testing' => [
            'driver' => 'sqlite',
            'database' => ':memory:',
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
        ],

    ],

    /*
    |--------------------------------------------------------------------------
    | Migration Repository Table
    |--------------------------------------------------------------------------
    |
    | This table keeps track of all the migrations that have already run for
    | your application. Using this information, we can determine which of
    | the migrations on disk haven't actually been run on the database.
    |
    */

    'migrations' => [
        'table' => 'migrations',
        'update_date_on_publish' => true,
    ],

    /*
    |--------------------------------------------------------------------------
    | Redis Databases
    |--------------------------------------------------------------------------
    |
    | Redis is an open source, fast, and advanced key-value store that also
    | provides a richer body of commands than a typical key-value system
    | such as Memcached. You may define your connection settings here.
    |
    */

    'redis' => [

        'client' => env('REDIS_CLIENT', 'phpredis'),

        'options' => [
            'cluster' => env('REDIS_CLUSTER', 'redis'),
            'prefix' => env('REDIS_PREFIX', Str::slug(env('APP_NAME', 'laravel'), '_').'_database_'),
        ],

        'default' => [
            'url' => env('REDIS_URL'),
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'username' => env('REDIS_USERNAME'),
            'password' => env('REDIS_PASSWORD'),
            'port' => env('REDIS_PORT', '6379'),
            'database' => env('REDIS_DB', '0'),
        ],

        'cache' => [
            'url' => env('REDIS_URL'),
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'username' => env('REDIS_USERNAME'),
            'password' => env('REDIS_PASSWORD'),
            'port' => env('REDIS_PORT', '6379'),
            'database' => env('REDIS_CACHE_DB', '1'),
        ],

    ],

];

[Bubka]

Did you deploy on the render free tier? If so, the "no disk" restriction of the free plan is probably the cause of the error message.

The image's entrypoint script checks for the presence of a file on the disk at every start of the container. If the file is missing, it is considered a first run. In this case the entire database is wiped out and rebuilt. Since the free plan does not offer a persistent disk, the file is always missing.

The error message in your log refers to a rollback issue because the script executes a rollback of all migrations instead of deleting the tables. This is quite misleading, I will change that.

[anime-kun32]

Did you deploy on the render free tier? If so, the "no disk" restriction of the free plan is probably the cause of the error message.

The image's entrypoint script checks for the presence of a file on the disk at every start of the container. If the file is missing, it is considered a first run. In this case the entire database is wiped out and rebuilt. Since the free plan does not offer a persistent disk, the file is always missing.

The error message in your log refers to a rollback issue because the script executes a rollback of all migrations instead of deleting the tables. This is quite misleading, I will change that.

@Bubka I did deploy as free tier on render using dokcer but i didn't know that i would need to use a disk since it's already using sql connection