root@Observium:/opt/observium# ./delete_device.php -dd pl02-switch-1
DEBUG!
Load class 'Console_Color2' from '/opt/observium/libs/pear/Console/Color2.php': OK
DEBUG: is_cli() == TRUE, PHP_SAPI: 'cli', REMOTE_ADDR: ''
CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0073s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Relative URL: ^/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 12863
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 12860
Last Changed Date: 2023-06-08 22:05:49 +0000 (Thu, 08 Jun 2023)

]


 > $observium_version /opt/observium/includes/definitions/version.inc.php:82
string(10) "23.6.12860"


 > $observium_version_long /opt/observium/includes/definitions/version.inc.php:83
string(19) "23.6.12860 (stable)"


 > $svn_train /opt/observium/includes/definitions/version.inc.php:84
string(6) "stable"
DEFINITIONS Time  : 0.092562 ms

DEFINITIONS Memory: 15.2MB


SQL[Load class 'Doctrine\SqlFormatter\SqlFormatter' from '/opt/observium/libs/Doctrine/SqlFormatter/SqlFormatter.php': OK
Load class 'Doctrine\SqlFormatter\Tokenizer' from '/opt/observium/libs/Doctrine/SqlFormatter/Tokenizer.php': OK
Load class 'Doctrine\SqlFormatter\Highlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/Highlighter.php': OK
Load class 'Doctrine\SqlFormatter\CliHighlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/CliHighlighter.php': OK
Load class 'Doctrine\SqlFormatter\Token' from '/opt/observium/libs/Doctrine/SqlFormatter/Token.php': OK
Load class 'Doctrine\SqlFormatter\Cursor' from '/opt/observium/libs/Doctrine/SqlFormatter/Cursor.php': OK
SELECT * FROM `observium_attribs`]
ROWS[23]
SQL RUNTIME[0.00029302s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00009203s]

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
ROWS[0]
SQL RUNTIME[0.00005698s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
ROWS[1]
SQL RUNTIME[0.00007820s]

SQL[SELECT * FROM `config`]
ROWS[4]
SQL RUNTIME[0.00012302s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0018s]
STDOUT[
observium.net.harpa.is
]

SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)]
ROWS[1]
SQL RUNTIME[0.00011587s]
Observium 23.6.12860
Remove Device


SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'pl02-switch-1']
ROWS[1]
SQL RUNTIME[0.00012302s]

SQL[SELECT * FROM `devices` LEFT JOIN `devices_locations` USING (`device_id`) WHERE `device_id` = '113']
ROWS[1]
SQL RUNTIME[0.00025201s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00011396s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00017905s]

SQL[SELECT `mempool_id` FROM `mempools` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00009680s]

SQL[SELECT `radio_id` FROM `p2p_radios` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007701s]

SQL[SELECT `sensor_id` FROM `sensors` WHERE `device_id` = '113';]
ROWS[71]
SQL RUNTIME[0.00012398s]

SQL[SELECT `status_id` FROM `status` WHERE `device_id` = '113';]
ROWS[2]
SQL RUNTIME[0.00008512s]

SQL[SELECT `storage_id` FROM `storage` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007796s]

SQL[SELECT `processor_id` FROM `processors` WHERE `device_id` = '113';]
ROWS[1]
SQL RUNTIME[0.00007796s]

SQL[SELECT `wlan_id` FROM `wifi_wlans` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00012422s]

SQL[SELECT `wifi_radio_id` FROM `wifi_radios` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00014901s]

SQL[SELECT `wifi_ap_id` FROM `wifi_aps` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00009418s]

SQL[SELECT `sla_id` FROM `slas` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007105s]

SQL[SELECT `pseudowire_id` FROM `pseudowires` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007606s]

SQL[SELECT `vm_id` FROM `vminfo` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00009894s]

SQL[SELECT `winsvc_id` FROM `winservices` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00723290s]

SQL[SELECT `alert_table_id` FROM `alert_table` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00010085s]

SQL[SELECT `counter_id` FROM `counters` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00008798s]

SQL[SELECT `oid_entry_id` FROM `oids_entries` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007701s]

