Project

General

Profile

action #91046

Updated by ilausuch about 3 years ago

## Motivation 

 In #89731 we introduced a initial webui container in charge of initializing the database. We have a test where the health check failed 
 https://github.com/os-autoinst/openQA/pull/3838/checks?check_run_id=2329551052 

 The problem is that the docker-compose exit with an error because the health check of the webuid_db_init container failed 
 ~~~ text 
          Name                         Command                     State                                          Ports                                  
 ------------------------------------------------------------------------------------------------------------------------------------------------ 
 webui_db_1                docker-entrypoint.sh postgres      Up (healthy)       5432/tcp                                                               
 webui_webui_db_init_1     sh -c chmod -R a+rwX /data ...     Up (unhealthy)     443/tcp, 80/tcp, 0.0.0.0:49153->9526/tcp, 9527/tcp, 9528/tcp, 9529/tcp 
 make: *** [Makefile:306: test-containers-compose] Error 1 
 ~~~ 

 The healthcheck is this one  
 https://github.com/os-autoinst/openQA/blob/abd9a2297430377cd9876c3cbcec8b2cb4302722/container/webui/docker-compose.yaml#L116 

 Take in consideration the DB error lines 
 ~~~ text 
 db_1               | 2021-04-13 02:43:08.038 UTC [98] ERROR:    relation "api_keys" does not exist at character 15 
 db_1               | 2021-04-13 02:43:08.038 UTC [98] STATEMENT:    select * from api_keys; 
 db_1               | 2021-04-13 02:43:10.441 UTC [100] ERROR:    relation "dbix_class_deploymenthandler_versions" does not exist at character 24 
 db_1               | 2021-04-13 02:43:10.441 UTC [100] STATEMENT:    SELECT me.version FROM dbix_class_deploymenthandler_versions me ORDER BY id DESC LIMIT $1 
 db_1               | 2021-04-13 02:43:10.446 UTC [100] ERROR:    relation "dbix_class_deploymenthandler_versions" does not exist at character 24 
 ~~~ 


 ## Acceptance criteria 
 * **AC 1**: Determine the cause of the failure 
 * **AC 2**: Fix the problem 

Back