Query joining multiple datasources does not return

1

I am just doing a simple query in which I am joining the same small table (40 records) in different datasources.

The qry is like this:-
SELECT a.*
FROM a JOIN b ON a.id = b.id
join c ON a.id = c.id (… and all other datasources)
WHERE a.id = 6666;

The server.log is stuck at this step
turn_items e ON c.item_id = e.item_id\nWHERE c.item_id = 51551446;",“start”:1518500045745,“finish”:1518500045759,“outcome”:“FAILED”,“username”:“admin”,“commandDescription”:""}
2018-02-12 21:34:12,904 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:0:0
2018-02-12 21:34:12,916 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:1:0
2018-02-12 21:34:12,925 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:2:0
2018-02-12 21:34:14,120 [e1 - 257d872d-7195-b63c-1275-f4d26b21f100:frag:2:0] INFO c.d.s.e.f.FragmentStatusReporter - 257d872d-7195-b63c-1275-f4d26b21f100:2:0: State to report: FINISHED

2

@HLNA could you share the query profile please?

3

Can is it possible to share the profile privately, without the forum?

4

Yes, you can mail to can @ dremio.com

5

@kelly @can

Atached is another query profile. This is causing considerable frustration as sometimes these queries work and sometimes they don’t work. I am using redshift jdbc url replacing postgres jdbc, I am using same mariadb (as its supplied in dremio), I have checked both mysql servers for wait_timeout which is 28800

Help Appreciated!
5cff6d55-dddf-4ddd-b507-5512db6dd7f1.zip (12.3 KB)

6

Hi @HLNA

This seems like a know issue (Could not send query: unexpected end of exception) that we already have an internal bug created. How often is this exception happening? In other words is it consistently reproducible?

Thanks,
@balaji.ramaswamy