You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Maarten Wullink <ma...@sidn.nl> on 2014/02/25 12:00:44 UTC

PhoenixIOException

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

I am getting an exception when trying to do aggregation.

I am using:
phoenix master branch (3.0)
hbase  	CDH4 	0.94.6+165


0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt  from
"queries" group by rname order by qt desc limit 10;
+------------+----------+
|   RNAME    |    QT    |
+------------+----------+
java.lang.RuntimeException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440)
	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
	at sqlline.SqlLine.print(SqlLine.java:1735)
	at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
	at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
	at sqlline.SqlLine.dispatch(SqlLine.java:821)
	at sqlline.SqlLine.begin(SqlLine.java:699)
	at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
	at sqlline.SqlLine.main(SqlLine.java:424)



Is this a known issue?


Cheers,

Maarten
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTDHfcAAoJEE8qSVxLG/CLhVoIAJVFdonQ05ifncXJ1ElC/gUt
kmf4YXk4kdE5LBX9Dc2QqPHqZ+V/+b1fmjonmUgICi5fRtXpXGMH0jyI+jurwUwD
Wy2sy5QV7qX2/IwpuVwKfQzqaNlk6Ph/bTmO2fo1g7LCxftWL69DN1NtOU1doU5w
4fs9Zby7evQUQ7WbaefIwHyi4uvMR4KAu2jpnnskzrSXlepIkYvxbSToMLkshTzn
s9G3uIc/uZzmZvLnSGd9RoV8kstS1Bs+Kgw/QViBwZV7keWgxEsdZGsHfA0C/nSB
A6kMpxdPeyM3kn1Bq7FnaQwg+RxryDyk3KqO1w7X0CeI9BxMWvQaZ622+qFF2ZE=
=bL5M
-----END PGP SIGNATURE-----

Re: PhoenixIOException

Posted by Maarten Wullink <ma...@sidn.nl>.
yes

thanks for your help

Maarten

Verstuurd vanaf mijn iPhone

Op 25 feb. 2014 om 19:55 heeft "James Taylor" <ja...@apache.org>> het volgende geschreven:

Ok, just to confirm, it's working correctly now?

Thanks,
James


On Tue, Feb 25, 2014 at 10:36 AM, Maarten Wullink <ma...@sidn.nl>> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

I dit remove the old jar and did a restart. But i probably did not
execute the DDL again. Sometimer later i did drop and recreate the
database table and then the error went away.

this is de exception log from the RS

2014-02-25 02:53:33,609 ERROR
org.apache.hadoop.hbase.regionserver.HRegionServer: Failed openScanner
org.apache.hadoop.hbase.DoNotRetryIOException:
queries,\x03\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1393325069607.00765ac94869a13fec1e76ca80b62f92.:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:51)
        at
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313)
        at
org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2429)
        at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
        at
org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
Caused by: java.lang.NoSuchMethodError:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.cache.aggcache.SpillMap$MappedByteBufferMap.addElement(SpillMap.java:437)
        at
org.apache.phoenix.cache.aggcache.SpillMap.put(SpillMap.java:294)
        at
org.apache.phoenix.cache.aggcache.SpillManager.spill(SpillManager.java:261)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1.removeEldestEntry(SpillableGroupByCache.java:190)
        at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:410)
        at java.util.HashMap.put(HashMap.java:385)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache(SpillableGroupByCache.java:251)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.scanUnordered(GroupedAggregateRegionObserver.java:384)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.doPostScannerOpen(GroupedAggregateRegionObserver.java:131)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:49)
        ... 7 more


