Hi,
ROS 6.44.3 on CHR
How to do vacuuming right?
Does DB will reduce in it size after vacuuming?

There is only one vacuum command available so you cannot make a mistake. But it might not help at all. You have to try...

There is only one vacuum command available so you cannot make a mistake. But it might not help at all. You have to try...

I did it. But it have to "eat" up to 1GB of system partition. Not Dude disk.
And finishes without any status info.
Database sill >3.5GB

Maybe I need to transfer db-file to x86 pc and do some other actions on it?

Try this.
viewtopic.php?f=8&t=138716&sid=ee6e1c12 ... da#p736644

Try this.
viewtopic.php?f=8&t=138716&sid=ee6e1c12 ... da#p736644

Does it applicable for >6.41 dude installations?

Sure. There is no change in dude for ages because mikrotik doesn't have available capacities. So the difference between the versions is just the number.

Hi,

To purge all historical data and only keep the devices / network maps this works.
Just performed the purge on 6.49, zero issues after cleaning. My results are: 615MBytes -> 1.2MBytes

First download SQLLite3 prebuild for your OS: https://www.sqlite.org/index.html

Stop the dude service, wait for it to finish stopping, it can take awhile, then download dude.db to a local folder.
Place sqlite3.exe in the same folder as you downloaded dude.db.

Src: http://www.mtin.net/blog/cleaning-the-dude-database/
Rename old dude.db to dude.db.orig and upload the now smaller dude.db back to the server/CHR/routerboard and start the service again.

interesting, thank you for sharing

VACUUM do not do already all?

pragma integrity_check;
vacuum;
reindex;

VACUUM do not do already all?

pragma integrity_check;
vacuum;
reindex;

Of course VACUUM does NOT delete valid data in tables, whether or not anybody considers it unwanted.

I'm talking about last 3 lines, not all the other "delete" lines

Hi,

To fix a corrupt Dude instance, e.g. ran out of space.

First download SQLLite3 prebuild for your OS: https://www.sqlite.org/index.html

Stop the dude service, wait for it to finish stopping, it can take awhile, then download dude.db to a local folder.
Place sqlite3.exe in the same folder as you downloaded dude.db. e.g. C:\SqlLite3\
Copy dude.sql to /tmp/ on a linux host
Copy objs.sql to C:\SqlLite3\ on your windows host
Create a clean empty dude.db, by deleting the original from the dude server and starting the server, then stop the server and copy the fresh dude.db to C:\SqlLite3\
Last copy dude.db to /dude/ on routeros and start the server.

thank you again for sharing

Might as well document the process. Cant be the first, nor the last to run into these issues