What row is missing?
Does it happen to be user ID 3, the old metabot user? That one was deleted a long time ago.
A bunch of rows are missing from various tables.
Table row counts from source live MySQL database:
Table: DATABASECHANGELOG, Count: 969
Table: DATABASECHANGELOGLOCK, Count: 1
Table: QRTZ_BLOB_TRIGGERS, Count: 0
Table: QRTZ_CALENDARS, Count: 0
Table: QRTZ_CRON_TRIGGERS, Count: 70
Table: QRTZ_FIRED_TRIGGERS, Count: 4
Table: QRTZ_JOB_DETAILS, Count: 20
Table: QRTZ_LOCKS, Count: 2
Table: QRTZ_PAUSED_TRIGGER_GRPS, Count: 0
Table: QRTZ_SCHEDULER_STATE, Count: 6
Table: QRTZ_SIMPLE_TRIGGERS, Count: 2
Table: QRTZ_SIMPROP_TRIGGERS, Count: 0
Table: QRTZ_TRIGGERS, Count: 72
Table: action, Count: 0
Table: api_key, Count: 1
Table: application_permissions_revision, Count: 0
Table: audit_log, Count: 26386
Table: bookmark_ordering, Count: 0
Table: cache_config, Count: 0
Table: card_bookmark, Count: 4
Table: card_label, Count: 0
Table: channel, Count: 0
Table: channel_template, Count: 3
Table: cloud_migration, Count: 0
Table: collection, Count: 1416
Table: collection_bookmark, Count: 0
Table: collection_permission_graph_revision, Count: 46
Table: connection_impersonations, Count: 0
Table: core_session, Count: 275
Table: core_user, Count: 1201
Table: dashboard_bookmark, Count: 0
Table: dashboard_favorite, Count: 38
Table: dashboard_tab, Count: 6
Table: dashboardcard_series, Count: 12
Table: data_permissions, Count: 1171
Table: dependency, Count: 0
Table: dimension, Count: 140
Table: field_usage, Count: 0
Table: http_action, Count: 0
Table: implicit_action, Count: 0
Table: label, Count: 0
Table: login_history, Count: 3206
Table: metabase_cluster_lock, Count: 2
Table: metabase_database, Count: 26
Table: metabase_field, Count: 108493
Table: metabase_fieldvalues, Count: 20729
Table: metabase_table, Count: 11391
Table: metric, Count: 0
Table: metric_important_field, Count: 0
Table: model_index, Count: 0
Table: model_index_value, Count: 0
Table: moderation_review, Count: 0
Table: native_query_snippet, Count: 19
Table: notification, Count: 3
Table: notification_handler, Count: 3
Table: notification_recipient, Count: 4
Table: notification_subscription, Count: 3
Table: parameter_card, Count: 4
Table: permissions, Count: 472
Table: permissions_group, Count: 9
Table: permissions_group_membership, Count: 1349
Table: permissions_revision, Count: 21
Table: persisted_info, Count: 0
Table: pulse, Count: 19
Table: pulse_card, Count: 19
Table: pulse_channel, Count: 17
Table: pulse_channel_recipient, Count: 22
Table: query, Count: 410239
Table: query_action, Count: 0
Table: query_analysis, Count: 0
Table: query_cache, Count: 0
Table: query_execution, Count: 39608
Table: query_field, Count: 0
Table: query_table, Count: 0
Table: recent_views, Count: 532
Table: report_card, Count: 3545
Table: report_cardfavorite, Count: 4
Table: report_dashboard, Count: 785
Table: report_dashboardcard, Count: 5086
Table: revision, Count: 20708
Table: sandboxes, Count: 0
Table: search_index_metadata, Count: 0
Table: secret, Count: 0
Table: segment, Count: 2
Table: setting, Count: 45
Table: table_privileges, Count: 342
Table: task_history, Count: 104060
Table: timeline, Count: 0
Table: timeline_event, Count: 0
Table: user_key_value, Count: 4
Table: user_parameter_value, Count: 28
Table: v_alerts, Count: 19
Table: v_audit_log, Count: 26386
Table: v_content, Count: 5746
Table: v_dashboardcard, Count: 5086
Table: v_databases, Count: 26
Table: v_fields, Count: 108493
Table: v_group_members, Count: 1350
Table: v_query_log, Count: 39608
Table: v_subscriptions, Count: 0
Table: v_tables, Count: 11391
Table: v_tasks, Count: 104074
Table: v_users, Count: 1202
Table: v_view_log, Count: 1905418
Table: view_log, Count: 1905418
Table row counts from target Postgres database:
schema_name | table_name | exact_row_count
-------------+--------------------------------------+-----------------
public | action | 0
public | api_key | 0
public | application_permissions_revision | 0
public | audit_log | 0
public | bookmark_ordering | 0
public | cache_config | 0
public | card_bookmark | 0
public | card_label | 0
public | channel | 0
public | channel_template | 0
public | cloud_migration | 0
public | collection | 1
public | collection_bookmark | 0
public | collection_permission_graph_revision | 0
public | connection_impersonations | 0
public | content_translation | 0
public | core_session | 0
public | core_user | 1
public | dashboard_bookmark | 0
public | dashboard_favorite | 0
public | dashboard_tab | 0
public | dashboardcard_series | 0
public | data_permissions | 0
public | databasechangelog | 530
public | db_router | 0
public | dependency | 0
public | dimension | 0
public | field_usage | 0
public | http_action | 0
public | implicit_action | 0
public | label | 0
public | login_history | 0
public | metabase_cluster_lock | 0
public | metabase_database | 0
public | metabase_field | 0
public | metabase_field_user_settings | 0
public | metabase_fieldvalues | 0
public | metabase_table | 0
public | metabot | 2
public | metabot_conversation | 0
public | metabot_entity | 0
public | metabot_message | 0
public | metabot_prompt | 0
public | metric | 0
public | metric_important_field | 0
public | model_index | 0
public | model_index_value | 0
public | moderation_review | 0
public | native_query_snippet | 0
public | notification | 0
public | notification_card | 0
public | notification_handler | 0
public | notification_recipient | 0
public | notification_subscription | 0
public | parameter_card | 0
public | permissions | 5
public | permissions_group | 2
public | permissions_group_membership | 1
public | permissions_revision | 0
public | persisted_info | 0
public | pulse | 0
public | pulse_card | 0
public | pulse_channel | 0
public | pulse_channel_recipient | 0
public | qrtz_blob_triggers | 0
public | qrtz_calendars | 0
public | qrtz_cron_triggers | 0
public | qrtz_fired_triggers | 0
public | qrtz_job_details | 0
public | qrtz_locks | 2
public | qrtz_paused_trigger_grps | 0
public | qrtz_scheduler_state | 1
public | qrtz_simple_triggers | 0
public | qrtz_simprop_triggers | 0
public | qrtz_triggers | 0
public | query | 0
public | query_action | 0
public | query_cache | 0
public | query_execution | 0
public | query_field | 0
public | query_table | 0
public | recent_views | 0
public | report_card | 0
public | report_cardfavorite | 0
public | report_dashboard | 0
public | report_dashboardcard | 0
public | revision | 0
public | sandboxes | 0
public | search_index_metadata | 0
public | secret | 0
public | segment | 0
public | setting | 1
public | table_privileges | 0
public | task_history | 0
public | timeline | 0
public | timeline_event | 0
public | user_key_value | 0
public | user_parameter_value | 0
public | view_log | 0
(99 rows)
As you can see most of the tables in the imported Postgres database are empty, which is my concern.
Looks like the copy failed somewhere along the way then. Review the logs and figure out what happened.
Ok, I will review the logs again.