search

emqx / MQTTX

A Powerful and All-in-One MQTT 5.0 client toolbox for Desktop, CLI and WebSocket.
https://mqttx.app
Apache License 2.0
3.64k stars 428 forks source link

[Bug] import backup data report sqlite error #1696

Open zhouding opened 2 weeks ago

zhouding commented 2 weeks ago

What did I do

I got a new computer, so I clicked "Data Backup" and got a JSON file. However, when I tried to import the JSON file using "Data Recovery", I received an error message, indicating that only one MQTT connection was found. In fact, I have 11 connections.

What happened

Get an error. image

Expected

transfer data between two computers

Environment

More detail

More detail include log information or screenshot

ysfscream commented 2 weeks ago

I have tried to backup and restore 11 connections on my side and encountered no issues. Could you please confirm if all your operations were performed within version 1.10.0? Also, the error message in your screenshot needs to be completed. Could you provide a full error message? This would help me understand the issue better and resolve it.

Thank you!

zhouding commented 2 weeks ago

image after“clear history data” ,data backup& data recovery was successful. i guess too much data will caused this problem.

ysfscream commented 2 weeks ago

OK, this BUG might be caused by message data. If you can, let us know how many messages you have pub/sub. We will use this data to reproduce the issue and improve this feature. Thanks!

zhouding commented 2 weeks ago

it's not safe to upload data in public area, so please give me an email address to send.

ysfscream commented 2 weeks ago

@zhouding yusf@emqx.io, thank you for your support and contribution.

I will try to reproduce the issue on my end. Your data will be saved locally and will not be shared anywhere. Once the optimization is complete, I will delete it immediately. Thank you!