Yeti web data insert return error 500

Yeti-Switch
1

Hello Everyone,
I am trying to update few customer auth entries in yeti web 1.12 and on each insert return error 500

ActiveRecord::StatementInvalid (PG::InternalError: ERROR:  No such queue#012CONTEXT: 

Jul 22 06:06:42 sbc0 yeti-web[1255]: [5fca6523-326a-47f3-81cb-4236905c7b5d] Completed 500 Internal Server Error in 111ms (Allocations: 17297)
Jul 22 06:06:42 sbc0 yeti-web[1255]: [5fca6523-326a-47f3-81cb-4236905c7b5d] [5fca6523-326a-47f3-81cb-4236905c7b5d] ActiveRecord::StatementInvalid (PG::InternalError: ERROR:  No such queue#012CONTEXT:  PL/pgSQL function pgq.insert_event(text,text,text,text,text,text,text) line 24 at RETURN#012PL/pgSQL function pgq.insert_event(text,text,text) line 18 at RETURN#012):#012[5fca6523-326a-47f3-81cb-4236905c7b5d]   #012[5fca6523-326a-47f3-81cb-4236905c7b5d] app/models/concerns/pg_event.rb:19:in `pgq_insert_event'#012[5fca6523-326a-47f3-81cb-4236905c7b5d] app/models/concerns/pg_event.rb:40:in `pg_event!'#012[5fca6523-326a-47f3-81cb-4236905c7b5d] app/models/concerns/pg_event.rb:36:in `pg_record_update'#012[5fca6523-326a-47f3-81cb-4236905c7b5d] app/admin/routing/customers_auths.rb:98:in `update'#012[5fca6523-326a-47f3-81cb-4236905c7b5d] config/initializers/instrumentation_notification.rb:32:in `block in process_action'#012[5fca6523-326a-47f3-81cb-4236905c7b5d] config/initializers/instrumentation_notification.rb:31:in `process_action'
2

As side note I followed upgrade procedure.

https://yeti-switch.org/docs/en/installation/installation-1.12/upgrade-from-1.11.html
3 

UI VERSION	1.12.90
ROUTING VERSION	20230717103315
CDR VERSION	20230708183812
RUBY	3.2.2/x86_64-linux/2023-03-30
SWITCH INTERFACE	switch20
4

looks like you have no proper queues in database by some reasons. show output of select * from pgq.get_queue_info()

5 
yeti=# select * from pgq.get_queue_info();
 queue_name | queue_ntables | queue_cur_table | queue_rotation_period | queue_switch_time | queue_external_ticker
 | queue_ticker_paused | queue_ticker_max_count | queue_ticker_max_lag | queue_ticker_idle_period | ticker_lag | 
ev_per_sec | ev_new | last_tick_id 
------------+---------------+-----------------+-----------------------+-------------------+----------------------
-+---------------------+------------------------+----------------------+--------------------------+------------+-
-----------+--------+--------------
(0 rows)

yeti=#
6

I did a bit more testing and only Customer Auth is affected.

7

you can try to create queue by

select pgq.create_queue('gateway-sync');

But something seriously wrong with your database, so you may face other issues.

8

Thank you, recreation of queue is resolved the issue.