[Spce-user] Upgrade CE mr9.5.4 -> CE mr11.5.1: detected divergence in mysql schemes, run ngcp-mysql-compare-dbs to check details

[Rickey]

Hi Marco,

Thank You for the solution.
Unfortunately, after executing the indicated commands, the problem still
occurs:
# apt-get update
# apt-get upgrade
# ngcp-update-db-schema
# ngcpcfg apply 'updates packages'
# ngcp-status
DB: detected divergence in mysql schemes, run ngcp-mysql-compare-dbs to
check details

# ngcp-mysql-compare-dbs
Schema stats is equal to json file
Schema carrier is equal to json file
Schema ldap is equal to json file
Schema fileshare is equal to json file
Schema syslog is equal to json file
Schema accounting is equal to json file
The following errors were found:

Element: columns/kamailio/reseller_preferences/last_modified/extra are not
equal:
  ---
  local db: on update current_timestamp()
  json file:
Element: columns/kamailio/usr_preferences/last_modified/extra are not equal:
  ---
  local db: on update current_timestamp()
  json file:
The following errors were found:

Element: columns/provisioning/voip_allowed_ip_groups/ipnet/column_type are
not equal:
  ---
  local db: varchar(43)
  json file: varchar(46)
Element: columns/provisioning/voip_usr_preferences/creation_timestamp is
missing in json file
Schema sipstats is equal to json file
Schema ngcp is equal to json file
The following errors were found:

Element: routines/prosody/uuidtobin/routine_definition are not equal:
  ---
  local db: RETURN
    UNHEX(CONCAT(
        SUBSTR(_uuid, 15, 4),
        SUBSTR(_uuid, 10, 4),
        SUBSTR(_uuid, 1, 8),
        SUBSTR(_uuid, 20, 4),
        SUBSTR(_uuid, 25) ));
  json file: RETURN
    UNHEX(CONCAT(
        SUBSTR(_uuid, 15, 4),
        SUBSTR(_uuid, 10, 4),
        SUBSTR(_uuid, 1, 8),
        SUBSTR(_uuid, 20, 4),
        SUBSTR(_uuid, 25) ))
Schema billing is equal to json file

Best Regards,
Rickey

pon., 23 paź 2023 o 09:34 Marco Capetta via Spce-user <
spce-user at lists.sipwise.com> napisał(a):

> Hi Rickey,
>
> please try to update all the packages in your system, in particular
> 'ngcp-db-schema', and execute the commands
> ngcp-update-db-schema
> ngcpcfg apply 'updates packages'
>
> After that please check again if you have divergences in the mysql schemes
>
>
> Thank you
>
> Best Regards
> Marco
>
>
> On 18/10/23 17:09, Michael Prokop via Spce-user wrote:
>
> Hi,
>
> * Rickey [Wed Oct 18, 2023 at 03:41:53PM +0200]:
>
>
> Has the message reached the group?
>
> Yes, your mails arrived fine, we can reproduce the issue and are
> working on it (known as MT#58530 internally, FTR).
>
> regards
> -mika-
>
>
> After upgrade from CE mr9.5.4 to CE mr11.5.1 following the instructions:https://www.sipwise.com/doc/mr11.5.1/spce/ce/mr11.5.1/upgrade/upgrade.html
>
> and running:
> ngcp-status
>
> I've got red alert on DB section:
> detected divergence in mysql schemes, run ngcp-mysql-compare-dbs to check
> details
>
> After running:
> ngcp-mysql-compare-dbs
>
> [...]
>
>
>
> --
> * Marco Capetta *
> R&D Manager
>
> Sipwise GmbH | an ALE Company <http://www.sipwise.com>
> c/o ALE International – Austria Branch
> Saturn Tower
> Leonard-Bernstein-Straße 10
> 1220 Vienna, Austria
>
> Email:  mcapetta at sipwise.com
> Website:  www.sipwise.com
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20231023/61a6516b/attachment.html>