Query preview works but don't run

1

Hello, everyone!

In Dremio AWS Edition, we’re using an version of Asterisk’s database with Postgres.

When we try to run the ‘select * from queue_log’ statement with Run button show up this error message:

The source [asterisk] is currently unavailable. Info: [ ]

When we click on Preview button rows are shown. When we send the command ctrl + enter all rows are shown too.

If it is saved as virtual data set the error remains. Were it could be? Do you have any ideas?

Versions below:

Dremio
Build
22.1.1-202208230402290397-a7010f28
Edition
AWS Edition
Build Time
23/08/2022 04:11:32
Change Hash
a7010f284dfb7bf28a29fb72846572e6991972d7
Change Time
23/08/2022 03:53:28

Database server
PostgreSQL 9.2.24 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit

2

@Diego Can we have the profile of the job that was successful and the one that failed?

3

@balaji.ramaswamy I upload the files here:

profile_dremio_success.zip (9,7,KB)
profile_dremio_error.zip (10,7,KB)

4

@Diego Seems to complain from node 10.0.0.120 which is an executor. Can you restart this executor and when it is coming up, tail the server.log and make sure the plugin status is marked healthy and if not see why?

Maybe you have not added this IP in pg_hba.conf to allow access to PG?

5

@balaji.ramaswamy I will to try enable IP list in pg_hba.conf. Thanks!

6

@balaji.ramaswamy I had enable IP’s from firewall and make all configurations but same problem persists

7

@Diego Check the error tab and see if it is the same executor again 10.0.0.120, if not maybe all the executors where not added to pg_hba.conf? Also review the server.log on the executor it is complaining on and look at the startup section to see if the plugin reports healthy

8

It’s not the same. I’ve already destroy and create new executors since last chat

9

@Diego Can we check two things

  • What is the error reported on the executor server.log?
  • What is the error on the server side? Postgres log
10

@balaji.ramaswamy
See the execution:
First I click on Run button, the result is error; Second, I clicked on Preview, returned success. Third, I click on Run and I receive error again

dremio asterisk error
dremio asterisk error1766×215 33.1 KB

Here the server.log from executor node
server.zip (45,0,KB)

11

@Diego Is this part of the server.log as the last line in the server.log just has the start fragment

023-01-12 20:43:49,136 [FABRIC-rpc-event-queue] INFO  c.d.sabot.exec.FragmentExecutors - Received remote fragment start instruction for 1c3f8efb-0643-edc9-d8d2-9a29a5b54f00:0:0 with assigned weight 1 and scheduling weight 1
2023-01-12 20:43:49,140 [FABRIC-rpc-event-queue] INFO  c.d.s.e.f.FragmentExecutorBuilder - Setting outStandingRPCsPerTunnel:3
12

@balaji.ramaswamy I think I didn’t understand very well. Do you need a more complete log?

13

@Diego Go to the log/archive folder of this executor 10.0.0.120 and send the tar of all server logs

tar -cvf serverlog.tar.gz server*