Duplicate entry '000000' for key 'vendor_ouis_oui_unique'

Howdy,

My daily.sh is failing, below is the output - Does anyone have any ideas on this?

Cheers

~$ ./daily.sh
Updating to latest codebase OK
Updating Composer packages OK
Updated from d810c7a64 to de65ff55f OK
Updating SQL-Schema FAIL

INFO Running migrations.

2023_08_02_090027_drop_dbschema_table … 962ms DONE
2023_08_02_120455_vendor_ouis_unique_index … 3,611ms FAIL

In Connection.php line 795:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’ (Connection:
mysql, SQL: alter table vendor_ouis add unique vendor_ouis_oui_unique(oui))

In Connection.php line 580:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’

Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK

got the same thing here.

Do you really wish to run this command? (yes/no) [no]
❯ y

INFO Running migrations.

2023_08_02_120455_vendor_ouis_unique_index … 126ms FAIL

In Connection.php line 795:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’ (Connection: mysql, SQL: alter ta
ble vendor_ouis add unique vendor_ouis_oui_unique(oui))

In Connection.php line 580:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’

dang me too

Updating SQL-Schema FAIL

INFO Running migrations.

2023_08_02_120455_vendor_ouis_unique_index … 80ms FAIL

In Connection.php line 795:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’ (Connection: mysql,
SQL: alter table vendor_ouis add unique vendor_ouis_oui_unique(oui))

In Connection.php line 580:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘000000’ for key ‘vendor_ouis_oui_unique’

Scary to have duplicates in that table, it is a large table!
Just truncate the vendor_ouis table, then run the migration. (A fix was merged that does this for you)
If you want to repopulate the MAC vendors, run lnms maintenance:fetch-ouis

1 Like