[jira] [Commented] (PHOENIX-3235) Tephra errors when trying to create a transactional table in Phoenix 4.8.0
[
https://issues.apache.org/jira/browse/PHOENIX-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15472802#comment-15472802
]
Francis Chuang commented on PHOENIX-3235:
-
Thanks, [~jamestaylor], that would be really awesome! Fingers crossed!
> Tephra errors when trying to create a transactional table in Phoenix 4.8.0
> --
>
> Key: PHOENIX-3235
> URL: https://issues.apache.org/jira/browse/PHOENIX-3235
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
> Environment: Alpine Linux 3.4, OpenJDK 8 (JDK) in Docker 1.12.1
> containers
>Reporter: Francis Chuang
>
> I've build a docker image to run HBase 1.2 with Phoenix 4.8.0 in fully
> distributed mode. There are 2 images, 1 containing HBase and Phoenix, and 1
> with just the phoenix query server. Java is OpenJDK 8 (JDK flavour).
> The docker images can be found in my branch here:
> https://github.com/F21/hbase-phoenix/tree/consolidate-images/
> To build each image, simply go into the appropriate folder and do a `docker
> build . -t myimage`.
> To run the master, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: master
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> To run the region server, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: regionserver
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> HBase, the transaction server starts up correctly along with the query
> server. I can connect to the query server using SquirrleSQL and the Phoenix
> tables were created correctly. I am also able to create non-transactional
> tables and run queries against them.
> However, if I try to create a transactional table, I get an error message
> saying:
> {code}
> Error: Error -1 (0) : Error while executing SQL "CREATE TABLE my_table (k
> BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true": Remote driver error:
> RuntimeException: java.lang.Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> TApplicationException: Internal error
> processing startShort
> SQLState: 0
> ErrorCode: -1
> {code}
> JPS confirms that the transaction manager is still running:
> {code}
> bash-4.3# jps
> 771 Jps
> 138 HMaster
> 190 TransactionServiceMain
> {code}
> In ` /tmp/tephra-/tephra-service--m9edd51-hmaster1.m9edd51.log`, it logs the
> following:
> {code}
> Wed Aug 31 23:12:33 UTC 2016 Starting tephra service on
> m9edd51-hmaster1.m9edd51
> -f: file size (blocks) unlimited
> -t: cpu time (seconds) unlimited
> -d: data seg size (kb) unlimited
> -s: stack size (kb)8192
> -c: core file size (blocks)unlimited
> -m: resident set size (kb) unlimited
> -l: locked memory (kb) 64
> -p: processes unlimited
> -n: file descriptors 65536
> -v: address space (kb) unlimited
> -w: locks unlimited
> -e: scheduling priority0
> -r: real-time priority 0
> Command: /usr/lib/jvm/java-1.8-openjdk/bin/java -XX:+UseConcMarkSweepGC -cp
>
[jira] [Commented] (PHOENIX-3235) Tephra errors when trying to create a transactional table in Phoenix 4.8.0
[
https://issues.apache.org/jira/browse/PHOENIX-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15472795#comment-15472795
]
James Taylor commented on PHOENIX-3235:
---
Yes, [~francischuang] - that's the plan, assuming we get a new release of
Tephra in time.
> Tephra errors when trying to create a transactional table in Phoenix 4.8.0
> --
>
> Key: PHOENIX-3235
> URL: https://issues.apache.org/jira/browse/PHOENIX-3235
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
> Environment: Alpine Linux 3.4, OpenJDK 8 (JDK) in Docker 1.12.1
> containers
>Reporter: Francis Chuang
>
> I've build a docker image to run HBase 1.2 with Phoenix 4.8.0 in fully
> distributed mode. There are 2 images, 1 containing HBase and Phoenix, and 1
> with just the phoenix query server. Java is OpenJDK 8 (JDK flavour).
> The docker images can be found in my branch here:
> https://github.com/F21/hbase-phoenix/tree/consolidate-images/
> To build each image, simply go into the appropriate folder and do a `docker
> build . -t myimage`.
> To run the master, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: master
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> To run the region server, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: regionserver
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> HBase, the transaction server starts up correctly along with the query
> server. I can connect to the query server using SquirrleSQL and the Phoenix
> tables were created correctly. I am also able to create non-transactional
> tables and run queries against them.
> However, if I try to create a transactional table, I get an error message
> saying:
> {code}
> Error: Error -1 (0) : Error while executing SQL "CREATE TABLE my_table (k
> BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true": Remote driver error:
> RuntimeException: java.lang.Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> TApplicationException: Internal error
> processing startShort
> SQLState: 0
> ErrorCode: -1
> {code}
> JPS confirms that the transaction manager is still running:
> {code}
> bash-4.3# jps
> 771 Jps
> 138 HMaster
> 190 TransactionServiceMain
> {code}
> In ` /tmp/tephra-/tephra-service--m9edd51-hmaster1.m9edd51.log`, it logs the
> following:
> {code}
> Wed Aug 31 23:12:33 UTC 2016 Starting tephra service on
> m9edd51-hmaster1.m9edd51
> -f: file size (blocks) unlimited
> -t: cpu time (seconds) unlimited
> -d: data seg size (kb) unlimited
> -s: stack size (kb)8192
> -c: core file size (blocks)unlimited
> -m: resident set size (kb) unlimited
> -l: locked memory (kb) 64
> -p: processes unlimited
> -n: file descriptors 65536
> -v: address space (kb) unlimited
> -w: locks unlimited
> -e: scheduling priority0
> -r: real-time priority 0
> Command: /usr/lib/jvm/java-1.8-openjdk/bin/java -XX:+UseConcMarkSweepGC -cp
>
[jira] [Commented] (PHOENIX-3235) Tephra errors when trying to create a transactional table in Phoenix 4.8.0
[
https://issues.apache.org/jira/browse/PHOENIX-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15472726#comment-15472726
]
Francis Chuang commented on PHOENIX-3235:
-
[~mynameisalian...@gmail.com] just fixed/closed TEPHRA-179. Will it be possible
to get the fix into phoenix 4.8.1?
> Tephra errors when trying to create a transactional table in Phoenix 4.8.0
> --
>
> Key: PHOENIX-3235
> URL: https://issues.apache.org/jira/browse/PHOENIX-3235
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
> Environment: Alpine Linux 3.4, OpenJDK 8 (JDK) in Docker 1.12.1
> containers
>Reporter: Francis Chuang
>
> I've build a docker image to run HBase 1.2 with Phoenix 4.8.0 in fully
> distributed mode. There are 2 images, 1 containing HBase and Phoenix, and 1
> with just the phoenix query server. Java is OpenJDK 8 (JDK flavour).
> The docker images can be found in my branch here:
> https://github.com/F21/hbase-phoenix/tree/consolidate-images/
> To build each image, simply go into the appropriate folder and do a `docker
> build . -t myimage`.
> To run the master, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: master
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> To run the region server, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: regionserver
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> HBase, the transaction server starts up correctly along with the query
> server. I can connect to the query server using SquirrleSQL and the Phoenix
> tables were created correctly. I am also able to create non-transactional
> tables and run queries against them.
> However, if I try to create a transactional table, I get an error message
> saying:
> {code}
> Error: Error -1 (0) : Error while executing SQL "CREATE TABLE my_table (k
> BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true": Remote driver error:
> RuntimeException: java.lang.Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> TApplicationException: Internal error
> processing startShort
> SQLState: 0
> ErrorCode: -1
> {code}
> JPS confirms that the transaction manager is still running:
> {code}
> bash-4.3# jps
> 771 Jps
> 138 HMaster
> 190 TransactionServiceMain
> {code}
> In ` /tmp/tephra-/tephra-service--m9edd51-hmaster1.m9edd51.log`, it logs the
> following:
> {code}
> Wed Aug 31 23:12:33 UTC 2016 Starting tephra service on
> m9edd51-hmaster1.m9edd51
> -f: file size (blocks) unlimited
> -t: cpu time (seconds) unlimited
> -d: data seg size (kb) unlimited
> -s: stack size (kb)8192
> -c: core file size (blocks)unlimited
> -m: resident set size (kb) unlimited
> -l: locked memory (kb) 64
> -p: processes unlimited
> -n: file descriptors 65536
> -v: address space (kb) unlimited
> -w: locks unlimited
> -e: scheduling priority0
> -r: real-time priority 0
> Command: /usr/lib/jvm/java-1.8-openjdk/bin/java -XX:+UseConcMarkSweepGC -cp
>
[jira] [Commented] (PHOENIX-3235) Tephra errors when trying to create a transactional table in Phoenix 4.8.0
[
https://issues.apache.org/jira/browse/PHOENIX-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15460069#comment-15460069
]
Ali Anwar commented on PHOENIX-3235:
The Tephra JIRA to track the fix for this:
https://issues.apache.org/jira/browse/TEPHRA-179
> Tephra errors when trying to create a transactional table in Phoenix 4.8.0
> --
>
> Key: PHOENIX-3235
> URL: https://issues.apache.org/jira/browse/PHOENIX-3235
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
> Environment: Alpine Linux 3.4, OpenJDK 8 (JDK) in Docker 1.12.1
> containers
>Reporter: Francis Chuang
>
> I've build a docker image to run HBase 1.2 with Phoenix 4.8.0 in fully
> distributed mode. There are 2 images, 1 containing HBase and Phoenix, and 1
> with just the phoenix query server. Java is OpenJDK 8 (JDK flavour).
> The docker images can be found in my branch here:
> https://github.com/F21/hbase-phoenix/tree/consolidate-images/
> To build each image, simply go into the appropriate folder and do a `docker
> build . -t myimage`.
> To run the master, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: master
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> To run the region server, these environment variables are required:
> {code}
> CLUSTER_NAME: hbase
> HBASE_ROLE: regionserver
> HBASE_ZOOKEEPER_QUORUM: myzk
> HDFS_CLUSTER_NAME: mycluster
> DFS_NAMENODE_RPC_ADDRESS_NN1: nn1:8020
> DFS_NAMENODE_RPC_ADDRESS_NN2: nn2:8020
> DFS_NAMENODE_HTTP_ADDRESS_NN1: nn1:50070
> DFS_NAMENODE_HTTP_ADDRESS_NN2: nn2:50070
> {code}
> HBase, the transaction server starts up correctly along with the query
> server. I can connect to the query server using SquirrleSQL and the Phoenix
> tables were created correctly. I am also able to create non-transactional
> tables and run queries against them.
> However, if I try to create a transactional table, I get an error message
> saying:
> {code}
> Error: Error -1 (0) : Error while executing SQL "CREATE TABLE my_table (k
> BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true": Remote driver error:
> RuntimeException: java.lang.Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> Exception: Thrift error for
> org.apache.tephra.distributed.TransactionServiceClient$2@660ae15c: Internal
> error processing startShort -> TApplicationException: Internal error
> processing startShort
> SQLState: 0
> ErrorCode: -1
> {code}
> JPS confirms that the transaction manager is still running:
> {code}
> bash-4.3# jps
> 771 Jps
> 138 HMaster
> 190 TransactionServiceMain
> {code}
> In ` /tmp/tephra-/tephra-service--m9edd51-hmaster1.m9edd51.log`, it logs the
> following:
> {code}
> Wed Aug 31 23:12:33 UTC 2016 Starting tephra service on
> m9edd51-hmaster1.m9edd51
> -f: file size (blocks) unlimited
> -t: cpu time (seconds) unlimited
> -d: data seg size (kb) unlimited
> -s: stack size (kb)8192
> -c: core file size (blocks)unlimited
> -m: resident set size (kb) unlimited
> -l: locked memory (kb) 64
> -p: processes unlimited
> -n: file descriptors 65536
> -v: address space (kb) unlimited
> -w: locks unlimited
> -e: scheduling priority0
> -r: real-time priority 0
> Command: /usr/lib/jvm/java-1.8-openjdk/bin/java -XX:+UseConcMarkSweepGC -cp
>
