Netsight Database Backup Error

  • 0
  • 1
  • Question
  • Updated 4 years ago

Hello,


we have a Problem withe Netsight Database Backup. We got tge following error message, although we have enough space at Netsight Server:

Message:

"Insufficient disk space for Database Backup of 'netsightrpt' to file /usr/local/Enterasys_Networks/NetSight/backup/netsight_20150420.sql.rpt"

Does somebody have an idea?


Brgds Nico


Photo of Nico Willamowski

Nico Willamowski

  • 886 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Ronald Dvorak

Ronald Dvorak, Embassador

  • 51,266 Points 50k badge 2x thumb
Does it work if you disable "backup alarm and reporting database'" ?
Photo of Nico Willamowski

Nico Willamowski

  • 886 Points 500 badge 2x thumb
The normal .SQL file is written. The error is at the .sql.rpt file and that file won ́t be written in the Directory.
Photo of Thomas, Frank

Thomas, Frank, Employee

  • 1,902 Points 1k badge 2x thumb
Could you run df -h?
It'll output something like this
df -h
Filesystem                 Size  Used Avail Use% Mounted on
/dev/mapper/systemvg-root  209G  167G   34G  84% /
udev                        12G  4.0K   12G   1% /dev
tmpfs                      2.4G  292K  2.4G   1% /run
none                       5.0M     0  5.0M   0% /run/lock
none                        12G     0   12G   0% /run/shm
/dev/sda1                  228M   49M  167M  23% /boot

then in /usr/local/Enterasys_Networks/NetSight/backup/ run ls -lah

It'll output something like this:
/usr/local/Enterasys_Networks/NetSight/backup$ ls -lah
total 45G
drwxr-xr-x  8 root root 4.0K Apr 22 00:51 ./
drwxr-xr-x 17 root root 4.0K Mar  6 13:29 ../
drwxr-xr-x  2 root root 4.0K Jul 23  2012 backup/
drwxr-xr-x  5 root root 4.0K Apr 22 00:51 InventoryMgr/
-rw-r--r--  1 root root 439M Apr 19 00:00 netsight_19042015.sql
-rw-r--r--  1 root root  22G Apr 19 00:48 netsight_19042015.sql.rpt
-rw-r--r--  1 root root 441M Apr 22 00:00 netsight_22042015.sql
-rw-r--r--  1 root root  22G Apr 22 00:51 netsight_22042015.sql.rpt
drwxr-xr-x  2 root root 4.0K Dec 17 00:11 OneView/
drwxr-xr-x  2 root root 4.0K Dec 17 00:00 Purview/


So as shown, our reporting database is 22 gigs, when copying the database, the netsight server needs generally wants about double the space in addition to an extra few gigs of spare space, the database is constantly being written to and no space available may result in a crash.