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:1063835558, 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 bin 2147475456 Oct 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 bin 2147475456 Sep 9 01:23 RT_Database2.db
-rw------- 1 root bin 2147475456 Sep 10 02:20 RT_Database3.db
-rw------- 1 root bin 2147475456 Sep 11 15:39 RT_Database4.db
-rw------- 1 root other 2147475456 Sep 15 16:55 RT_Database5.db
-rw------- 1 root other 2147475456 Sep 13 16:44 RT_Database6.db
-rw------- 1 root other 2147475456 Sep 15 22:14 RT_Database7.db
-rw------- 1 root other 2147475456 Sep 17 13:32 RT_Database8.db
-rw------- 1 root other 2147475456 Oct 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 [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
=================================================
