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
