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

[Mykola Malkov]

Hello Alexander

> we installed a new server including the latest version mr12.5.1.

> After checking the system using ngcp-status --all the following message
appears:
Sorry, I can't reproduce this issue.

ngcp-mysql-compare-dbs reports that in database 'provisioning' several
tables like 'voip_dom_preferences', 'voip_contacts', 'voip_dbaliases', etc
don't have required constraints.
I guess the constraints were created but with different names.
Show the output of "mysql provisioning -e 'show create table
voip_dom_preferences\G'



On Mon, Feb 3, 2025 at 4:42 PM Alexander Schwarz <schwarz at flow7.de> wrote:

> 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
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>


-- 
WBR
---
Mykola Malkov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20250204/5a9884ad/attachment-0001.htm>