[
https://issues.apache.org/jira/browse/PHOENIX-1378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14182600#comment-14182600
]
xufeng commented on PHOENIX-1378:
---------------------------------
I did not find any error in regionserver log.
and when I execute !table command, the index table is not exist.
0: jdbc:phoenix:10.20.14.35:2181> !table
+------------+-------------+------------+------------+------------+------------+---------------------------+---------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NAME
| SELF_REFERENCING_COL_NAME | REF_GEN |
+------------+-------------+------------+------------+------------+------------+---------------------------+---------+
| null | SYSTEM | CATALOG | SYSTEM TABLE | null | null
| null | null |
| null | SYSTEM | SEQUENCE | SYSTEM TABLE | null | null
| null | null |
| null | null | T_BLACK_LIST | TABLE | null | null
| null | null |
+------------+-------------+------------+------------+------------+------------+---------------------------+---------+
> (state=42M03,code=1012) happened when create index
> --------------------------------------------------
>
> Key: PHOENIX-1378
> URL: https://issues.apache.org/jira/browse/PHOENIX-1378
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1
> Reporter: xufeng
>
> 1. create a table
> 2.put 12000000 rows into the table.
> 3.create index on the table by [create index customer_name_index on
> T_BLACK_LIST(CUSTOMER_NAME)
> include(DATA_BUILDTIME,DATA_SOURCE,BLACKLIST_TYPE,MONEY_BOUND,DATE_CREATED,CREATED_BY,DATE_UPDATED,UPDATED_BY)
> salt_buckets=9;]
> 4.after 30 minute:
> Error: ERROR 1012 (42M03): Table undefined. tableName=CUSTOMER_NAME_INDEX
> (state=42M03,code=1012)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
