[ZBX-2851] apache hangs with 100% cpu load when accessing empty database Created: 2010 Aug 10  Updated: 2017 May 30  Resolved: 2010 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.3rc3
Fix Version/s: 1.8.4

Type: Incident report Priority: Minor
Reporter: Aleksandrs Saveljevs Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File only-variables.png    

 Description   

Create an empty database, but don't do schema.sql, data.sql and images_DB.sql just yet. Open the frontend and Apache will hang, using 100% of CPU.

 Comments   
Comment by richlv [ 2010 Aug 19 ]

confirming. not too nice.

waiting for a timeout seems to also produce additional messages :

Error in query [SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid] [Table 'tmp.nodes' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]
Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='d4648f4a8a54ed35626e92d0caf97e33' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1282203625) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'tmp.sessions' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]
Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'tmp.users' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]
Error in query [SELECT s.* FROM sessions s WHERE s.sessionid='d4648f4a8a54ed35626e92d0caf97e33' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))] [Table 'tmp.sessions' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]
Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'tmp.config' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]
Undefined index: title[/usr/local/apache2/htdocs/trunk/include/profiles.inc.php:213]
Unable to select configuration
Error in query [SELECT * FROM profiles WHERE userid=0 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC] [Table 'tmp.profiles' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]

Comment by Aleksandrs Saveljevs [ 2010 Dec 07 ]

Same thing happens when an incorrect IBM DB2 schema is specified.

Comment by Alexey Fukalov [ 2010 Dec 08 ]

dev branch: ZBX-2851

Comment by Aleksandrs Saveljevs [ 2010 Dec 13 ]

See only-variables.png.

Comment by Alexey Fukalov [ 2010 Dec 13 ]

fixed

Comment by Aleksandrs Saveljevs [ 2010 Dec 14 ]

Apache still hangs if an incorrect IBM DB2 schema is specified.

Comment by Alexey Fukalov [ 2010 Dec 21 ]

fixed

Comment by Alexey Fukalov [ 2010 Dec 21 ]

branches/1.8 16307

Generated at Thu Apr 25 19:13:12 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.