after trying to save database for backup i get this

[admin@MikroTik] /tool user-manager database> save
name: backup_nov
Saving user-manager database
Failed to save user-manager database backup
failed to open DB for reading: Value too large for defined data type

Also i notice that 2 times per week user-manager is getting non-responsive .
In database there is 3700 users this is critical if start failing more .
also in session i have 1054453 pages for logs .

Any idea what to do
i'm even afraid to reboot mikrotik
Is miktorik v 3.3 with UM v3

also in session i have 1054453 pages for logs .

Is that 1,054,453 pages? In your router? Maybe running out of memory. Check "/system resource".

Hi

System is ok and very powerfull
not used system resources

Im woried about size of database.
how can i shrink it



[admin@MikroTik] > /system resource print
uptime: 27w1d10h41m33s
version: "3.30"
free-memory: 1919280kB
total-memory: 1945780kB
cpu: "Intel(R)"
cpu-count: 2
cpu-frequency: 1861MHz
cpu-load: 5
free-hdd-space: 235158484kB
total-hdd-space: 240348676kB
write-sect-since-reboot: 737313706
write-sect-total: 737313706
architecture-name: "x86"
board-name: "x86"
[admin@MikroTik] >

Thats the problem. U dont have enough space to save your database.
So u need to delete the logs and sessions via http://ipaddress/userman
then try to save. if this didnt work , you need to clear the cache

How is possible that

free-hdd-space: 235158484kB
total-hdd-space: 240348676kB

this is saying i have a gigabytes free of HDD

is anyway i can do cleaning from terminal
doing from web page will took me ages .

or how to clear cache ?

This is a typo, correct? It just kinda looked like copy-and-paste.

[admin@MikroTik] /tool user-manager database> save

Should be:

[admin@MikroTik] /tool user-manager database save

Just checking...

That is my problem
it wont save

[admin@MikroTik] > /tool user-manager database save
name: bakup3
Saving user-manager database
Failed to save user-manager database backup
failed to open DB for reading: Value too large for defined data type
[admin@MikroTik] >

Question is what to do

Any solution to this i am having the same problem? I have ample resources.