<div dir="ltr"><div dir="ltr">Hi Marco,<div><br></div><div>Thank You for the solution.</div><div>Unfortunately, after executing the indicated commands, the problem still occurs:<br># apt-get update<br># apt-get upgrade<br># ngcp-update-db-schema<br># ngcpcfg apply 'updates packages'<br># ngcp-status<br>DB: detected divergence in mysql schemes, run ngcp-mysql-compare-dbs to check details</div><div><br># ngcp-mysql-compare-dbs<br>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>Schema accounting is equal to 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_usr_preferences/creation_timestamp is missing in json file<br>Schema sipstats is equal to json file<br>Schema ngcp is equal to json file<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>Schema billing is equal to json file<br></div></div><div><br></div><div>Best Regards,</div><div>Rickey</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">pon., 23 paź 2023 o 09:34 Marco Capetta via Spce-user <<a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a>> napisał(a):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
<font face="monospace">Hi Rickey,<br>
<br>
please try to update all the packages in your system, in
particular 'ngcp-db-schema', and execute the commands<br>
ngcp-update-db-schema<br>
ngcpcfg apply 'updates packages'<br>
<br>
After that please check again if you have divergences in the mysql
schemes<br>
<br>
<br>
Thank you<br>
<br>
Best Regards<br>
Marco<br>
<br>
</font><br>
<div>On 18/10/23 17:09, Michael Prokop via
Spce-user wrote:<br>
</div>
<blockquote type="cite">
<pre>Hi,
* Rickey [Wed Oct 18, 2023 at 03:41:53PM +0200]:
</pre>
<blockquote type="cite">
<pre>Has the message reached the group?
</pre>
</blockquote>
<pre>Yes, your mails arrived fine, we can reproduce the issue and are
working on it (known as MT#58530 internally, FTR).
regards
-mika-
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre>After upgrade from CE mr9.5.4 to CE mr11.5.1 following the instructions:
<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>
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
</pre>
</blockquote>
</blockquote>
<pre>[...]
</pre>
</blockquote>
<br>
<div>-- <br>
<div style="line-height:16px;margin:6px 0px;padding:8px;border-top:1px dotted rgb(174,177,166);border-bottom:1px dotted rgb(174,177,166);font-family:"Lucida Sans","Lucida Grande",Verdana,Arial,sans-serif;font-size:11px;color:rgb(85,85,85)"> <strong style="color:rgb(51,51,51);text-transform:uppercase;font-size:10px"> Marco Capetta </strong> <br>
R&D Manager
<p> <a href="http://www.sipwise.com" style="border-bottom:1px dotted rgb(170,170,170);color:rgb(0,136,204);text-decoration:none" target="_blank"> Sipwise GmbH | an ALE
Company </a><br>
c/o ALE International – Austria Branch<br>
Saturn Tower<br>
Leonard-Bernstein-Straße 10<br>
1220 Vienna, Austria </p>
<p> Email: <a href="mailto:mcapetta@sipwise.com" style="border-bottom:1px dotted rgb(170,170,170);color:rgb(0,136,204);text-decoration:none" target="_blank"> mcapetta@sipwise.com </a> <br>
Website: <a href="http://www.sipwise.com" style="border-bottom:1px dotted rgb(170,170,170);color:rgb(0,136,204);text-decoration:none" target="_blank"> www.sipwise.com </a>
</p>
</div>
</div>
</div>
-- <br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div></div>