odbc logging is low and many test items are hanging

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
chunlan
Posts: 9
Joined: Thu Dec 04, 2008 7:14 pm

odbc logging is low and many test items are hanging

Post by chunlan »

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?
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

The version of hostmonitor I installed is 8.86. logging database is oracle
Its not about HostMonitor version, its about Oracle ODBC driver version.
What Oracle client do you use?
How can I solve this problem?
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.

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
Post Reply