Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to save dashboard Disck image is malformed #33885

Closed
mohan-nagandlla opened this issue May 11, 2021 · 3 comments
Closed

Unable to save dashboard Disck image is malformed #33885

mohan-nagandlla opened this issue May 11, 2021 · 3 comments

Comments

@mohan-nagandlla
Copy link

Hi team,
I am getting error like unable to save dashboard because of disk malformed i just attached the logs of grafana

t=2021-05-10T06:03:02+0000 lvl=eror msg="Failed to save dashboard" logger=context userId=2 orgId=3 uname=user error="database disk image is malformed" remote_addr=y.y.y.y
=2021-05-10T05:55:58+0000 lvl=eror msg="Request Completed" logger=context userId=2 orgId=3 uname=user method=POST path=/api/dashboards/db/ status=500 remote_addr=y.y.y.y time_ms=445 size=38 referer="https://x.x.x.x:port/d/0Tdh_ZjMz/sample-copy?orgId=3&from=now-30m&to=now"
t=2021-05-10T05:56:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T05:56:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:56:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:57:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T05:57:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:57:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:58:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T05:58:09+0000 lvl=eror msg="Failed to save dashboard" logger=context userId=2 orgId=3 uname=user error="database disk image is malformed" remote_addr=y.y.y.y
t=2021-05-10T05:58:09+0000 lvl=eror msg="Request Completed" logger=context userId=2 orgId=3 uname=user method=POST path=/api/dashboards/db/ status=500 remote_addr=y.y.y.y time_ms=40 size=38 referer="https://x.x.x.x:port/d/0Tdh_ZjMz/sample-copy?orgId=3"
t=2021-05-10T05:58:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:58:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:59:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T05:59:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T05:59:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:00:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T06:00:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:00:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:01:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T06:01:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:01:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:02:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T06:02:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:02:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:03:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T06:03:02+0000 lvl=eror msg="Failed to save dashboard" logger=context userId=2 orgId=3 uname=user error="database disk image is malformed" remote_addr=y.y.y.y
t=2021-05-10T06:03:02+0000 lvl=eror msg="Request Completed" logger=context userId=2 orgId=3 uname=user method=POST path=/api/dashboards/db/ status=500 remote_addr=y.y.y.y time_ms=119 size=38 referer="https://x.x.x.x:port/d/GPkyky2ik/flink-metrics?orgId=3&refresh=1m&var-Topics=All&var-Broker=All&var-Zookeeper=All&var-Flink_Job_Name=&var-Source=All&var-Sink=All&var-Node=All"
t=2021-05-10T06:03:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:03:45+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:04:01+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name=NoMessageForTooLong error="tsdb.HandleRequest() error Post \"http://x.x.x.x:port/api/v1/query_range\": dial tcp x.x.x.x:port: connect: connection refused" changing state to=alerting
t=2021-05-10T06:04:15+0000 lvl=info msg="Alert Rule returned no data" logger=alerting.evalContext ruleId=5 name="bufferpool alert" changing state to=no_data
t=2021-05-10T06:04:44+0000 lvl=info msg="Shutdown started" logger=server reason="System signal: terminated"
@torkelo
Copy link
Member

torkelo commented May 11, 2021

Looks like your database file is been corrupted, here is a guide for how to recover https://sqliteviewer.com/blog/database-disk-image-malformed/

@dgsfor
Copy link

dgsfor commented Dec 1, 2022

fixed with this doc :https://alignan.github.io/post/restoring-grafana-db/

@kwenzh
Copy link

kwenzh commented Dec 15, 2022

the same promeblem, Is there a fix planned for which version?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants