View Issue Details

IDProjectCategoryView StatusLast Update
2087RackTablesdefaultpublic2023-12-06 08:47
ReporterMyFirstBug Assigned To 
PrioritylowSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version0.22.0 
Summary2087: Unable To Connect Front to Back Ports
DescriptionWhen I try to connect front port with back ports in the 'Link Management' section then I receive a error message "PDOException".
Also when I try to connect front port and front port, then I receive the same error message.

Otherwise when I connect the ports within the 'ports' section, then it is working, but I can only connect one to one instead when I use multipe patch panels.

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 3940

/var/www/racktables/wwwroot/inc/database.php:3940 execute()
/var/www/racktables/plugins/linkmgmt/plugin.php:4069 usePreparedInsertBlade()
/var/www/racktables/plugins/linkmgmt/plugin.php:3990 linkmgmt_linkPorts()
/var/www/racktables/wwwroot/inc/functions.php:5679 linkmgmt_oplinkPort()
/var/www/racktables/plugins/linkmgmt/plugin.php:4098 getOutputOf()
/var/www/racktables/wwwroot/inc/functions.php:6032 linkmgmt_opPortLinkDialog()
/var/www/racktables/wwwroot/index.php:238 universalOpHandler()
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
(array)
module redirect
page object
tab linkmgmt
object_id 131
allports 1
op PortLinkDialog
port 1831
linktype front
POST
(array)
port 1831
filter-obj
filter-port
in_rack 1
remote_object 461
remote_ports
(array)
0 7174
cable
do_link Link front
COOKIE
(array)
__cmpcpcu7702 __51__
__cmpconsent7702 BP0LbLkP0LbLkAfSABDEABAAAAAAAA
__cmpcvcu7702 __s23_s2612_s1409_s24_s1475_s893_c43145_c2838_c2837_U__
PHPSESSID 67m3rkvea2vi8or7h0qtn5c8ls
TagsNo tags attached.
Attached Files
RackTables pop-up-10_37_15.jpg (214,816 bytes)   
RackTables pop-up-10_37_15.jpg (214,816 bytes)   
PDOException-10_38_04.jpg (142,267 bytes)   
PDOException-10_38_04.jpg (142,267 bytes)   

Activities

MyFirstBug

MyFirstBug

2023-11-23 15:36

reporter   ~0004517

Is there any updates when the request will be proceeded?
infrastation

infrastation

2023-12-06 00:18

administrator   ~0004525

Thank you for reporting the bug. I do not remember seeing this before. Could you describe a simple way to reproduce the problem?
MyFirstBug

MyFirstBug

2023-12-06 08:47

reporter   ~0004529

Yes always, when I try to connect ports in the "Link Management" section, then I receive this exception.
When I use the port section to connect the device it is working.

Can it be possible to have issues between compatibilities?

Issue History

Date Modified Username Field Change
2023-10-31 10:38 MyFirstBug New Issue
2023-10-31 10:38 MyFirstBug File Added: RackTables pop-up-10_37_15.jpg
2023-10-31 10:38 MyFirstBug File Added: PDOException-10_38_04.jpg
2023-11-23 15:36 MyFirstBug Note Added: 0004517
2023-12-06 00:18 infrastation Note Added: 0004525
2023-12-06 08:47 MyFirstBug Note Added: 0004529