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

[Jiri Ptacnik]

same problem with divergence on upgrade from latest LTS 10.5. to latest LTS 11

after suggested solution i have this:

root at spce:~# ngcp-mysql-compare-dbs
Schema fileshare is equal to json file
Schema sipstats is equal to json file
Schema billing is equal to json file
Schema syslog is equal to json file
Schema stats is equal to json file
Schema ldap is equal to json file
Schema accounting is equal to json file
Schema ngcp is equal to json file
Schema kamailio is equal to json file
Schema prosody is equal to json file
Schema carrier is equal to 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)


JiriP

po 23. 10. 2023 v 9:52 odesílatel Rickey <rickey58 at gmail.com> napsal:
>
> 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
>> 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
>
> --
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com