SQL[SELECT `vsvr_id` FROM `netscaler_vservers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00310993s]

SQL[SELECT `svc_id` FROM `netscaler_services` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00470209s]

SQL[SELECT `svc_id` FROM `netscaler_servicegroupmembers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00722909s]

SQL[SELECT `pool_id` FROM `lb_pools` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00599694s]

SQL[SELECT `virt_id` FROM `lb_virtuals` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00377798s]

SQL[SELECT `probe_id` FROM `probes` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00012398s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00011110s]

SQL[SELECT `cbqos_id` FROM `ports_cbqos` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00011587s]

SQL[SELECT `supply_id` FROM `printersupplies` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00007701s]

SQL[SELECT `bgpPeer_id` FROM `bgpPeers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00008106s]

SQL[SELECT `cbgp_id` FROM `bgpPeers_cbgp` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00011706s]

SQL[SELECT `device_id` FROM `devices` WHERE `device_id` = '113';]
ROWS[1]
SQL RUNTIME[0.00007987s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.00019002s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.00062299s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.00566697s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00010014s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00010014s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00006509s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00006604s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00009203s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00006199s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00006700s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00006580s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00005698s]

SQL[DELETE FROM `accesspoints` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00257397s]

SQL[DELETE FROM `alert_log` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00063396s]

SQL[DELETE FROM `alert_table` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00008702s]

SQL[DELETE FROM `syslog_alerts` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.01978087s]

SQL[DELETE FROM `applications` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00013280s]

SQL[DELETE FROM `bgpPeers` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00008988s]

SQL[DELETE FROM `bgpPeers_cbgp` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00021696s]

SQL[DELETE FROM `cef_prefix` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00016499s]

SQL[DELETE FROM `cef_switching` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00017810s]

SQL[DELETE FROM `devices_mibs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00011396s]

SQL[DELETE FROM `devices_locations` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00020790s]

