Bump quarkus.version from 3.1.0.Final to 3.1.1.Final

[dependabot[bot]]

Bumps quarkus.version from 3.1.0.Final to 3.1.1.Final. Updates quarkus-bom from 3.1.0.Final to 3.1.1.Final

Release notes

Sourced from quarkus-bom's releases.

3.1.1.Final

Complete changelog

• #33846 - Update Jackson to 2.15.2
• #33834 - Kafka serde discovery: handle channel names containing dot
• #33821 - DEV UI: Prevent NPE in JsonRpc#route after Quarkus app reloaded
• #33820 - DEV UI on reload logs NPE xception in JsonRpcRouter#route on line 200
• #33815 - Redis Hostname provider - do not call getHosts() twice
• #33811 - Only expose the Dev UI Routes if Vert.x HTTP is present
• #33804 - Dev Mode fails with Quarkus 3.1 and Kafka client (no vert.x http extension on the classpath)
• #33802 - Fix Dev UI v1 link in the guides
• #33799 - Fix message typo in OIDCRecorder
• #33769 - Fix detection of OpenTelemetry
• #33763 - When using RestMulti, don't require @Produces
• #33761 - Properly implement ClientRequestContext#setEntity
• #33758 - Update security-keycloak-admin-client.adoc
• #33756 - Prevent NPE in Jacoco report preparation when a workspace module has no sources
• #33753 - Bump apicurio-registry.version from 2.4.2.Final to 2.4.3.Final
• #33752 - Bump kotlinx-serialization-json from 1.5.0 to 1.5.1
• #33746 - Quarkus 3.1 still throws an error if @Produces is not defined on a stream response
• #33741 - io.quarkus:quarkus-jacoco cannot import pom module dependecy
• #33738 - Quarkus 3.1 rest client uses wrong Messagewriter
• #33735 - Make Elasticsearch Java Client's withJson(...) methods work in native mode
• #33730 - Smallrye Reactive Messaging with Kafka Connector does not support channel names containing a dot
• #33720 - Normalize podman vs. podman.exe and Podman Desktop
• #33718 - Fix native query support in Hibernate Reactive
• #33713 - NamedNativeQuery not working in native image
• #33695 - Update rewrite-maven-plugin to 4.46.0
• #33689 - DevTool-cli Clarify --errors help message
• #33687 - Call after construct callbacks when creating outer instances/QuarkusTest
• #33680 - Fix dropped exception on JSON stream cancellation
• #33677 - Fix npe when vert.x delegate is called but not set yet
• #33671 - Mark test failure in time for callbacks to know about it
• #33670 - Guard against potential NPE in GrpcClientConfiguration
• #33667 - Do not include the Kafka Dev UI beans during the native build
• #33663 - Fix SSE response with legacy publisher in native mode
• #33660 - Dev UI small fixes
• #33659 - Add DevConsoleCORSFilter to Dev UI JsonRPC WebSocket
• #33657 - Security JPA Reactive - catch non-unique result exception properly
• #33652 - Endpoint with RestSseElementType doesn't produce events in native
• #33651 - Refer to 'microprofile_jwt' scope in OIDC docs
• #33649 - [Doc] Fix minor typo in devtool CLI
• #33647 - Incorrect test status in QuarkusTestAfterTestExecutionCallback and QuarkusTestAfterEachCallback for failing test
• #33645 - Ignore IndexDependencyBuildItem for missing dependencies
• #33643 - RolesAllowed and OIDC broken in 2.16.0-Final and 3.0.4-Final with KeyCloak
• #33639 - Upgrade to SmallRye Fault Tolerance 6.2.3
• #33631 - Hibernate Storing multiple items with @IdClass in one transaction fails
• #33627 - Do not bind the "grpc" container port when configured to use same server
• #33623 - Regression - Unable to build native binary when using quarkus-kafka-client extension

... (truncated)

Commits

