Metabase Actions saved and api works successfully.But the added action cannot be saw on the page.
version is 0.49.6
action 404 appears
action 404 appears
{
"browser-info": {
"language": "zh-CN",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.22+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7",
"os.name": "Linux",
"os.version": "3.10.0-1160.105.1.el7.x86_64",
"user.language": "en",
"user.timezone": "Asia/Shanghai"
},
"metabase-info": {
"databases": [
"h2",
"postgres",
"csv"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "16.0"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
}
},
"run-mode": "prod",
"version": {
"date": "2024-04-16",
"tag": "v0.49.6",
"hash": "5abf130"
},
"settings": {
"report-timezone": null
}
}
}
This appears when upgrade from 0.89.11 to 0.96.6 and downgrade from 0.96.6 to 0.89.11.
When i finished upgrade and downgrade, create action cannot works in origin version.
what versions are those?
This appears when upgrade from 0.89.11 to 0.96.6 and downgrade from 0.96.6 to 0.89.11.
I found the table （action） structure is not consistent, guess it might be related to this issue
The thing is that we are on version 0.49.7 so I am not sure what 0.89.11 to 0.96.6 are
It was a handwriting mistake. Actually, they were 0.48.11 and 0.49.6
i cannot upload pictures, but i found some suspicious points.
i compaed and found the structure of table 'action' is not consistent. field 'archived' lost nullable and default property, and foreign key 'fk_query_action_ref_action_id' and 'fk_report_dashboardcard_ref_action_id' were disappeared.
Disappeared? Can you check the DATABASECHANGELOG in the Application table. Those changes should be expected if those ran:
id | author | filename | dateexecuted | orderexecuted | exectype | md5sum |
description |
comments | tag | liquibase | contexts | labels | deployment_id
------------+---------------+---------------------------------------+----------------------------+---------------+----------+------------------------------------+---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------+-----+-----------+----------+--------+---------------
v48.00-067 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 15:01:41.24987 | 210 | MARK_RAN | 8:e7cd8168533c58c865dacf320e819218 | addUniqueConstraint constraintName=idx_databasechangelog_id_author_filename, tableName
=databasechangelog | Add unique constraint idx_databasechangelog_id_author_filename
| | 4.21.1 | | | 3596501011
v48.00-061 | piranha | migrations/001_update_migrations.yaml | 2024-04-20 15:01:41.243263 | 209 | EXECUTED | 8:9b9939aad6ca12f7cf4dfa85dae6eb1c | addColumn tableName=query_execution
| Adds query_execution.cache_hash -> query_cache.query_hash
| | 4.21.1 | | | 3596501011
v48.00-060 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:41.235836 | 208 | EXECUTED | 8:a59027f5494811033ce77cd0ba05d6bd | createIndex indexName=idx_task_history_started_at, tableName=task_history
| Added 0.48.0 - task_history.started_at
| | 4.21.1 | | | 3596501011
v48.00-059 | qwef | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.167823 | 207 | EXECUTED | 8:fd8b5031dbbf69c4588ce2699eb20f33 | sql
| Update the namespace of any audit collections that are already loaded
| | 4.21.1 | | | 3596463722
v48.00-057 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.164209 | 206 | EXECUTED | 8:8e32153df1031ea12005d58ce1674873 | addColumn tableName=view_log
| Adjust view_log schema for Audit Log v2
| | 4.21.1 | | | 3596463722
v48.00-056 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.160841 | 205 | EXECUTED | 8:229e8058cc8309053b344bbfdb042405 | addColumn tableName=view_log
| Adjust view_log schema for Audit Log v2
| | 4.21.1 | | | 3596463722
v48.00-055 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.156933 | 204 | EXECUTED | 8:fd36092d50982fbf31ce16757c16e47e | sqlFile path=instance_analytics_views/tasks/v1/postgres-tasks.sql; sqlFile path=instan
ce_analytics_views/tasks/v1/mysql-tasks.sql; sqlFile path=instance_analytics_views/tasks/v1/h2-tasks.sql | Added 0.48.0 - new view v_tasks
| | 4.21.1 | | | 3596463722
v48.00-054 | escherize | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.151445 | 203 | EXECUTED | 8:d41d8cd98f00b204e9800998ecf8427e | empty
| Added 0.48.0 - no-op migration to remove Internal Metabase User on downgrade
| | 4.21.1 | | | 3596463722
v48.00-053 | johnswanson | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.149686 | 202 | EXECUTED | 8:8b41162170f6d712871b2ee9221adc1a | modifyDataType columnName=model, tableName=activity
| Increase length of activity.model to fit longer model names
| | 4.21.1 | | | 3596463722
v48.00-051 | calherries | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.143377 | 201 | EXECUTED | 8:5f5d1fd5b6153a6613511fd8f765737d | sql; sql
| Migrate metabase_field when the fk target field is inactive
| | 4.21.1 | | | 3596463722
v48.00-050 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.138828 | 200 | EXECUTED | 8:d41d8cd98f00b204e9800998ecf8427e | empty
| Added 0.48.0 - no-op migration to remove audit DB and collection on downgrade
| | 4.21.1 | | | 3596463722
v48.00-049 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.136934 | 199 | EXECUTED | 8:853f2a24c53470bf2d9e85b1246bab7b | sql; sql; sql
| Migrate data from activity to audit_log
| | 4.21.1 | | | 3596463722
v48.00-048 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.133118 | 198 | EXECUTED | 8:872e632a8ffa42eb2969f77823e8bfc8 | addForeignKeyConstraint baseTableName=recent_views, constraintName=fk_recent_views_ref
_user_id, referencedTableName=core_user | Add foreign key on recent_views with onDelete CASCADE
| | 4.21.1 | | | 3596463722
v48.00-047 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.127992 | 197 | EXECUTED | 8:2b18bed0e1ae18dd7b26a0770dac54c0 | dropForeignKeyConstraint baseTableName=recent_views, constraintName=fk_recent_views_re
f_user_id | Drop foreign key on recent_views so that it can be recreated with onDelete policy
| | 4.21.1 | | | 3596463722
v48.00-046 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.123058 | 196 | EXECUTED | 8:4bb11295621890202e066cd15de93a52 | sqlFile path=instance_analytics_views/indexes/v1/postgres-indexes.sql; sqlFile path=in
stance_analytics_views/indexes/v1/mysql-indexes.sql; sqlFile path=instance_analytics_views/indexes/v1/mariadb-indexes.sql; sqlFile path=instance_analytics_views/... | Added 0.48.0 - new indexes to optimize audit v2 queries
| | 4.21.1 | | | 3596463722
v48.00-045 | qwef | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.106283 | 195 | EXECUTED | 8:874f14ae26d742448d8dd2b47dc8aa3d | addColumn tableName=query_execution
| Added 0.48.0 - add is_sandboxed to query_execution
| | 4.21.1 | | | 3596463722
v48.00-040 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.102605 | 194 | EXECUTED | 8:b8842eac1c7cba6e997d4d288306e36c | sqlFile path=instance_analytics_views/view_log/v1/postgres-view_log.sql; sqlFile path=
instance_analytics_views/view_log/v1/mysql-view_log.sql; sqlFile path=instance_analytics_views/view_log/v1/h2-view_log.sql | Added 0.48.0 - new view v_view_log
| | 4.21.1 | | | 3596463722
v48.00-039 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.097603 | 193 | EXECUTED | 8:b43481a01df86830c4cb1adb8189d400 | sqlFile path=instance_analytics_views/tables/v1/postgres-tables.sql; sqlFile path=inst
ance_analytics_views/tables/v1/mysql-tables.sql; sqlFile path=instance_analytics_views/tables/v1/h2-tables.sql | Added 0.48.0 - new view v_tables
| | 4.21.1 | | | 3596463722
v48.00-038 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.091727 | 192 | EXECUTED | 8:a24f4bcd3336e79d1c8ef33ab81c0db3 | sqlFile path=instance_analytics_views/query_log/v1/postgres-query_log.sql; sqlFile pat
h=instance_analytics_views/query_log/v1/mysql-query_log.sql; sqlFile path=instance_analytics_views/query_log/v1/h2-query_log.sql | Added 0.48.0 - new view v_query_log
| | 4.21.1 | | | 3596463722
v48.00-037 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.08537 | 191 | EXECUTED | 8:a4b6ebd594b4663a6a888211f36ce6c3 | sqlFile path=instance_analytics_views/fields/v1/postgres-fields.sql; sqlFile path=inst
ance_analytics_views/fields/v1/mysql-fields.sql; sqlFile path=instance_analytics_views/fields/v1/h2-fields.sql | Added 0.48.0 - new view v_fields
| | 4.21.1 | | | 3596463722
v48.00-036 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.079133 | 190 | EXECUTED | 8:8a35e1bdf0738ccac5da8062d6671dd0 | sqlFile path=instance_analytics_views/databases/v1/databases.sql
| Added 0.48.0 - new view v_databases
| | 4.21.1 | | | 3596463722
v48.00-035 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.072668 | 189 | EXECUTED | 8:c0276764af3e1b4b5b0c4e5fdc979e60 | sqlFile path=instance_analytics_views/alerts/v1/postgres-alerts.sql; sqlFile path=inst
ance_analytics_views/alerts/v1/mysql-alerts.sql; sqlFile path=instance_analytics_views/alerts/v1/h2-alerts.sql | Added 0.48.0 - new view v_alerts
| | 4.21.1 | | | 3596463722
v48.00-034 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.064458 | 188 | EXECUTED | 8:1c268d93ce69eaee11e3ecdf9951449a | sqlFile path=instance_analytics_views/users/v1/postgres-users.sql; sqlFile path=instan
ce_analytics_views/users/v1/mysql-users.sql; sqlFile path=instance_analytics_views/users/v1/h2-users.sql | Added 0.48.0 - new view v_users
| | 4.21.1 | | | 3596463722
v48.00-033 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.058843 | 187 | EXECUTED | 8:7ac57373a0fba4bd9613c242702c863d | sqlFile path=instance_analytics_views/subscriptions/v1/postgres-subscriptions.sql; sql
File path=instance_analytics_views/subscriptions/v1/mysql-subscriptions.sql; sqlFile path=instance_analytics_views/subscriptions/v1/h2-subscriptions.sql | Added 0.48.0 - new view v_subscriptions for postgres
| | 4.21.1 | | | 3596463722
v48.00-032 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.05126 | 186 | EXECUTED | 8:64d52462def7bb6981a3b6a40d42e67e | sqlFile path=instance_analytics_views/group_members/v1/group_members.sql
| Added 0.48.0 - new view v_group_members
| | 4.21.1 | | | 3596463722
v48.00-031 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.04579 | 185 | EXECUTED | 8:721bedb0dd362793a1a216cf3e552f3b | sqlFile path=instance_analytics_views/dashboardcard/v1/dashboardcard.sql
| Added 0.48.0 - new view v_dashboardcard
| | 4.21.1 | | | 3596463722
v48.00-030 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.039595 | 184 | EXECUTED | 8:965d6479698fe55f2f6799be552b5edb | sqlFile path=instance_analytics_views/content/v1/postgres-content.sql; sqlFile path=in
stance_analytics_views/content/v1/mysql-content.sql; sqlFile path=instance_analytics_views/content/v1/h2-content.sql | Added 0.48.0 - new view v_content
| | 4.21.1 | | | 3596463722
v48.00-029 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:04.014429 | 183 | EXECUTED | 8:1994760ab0950e7f591c40e887295e1a | sqlFile path=instance_analytics_views/audit_log/v1/postgres-audit_log.sql; sqlFile pat
h=instance_analytics_views/audit_log/v1/mysql-audit_log.sql; sqlFile path=instance_analytics_views/audit_log/v1/h2-audit_log.sql | Added 0.48.0 - new view v_audit_log
| | 4.21.1 | | | 3596463722
v48.00-028 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:01:03.983104 | 182 | EXECUTED | 8:818119252c2e7877bbf46aec40fab160 | createTable tableName=audit_log
| Add new audit_log table
| | 4.21.1 | | | 3596463722
v48.00-027 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.772897 | 181 | EXECUTED | 8:41eae119438c45330e25e193f5936f6b | sql
| No op migration
| | 4.21.1 | | | 3596419524
v48.00-026 | lbrdnk | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.763218 | 180 | EXECUTED | 8:7c8330e861c16997780a9b0881144b26 | update tableName=metabase_field
| Set semantic_type with value type/Number to null (#18754)
| | 4.21.1 | | | 3596419524
v48.00-025 | piranha | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.759203 | 179 | EXECUTED | 8:a2fa9ab0913b9e4b97dff91f973344d6 | addColumn tableName=revision
| Revisions store Metabase version used to create them
| | 4.21.1 | | | 3596419524
v48.00-024 | piranha | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.755431 | 178 | EXECUTED | 8:fab2a51d73c66cea059d55a6fea8bb2f | dropTable tableName=data_migrations
| All data migrations were transferred to custom_migrations!
| | 4.21.1 | | | 3596419524
v48.00-023 | piranha | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.750524 | 177 | MARK_RAN | 8:f18e5e053b508aab0bdd8c4bf1d7de4b | customChange
| Data migration migrate-remove-admin-from-group-mapping-if-needed
| | 4.21.1 | | | 3596419524
v48.00-022 | johnswanson | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.748066 | 176 | MARK_RAN | 8:0f034d06b1ad5336c3c81b0d22cde259 | customChange
| Migrate migrate-click-through to a custom migration
| | 4.21.1 | | | 3596419524
v48.00-021 | piranha | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.744212 | 175 | EXECUTED | 8:a1543239e39c70dc9bab3bbc303242b1 | addColumn tableName=report_card
| Cards store Metabase version used to create them
| | 4.21.1 | | | 3596419524
v48.00-020 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.73976 | 174 | EXECUTED | 8:2c410019e1834304131ff57278003d35 | createIndex indexName=idx_recent_views_user_id, tableName=recent_views
| Added 0.48.0 - Create recent_views.user_id index
| | 4.21.1 | | | 3596419524
v48.00-019 | nemanjaglumac | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.734575 | 173 | EXECUTED | 8:c3866a4b7cfbb49d4b626dc2fd750935 | dropColumn columnName=color, tableName=collection
| Collection color is removed in 0.48.0
| | 4.21.1 | | | 3596419524
v48.00-018 | noahmoss | migrations/001_update_migrations.yaml | 2024-04-20 15:00:19.727866 | 172 | EXECUTED | 8:efae52e7403f39c1458f53e885b4393d | createTable tableName=recent_views
| Add new recent_views table
| | 4.21.1 | | | 3596419524
v48.00-016 | calherries | migrations/001_update_migrations.yaml | 2024-04-20 14:59:23.235074 | 171 | EXECUTED | 8:ea2cb901edad5cf3a1250bdd2a9b0866 | modifyDataType columnName=slug, tableName=collection
| Added 0.48.0 - Change the type of collection.slug to varchar(510)
| | 4.21.1 | | | 3596363006
v48.00-015 | calherries | migrations/001_update_migrations.yaml | 2024-04-20 14:59:23.205788 | 170 | EXECUTED | 8:6f58cf60c8048bb39bbf6128058ff85e | createIndex indexName=idx_table_privileges_role, tableName=table_privileges
| Added 0.48.0 - Create table_privileges.role index
| | 4.21.1 | | | 3596363006
v48.00-014 | calherries | migrations/001_update_migrations.yaml | 2024-04-20 14:58:46.063507 | 169 | EXECUTED | 8:b2c1361f1dc14c2390a1dc25a4a86311 | createIndex indexName=idx_table_privileges_table_id, tableName=table_privileges
| Added 0.48.0 - Create table_privileges.table_id index
| | 4.21.1 | | | 3596325873
v48.00-013 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 14:54:41.278439 | 168 | EXECUTED | 8:145eb766e2d49e95f31d8a08df8ff776 | sql
| Index unindexed FKs for postgres
| | 4.21.1 | | | 3596081019
v48.00-011 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.612222 | 167 | EXECUTED | 8:65ef87949a7e9555fabaf69069806ee0 | createIndex indexName=idx_revision_most_recent, tableName=revision
| Index revision.most_recent
| | 4.21.1 | | | 3584533221
v48.00-010 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.607068 | 166 | MARK_RAN | 8:da6117039b6e0249b710cc3160af982d | sql
| Remove ON UPDATE for revision.timestamp on mysql, mariadb
| | 4.21.1 | | | 3584533221
v48.00-009 | calherries | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.60558 | 165 | EXECUTED | 8:dfd90256380263274ea7f5cc0c5ed413 | createTable tableName=table_privileges
| Added 0.48.0 - Create table_privileges table
| | 4.21.1 | | | 3584533221
v48.00-008 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.583192 | 164 | EXECUTED | 8:c0a512701d6dfd5cc1c4a689919be074 | sql; sql
| Set revision.most_recent = true for latest revisions
| | 4.21.1 | | | 3584533221
v48.00-007 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.56318 | 163 | EXECUTED | 8:15d05ceba05e5b7d25d351fb6ec5b100 | addColumn tableName=revision
| Added 0.48.0 - Add revision.most_recent
| | 4.21.1 | | | 3584533221
v48.00-006 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.532522 | 162 | EXECUTED | 8:cf1413241565a186bf98eece35d519bf | createIndex indexName=idx_query_execution_action_id, tableName=query_execution
| Added 0.48.0 - Index query_execution.action_id
| | 4.21.1 | | | 3584533221
v48.00-005 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.521864 | 161 | EXECUTED | 8:a570f2e1d90a302bc207c00e3776eaaf | addColumn tableName=query_execution
| Added 0.48.0 - Add query_execution.action_id
| | 4.21.1 | | | 3584533221
v48.00-004 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.51611 | 160 | MARK_RAN | 8:d0b1d7cc179c332b7e31f065325b7275 | dropTable tableName=computation_job
| Added 0.48.0 - drop computation_job table
| | 4.21.1 | | | 3584533221
v48.00-003 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.498096 | 159 | MARK_RAN | 8:da33cde0f1f93eed56c0f6d9ac2007df | dropTable tableName=computation_job_result
| Added 0.48.0 - drop computation_job_result table
| | 4.21.1 | | | 3584533221
v48.00-002 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.474538 | 158 | EXECUTED | 8:deceb81591f51f2d7253976f247e36cc | dropColumn columnName=options, tableName=metabase_database
| Added 0.47.0 - drop metabase_database.options
| | 4.21.1 | | | 3584533221
v48.00-001 | qnkhuat | migrations/001_update_migrations.yaml | 2024-04-20 11:42:13.467644 | 157 | EXECUTED | 8:c38ceb502af7907aed614f17da6c3f80 | customChange
| Added 0.47.0 - Migrate database.options to database.settings
| | 4.21.1 | | | 3584533221
I am not sure what happened but you mentioned you upgraded form 48 to 49 but yet i see no 49 migrations applied to your Database .. .Did you restored some backup back to 48?