io.tolgee.api.v2.controllers.v2KeyController.KeyControllerKeySearchTest: search is not slow(): jakarta.persistence.QueryTimeoutException: JDBC exception executing SQL [select p1_0.id,l1_0.id,l1_0.tag,l1_0.name,l1_0.original_name,l1_0.flag_emoji,(select coalesce(count(distinct k1_0.name),?) from project p2_0 join key k1_0 on p2_0.id=k1_0.project_id left join branch b1_0 on b1_0.id=k1_0.branch_id join translation t1_0 on k1_0.id=t1_0.key_id and t1_0.state=? and t1_0.language_id=l1_0.id where (k1_0.branch_id is null or b1_0.is_default) and k1_0.deleted_at is null),(select coalesce(sum(t3_0.word_count),?) from project p3_0 join key k2_0 on p3_0.id=k2_0.project_id left join branch b3_0 on b3_0.id=k2_0.branch_id join translation t2_0 on k2_0.id=t2_0.key_id and t2_0.state=? and t2_0.language_id=l1_0.id left join translation t3_0 on k2_0.id=t3_0.key_id and t3_0.language_id=p3_0.base_language_id where (k2_0.branch_id is null or b3_0.is_default) and k2_0.deleted_at is null),(select coalesce(count(distinct k3_0.name),?) from project p4_0 join key k3_0 on p4_0.id=k3_0.project_id left join branch b5_0 on b5_0.id=k3_0.branch_id join translation t4_0 on k3_0.id=t4_0.key_id and t4_0.state=? and t4_0.language_id=l1_0.id where (k3_0.branch_id is null or b5_0.is_default) and k3_0.deleted_at is null),(select coalesce(sum(t6_0.word_count),?) from project p5_0 join key k4_0 on p5_0.id=k4_0.project_id left join branch b7_0 on b7_0.id=k4_0.branch_id join translation t5_0 on k4_0.id=t5_0.key_id and t5_0.state=? and t5_0.language_id=l1_0.id left join translation t6_0 on k4_0.id=t6_0.key_id and t6_0.language_id=p5_0.base_language_id where (k4_0.branch_id is null or b7_0.is_default) and k4_0.deleted_at is null) from project p1_0 join language l1_0 on p1_0.id=l1_0.project_id where p1_0.id in (?) group by 2,1] [ERROR: canceling statement due to statement timeout] [n/a] - jakarta.persistence.QueryTimeoutException: JDBC exception executing SQL [select p1_0.id,l1_0.id,l1_0.tag,l1_0.name,l1_0.original_name,l1_0.flag_emoji,(select coalesce(count(distinct k1_0.name),?) from project p2_0 join key k1_0 on p2_0.id=k1_0.project_id left join branch b1_0 on b1_0.id=k1_0.branch_id join translation t1_0 on k1_0.id=t1_0.key_id and t1_0.state=? and t1_0.language_id=l1_0.id where (k1_0.branch_id is null or b1_0.is_default) and k1_0.deleted_at is null),(select coalesce(sum(t3_0.word_count),?) from project p3_0 join key k2_0 on p3_0.id=k2_0.project_id left join branch b3_0 on b3_0.id=k2_0.branch_id join translation t2_0 on k2_0.id=t2_0.key_id and t2_0.state=? and t2_0.language_id=l1_0.id left join translation t3_0 on k2_0.id=t3_0.key_id and t3_0.language_id=p3_0.base_language_id where (k2_0.branch_id is null or b3_0.is_default) and k2_0.deleted_at is null),(select coalesce(count(distinct k3_0.name),?) from project p4_0 join key k3_0 on p4_0.id=k3_0.project_id left join branch b5_0 on b5_0.id=k3_0.branch_id join translation t4_0 on k3_0.id=t4_0.key_id and t4_0.state=? and t4_0.language_id=l1_0.id where (k3_0.branch_id is null or b5_0.is_default) and k3_0.deleted_at is null),(select coalesce(sum(t6_0.word_count),?) from project p5_0 join key k4_0 on p5_0.id=k4_0.project_id left join branch b7_0 on b7_0.id=k4_0.branch_id join translation t5_0 on k4_0.id=t5_0.key_id and t5_0.state=? and t5_0.language_id=l1_0.id left join translation t6_0 on k4_0.id=t6_0.key_id and t6_0.language_id=p5_0.base_language_id where (k4_0.branch_id is null or b7_0.is_default) and k4_0.deleted_at is null) from project p1_0 join language l1_0 on p1_0.id=l1_0.project_id where p1_0.id in (?) group by 2,1] [ERROR: canceling statement due to statement timeout] [n/a]
at app//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:115)
at app//org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:431)
at app//org.hibernate.query.Query.getResultList(Query.java:120)
at app//io.tolgee.service.queryBuilders.LanguageStatsProvider.getResultForSingleProject(LanguageStatsProvider.kt:36)
at app//io.tolgee.service.project.LanguageStatsService.getLanguageStats