Bulk Modifications SQL Errors

[BanditBBS]

I just tried to add a contact group to a list of services and received the following errors when trying to save.

Code: Select all

SQL: SQL Error [nagiosql] : Duplicate entry '242-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '251-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '248-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '249-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '252-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '247-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '244-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '246-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '250-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '245-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '231-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '240-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '237-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '238-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '241-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '236-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '233-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '235-3' for key 'PRIMARY' SQL: SQL Error [nagiosql] : Duplicate entry '239-3' for key 'PRIMARY'

[BanditBBS]

What it looks like is half the services already had that contact group assigned while the other half didn't. It did add it to the half that didn't and I applied configuration and it is working fine.

[scottwilkerson]

This may be in the underlying NagiosQL code, it should probably be changed so the INSERT has a ON DUPLICATE KEY UPDATE value...

[BanditBBS]

I would agree

Let me guess, want me to fill out a bug report?

[mguthrie]

I'll save you the time, I got it on the TODO for the next revision. Thanks for the report!