I've launched the script admin/cli/check_database_schema.php on several Moodle instances, used from years, and found problems for several plugins.
I think it's a coherence problem between files db/upgrade.php and db/install.xml.
Plugin developpers should think to adapt the db/upgrade.php file to reflect changes in db/install.xml.
On the other hand, administrators should think to launch admin/cli/check_database_schema.php before and after each plugin update. That would allow them to see problems soon when a new plugin version comes out, with this problem, to report it to the developper.
For the benefit of the whole community, what would be the best way to verify lots of plugins? Install an old Moodle version, with old plugins versions, and try to update them (several times) to see where the problem occur? Ask administrators to launch admin/cli/check_database_schema.php on there Moodle installations and publish the results?
And then, how to inform plugin developpers so that they can improve plugins?