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

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/20231017/8cc7d15f/attachment-0001.html>