Could not execute query - unable to open database file: out of memory (14)

[pseudozach]

Describe the bug I'm able to successfully import a 2MB+ sqlite3 db file into grafana. But when I try to run a basic query, I get this error:

logger=plugin.frser-sqlite-datasource t=2022-11-16T06:34:44.612548514Z level=error msg="Could not execute query" err="unable to open database file: out of memory (14)" query="select * from apipayments;"

To Reproduce Steps to reproduce the behavior:

1. run grafana with docker, bind a local file to the docker with -v
2. install this plugin
3. setup a panel using the sqlite3 file
4. See error

Screenshots

Versions (please complete the following information):

• OS: debian 10
• Run via docker? yes
• Browser chrome
• Grafana Version 9.3.0-beta1
• Plugin Version 3.1.0
• Plugin installed via grafana-cli or manually? from GUI

Additional context VM has 64GB RAM so there's plenty of memory available.

[fr-ser]

Interesting behavior indeed. Do you see the same for older versions of Grafana? And do you have a full debug level log to check?

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.