699: Unable to unlink ports - RackTables bug tracker

ID	Project	Category	View Status	Date Submitted	Last Update

699	RackTables	default	public	2012-12-19 13:02	2012-12-20 08:11

Reporter	rogier mars	Assigned To	andriyanov
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform	Linux	OS	Centos	OS Version	5.8
Product Version	0.20.1
Target Version	0.20.3	Fixed in Version	0.20.3

Summary	699: Unable to unlink ports
Description	When I try to unlink two ports from a switch I get the error message pasted below. I run on Centos with php 5.2.17. Is this a bug, or some other problem? [root@web01 inc]# cat /etc/redhat-release CentOS release 5.8 (Final) [root@web01 inc]# php -v PHP 5.2.17 (cli) (built: Oct 12 2011 00:20:38) Copyright (c) 1997-2010 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies with the ionCube PHP Loader v3.3.7, Copyright (c) 2002-2009, by ionCube Ltd., and with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies [root@web01 inc]# mysql -V mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1 [root@web01 inc]# Pdo exception: PDOException SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. (HY000) at file /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php, line 3613 /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:3613 prepare('INSERT INTO PortLog (port_id, user, date, message) VALUES (?, ?, NOW(), ?)') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:1744 usePreparedExecuteBlade('INSERT INTO PortLog (port_id, user, date, message) VALUES (?, ?, NOW(), ?)', Array ( [0] => 6115 [1] => admin [2] => unlinked from blsw01.care.redbee.nl eth20 ) ) /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:1725 addPortLogEntry('6115', 'unlinked from blsw01.care.redbee.nl eth20') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/ophandlers.php:2942 commitUnlinkPort('6313') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/index.php:225 unlinkPort() Error info: Array ( [0] => HY000 [1] => 2014 [2] => Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. ) Parameters: GET module redirect op unlinkPort port_id 6313 page object tab ports object_id 1000 POST COOKIE __utma 54622248.375013107.1343125482.1350494463.1351710027.33 __utmc 54622248 __utmz 54622248.1343125482.1.1.utmcsr=(direct)\|utmccn=(direct)\|utmcmd=(none) PHPSESSID i027n3na04mcktvjmkbaolphd7
Steps To Reproduce	Unlink a port from a switch
Tags	No tags attached.

rogier mars 2012-12-19 13:04 reporter ~0001031	Linking a port gives the same error: Pdo exception: PDOException SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. (HY000) at file /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php, line 3613 /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:3613 prepare('INSERT INTO PortLog (port_id, user, date, message) VALUES (?, ?, NOW(), ?)') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:1744 usePreparedExecuteBlade('INSERT INTO PortLog (port_id, user, date, message) VALUES (?, ?, NOW(), ?)', Array ( [0] => 5169 [1] => admin [2] => linked to 01..xx.yyy.zzz.nl Ethernet0/1 ) ) /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/database.php:1691 addPortLogEntry('5169', 'linked to 01.fw.colt.redbee.nl Ethernet0/1') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/popup.php:257 linkPorts('1630', '5169', '') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/functions.php:5204 handlePopupPortLink() /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/functions.php:5183 callHook('handlePopupPortLink', Array ( ) ) /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/inc/popup.php:459 getOutputOf('handlePopupPortLink') /bigdisk/apache_sites/RackTables-0.20.1/wwwroot/index.php:250 renderPopupHTML() Error info: Array ( [0] => HY000 [1] => 2014 [2] => Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. ) Parameters: GET module popup helper portlist port 1630 filter-obj filter-port in_rack on remote_port 5169 cable do_link Link POST COOKIE __utma 54622248.375013107.1343125482.1350494463.1351710027.33 __utmc 54622248 __utmz 54622248.1343125482.1.1.utmcsr=(direct)\|utmccn=(direct)\|utmcmd=(none) PHPSESSID i027n3na04mcktvjmkbaolphd7

andriyanov 2012-12-19 17:29 reporter ~0001033	fixed, thanks. 0.20.3 will be released today

Date Modified	Username	Field	Change
2012-12-19 13:02	rogier mars	New Issue
2012-12-19 13:04	rogier mars	Note Added: 0001031
2012-12-19 17:29	andriyanov	Note Added: 0001033
2012-12-19 17:29	andriyanov	Status	new => closed
2012-12-19 17:29	andriyanov	Assigned To	=> andriyanov
2012-12-19 17:29	andriyanov	Resolution	open => fixed
2012-12-19 17:29	andriyanov	Fixed in Version	=> 0.20.3
2012-12-20 08:11	infrastation	Target Version	=> 0.20.3