SQL Warnings When Removing Plugin

[oschwartz10612]

Types of Issue

• Anomaly report (something appears to not work correctly)
• Enhancement request (describe the enhancement being requested)
• Other (please ensure the description clarifies why the issue doesn’t fall into either of the above categories)

Descriptive summary

When removing a plugin using the web portal, the following SQL errors continue to be thrown:

2022-09-27 19:45:03.133511	WARNING	/home/V2X-Hub/src/tmx/TmxCore/src/MessageProfiler.cpp, 249	Cannot add or update a child row: a foreign key constraint fails (`IVP`.`messageActivity`, CONSTRAINT `messageActivity_ibfk_2` FOREIGN KEY (`pluginId`) REFERENCES `plugin` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

The only way to resolve these errors is to restart v2x. This is in the Docker version.

V2XHUB version where this issue was discovered

7.0

Expected behavior

Plugin is removed an no errors arise.

Actual behavior

Steps to reproduce the actual behavior

1. Install plugin
2. Click the remove button in the web portal
3. Watch logs

[jwillmartin]

@oschwartz10612 Was this on amd or arm? I've tried recreating in amd and didn't get the same warning. I used v2xhub tag 7.0, and it pulled docker release 6.2.

[oschwartz10612]

Hi Will,

This is definitely not something that happens regularly and I should have made that clear. I have seen this on both x86 and arm but only occasionally. If I see it again I will attempt to be more through in documenting what I can and report back here.

In the mean time let me know if I can help in any other way.