View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1199 | RackTables | default | public | 2014-03-21 15:02 | 2014-05-24 20:11 |
| Reporter | slava_dubr | Assigned To | adoom42 | ||
| Priority | normal | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | unable to reproduce | ||
| Platform | Linux | OS | Centos | OS Version | 6.4 |
| Product Version | 0.20.7 | ||||
| Summary | 1199: Can't link port | ||||
| Description | Trying link port for 2 objects and get error: Pdo exception: PDOException SQLSTATE[HY000]: General error: 1442 Can't update table 'Port' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. (HY000) at file /var/www/RackTables/wwwroot/inc/database.php, line 3805 /var/www/RackTables/wwwroot/inc/database.php:3805 execute(Array ( [0] => 618 [1] => 657 [2] => ) ) /var/www/RackTables/wwwroot/inc/database.php:1856 usePreparedInsertBlade('Link', Array ( [porta] => 618 [portb] => 657 [cable] => ) ) /var/www/RackTables/wwwroot/inc/popup.php:280 linkPorts('657', '618', '') handlePopupPortLink() /var/www/RackTables/wwwroot/inc/functions.php:5306 call_user_func_array('handlePopupPortLink', Array ( ) ) callHook('handlePopupPortLink') /var/www/RackTables/wwwroot/inc/functions.php:5285 call_user_func_array('callHook', Array ( [0] => handlePopupPortLink ) ) /var/www/RackTables/wwwroot/inc/popup.php:493 getOutputOf('callHook', 'handlePopupPortLink') /var/www/RackTables/wwwroot/index.php:261 renderPopupHTML() Error info: Array ( [0] => HY000 [1] => 1442 [2] => Can't update table 'Port' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. ) Parameters: GET module popup helper portlist port 657 filter-obj XIV filter-asset_no filter-port remote_port 618 cable do_link Link POST | ||||
| Steps To Reproduce | 1. Create 2 objects 2. Add 2 ports to each 3. Link ports I can provide mysql dump for reproduce | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-03-21 15:02 | slava_dubr | New Issue | |
| 2014-03-21 15:02 | slava_dubr | Status | new => assigned |
| 2014-03-21 15:02 | slava_dubr | Assigned To | => andriyanov |
| 2014-03-21 15:09 | infrastation | Assigned To | andriyanov => adoom42 |
| 2014-03-21 15:09 | infrastation | Status | assigned => new |
| 2014-03-21 15:09 | infrastation | Category | IPv4/IPv6/SLB => default |
| 2014-03-21 15:29 | adoom42 | Note Added: 0002225 | |
| 2014-03-21 15:29 | adoom42 | Status | new => assigned |
| 2014-03-21 15:29 | adoom42 | Product Version | => 0.20.7 |
| 2014-03-25 05:26 | adoom42 | Status | assigned => feedback |
| 2014-03-25 10:08 | slava_dubr | File Added: racktables_db.sql.gz | |
| 2014-03-25 10:08 | slava_dubr | File Added: triggers.racktables | |
| 2014-03-25 10:26 | slava_dubr | Note Added: 0002229 | |
| 2014-03-25 10:26 | slava_dubr | Status | feedback => assigned |
| 2014-05-24 20:11 | adoom42 | Status | assigned => closed |
| 2014-05-24 20:11 | adoom42 | Resolution | open => unable to reproduce |
