Hi,
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 |
| SNMP | NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.9.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct