search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.43k stars 3k forks source link

Flaky test TestOracleDistributedQueries.testLargeIn #3798

Closed findepi closed 4 years ago

findepi commented 4 years ago 
2020-05-20T10:29:20.6951914Z [ERROR] Tests run: 178, Failures: 1, Errors: 0, Skipped: 11, Time elapsed: 449.324 s <<< FAILURE! - in TestSuite
2020-05-20T10:29:20.6972583Z [ERROR] testLargeIn(io.prestosql.plugin.oracle.TestOracleDistributedQueries)  Time elapsed: 13.977 s  <<< FAILURE!
2020-05-20T10:29:20.7442043Z java.lang.AssertionError: Execution of 'actual' query failed: SELECT orderkey FROM orders WHERE orderkey NOT IN (mod(1000, orderkey), 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999)
2020-05-20T10:29:20.7446473Z    at org.testng.Assert.fail(Assert.java:83)
2020-05-20T10:29:20.7453032Z    at io.prestosql.testing.QueryAssertions.assertQuery(QueryAssertions.java:150)
2020-05-20T10:29:20.7458763Z    at io.prestosql.testing.QueryAssertions.assertQuery(QueryAssertions.java:106)
2020-05-20T10:29:20.7466746Z    at io.prestosql.testing.AbstractTestQueryFramework.assertQuery(AbstractTestQueryFramework.java:125)
2020-05-20T10:29:20.7544042Z    at io.prestosql.testing.AbstractTestQueryFramework.assertQuery(AbstractTestQueryFramework.java:120)
2020-05-20T10:29:20.7545553Z    at io.prestosql.plugin.oracle.TestOracleDistributedQueries.testLargeIn(TestOracleDistributedQueries.java:138)
2020-05-20T10:29:20.7546887Z    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2020-05-20T10:29:20.7548571Z    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2020-05-20T10:29:20.7550414Z    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2020-05-20T10:29:20.7551792Z    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
2020-05-20T10:29:20.7553484Z    at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:104)
2020-05-20T10:29:20.7554378Z    at org.testng.internal.Invoker.invokeMethod(Invoker.java:645)
2020-05-20T10:29:20.7555430Z    at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:851)
2020-05-20T10:29:20.7556454Z    at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1177)
2020-05-20T10:29:20.7557882Z    at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129)
2020-05-20T10:29:20.7559457Z    at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112)
2020-05-20T10:29:20.7561085Z    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2020-05-20T10:29:20.7562908Z    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2020-05-20T10:29:20.7563949Z    at java.base/java.lang.Thread.run(Thread.java:834)
2020-05-20T10:29:20.7566041Z Caused by: java.lang.RuntimeException: Listener refused the connection with the following error:
2020-05-20T10:29:20.7568305Z ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
2020-05-20T10:29:20.7569620Z  
2020-05-20T10:29:20.7570189Z    at io.prestosql.testing.AbstractTestingPrestoClient.execute(AbstractTestingPrestoClient.java:114)
2020-05-20T10:29:20.7570669Z    at io.prestosql.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:443)
2020-05-20T10:29:20.7572319Z    at io.prestosql.testing.QueryAssertions.assertQuery(QueryAssertions.java:147)
2020-05-20T10:29:20.7572666Z    ... 17 more
2020-05-20T10:29:20.7574093Z Caused by: io.prestosql.spi.PrestoException: Listener refused the connection with the following error:
2020-05-20T10:29:20.7575798Z ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
2020-05-20T10:29:20.7576232Z  
2020-05-20T10:29:20.7576629Z    at io.prestosql.plugin.jdbc.JdbcRecordCursor.handleSqlException(JdbcRecordCursor.java:249)
2020-05-20T10:29:20.7578044Z    at io.prestosql.plugin.jdbc.JdbcRecordCursor.<init>(JdbcRecordCursor.java:105)
2020-05-20T10:29:20.7579160Z    at io.prestosql.plugin.jdbc.JdbcRecordSet.cursor(JdbcRecordSet.java:60)
2020-05-20T10:29:20.7580866Z    at io.prestosql.spi.connector.RecordPageSource.<init>(RecordPageSource.java:37)
2020-05-20T10:29:20.7581560Z    at io.prestosql.split.RecordPageSourceProvider.createPageSource(RecordPageSourceProvider.java:50)
2020-05-20T10:29:20.7583287Z    at io.prestosql.split.PageSourceManager.createPageSource(PageSourceManager.java:64)
2020-05-20T10:29:20.7585604Z    at io.prestosql.operator.ScanFilterAndProjectOperator$SplitToPages.process(ScanFilterAndProjectOperator.java:254)
2020-05-20T10:29:20.7587966Z    at io.prestosql.operator.ScanFilterAndProjectOperator$SplitToPages.process(ScanFilterAndProjectOperator.java:182)
2020-05-20T10:29:20.7589277Z    at io.prestosql.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:319)
2020-05-20T10:29:20.7590999Z    at io.prestosql.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:372)
2020-05-20T10:29:20.7593173Z    at io.prestosql.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:306)
2020-05-20T10:29:20.7595767Z    at io.prestosql.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:372)
2020-05-20T10:29:20.7597138Z    at io.prestosql.operator.WorkProcessorUtils$3.process(WorkProcessorUtils.java:306)
2020-05-20T10:29:20.7599594Z    at io.prestosql.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:372)
2020-05-20T10:29:20.7600433Z    at io.prestosql.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:221)
2020-05-20T10:29:20.7602407Z    at io.prestosql.operator.WorkProcessorUtils.lambda$processStateMonitor$2(WorkProcessorUtils.java:200)
2020-05-20T10:29:20.7604201Z    at io.prestosql.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:372)
2020-05-20T10:29:20.7605274Z    at io.prestosql.operator.WorkProcessorUtils.getNextState(WorkProcessorUtils.java:221)
2020-05-20T10:29:20.7607012Z    at io.prestosql.operator.WorkProcessorUtils.lambda$finishWhen$3(WorkProcessorUtils.java:215)
2020-05-20T10:29:20.7607620Z    at io.prestosql.operator.WorkProcessorUtils$ProcessWorkProcessor.process(WorkProcessorUtils.java:372)
2020-05-20T10:29:20.7609294Z    at io.prestosql.operator.WorkProcessorSourceOperatorAdapter.getOutput(WorkProcessorSourceOperatorAdapter.java:149)
2020-05-20T10:29:20.7610307Z    at io.prestosql.operator.Driver.processInternal(Driver.java:379)
2020-05-20T10:29:20.7611309Z    at io.prestosql.operator.Driver.lambda$processFor$8(Driver.java:283)
2020-05-20T10:29:20.7613347Z    at io.prestosql.operator.Driver.tryWithLock(Driver.java:675)
2020-05-20T10:29:20.7615071Z    at io.prestosql.operator.Driver.processFor(Driver.java:276)
2020-05-20T10:29:20.7615641Z    at io.prestosql.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1075)
2020-05-20T10:29:20.7617490Z    at io.prestosql.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:163)
2020-05-20T10:29:20.7618317Z    at io.prestosql.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:484)
2020-05-20T10:29:20.7619577Z    at io.prestosql.$gen.Presto_testversion____20200520_102350_2.run(Unknown Source)
2020-05-20T10:29:20.7620741Z    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2020-05-20T10:29:20.7621165Z    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2020-05-20T10:29:20.7621569Z    at java.base/java.lang.Thread.run(Thread.java:834)
2020-05-20T10:29:20.7623537Z Caused by: java.sql.SQLException: Listener refused the connection with the following error:
2020-05-20T10:29:20.7698126Z ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
2020-05-20T10:29:20.7698869Z  
2020-05-20T10:29:20.7699221Z    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
2020-05-20T10:29:20.7699609Z    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
2020-05-20T10:29:20.7700530Z    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
2020-05-20T10:29:20.7701647Z    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
2020-05-20T10:29:20.7702693Z    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
2020-05-20T10:29:20.7704635Z    at io.prestosql.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:73)
2020-05-20T10:29:20.7706721Z    at io.prestosql.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:42)
2020-05-20T10:29:20.7707451Z    at io.prestosql.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:35)
2020-05-20T10:29:20.7709891Z    at io.prestosql.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:42)
2020-05-20T10:29:20.7711503Z    at io.prestosql.plugin.jdbc.BaseJdbcClient.getConnection(BaseJdbcClient.java:351)
2020-05-20T10:29:20.7713198Z    at io.prestosql.plugin.jdbc.ForwardingJdbcClient.getConnection(ForwardingJdbcClient.java:107)
2020-05-20T10:29:20.7715196Z    at io.prestosql.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getConnection$8(StatisticsAwareJdbcClient.java:122)
2020-05-20T10:29:20.7716264Z    at io.prestosql.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:35)
2020-05-20T10:29:20.7718657Z    at io.prestosql.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getConnection(StatisticsAwareJdbcClient.java:122)
2020-05-20T10:29:20.7720298Z    at io.prestosql.plugin.jdbc.CachingJdbcClient.getConnection(CachingJdbcClient.java:139)
2020-05-20T10:29:20.7721558Z    at io.prestosql.plugin.jdbc.JdbcRecordCursor.<init>(JdbcRecordCursor.java:71)
2020-05-20T10:29:20.7721907Z    ... 30 more
2020-05-20T10:29:20.7723182Z Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
2020-05-20T10:29:20.7725472Z ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
2020-05-20T10:29:20.7726009Z  
2020-05-20T10:29:20.7726394Z    at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:284)
2020-05-20T10:29:20.7727443Z    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
2020-05-20T10:29:20.7728156Z    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)
2020-05-20T10:29:20.7729362Z    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)
2020-05-20T10:29:20.7729725Z    ... 45 more

https://github.com/prestosql/presto/runs/692325004?check_suite_focus=true

findepi commented 4 years ago

cc @eskabetxe

eskabetxe commented 4 years ago

@findepi this will be fixed in https://github.com/prestosql/presto/pull/3795