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