ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

From Chris , 3 Years ago, written in Plain Text.
Embed
  1. ./lnms migrate -vvv
  2. SQL[select `config_name`, `config_value` from `config` [] 0.27ms]
  3.  
  4. SQL[select * from `graph_types` [] 0.25ms]
  5.  
  6. **************************************
  7. *     Application In Production!     *
  8. **************************************
  9.  
  10.  Do you really wish to run this command? (yes/no) [no]:
  11.  > y
  12.  
  13. SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 145.61ms]
  14.  
  15. SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 0.55ms]
  16.  
  17. SQL[select `migration` from `migrations` order by `batch` asc, `migration` asc [] 42.25ms]
  18.  
  19. SQL[select `migration` from `migrations` order by `batch` asc, `migration` asc [] 0.38ms]
  20.  
  21. SQL[select max(`batch`) as aggregate from `migrations` [] 0.45ms]
  22.  
  23. Migrating: 2021_10_03_164200_update_hrsystem_table
  24. There is no column with name 'hrsystemnumusers' on table 'hrSystem'. {"exception":"[object] (Doctrine\\DBAL\\Schema\\SchemaException(code: 30): There is no column with name 'hrsystemnumusers' on table 'hrSystem'. at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86)"}
  25.  
  26. In SchemaException.php line 86:
  27.  
  28.   [Doctrine\DBAL\Schema\SchemaException (30)]
  29.   There is no column with name 'hrsystemnumusers' on table 'hrSystem'.
  30.  
  31. Exception trace:
  32.   at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86
  33.  Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist() at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:711
  34.  Doctrine\DBAL\Schema\Table->getColumn() at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:342
  35.  Doctrine\DBAL\Schema\Table->changeColumn() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:110
  36.  Illuminate\Database\Schema\Grammars\ChangeColumn::getDoctrineColumn() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:80
  37.  Illuminate\Database\Schema\Grammars\ChangeColumn::getTableWithColumnChanges() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:64
  38.  Illuminate\Database\Schema\Grammars\ChangeColumn::getChangedDiff() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:41
  39.  Illuminate\Database\Schema\Grammars\ChangeColumn::compile() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php:83
  40.  Illuminate\Database\Schema\Grammars\Grammar->compileChange() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:135
  41.  Illuminate\Database\Schema\Blueprint->toSql() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:108
  42.  Illuminate\Database\Schema\Blueprint->build() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:365
  43.  Illuminate\Database\Schema\Builder->build() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:212
  44.  Illuminate\Database\Schema\Builder->table() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
  45.  Illuminate\Support\Facades\Facade::__callStatic() at /opt/librenms/database/migrations/2021_10_03_164200_update_hrsystem_table.php:20
  46.  UpdateHrSystemTable->up() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:394
  47.  Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:403
  48.  Illuminate\Database\Migrations\Migrator->runMigration() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:202
  49.  Illuminate\Database\Migrations\Migrator->runUp() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:167
  50.  Illuminate\Database\Migrations\Migrator->runPending() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:112
  51.  Illuminate\Database\Migrations\Migrator->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:85
  52.  Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:585
  53.  Illuminate\Database\Migrations\Migrator->usingConnection() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:94
  54.  Illuminate\Database\Console\Migrations\MigrateCommand->handle() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
  55.  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php:40
  56.  Illuminate\Container\Util::unwrapIfClosure() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
  57.  Illuminate\Container\BoundMethod::callBoundMethod() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
  58.  Illuminate\Container\BoundMethod::call() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php:653
  59.  Illuminate\Container\Container->call() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php:136
  60.  Illuminate\Console\Command->execute() at /opt/librenms/vendor/symfony/console/Command/Command.php:299
  61.  Symfony\Component\Console\Command\Command->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php:121
  62.  Illuminate\Console\Command->run() at /opt/librenms/vendor/symfony/console/Application.php:978
  63.  Symfony\Component\Console\Application->doRunCommand() at /opt/librenms/vendor/symfony/console/Application.php:295
  64.  Symfony\Component\Console\Application->doRun() at /opt/librenms/vendor/symfony/console/Application.php:167
  65.  Symfony\Component\Console\Application->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Application.php:94
  66.  Illuminate\Console\Application->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:129
  67.  Illuminate\Foundation\Console\Kernel->handle() at /opt/librenms/app/Console/Kernel.php:72
  68.  App\Console\Kernel->handle() at /opt/librenms/lnms:40
captcha