phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Serega Sheypak <serega.shey...@gmail.com>
Subject org.apache.phoenix.execute.CommitException: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException
Date Wed, 02 Sep 2015 20:09:46 GMT
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

Mime
View raw message