Flaky TestHiveDynamicPartitionPruningTest.testJoinDynamicFilteringMultiJoinOnBucketedTables

[ebyhr]

Error:  io.trino.plugin.hive.TestHiveDynamicPartitionPruningTest.testJoinDynamicFilteringMultiJoinOnBucketedTables[BROADCAST](2)  Time elapsed: 1.408 s  <<< FAILURE!
java.lang.AssertionError: 
[filtered input positions] 
Expecting:
 <4L>
to be less than:
 <4L> 
	at io.trino.testing.BaseDynamicPartitionPruningTest.assertDynamicFilters(BaseDynamicPartitionPruningTest.java:491)
	at io.trino.testing.BaseDynamicPartitionPruningTest.testJoinDynamicFilteringMultiJoin(BaseDynamicPartitionPruningTest.java:465)
	at io.trino.testing.BaseDynamicPartitionPruningTest.testJoinDynamicFilteringMultiJoinOnBucketedTables(BaseDynamicPartitionPruningTest.java:457)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:104)
	at org.testng.internal.InvokeMethodRunnable.runOne(InvokeMethodRunnable.java:54)
	at org.testng.internal.InvokeMethodRunnable.run(InvokeMethodRunnable.java:44)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)

https://github.com/trinodb/trino/runs/7479762692

[sopel39]

This wasn't flaky before. Could it be actual product test due to recent DF changes, cc @raunaqmorarka @arhimondr ?

[sopel39]

@nineinchnick Could you confirm that it's a new flakyness rather than being there always from time to time?

[nineinchnick]

@sopel39 last occurrence was on 2022-06-14, I checked in last 90 days so it's pretty rare.

[nineinchnick]

Is this happening in the CI? Shouldn't we see more recent occurrences?

[ebyhr]

@nineinchnick It failed 2 days ago on master in https://github.com/trinodb/trino/runs/7479762692

[sopel39]

https://github.com/trinodb/trino/runs/7520376089?check_suite_focus=true

[Praveen2112]

https://github.com/trinodb/trino/runs/7560632851?check_suite_focus=true

[findepi]

https://github.com/trinodb/trino/runs/7776189226?check_suite_focus=true

[ebyhr]

https://github.com/trinodb/trino/runs/7802208619