SQL[DELETE FROM `device_graphs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00012612s]

SQL[DELETE FROM `eigrp_ports` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00012994s]

SQL[DELETE FROM `entPhysical` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00014687s]

SQL[DELETE FROM `eventlog` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[7.31550288s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `hrDevice` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000405s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipsec_tunnels` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000310s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `loadbalancer_rservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `loadbalancer_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `mempools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `munin_plugins` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000310s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_services` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_services_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_areas` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_instances` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_nbrs` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_ports` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `packages` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000286s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports_stack` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000119s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports_vlans` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `processors` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `pseudowires` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `sensors` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `status` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `services` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `slas` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `storage` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `syslog` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `printersupplies` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ucd_diskio` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vlans` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vlans_fdb` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vminfo` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vrfs` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `wifi_accesspoints` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `wifi_sessions` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `group_table` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `p2p_radios` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `oids_entries` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_virtuals` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `observium_processes` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_pools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_pool_members` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000381s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_snatpools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `neighbours` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `autodiscovery` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipv4_addresses` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000119s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipv6_addresses` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ip_mac` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000119s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `notifications_queue` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `mac_accounting` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `devices` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `autodiscovery` WHERE `remote_device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('0','113','info',NOW(),'5','Deleted device: pl02-switch-1')]
ROWS[-1]
SQL RUNTIME[0.00000310s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

 * Deleted device entries from tables:  * Deleted device: pl02-switch-1
Device pl02-switch-1 removed.
root@Observium:/opt/observium#
root@Observium:/opt/observium#
root@Observium:/opt/observium# ./delete_device.php -dd pl02-switch-1 rrd
DEBUG!
Load class 'Console_Color2' from '/opt/observium/libs/pear/Console/Color2.php': OK
DEBUG: is_cli() == TRUE, PHP_SAPI: 'cli', REMOTE_ADDR: ''
CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0112s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Relative URL: ^/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 12863
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 12860
Last Changed Date: 2023-06-08 22:05:49 +0000 (Thu, 08 Jun 2023)

]


 > $observium_version /opt/observium/includes/definitions/version.inc.php:82
string(10) "23.6.12860"


 > $observium_version_long /opt/observium/includes/definitions/version.inc.php:83
string(19) "23.6.12860 (stable)"


 > $svn_train /opt/observium/includes/definitions/version.inc.php:84
string(6) "stable"
DEFINITIONS Time  : 0.103896 ms

DEFINITIONS Memory: 15.2MB


SQL[Load class 'Doctrine\SqlFormatter\SqlFormatter' from '/opt/observium/libs/Doctrine/SqlFormatter/SqlFormatter.php': OK
Load class 'Doctrine\SqlFormatter\Tokenizer' from '/opt/observium/libs/Doctrine/SqlFormatter/Tokenizer.php': OK
Load class 'Doctrine\SqlFormatter\Highlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/Highlighter.php': OK
Load class 'Doctrine\SqlFormatter\CliHighlighter' from '/opt/observium/libs/Doctrine/SqlFormatter/CliHighlighter.php': OK
Load class 'Doctrine\SqlFormatter\Token' from '/opt/observium/libs/Doctrine/SqlFormatter/Token.php': OK
Load class 'Doctrine\SqlFormatter\Cursor' from '/opt/observium/libs/Doctrine/SqlFormatter/Cursor.php': OK
SELECT * FROM `observium_attribs`]
ROWS[23]
SQL RUNTIME[0.00028300s]

SQL[SELECT @@SESSION.sql_mode;]
ROWS[1]
SQL RUNTIME[0.00009418s]

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
ROWS[0]
SQL RUNTIME[0.00005913s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
ROWS[1]
SQL RUNTIME[0.00006509s]

SQL[SELECT * FROM `config`]
ROWS[4]
SQL RUNTIME[0.00011516s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0055s]
STDOUT[
observium.net.harpa.is
]

SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)]
ROWS[1]
SQL RUNTIME[0.00015593s]
Observium 23.6.12860
Remove Device


SQL[SELECT `device_id` FROM `devices` WHERE `hostname` = 'pl02-switch-1']
ROWS[1]
SQL RUNTIME[0.00012493s]

SQL[SELECT * FROM `devices` LEFT JOIN `devices_locations` USING (`device_id`) WHERE `device_id` = '113']
ROWS[1]
SQL RUNTIME[0.00032496s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00011683s]

SQL[SELECT * FROM `ports` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00017309s]

SQL[SELECT `mempool_id` FROM `mempools` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00013900s]

SQL[SELECT `radio_id` FROM `p2p_radios` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00008297s]

SQL[SELECT `sensor_id` FROM `sensors` WHERE `device_id` = '113';]
ROWS[71]
SQL RUNTIME[0.00014997s]

SQL[SELECT `status_id` FROM `status` WHERE `device_id` = '113';]
ROWS[2]
SQL RUNTIME[0.00011206s]

SQL[SELECT `storage_id` FROM `storage` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00016093s]

SQL[SELECT `processor_id` FROM `processors` WHERE `device_id` = '113';]
ROWS[1]
SQL RUNTIME[0.36168098s]

SQL[SELECT `wlan_id` FROM `wifi_wlans` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00025821s]

SQL[SELECT `wifi_radio_id` FROM `wifi_radios` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00020194s]

SQL[SELECT `wifi_ap_id` FROM `wifi_aps` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00018406s]

SQL[SELECT `sla_id` FROM `slas` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00019598s]

SQL[SELECT `pseudowire_id` FROM `pseudowires` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00015903s]

SQL[SELECT `vm_id` FROM `vminfo` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00668120s]

SQL[SELECT `winsvc_id` FROM `winservices` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00831103s]

SQL[SELECT `alert_table_id` FROM `alert_table` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00017715s]

SQL[SELECT `counter_id` FROM `counters` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00016880s]

SQL[SELECT `oid_entry_id` FROM `oids_entries` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00022292s]

SQL[SELECT `vsvr_id` FROM `netscaler_vservers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00105190s]

SQL[SELECT `svc_id` FROM `netscaler_services` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00111413s]

