Skip to content

Error 1049 (42000): Unknown database 'boulder_sa' #224

@vsc55

Description

@vsc55

Hi,

First of all I wanted to thank you for this great project.

The problem has arisen when updating from version 25.12 to 26.03.
Now when trying to access sections other than the LOG, the following error appears on the website: Some unexpected error occurred!
This is logged in the console:

gui-1             | 2026/03/11 20:41:11 GET /
gui-1             | 2026/03/11 20:41:11 errorHandler: err=Error 1049 (42000): Unknown database 'boulder_sa'
gui-1             | main.CollectDashboardData({0x16b87f8, 0xc00015c780}, 0xc000d58500)
gui-1             |     /go/src/labca/dashboard.go:605 +0x9aa
gui-1             | main.rootHandler({0x16b87f8, 0xc00015c780}, 0xc000d58500)
gui-1             |     /go/src/labca/main.go:392 +0x6c
gui-1             | net/http.HandlerFunc.ServeHTTP(0xfbf740?, {0x16b87f8?, 0xc00015c780?}, 0xc00015c780?)
gui-1             |     /usr/local/go/src/net/http/server.go:2322 +0x29
gui-1             | main.authorized.func1({0x16b87f8, 0xc00015c780}, 0xc000d58500)
gui-1             |     /go/src/labca/main.go:3154 +0x32e
gui-1             | net/http.HandlerFunc.ServeHTTP(0xc000d583c0?, {0x16b87f8?, 0xc00015c780?}, 0x3052b87b7d?)
gui-1             |     /usr/local/go/src/net/http/server.go:2322 +0x29
gui-1             | github.com/gorilla/mux.(*Router).ServeHTTP(0xc000d54000, {0x16b87f8, 0xc00015c780}, 0xc000d58280)
gui-1             |     /root/go/pkg/mod/github.com/gorilla/mux@v1.8.1/mux.go:212 +0x1e2
gui-1             | net/http.serverHandler.ServeHTTP({0xc000bf2680?}, {0x16b87f8?, 0xc00015c780?}, 0x6?)
gui-1             |     /usr/local/go/src/net/http/server.go:3340 +0x8e
gui-1             | net/http.(*conn).serve(0xc0000e7cb0, {0x16bad80, 0xc000c002d0})
gui-1             |     /usr/local/go/src/net/http/server.go:2109 +0x665
gui-1             | created by net/http.(*Server).Serve in goroutine 1
gui-1             |     /usr/local/go/src/net/http/server.go:3493 +0x485
nginx-1           | ::ffff:192.xxxxx - - [11/Mar/2026:20:41:11 +0000] "GET /admin/ HTTP/1.1" 500 9077 "https://labca.dominio.local/admin/about" "Mozill

The mysql update process seems to be fine, everything is ok:

