jstastny-cz commented on code in PR #2334: URL: https://github.com/apache/incubator-kie-kogito-apps/pull/2334#discussion_r3246458907
########## jobs/kogito-addons-springboot-embedded-jobs/src/test/resources/application.properties: ########## @@ -13,3 +13,4 @@ kie.flyway.enabled=true # Enable exception details capture for tests kogito.jobs-service.exception-details-enabled=true +logging.level.org.kie.kogito.app.jobs.jpa.JPAJobStore=TRACE Review Comment: I actually thought we would have that - for the particular test module, scoped to this single class - for the logs to be useful during possible failure investigation :/ These are the lines added for whole module (so it will be twice this for quarkus and spring boot): ``` 2026-05-15 08:55:10,368 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad 2026-05-15 08:55:10,368 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: false 2026-05-15 08:55:11,046 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 0 jobs 2026-05-15 08:55:11,244 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad 2026-05-15 08:55:11,244 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: false 2026-05-15 08:55:11,256 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 3 jobs 2026-05-15 08:55:11,272 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-3, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:11,273 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - Filtering enabled: false 2026-05-15 08:55:11,330 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-3, updated: 1 2026-05-15 08:55:11,344 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-2, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:11,344 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - Filtering enabled: false 2026-05-15 08:55:11,349 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-2, updated: 1 2026-05-15 08:55:11,356 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-1, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:11,356 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - Filtering enabled: false 2026-05-15 08:55:11,360 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) shouldRun() - jobId: direct-test-1, updated: 1 2026-05-15 08:55:13,248 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: a, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:13,249 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: false 2026-05-15 08:55:13,252 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: a, updated: 1 2026-05-15 08:55:13,279 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad 2026-05-15 08:55:13,279 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: false 2026-05-15 08:55:13,286 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 3 jobs 2026-05-15 08:55:13,290 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-1, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:13,290 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: false 2026-05-15 08:55:13,294 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-1, updated: 1 2026-05-15 08:55:13,301 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-3, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:13,301 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: false 2026-05-15 08:55:13,305 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-3, updated: 1 2026-05-15 08:55:13,316 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-2, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:13,316 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: false 2026-05-15 08:55:13,320 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: direct-test-2, updated: 1 2026-05-15 08:55:15,283 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-2) shouldRun() - jobId: b, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:15,284 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-2) shouldRun() - Filtering enabled: false 2026-05-15 08:55:15,288 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-2) shouldRun() - jobId: b, updated: 1 2026-05-15 08:55:15,395 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-3) shouldRun() - jobId: b, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:15,395 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-3) shouldRun() - Filtering enabled: false 2026-05-15 08:55:15,399 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-3) shouldRun() - jobId: b, updated: 1 2026-05-15 08:55:15,504 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-4) shouldRun() - jobId: b, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:15,505 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-4) shouldRun() - Filtering enabled: false 2026-05-15 08:55:15,508 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-4) shouldRun() - jobId: b, updated: 1 2026-05-15 08:55:15,612 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-5) shouldRun() - jobId: b, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId 2026-05-15 08:55:15,612 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-5) shouldRun() - Filtering enabled: false 2026-05-15 08:55:15,615 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-5) shouldRun() - jobId: b, updated: 1 2026-05-15 08:55:17,493 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:17,495 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:18,874 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:18,874 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:19,323 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 3 jobs 2026-05-15 08:55:19,326 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 3 jobs 2026-05-15 08:55:20,561 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-3, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId AND EXISTS (SELECT 1 FROM (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:20,562 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: true 2026-05-15 08:55:20,585 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-3, updated: 1 2026-05-15 08:55:20,633 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-2, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId AND EXISTS (SELECT 1 FROM (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:20,633 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: true 2026-05-15 08:55:20,638 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-2, updated: 1 2026-05-15 08:55:20,651 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-1, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId AND EXISTS (SELECT 1 FROM (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:20,651 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - Filtering enabled: true 2026-05-15 08:55:20,654 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-1) shouldRun() - jobId: local-job-1, updated: 1 2026-05-15 08:55:22,062 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:22,063 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:22,618 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - jobId: local-shouldrun-1, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId AND EXISTS (SELECT 1 FROM (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:22,618 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - Filtering enabled: true 2026-05-15 08:55:22,645 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - jobId: local-shouldrun-1, updated: 1 2026-05-15 08:55:22,674 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Returned 0 jobs 2026-05-15 08:55:22,732 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:22,732 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:22,742 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Returned 1 jobs 2026-05-15 08:55:22,797 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:22,797 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:22,806 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Returned 1 jobs 2026-05-15 08:55:22,910 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:22,910 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:22,917 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Returned 2 jobs 2026-05-15 08:55:23,005 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Query: WITH allowed_processes AS (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad AND EXISTS (SELECT 1 FROM allowed_processes ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:23,005 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Filtering enabled: true 2026-05-15 08:55:23,014 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) loadActiveJobs() - Returned 3 jobs 2026-05-15 08:55:23,044 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - jobId: remote-shouldrun-1, Query: UPDATE JobDetailsEntity o SET status = :status WHERE o.status IN (:activeStatus) AND o.id = :jobId AND EXISTS (SELECT 1 FROM (SELECT CAST(:processId0 AS STRING) AS processId UNION ALL SELECT CAST(:processId1 AS STRING) AS processId) ap WHERE ap.processId = o.rootProcessId OR (o.rootProcessId IS NULL AND ap.processId = o.processId)) 2026-05-15 08:55:23,045 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - Filtering enabled: true 2026-05-15 08:55:23,048 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (main) shouldRun() - jobId: remote-shouldrun-1, updated: 0 2026-05-15 08:55:24,427 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad 2026-05-15 08:55:24,427 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: false 2026-05-15 08:55:26,637 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Query: SELECT o FROM JobDetailsEntity o WHERE o.status IN (:activeStatus) AND o.fireTime <= :maxWindowsLoad 2026-05-15 08:55:26,637 TRACE [org.kie.kog.app.job.jpa.JPAJobStore] (Jobs-0) loadActiveJobs() - Filtering enabled: false ``` ~150 lines altogether. Or do you think it's better to log as DEBUG instead to prevent future logs bloating? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
