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

Alexander Schwarz schwarz at flow7.de
Wed Feb 12 07:27:01 EST 2025 

Hello Mykola Malkov,

root at spce:~# mysql provisioning -e 'show create table voip_dom_preferences\G'

*************************** 1. row ***************************
       Table: voip_dom_preferences
Create Table: CREATE TABLE `voip_dom_preferences` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) unsigned NOT NULL,
  `attribute_id` int(11) unsigned NOT NULL,
  `value` varchar(128) NOT NULL,
  `modify_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `domidattrid_idx` (`domain_id`,`attribute_id`),
  KEY `domainid_idx` (`domain_id`),
  KEY `attributeid_idx` (`attribute_id`),
  CONSTRAINT `v_d_p_attributeid_ref` FOREIGN KEY (`attribute_id`) REFERENCES `voip_preferences` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `v_d_p_domainid_ref` FOREIGN KEY (`domain_id`) REFERENCES `voip_domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=377 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

Best regards,

Alex

-----Ursprüngliche Nachricht-----
Von: spce-user-request at lists.sipwise.com <spce-user-request at lists.sipwise.com> 
Gesendet: Dienstag, 4. Februar 2025 14:59
An: spce-user at lists.sipwise.com
Betreff: Spce-user Digest, Vol 68, Issue 2

Send Spce-user mailing list submissions to
	spce-user at lists.sipwise.com

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
or, via email, send a message with subject or body 'help' to
	spce-user-request at lists.sipwise.com

You can reach the person managing the list at
	spce-user-owner at lists.sipwise.com

When replying, please edit your Subject line so it is more specific than "Re: Contents of Spce-user digest..."


Today's Topics:

   1. Re: detect divergence in mysql schemes mr12.5.1 (Matthias Hohl)
   2. Re: [EXTERNAL] detect divergence in mysql schemes mr12.5.1
      (Mykola Malkov)


----------------------------------------------------------------------

Message: 1
Date: Tue, 4 Feb 2025 11:08:59 +0100 (CET)
From: Matthias Hohl <matthias.hohl at telematica.at>
To: 'Alexander Schwarz' <schwarz at flow7.de>,
	spce-user at lists.sipwise.com
Subject: Re: [Spce-user] detect divergence in mysql schemes mr12.5.1
Message-ID: <1686808492.2427473.1738663739410.JavaMail.zimbra at mx>
Content-Type: text/plain; charset="utf-8"

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-0001.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-0001.p7s>

------------------------------

Message: 2
Date: Tue, 4 Feb 2025 15:58:27 +0200
From: Mykola Malkov <mmalkov at sipwise.com>
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] [EXTERNAL] detect divergence in mysql schemes
	mr12.5.1
Message-ID:
	<CABg59rRG9Z1FnkshJHLCKAK3hjJccktsu=_eb2Ayoo1Z2SxsiQ at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

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_i
> d/voip_domains/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_dbaliases/voip_dbaliases_ibfk_2/subscrib
> er_id/voip_subscribers/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibf
> k_1/domain_id/voip_domains/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_dom_preferences/voip_dom_preferences_ibf
> k_2/attribute_id/voip_preferences/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_fax_destinations/voip_fax_destinations_i
> bfk_1/subscriber_id/voip_subscribers/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_fax_preferences/voip_fax_preferences_ibf
> k_1/subscriber_id/voip_subscribers/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_peer_preferences/voip_peer_preferences_i
> bfk_1/peer_host_id/voip_peer_hosts/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_peer_preferences/voip_peer_preferences_i
> bfk_2/attribute_id/voip_preferences/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_subscribers/voip_subscribers_ibfk_1/doma
> in_id/voip_domains/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibf
> k_1/subscriber_id/voip_subscribers/id
> is missing in local db
>
> Element:
> constraints/provisioning/voip_usr_preferences/voip_usr_preferences_ibf
> k_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.htm>

------------------------------

Subject: Digest Footer

Spce-user mailing list
Spce-user at lists.sipwise.com
http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com


------------------------------

End of Spce-user Digest, Vol 68, Issue 2
****************************************

More information about the Spce-user mailing list