Dead lock on MySQL after an "Allowed memory size" error ?

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None
    • Environment:
      Ubuntu jaunty server 64bits edition on Xen server
      Kernel: 2.6.28-18-server
      zabbix-server-mysql: 1:1.6.1-3ubuntu0.1
      zabbix-frontend-php: 1:1.6.1-3ubuntu0.1
      mysql-server: 5.1.37-1ubuntu5.1

      TEST:
      On Zabbix web page :

      • Log as super admin
      • Configuration > Hosts
      • Select Templates on the right
      • Select many templates (4 or more)
      • Click on "Delete selected"

      Zabbix web page return an error:
      "Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 24 bytes) in /usr/share/zabbix/include/db.inc.php on line 519"

      • Back on last page using the back button of the browser, displays the templates.
      • Select only 1 template
      • Click on "Delete selected"

      After several minutes : Firefox display an error : 500 Server Error
      When trying to display Zabbix web page on another firefox tab, I also had this error :
      Zabbix page is displayed but there is an error message :
      " * Error in query [UPDATE sessions SET lastaccess=1269512352 WHERE sessionid='7118b198f7ecd1a50afec1a0e7c5912e'] [Lock wait timeout exceeded; try restarting transaction]"

      MySQL restart (/etc/init.d/mysql restart) solve the problem.

      I reproduced this bug each time I tried.

            Assignee:
            Unassigned
            Reporter:
            Ben
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: