VSCode Extension doesn't show studies / Optuna Dashboard fails with `UnicodeDecodeError` about optuna-dashboard HOT 10 CLOSED

1. I made on anyway, but feel free to reject if you are not happy with it #800

2. VS Code extension: v0.2.0 / VS Code: 1.84.2

from optuna-dashboard.

Don't think so, or at least not directly related as I tried several times even after reinstalling the extension and using vscode & codium. But maybe the os restart helped. Maybe also a browser cache problem (?)

from optuna-dashboard.

Update: As i wake up this morning, opening the same sqlite db with the vscode extension (still v0.2.0) suddenly works. I have no idea why, probably the Browser-only version has changed?

from optuna-dashboard.

@turbotimon
ok! I will review it soon. Thank you.

from optuna-dashboard.

@turbotimon Thank you for your report!

For using optuna-dashboard (Python library), you need to specify the SQLAlchemy's database url as follows:

$ optuna-dashboard sqlite:///nbs/example-study.db 

However, regarding the VS Code extension, there might be a bug. The VS Code extension internally utilizes the browser-only version of Optuna Dashboard, which is accessible at https://optuna.github.io/optuna-dashboard/.

Could you please try dragging and dropping your SQLite3 file onto https://optuna.github.io/optuna-dashboard/? Note that this website is hosted on GitHub pages and does not upload your SQLite3 file to an external server. Instead, it simply loads the Optuna studies using SQLite3.wasm and displays the optimization history in graphs and tables.

Once you've done that, could you share any error traces from the Google Chrome's developer console?

from optuna-dashboard.

Hi @c-bata, thanks for your quick reply 🚀

1. optuna-dashboard sqlite:///...: Sorry, my bad 🥴 But i'm guessing im not the only stupid, so maybe a meaningful error message would help? Maybe this would be a good-first-issue?

2. dragging and dropping your SQLite3 file onto https://optuna.github.io/optuna-dashboard/: This works fine without an error and i can see my study. Is there another way to narrow down the problem? I tried to reinstall the extension and also tried out vscodium, but same behaviour..

from optuna-dashboard.

optuna-dashboard sqlite:///...: Sorry, my bad 🥴 But I'm guessing I'm not the only one, so a more meaningful error message might help? Maybe this would be a good-first-issue?

I agree, It's so confusing. We will work on it since it doesn't seems to be a good-first-issue actually. Thank you for your suggestion!

dragging and dropping your SQLite3 file onto https://optuna.github.io/optuna-dashboard/: This works fine without an error and I can see my study. Is there another way to narrow down the problem? I tried to reinstall the extension and also tried out vscodium, but the behaviour is the same..

Hmm... I'm not sure, but it's possible that there is a following problem in the VS Code extension.

Please note that we have confirmed the behavior of the code-server extension can be unstable. When opening SQLite files, the dashboard might not appear on the first attempt, but should display upon a second try.
https://optuna-dashboard.readthedocs.io/en/latest/getting-started.html#vs-code-and-code-server-extension-experimental

Could you provide the following two information?

1. VS Code version: (e.g. Version: 1.85.2 (Universal)).
2. Version of the Optuna VS Code extension: (e.g. 0.1.0 or 0.2.0).

from optuna-dashboard.

Thank you for letting me know! I'm not sure, but it might be related to #756.

from optuna-dashboard.

@turbotimon
In that case, do we still need to merge #800 ?

from optuna-dashboard.

@keisuke-umezawa i would recommend. I mixed up two issues in this issue because i initially thought they were related (but aren't)

1. Vscode plugin didn't showed studies -> solved
2. cli command optuna-dashboard example.db fails because sqlite prefix is missing -> This is not a bug but I suppose that lot of users will fall for that trap so the merge will improve user experience #800

from optuna-dashboard.