James Taylor schreef op 25-02-14 18:01:
> One thing I forgot to mention: please make sure to remove the old
> Phoenix jar, bounce your cluster and rerun your DDL statement, as
> there's no code in place to upgrade the schema.
>
> If you've already done that, would you mind checking the server log
> for exceptions?
>
> Thanks, James
>
> On Tuesday, February 25, 2014, Maarten Wullink
> <ma...@sidn.nl>> wrote:
>
> I am getting an exception when trying to do aggregation.
>
> I am using: phoenix master branch (3.0) hbase   CDH4    0.94.6+165
>
>
> 0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt
> from "queries" group by rname order by qt desc limit 10;
> +------------+----------+ |   RNAME    |    QT    |
> +------------+----------+ java.lang.RuntimeException:
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.hadoop.hbase.DoNotRetryIOException:
> queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.:
> com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at
> sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) at
> sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at
> sqlline.SqlLine.print(SqlLine.java:1735) at
> sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at
> sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at
> sqlline.SqlLine.dispatch(SqlLine.java:821) at
> sqlline.SqlLine.begin(SqlLine.java:699) at
> sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at
> sqlline.SqlLine.main(SqlLine.java:424)
>
>
>
> Is this a known issue?
>
>
> Cheers,
>
> Maarten
>>
>

- --
Maarten Wullink | Research Engineer
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM
T +31 (0)26 352 55 45<tel:%2B31%20%280%2926%20352%2055%2045> | M +31 (0)6 21 26 87 55<tel:%2B31%20%280%296%2021%2026%2087%2055> | F +31 (0)26 352 55 05<tel:%2B31%20%280%2926%20352%2055%2005>
maarten.wullink@sidn.nl<ma...@sidn.nl> | www.sidn.nl<http://www.sidn.nl>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTDOKmAAoJEE8qSVxLG/CLRn4H/3/U7MS2ylsCY7DwBt1Pp8oQ
coEiLhwEfWgJmFjCtnLI8ZK6talJ8u/c447UkmgeXdYpnUOJvaMqNePJHfkVdFG8
5xpqjN4R3IhknxQO7vHSxghgdalnnFyaWL5P3gE2e1Iqk5Og6He3/qWJVauBDdjS
YEKhvJ1KdFWnISgRkhOenAyuGRLJp16DfdaYUTq6+Lm0VLjNGJUb/3Ob8HLVVu7n
fpxMwLx4wfMZto6EdzeWNcTl+hILlq/ibqy7gWlXAPAqRiSDOoy68hqG3eTDQ2xY
1bbyKGralnNlBf//tAtIboWXuB0yt54sFstmjLT0gsbKIIcdrgVsr1SfzRM4VJI=
=G3qJ
-----END PGP SIGNATURE-----


Re: PhoenixIOException

Posted by James Taylor <ja...@apache.org>.
Ok, just to confirm, it's working correctly now?

Thanks,
James


