<div dir="ltr"><div dir="ltr">Has the message reached the group?<br></div><div dir="ltr"><br></div><div>BR</div><div>Rickey</div><div dir="ltr"><div dir="ltr"><br></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>After upgrade from CE mr9.5.4 to CE mr11.5.1 following the instructions:</div><div><a href="https://www.sipwise.com/doc/mr11.5.1/spce/ce/mr11.5.1/upgrade/upgrade.html" target="_blank">https://www.sipwise.com/doc/mr11.5.1/spce/ce/mr11.5.1/upgrade/upgrade.html</a></div><div><br></div><div>and running:</div><div>ngcp-status<br></div><div><br></div><div>I've got red alert on DB section:</div><div>detected divergence in mysql schemes, run ngcp-mysql-compare-dbs to check details<br></div><div><br></div><div>After running:</div><div>ngcp-mysql-compare-dbs<br></div><div><br></div><div>I've got:</div><div>Schema stats is equal to json file<br>Schema carrier is equal to json file<br>Schema ldap is equal to json file<br>Schema fileshare is equal to json file<br>Schema syslog is equal to json file<br>The following errors were found:<br><br>Element: tables/accounting/cdr_202203 is missing in json file<br>Element: tables/accounting/cdr_202205 is missing in json file<br>Element: tables/accounting/cdr_202206 is missing in json file<br>Element: tables/accounting/cdr_202207 is missing in json file<br>Element: tables/accounting/cdr_group_202203 is missing in json file<br>Element: tables/accounting/cdr_group_202205 is missing in json file<br>Element: tables/accounting/cdr_group_202206 is missing in json file<br>Element: tables/accounting/cdr_group_202207 is missing in json file<br>Element: tables/accounting/cdr_mos_data_202203 is missing in json file<br>Element: tables/accounting/cdr_mos_data_202205 is missing in json file<br>Element: tables/accounting/cdr_mos_data_202206 is missing in json file<br>Element: tables/accounting/cdr_mos_data_202207 is missing in json file<br>Element: tables/accounting/cdr_period_costs_202203 is missing in json file<br>Element: tables/accounting/cdr_period_costs_202206 is missing in json file<br>Element: tables/accounting/cdr_tag_data_202203 is missing in json file<br>Element: tables/accounting/cdr_tag_data_202205 is missing in json file<br>Element: tables/accounting/cdr_tag_data_202206 is missing in json file<br>Element: tables/accounting/cdr_tag_data_202207 is missing in json file<br>Element: columns/accounting/prepaid_costs/timestamp/column_default are not equal:<br> ---<br> local db: current_timestamp()<br> json file: NULL<br>Element: columns/accounting/prepaid_costs/timestamp/extra are not equal:<br> ---<br> local db: on update current_timestamp()<br> json file:<br>The following errors were found:<br><br>Element: columns/kamailio/reseller_preferences/last_modified/extra are not equal:<br> ---<br> local db: on update current_timestamp()<br> json file:<br>Element: columns/kamailio/usr_preferences/last_modified/extra are not equal:<br> ---<br> local db: on update current_timestamp()<br> json file:<br>The following errors were found:<br><br>Element: columns/provisioning/voip_allowed_ip_groups/ipnet/column_type are not equal:<br> ---<br> local db: varchar(43)<br> json file: varchar(46)<br>Element: columns/provisioning/voip_time_periods/end/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/provisioning/voip_time_periods/start/column_default are not equal:<br> ---<br> local db: current_timestamp()<br> json file: NULL<br>Element: columns/provisioning/voip_time_periods/start/extra are not equal:<br> ---<br> local db: on update current_timestamp()<br> json file:<br>Element: columns/provisioning/voip_usr_preferences/creation_timestamp is missing in json file<br>Schema sipstats is equal to json file<br>The following errors were found:<br><br>Element: columns/ngcp/timezone/created_at/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/ngcp/timezone/modified_at/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/ngcp/tzinfo_version/created_at/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/ngcp/tzinfo_version/modified_at/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>The following errors were found:<br><br>Element: routines/prosody/uuidtobin/routine_definition are not equal:<br> ---<br> local db: RETURN<br> UNHEX(CONCAT(<br> SUBSTR(_uuid, 15, 4),<br> SUBSTR(_uuid, 10, 4),<br> SUBSTR(_uuid, 1, 8),<br> SUBSTR(_uuid, 20, 4),<br> SUBSTR(_uuid, 25) ));<br> json file: RETURN<br> UNHEX(CONCAT(<br> SUBSTR(_uuid, 15, 4),<br> SUBSTR(_uuid, 10, 4),<br> SUBSTR(_uuid, 1, 8),<br> SUBSTR(_uuid, 20, 4),<br> SUBSTR(_uuid, 25) ))<br>The following errors were found:<br><br>Element: columns/billing/contacts/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/contacts/create_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/contract_credits/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/contract_credits/create_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/contracts/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/customers/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/customers/create_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/orders/complete_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/orders/complete_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/orders/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/orders/create_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/payments/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/payments/create_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: columns/billing/voip_intercept/create_timestamp/column_default are not equal:<br> ---<br> local db: '0000-00-00 00:00:00'<br> json file: NULL<br>Element: columns/billing/voip_numbers/list_timestamp/column_default are not equal:<br> ---<br> local db: current_timestamp()<br> json file: NULL<br>Element: columns/billing/voip_numbers/list_timestamp/extra are not equal:<br> ---<br> local db: on update current_timestamp()<br> json file:<br>Element: columns/billing/voip_numbers/list_timestamp/is_nullable are not equal:<br> ---<br> local db: NO<br> json file: YES<br>Element: indexes/billing/voip_numbers/listts_idx/1/nullable are not equal:<br> ---<br> local db:<br> json file: YES<br></div><div><br></div><div>How to fix this?</div><div><br></div><div>BR,</div><div>Rickey</div></div>
</blockquote></div></div>
</div>