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

[Matthias Hohl]

I had exactly the same by updating our SPCE version from 10.5.1 to 11.5.1 yesterday.

Sadly I also don’t know what causes this problem or how to fix the divergence.

 

 

Von: Alexander Schwarz <schwarz at flow7.de> 
Gesendet: Montag, 3. Februar 2025 15:41
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] detect divergence in mysql schemes mr12.5.1
Priorität: Hoch

 

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/20250204/0c64e897/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4999 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20250204/0c64e897/attachment.p7s>