search

Kitware / CDash

An open source, web-based software testing server
http://www.cdash.org/
Other
218 stars 76 forks source link

Upgrade from 3.3 to 3.4.2 caused ERROR: column "testname" of relation "build2test" does not exist #2224

Closed vlb-sq closed 5 months ago

vlb-sq commented 6 months ago

Despite a successful migration after the upgrade, the following error arrised:

cdash_worker    | [2024-05-28 15:13:15] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "testname" of relation "build2test" does not exist
cdash_worker    | LINE 1: ...uildid", "outputid", "status", "details", "time", "testname"...
cdash_worker    |                                                              ^ (Connection: pgsql, SQL: insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values (0, 0, 14291, 11909593, passed, Completed, 0.185331, TestCore_Bug21166) returning "id") {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column \"testname\" of relation \"build2test\" does not exist
cdash_worker    | LINE 1: ...uildid\", \"outputid\", \"status\", \"details\", \"time\", \"testname\"...
cdash_worker    |                                                              ^ (Connection: pgsql, SQL: insert into \"build2test\" (\"timemean\", \"timestd\", \"buildid\", \"outputid\", \"status\", \"details\", \"time\", \"testname\") values (0, 0, 14291, 11909593, passed, Completed, 0.185331, TestCore_Bug21166) returning \"id\") at /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
cdash_worker    | [stacktrace]
cdash_worker    | #0 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback('insert into \"bu...', Array, Object(Closure))
cdash_worker    | #1 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\\Database\\Connection->run('insert into \"bu...', Array, Object(Closure))
cdash_worker    | #2 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(401): Illuminate\\Database\\Connection->select('insert into \"bu...', Array, false)
cdash_worker    | #3 /cdash/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/PostgresProcessor.php(24): Illuminate\\Database\\Connection->selectFromWriteConnection('insert into \"bu...', Array)
cdash_worker    | #4 /cdash/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3507): Illuminate\\Database\\Query\\Processors\\PostgresProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into \"bu...', Array, 'id')
cdash_worker    | #5 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1982): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id')
cdash_worker    | #6 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array)
cdash_worker    | #7 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)
cdash_worker    | #8 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder))
cdash_worker    | #9 /cdash/app/Utils/TestCreator.php(226): Illuminate\\Database\\Eloquent\\Model->save()
cdash_worker    | #10 /cdash/app/cdash/xml_handlers/testing_handler.php(178): App\\Utils\\TestCreator->create(Object(CDash\\Model\\Build))
cdash_worker    | #11 [internal function]: TestingHandler->endElement(Object(XMLParser), 'TEST')
cdash_worker    | #12 /cdash/app/cdash/include/ctestparser.php(302): xml_parse(Object(XMLParser), 'estAPI_C_Client...', false)
cdash_worker    | #13 /cdash/app/Jobs/ProcessSubmission.php(195): ctest_parse(Resource id #1454, 1, '6e5096ae569b161...')
cdash_worker    | #14 /cdash/app/Jobs/ProcessSubmission.php(131): App\\Jobs\\ProcessSubmission->doSubmit('inprogress/Star...', 1, 14291, '6e5096ae569b161...', true)
cdash_worker    | #15 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\ProcessSubmission->handle()
cdash_worker    | #16 /cdash/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
cdash_worker    | #17 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
cdash_worker    | #18 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
cdash_worker    | #19 /cdash/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
cdash_worker    | #20 /cdash/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call(Array)
cdash_worker    | #21 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #22 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #23 /cdash/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
cdash_worker    | #24 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\ProcessSubmission), false)
cdash_worker    | #25 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #26 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #27 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
cdash_worker    | #28 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #29 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)
cdash_worker    | #30 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()
cdash_worker    | #31 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process('database', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #32 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 'database', Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #33 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(137): Illuminate\\Queue\\Worker->daemon('database', 'default', Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #34 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(120): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'default')
cdash_worker    | #35 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
cdash_worker    | #36 /cdash/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
cdash_worker    | #37 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
cdash_worker    | #38 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
cdash_worker    | #39 /cdash/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
cdash_worker    | #40 /cdash/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call(Array)
cdash_worker    | #41 /cdash/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
cdash_worker    | #42 /cdash/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
cdash_worker    | #43 /cdash/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #44 /cdash/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #45 /cdash/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #46 /cdash/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #47 /cdash/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #48 {main}
cdash_worker    |
cdash_worker    | [previous exception] [object] (PDOException(code: 42703): SQLSTATE[42703]: Undefined column: 7 ERROR:  column \"testname\" of relation \"build2test\" does not exist
cdash_worker    | LINE 1: ...uildid\", \"outputid\", \"status\", \"details\", \"time\", \"testname\"...
cdash_worker    |                                                              ^ at /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428)
cdash_worker    | [stacktrace]
cdash_worker    | #0 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(428): PDOStatement->execute()
cdash_worker    | #1 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into \"bu...', Array)
cdash_worker    | #2 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback('insert into \"bu...', Array, Object(Closure))
cdash_worker    | #3 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\\Database\\Connection->run('insert into \"bu...', Array, Object(Closure))
cdash_worker    | #4 /cdash/vendor/laravel/framework/src/Illuminate/Database/Connection.php(401): Illuminate\\Database\\Connection->select('insert into \"bu...', Array, false)
cdash_worker    | #5 /cdash/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/PostgresProcessor.php(24): Illuminate\\Database\\Connection->selectFromWriteConnection('insert into \"bu...', Array)
cdash_worker    | #6 /cdash/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3507): Illuminate\\Database\\Query\\Processors\\PostgresProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into \"bu...', Array, 'id')
cdash_worker    | #7 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1982): Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id')
cdash_worker    | #8 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1333): Illuminate\\Database\\Eloquent\\Builder->__call('insertGetId', Array)
cdash_worker    | #9 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1298): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)
cdash_worker    | #10 /cdash/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1137): Illuminate\\Database\\Eloquent\\Model->performInsert(Object(Illuminate\\Database\\Eloquent\\Builder))
cdash_worker    | #11 /cdash/app/Utils/TestCreator.php(226): Illuminate\\Database\\Eloquent\\Model->save()
cdash_worker    | #12 /cdash/app/cdash/xml_handlers/testing_handler.php(178): App\\Utils\\TestCreator->create(Object(CDash\\Model\\Build))
cdash_worker    | #13 [internal function]: TestingHandler->endElement(Object(XMLParser), 'TEST')
cdash_worker    | #14 /cdash/app/cdash/include/ctestparser.php(302): xml_parse(Object(XMLParser), 'estAPI_C_Client...', false)
cdash_worker    | #15 /cdash/app/Jobs/ProcessSubmission.php(195): ctest_parse(Resource id #1454, 1, '6e5096ae569b161...')
cdash_worker    | #16 /cdash/app/Jobs/ProcessSubmission.php(131): App\\Jobs\\ProcessSubmission->doSubmit('inprogress/Star...', 1, 14291, '6e5096ae569b161...', true)
cdash_worker    | #17 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\ProcessSubmission->handle()
cdash_worker    | #18 /cdash/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
cdash_worker    | #19 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
cdash_worker    | #20 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
cdash_worker    | #21 /cdash/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
cdash_worker    | #22 /cdash/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call(Array)
cdash_worker    | #23 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #24 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #25 /cdash/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
cdash_worker    | #26 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\ProcessSubmission), false)
cdash_worker    | #27 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #28 /cdash/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #29 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
cdash_worker    | #30 /cdash/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\ProcessSubmission))
cdash_worker    | #31 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)
cdash_worker    | #32 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()
cdash_worker    | #33 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process('database', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #34 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), 'database', Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #35 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(137): Illuminate\\Queue\\Worker->daemon('database', 'default', Object(Illuminate\\Queue\\WorkerOptions))
cdash_worker    | #36 /cdash/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(120): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'default')
cdash_worker    | #37 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
cdash_worker    | #38 /cdash/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
cdash_worker    | #39 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
cdash_worker    | #40 /cdash/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
cdash_worker    | #41 /cdash/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
cdash_worker    | #42 /cdash/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call(Array)
cdash_worker    | #43 /cdash/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
cdash_worker    | #44 /cdash/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
cdash_worker    | #45 /cdash/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #46 /cdash/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #47 /cdash/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #48 /cdash/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #49 /cdash/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
cdash_worker    | #50 {main}
cdash_worker    | "}

I manually added the column via 

ALTER TABLE build2test
ADD COLUMN testname TEXT;

which fixed the error.

williamjallen commented 6 months ago

Do you still have the output (if any) from the migrations you ran during the upgrade? We've upgraded multiple large CDash instances to 3.4 without any problems. The most likely cause of the error you're seeing is the migration not finishing for whatever reason.

vlb-sq commented 6 months ago

here are some extra logs, not sure how relevant they are... Unfortunately I don't have more.

cdash  | =================================================================================
cdash  | Configuring production CDash installation...
cdash  | Enabling maintenance mode...
cdash  | 
cdash  |    INFO  Application is now in maintenance mode.  
cdash  | 
cdash  | Updating vendor dependencies...
cdash  | 
cdash  | up to date, audited 915 packages in 2s
cdash  | 
cdash  | 107 packages are looking for funding
cdash  |   run `npm fund` for details
cdash  | 
cdash  | 2 vulnerabilities (1 moderate, 1 high)
cdash  | 
cdash  | To address all issues (including breaking changes), run:
cdash  |   npm audit fix --force
cdash  | 
cdash  | Run `npm audit` for details.
cdash  | Installing dependencies from lock file
cdash  | Verifying lock file contents can be installed on current platform.
cdash  | Nothing to install, update or remove
cdash  | Package adldap2/adldap2 is abandoned, you should avoid using it. No replacement was suggested.
cdash  | Package adldap2/adldap2-laravel is abandoned, you should avoid using it. No replacement was suggested.
cdash  | Package tightenco/collect is abandoned, you should avoid using it. Use illuminate/collections instead.
cdash  | Generating optimized autoload files
cdash  | > Illuminate\Foundation\ComposerScripts::postAutoloadDump
cdash  | > @php artisan package:discover --ansi
cdash  | 
cdash  |    INFO  Discovering packages.  
cdash  | 
cdash  |   24slides/laravel-saml2 ................................................ DONE
cdash  |   adldap2/adldap2-laravel ............................................... DONE
cdash  |   laravel/legacy-factories .............................................. DONE
cdash  |   laravel/socialite ..................................................... DONE
cdash  |   laravel/ui ............................................................ DONE
cdash  |   mll-lab/laravel-graphiql .............................................. DONE
cdash  |   nesbot/carbon ......................................................... DONE
cdash  |   nunomaduro/termwind ................................................... DONE
cdash  |   nuwave/lighthouse ..................................................... DONE
cdash  |   shiftonelabs/laravel-sqs-fifo-queue ................................... DONE
cdash  |   socialiteproviders/manager ............................................ DONE
cdash  | 
cdash  | 65 packages you are using are looking for funding.
cdash  | Use the `composer fund` command to find out more!
cdash  | Creating storage directories...
cdash  | /cdash/storage/app/failed already exists
cdash  | /cdash/storage/app/inbox already exists
cdash  | /cdash/storage/app/inprogress already exists
cdash  | /cdash/storage/app/parsed already exists
cdash  | creating /cdash/storage/app/public
cdash  | creating /cdash/storage/app/tmp
cdash  | /cdash/storage/app/upload already exists
cdash  | /cdash/storage/framework/cache/data already exists
cdash  | /cdash/storage/framework/sessions already exists
cdash  | /cdash/storage/framework/views already exists
cdash  | creating /cdash/storage/logs
cdash  | Running migrations...
cdash  | 
cdash  |    INFO  Running migrations.  
cdash  | 
cdash  |   2024_01_14_161810_delete_version_table ........................... 17ms DONE
cdash  |   2024_03_22_031040_project_unique_name ............................ 16ms DONE
cdash  |   2024_03_22_233702_drop_bugtrackerfileurl_column ................... 5ms DONE
cdash  |   2024_03_22_234620_label2buildfailure_index ....................... 11ms DONE
cdash  |   2024_03_23_001025_label2dynamicanalysis_index .................... 60ms DONE
cdash  |   2024_03_23_144609_siteinformation_fk Adding siteid foreign key to siteinformation table...0 invalid rows deleted
cdash  | ............................. 38ms DONE
cdash  |   2024_03_23_180709_site2user_fk_and_index Adding siteid foreign key to site2user table...0 invalid rows deleted
cdash  | ......................... 11ms DONE
cdash  |   2024_05_06_151132_buildinformation_nullable ...................... 25ms DONE
cdash  | 
cdash  | Clearing caches...
cdash  | 
cdash  |    INFO  Routes cached successfully.  
cdash  | 
cdash  | 
cdash  |    INFO  Blade templates cached successfully.  
cdash  | 
cdash  | GraphQL schema cache created.
cdash  | Building the website...
cdash  | 
cdash  | > cdash@3.4.0 prod
cdash  | > npm run production
cdash  | 
cdash  | 
cdash  | > cdash@3.4.0 production
cdash  | > mix --production
cdash  | 
cdash  | ℹ Compiling Mix
cdash  | 
cdash  |                          
cdash  |    Laravel Mix v6.0.49   
cdash  |                          
cdash  | 
cdash  | ✔ Compiled Successfully in 11912ms
cdash  | ┌───────────────────────────────────┬───────────┐
cdash  | │                              File │ Size      │
cdash  | ├───────────────────────────────────┼───────────┤
cdash  | │           /build/css/3rdparty.css │ 198 KiB   │
cdash  | │  …ild/css/cdash_1716899637822.css │ 1.22 KiB  │
cdash  | │  …ss/colorblind_1716899637822.css │ 1.08 KiB  │
cdash  | │             /build/css/common.css │ 23.7 KiB  │
cdash  | │  …ges/ui-icons_444444_256x240.png │ 6.97 KiB  │
cdash  | │  …ges/ui-icons_555555_256x240.png │ 6.96 KiB  │
cdash  | │  …ges/ui-icons_777620_256x240.png │ 4.56 KiB  │
cdash  | │  …ges/ui-icons_777777_256x240.png │ 7 KiB     │
cdash  | │  …ges/ui-icons_cc0000_256x240.png │ 4.56 KiB  │
cdash  | │  …ges/ui-icons_ffffff_256x240.png │ 6.39 KiB  │
cdash  | │      /build/css/nv.d3.min.css.map │ 3.59 KiB  │
cdash  | │ /build/views/compareCoverage.html │ 5.17 KiB  │
cdash  | │           /build/views/index.html │ 21.7 KiB  │
cdash  | │  …ild/views/manageBuildGroup.html │ 16.2 KiB  │
cdash  | │  /build/views/manageOverview.html │ 3.53 KiB  │
cdash  | │  …ild/views/manageSubProject.html │ 10.2 KiB  │
cdash  | │        /build/views/overview.html │ 4.18 KiB  │
cdash  | │  …s/buildError_1716899637822.html │ 4.08 KiB  │
cdash  | │  …rtials/build_1716899637822.html │ 15.5 KiB  │
cdash  | │  …s/buildgroup_1716899637822.html │ 10.4 KiB  │
cdash  | │  …ls/daterange_1716899637822.html │ 194 bytes │
cdash  | │  …ilterButtons_1716899637822.html │ 631 bytes │
cdash  | │  …ls/filterRow_1716899637822.html │ 1.35 KiB  │
cdash  | │  …dataTemplate_1716899637822.html │ 2.86 KiB  │
cdash  | │  …ProjectTable_1716899637822.html │ 8.67 KiB  │
cdash  | │  …als/timeline_1716899637822.html │ 585 bytes │
cdash  | │      /build/views/queryTests.html │ 6.99 KiB  │
cdash  | │    /build/views/testOverview.html │ 5.84 KiB  │
cdash  | │     /build/views/testSummary.html │ 4.81 KiB  │
cdash  | │  /build/views/userStatistics.html │ 5.39 KiB  │
cdash  | │  /build/views/viewBuildError.html │ 3.33 KiB  │
cdash  | │  …ws/viewDynamicAnalysisFile.html │ 602 bytes │
cdash  | │ /build/views/viewSubProjects.html │ 5.8 KiB   │
cdash  | │               /js/1stparty.min.js │ 55.5 KiB  │
cdash  | │               /js/3rdparty.min.js │ 1.49 MiB  │
cdash  | │    /js/CDash_1716899637822.min.js │ 1.54 MiB  │
cdash  | │                  /js/nv.d3.js.map │ 1.55 MiB  │
cdash  | │                /laravel/js/app.js │ 2.01 MiB  │
cdash  | │    /laravel/js/app.js.LICENSE.txt │ 379 bytes │
cdash  | │                          /main.js │ 2.65 KiB  │
cdash  | │                        COMMITHASH │ 40 bytes  │
cdash  | │                LASTCOMMITDATETIME │ 25 bytes  │
cdash  | │                           VERSION │ 6 bytes   │
cdash  | │               laravel/css/app.css │ 143 KiB   │
cdash  | └───────────────────────────────────┴───────────┘
cdash  | ✔ Mix: Compiled successfully in 28.04s
cdash  |     
cdash  | 
cdash  |   WARNING in ./resources/sass/app.scss (./node_modules/css-loader/dist/cjs.js??clonedRuleSet-6.use[1]!./node_modules/postcss-loader/dist/cjs.js??clonedRuleSet-6.use[2]!./node_modules/resolve-url-loader/index.js??clonedRuleSet-6.use[3]!./node_modules/sass-loader/dist/cjs.js??clonedRuleSet-6.use[4]!./resources/sass/app.scss)
cdash  |   Module Warning (from ./node_modules/sass-loader/dist/cjs.js):
cdash  |   Deprecation Warning on line 53, column 13 of file:///cdash/node_modules/bootstrap/scss/vendor/_rfs.scss:53:13:
cdash  |   Passing percentage units to the global abs() function is deprecated.
cdash  |   In the future, this will emit a CSS abs() function to be resolved by the browser.
cdash  |   To preserve current behavior: math.abs(100%)
cdash  |   To emit a CSS abs() now: abs(#{100%})
cdash  |   More info: https://sass-lang.com/d/abs-percent
cdash  | 
cdash  |   53 |   $dividend: abs($dividend);
cdash  | 
cdash  | 
cdash  |   node_modules/bootstrap/scss/vendor/_rfs.scss 54:14             divide()
cdash  |   node_modules/bootstrap/scss/mixins/_grid.scss 66:15            row-cols()
cdash  |   node_modules/bootstrap/scss/mixins/_grid-framework.scss 43:13  @content
cdash  |   node_modules/bootstrap/scss/mixins/_breakpoints.scss 65:5      media-breakpoint-up()
cdash  |   node_modules/bootstrap/scss/mixins/_grid-framework.scss 32:5   make-grid-columns()
cdash  |   node_modules/bootstrap/scss/_grid.scss 72:3                    @import
cdash  |   node_modules/bootstrap/scss/bootstrap.scss 16:9                @import
cdash  |   resources/sass/app.scss 9:9                                    root stylesheet
cdash  | 
cdash  |   Child mini-css-extract-plugin /cdash/node_modules/css-loader/dist/cjs.js??clonedRuleSet-6.use[1]!/cdash/node_modules/postcss-loader/dist/cjs.js??clonedRuleSet-6.use[2]!/cdash/node_modules/resolve-url-loader/index.js??clonedRuleSet-6.use[3]!/cdash/node_modules/sass-loader/dist/cjs.js??clonedRuleSet-6.use[4]!/cdash/resources/sass/app.scss compiled with 1 warning
cdash  | webpack compiled with 1 warning
cdash  | Bringing CDash back online...
cdash  | 
cdash  |    INFO  Application is now live.  
cdash_postgres  | 
cdash_postgres  | PostgreSQL Database directory appears to contain a database; Skipping initialization
cdash_postgres  | 
cdash_postgres  | 2024-05-28 12:33:46.422 UTC [1] LOG:  starting PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
cdash_postgres  | 2024-05-28 12:33:46.423 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
cdash_postgres  | 2024-05-28 12:33:46.423 UTC [1] LOG:  listening on IPv6 address "::", port 5432
cdash_postgres  | 2024-05-28 12:33:46.425 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
cdash_postgres  | 2024-05-28 12:33:46.429 UTC [28] LOG:  database system was shut down at 2024-05-28 12:33:31 UTC
cdash_postgres  | 2024-05-28 12:33:46.437 UTC [1] LOG:  database system is ready to accept connections
cdash_postgres  | 2024-05-28 12:37:17.539 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 12:37:17.539 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14280, '11909584', 'passed', 'Completed', '0.0672586', 'TestCore_FastHeap') returning "id"
cdash_postgres  | 2024-05-28 12:37:50.780 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.780 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'notrun' AND b2t.details != 'Disabled'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.780 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.780 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14269'
cdash_postgres  |               AND b2t.status = 'notrun' AND b2t.details != 'Disabled'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.781 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.781 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'failed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.781 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.781 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14269'
cdash_postgres  |               AND b2t.status = 'failed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.782 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.782 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'passed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14269'
cdash_postgres  |               AND b2t.status = 'passed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.timestatus > 3
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 12:37:50.783 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14269'
cdash_postgres  |               AND b2t.timestatus > 3
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 12:37:50.784 UTC [350] ERROR:  column b2t.testname does not exist at character 31
cdash_postgres  | 2024-05-28 12:37:50.784 UTC [350] STATEMENT:  SELECT b2t.id AS buildtestid, b2t.testname
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14269'
cdash_postgres  | 2024-05-28 12:37:50.793 UTC [350] ERROR:  column "testname" does not exist at character 17
cdash_postgres  | 2024-05-28 12:37:50.793 UTC [350] STATEMENT:  SELECT DISTINCT testname
cdash_postgres  |                   FROM build2test
cdash_postgres  |                   WHERE buildid=14269
cdash_postgres  |                   ORDER BY testname
cdash_postgres  |                
cdash_postgres  | 2024-05-28 12:38:46.521 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 12:39:08.535 UTC [26] LOG:  checkpoint complete: wrote 222 buffers (1.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=21.998 s, sync=0.011 s, total=22.014 s; sync files=132, longest=0.005 s, average=0.001 s; distance=2634 kB, estimate=2634 kB; lsn=3A/5AE8B2F8, redo lsn=3A/5AE8B2C0
cdash_postgres  | 2024-05-28 12:43:46.549 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 12:43:47.359 UTC [26] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.803 s, sync=0.004 s, total=0.811 s; sync files=9, longest=0.003 s, average=0.001 s; distance=19 kB, estimate=2373 kB; lsn=3A/5AE90030, redo lsn=3A/5AE8FFE0
cdash_postgres  | 2024-05-28 12:44:03.313 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 12:44:03.313 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14282, '11909585', 'passed', 'Completed', '0.0706331', 'TestCore_Bug18076') returning "id"
cdash_postgres  | 2024-05-28 12:48:46.440 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 12:48:54.889 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 12:48:54.889 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14283, '11909586', 'passed', 'Completed', '0.125633', 'TestCore_Fragmentation') returning "id"
cdash_postgres  | 2024-05-28 12:48:55.079 UTC [26] LOG:  checkpoint complete: wrote 88 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.623 s, sync=0.012 s, total=8.640 s; sync files=76, longest=0.003 s, average=0.001 s; distance=416 kB, estimate=2177 kB; lsn=3A/5AF520A8, redo lsn=3A/5AEF82E0
cdash_postgres  | 2024-05-28 12:53:31.294 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 12:53:31.294 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14284, '11909587', 'passed', 'Completed', '0.043395', 'TestLoader_BlockParser') returning "id"
cdash_postgres  | 2024-05-28 12:53:46.179 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 12:53:56.525 UTC [26] LOG:  checkpoint complete: wrote 105 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.334 s, sync=0.007 s, total=10.346 s; sync files=79, longest=0.002 s, average=0.001 s; distance=519 kB, estimate=2011 kB; lsn=3A/5AF7F8B8, redo lsn=3A/5AF7A018
cdash_postgres  | 2024-05-28 12:58:46.619 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 12:58:47.931 UTC [26] LOG:  checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.304 s, sync=0.004 s, total=1.312 s; sync files=11, longest=0.002 s, average=0.001 s; distance=54 kB, estimate=1816 kB; lsn=3A/5AF87C48, redo lsn=3A/5AF87C10
cdash_postgres  | 2024-05-28 13:00:43.764 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:00:43.764 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14285, '11909588', 'passed', 'Completed', '0.0614676', 'TestCore_HastTableString') returning "id"
cdash_postgres  | 2024-05-28 13:03:47.014 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:03:56.049 UTC [26] LOG:  checkpoint complete: wrote 92 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.024 s, sync=0.007 s, total=9.036 s; sync files=77, longest=0.002 s, average=0.001 s; distance=421 kB, estimate=1676 kB; lsn=3A/5AFF11C8, redo lsn=3A/5AFF1190
cdash_postgres  | 2024-05-28 13:06:35.259 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:06:35.259 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14286, '11909589', 'passed', 'Completed', '0.038988', 'TestProd_Bug19888') returning "id"
cdash_postgres  | 2024-05-28 13:07:41.500 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:07:41.500 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14287, '11909590', 'passed', 'Completed', '0.0617321', 'TestCore_HastTableString') returning "id"
cdash_postgres  | 2024-05-28 13:08:47.129 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:08:47.774 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:08:47.774 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14288, '11909591', 'passed', 'Completed', '0.172096', 'TestProd_Bug20045') returning "id"
cdash_postgres  | 2024-05-28 13:08:57.582 UTC [26] LOG:  checkpoint complete: wrote 106 buffers (0.6%); 0 WAL file(s) added, 1 removed, 0 recycled; write=10.436 s, sync=0.011 s, total=10.454 s; sync files=73, longest=0.006 s, average=0.001 s; distance=554 kB, estimate=1564 kB; lsn=3A/5B094970, redo lsn=3A/5B07BD38
cdash_postgres  | 2024-05-28 13:10:30.098 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.098 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14289'
cdash_postgres  |               AND b2t.status = 'notrun' AND b2t.details != 'Disabled'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.099 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.099 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'notrun' AND b2t.details != 'Disabled'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14289'
cdash_postgres  |               AND b2t.status = 'failed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'failed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14289'
cdash_postgres  |               AND b2t.status = 'passed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.100 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.status = 'passed'
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.101 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.101 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14289'
cdash_postgres  |               AND b2t.timestatus > 3
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.102 UTC [350] ERROR:  column b2t.testname does not exist at character 21
cdash_postgres  | 2024-05-28 13:10:30.102 UTC [350] STATEMENT:  
cdash_postgres  |               SELECT b2t.testname AS name, b2t.id AS buildtestid, b2t.details
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  |               AND b2t.timestatus > 3
cdash_postgres  |               ORDER BY b2t.testname
cdash_postgres  |               
cdash_postgres  | 2024-05-28 13:10:30.102 UTC [350] ERROR:  column b2t.testname does not exist at character 31
cdash_postgres  | 2024-05-28 13:10:30.102 UTC [350] STATEMENT:  SELECT b2t.id AS buildtestid, b2t.testname
cdash_postgres  |               FROM build2test b2t
cdash_postgres  |               WHERE b2t.buildid = '14281'
cdash_postgres  | 2024-05-28 13:10:30.110 UTC [350] ERROR:  column "testname" does not exist at character 17
cdash_postgres  | 2024-05-28 13:10:30.110 UTC [350] STATEMENT:  SELECT DISTINCT testname
cdash_postgres  |                   FROM build2test
cdash_postgres  |                   WHERE buildid=14281
cdash_postgres  |                   ORDER BY testname
cdash_postgres  |                
cdash_postgres  | 2024-05-28 13:12:29.791 UTC [18155] ERROR:  function locate(unknown, text) does not exist at character 189
cdash_postgres  | 2024-05-28 13:12:29.791 UTC [18155] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
cdash_postgres  | 2024-05-28 13:12:29.791 UTC [18155] STATEMENT:  SELECT uf.* FROM updatefile uf
cdash_postgres  |               JOIN build2update b2u ON uf.updateid = b2u.updateid
cdash_postgres  |               WHERE b2u.buildid = '14288'
cdash_postgres  |               ORDER BY REVERSE(RIGHT(REVERSE(filename),LOCATE('/',REVERSE(filename))))
cdash_postgres  | 2024-05-28 13:12:45.599 UTC [18291] ERROR:  function locate(unknown, text) does not exist at character 189
cdash_postgres  | 2024-05-28 13:12:45.599 UTC [18291] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
cdash_postgres  | 2024-05-28 13:12:45.599 UTC [18291] STATEMENT:  SELECT uf.* FROM updatefile uf
cdash_postgres  |               JOIN build2update b2u ON uf.updateid = b2u.updateid
cdash_postgres  |               WHERE b2u.buildid = '14284'
cdash_postgres  |               ORDER BY REVERSE(RIGHT(REVERSE(filename),LOCATE('/',REVERSE(filename))))
cdash_postgres  | 2024-05-28 13:12:48.388 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:12:48.388 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14290, '11909592', 'passed', 'Completed', '0.0560186', 'CoverageLogger_CoverageLogger') returning "id"
cdash_postgres  | 2024-05-28 13:13:15.654 UTC [350] ERROR:  column "testname" of relation "build2test" does not exist at character 102
cdash_postgres  | 2024-05-28 13:13:15.654 UTC [350] STATEMENT:  insert into "build2test" ("timemean", "timestd", "buildid", "outputid", "status", "details", "time", "testname") values ('0', '0', 14291, '11909593', 'passed', 'Completed', '0.185331', 'TestCore_Bug21166') returning "id"
cdash_postgres  | 2024-05-28 13:13:47.596 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:14:00.251 UTC [26] LOG:  checkpoint complete: wrote 128 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=12.642 s, sync=0.009 s, total=12.656 s; sync files=88, longest=0.003 s, average=0.001 s; distance=682 kB, estimate=1476 kB; lsn=3A/5B12C8C8, redo lsn=3A/5B1265B0
cdash_postgres  | 2024-05-28 13:18:47.347 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:18:52.375 UTC [26] LOG:  checkpoint complete: wrote 51 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.019 s, sync=0.005 s, total=5.029 s; sync files=40, longest=0.002 s, average=0.001 s; distance=171 kB, estimate=1345 kB; lsn=3A/5B1531F8, redo lsn=3A/5B1514D8
cdash_postgres  | 2024-05-28 13:23:47.464 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:28:17.114 UTC [26] LOG:  checkpoint complete: wrote 3624 buffers (22.1%); 0 WAL file(s) added, 0 removed, 1 recycled; write=269.630 s, sync=0.015 s, total=269.650 s; sync files=106, longest=0.005 s, average=0.001 s; distance=26744 kB, estimate=26744 kB; lsn=3A/5E3D8B20, redo lsn=3A/5CB6F6A8
cdash_postgres  | 2024-05-28 13:28:47.117 UTC [26] LOG:  checkpoint starting: time
cdash_postgres  | 2024-05-28 13:33:17.068 UTC [26] LOG:  checkpoint complete: wrote 2803 buffers (17.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.936 s, sync=0.009 s, total=269.951 s; sync files=100, longest=0.002 s, average=0.001 s; distance=24997 kB, estimate=26569 kB; lsn=3A/5E3ECF48, redo lsn=3A/5E3D8C10
cdash_postgres  | 2024-05-28 13:38:47.197 UTC [26] LOG:  checkpoint starting: time
williamjallen commented 6 months ago

Are you using the v3.4.2 tag for the worker image?

vlb-sq commented 6 months ago

I was actually using no tag in my compose file, so I believe it resolves to :latest?

williamjallen commented 6 months ago

Yep, that would do it. You're running 3.4 in your primary container, but the workers are using more recent code which requires more recent migrations.

williamjallen commented 5 months ago

It seems like there aren't any actionable items here from the CDash side, so I'm going to close this now. Please feel free to update this further or create a new issue if you believe there is an issue with CDash itself.