Drill ships with jar 'log4j-over-slf4j.jar'. Even Drillbit fails to start with same stacktrace when slf4j-log4j12.jar is added to Drill classpath. You may need to look into how log4j-over-slf4j.jar is getting added to your classpath.
As per SLF4J documentation , both these jars cannot be present simultaneously. https://www.slf4j.org/legacy.html#log4jRecursion The presence of slf4j-log4j12.jar, that is the log4j binding for SLF4J, will force all SLF4J calls to be delegated to log4j. The presence of log4j-over-slf4j.jar will in turn delegate all log4j API calls to their SLF4J equivalents. If both are present simultaneously, slf4j calls will be delegated to log4j, and log4j calls redirected to SLF4j, resulting in an endless loop<https://www.slf4j.org/codes.html#log4jDelegationLoop>. https://stackoverflow.com/questions/18320146/java-lang-illegalstateexception-detected-both-log4j-over-slf4j-jar-and-slf4j-lo Thanks, Arjun ________________________________ From: Chetan Kothari <[email protected]> Sent: Sunday, October 8, 2017 12:14 AM To: [email protected] Subject: RE: Access to Drill 1.9.0 HI Paul SQL Lines does not work after this warning. It also gives error - java.lang.ExceptionInInitializerError after this warning. Regards Chetan -----Original Message----- From: Paul Rogers [mailto:[email protected]] Sent: Saturday, October 7, 2017 10:42 PM To: [email protected] Subject: Re: Access to Drill 1.9.0 Hi Chetan,The message seems to be saying that there are multiple “Slf4J" logging jars found by the “Slf4J” logging mechanism. This may only be a warning.Does SqlLine work after you get this warning?Drill provides “dependency management” in its build system to avoid such errors. I wonder if someone familiar with the Alluxio client might be able to comment on how best to manage their dependency…- Paul > On Oct 7, 2017, at 12:00 AM, Chetan Kothari <[email protected]> wrote:> > I am getting following error when I am trying to integrate Drill with Alluxio.> It was working for me with both Drill 1.9.0 and Drill 1.11.0 sometime back.> > So thought of cross-checking whether issue comes with Drill 1.9.0.> > Any inputs on how to fix following issue?> > > Calculating Drill classpath...> SLF4J: Class path contains multiple SLF4J bindings.> SLF4J: Found binding in [jar:file:/D:/apache-drill-1.11.0/jars/classb/alluxio-core-client-1.4.0-jar-with-dependencies.jar!/org/slf4j/impl/StaticLoggerBinder.class]> SLF4J: Found binding in [jar:file:/D:/apache-drill-1.11.0/jars/classb/logback-classic-1.0.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]> SLF4J: See https://urldefense.proofpoint.com/v2/url?u=http-3A__www.slf4j.org_codes.html-23multiple-5Fbindings&d=DwIGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=wCBfMeK4PRbjvU58p7cEOh61BWQ8D9oJ9aQTgjryw58&s=qB2A7uRNGKAcdcPWWTyAcqTAT11t6mCLtxYjJwnahdw&e= for an explanation.> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]> SLF4J: Detected both log4j-over-slf4j.jar AND slf4j-log4j12.jar on the class path, preempting StackOverflowError.> SLF4J: See also https://urldefense.proofpoint.com/v2/url?u=http-3A__www.slf4j.org_codes.html-23log4jDelegationLoop&d=DwIGaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=wCBfMeK4PRbjvU58p7cEOh61BWQ8D9oJ9aQTgjryw58&s=CqbFmZ-Kv5MdTCjcAeGGuHTQz7qvBa_LSRnvkyLzKes&e= for more details.> java.lang.ExceptionInInitializerError> apache drill 1.11.0> "start your sql engine"> > -----Original Message-----> From: Kunal Khatua [mailto:[email protected]] > Sent: Saturday, October 7, 2017 11:07 AM> To: [email protected]> Subject: RE: Access to Drill 1.9.0> > Just curious... any reason why you're looking to try Drill 1.9.0, considering that is nearly a year old ?> > > -----Original Message-----> From: Rob Wu [mailto:[email protected]] > Sent: Friday, October 06, 2017 10:35 PM> To: [email protected]> Subject: Re: Access to Drill 1.9.0> > Hi Chetan,> > You can grab those archives here:> https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.apache.org_dist_drill_drill-2D1.9.0_&d=DwIFAg&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=zUOB0RDFLKJDe0b0M9qP85NUhoxLbCW6QCJBWyJl4L8&s=x7KT9LfHnoi60ZtZnaQFvT9Jv6wdQfsb0CNisqDwswc&e= <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.apache.org_dyn_closer.cgi_drill_drill-2D1.9.0_apache-2Ddrill-2D1.9.0.tar.gz&d=DwIFAg&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=zUOB0RDFLKJDe0b0M9qP85NUhoxLbCW6QCJBWyJl4L8&s=Ht1E8ZGR16aJBKcI3ILJGdXrOTAZuAIC6YfBrM09cfk&e=>> > Best regards,> > Rob> >> On Oct 6, 2017, at 10:28 PM, Chetan Kothari <[email protected]> wrote:>> >> I am not able to download Apache Drill 1.9.0 from Drill Site.>> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_download_&d=DwIFAg&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg&m=zUOB0RDFLKJDe0b0M9qP85NUhoxLbCW6QCJBWyJl4L8&s=3Auo_lwVDz57pDXodSkQjXV83mflZcHGKflBNuV6trs&e= >> >> Any inputs on how to get binaries of Drill 1.9.0>> >> Regards>> Chetan>
