I am occasionally noticing these Update Failure issues in the log due to "too long for column." Should I be concerned about them and is there a way to avoid them? Every month I download the MAC vendor list from https://linuxnet.ca/ieee/oui.txt.
Tue Jan 7 08:05:23 2020: netdbctl(32208): Importing 7053 MAC entries in to switchports table Tue Jan 7 08:05:31 2020: netdbctl(32208): DBD::mysql::st execute failed: Data too long for column 'vendor' at row 1 at /usr/local/lib/site_perl/NetDB.pm line 2495. Tue Jan 7 08:05:31 2020: netdbctl(32208): DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`netdb`.`switchports`, CONSTRAINT `switchports_ibfk_1` FOREIGN KEY (`mac`) REFERENCES `mac` (`mac`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/local/lib/site_perl/NetDB.pm line 2524. Tue Jan 7 08:05:32 2020: netdbctl(32208): DBD::mysql::st execute failed: Data too long for column 'vendor' at row 1 at /usr/local/lib/site_perl/NetDB.pm line 2486. Tue Jan 7 08:05:32 2020: netdbctl(32208): 2020-01-07 08:05:32 AM: Database Transaction Error (MAC): Update Failure in mac for 7836.90a4.8849: Data too long for column 'vendor' at row 1
Log in to post a comment.
I am occasionally noticing these Update Failure issues in the log due to "too long for column." Should I be concerned about them and is there a way to avoid them? Every month I download the MAC vendor list from https://linuxnet.ca/ieee/oui.txt.