Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Control » After upgrade to 9. 1 stopped working statistics
  •  
monkluk

Messages: 7
Karma: 0
Send a private message to this user
Hi all.
After upgrade to 9. 1 stopped working statistics.
Error log every second generates messages firebird DB.
Just log Warning bombarded with messages "Cannot list the log. Permission denied".


Someone has idea how to fix this error?



[14/Jul/2016 12:18:43] (335544335) Firebird DB:
[14/Jul/2016 12:18:43] (335544335) Firebird DB: Engine Code : 335544335
[14/Jul/2016 12:18:43] (335544335) Firebird DB: Engine Message :
[14/Jul/2016 12:18:43] (335544335) Firebird DB: database file appears corrupt (/var/winroute/star/data/star.fdb)
[14/Jul/2016 12:18:43] (335544335) Firebird DB: wrong page type
[14/Jul/2016 12:18:43] (335544335) Firebird DB: page 21653 is of wrong type (expected 5, found 0)
[14/Jul/2016 12:18:43] (335544335) Firebird DB:
[14/Jul/2016 13:18:43] (335544335) Unable to purge DB, Firebird DB error message follows:
[14/Jul/2016 13:18:43] (335544335) Firebird DB: *** IBPP::SQLException ***
[14/Jul/2016 13:18:43] (335544335) Firebird DB: Context: Statement::Execute( delete from user_list where not (exists (select first 1 * from DATAINOUT_D where DATAINOUT_D.USER_ID = user_list.USER_ID) or exists (select first 1 * from WEB_ACCESS_AP where WEB_ACCESS_AP.USER_ID = user_list.USER_ID) or exists (select first 1 * from ALL_TOP_WEBS_VISITORS where ALL_TOP_WEBS_VISITORS.USER_ID = user_list.USER_ID) or exists (select first 1 * from GROUP_TOP_WEBS_VISITORS where GROUP_TOP_WEBS_VISITORS.USER_ID = user_list.USER_ID) or exists (select first 1 * from ISS_D where ISS_D.USER_ID = user_list.USER_ID) or exists (select first 1 * from PROTO_D where PROTO_D.USER_ID = user_list.USER_ID) or exists (select first 1 * from USER_TOP_WEBS where USER_TOP_WEBS.USER_ID = user_list.USER_ID) or exists (select first 1 * from APPLICATION_D where APPLICATION_D.USER_ID = user_list.USER_ID) or exists (select first 1 * from WEB_ACCESS_DATA_AP where WEB_ACCESS_DATA_AP.USER_ID = user_list.USER_ID) or exists (select first 1 * from ALL_T
[14/Jul/2016 13:18:43] (335544335) Firebird DB: Message: isc_dsql_execute2 failed
[14/Jul/2016 13:18:43] (335544335) Firebird DB:
[14/Jul/2016 13:18:43] (335544335) Firebird DB: SQL Message : -902
[14/Jul/2016 13:18:43] (335544335) Firebird DB: Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements

[Updated on: Fri, 15 July 2016 00:16]

  •  
monkluk

Messages: 7
Karma: 0
Send a private message to this user
The question was solved Clearing cache and all statistics.
Previous Topic: Application aware routing?
Next Topic: NG100 slowing traffic down
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Tue Dec 06 03:56:58 CET 2016

Total time taken to generate the page: 0.00857 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.