You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "MUFEED USMAN (JIRA)" <ji...@apache.org> on 2014/10/09 15:38:33 UTC
[jira] [Updated] (DRILL-1513) sqlline Console Freezes On Executing
Queries Using More Than One Drillbit
[ https://issues.apache.org/jira/browse/DRILL-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
MUFEED USMAN updated DRILL-1513:
--------------------------------
Description:
While querying a data (sample below):
[root@n69 ~]# head webdata.tbl
1.1.11.1.1234567890123456|user123|www.abcd.com/en/US/abcde/|www.abcd.com/en/US/abcde/|2014-01-09|pg|meta.handheldfriendly|true|4
on a 3-node running Drill 0.5.0
select columns[0], count(*) as CNT from dfs.`/user/webdata.tbl` group by columns[0] order by CNT desc limit 10;
And the query console shows no signs of breakage (that from an end-user
perspective is bad).
Only a kill <sqlline PID> gets me out of the unresponsive sqlline console.
Whereas a simple count(*) on the same data works just fine.
0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> select count(*) from
dfs.`/user/webdata.tbl`;
+------------+
| EXPR$0 |
+------------+
| 23719188 |
+------------+
1 row selected (20.278 seconds)
Following can be seen in the drillbit logs:
2014-10-09 16:20:57,560 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure.
2014-10-09 16:20:57,561 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error ad4b0e49-e6f6-4561-8930-5169b98fc14e: Failure while running fragment.
2014-10-09 16:20:57,563 [WorkManager-58] ERROR o.apache.drill.exec.work.WorkManager - Failure while running wrapper [FragmentExecutor: 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:0:0]
2014-10-09 16:19:02,249 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,250 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,251 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,253 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,254 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,256 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,257 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,258 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,260 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,261 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
was:
While querying a data (sample below):
[root@n69 ~]# head webdata.tbl
cookie|userid|referrer|url|viewdate|scope|name|value|total
1.11.158.135.1389267942050681|gloryjs77|www.cisco.com/en/US/hmpgs/|www.cisco.com/en/US/hmpgs/|2014-01-09|pg|meta.handheldfriendly|true|4
1.21.108.49.1389194292791385|takashi.shimada|www.cisco.com/web/partners/|www.cisco.com/web/partners/|2014-01-08|pg|hier3|partners_and_resellers|8
1.21.108.49.1389194292791385|takashi.shimada|www.cisco.com/web/partners/|www.cisco.com/web/partners/|2014-01-08|pg|meta.language|en|8
1.21.108.49.1389194292791385|takashi.shimada|www.cisco.com/web/partners/pr11/|www.cisco.com/web/partners/pr11/|2014-01-08|ev|vid|1.21.108.49.1389194292791385|4
1.21.108.49.1389194292791385|takashi.shimada|www.cisco.com/web/partners/pr11/|www.cisco.com/web/partners/pr11/|2014-01-08|pg|meta.content-type|text/html;charset=iso-8859-1|4
1.21.108.49.1389194292791385|takashi.shimada|www.cisco.com/web/partners/pr11/|www.cisco.com/web/partners/pr11/|2014-01-08|pg|rs|1680x1050|4
1.214.61.123.1389140993615403|comtec290632|www.cisco.com/cisco/web/siteassets/contacts/|www.cisco.com/cisco/web/siteassets/contacts/|2014-01-10|lc|lc|http://www.cisco.com/cisco/web/siteassets/contacts/index.html|8
1.214.61.123.1389140993615403|comtec290632|www.cisco.com/cisco/web/siteassets/contacts/|www.cisco.com/cisco/web/siteassets/contacts/|2014-01-10|pg|title|ì—°ë
½ì²˜ 시스코 - cisco systems|8
1.214.61.123.1389140993615403|comtec290632|www.cisco.com/en/US/tech/tk365/technologies_configuration_example09186a0080ba1d2d.shtml|www.cisco.com/en/US/tech/tk365/technologies_configuration_example09186a0080ba1d2d.shtml|2014-01-10|pg|url|http://www.cisco.com/en/us/tech/tk365/technologies_configuration_example09186a0080ba1d2d.shtml|4
on a 3-node running Drill 0.5.0
select columns[0], count(*) as CNT from dfs.`/user/webdata.tbl` group by columns[0] order by CNT desc limit 10;
And the query console shows no signs of breakage (that from an end-user
perspective is bad).
Only a kill <sqlline PID> gets me out of the unresponsive sqlline console.
Whereas a simple count(*) on the same data works just fine.
0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> select count(*) from
dfs.`/user/webdata.tbl`;
+------------+
| EXPR$0 |
+------------+
| 23719188 |
+------------+
1 row selected (20.278 seconds)
Following can be seen in the drillbit logs:
2014-10-09 16:20:57,560 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure.
2014-10-09 16:20:57,561 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error ad4b0e49-e6f6-4561-8930-5169b98fc14e: Failure while running fragment.
2014-10-09 16:20:57,563 [WorkManager-58] ERROR o.apache.drill.exec.work.WorkManager - Failure while running wrapper [FragmentExecutor: 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:0:0]
2014-10-09 16:19:02,249 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,250 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,251 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,253 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,254 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,256 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,257 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
2014-10-09 16:19:02,258 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,260 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
2014-10-09 16:19:02,261 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
> sqlline Console Freezes On Executing Queries Using More Than One Drillbit
> -------------------------------------------------------------------------
>
> Key: DRILL-1513
> URL: https://issues.apache.org/jira/browse/DRILL-1513
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - CLI
> Affects Versions: 0.5.0
> Reporter: MUFEED USMAN
>
> While querying a data (sample below):
> [root@n69 ~]# head webdata.tbl
> 1.1.11.1.1234567890123456|user123|www.abcd.com/en/US/abcde/|www.abcd.com/en/US/abcde/|2014-01-09|pg|meta.handheldfriendly|true|4
> on a 3-node running Drill 0.5.0
> select columns[0], count(*) as CNT from dfs.`/user/webdata.tbl` group by columns[0] order by CNT desc limit 10;
> And the query console shows no signs of breakage (that from an end-user
> perspective is bad).
> Only a kill <sqlline PID> gets me out of the unresponsive sqlline console.
> Whereas a simple count(*) on the same data works just fine.
> 0: jdbc:drill:zk=n69:5181,n72:5181,n73:5181> select count(*) from
> dfs.`/user/webdata.tbl`;
> +------------+
> | EXPR$0 |
> +------------+
> | 23719188 |
> +------------+
> 1 row selected (20.278 seconds)
> Following can be seen in the drillbit logs:
> 2014-10-09 16:20:57,560 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure.
> 2014-10-09 16:20:57,561 [4fd32d44-ffd0-4351-829f-bfa5c6accdcd:frag:0:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error ad4b0e49-e6f6-4561-8930-5169b98fc14e: Failure while running fragment.
> 2014-10-09 16:20:57,563 [WorkManager-58] ERROR o.apache.drill.exec.work.WorkManager - Failure while running wrapper [FragmentExecutor: 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:0:0]
> 2014-10-09 16:19:02,249 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
> 2014-10-09 16:19:02,250 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
> 2014-10-09 16:19:02,251 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
> 2014-10-09 16:19:02,253 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
> 2014-10-09 16:19:02,254 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
> 2014-10-09 16:19:02,256 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
> 2014-10-09 16:19:02,257 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
> 2014-10-09 16:19:02,258 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
> 2014-10-09 16:19:02,260 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:1
> 2014-10-09 16:19:02,261 [BitServer-6] ERROR o.a.drill.exec.rpc.data.DataServer - Failure while getting fragment manager. 4fd32d44-ffd0-4351-829f-bfa5c6accdcd:1:3
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)