On Tue, Feb 25, 2014 at 10:36 AM, Maarten Wullink
<ma...@sidn.nl>wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> I dit remove the old jar and did a restart. But i probably did not
> execute the DDL again. Sometimer later i did drop and recreate the
> database table and then the error went away.
>
> this is de exception log from the RS
>
> 2014-02-25 02:53:33,609 ERROR
> org.apache.hadoop.hbase.regionserver.HRegionServer: Failed openScanner
> org.apache.hadoop.hbase.DoNotRetryIOException:
>
> queries,\x03\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1393325069607.00765ac94869a13fec1e76ca80b62f92.:
> com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
>         at
> org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73)
>         at
>
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:51)
>         at
>
> org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313)
>         at
>
> org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2429)
>         at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
>
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
>         at
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
> Caused by: java.lang.NoSuchMethodError:
> com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
>         at
>
> org.apache.phoenix.cache.aggcache.SpillMap$MappedByteBufferMap.addElement(SpillMap.java:437)
>         at
> org.apache.phoenix.cache.aggcache.SpillMap.put(SpillMap.java:294)
>         at
> org.apache.phoenix.cache.aggcache.SpillManager.spill(SpillManager.java:261)
>         at
>
> org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1.removeEldestEntry(SpillableGroupByCache.java:190)
>         at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:410)
>         at java.util.HashMap.put(HashMap.java:385)
>         at
>
> org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache(SpillableGroupByCache.java:251)
>         at
>
> org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.scanUnordered(GroupedAggregateRegionObserver.java:384)
>         at
>
> org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.doPostScannerOpen(GroupedAggregateRegionObserver.java:131)
>         at
>
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:49)
>         ... 7 more
>
>
> James Taylor schreef op 25-02-14 18:01:
> > One thing I forgot to mention: please make sure to remove the old
> > Phoenix jar, bounce your cluster and rerun your DDL statement, as
> > there's no code in place to upgrade the schema.
> >
> > If you've already done that, would you mind checking the server log
> > for exceptions?
> >
> > Thanks, James
> >
> > On Tuesday, February 25, 2014, Maarten Wullink
> > <ma...@sidn.nl> wrote:
> >
> > I am getting an exception when trying to do aggregation.
> >
> > I am using: phoenix master branch (3.0) hbase   CDH4    0.94.6+165
> >
> >
> > 0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt
> > from "queries" group by rname order by qt desc limit 10;
> > +------------+----------+ |   RNAME    |    QT    |
> > +------------+----------+ java.lang.RuntimeException:
> > org.apache.phoenix.exception.PhoenixIOException:
> > org.apache.phoenix.exception.PhoenixIOException:
> > org.apache.hadoop.hbase.DoNotRetryIOException:
> > queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.:
> > com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at
> > sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) at
> > sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at
> > sqlline.SqlLine.print(SqlLine.java:1735) at
> > sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at
> > sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at
> > sqlline.SqlLine.dispatch(SqlLine.java:821) at
> > sqlline.SqlLine.begin(SqlLine.java:699) at
> > sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at
> > sqlline.SqlLine.main(SqlLine.java:424)
> >
> >
> >
> > Is this a known issue?
> >
> >
> > Cheers,
> >
> > Maarten
> >>
> >
>
> - --
> Maarten Wullink | Research Engineer
> SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM
> T +31 (0)26 352 55 45 | M +31 (0)6 21 26 87 55 | F +31 (0)26 352 55 05
> maarten.wullink@sidn.nl | www.sidn.nl
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
> Comment: GPGTools - https://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQEcBAEBCgAGBQJTDOKmAAoJEE8qSVxLG/CLRn4H/3/U7MS2ylsCY7DwBt1Pp8oQ
> coEiLhwEfWgJmFjCtnLI8ZK6talJ8u/c447UkmgeXdYpnUOJvaMqNePJHfkVdFG8
> 5xpqjN4R3IhknxQO7vHSxghgdalnnFyaWL5P3gE2e1Iqk5Og6He3/qWJVauBDdjS
> YEKhvJ1KdFWnISgRkhOenAyuGRLJp16DfdaYUTq6+Lm0VLjNGJUb/3Ob8HLVVu7n
> fpxMwLx4wfMZto6EdzeWNcTl+hILlq/ibqy7gWlXAPAqRiSDOoy68hqG3eTDQ2xY
> 1bbyKGralnNlBf//tAtIboWXuB0yt54sFstmjLT0gsbKIIcdrgVsr1SfzRM4VJI=
> =G3qJ
> -----END PGP SIGNATURE-----
>

Re: PhoenixIOException

Posted by Maarten Wullink <ma...@sidn.nl>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

I dit remove the old jar and did a restart. But i probably did not
execute the DDL again. Sometimer later i did drop and recreate the
database table and then the error went away.

this is de exception log from the RS

2014-02-25 02:53:33,609 ERROR
org.apache.hadoop.hbase.regionserver.HRegionServer: Failed openScanner
org.apache.hadoop.hbase.DoNotRetryIOException:
queries,\x03\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1393325069607.00765ac94869a13fec1e76ca80b62f92.:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:51)
        at
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313)
        at
org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2429)
        at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
        at
org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
Caused by: java.lang.NoSuchMethodError:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.cache.aggcache.SpillMap$MappedByteBufferMap.addElement(SpillMap.java:437)
        at
org.apache.phoenix.cache.aggcache.SpillMap.put(SpillMap.java:294)
        at