• 481b0b7 [RELEASE] - Bump version to 3.1.1.Final
• d68dd00 Merge pull request #33853 from gsmet/3.1.1-backports-2
• 6b50326 Register PGobject subtypes for reflection
• 04b2b8e Update Jackson to 2.15.2 in independent-projects
• 15dcca8 set jackson-bom version to 2.15.2
• cbe6b53 Bump apicurio-registry.version from 2.4.2.Final to 2.4.3.Final
• b3866a1 Bump kotlinx-serialization-json from 1.5.0 to 1.5.1
• 7552b20 Redis Hostname provider - do not call getHosts() twice
• 226ff97 Fix Dev UI v1 link in the guides
• 1bf7e7f Only expose the Dev UI Routes if Vert.x HTTP is present
• Additional commits viewable in compare view

Updates quarkus-ide-config from 3.1.0.Final to 3.1.1.Final

Release notes

Sourced from quarkus-ide-config's releases.

3.1.1.Final

Complete changelog

• #33846 - Update Jackson to 2.15.2
• #33834 - Kafka serde discovery: handle channel names containing dot
• #33821 - DEV UI: Prevent NPE in JsonRpc#route after Quarkus app reloaded
• #33820 - DEV UI on reload logs NPE xception in JsonRpcRouter#route on line 200
• #33815 - Redis Hostname provider - do not call getHosts() twice
• #33811 - Only expose the Dev UI Routes if Vert.x HTTP is present
• #33804 - Dev Mode fails with Quarkus 3.1 and Kafka client (no vert.x http extension on the classpath)
• #33802 - Fix Dev UI v1 link in the guides
• #33799 - Fix message typo in OIDCRecorder
• #33769 - Fix detection of OpenTelemetry
• #33763 - When using RestMulti, don't require @Produces
• #33761 - Properly implement ClientRequestContext#setEntity
• #33758 - Update security-keycloak-admin-client.adoc
• #33756 - Prevent NPE in Jacoco report preparation when a workspace module has no sources
• #33753 - Bump apicurio-registry.version from 2.4.2.Final to 2.4.3.Final
• #33752 - Bump kotlinx-serialization-json from 1.5.0 to 1.5.1
• #33746 - Quarkus 3.1 still throws an error if @Produces is not defined on a stream response
• #33741 - io.quarkus:quarkus-jacoco cannot import pom module dependecy
• #33738 - Quarkus 3.1 rest client uses wrong Messagewriter
• #33735 - Make Elasticsearch Java Client's withJson(...) methods work in native mode
• #33730 - Smallrye Reactive Messaging with Kafka Connector does not support channel names containing a dot
• #33720 - Normalize podman vs. podman.exe and Podman Desktop
• #33718 - Fix native query support in Hibernate Reactive
• #33713 - NamedNativeQuery not working in native image
• #33695 - Update rewrite-maven-plugin to 4.46.0
• #33689 - DevTool-cli Clarify --errors help message
• #33687 - Call after construct callbacks when creating outer instances/QuarkusTest
• #33680 - Fix dropped exception on JSON stream cancellation
• #33677 - Fix npe when vert.x delegate is called but not set yet
• #33671 - Mark test failure in time for callbacks to know about it
• #33670 - Guard against potential NPE in GrpcClientConfiguration
• #33667 - Do not include the Kafka Dev UI beans during the native build
• #33663 - Fix SSE response with legacy publisher in native mode
• #33660 - Dev UI small fixes
• #33659 - Add DevConsoleCORSFilter to Dev UI JsonRPC WebSocket
• #33657 - Security JPA Reactive - catch non-unique result exception properly
• #33652 - Endpoint with RestSseElementType doesn't produce events in native
• #33651 - Refer to 'microprofile_jwt' scope in OIDC docs
• #33649 - [Doc] Fix minor typo in devtool CLI
• #33647 - Incorrect test status in QuarkusTestAfterTestExecutionCallback and QuarkusTestAfterEachCallback for failing test
• #33645 - Ignore IndexDependencyBuildItem for missing dependencies
• #33643 - RolesAllowed and OIDC broken in 2.16.0-Final and 3.0.4-Final with KeyCloak
• #33639 - Upgrade to SmallRye Fault Tolerance 6.2.3
• #33631 - Hibernate Storing multiple items with @IdClass in one transaction fails
• #33627 - Do not bind the "grpc" container port when configured to use same server
• #33623 - Regression - Unable to build native binary when using quarkus-kafka-client extension

... (truncated)

Commits

