You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Serega Sheypak <se...@gmail.com> on 2015/09/02 22:09:46 UTC
org.apache.phoenix.execute.CommitException: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException
Hi, I'm here again. Wrote local unit-tests, all works perfectly. Started to
run smokes on production and can't reach great success. What this exception
means?
My ddl is:
CREATE TABLE IF NOT EXISTS cross_id_attributes
(
crossId VARCHAR NOT NULL
CONSTRAINT cross_id_reference_pk PRIMARY KEY (crossId)
)SALT_BUCKETS=30, DATA_BLOCK_ENCODING='SNAPPY',VERSIONS=1, TTL=691200
Here it is:
0: jdbc:phoenix:node01.a> !tables
*+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
*| ** TABLE_CAT ** | **
TABLE_SCHEM ** | ** TABLE_NAME **
| ** TABLE_TYPE ** |*
*+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
*| * * | *SYSTEM
* | *CATALOG * | *SYSTEM TABLE
* |*
*| * * | *SYSTEM
* | *SEQUENCE * | *SYSTEM TABLE
* |*
*| * * | *SYSTEM
* | *STATS * | *SYSTEM TABLE
* |*
*| * * | *
* | *CROSS_ID_ATTRIBUTES * | *TABLE
* |*
*+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
found this one:
http://stackoverflow.com/questions/4794092/unable-to-access-hbase-table
but I have other "usual" tables (non phoenix) with SNAPPY compression and
it works w/o problems.
Caused by: org.apache.phoenix.execute.CommitException:
org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed
1 action: No server address listed in hbase:meta for region
CROSS_ID_ATTRIBUTES,,1441136798698.c707266cf9e332ced8ff05170be489e9.
containing row \x0012345x: 1 time,
at org.apache.phoenix.execute.MutationState.commit(MutationState.java:451)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:427)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:424)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:424)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:283)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:211)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:174)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:179)
~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_45]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_45]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_45]
at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
at
ninja.params.ControllerMethodInvoker.invoke(ControllerMethodInvoker.java:56)
~[ninja-core-5.1.4.jar:na]
... 27 common frames omitted
Re: org.apache.phoenix.execute.CommitException: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException
Posted by Serega Sheypak <se...@gmail.com>.
I can describe table using sqlline from phoenix, but can't query the table:
select crossid from CROSS_ID_ATTRIBUTES limit 1;
just hungs and when I try to interrupt utility, I see "a kind o exception"
Exception in thread "SIGINT handler" java.lang.RuntimeException:
java.sql.SQLFeatureNotSupportedException
at
sqlline.SunSignalHandler.handle(SunSignalHandler.java:43)
at sun.misc.Signal$1.run(Signal.java:212)
at
java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLFeatureNotSupportedException
at
org.apache.phoenix.jdbc.PhoenixStatement.cancel(PhoenixStatement.java:958)
at
sqlline.DispatchCallback.forceKillSqlQuery(DispatchCallback.java:83)
at
sqlline.SunSignalHandler.handle(SunSignalHandler.java:38)
2015-09-02 22:09 GMT+02:00 Serega Sheypak <se...@gmail.com>:
> Hi, I'm here again. Wrote local unit-tests, all works perfectly. Started
> to run smokes on production and can't reach great success. What this
> exception means?
>
>
> My ddl is:
>
> CREATE TABLE IF NOT EXISTS cross_id_attributes
>
> (
>
> crossId VARCHAR NOT NULL
>
> CONSTRAINT cross_id_reference_pk PRIMARY KEY (crossId)
>
> )SALT_BUCKETS=30, DATA_BLOCK_ENCODING='SNAPPY',VERSIONS=1, TTL=691200
>
>
> Here it is:
>
> 0: jdbc:phoenix:node01.a> !tables
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> *| ** TABLE_CAT ** | **
> TABLE_SCHEM ** | ** TABLE_NAME **
> | ** TABLE_TYPE ** |*
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> *| * * | *SYSTEM
> * | *CATALOG * | *SYSTEM
> TABLE * |*
>
> *| * * | *SYSTEM
> * | *SEQUENCE * | *SYSTEM
> TABLE * |*
>
> *| * * | *SYSTEM
> * | *STATS * | *SYSTEM
> TABLE * |*
>
> *| * * | *
> * | *CROSS_ID_ATTRIBUTES * | *TABLE
> * |*
>
>
> *+------------------------------------------+------------------------------------------+------------------------------------------+----------------------------------------+*
>
> found this one:
>
> http://stackoverflow.com/questions/4794092/unable-to-access-hbase-table
>
> but I have other "usual" tables (non phoenix) with SNAPPY compression and
> it works w/o problems.
>
> Caused by: org.apache.phoenix.execute.CommitException:
> org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed
> 1 action: No server address listed in hbase:meta for region
> CROSS_ID_ATTRIBUTES,,1441136798698.c707266cf9e332ced8ff05170be489e9.
> containing row \x0012345x: 1 time,
>
> at org.apache.phoenix.execute.MutationState.commit(MutationState.java:451)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:427)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:424)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:424)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:283)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:211)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:174)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:179)
> ~[phoenix-core-4.3.0-clabs-phoenix-1.0.0.jar:na]
>
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_45]
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_45]
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_45]
>
> at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
>
> at
> ninja.params.ControllerMethodInvoker.invoke(ControllerMethodInvoker.java:56)
> ~[ninja-core-5.1.4.jar:na]
>
> ... 27 common frames omitted
>