Ad Widget

Collapse

DBforBIX

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zaicnupagadi
    Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2010
    • 73

    #16
    Shouldn't the parameter "DatabaseList" include the correct name of your database, I mean - is your database named like "PGSQLDB2"?

    I think it should be like:

    DatabaseList=YourDatabaseName
    YourDatabaseName.Url=jdbcostgresql://127.0.0.1:5433/YourDatabaseName

    Comment

    • dalle
      Senior Member
      Zabbix Certified Specialist
      • Mar 2009
      • 402

      #17
      Originally posted by ufocek
      Hi Dalle,

      Today I try run dbforbix 0.2 and I have in log some errror:

      Code:
      2011-05-10 14:34:08,374 [pool-1-thread-3] INFO  DBforBIX - Done with dbJob on database PGSQLDB2 QueryList elapsed time 4 ms
       2011-05-10 14:35:07,933 [main] INFO  DBforBIX - Starting DBforBIX Version 0.2
       2011-05-10 14:35:07,941 [main] INFO  DBforBIX - DBforBIX started with pid:31841
       2011-05-10 14:35:07,942 [main] ERROR DBforBIX - Error on Configurator getPidFile java.lang.NullPointerException
       2011-05-10 14:35:07,942 [main] ERROR DBforBIX - Error while trying to write pidfile java.lang.NullPointerException
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolDataSource@1787038
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - URL=jdbc:postgresql://127.0.0.1:5433/zabbix
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - maxPoolSize=10
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - maxIdleSize=1
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - maxIdleTime=1800000ms
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - poolTimeout=100
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - timeBetweenEvictionRunsMillis=-1
       2011-05-10 14:35:07,978 [main] INFO  DBforBIX - numTestsPerEvictionRun=3
       2011-05-10 14:35:08,119 [main] INFO  DBforBIX - Connected as zabbix
       2011-05-10 14:35:08,120 [main] INFO  DBforBIX - --------- on Database -> zabbix
       2011-05-10 14:35:08,121 [main] ERROR DBforBIX - Error on Configurator while retriving the DBforBIX.MaxThreadNumber java.lang.NumberFormatException: null
       2011-05-10 14:35:08,206 [pool-1-thread-1] INFO  DBforBIX - Done with dbJob on database PGSQLDB2 QueryList elapsed time 58 ms
      config

      Code:
      ZabbixServerList=ZabbixServer1
      
      ZabbixServer1.Address=192.168.1.96
      ZabbixServer1.Port=10051
      
      
      #pidFile
      DBforBIXDaemon.PidFile=/tmp/orabbix.pid
      #frequency of item's refresh
      DBforBIXDaemon.Sleep=30
      #MaxThreadNumber should be >= than the number of your databases
      DBforBIXDaemon.MaxThreadNumber=200
      
      #put here your databases in a comma separated list
      DatabaseList=PGSQLDB2
      
      #Configuration of Connection pool
      #if not specified Orabbis is going to use default values (hardcoded)
      #Maximum number of active connection inside pool
      DatabaseList.MaxActive=10
      #The maximum number of milliseconds that the pool will wait 
      #(when there are no available connections) for a connection to be returned 
      #before throwing an exception, or <= 0 to wait indefinitely. 
      DatabaseList.MaxWait=100
      DatabaseList.MaxIdle=1
      
      ###PostgreSQL
      #define here your connection string for each database
      #on the following example we are treating PostgreSQL
      PGSQLDB2.Url=jdbc:postgresql://127.0.0.1:5433/zabbix
      PGSQLDB2.User=zabbix
      PGSQLDB2.Password=xxxxxxxxxxxxxxxxx
      PGSQLDB2.DatabaseType=pgsql
      PGSQLDB2.QueryListFile=./conf/pgsqlquery.props
      #Those values are optionals if not specified DBforBIX is going to use his own default values
      PGSQLDB2.MaxActive=10
      PGSQLDB2.MaxWait=100
      PGSQLDB2.MaxIdle=1
      I just realize!
      please rename inside config.props
      DBforBIXDaemon with
      DBforBIX
      there is an issue with configfile
      and let me know
      Andrea Dalle Vacche
      website:http://www.smartmarmot.com/
      e-mail:
      Author of:Mastering Zabbix Book - second edition
      Zabbix Network Monitoring Essentials

      Comment

      • ufocek
        Senior Member
        • Aug 2006
        • 161

        #18
        Originally posted by dalle
        I just realize!
        please rename inside config.props
        DBforBIXDaemon with
        DBforBIX
        there is an issue with configfile
        and let me know
        Hi,

        I changed DBforBIXDaemon on DBforBIX and now I don't have any errors, but zabbix doesn't show data from this trapper.
        Template was imported and add to the host.

        Code:
        2011-05-12 07:45:09,320 [main] INFO  DBforBIX - Starting DBforBIX Version 0.2
         2011-05-12 07:45:09,325 [main] INFO  DBforBIX - DBforBIX started with pid:884
         2011-05-12 07:45:09,325 [main] INFO  DBforBIX - PidFile -> /tmp/orabbix.pid
         2011-05-12 07:45:09,326 [main] DEBUG DBforBIX - getConnection for database zabbix
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolDataSource@1787038
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - URL=jdbc:postgresql://127.0.0.1:5433/zabbix
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - maxPoolSize=10
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - maxIdleSize=1
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - maxIdleTime=1800000ms
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - poolTimeout=100
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - timeBetweenEvictionRunsMillis=-1
         2011-05-12 07:45:09,349 [main] INFO  DBforBIX - numTestsPerEvictionRun=3
         2011-05-12 07:45:09,434 [main] INFO  DBforBIX - Connected as zabbix
         2011-05-12 07:45:09,435 [main] INFO  DBforBIX - --------- on Database -> zabbix
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Loaded the properties from ./conf/pgsqlquery.props
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.NoDataFound null or not present null
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionValue null or not present null
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.Period null or not present null
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.ExcludeColumnsList error null
         2011-05-12 07:45:09,439 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.NoDataFound null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionValue null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.Period null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.ExcludeColumnsList error null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.NoDataFound null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionValue null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.Period null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.ExcludeColumnsList error null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupupdated.NoDataFound null or not present null
         2011-05-12 07:45:09,440 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionValue null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupupdated.Period null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupupdated.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupupdated.ExcludeColumnsList error null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.NoDataFound null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionValue null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.Period null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.ExcludeColumnsList error null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.NoDataFound null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionValue null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.Period null or not present null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.ExcludeColumnsList error null
         2011-05-12 07:45:09,441 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.NoDataFound null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionValue null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.Period null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.ExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.Period null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.Period null or not present null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,442 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.NoDataFound null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.Period null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.NoDataFound null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.Period null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.Period null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,443 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.Period null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.Period null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.NoDataFound null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionValue null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.Period null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.ExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.NoDataFound null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionValue null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.Period null or not present null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.ExcludeColumnsList error null
         2011-05-12 07:45:09,444 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.NoDataFound null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionValue null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.Period null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.ExcludeColumnsList error null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.NoDataFound null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionValue null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.Period null or not present null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.ExcludeColumnsList error null
         2011-05-12 07:45:09,445 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.NoDataFound null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionValue null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.Period null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.ExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.NoDataFound null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionValue null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.Period null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.ExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.NoDataFound null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionValue null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.Period null or not present null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.ExcludeColumnsList error null
         2011-05-12 07:45:09,446 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Loaded the properties from ./conf/pgsqlquery.props
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.NoDataFound null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionValue null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.Period null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.ExcludeColumnsList error null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: activeconn.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.NoDataFound null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionValue null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.Period null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.ExcludeColumnsList error null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupfetched.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupinserted.NoDataFound null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionValue null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupinserted.Period null or not present null
         2011-05-12 07:45:09,452 [main] DEBUG DBforBIX - Note: tupinserted.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupinserted.ExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupinserted.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.NoDataFound null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionValue null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.Period null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.ExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupupdated.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.NoDataFound null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionValue null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.Period null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.ExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: tupdeleted.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.NoDataFound null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionValue null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.Period null or not present null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.ExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactcommit.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,453 [main] DEBUG DBforBIX - Note: xactrollback.NoDataFound null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionValue null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.Period null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.ExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: xactrollback.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.Period null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: exclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.Period null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accessexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.NoDataFound null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.Period null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: accesssharelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: rowsharelock.NoDataFound null or not present null
         2011-05-12 07:45:09,454 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowsharelock.Period null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowsharelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowsharelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowsharelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.Period null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: rowexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.Period null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: shareupdateexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.NoDataFound null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionValue null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.Period null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.ExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: sharerowexclusivelock.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: checkpoints_timed.NoDataFound null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionValue null or not present null
         2011-05-12 07:45:09,455 [main] DEBUG DBforBIX - Note: checkpoints_timed.Period null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_timed.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_timed.ExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_timed.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.NoDataFound null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionValue null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.Period null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.ExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: checkpoints_req.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.NoDataFound null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionValue null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.Period null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.ExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_checkpoint.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_clean.NoDataFound null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionValue null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_clean.Period null or not present null
         2011-05-12 07:45:09,456 [main] DEBUG DBforBIX - Note: buffers_clean.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: buffers_clean.ExcludeColumnsList error null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: buffers_clean.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.NoDataFound null or not present null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionValue null or not present null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.Period null or not present null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.ExcludeColumnsList error null
         2011-05-12 07:45:09,457 [main] DEBUG DBforBIX - Note: maxwritten_clean.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.NoDataFound null or not present null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionValue null or not present null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.Period null or not present null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.ExcludeColumnsList error null
         2011-05-12 07:45:09,458 [main] DEBUG DBforBIX - Note: buffers_backend.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.NoDataFound null or not present null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionQuery null or not present null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionValue null or not present null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.Period null or not present null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.Period null or not present using default values 5 min.
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.ExcludeColumnsList error null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Note: buffers_alloc.RaceConditionQueryExcludeColumnsList error null
         2011-05-12 07:45:09,459 [main] DEBUG DBforBIX - Ready to run DBJob for dbname ->zabbix
         2011-05-12 07:45:09,460 [pool-1-thread-1] DEBUG DBforBIX - Starting dbJob on database zabbix QueryList
         2011-05-12 07:45:09,462 [pool-1-thread-1] DEBUG DBforBIX - Actual query is activeconnNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,464 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 172 for query activeconn on database=zabbix
         2011-05-12 07:45:09,464 [pool-1-thread-1] DEBUG DBforBIX - Actual query is tupfetchedNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,473 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 2982572327 for query tupfetched on database=zabbix
         2011-05-12 07:45:09,474 [pool-1-thread-1] DEBUG DBforBIX - Actual query is tupinsertedNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,474 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 149953156 for query tupinserted on database=zabbix
         2011-05-12 07:45:09,474 [pool-1-thread-1] DEBUG DBforBIX - Actual query is tupupdatedNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,475 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 150351093 for query tupupdated on database=zabbix
         2011-05-12 07:45:09,475 [pool-1-thread-1] DEBUG DBforBIX - Actual query is tupdeletedNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,475 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 152171778 for query tupdeleted on database=zabbix
         2011-05-12 07:45:09,475 [pool-1-thread-1] DEBUG DBforBIX - Actual query is xactcommitNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,476 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 99210860 for query xactcommit on database=zabbix
         2011-05-12 07:45:09,476 [pool-1-thread-1] DEBUG DBforBIX - Actual query is xactrollbackNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,476 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 105 for query xactrollback on database=zabbix
         2011-05-12 07:45:09,477 [pool-1-thread-1] DEBUG DBforBIX - Actual query is exclusivelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,478 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 2 for query exclusivelock on database=zabbix
         2011-05-12 07:45:09,478 [pool-1-thread-1] DEBUG DBforBIX - Actual query is accessexclusivelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,478 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 0 for query accessexclusivelock on database=zabbix
         2011-05-12 07:45:09,478 [pool-1-thread-1] DEBUG DBforBIX - Actual query is accesssharelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,479 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 3 for query accesssharelock on database=zabbix
         2011-05-12 07:45:09,479 [pool-1-thread-1] DEBUG DBforBIX - Actual query is rowsharelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,479 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 0 for query rowsharelock on database=zabbix
         2011-05-12 07:45:09,479 [pool-1-thread-1] DEBUG DBforBIX - Actual query is rowexclusivelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,480 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 0 for query rowexclusivelock on database=zabbix
         2011-05-12 07:45:09,480 [pool-1-thread-1] DEBUG DBforBIX - Actual query is shareupdateexclusivelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,480 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 0 for query shareupdateexclusivelock on database=zabbix
         2011-05-12 07:45:09,481 [pool-1-thread-1] DEBUG DBforBIX - Actual query is sharerowexclusivelockNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,481 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 0 for query sharerowexclusivelock on database=zabbix
         2011-05-12 07:45:09,481 [pool-1-thread-1] DEBUG DBforBIX - Actual query is checkpoints_timedNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,482 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 12829 for query checkpoints_timed on database=zabbix
         2011-05-12 07:45:09,482 [pool-1-thread-1] DEBUG DBforBIX - Actual query is checkpoints_reqNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,482 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 163 for query checkpoints_req on database=zabbix
         2011-05-12 07:45:09,483 [pool-1-thread-1] DEBUG DBforBIX - Actual query is buffers_checkpointNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,483 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 58297855 for query buffers_checkpoint on database=zabbix
         2011-05-12 07:45:09,483 [pool-1-thread-1] DEBUG DBforBIX - Actual query is buffers_cleanNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,484 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 8996525 for query buffers_clean on database=zabbix
         2011-05-12 07:45:09,484 [pool-1-thread-1] DEBUG DBforBIX - Actual query is maxwritten_cleanNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,484 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 16891 for query maxwritten_clean on database=zabbix
         2011-05-12 07:45:09,484 [pool-1-thread-1] DEBUG DBforBIX - Actual query is buffers_backendNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,485 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 4650931 for query buffers_backend on database=zabbix
         2011-05-12 07:45:09,485 [pool-1-thread-1] DEBUG DBforBIX - Actual query is buffers_allocNextrun 2011/05/12 07:50:09 on database=zabbix Period=5
         2011-05-12 07:45:09,485 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 77594453 for query buffers_alloc on database=zabbix
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - Item retrieved 21 on database zabbix
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  activeconn value 172
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  tupfetched value 2982572327
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  tupinserted value 149953156
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  tupupdated value 150351093
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  tupdeleted value 152171778
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  xactcommit value 99210860
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  xactrollback value 105
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  exclusivelock value 2
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  accessexclusivelock value 0
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  accesssharelock value 3
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  rowsharelock value 0
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  rowexclusivelock value 0
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  shareupdateexclusivelock value 0
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  sharerowexclusivelock value 0
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  checkpoints_timed value 12829
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  checkpoints_req value 163
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  buffers_checkpoint value 58297855
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  buffers_clean value 8996525
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  maxwritten_clean value 16891
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  buffers_backend value 4650931
         2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item  buffers_alloc value 77594453

        Comment

        • dalle
          Senior Member
          Zabbix Certified Specialist
          • Mar 2009
          • 402

          #19
          It's really strange because DBforBIX is sending data,
          2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item tupfetched value 2982572327
          mmm do you have an host with the same name of DB configured?
          Andrea Dalle Vacche
          website:http://www.smartmarmot.com/
          e-mail:
          Author of:Mastering Zabbix Book - second edition
          Zabbix Network Monitoring Essentials

          Comment

          • ufocek
            Senior Member
            • Aug 2006
            • 161

            #20
            Originally posted by dalle
            It's really strange because DBforBIX is sending data,
            2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item tupfetched value 2982572327
            mmm do you have an host with the same name of DB configured?
            I have got only one host with zabbix db, on the same host i run dbforbix, i attached template and there aren't any data. Really strange thing.

            Comment

            • ufocek
              Senior Member
              • Aug 2006
              • 161

              #21
              Originally posted by dalle
              It's really strange because DBforBIX is sending data,
              2011-05-12 07:45:09,486 [pool-1-thread-1] DEBUG DBforBIX - dbname zabbix sending item tupfetched value 2982572327
              mmm do you have an host with the same name of DB configured?
              I noticed strange situation in templates, if i add an aplication to temaplate and move items than it doen't work, first time i addedd template to host for few moments i saw data from dbfo.... for mysql, template was original from script.

              Comment

              • dalle
                Senior Member
                Zabbix Certified Specialist
                • Mar 2009
                • 402

                #22
                Originally posted by ufocek
                I noticed strange situation in templates, if i add an aplication to temaplate and move items than it doen't work, first time i addedd template to host for few moments i saw data from dbfo.... for mysql, template was original from script.
                Today i'm going to reproduce your issue you will receive a reply as soon as possible
                I'm going trying with a new installation of zabbix
                Andrea Dalle Vacche
                website:http://www.smartmarmot.com/
                e-mail:
                Author of:Mastering Zabbix Book - second edition
                Zabbix Network Monitoring Essentials

                Comment

                • ufocek
                  Senior Member
                  • Aug 2006
                  • 161

                  #23
                  Did you have any information why it's didn't work?

                  Comment

                  • dalle
                    Senior Member
                    Zabbix Certified Specialist
                    • Mar 2009
                    • 402

                    #24
                    Originally posted by ufocek
                    Did you have any information why it's didn't work?
                    I've installed just today a new Zabbix server, installed a dbforbix, created an host and added a mysql database (linked with template) and everythink is working right.
                    Attached Files
                    Last edited by dalle; 17-05-2011, 11:13.
                    Andrea Dalle Vacche
                    website:http://www.smartmarmot.com/
                    e-mail:
                    Author of:Mastering Zabbix Book - second edition
                    Zabbix Network Monitoring Essentials

                    Comment

                    • ufocek
                      Senior Member
                      • Aug 2006
                      • 161

                      #25
                      hm, can you unlink template from your host. Add a aplication in template and move item to a new aplication. Again add template to your host?

                      Comment

                      • dalle
                        Senior Member
                        Zabbix Certified Specialist
                        • Mar 2009
                        • 402

                        #26
                        Originally posted by ufocek
                        hm, can you unlink template from your host. Add a aplication in template and move item to a new aplication. Again add template to your host?
                        AAAA ok now it's clear. I dind't understood what have you done. doing so you added a new hiearchy to my items and dbforbix don't know the new hierarchy and zabbix is going to drop all your items
                        Andrea Dalle Vacche
                        website:http://www.smartmarmot.com/
                        e-mail:
                        Author of:Mastering Zabbix Book - second edition
                        Zabbix Network Monitoring Essentials

                        Comment

                        • ufocek
                          Senior Member
                          • Aug 2006
                          • 161

                          #27
                          Exactly, and what now?

                          Comment

                          • dalle
                            Senior Member
                            Zabbix Certified Specialist
                            • Mar 2009
                            • 402

                            #28
                            Originally posted by ufocek
                            Exactly, and what now?
                            if you want a customization I can write for your own system with a sponsorship
                            Andrea Dalle Vacche
                            website:http://www.smartmarmot.com/
                            e-mail:
                            Author of:Mastering Zabbix Book - second edition
                            Zabbix Network Monitoring Essentials

                            Comment

                            • ufocek
                              Senior Member
                              • Aug 2006
                              • 161

                              #29
                              Still a strange situation, I went back to the original templates and now show me the items but no data in them.

                              Code:
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.NoDataFound null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.Period null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: dbversion.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.NoDataFound null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.Period null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_clients.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.NoDataFound null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.Period null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Aborted_connects.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.NoDataFound null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.Period null or not present null
                               2011-05-17 12:35:07,496 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_disk_use.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.NoDataFound null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.Period null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Binlog_cache_use.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.NoDataFound null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.Period null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_received.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.NoDataFound null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.Period null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Bytes_sent.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.NoDataFound null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.Period null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_admin_commands.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.NoDataFound null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.Period null or not present null
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,497 [main] DEBUG DBforBIX - Note: Com_alter_db.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_alter_table.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_analyze.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_backup_table.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_begin.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_db.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.NoDataFound null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.Period null or not present null
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,498 [main] DEBUG DBforBIX - Note: Com_change_master.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,499 [pool-1-thread-1] DEBUG DBforBIX - Actual query is activeconnNextrun 2011/05/17 12:40:07 on database=zabbix Period=5
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.Period null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_check.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.Period null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_checksum.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.Period null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_commit.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.Period null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_db.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.Period null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_function.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_index.NoDataFound null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_index.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,499 [main] DEBUG DBforBIX - Note: Com_create_index.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_index.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_index.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_index.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.NoDataFound null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_table.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.NoDataFound null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_create_user.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.NoDataFound null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_dealloc_sql.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.NoDataFound null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.NoDataFound null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.Period null or not present null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_delete_multi.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,500 [main] DEBUG DBforBIX - Note: Com_do.NoDataFound null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_do.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_do.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_do.Period null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_do.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_do.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.NoDataFound null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.Period null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,501 [pool-1-thread-1] DEBUG DBforBIX - I'm going to return 181 for query activeconn on database=zabbix
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_db.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.NoDataFound null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.Period null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,501 [pool-1-thread-1] DEBUG DBforBIX - Actual query is tupfetchedNextrun 2011/05/17 12:40:07 on database=zabbix Period=5
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_function.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.NoDataFound null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.Period null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_index.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.NoDataFound null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.Period null or not present null
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,501 [main] DEBUG DBforBIX - Note: Com_drop_table.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_drop_user.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_execute_sql.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_flush.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_grant.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_close.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_open.NoDataFound null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_open.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_open.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_open.Period null or not present null
                               2011-05-17 12:35:07,502 [main] DEBUG DBforBIX - Note: Com_ha_open.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_ha_open.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.Period null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_help.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.Period null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.Period null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_insert_select.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.Period null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_kill.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.Period null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load_master_data.NoDataFound null or not present null
                               2011-05-17 12:35:07,503 [main] DEBUG DBforBIX - Note: Com_load_master_data.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_data.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_data.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_data.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_data.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.NoDataFound null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_load_master_table.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.NoDataFound null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_lock_tables.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.NoDataFound null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_optimize.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.NoDataFound null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_preload_keys.RaceConditionQueryExcludeColumnsList error null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_prepare_sql.NoDataFound null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_prepare_sql.RaceConditionQuery null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_prepare_sql.RaceConditionValue null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_prepare_sql.Period null or not present null
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note: Com_prepare_sql.Period null or not present using default values 5 min.
                               2011-05-17 12:35:07,504 [main] DEBUG DBforBIX - Note:
                              Attached Files

                              Comment

                              • dalle
                                Senior Member
                                Zabbix Certified Specialist
                                • Mar 2009
                                • 402

                                #30
                                I've tested and on 1.8.5 and changing application my items are working too.... it should be so... at least for what there is on dicumentation... anyway is working right with application too so consider it implemented (I'm kidding)
                                Are you sure that you are using template included on distribution 0.2?
                                I'm using the template in attach.
                                let me know
                                Attached Files
                                Andrea Dalle Vacche
                                website:http://www.smartmarmot.com/
                                e-mail:
                                Author of:Mastering Zabbix Book - second edition
                                Zabbix Network Monitoring Essentials

                                Comment

                                Working...