CDR Post upgrade failure

Yeti-Switch
1

Hello Everyone,
I upgraded to version 1.11 from 1.10 and cdr table can’t write into database.
Rest system works correctly

 dpkg -l | grep yeti
ii  postgresql-13-yeti              1.3.3p4                       amd64        provides YETI extension for PostgreSQL
ii  sems-modules-yeti               1.11.14core50                 amd64        YETI SBC application module for SEMS
ii  yeti-cli                        2.1.2p2                       all          simple client for jsonrpc
ii  yeti-management                 1.9.0                         amd64        management node for YETI project
ii  yeti-web                        1.11.20                       amd64        UI for YETI project

Error in postgresql

2023-01-05 18:21:59.637 EST [25755] cdr@cdr ERROR:  no partition of relation "streams" found for row
2023-01-05 18:21:59.637 EST [25755] cdr@cdr DETAIL:  Partition key of the failing row contains (time_start) = (2022-12-31 09:34:54.578346-05).
2023-01-05 18:21:59.637 EST [25755] cdr@cdr CONTEXT:  SQL statement "INSERT INTO rtp_statistics.streams VALUES( v_rtp_stream_data.*)"
        PL/pgSQL function writecdr(boolean,integer,integer,integer,boolean,smallint,character varying,integer,character varying,integer,smallint,character varying,integer,character varying,integer,character varying,character varying,json,boolean,integer,character varying,integer,integer,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,integer,boolean,json,json,character varying,character varying,json,smallint,bigint,json,json,boolean,json,json) line 258 at SQL statement
2023-01-05 18:21:59.637 EST [25755] cdr@cdr STATEMENT:  SELECT writecdr($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45);

Jan  5 22:07:54 sbc0 sems[31386]: [31442/yeti:cdr/CdrWriter.cpp:577] ERROR: Cant write record to master database
Jan  5 22:07:56 sbc0 sems[31386]: [31443/yeti:cdr/CdrWriter.cpp:577] ERROR: Cant write record to master database
2

looks like there is no partition for rtp_statistics.streams. Easiest way to fix it - wait 1h until scheduler CdrPartitioning will create it.

3

I waited , but tables wasn’t created. How I can check which process is responsible for it.

4

check yeti-scheduler service

5

I don’t see such service. How this service need to be installed ?

root@sbc0:~# systemctl -l | grep  yeti 
  yeti-cdr-billing@cdr_billing.service                                                      loaded active running   YETI CDR billing: cdr_billing                                                
  yeti-delayed-job.service                                                                  loaded active running   YETI system web interface delayed jobs                                       
  yeti-management.service                                                                   loaded active running   LSB: YETI management node                                                    
  yeti-web.service                                                                          loaded active running   YETI system web interface                                                    
  system-yeti\x2dcdr\x2dbilling.slice                                                       loaded active active    system-yeti\x2dcdr\x2dbilling.slice                                          
root@sbc0:~#
6

I found , the service was masked some reason. I upgraded OS too, that might the cause, but yeti-scheduler is running and system is refreshed. Thank you again.