org.apache.phoenix.cache.aggcache.SpillManager.spill(SpillManager.java:261)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1.removeEldestEntry(SpillableGroupByCache.java:190)
        at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:410)
        at java.util.HashMap.put(HashMap.java:385)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache(SpillableGroupByCache.java:251)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.scanUnordered(GroupedAggregateRegionObserver.java:384)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.doPostScannerOpen(GroupedAggregateRegionObserver.java:131)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:49)
        ... 7 more


James Taylor schreef op 25-02-14 18:01:
> One thing I forgot to mention: please make sure to remove the old
> Phoenix jar, bounce your cluster and rerun your DDL statement, as
> there's no code in place to upgrade the schema.
> 
> If you've already done that, would you mind checking the server log
> for exceptions?
> 
> Thanks, James
> 
> On Tuesday, February 25, 2014, Maarten Wullink
> <ma...@sidn.nl> wrote:
> 
> I am getting an exception when trying to do aggregation.
> 
> I am using: phoenix master branch (3.0) hbase   CDH4    0.94.6+165
> 
> 
> 0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt
> from "queries" group by rname order by qt desc limit 10; 
> +------------+----------+ |   RNAME    |    QT    | 
> +------------+----------+ java.lang.RuntimeException: 
> org.apache.phoenix.exception.PhoenixIOException: 
> org.apache.phoenix.exception.PhoenixIOException: 
> org.apache.hadoop.hbase.DoNotRetryIOException: 
> queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.: 
> com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at
> sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) at
> sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at
> sqlline.SqlLine.print(SqlLine.java:1735) at
> sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at
> sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at
> sqlline.SqlLine.dispatch(SqlLine.java:821) at
> sqlline.SqlLine.begin(SqlLine.java:699) at
> sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at
> sqlline.SqlLine.main(SqlLine.java:424)
> 
> 
> 
> Is this a known issue?
> 
> 
> Cheers,
> 
> Maarten
>> 
> 

- -- 
Maarten Wullink | Research Engineer
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM
T +31 (0)26 352 55 45 | M +31 (0)6 21 26 87 55 | F +31 (0)26 352 55 05
maarten.wullink@sidn.nl | www.sidn.nl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTDOKmAAoJEE8qSVxLG/CLRn4H/3/U7MS2ylsCY7DwBt1Pp8oQ
coEiLhwEfWgJmFjCtnLI8ZK6talJ8u/c447UkmgeXdYpnUOJvaMqNePJHfkVdFG8
5xpqjN4R3IhknxQO7vHSxghgdalnnFyaWL5P3gE2e1Iqk5Og6He3/qWJVauBDdjS
YEKhvJ1KdFWnISgRkhOenAyuGRLJp16DfdaYUTq6+Lm0VLjNGJUb/3Ob8HLVVu7n
fpxMwLx4wfMZto6EdzeWNcTl+hILlq/ibqy7gWlXAPAqRiSDOoy68hqG3eTDQ2xY
1bbyKGralnNlBf//tAtIboWXuB0yt54sFstmjLT0gsbKIIcdrgVsr1SfzRM4VJI=
=G3qJ
-----END PGP SIGNATURE-----

Re: PhoenixIOException

Posted by James Taylor <ja...@apache.org>.
One thing I forgot to mention: please make sure to remove the old Phoenix
jar, bounce your cluster and rerun your DDL statement, as there's no code
in place to upgrade the schema.

If you've already done that, would you mind checking the server log for
exceptions?

Thanks,
James

