[SR-Users] invalid version 8 for table aliases found, expected 9

[Abdulaziz Alghosh]

hi Henning,

No. To read this table I am using usrloc module :/
So, We are using lookup() function of the registrar module whereas the
aliases table (has version 8) was given as parameter but not location (has
version 9).

I got rid of this error by writing lookup("location") instead of
lookup("aliases").

Thus, I have a new question :

Should one only use lookup() function of the registrar module along with
usrloc module to query only the "location" table ?
or
Use only alias_db_lookup() function from alias_db module to query the
"aliases" table ?

what I was exactly getting as an error is below:

 0(4231) ERROR: <core> [db.c:450]: db_check_table_version(): invalid
version 8 for table aliases found, expected 9 (check table structure and
table "version")
 0(4231) ERROR: usrloc [dlist.c:649]: register_udomain(): error during
table version check.
 0(4231) ERROR: registrar [registrar.c:651]: domain_fixup(): failed to
register domain
 0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
(code=-1) at cfg://etc/kamailio/kamailio.cfg:1065
 0(4231) ERROR: <core> [core/rvalue.c:3860]: fix_rval_expr(): failure in
cfg at line: 1065 col: 28
 0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
(code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
 0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
(code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
 0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
(code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
 0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
(code=-1) at cfg://etc/kamailio/kamailio.cfg:1276


Best Regards
Abdul




On Tue, Aug 21, 2018 at 2:06 PM, Henning Westerholt <hw at kamailio.org> wrote:
>
> Am Dienstag, 21. August 2018, 13:31:36 CEST schrieb Abdulaziz Alghosh:
> > i am trying to start kamailio 5.1.4 after the migration from Kamailio
3.0.3
> > but getting newly the following error:
> >
> > ERROR: <core> [db.c:450]: db_check_table_version(): invalid version 8
for
> > table aliases found, expected 9 (check table structure and table
"version")
> >
> > Allegedlly, this error is because of a wrong version of "aliases"
table. I
> > followed the Upgrade process starting from 3.0.3 till 5.1.x and I
altered
> > the structure of my aliase table accordinglly.
> > The last new version of aliases is 8 as it is described at the upgrade
from
> > 4.2.x to 4.3.0
> >
> > Even though, the error here says that the newest version is 9:
> >
> > May someone help me to find out if the aliases table's structure was
> > renewed in between ?? Is there any modification in the data types?
>
> Hello Abdulaziz,
>
> version 8 is the current version of the alias table, even in git master.
>
> $ kamailio/src> grep "version" lib/srdb1/schema/aliases.xml
> <?xml version="1.0" encoding="UTF-8"?>
>     <version>8</version>
>
> I am a bit confused, do you actually try to read this table from the
alias_db
> module? Because I was not able to find a version check here in the code.
>
> Version 9 is only used from location table.
>
> Please quote a bit more lines of your error here.
>
> Best regards,
>
> Henning
>
> --
> Henning Westerholt
> https://skalatan.de/blog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180821/665eb8b1/attachment.html>