search

ecrin-github / MDR_Aggregator

MIT License
1 stars 0 forks source link

Phase 5: `relation "core.new_search_idents" does not exist` - `core.new_search_pmids` - `core.new_search_lexemes` #10

Open michelescarlato opened 1 month ago

michelescarlato commented 1 month ago 
08/09/2024 : 17:00 :   **** SETUP ****

08/09/2024 : 17:00 :   transfer data =  False
08/09/2024 : 17:00 :   create core =  False
08/09/2024 : 17:00 :   create json =  False
08/09/2024 : 17:00 :   do statistics =  False
08/09/2024 : 17:00 :   do iec =  False
08/09/2024 : 17:00 :   do indices =  True
08/09/2024 : 17:00 :   FTW tables recreated

08/09/2024 : 17:00 :   **** SETTING UP STUDY SEARCH TABLES ****

08/09/2024 : 17:00 :   **** CREATING JSON STUDY DATA ****

08/09/2024 : 17:00 :   **** CREATING DATA IN SEARCH TABLES ****

+++++++++++++++++++++++++++++++++++++++
08/09/2024 : 17:00 :   ***ERROR*** In ExecuteSQL; 42P01: relation "core.new_search_idents" does not exist

POSITION: 8, 
SQL was: update core.new_search_idents s
                              set study_json = sj.search_res
                              from core.search_studies_json sj
                              where s.study_id = sj.id  and s.study_id >= 0 and s.study_id < 10000 
+++++++++++++++++++++++++++++++++++++++

08/09/2024 : 17:00 :   0 idents search records updated with study json data

+++++++++++++++++++++++++++++++++++++++
08/09/2024 : 17:00 :   ***ERROR*** In ExecuteSQL; 42P01: relation "core.new_search_pmids" does not exist

POSITION: 8, 
SQL was: update core.new_search_pmids s
                              set study_json = sj.search_res
                              from core.new_search_studies_json sj
                              where s.study_id = sj.id  and s.study_id >= 0 and s.study_id < 10000 
+++++++++++++++++++++++++++++++++++++++

08/09/2024 : 17:00 :   0 pmids search records updated with study json data

+++++++++++++++++++++++++++++++++++++++
08/09/2024 : 17:00 :   ***ERROR*** In ExecuteSQL; 42P01: relation "core.new_search_lexemes" does not exist

POSITION: 8, 
SQL was: update core.new_search_lexemes s
                              set study_json = sj.search_res
                              from core.new_search_studies_json sj
                              where s.study_id = sj.id  and s.study_id >= 0 and s.study_id < 10000 
+++++++++++++++++++++++++++++++++++++++

08/09/2024 : 17:00 :   0 lexemes search records updated with study json data
08/09/2024 : 17:00 :   FTW tables dropped

08/09/2024 : 17:00 :   **** CLOSING LOG ****
michelescarlato commented 1 month ago

This error are thrown by the version of the Aggregator built upon the feature branch: feature/bump-packages/

It looks like the code in this branch creates tables that were not created before.