[Spce-user] detect divergence in mysql schemes mr12.5.1

[Alexander Schwarz]

Hello,
we installed a new server including the latest version mr12.5.1.
After checking the system using ngcp-status --all the following message appears:
DB: detect divergence in mysql schemes, run ngcp-mysql-compare-dbs to check detail.

.\ngcp-mysql-compare-dbs:
The following errors were found:
Element: constraints/provisioning/voip_contacts/voip_contacts_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db
Element: constraints/provisioning/voip_dbaliases/voip_dbaliases_ibfk_1/domain_id/voip_domains/id is missing in local db
Element: constraints/provisioning/voip_dbaliases/voip_dbaliases_ibfk_2/subscriber_id/voip_subscribers/id is missing in local db
Element: constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibfk_1/domain_id/voip_domains/id is missing in local db
Element: constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db
Element: constraints/provisioning/voip_fax_destinations/voip_fax_destinations_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db
Element: constraints/provisioning/voip_fax_preferences/voip_fax_preferences_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db
Element: constraints/provisioning/voip_peer_preferences/voip_peer_preferences_ibfk_1/peer_host_id/voip_peer_hosts/id is missing in local db
Element: constraints/provisioning/voip_peer_preferences/voip_peer_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db
Element: constraints/provisioning/voip_subscribers/voip_subscribers_ibfk_1/domain_id/voip_domains/id is missing in local db
Element: constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibfk_1/subscriber_id/voip_subscribers/id is missing in local db
Element: constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibfk_2/attribute_id/voip_preferences/id is missing in local db

Would you please provide a fix for this issue?
We would like to update our productive systems for several reasons, but we fear that we will also receive this error

Best regards,

Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20250203/a74da661/attachment.htm>