when I user odbc logging with full option, it seems the logging becomes low after some hours running. And syslog there are many logs like
"
2011-8-16 19:56:03 Warning: Logging performance is not high enough considering average test frequency
2011-8-16 20:06:17 Warning: Logging performance is very low considering average test frequency
2011-8-16 20:16:30 Warning: Logging performance is very low considering average test frequency
2011-8-16 20:26:43 Warning: Logging performance is very low considering average test frequency
2011-8-16 20:36:58 Warning: Logging performance is very low considering average test frequency
"
In this time many test are hanging there.
And also I see many TIME_WAIT connections on my hostmonitor machine.
The version of hostmonitor I installed is 8.86. logging database is oracle.
How can I solve this problem?
odbc logging is low and many test items are hanging
Its not about HostMonitor version, its about Oracle ODBC driver version.The version of hostmonitor I installed is 8.86. logging database is oracle
What Oracle client do you use?
The best solution - remove that Oracle! They have so many bugs in ODBC drivers - hundreds of bugs and dozens of them are critical, like bugs that cause memory leak, 100% cpu usage, access vialotion errors, etc.How can I solve this problem?
If you cannot remove oracle and install some other database (e.g. MSSQL - they made bugs in ODBC drivers from time to time as well but not so many), try to install Oracle client 9.2.0.8.0, probably this is the most stable one.
Regards
Alex