Skip to content

Change "errors" for missing data to "warning" or "info" to avoid postgres logging them

Postgres logs are filled with this type of error message:

2024-03-28 17:40:19 UTC [2291]: app=hive_server STATEMENT:  SELECT * FROM hivemind_app.condenser_get_content('steemychicken1', 'pglwzhbavs')
2024-03-28 17:40:19 UTC [593]: app=hive_server ERROR:  Post travoved/ynsbhlpfgx does not exist
2024-03-28 17:40:19 UTC [593]: app=hive_server CONTEXT:  PL/pgSQL function hivemind_app.find_comment_id(character varying,character varying,boolean) line 22 at RAISE
        PL/pgSQL function hivemind_app.condenser_get_content(character varying,character varying) line 5 at assignment
2024-03-28 17:40:19 UTC [593]: app=hive_server STATEMENT:  SELECT * FROM hivemind_app.condenser_get_content('travoved', 'ynsbhlpfgx')
2024-03-28 17:40:19 UTC [522]: app=hive_server ERROR:  Post firulaixcoin/hzqwpsbnxx does not exist
2024-03-28 17:40:19 UTC [522]: app=hive_server CONTEXT:  PL/pgSQL function hivemind_app.find_comment_id(character varying,character varying,boolean) line 22 at RAISE
        PL/pgSQL function hivemind_app.condenser_get_content(character varying,character varying) line 5 at assignment