bmysql-upgrade-1  | Phase 1/8: Checking and upgrading mysql database
bmysql-upgrade-1  | Processing databases
bmysql-upgrade-1  | mysql
bmysql-upgrade-1  | mysql.column_stats                                 OK
bmysql-upgrade-1  | mysql.columns_priv                                 OK
bmysql-upgrade-1  | mysql.db                                           OK
bmysql-upgrade-1  | mysql.event                                        OK
bmysql-upgrade-1  | mysql.func                                         OK
bmysql-upgrade-1  | mysql.global_priv                                  OK
bmysql-upgrade-1  | mysql.gtid_slave_pos                               OK
bmysql-upgrade-1  | mysql.help_category                                OK
bmysql-upgrade-1  | mysql.help_keyword                                 OK
bmysql-upgrade-1  | mysql.help_relation                                OK
bmysql-upgrade-1  | mysql.help_topic                                   OK
bmysql-upgrade-1  | mysql.index_stats                                  OK
bmysql-upgrade-1  | mysql.innodb_index_stats                           OK
bmysql-upgrade-1  | mysql.innodb_table_stats                           OK
bmysql-upgrade-1  | mysql.plugin                                       OK
bmysql-upgrade-1  | mysql.proc                                         OK
bmysql-upgrade-1  | mysql.procs_priv                                   OK
bmysql-upgrade-1  | mysql.proxies_priv                                 OK
bmysql-upgrade-1  | mysql.roles_mapping                                OK
bmysql-upgrade-1  | mysql.servers                                      OK
bmysql-upgrade-1  | mysql.table_stats                                  OK
bmysql-upgrade-1  | mysql.tables_priv                                  OK
bmysql-upgrade-1  | mysql.time_zone                                    OK
bmysql-upgrade-1  | mysql.time_zone_leap_second                        OK
bmysql-upgrade-1  | mysql.time_zone_name                               OK
bmysql-upgrade-1  | mysql.time_zone_transition                         OK
bmysql-upgrade-1  | mysql.time_zone_transition_type                    OK
bmysql-upgrade-1  | mysql.transaction_registry                         OK
bmysql-upgrade-1  | Phase 2/8: Installing used storage engines... Skipped
bmysql-upgrade-1  | Phase 3/8: Running 'mysql_fix_privilege_tables'
boulder-1         | labca/entrypoint.sh: line 26: USE_VITESS: unbound variable
boulder-1 exited with code 1 (restarting)
boulder-1         | labca/entrypoint.sh: line 26: USE_VITESS: unbound variable
boulder-1 exited with code 1 (restarting)
boulder-1         | labca/entrypoint.sh: line 26: USE_VITESS: unbound variable
boulder-1 exited with code 1 (restarting)
boulder-1 exited with code 1 (restarting)
boulder-1         | labca/entrypoint.sh: line 26: USE_VITESS: unbound variable
bmysql-upgrade-1  | Phase 4/8: Fixing views
bmysql-upgrade-1  | mysql.user                                         OK
bmysql-upgrade-1  | sys.host_summary                                   OK
bmysql-upgrade-1  | sys.host_summary_by_file_io                        OK
bmysql-upgrade-1  | sys.host_summary_by_file_io_type                   OK
bmysql-upgrade-1  | sys.host_summary_by_stages                         OK
bmysql-upgrade-1  | sys.host_summary_by_statement_latency              OK
bmysql-upgrade-1  | sys.host_summary_by_statement_type                 OK
bmysql-upgrade-1  | sys.innodb_buffer_stats_by_schema                  OK
bmysql-upgrade-1  | sys.innodb_buffer_stats_by_table                   OK
bmysql-upgrade-1  | sys.innodb_lock_waits                              OK
bmysql-upgrade-1  | sys.io_by_thread_by_latency                        OK
bmysql-upgrade-1  | sys.io_global_by_file_by_bytes                     OK
bmysql-upgrade-1  | sys.io_global_by_file_by_latency                   OK
bmysql-upgrade-1  | sys.io_global_by_wait_by_bytes                     OK
bmysql-upgrade-1  | sys.io_global_by_wait_by_latency                   OK
bmysql-upgrade-1  | sys.latest_file_io                                 OK
bmysql-upgrade-1  | sys.memory_by_host_by_current_bytes                OK
bmysql-upgrade-1  | sys.memory_by_thread_by_current_bytes              OK
bmysql-upgrade-1  | sys.memory_by_user_by_current_bytes                OK
bmysql-upgrade-1  | sys.memory_global_by_current_bytes                 OK
bmysql-upgrade-1  | sys.memory_global_total                            OK
bmysql-upgrade-1  | sys.metrics                                        OK
bmysql-upgrade-1  | sys.processlist                                    OK
bmysql-upgrade-1  | sys.ps_check_lost_instrumentation                  OK
bmysql-upgrade-1  | sys.schema_auto_increment_columns                  OK
bmysql-upgrade-1  | sys.schema_index_statistics                        OK
bmysql-upgrade-1  | sys.schema_object_overview                         OK
bmysql-upgrade-1  | sys.schema_redundant_indexes                       OK
bmysql-upgrade-1  | sys.schema_table_lock_waits                        OK
bmysql-upgrade-1  | sys.schema_table_statistics                        OK
bmysql-upgrade-1  | sys.schema_table_statistics_with_buffer            OK
bmysql-upgrade-1  | sys.schema_tables_with_full_table_scans            OK
bmysql-upgrade-1  | sys.schema_unused_indexes                          OK
bmysql-upgrade-1  | sys.session                                        OK
bmysql-upgrade-1  | sys.session_ssl_status                             OK
bmysql-upgrade-1  | sys.statement_analysis                             OK
bmysql-upgrade-1  | sys.statements_with_errors_or_warnings             OK
bmysql-upgrade-1  | sys.statements_with_full_table_scans               OK
bmysql-upgrade-1  | sys.statements_with_runtimes_in_95th_percentile    OK
bmysql-upgrade-1  | sys.statements_with_sorting                        OK
bmysql-upgrade-1  | sys.statements_with_temp_tables                    OK
bmysql-upgrade-1  | sys.user_summary                                   OK
bmysql-upgrade-1  | sys.user_summary_by_file_io                        OK
bmysql-upgrade-1  | sys.user_summary_by_file_io_type                   OK
bmysql-upgrade-1  | sys.user_summary_by_stages                         OK
bmysql-upgrade-1  | sys.user_summary_by_statement_latency              OK
bmysql-upgrade-1  | sys.user_summary_by_statement_type                 OK
bmysql-upgrade-1  | sys.version                                        OK
bmysql-upgrade-1  | sys.wait_classes_global_by_avg_latency             OK
bmysql-upgrade-1  | sys.wait_classes_global_by_latency                 OK
bmysql-upgrade-1  | sys.waits_by_host_by_latency                       OK
bmysql-upgrade-1  | sys.waits_by_user_by_latency                       OK
bmysql-upgrade-1  | sys.waits_global_by_latency                        OK
bmysql-upgrade-1  | sys.x$host_summary                                 OK
bmysql-upgrade-1  | sys.x$host_summary_by_file_io                      OK
bmysql-upgrade-1  | sys.x$host_summary_by_file_io_type                 OK
bmysql-upgrade-1  | sys.x$host_summary_by_stages                       OK
bmysql-upgrade-1  | sys.x$host_summary_by_statement_latency            OK
bmysql-upgrade-1  | sys.x$host_summary_by_statement_type               OK
bmysql-upgrade-1  | sys.x$innodb_buffer_stats_by_schema                OK
bmysql-upgrade-1  | sys.x$innodb_buffer_stats_by_table                 OK
bmysql-upgrade-1  | sys.x$innodb_lock_waits                            OK
bmysql-upgrade-1  | sys.x$io_by_thread_by_latency                      OK
bmysql-upgrade-1  | sys.x$io_global_by_file_by_bytes                   OK
bmysql-upgrade-1  | sys.x$io_global_by_file_by_latency                 OK
bmysql-upgrade-1  | sys.x$io_global_by_wait_by_bytes                   OK
bmysql-upgrade-1  | sys.x$io_global_by_wait_by_latency                 OK
bmysql-upgrade-1  | sys.x$latest_file_io                               OK
bmysql-upgrade-1  | sys.x$memory_by_host_by_current_bytes              OK
bmysql-upgrade-1  | sys.x$memory_by_thread_by_current_bytes            OK
bmysql-upgrade-1  | sys.x$memory_by_user_by_current_bytes              OK
bmysql-upgrade-1  | sys.x$memory_global_by_current_bytes               OK
bmysql-upgrade-1  | sys.x$memory_global_total                          OK
bmysql-upgrade-1  | sys.x$processlist                                  OK
bmysql-upgrade-1  | sys.x$ps_digest_95th_percentile_by_avg_us          OK
bmysql-upgrade-1  | sys.x$ps_digest_avg_latency_distribution           OK
bmysql-upgrade-1  | sys.x$ps_schema_table_statistics_io                OK
bmysql-upgrade-1  | sys.x$schema_flattened_keys                        OK
bmysql-upgrade-1  | sys.x$schema_index_statistics                      OK
bmysql-upgrade-1  | sys.x$schema_table_lock_waits                      OK
bmysql-upgrade-1  | sys.x$schema_table_statistics                      OK
bmysql-upgrade-1  | sys.x$schema_table_statistics_with_buffer          OK
bmysql-upgrade-1  | sys.x$schema_tables_with_full_table_scans          OK
bmysql-upgrade-1  | sys.x$session                                      OK
bmysql-upgrade-1  | sys.x$statement_analysis                           OK
bmysql-upgrade-1  | sys.x$statements_with_errors_or_warnings           OK
bmysql-upgrade-1  | sys.x$statements_with_full_table_scans             OK
bmysql-upgrade-1  | sys.x$statements_with_runtimes_in_95th_percentile  OK
bmysql-upgrade-1  | sys.x$statements_with_sorting                      OK
bmysql-upgrade-1  | sys.x$statements_with_temp_tables                  OK
bmysql-upgrade-1  | sys.x$user_summary                                 OK
bmysql-upgrade-1  | sys.x$user_summary_by_file_io                      OK
bmysql-upgrade-1  | sys.x$user_summary_by_file_io_type                 OK
bmysql-upgrade-1  | sys.x$user_summary_by_stages                       OK
bmysql-upgrade-1  | sys.x$user_summary_by_statement_latency            OK
bmysql-upgrade-1  | sys.x$user_summary_by_statement_type               OK
bmysql-upgrade-1  | sys.x$wait_classes_global_by_avg_latency           OK
bmysql-upgrade-1  | sys.x$wait_classes_global_by_latency               OK
bmysql-upgrade-1  | sys.x$waits_by_host_by_latency                     OK
bmysql-upgrade-1  | sys.x$waits_by_user_by_latency                     OK
bmysql-upgrade-1  | sys.x$waits_global_by_latency                      OK
bmysql-upgrade-1  | Phase 5/8: Fixing table and database names
bmysql-upgrade-1  | Phase 6/8: Checking and upgrading tables
bmysql-upgrade-1  | Processing databases
bmysql-upgrade-1  | boulder_sa_integration
bmysql-upgrade-1  | boulder_sa_integration.authz2                      OK
bmysql-upgrade-1  | boulder_sa_integration.blockedKeys                 OK
bmysql-upgrade-1  | boulder_sa_integration.certificateStatus           OK
bmysql-upgrade-1  | boulder_sa_integration.certificates                OK
bmysql-upgrade-1  | boulder_sa_integration.certificatesPerName         OK
bmysql-upgrade-1  | boulder_sa_integration.challenges                  OK
bmysql-upgrade-1  | boulder_sa_integration.crlShards                   OK
bmysql-upgrade-1  | boulder_sa_integration.fqdnSets                    OK
bmysql-upgrade-1  | boulder_sa_integration.gorp_migrations             OK
bmysql-upgrade-1  | boulder_sa_integration.incidents                   OK
bmysql-upgrade-1  | boulder_sa_integration.issuedNames                 OK
bmysql-upgrade-1  | boulder_sa_integration.keyHashToSerial             OK
bmysql-upgrade-1  | boulder_sa_integration.newOrdersRL                 OK
bmysql-upgrade-1  | boulder_sa_integration.orderFqdnSets               OK
bmysql-upgrade-1  | boulder_sa_integration.orderToAuthz2               OK
bmysql-upgrade-1  | boulder_sa_integration.orders                      OK
bmysql-upgrade-1  | boulder_sa_integration.paused                      OK
bmysql-upgrade-1  | boulder_sa_integration.precertificates             OK
bmysql-upgrade-1  | boulder_sa_integration.registrations               OK
bmysql-upgrade-1  | boulder_sa_integration.replacementOrders           OK
bmysql-upgrade-1  | boulder_sa_integration.requestedNames              OK
bmysql-upgrade-1  | boulder_sa_integration.revokedCertificates         OK
bmysql-upgrade-1  | boulder_sa_integration.serials                     OK
bmysql-upgrade-1  | boulder_sa_test
bmysql-upgrade-1  | boulder_sa_test.authz2                             OK
bmysql-upgrade-1  | boulder_sa_test.blockedKeys                        OK
bmysql-upgrade-1  | boulder_sa_test.certificateStatus                  OK
bmysql-upgrade-1  | boulder_sa_test.certificates                       OK
bmysql-upgrade-1  | boulder_sa_test.certificatesPerName                OK
bmysql-upgrade-1  | boulder_sa_test.challenges                         OK
bmysql-upgrade-1  | boulder_sa_test.crlShards                          OK
bmysql-upgrade-1  | boulder_sa_test.fqdnSets                           OK
bmysql-upgrade-1  | boulder_sa_test.gorp_migrations                    OK
bmysql-upgrade-1  | boulder_sa_test.incidents                          OK
bmysql-upgrade-1  | boulder_sa_test.issuedNames                        OK
bmysql-upgrade-1  | boulder_sa_test.keyHashToSerial                    OK
bmysql-upgrade-1  | boulder_sa_test.newOrdersRL                        OK
bmysql-upgrade-1  | boulder_sa_test.orderFqdnSets                      OK
bmysql-upgrade-1  | boulder_sa_test.orderToAuthz2                      OK
bmysql-upgrade-1  | boulder_sa_test.orders                             OK
bmysql-upgrade-1  | boulder_sa_test.paused                             OK
bmysql-upgrade-1  | boulder_sa_test.precertificates                    OK
bmysql-upgrade-1  | boulder_sa_test.registrations                      OK
bmysql-upgrade-1  | boulder_sa_test.replacementOrders                  OK
bmysql-upgrade-1  | boulder_sa_test.requestedNames                     OK
bmysql-upgrade-1  | boulder_sa_test.revokedCertificates                OK
bmysql-upgrade-1  | boulder_sa_test.serials                            OK
bmysql-upgrade-1  | incidents_sa_integration
bmysql-upgrade-1  | incidents_sa_integration.gorp_migrations           OK
bmysql-upgrade-1  | incidents_sa_integration.incident_bar              OK
bmysql-upgrade-1  | incidents_sa_integration.incident_foo              OK
bmysql-upgrade-1  | incidents_sa_test
bmysql-upgrade-1  | incidents_sa_test.gorp_migrations                  OK
bmysql-upgrade-1  | incidents_sa_test.incident_bar                     OK
bmysql-upgrade-1  | incidents_sa_test.incident_foo                     OK
bmysql-upgrade-1  | information_schema
bmysql-upgrade-1  | performance_schema
bmysql-upgrade-1  | sys
bmysql-upgrade-1  | sys.sys_config                                     OK
bmysql-upgrade-1  | Phase 7/8: uninstalling plugins
bmysql-upgrade-1  | Phase 8/8: Running 'FLUSH PRIVILEGES'
bmysql-upgrade-1  | OK

Best Regards.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions