[FW-1] Database limit reached

[Maurizio Serra <mserra@FW1-NOSPAMSECURE-EDGE.COM>]

Hello,

I have some problem on my Reporter Server Database :(

I use checkpoint firewall-1 NG FP3 Hotfix2 (distribuited
installation) and smartview-reporting (distribuited installation).

I saw today that the engine consolidator process "ended" September
18 with the error "failed to process current Log record" 'cos the
database size limit was reached (I attach the error log)

============================
Error LOG:
   Fri Sep  5 12:02:54 2003     LEA Filter rulebase registered successfully
   Fri Sep  5 18:44:43 2003     LEA Filter rulebase registered successfully
   Thu Sep 18 10:48:40 2003     Warning:database size has reached 18446 MB,
exceeding 90% of its 20479 MB size limit.
   Thu Sep 18 10:48:40 2003     Warning:database is running out of internal
free space - it has only 40 MB left while it
needs at least 25 MB.
   Thu Sep 18 10:54:19 2003     Error:database is out of internal free
space - it has only 21 MB left while it needs at
least 25 MB.
   Thu Sep 18 10:54:22 2003     Error:database is out of internal free
space - it has only 21 MB left while it needs at
least 25 MB.
   Thu Sep 18 10:54:22 2003     Error:failed to process current Log record
(FileName:fw.log, FileID:, Pos:2793420)
   Thu Oct  2 11:04:59 2003     Extended URL Processing - enabled
   Thu Oct  2 11:04:59 2003     LEA filtering out Floodgate-1 - enabled
============================



I guessed that the database was reached the 24gb limit (i have
modified the solid.ini to increse the database size limit by 4gb.. the
standard is 20gb), but instead, "ONLY" 18gb was occupied...

(i attach the engine adn database error)
=============================================================
Engine and Database status

   Engine current status:                        Starting
   Last command:                                 Install
                                                 (since Thu Oct  2 12:18:35
2003)

   Last startup at:                              Thu Oct  2 11:04:52 2003
   Log records processed since startup:          0 (Stored:0  Ignored:0)
   Currently open consolidated records:          0
   Consolidated records loaded to DB:            0 (Permanent:0
Temporary:0)
   Consolidation rate:                           0%

---Extra information---
Database statistics:
   Database usage:                               100% (Total:18889552 KB
Unoccupied: 26528 KB)
   Database size limit:                          25165823 KB
   Database memory size:                         33847 KB
   Database log size:                            1088 KB

DNS statistics:
   DNS cache size:                               16384 items
   DNS cached items:                             0
   DNS open requests:                            0
   DNS cache hit rate:                           0% (Hits:0  Misses:0)
=================================================================


   This strings say strange something...
   Database usage:                               100% (Total:18889552 KB
Unoccupied: 26528 KB)
   Database size limit:                          25165823 KB

   If the database size limit is 24gb (25165823 KB ) why Reporting
   tool say it is FULL!??!

   Obviously, there are free space on the HD partition...
   Actualy there are 12gb of free space...

   Pls.. help me...

   Now the engine is started, but no log was processed (cos the
   database results full).

   I post the list of the Database directory:

drwx------   6 root     bin         1024 Oct  2 11:04 .
drwxr-x---  11 root     bin          512 Mar  2  2003 ..
drwx------   2 root     bin          512 Sep  3 13:46 Clean_DB
drwx------   2 root     bin          512 Sep  3 13:46 Export
drwx------   2 root     bin          512 Oct  2 13:08 Log
-rw-------   1 root     binOct  2 13:23 RT_Database.db
-rw-------   1 root     other    57565184 Oct  2 13:35 RT_Database10.db
-rw-r--r--   1 root     other          0 Sep 19 17:28 RT_Database11.db
-rw-r--r--   1 root     other          0 Sep 19 17:28 RT_Database12.db
-rw-------   1 root     binSep  9 01:23 RT_Database2.db
-rw-------   1 root     binSep 10 02:20 RT_Database3.db
-rw-------   1 root     binSep 11 15:39 RT_Database4.db
-rw-------   1 root     otherSep 15 16:55 RT_Database5.db
-rw-------   1 root     otherSep 13 16:44 RT_Database6.db
-rw-------   1 root     otherSep 15 22:14 RT_Database7.db
-rw-------   1 root     otherSep 17 13:32 RT_Database8.db
-rw-------   1 root     otherOct  2 12:26 RT_Database9.db
drwx------   2 root     bin         1024 Oct  2 12:42 Sort
-rwx------   1 root     bin       840812 Oct 17  2002 solexp
-rwx------   1 root     bin      2374692 Oct 17  2002 solid
-------rw-   1 root     other        831 Oct  2 11:51 solid.ini
-rw-------   1 root     bin         1317 Oct 17  2002 solid.lic
srwxrwx---   1 root     root           0 Oct  2 11:04 solid1624
srwxrwx---   1 root     root           0 Sep  4 16:55 solid28275
-rwx------   1 root     bin       796204 Oct 17  2002 solload
-rw-r--r--   1 root     other    1051254 Sep 17 12:36 solmsg.bak
-rw-rw----   1 root     root       97991 Oct  2 13:23 solmsg.out

As you can see the RT_Database10.db file is only 57Mb...

Regards

M.

=================================================
To set vacation, Out-Of-Office, or away messages,
send an email to LISTSERV@amadeus.us.checkpoint.com
in the BODY of the email add:
set fw-1-mailinglist nomail
=================================================
To unsubscribe from this mailing list,
please see the instructions at
http://www.checkpoint.com/services/mailing.html
=================================================
If you have any questions on how to change your
subscription options, email
fw-1-owner@ts.checkpoint.com
=================================================