Dude 4.0beta3 database fixed

RouterOS The Dude
1

I’ve had a problem Dude 4.0beta3 database for a year now. dude.db was 419259 KB in size.

Trying the dump to .sql solution caused all my maps to disappear.

Instead, I did the following:

  1. Shutdown dude.exe
  2. Make a backup of dude.db
  3. Use sqlite3 dude.db
  4. sqlite> DELETE FROM outages;
  5. sqlite> DELETE FROM chart_values_raw;
  6. sqlite> DELETE FROM chart_values_10min;
  7. sqlite> DELETE FROM chart_values_2hour;
  8. sqlite> DELETE FROM chart_values_1day;
  9. sqlite> pragma integrity_check;
  10. sqlite> vacuum;
  11. sqlite> reindex;
  12. sqlite> .quit
  13. Start dude.exe again

My dude.db is now 46662 with all maps minus all historic outages and charts. It runs fast.

2

Great. But it should be running fast with all historic data…

3

Nice to know how to clear out the database!

4

I have a problem with my dude , it stop working now when i check the this command here is the result:
/dude print
action timed out - try again, if error continues contact MikroTik support and send a supout file (13)

so i download the database and delete all historic data it reduce the database size from 260MB to 20 MB
but still when i enable the dude and run the /dude print it shows it is loading the record and then it hangs again(check the attachment)

it seems there is a line in database which crashes the dude
when i dump the database i have 43427 records in obj table

anyway thoughts about how i can fix this?

Thank you

5

Sorry to hear that you are having trouble with your Dude install.

Did you try the vacuum command?