Hi Divya,

Can you please share the stack trace from drillbit.out/drillbit.log file for AccessControlException ? And also the query profile will be helpful.


Thanks,
Sorabh

________________________________
From: Divya Gehlot <divya.htconex@gmail.com>
Sent: Monday, June 18, 2018 3:48:43 AM
To: user@drill.apache.org
Subject: Re: strange access control exception

Hi ,
Some more updates :
1. I am able to create the same table when I am using the admin user of the
Drill .
2. In logs I could see the following errors :

Apache Drill
> 2018-06-18 01:57:23,282 [24d8a82d-285d-7a76-2ea5-560e0cd2b112:frag:0:0]
> ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: RuntimeException:
> Error closing operators
> Fragment 0:0
> [Error Id: e51bd5d5-fe9c-4a0d-ab8c-dc565d218841 on <drillbitnode1>:31010]
> org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
> RuntimeException: Error closing operators
> Fragment 0:0
> [Error Id: e51bd5d5-fe9c-4a0d-ab8c-dc565d218841 on <drillbitnode1>:31010]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:544)
> ~[drill-common-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:293)
> [drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:160)
> [drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:262)
> [drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
> [drill-common-1.10.0.jar:1.10.0]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [na:1.8.0_171]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [na:1.8.0_171]
> at java.lang.Thread.run(Thread.java:748) [na:1.8.0_171]
> Caused by: java.lang.RuntimeException: Error closing operators
> at
> org.apache.drill.exec.physical.impl.BaseRootExec$1.get(BaseRootExec.java:144)
> ~[drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec$1.get(BaseRootExec.java:141)
> ~[drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.common.DeferredException.addException(DeferredException.java:81)
> ~[drill-common-1.10.0.jar:1.10.0]
> at
> org.apache.drill.common.DeferredException.suppressingClose(DeferredException.java:161)
> ~[drill-common-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.physical.impl.BaseRootExec.close(BaseRootExec.java:149)
> ~[drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.close(ScreenCreator.java:141)
> ~[drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources(FragmentExecutor.java:311)
> [drill-java-exec-1.10.0.jar:1.10.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:155)
> [drill-java-exec-1.10.0.jar:1.10.0]
> ... 5 common frames omitted
> 2018-06-18 01:57:23,291 [BitServer-2] INFO
> o.a.drill.exec.work.foreman.Foreman - Failure while trying communicate
> query result to initiating client. This would happen if a client is
> disconnected before response notice can be sent.
>


On Mon, 18 Jun 2018 at 14:37, Divya Gehlot <divya.htconex@gmail.com> wrote:

> Hi,
> I am running a drill query in loop by passing Month,Day and hour as
> parameter .
> The query runs fine all the time except at some times where I get below
> error :
> Error: SYSTEM ERROR: AccessControlException: User <username>(user id
> 829131620) does not have access to
> /Path/to/parquetfiles/directory/2018_03_09/07/0_0_0.parquet
>
> Fragment 0:0
>
> [Error Id: 57586701-25e3-4686-91f0-74643f66a9f4 on
> <MachineName>-dn5:31010] (state=,code=0)
>
> When browsed for error I found it seems to bug with Drill while reading
> the parquet data . Here is the JIRA Link
> https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_DRILL-2D6100&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=bkjTUe-lHA8MIpnJvO5oyThSv8zh4x2CdmZc6dSpbQ4&s=IQ2qb5iRIiWHq7ZMAwthz8QmfIAcvrYdXyZy0eR3Yo0&e=
>
> I am facing this issue while writing the data .
>
> Does anybody faced this kind of issue .
> Appreciate the help !
>
> Thanks,
> Divya
>
>