June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16788) CaseSearchedExpression whenFragments contains null value

by Lars Benedetto (JIRA)

Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODRjNjY1Mzgz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiODRjNj... ) HHH-16788 ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiODRjNj... ) CaseSearchedExpression whenFragments contains null value ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiODRjNj... ) Change By: Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) {noformat}Java.lang.NullPointerException: Cannot invoke "org.hibernate.sql.ast.tree.expression.CaseSearchedExpression$WhenFragment.getPredicate()" because "whenFragment" is null at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitAnsiCaseSearchedExpression(AbstractSqlAstTranslator.java:6431){noformat} We recently updated to 6.2.4 from 5.x and started occasionally seeing large spikes of errors with this stacktrace. One pod, out of dozens, will suddenly start getting this error for about 10% of findById queries on a specific Repository and continue until it is manually killed. We’ve been unable to figure out how to reproduce the issue, but it seems to correlate with high system load. {noformat} @Query("SELECT p FROM TblEntity e WHERE e.id = :id") Optional<TblEntity> findById(@Param("id") long id);{noformat} I had a look at which whenFragments exist when the query succeeds, and narrowed the issue down to a join column: {noformat}@OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL) @JoinColumn(name = "payment_id") private List<TblPaymentChange> paymentChanges;{noformat} Where TblPaymentChange has {noformat}@OneToOne(optional = true, fetch = FetchType.EAGER, cascade = CascadeType.ALL) @JoinColumns({ @JoinColumn(name = "payment_id", referencedColumnName = "payment_id", nullable = true), @JoinColumn(name = "sort_index", referencedColumnName = "sort_index", nullable = true) }) private TblPaymentChangeDetail changeDetails;{noformat} This the line in the code where the NPE occurs {noformat} for ( CaseSearchedExpression.WhenFragment whenFragment : caseSearchedExpression.getWhenFragments() ) { ... whenFragment.getPredicate().accept( this ); // <-- NPE, whenFragment is null somehow ... }{noformat} I’ve done my best to look through the hibernate code and I can’t figure out a single way that a null value could make its way into that list of when fragments. As far as I can tell, the when fragments are always instantiated and then immediately passed into the add() function, never stored in an intermediate variable that could become null. The only thing I can think of is that the when fragments are getting garbage collected. ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16787) Multi-valued parameter with single element parameter list fails with no such element exception

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmVmN2IzYmNi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16787?atlOrigin=eyJpIjoiYmVmN2... ) HHH-16787 ( https://hibernate.atlassian.net/browse/HHH-16787?atlOrigin=eyJpIjoiYmVmN2... ) Multi-valued parameter with single element parameter list fails with no such element exception ( https://hibernate.atlassian.net/browse/HHH-16787?atlOrigin=eyJpIjoiYmVmN2... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The problem is that function arguments are resolved twice if a subquery select a {{SqmPath}} that is returned via a custom function. {{from Post p where my_function((select p2.id from Post p2 where p2.title in (:name)))=1}} ( https://hibernate.atlassian.net/browse/HHH-16787#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16787#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16788) CaseSearchedExpression whenFragments contains null value

by Lars Benedetto (JIRA)

Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTkzYmRhYWI2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiMTkzYm... ) HHH-16788 ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiMTkzYm... ) CaseSearchedExpression whenFragments contains null value ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiMTkzYm... ) Change By: Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) {noformat}Java.lang.NullPointerException: Cannot invoke "org.hibernate.sql.ast.tree.expression.CaseSearchedExpression$WhenFragment.getPredicate()" because "whenFragment" is null at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitAnsiCaseSearchedExpression(AbstractSqlAstTranslator.java:6431){noformat} We recently updated to 6.2.4 from 5.x and started occasionally seeing large spikes of errors with this stacktrace. One pod, out of dozens, will suddenly start getting this error for about 10% of findById queries on a specific Repository and continue until it is manually killed. We’ve been unable to figure out how to reproduce the issue, but it seems to correlate with high system load. {noformat} @Query("SELECT p FROM TblEntity e WHERE e.id = :id") Optional<TblEntity> findById(@Param("id") long id);{noformat} This the line in the code where the NPE occurs {noformat} for ( CaseSearchedExpression.WhenFragment whenFragment : caseSearchedExpression.getWhenFragments() ) { ... whenFragment.getPredicate().accept( this ); // <-- NPE, whenFragment is null somehow ... }{noformat} ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16788) CaseSearchedExpression whenFragments contains null value

by Lars Benedetto (JIRA)

Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjEzZjVhZDlj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNjEzZj... ) HHH-16788 ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNjEzZj... ) CaseSearchedExpression whenFragments contains null value ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNjEzZj... ) Change By: Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) {noformat}Java.lang.NullPointerException: Cannot invoke "org.hibernate.sql.ast.tree.expression.CaseSearchedExpression$WhenFragment.getPredicate()" because "whenFragment" is null at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitAnsiCaseSearchedExpression(AbstractSqlAstTranslator.java:6431){noformat} We recently updated to 6.2.4 from 5.x and started occasionally seeing large spikes of errors with this stacktrace. One pod, out of dozens, will suddenly start getting this error for about 5 10 % of findById queries (seemingly random ones) on a specific Repository and continue until it is manually killed. We’ve been unable to figure out how to reproduce the issue, but it seems to correlate with high system load. This the line in the code where the NPE occurs {noformat} for ( CaseSearchedExpression.WhenFragment whenFragment : caseSearchedExpression.getWhenFragments() ) { ... whenFragment.getPredicate().accept( this ); // <-- NPE, whenFragment is null somehow ... }{noformat} ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16789) Improve error message for use of limit without order by in subquery

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDJiMTgyMjdl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16789?atlOrigin=eyJpIjoiMDJiMT... ) HHH-16789 ( https://hibernate.atlassian.net/browse/HHH-16789?atlOrigin=eyJpIjoiMDJiMT... ) Improve error message for use of limit without order by in subquery ( https://hibernate.atlassian.net/browse/HHH-16789?atlOrigin=eyJpIjoiMDJiMT... ) Issue Type: Improvement Affects Versions: 6.2.4 Assignee: Unassigned Components: hibernate-core Created: 13/Jun/2023 07:53 AM Fix Versions: 6.wishlist Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) A query like the following fails with an error that is not helpful: select 1 from MyEntity where 1 = (select 1 from MyEntity e limit 1) The error is a missing order by clause, but the parsing fails with “no viable alternative”. We should always parse this and rather throw a meaningful error during visitation. ( https://hibernate.atlassian.net/browse/HHH-16789#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16789#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16788) CaseSearchedExpression whenFragments contains null value

by Lars Benedetto (JIRA)

Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDYwNjFiOTA1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNDYwNj... ) HHH-16788 ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNDYwNj... ) CaseSearchedExpression whenFragments contains null value ( https://hibernate.atlassian.net/browse/HHH-16788?atlOrigin=eyJpIjoiNDYwNj... ) Issue Type: Bug Affects Versions: 6.2.4 Assignee: Unassigned Components: hibernate-core Created: 13/Jun/2023 07:15 AM Priority: Major Reporter: Lars Benedetto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bb1d56... ) Java.lang.NullPointerException: Cannot invoke "org.hibernate.sql.ast.tree.expression.CaseSearchedExpression$WhenFragment.getPredicate()" because "whenFragment" is null at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitAnsiCaseSearchedExpression(AbstractSqlAstTranslator.java:6431) We recently updated to 6.2.4 from 5.x and started occasionally seeing large spikes of errors with this stacktrace. One pod, out of dozens, will suddenly start getting this error for about 5% of queries (seemingly random ones) and continue until it is killed. We’ve been unable to figure out how to reproduce the issue, but it seems to correlate with high system load. This the line in the code where the NPE occurs for ( CaseSearchedExpression.WhenFragment whenFragment : caseSearchedExpression.getWhenFragments() ) { ... whenFragment.getPredicate().accept( this ); // <-- NPE, whenFragment is null somehow ... } ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16788#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:956085d )

1 year, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4873) Test Hibernate Search against JDK 22 EA

by Yoann Rodière (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HV-1954) Test Hibernate Validator against JDK 22

by Yoann Rodière (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16787) Multi-valued parameter with single element parameter list fails with no such element exception

by Christian Beikov (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16537) Wrong SQL generated when root join is not used in sub-query

by Marco Belladelli (JIRA)

1 year, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues June 2023