[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]

Has the message reached the group?

BR
Rickey

Hello,
>
> 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
>
> I've got:
> 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
> The following errors were found:
>
> Element: tables/accounting/cdr_202203 is missing in json file
> Element: tables/accounting/cdr_202205 is missing in json file
> Element: tables/accounting/cdr_202206 is missing in json file
> Element: tables/accounting/cdr_202207 is missing in json file
> Element: tables/accounting/cdr_group_202203 is missing in json file
> Element: tables/accounting/cdr_group_202205 is missing in json file
> Element: tables/accounting/cdr_group_202206 is missing in json file
> Element: tables/accounting/cdr_group_202207 is missing in json file
> Element: tables/accounting/cdr_mos_data_202203 is missing in json file
> Element: tables/accounting/cdr_mos_data_202205 is missing in json file
> Element: tables/accounting/cdr_mos_data_202206 is missing in json file
> Element: tables/accounting/cdr_mos_data_202207 is missing in json file
> Element: tables/accounting/cdr_period_costs_202203 is missing in json file
> Element: tables/accounting/cdr_period_costs_202206 is missing in json file
> Element: tables/accounting/cdr_tag_data_202203 is missing in json file
> Element: tables/accounting/cdr_tag_data_202205 is missing in json file
> Element: tables/accounting/cdr_tag_data_202206 is missing in json file
> Element: tables/accounting/cdr_tag_data_202207 is missing in json file
> Element: columns/accounting/prepaid_costs/timestamp/column_default are not
> equal:
>   ---
>   local db:  current_timestamp()
>   json file: NULL
> Element: columns/accounting/prepaid_costs/timestamp/extra are not equal:
>   ---
>   local db:  on update current_timestamp()
>   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_time_periods/end/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/provisioning/voip_time_periods/start/column_default are
> not equal:
>   ---
>   local db:  current_timestamp()
>   json file: NULL
> Element: columns/provisioning/voip_time_periods/start/extra are not equal:
>   ---
>   local db:  on update current_timestamp()
>   json file:
> Element: columns/provisioning/voip_usr_preferences/creation_timestamp is
> missing in json file
> Schema sipstats is equal to json file
> The following errors were found:
>
> Element: columns/ngcp/timezone/created_at/is_nullable are not equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/ngcp/timezone/modified_at/is_nullable are not equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/ngcp/tzinfo_version/created_at/is_nullable are not equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/ngcp/tzinfo_version/modified_at/is_nullable are not equal:
>   ---
>   local db:  NO
>   json file: YES
> 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) ))
> The following errors were found:
>
> Element: columns/billing/contacts/create_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/contacts/create_timestamp/is_nullable are not
> equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/contract_credits/create_timestamp/column_default
> are not equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/contract_credits/create_timestamp/is_nullable are
> not equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/contracts/create_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/customers/create_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/customers/create_timestamp/is_nullable are not
> equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/orders/complete_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/orders/complete_timestamp/is_nullable are not
> equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/orders/create_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/orders/create_timestamp/is_nullable are not equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/payments/create_timestamp/column_default are not
> equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/payments/create_timestamp/is_nullable are not
> equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: columns/billing/voip_intercept/create_timestamp/column_default
> are not equal:
>   ---
>   local db:  '0000-00-00 00:00:00'
>   json file: NULL
> Element: columns/billing/voip_numbers/list_timestamp/column_default are
> not equal:
>   ---
>   local db:  current_timestamp()
>   json file: NULL
> Element: columns/billing/voip_numbers/list_timestamp/extra are not equal:
>   ---
>   local db:  on update current_timestamp()
>   json file:
> Element: columns/billing/voip_numbers/list_timestamp/is_nullable are not
> equal:
>   ---
>   local db:  NO
>   json file: YES
> Element: indexes/billing/voip_numbers/listts_idx/1/nullable are not equal:
>   ---
>   local db:
>   json file: YES
>
> How to fix this?
>
> BR,
> Rickey
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20231018/5104b32c/attachment-0001.html>