Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Spark] Native test TestPrestoSparkNativeWindowQueries.testDenseRank fails in CI #24262

Open
czentgr opened this issue Dec 14, 2024 · 0 comments
Labels
bug flaky-test spark Apache Spark related

Comments

@czentgr
Copy link
Contributor

czentgr commented Dec 14, 2024

The stack is similar to other failures in flaky spark tests having the NULL pointer exception.

TestPrestoSparkNativeWindowQueries.testDenseRank fails

2024-12-13T22:10:15.2502028Z [ERROR] com.facebook.presto.spark.TestPrestoSparkNativeWindowQueries.testDenseRank  Time elapsed: 4.772 s  <<< FAILURE!
2024-12-13T22:10:15.2505167Z java.lang.AssertionError: Execution of 'actual' query failed: SELECT dense_rank() OVER (PARTITION BY orderkey ORDER BY totalprice RANGE UNBOUNDED PRECEDING), dense_rank() OVER (PARTITION BY orderkey ORDER BY totalprice RANGE CURRENT ROW), dense_rank() OVER (PARTITION BY orderkey ORDER BY totalprice RANGE BETWEEN UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING), dense_rank() OVER (PARTITION BY orderkey ORDER BY totalprice ROWS UNBOUNDED PRECEDING), dense_rank() OVER (PARTITION BY orderkey ORDER BY totalprice ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) FROM orders
2024-12-13T22:10:15.2507473Z 	at org.testng.Assert.fail(Assert.java:98)
2024-12-13T22:10:15.2508023Z 	at com.facebook.presto.tests.QueryAssertions.assertQuery(QueryAssertions.java:178)
2024-12-13T22:10:15.2508759Z 	at com.facebook.presto.tests.QueryAssertions.assertQuery(QueryAssertions.java:106)
2024-12-13T22:10:15.2509452Z 	at com.facebook.presto.tests.AbstractTestQueryFramework.assertQuery(AbstractTestQueryFramework.java:169)
2024-12-13T22:10:15.2510250Z 	at com.facebook.presto.tests.AbstractTestQueryFramework.assertQuery(AbstractTestQueryFramework.java:164)
2024-12-13T22:10:15.2511176Z 	at com.facebook.presto.nativeworker.AbstractTestNativeWindowQueries.testWindowFunction(AbstractTestNativeWindowQueries.java:135)
2024-12-13T22:10:15.2512203Z 	at com.facebook.presto.nativeworker.AbstractTestNativeWindowQueries.testDenseRank(AbstractTestNativeWindowQueries.java:148)
2024-12-13T22:10:15.2512988Z 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2024-12-13T22:10:15.2513763Z 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2024-12-13T22:10:15.2514576Z 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2024-12-13T22:10:15.2515185Z 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
2024-12-13T22:10:15.2515773Z 	at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:135)
2024-12-13T22:10:15.2516432Z 	at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:673)
2024-12-13T22:10:15.2517007Z 	at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:220)
2024-12-13T22:10:15.2517596Z 	at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
2024-12-13T22:10:15.2518211Z 	at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:945)
2024-12-13T22:10:15.2518848Z 	at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:193)
2024-12-13T22:10:15.2519472Z 	at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
2024-12-13T22:10:15.2520054Z 	at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
2024-12-13T22:10:15.2520727Z 	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2024-12-13T22:10:15.2521403Z 	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2024-12-13T22:10:15.2521866Z 	at java.base/java.lang.Thread.run(Thread.java:829)
2024-12-13T22:10:15.2522170Z Caused by: java.lang.NullPointerException
2024-12-13T22:10:15.2522716Z 	at com.facebook.presto.spark.util.PrestoSparkFailureUtils.toPrestoSparkFailure(PrestoSparkFailureUtils.java:59)
2024-12-13T22:10:15.2523580Z 	at com.facebook.presto.spark.execution.AbstractPrestoSparkQueryExecution.execute(AbstractPrestoSparkQueryExecution.java:395)
2024-12-13T22:10:15.2524425Z 	at com.facebook.presto.spark.PrestoSparkQueryRunner.executeWithStrategies(PrestoSparkQueryRunner.java:548)
2024-12-13T22:10:15.2525121Z 	at com.facebook.presto.spark.PrestoSparkQueryRunner.execute(PrestoSparkQueryRunner.java:522)
2024-12-13T22:10:15.2525722Z 	at com.facebook.presto.tests.QueryAssertions.assertQuery(QueryAssertions.java:175)
2024-12-13T22:10:15.2526116Z 	... 20 more
2024-12-13T22:10:15.2526217Z 

See https://github.com/prestodb/presto/actions/runs/12323348049/job/34399055454?pr=24236

Your Environment

  • Presto version used:
  • Storage (HDFS/S3/GCS..):
  • Data source and connector used:
  • Deployment (Cloud or On-prem):
  • Pastebin link to the complete debug logs:

Expected Behavior

Current Behavior

Possible Solution

Steps to Reproduce

Screenshots (if appropriate)

Context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug flaky-test spark Apache Spark related
Projects
Status: 🆕 Unprioritized
Status: 🆕 Unprioritized
Development

No branches or pull requests

2 participants