due to a db server issue I had to restore the metabase (mysql) db from a backup last week, all appears to be working, except for the fact that when I try to edit a question the drop downs to do so are not available, as if the question was written in SQL (see screenshots below).. When I click the "View SQL" button I am able to see the questions SQL I've checked the db and the questions are all still defined there. Any suggestions?
Hi @joe_bi3
Which version of Metabase?
Do you see any error in the Metabase log or in the browser console?
Have you restarted Metabase after you restored the metadata database?
The image looks like you don’t have the correct permissions.
Maybe it’s because the database is out-of-sync, so try running force sync via Admin > Databases > (database) > Sync database schema now.
Hi @flamber
Metabase version:0.32.9
I've tried refreshing the database schema with the same results:
On the browser console I'm getting the following:
app-main.bundle.js:5 DEPRECATED: metabase/redux/metadata fetchDatabases
v @ app-main.bundle.js:5
:3000/api/database?include_tables=true&include_cards=true:1 Failed to load resource: the server responded with a status of 500 (Server Error)
app-main.bundle.js:5 Request entities,databases_list,{"include_tables":true,"include_cards":true},fetch failed: Object
(anonymous) @ app-main.bundle.js:5
app-main.bundle.js:5 error fetching dbs Object
(anonymous) @ app-main.bundle.js:5
app-main.bundle.js:5 DEPRECATED: metabase/redux/metadata fetchTableMetadata
v @ app-main.bundle.js:5
I do get an error in the metabase log, see below:
Jul 22 11:34:38 ERROR metabase.middleware.log :: GET /api/database 500 167 ms (5 DB calls) {:message "Unexpected character (':' (code 58)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')\n at [Source: (StringReader); line: 1, column: 2]", :type com.fasterxml.jackson.core.JsonParseException, :stacktrace ("com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:1804)" "com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:669)" "com.fasterxml.jackson.core.base.ParserMinimalBase._reportUnexpectedChar(ParserMinimalBase.java:567)" "com.fasterxml.jackson.core.json.ReaderBasedJsonParser._handleOddValue(ReaderBasedJsonParser.java:1892)" "com.fasterxml.jackson.core.json.ReaderBasedJsonParser.nextToken(ReaderBasedJsonParser.java:747)" "cheshire.parse$parse.invokeStatic(parse.clj:88)" "cheshire.parse$parse.invoke(parse.clj:86)" "cheshire.core$parse_string.invokeStatic(core.clj:206)" "cheshire.core$parse_string.invoke(core.clj:192)" "cheshire.core$parse_string.invokeStatic(core.clj:203)" "cheshire.core$parse_string.invoke(core.clj:192)" "--> models.interface$json_out.invokeStatic(interface.clj:40)" "models.interface$json_out.invoke(interface.clj:37)" "models.interface$json_out_with_keywordization.invokeStatic(interface.clj:46)" "models.interface$json_out_with_keywordization.invoke(interface.clj:43)" "api.database$source_query_cards.invokeStatic(database.clj:111)" "api.database$source_query_cards.invoke(database.clj:108)" "api.database$cards_virtual_tables.invokeStatic(database.clj:125)" "api.database$cards_virtual_tables.doInvoke(database.clj:120)" "api.database$saved_cards_virtual_db_metadata.invokeStatic(database.clj:130)" "api.database$saved_cards_virtual_db_metadata.doInvoke(database.clj:128)" "api.database$add_virtual_tables_for_saved_cards.invokeStatic(database.clj:139)" "api.database$add_virtual_tables_for_saved_cards.invoke(database.clj:138)" "api.database$dbs_list.invokeStatic(database.clj:146)" "api.database$dbs_list.invoke(database.clj:144)" "api.database$fn__49676.invokeStatic(database.clj:157)" "api.database$fn__49676.invoke(database.clj:150)" "middleware.auth$enforce_authentication$fn__61677.invoke(auth.clj:14)" "routes$fn__62814$fn__62815.doInvoke(routes.clj:56)" "middleware.exceptions$catch_uncaught_exceptions$fn__61768.invoke(exceptions.clj:104)" "middleware.exceptions$catch_api_exceptions$fn__61765.invoke(exceptions.clj:92)" "middleware.log$log_api_call$fn__63188$fn__63189.invoke(log.clj:170)" "middleware.log$log_api_call$fn__63188.invoke(log.clj:164)" "middleware.security$add_security_headers$fn__61731.invoke(security.clj:105)" "middleware.json$wrap_json_body$fn__62893.invoke(json.clj:61)" "middleware.json$wrap_streamed_json_response$fn__62911.invoke(json.clj:97)" "middleware.session$bind_current_user$fn__60345$fn__60346.invoke(session.clj:193)" "middleware.session$do_with_current_user.invokeStatic(session.clj:176)" "middleware.session$do_with_current_user.invoke(session.clj:170)" "middleware.session$bind_current_user$fn__60345.invoke(session.clj:192)" "middleware.session$wrap_current_user_id$fn__60334.invoke(session.clj:161)" "middleware.session$wrap_session_id$fn__60319.invoke(session.clj:123)" "middleware.auth$wrap_api_key$fn__61685.invoke(auth.clj:27)" "middleware.misc$maybe_set_site_url$fn__63253.invoke(misc.clj:58)" "middleware.misc$bind_user_locale$fn__63256.invoke(misc.clj:74)" "middleware.misc$add_content_type$fn__63241.invoke(misc.clj:30)" "middleware.misc$disable_streaming_buffering$fn__63278.invoke(misc.clj:119)" "middleware.misc$wrap_gzip$fn__63271.invoke(misc.clj:101)")}
@joe_bi3
Did you shutdown Metabase before restoring metadata? Otherwise I think your backup might be corrupted - try with an older backup.
Metabase was shut down when restoring, yes. I’ll try with an older backup.
Thanks for your help!