Do not save question

1

Hi
What is this error?

[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 DEBUG metabase.async.util metabase.api.card$save_new_card_async_BANG_$fn__47719@250b5904を複数のスレッドで実行中...
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 ERROR metabase.async.util metabase.api.card$save_new_card_async_BANG_$fn__47719@250b5904の実行中にエラーが発生しました

image
image1738×954 73.4 KB

2

Hi @yuuuuuuuji
Which version of Metabase?
Which database are you using for metadata?
Do you see other errors? The error is Caught error running {0}, which doesn’t give any hints to what the problem could be.

3

HI @flamber

Thank you for reply.

sorry.

Version:v0.33.0
database:mysql

there is no other error.

[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:29+09:00 DEBUG metabase.middleware.log POST /api/dataset 200 [ASYNC: completed] 3.9 s (15 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 DEBUG metabase.async.util metabase.api.card$save_new_card_async_BANG_$fn__47719@250b5904を複数のスレッドで実行中…
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 ERROR metabase.async.util metabase.api.card$save_new_card_async_BANG_$fn__47719@250b5904の実行中にエラーが発生しました
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:01:51+09:00 DEBUG metabase.middleware.log POST /api/card 200 [ASYNC: completed] 250.9 ms (35 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[b3c2f808-2e27-4170-9ba8-c70db7a21336] 2019-09-24T14:02:04+09:00 DEBUG metabase.middleware.log GET /api/session/properties 200 2.4 ms (1 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (50 total active threads) Queries in flight: 0

Umm,i will find any hints…

4

@yuuuuuuuji
Latest release is 0.33.3
I have a feeling that you’re not using utf8mb4 as charset/collation for the database/tables/columns, so make sure they’re all using that - and that should fix your problem.
https://github.com/metabase/metabase/issues/10691
https://stackoverflow.com/questions/34165523/error-1366-hy000-incorrect-string-value-xf0-x9f-x98-x9c-for-column-comme

5

@flamber

I downgraded metabase because other bug
(Changing the visualization method makes the time display strange)

mysql> show variables like “chara%”
-> ;
±-------------------------±------------------------------------------+
| Variable_name | Value |
±-------------------------±------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /rdsdbbin/mysql-5.7.22.R5/share/charsets/ |
±-------------------------±------------------------------------------+

is this?

6

@yuuuuuuuji
Run the commands that I have listed in https://github.com/metabase/metabase/issues/10691
And no, utf8 is not the same as utf8mb4 - specially not, when you’re using Japanese characters.

7

OK,Thank you.