Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.4 (alpha)
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Labels:
    • Environment:
      fedora 13 mysql 5.1.52 rev 19183

      Description

      I'm no expert just so you know, but I believe this to be related to low level discovery. In our environment we have switch gear with 240+ ports and I believe that discovery is struggling for some reason. I got this from my zabbix server log:

      4021:20110429:075938.614 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='items' and field_name='itemid']
      4002:20110429:075955.631 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='items' and field_name='itemid']
      4007:20110429:080011.648 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='items' and field_name='itemid']
      4012:20110429:080027.666 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='items' and field_name='itemid']
      4011:20110429:084341.457 [Z3005] Query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+1 where nodeid=0 and table_name='functions' and field_name='functionid']

      I've tweaked mysql with:
      innodb_file_per_table
      innodb_lock_wait_timeout=10000 (I think that's the max from pokin around on the net)
      But in the long run its still occuring.

      I've got 6 items being discovery per interface and 7 triggers on top of those items...

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Evan James Anderson
          • Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: