[ https://issues.apache.org/jira/browse/DRILL-8397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17686398#comment-17686398 ]
ASF GitHub Bot commented on DRILL-8397: --------------------------------------- jnturton commented on PR #2752: URL: https://github.com/apache/drill/pull/2752#issuecomment-1424093562 Regarding the sporadic failures of the unit test testBasicCTASWithScalarDataTypes that have been showing in recent CI runs, and now also here, it looks to me like [the Thread.sleep(15_000) that it uses](https://github.com/jnturton/drill/blob/83bf04cd815e6c6d22d9ef04550cd8113bd9f905/contrib/storage-splunk/src/test/java/org/apache/drill/exec/store/splunk/SplunkWriterTest.java#L113) to wait for an INSERT to go through is not always enough to ensure that Splunk will return the record needed for the subsequent schema validation to pass. Locally I've been able to reproduce both successes and failures of this test with a range of sleep durations from 6_000 to 60_000 so I'm not sure if there is a magic number here, or what it might be. Stepping back further, I don't know if Splunk ever takes a transactional approach to loading data - maybe it makes no guarantees beyond "Thanks, I'll index this later"? CC @cgivre. > Drill prints warnings to console when starting it > ------------------------------------------------- > > Key: DRILL-8397 > URL: https://issues.apache.org/jira/browse/DRILL-8397 > Project: Apache Drill > Issue Type: Bug > Reporter: Vova Vysotskyi > Assignee: Vova Vysotskyi > Priority: Minor > > When starting the drill in embedded mode, it prints the following warnings: > {noformat} > 11:19:55,482 |-INFO in ch.qos.logback.classic.LoggerContext[default] - This > is logback-classic version 1.4.5 > 11:19:55,499 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could > NOT find resource [logback-test.xml] > 11:19:55,503 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found > resource [logback.xml] at > [file:/tmp/drill/distribution/target/apache-drill-1.21.0-SNAPSHOT/apache-drill-1.21.0-SNAPSHOT/conf/logback.xml] > 11:19:55,607 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > <level> element is deprecated. Near [level] on line 73 > 11:19:55,607 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > Please use "level" attribute within <logger> or <root> elements instead. > 11:19:55,607 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > <level> element is deprecated. Near [level] on line 78 > 11:19:55,607 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > Please use "level" attribute within <logger> or <root> elements instead. > 11:19:55,608 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > <level> element is deprecated. Near [level] on line 91 > 11:19:55,608 |-WARN in ch.qos.logback.classic.joran.action.LevelAction - > Please use "level" attribute within <logger> or <root> elements instead. > 11:19:55,652 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - Processing > appender named [STDOUT] > 11:19:55,652 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - About to > instantiate appender of type [ch.qos.logback.core.ConsoleAppender] > 11:19:55,658 |-INFO in > ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default > type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] > property > 11:19:55,689 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - Processing > appender named [QUERY] > 11:19:55,689 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - About to > instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender] > 11:19:55,697 |-INFO in > ch.qos.logback.core.rolling.FixedWindowRollingPolicy@66ac5762 - No > compression will be used > 11:19:55,699 |-INFO in > ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default > type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] > property > 11:19:55,699 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[QUERY] > - Active log file name: > /tmp/drill/distribution/target/apache-drill-1.21.0-SNAPSHOT/apache-drill-1.21.0-SNAPSHOT/log/sqlline_queries.json > 11:19:55,699 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[QUERY] > - File property is set to > [/tmp/drill/distribution/target/apache-drill-1.21.0-SNAPSHOT/apache-drill-1.21.0-SNAPSHOT/log/sqlline_queries.json] > 11:19:55,700 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - Processing > appender named [FILE] > 11:19:55,700 |-INFO in > ch.qos.logback.core.model.processor.AppenderModelHandler - About to > instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender] > 11:19:55,700 |-INFO in > ch.qos.logback.core.rolling.FixedWindowRollingPolicy@797cf65c - No > compression will be used > 11:19:55,701 |-INFO in > ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default > type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] > property > 11:19:55,701 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] > - Active log file name: > /tmp/drill/distribution/target/apache-drill-1.21.0-SNAPSHOT/apache-drill-1.21.0-SNAPSHOT/log/sqlline.log > 11:19:55,701 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] > - File property is set to > [/tmp/drill/distribution/target/apache-drill-1.21.0-SNAPSHOT/apache-drill-1.21.0-SNAPSHOT/log/sqlline.log] > 11:19:55,702 |-INFO in > ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting > additivity of logger [org.apache.drill] to false > 11:19:55,702 |-INFO in > ch.qos.logback.classic.model.processor.LevelModelHandler - org.apache.drill > level set to INFO > 11:19:55,702 |-INFO in > ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching > appender named [FILE] to Logger[org.apache.drill] > 11:19:55,703 |-INFO in > ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting > additivity of logger [query.logger] to false > 11:19:55,703 |-INFO in > ch.qos.logback.classic.model.processor.LevelModelHandler - query.logger level > set to INFO > 11:19:55,703 |-INFO in > ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching > appender named [QUERY] to Logger[query.logger] > 11:19:55,703 |-INFO in > ch.qos.logback.classic.model.processor.LevelModelHandler - ROOT level set to > ERROR > 11:19:55,703 |-INFO in > ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching > appender named [STDOUT] to Logger[ROOT] > 11:19:55,703 |-INFO in > ch.qos.logback.core.model.processor.DefaultProcessor@31bcf236 - End of > configuration. > 11:19:55,703 |-INFO in > ch.qos.logback.classic.joran.JoranConfigurator@4b3ed2f0 - Registering current > configuration as safe fallback point {noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)