[DRILL-4643] Queries hang when S3 storage plugin is enabled and config is incomplete

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.7.0
• Component/s: Execution - Flow, Query Planning & Optimization

Environment

Drill Version: 1.7.0
Git.Commit.ID: 5705d45095bd89fb9d1e7b3b3e12c34e74930c4c
Date: Apr 27 2016

• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 27/Apr/16 18:37
• Updated: 07/Sep/18 10:16

Description

I added an S3 storage plugin and was able to query files successfully. I modified the config to remove my security keys. I might have also updated my build to 1.7.0 (from 1.6.0).

After the change, I was unable to execute any queries. "Show schemas" and all other queries hang and no error message was thrown. Log indicates an issue with loading the S3 classes.

Log snippets (relevant log attached):

2016-04-27 11:00:06,575 [28df01d9-7921-215c-81ec-a8ff014f4513:foreman] INFO  o.a.drill.exec.work.foreman.Foreman - Query text for query id 28df01d9-7921-215c-81ec-a8ff014f4513: show schemas
2016-04-27 11:00:06,585 [drill-executor-3] ERROR o.a.d.exec.server.BootStrapContext - org.apache.drill.exec.work.foreman.Foreman.run() leaked an exception.
java.lang.NoClassDefFoundError: org/jets3t/service/S3ServiceException

After updating the S3 plugin with complete config, I was able to resolve the issue.

Issue Links

• is caused by: DRILL-6412 Clients are created for all storages even for disabled plugins
• is related to: DRILL-5089 Skip initializing all enabled storage plugins for every query