On Tuesday, February 25, 2014, Maarten Wullink <ma...@sidn.nl>
wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> I am getting an exception when trying to do aggregation.
>
> I am using:
> phoenix master branch (3.0)
> hbase   CDH4    0.94.6+165
>
>
> 0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt  from
> "queries" group by rname order by qt desc limit 10;
> +------------+----------+
> |   RNAME    |    QT    |
> +------------+----------+
> java.lang.RuntimeException:
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.hadoop.hbase.DoNotRetryIOException:
> queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.:
> com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
>         at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440)
>         at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
>         at sqlline.SqlLine.print(SqlLine.java:1735)
>         at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
>         at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
>         at sqlline.SqlLine.dispatch(SqlLine.java:821)
>         at sqlline.SqlLine.begin(SqlLine.java:699)
>         at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
>         at sqlline.SqlLine.main(SqlLine.java:424)
>
>
>
> Is this a known issue?
>
>
> Cheers,
>
> Maarten
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
> Comment: GPGTools - https://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQEcBAEBCgAGBQJTDHfcAAoJEE8qSVxLG/CLhVoIAJVFdonQ05ifncXJ1ElC/gUt
> kmf4YXk4kdE5LBX9Dc2QqPHqZ+V/+b1fmjonmUgICi5fRtXpXGMH0jyI+jurwUwD
> Wy2sy5QV7qX2/IwpuVwKfQzqaNlk6Ph/bTmO2fo1g7LCxftWL69DN1NtOU1doU5w
> 4fs9Zby7evQUQ7WbaefIwHyi4uvMR4KAu2jpnnskzrSXlepIkYvxbSToMLkshTzn
> s9G3uIc/uZzmZvLnSGd9RoV8kstS1Bs+Kgw/QViBwZV7keWgxEsdZGsHfA0C/nSB
> A6kMpxdPeyM3kn1Bq7FnaQwg+RxryDyk3KqO1w7X0CeI9BxMWvQaZ622+qFF2ZE=
> =bL5M
> -----END PGP SIGNATURE-----
>

Re: PhoenixIOException

Posted by Maarten Wullink <ma...@sidn.nl>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

After a cluster reboot i am again getting exceptions with aggregations.
This is with the 3.0 branch, checked out feb 26th.

RS log:


2014-02-27 05:55:55,210 ERROR
org.apache.hadoop.hbase.regionserver.HRegionServer: Failed openScanner
org.apache.hadoop.hbase.DoNotRetryIOException:
queries,\x02\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\
x00,1393332909410.191765a3d1d1a6063508ccb4dd3ceca1.:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:51)
        at
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313)
        at
org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2429)
        at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
        at
org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
Caused by: java.lang.NoSuchMethodError:
com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z
        at
org.apache.phoenix.cache.aggcache.SpillMap$MappedByteBufferMap.addElement(SpillMap.java:437)
        at
org.apache.phoenix.cache.aggcache.SpillMap.put(SpillMap.java:294)
        at
org.apache.phoenix.cache.aggcache.SpillManager.spill(SpillManager.java:261)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1.removeEldestEntry(SpillableGroupByCache.java:190)
        at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:410)
        at java.util.HashMap.put(HashMap.java:385)
        at
org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache(SpillableGroupByCache.java:251)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.scanUnordered(GroupedAggregateRegionObserver.java:384)
        at
org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.doPostScannerOpen(GroupedAggregateRegionObserver.java:131)
        at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:49)
        ... 7 more

-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: GPGTools - https://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTD0bAAAoJEE8qSVxLG/CLJv4H/R/v8bJ7zC67DpVIRQEWDvjm
DMdQm3LAQkRwU8ME3maDpNqUkoc1nKDKsjFwmyp9rE7blUJO1UrocrzmxogWKVp4
VZYizwLLtk5eNtHuEHEo+P2W+qEfM4cbTM70cVCnPfNrijaXK3huwtV7lY8yNLCu
Ikclg+8QpnSSTd/YcldTTh2yRcfbb2sQJ6Kkiq4BV1W8DeRvJAnkYD71NFLfklqD
2j34c4iLufDc/R6tg+DU8TmFzZOUVo6qTyzSqf7R38kDDbxuZXhUdKZnJupt2Tb/
a/vEEwGXJBpGU1yEOE43zF7ehuSuIkrP8yTAMrOMQVMmuZpKqFP3fiWxbpa/eR8=
=G6Nw
-----END PGP SIGNATURE-----