• 481b0b7 [RELEASE] - Bump version to 3.1.1.Final
• d68dd00 Merge pull request #33853 from gsmet/3.1.1-backports-2
• 6b50326 Register PGobject subtypes for reflection
• 04b2b8e Update Jackson to 2.15.2 in independent-projects
• 15dcca8 set jackson-bom version to 2.15.2
• cbe6b53 Bump apicurio-registry.version from 2.4.2.Final to 2.4.3.Final
• b3866a1 Bump kotlinx-serialization-json from 1.5.0 to 1.5.1
• 7552b20 Redis Hostname provider - do not call getHosts() twice
• 226ff97 Fix Dev UI v1 link in the guides
• 1bf7e7f Only expose the Dev UI Routes if Vert.x HTTP is present
• Additional commits viewable in compare view

Updates quarkus-maven-plugin from 3.1.0.Final to 3.1.1.Final

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[yrodiere]

@gastaldi Something that I noticed while trying to write a reproducer: your application uses the json type for the platform.metadata column, but recent versions of Hibernate ORM expect the type jsonb. And, critically, you won't have that error when using the jsonb column type.

As a workaround, and perhaps just a migration step, I'd recommend you move to jsonb.

I'll continue working on a reproducer and report to the ORM team.

[gastaldi]

@yrodiere unfortunately changing the column to jsonb is not a valid workaround. It gives:

Caused by: org.postgresql.util.PSQLException: ERROR: column "p4_0.platform_stream_id" must appear in the GROUP BY clause or be used in an aggregate function
  Position: 468
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
    at io.agroal.pool.wrapper.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:78)
    at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:239)

It produces the following SQL:

SELECT p1_0.id,
       p1_0.bom,
       p1_0.created_at,
       p1_0.member_boms,
       p1_0.metadata,
       p1_0.pinned,
       p1_0.platform_stream_id,
       p1_0.quarkus_core_version,
       p1_0.unlisted,
       p1_0.upstream_quarkus_core_version,
       p1_0.version,
       p1_0.version_sortable
FROM platform_release p1_0
JOIN platform_stream p2_0 ON p2_0.id=p1_0.platform_stream_id
JOIN platform p3_0 ON p3_0.id=p2_0.platform_id
WHERE p1_0.unlisted=FALSE
  AND p3_0.platform_type='C'
  AND (p1_0.platform_stream_id,
       p1_0.version_sortable) in
    (SELECT p4_0.platform_stream_id,
            max(p4_0.version_sortable)
     FROM platform_release p4_0
     JOIN platform_stream p5_0 ON p5_0.id=p4_0.platform_stream_id
     WHERE p5_0.unlisted=FALSE
       AND p4_0.unlisted=FALSE
     GROUP BY p5_0.id,
              p5_0.created_at,
              p5_0.metadata,
              p5_0.name,
              p5_0.pinned,
              p5_0.platform_id,
              p5_0.stream_key,
              p5_0.stream_key_sortable,
              p5_0.unlisted)
ORDER BY p1_0.version_sortable DESC,
         p3_0.is_default DESC

[yrodiere]

@gastaldi Is this with the same HQL, i.e. this?

select pr from PlatformRelease pr
where pr.unlisted = false
and pr.platformStream.platform.platformType = 'C'
and (pr.platformStream, pr.versionSortable) in
    (
     select pr2.platformStream, max(pr2.versionSortable) from PlatformRelease pr2
         where pr2.platformStream.unlisted = false
         and pr2.unlisted = false
         group by pr2.platformStream
    )
order by pr.versionSortable desc, pr.platformStream.platform.isDefault desc

If so that looks like a bug...

Regardless, you could also try to avoid using associations in the query where you only need the ID, i.e. something like this (might need adjustment, I didn't try it):

select pr from PlatformRelease pr
where pr.unlisted = false
and pr.platformStream.platform.platformType = 'C'
and (pr.platformStream.id, pr.versionSortable) in
    (
     select pr2.platformStream.id, max(pr2.versionSortable) from PlatformRelease pr2
         where pr2.platformStream.unlisted = false
         and pr2.unlisted = false
         group by pr2.platformStream.id
    )
order by pr.versionSortable desc, pr.platformStream.platform.isDefault desc

[gastaldi]

@yrodiere ah good idea, that seems to work, I've pushed a commit with your suggestion and the tests passed.