Database migration logs are flooding the application stdout
As on 2.0-RC3
, to reproduce, run:
docker run -it --rm -p 8080:8080 lightmeter/controlcenter:latest -stdin
And you'll see some output similar to:
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name auth service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_auth_migration_create_auth_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 2_create_meta_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_auth_migration_clear_old_keys.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 4_index_meta_table.go service=controlcenter
2022/01/19 11:37:24 OK 1_auth_migration_create_auth_table.go
2022/01/19 11:37:24 OK 2_create_meta_table.go
2022/01/19 11:37:24 OK 3_auth_migration_clear_old_keys.go
2022/01/19 11:37:24 OK 4_index_meta_table.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 4 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name connections service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_create_postfix_connection_tables.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 2_add_support_for_imap.go service=controlcenter
2022/01/19 11:37:24 OK 1_create_postfix_connection_tables.go
2022/01/19 11:37:24 OK 2_add_support_for_imap.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 2 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name insights service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_insights.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 2_fix_fields_names.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_metadata.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 4_historical_import.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 5_insights_user_ratings.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 6_index_meta_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 7_index_archived.go service=controlcenter
2022/01/19 11:37:24 OK 1_insights.go
2022/01/19 11:37:24 OK 2_fix_fields_names.go
2022/01/19 11:37:24 OK 3_metadata.go
2022/01/19 11:37:24 OK 4_historical_import.go
2022/01/19 11:37:24 OK 5_insights_user_ratings.go
2022/01/19 11:37:24 OK 6_index_meta_table.go
2022/01/19 11:37:24 OK 7_index_archived.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 7 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name intel-collector service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_basic_intel.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_create_meta_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 6_index_meta_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 7_events.go service=controlcenter
2022/01/19 11:37:24 OK 1_basic_intel.go
2022/01/19 11:37:24 OK 3_create_meta_table.go
2022/01/19 11:37:24 OK 6_index_meta_table.go
2022/01/19 11:37:24 OK 7_events.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 7 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name logs service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_create_table_postfix_smtp_message_status.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 2_delete_old_log_tables.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_delivery_tables.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 4_add_queue_info.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 5_case_insensitive_domains_index.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 6_index_for_message_id.go service=controlcenter
2022/01/19 11:37:24 OK 1_create_table_postfix_smtp_message_status.go
2022/01/19 11:37:24 OK 2_delete_old_log_tables.go
2022/01/19 11:37:24 OK 3_delivery_tables.go
2022/01/19 11:37:24 OK 4_add_queue_info.go
2022/01/19 11:37:24 OK 5_case_insensitive_domains_index.go
2022/01/19 11:37:24 OK 6_index_for_message_id.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 6 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name logtracker service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_tracking.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 2_messageid_log_location.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_wipe_tracking_data.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 4_delete_messageids_table.go service=controlcenter
2022/01/19 11:37:24 OK 1_tracking.go
2022/01/19 11:37:24 OK 2_messageid_log_location.go
2022/01/19 11:37:24 OK 3_wipe_tracking_data.go
2022/01/19 11:37:24 OK 4_delete_messageids_table.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 4 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name master service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_create_meta_table.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 3_rename_localrbl_to_globalsettings.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 4_rename_postfix_ip_setting.go service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 5_index_meta_table.go service=controlcenter
2022/01/19 11:37:24 OK 1_create_meta_table.go
2022/01/19 11:37:24 OK 3_rename_localrbl_to_globalsettings.go
2022/01/19 11:37:24 OK 4_rename_postfix_ip_setting.go
2022/01/19 11:37:24 OK 5_index_meta_table.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 5 service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:197 > Database name rawlogs service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:198 > Applied At Migration service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:199 > ======================================= service=controlcenter
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:229 > Pending -- 1_create_logs_table.go service=controlcenter
2022/01/19 11:37:24 OK 1_create_logs_table.go
2022-01-19T11:37:24Z INF src/lmsqlite3/migrator/migrator.go:86 > no migrations to run. current version: 1 service=controlcenter
2022-01-19T11:37:24Z INF src/insights/engine.go:315 > Waiting for import announcement! service=controlcenter
2022-01-19T11:37:24Z INF src/auth/auth.go:236 > Generated Session key with 32 bytes service=controlcenter
The most important bits in the output are not visible in such output, namely:
2022-01-19T11:37:24Z INF src/main.go:59 > This program comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions; see here for details: https://lightmeter.io/lmcc-license. service=controlcenter
2022-01-19T11:37:24Z INF src/server/server.go:95 > Lightmeter ControlCenter is running on http://[::]:8080 service=controlcenter
Therefore any database related logs from when the application starts should get the log level DEBUG
.
This include the internal goose
output, such as:
2022/01/19 11:37:24 OK 1_insights.go