[ 
https://issues.apache.org/jira/browse/DRILL-4947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15578074#comment-15578074
 ] 

Tushar Pathare edited comment on DRILL-4947 at 10/15/16 1:45 PM:
-----------------------------------------------------------------

The thread monitoring from JConsole for 

Name: SendBytes@SocketDataOutputStreamFactory[hostName=localhost, port=10000, 
connectionTimeout=10000, writeTimeout=5000]
State: TIMED_WAITING
Total blocked: 0  Total waited: 36,534

Is this thread being blocked the above port



Stack trace: 
java.lang.Thread.sleep(Native Method)
de.huxhorn.lilith.sender.SimpleSendBytesService$SendBytesThread.run(SimpleSendBytesService.java:264)
 



> Multiple inner join drill query fails to return result
> ------------------------------------------------------
>
>                 Key: DRILL-4947
>                 URL: https://issues.apache.org/jira/browse/DRILL-4947
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - RPC, Functions - Drill, Query Planning & 
> Optimization, Storage - JDBC
>    Affects Versions: 1.8.0, 1.9.0
>         Environment: RHEL 6.4 
> 32 Cores 256GB RAM
> 2.6.32-358.el6.x86_64
>            Reporter: Tushar Pathare
>            Priority: Blocker
>         Attachments: Screen Shot 2016-10-15 at 4.00.33 PM.png, Screen Shot 
> 2016-10-15 at 4.12.16 PM.png, Screen Shot 2016-10-15 at 4.12.31 PM.png, 
> Screen Shot 2016-10-15 at 4.12.40 PM.png, Screen Shot 2016-10-15 at 4.12.48 
> PM.png, Screen Shot 2016-10-15 at 4.12.55 PM.png, Screen Shot 2016-10-15 at 
> 4.13.03 PM.png, Screen Shot 2016-10-15 at 4.13.11 PM.png, Screen Shot 
> 2016-10-15 at 4.13.21 PM.png, Screen Shot 2016-10-15 at 4.13.29 PM.png, 
> drilllog_jira
>
>
> Huge query fails to return results.
> The query is related to a couple of data bases in the ORACLE DB.
> We are using ojdbc7.jar as 3rd party jars
> The query looks has about 11 inner joins or joins
> The Query and Planning page just mentions 
> Major fragment showing all the columns 'SENDING'
> Minor Fragment ID     Host Name       Start   End     Runtime Max Records     
> Max Batches     Last Update     Last Progress   Peak Memory     State
> 0-0   SENDING SENDING SENDING SENDING SENDING SENDING SENDING SENDING SENDING 
> SENDING
> the last log is as below 
> 016-10-15 15:11:24,924 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.d.exec.rpc.control.WorkEventBus - Adding fragment status listener for 
> queryId 27fde379-3cf4-c429-8d42-470f55c5fead.
> 2016-10-15 15:11:24,924 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.drill.exec.work.foreman.Foreman - Submitting fragments to run.
> 2016-10-15 15:11:24,927 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.drill.exec.ops.FragmentContext - Getting initial memory allocation of 
> 113000000
> 2016-10-15 15:11:24,928 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.drill.exec.ops.FragmentContext - Fragment max allocation: 930093368854
> 2016-10-15 15:11:24,932 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.d.e.work.batch.IncomingBuffers - Came up with a list of 0 required 
> fragments.  Fragments {}
> 2016-10-15 15:11:24,941 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.drill.exec.work.foreman.Foreman - 27fde379-3cf4-c429-8d42-470f55c5fead: 
> State change requested STARTING --> RUNNING
> 2016-10-15 15:11:24,942 [27fde379-3cf4-c429-8d42-470f55c5fead:foreman] DEBUG 
> o.a.drill.exec.work.foreman.Foreman - Fragments running.
> 2016-10-15 15:11:25,265 [27fde379-3cf4-c429-8d42-470f55c5fead:frag:0:0] DEBUG 
> o.a.d.e.p.i.s.RemovingRecordBatch - Created.
> 2016-10-15 15:11:25,390 [27fde379-3cf4-c429-8d42-470f55c5fead:frag:0:0] DEBUG 
> o.a.d.e.p.i.s.RemovingRecordBatch - Created.
> <doesnt proceed from here>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to