[OpenSIPS-Users] OpenSIPS 3.1 - DB version table error

Mark Allen mark at allenclan.co.uk
Tue Jul 28 07:54:57 EST 2020


Getting version table errors on startup after move to 3.1...

    ERROR:core:db_check_table_version: invalid version 10 for table dialog
found, expected 11

Version 3.1 is built from 3.1 branch on GitHub. I think I've followed the
documentation correctly but OpenSIPS 3.1 is not starting and I'm seeing
this error. On our test setup I've tried both...

    opensips-cli -x database migrate 3.0_to_3.1 opensips opensips_3_1

and

    opensips-cli -x database create opensips-3_1


Using DB opensips-3_1, a 'SELECT * FROM version;' gives the following...

after database migration:
+------------------+---------------+
| table_name       | table_version |
+------------------+---------------+
| acc              |             7 |
| address          |             5 |
| clusterer        |             4 |
| dbaliases        |             2 |
| dialog           |            10 |
| dialplan         |             5 |
| dispatcher       |             8 |
| domain           |             3 |
| dr_carriers      |             2 |
| dr_gateways      |             6 |
| dr_groups        |             2 |
| dr_partitions    |             1 |
| dr_rules         |             3 |
| grp              |             3 |
| load_balancer    |             2 |
| location         |          1013 |
| missed_calls     |             5 |
| re_grp           |             2 |
| rtpengine        |             1 |
| rtpproxy_sockets |             0 |
| silo             |             6 |
| speed_dial       |             3 |
| subscriber       |             7 |
| tls_mgm          |             3 |
| uri              |             2 |
| usr_preferences  |             3 |
+------------------+---------------+

after database creation:
+------------------+---------------+
| table_name       | table_version |
+------------------+---------------+
| acc              |             7 |
| address          |             5 |
| clusterer        |             4 |
| dbaliases        |             2 |
| dialog           |            10 |
| dialplan         |             5 |
| dispatcher       |             8 |
| domain           |             3 |
| dr_carriers      |             2 |
| dr_gateways      |             6 |
| dr_groups        |             2 |
| dr_partitions    |             1 |
| dr_rules         |             3 |
| grp              |             3 |
| load_balancer    |             2 |
| location         |          1013 |
| missed_calls     |             5 |
| re_grp           |             2 |
| rtpengine        |             1 |
| rtpproxy_sockets |             0 |
| silo             |             6 |
| speed_dial       |             3 |
| subscriber       |             7 |
| tls_mgm          |             3 |
| uri              |             2 |
| usr_preferences  |             3 |
+------------------+---------------+

What am I missing????

Documentation used:
https://github.com/OpenSIPS/opensips/blob/master/INSTALL
https://www.opensips.org/Documentation/Migration-3-0-0-to-3-1-0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200728/238dbc66/attachment.html>


More information about the Users mailing list