Asterisk 21. Attempted to update column 'generator_data' in table 'ps_subscription_persistence', but column does not exist!

Asterisk Asterisk Support
1

Hi, I’m using Asterisk 21.4.3.
Created database for realtime PJSIP over alembic and handle this issue.

[Sep 23 09:59:35] ERROR[3315]: res_config_pgsql.c:167 _pgsql_exec: PostgreSQL RealTime: Failed to query 'ps_subscription_persistence@asterisk'.
[Sep 23 09:59:35] ERROR[3315]: res_config_pgsql.c:168 _pgsql_exec: PostgreSQL RealTime: Query 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 ('ade0a37f-0ecd-4b17-a715-d9d8ebc39e28', '0', '0', '0', '0', 'no', '1102', '', '', '', '', '663677af-f2dc-44e4-af30-a3a647131f03', '', '0')
[Sep 23 09:59:35] ERROR[3315]: res_config_pgsql.c:169 _pgsql_exec: PostgreSQL RealTime: Query Failed because: ERROR:  column "generator_data" of relation "ps_subscription_persistence" does not exist
LINE 1: ...es, transport_key, cseq, prune_on_boot, endpoint, generator_...
                                                                                                 ^
 (PGRES_FATAL_ERROR)

[Sep 23 09:59:35] NOTICE[3315] res_config_pgsql.c: Attempted to update column 'generator_data' in table 'ps_subscription_persistence', but column does not exist!

At res_pgsql.conf seted:
requirements = createclose

But this doen’t help.

Created this column manually and issue was resolved.

Dear support team, coud you add this to new release alembic.

2

Issues are reported on the issue tracker[1], not the forum.

[1] Issues · asterisk/asterisk · GitHub

3

Thank you for link.

4

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