Vlan dbDelete too large


Running 2 x Dell MXL I/O-Aggregator latest firmware in default mode.
This is a very basic passthrough mode, and all VLANs are active on all ports. and pushed towards an uplink.

In trying to make things usable, I disabled the VLAN polling that I don’t use in LibrenNMS, opening the ports page takes forever and times out most of times. (not of concern here)

however i have recently started seeing this error in daily.log

production.ERROR: SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many placeholders 107985 (SQL: DELETE FROM ports_vlans WHERE device_id=23 AND port_vlan_id NOT IN (

With what looks like a very large listing, of every vlan on every port. its 135,102 records per switch.

very similar to Discovery arp-table module in large production environment

not too sure if the same fix in the post above can be used here?

is this the right forum to report this?


Component Version
LibreNMS 1.58.1-29-g37d6a86
DB Schema 2019_04_22_220000_update_route_table (147)
PHP 7.2.24
MySQL 5.5.64-MariaDB
RRDTool 1.4.8


[OK] Composer Version: 1.9.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct