[HIVE-22714] TestScheduledQueryService is flaky

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Tests
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 09/Jan/20 23:48
• Updated: 17/Nov/22 08:51
• Resolved: 11/Jan/20 00:49

Description

[ERROR] Failures: 
[ERROR]   TestScheduledQueryService.testScheduledQueryExecution:152 
Expected: <5>
     but: was <0>
[INFO] 
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0

Looks like sometimes we are not waiting long enough for the INSERT query to complete and the SELECT runs before it finishes:

$ egrep "insert|select" target/surefire-reports/org.apache.hadoop.hive.ql.schq.TestScheduledQueryService-output.txt | grep HOOK
PREHOOK: query: insert into tu values(1),(2),(3),(4),(5)
2020-01-09T14:49:09,497  INFO [SchQ 0] SessionState: PREHOOK: query: insert into tu values(1),(2),(3),(4),(5)
PREHOOK: query: select 1 from tu
2020-01-09T14:49:11,452  INFO [main] SessionState: PREHOOK: query: select 1 from tu
POSTHOOK: query: select 1 from tu
2020-01-09T14:49:11,452  INFO [main] SessionState: POSTHOOK: query: select 1 from tu
POSTHOOK: query: insert into tu values(1),(2),(3),(4),(5)
2020-01-09T14:49:12,062  INFO [SchQ 0] SessionState: POSTHOOK: query: insert into tu values(1),(2),(3),(4),(5)