SQL[SELECT `svc_id` FROM `netscaler_servicegroupmembers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00091696s]

SQL[SELECT `pool_id` FROM `lb_pools` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00080395s]

SQL[SELECT `virt_id` FROM `lb_virtuals` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00081086s]

SQL[SELECT `probe_id` FROM `probes` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.06043410s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00021887s]

SQL[SELECT `cbqos_id` FROM `ports_cbqos` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00015807s]

SQL[SELECT `supply_id` FROM `printersupplies` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00012612s]

SQL[SELECT `bgpPeer_id` FROM `bgpPeers` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00042510s]

SQL[SELECT `cbgp_id` FROM `bgpPeers_cbgp` WHERE `device_id` = '113';]
ROWS[0]
SQL RUNTIME[0.00024414s]

SQL[SELECT `device_id` FROM `devices` WHERE `device_id` = '113';]
ROWS[1]
SQL RUNTIME[0.00012398s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.00031495s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.00075698s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'sensor' AND `entity_id` IN ('1593','1594','1595','1596','1597','1598','1599','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','1616','1617','1618','1619','1620','1621','1622','1623','1640','1641','1642','1643','1644','1645','1646','1647','1648','1655','1656','1657','1661','1662','1663','1673','1674','1675','1691','1692','1693','1703','1704','1705','1741','1742','1743','1746','1747','1748','1792','1793','1794','1958','2002','2003','2004','2322','2323','2324')]
ROWS[0]
SQL RUNTIME[0.03675508s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00014901s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00012684s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'status' AND `entity_id` IN ('270','557')]
ROWS[0]
SQL RUNTIME[0.00010109s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00009012s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00010204s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'processor' AND `entity_id` = '210']
ROWS[0]
SQL RUNTIME[0.00008202s]

SQL[DELETE FROM `entity_permissions` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00009203s]

SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00008607s]

SQL[DELETE FROM `bill_entities` WHERE `entity_type` = 'device' AND `entity_id` = '113']
ROWS[0]
SQL RUNTIME[0.00007582s]

SQL[DELETE FROM `accesspoints` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00707006s]

SQL[DELETE FROM `alert_log` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.23760104s]

SQL[DELETE FROM `alert_table` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00019789s]

SQL[DELETE FROM `syslog_alerts` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00126791s]

SQL[DELETE FROM `applications` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00010800s]

SQL[DELETE FROM `bgpPeers` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00009894s]

SQL[DELETE FROM `bgpPeers_cbgp` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00010991s]

SQL[DELETE FROM `cef_prefix` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00012112s]

SQL[DELETE FROM `cef_switching` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00012207s]

SQL[DELETE FROM `devices_mibs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00027084s]

SQL[DELETE FROM `devices_locations` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00009489s]

SQL[DELETE FROM `device_graphs` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00008893s]

SQL[DELETE FROM `eigrp_ports` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00012612s]

SQL[DELETE FROM `entPhysical` WHERE `device_id` = '113']
ROWS[0]
SQL RUNTIME[0.00014305s]

SQL[DELETE FROM `eventlog` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[4.22525692s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `hrDevice` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000501s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipsec_tunnels` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `loadbalancer_rservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000286s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `loadbalancer_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `mempools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `munin_plugins` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_services` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_services_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `netscaler_vservers` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_areas` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_instances` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000310s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_nbrs` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ospf_ports` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `packages` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000310s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports_stack` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000119s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ports_vlans` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `processors` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `pseudowires` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000501s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `sensors` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `status` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `services` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `slas` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `storage` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `syslog` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `printersupplies` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ucd_diskio` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vlans` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000286s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vlans_fdb` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000119s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vminfo` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `vrfs` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `wifi_accesspoints` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `wifi_sessions` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `group_table` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00001287s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `p2p_radios` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `oids_entries` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_virtuals` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `observium_processes` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_pools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_pool_members` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `lb_snatpools` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `neighbours` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `autodiscovery` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipv4_addresses` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ipv6_addresses` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `ip_mac` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000215s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `notifications_queue` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000286s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `mac_accounting` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `devices` WHERE `device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000095s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[DELETE FROM `autodiscovery` WHERE `remote_device_id` = '113']
ROWS[-1]
SQL RUNTIME[0.00000191s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('0','113','info',NOW(),'5','Deleted device: pl02-switch-1')]
ROWS[-1]
SQL RUNTIME[0.00000286s]
SQL ERROR[Error in query: (MySQL server has gone away) 2006]

 * Deleted device entries from tables:  * Deleted device: pl02-switch-1
Device pl02-switch-1 removed.
root@Observium:/opt/observium#