# Error while running a query

**URL:** <https://community.dremio.com/t/error-while-running-a-query/2145>\
**Category:** Uncategorized\
**Created:** [November 1, 2018, 8:52am UTC](https://community.dremio.com/t/error-while-running-a-query/2145 "2018-11-01T08:52:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rashmi.palat](https://avatars.discourse-cdn.com/v4/letter/r/e0b2c6/32.png) [@rashmi.palat](https://community.dremio.com/u/rashmi.palat)\
**Post date:** [November 1, 2018, 8:52am UTC](https://community.dremio.com/t/error-while-running-a-query/2145/1 "2018-11-01T08:52:43Z")

</div>

Hello,

I am getting a error while running a query in dremio :  
The JDBC storage plugin failed while trying setup the SQL query.

This is what I see in the logs :  
2018-11-01 16:44:57,048 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,050 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,052 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,058 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,058 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,059 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,059 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,064 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,064 [242542f6-df5d-f33b-be11-e56486290700:foreman] INFO c.d.e.p.l.p.PruneScanRuleBase - Total pruning elapsed time: 0 ms  
2018-11-01 16:44:57,274 [FABRIC-rpc-event-queue] INFO c.d.exec.work.foreman.QueryManager - Fragment 242542f6-df5d-f33b-be11-e56486290700:1:0 failed, cancelling remaining fragments.  
2018-11-01 16:44:57,278 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A node query status message arrived post query termination, dropping. Query [242542f6-df5d-f33b-be11-e56486290700] from node address: “csl-svr-hdp04.ad.capricorn.com.au”  
user\_port: -1  
fabric\_port: 46011  
roles {  
sql\_query: false  
java\_executor: true  
master: false  
}  
startTime: 1541044862445  
provision\_id: “container\_1541044626271\_0001\_01\_000005”  
max\_direct\_memory: 25769803776  
available\_cores: 6  
.  
2018-11-01 16:44:57,279 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [3:0] reported a state of FAILED.  
2018-11-01 16:44:57,279 [out-of-band-observer] INFO query.logger - {“queryId”:“242542f6-df5d-f33b-be11-e56486290700”,“schema”:"[Trusted]",“queryText”:“select \* From trusted.da.Integration.Epicor.APTransaction As CH \r\n Inner Join trusted.da.Base.Epicor.EpicorERP.dbo.Vendor As V --Fin Supplier\r\n On CH.Company = V.Company\r\n And CH.VendorNum = V.VendorNum\r\n LeftJoin trusted.da.Base.Epicor.EpicorERP.dbo.Customer As C --CRM Supplier\r\n On C.SyncId = V.SyncID\r\n And C.SyncID \<\> 0\r\n And C.Company = ‘CAPCRM’\r\n Left Join trusted.da.Base.Epicor.EpicorERP.dbo.Customer As M --Fin Memberr\r\n On M.Company = C.Company\r\n And M.CustID = CH.MemberCustId”,“start”:1541061896181,“finish”:1541061897275,“outcome”:“FAILED”,“username”:“rashmi.palat”}  
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [4:0] reported a state of CANCELLED.  
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [0:0] reported a state of CANCELLED.  
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [5:0] reported a state of FAILED.  
2018-11-01 16:44:57,281 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A node query status message arrived post query termination, dropping. Query [242542f6-df5d-f33b-be11-e56486290700] from node address: “csl-svr-hdp05.ad.capricorn.com.au”  
user\_port: -1  
fabric\_port: 46012  
roles {  
sql\_query: false  
java\_executor: true  
master: false  
}  
startTime: 1541044886061  
provision\_id: “container\_1541044626271\_0001\_01\_000012”  
max\_direct\_memory: 25769803776  
available\_cores: 6  
.  
2018-11-01 16:44:57,282 [FABRIC-rpc-event-queue] INFO c.d.e.w.protector.ForemenWorkManager - A fragment status message arrived postquery termination, dropping. Fragment [2:0] reported a state of FAILED.

Please help!

Thanks and regards,  
Rashmi

---

<div class="post-metadata">

**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\
**Post date:** [November 1, 2018, 1:40pm UTC](https://community.dremio.com/t/error-while-running-a-query/2145/2 "2018-11-01T13:40:09Z")

</div>

Can you [share a full query profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)? From a glance, it looks like one of your worker nodes failed.  
Was there an outage? What type of query was this? Can you talk some more about your cluster?