Upgraded from 16.6.2 to 16.14.0 and get the following warnings

Asterisk Asterisk SIP
1

[2020-10-20 14:41:58.197] WARNING[18111]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [ma-3.0.3][10.3.23-MariaDB-0+deb10u1-log]Unknown column ‘generator_data’ in ‘field list’
[2020-10-20 14:41:58.197] WARNING[18111]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [INSERT INTO ps_subscription_persistence (id, src_port, expires, transport_key, cseq, prune_on_boot, endpoint, generator_data, packet, src_name, local_name, tag, contact_uri, local_port) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

The field generator_data doesn’t exist in the database table ps_subscription_persistence.

I have looked in contrib/ast-db-manage/config/versions and it appears this field is never created by alembic.

Harley

2

Is there a reason you are putting subscription persistence into ODBC? It is generally not needed.

3

No there isn’t I just set everything up to use a realtime database a long time ago never was a problem before.
It’s just a Android soft phone generating presence info. There is no way to disable it in the softphone config.
If I create the field the errors go away but I’m not sure the correct format for the field.
Or I could just remove ps_subscription_persistence => odbc,asterisk.

4

You can just remove that ps_subscription_persistence, they will be stored in the local astdb.

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.