IDB for Apache Hadoop: ERROR 122 (HY000): CAL0009

2 posts / 0 new
Last post
amr06
amr06's picture
Offline
Last seen: 7 months 3 weeks ago
Joined: Nov 13 2013
Junior Boarder

Posts: 5

Anju M R
IDB for Apache Hadoop: ERROR 122 (HY000): CAL0009

I installed InfiniDB for Apache Hadoop on a machine with Cloudera Hadoop.

I have the UM running on machine InfiniDB1 which is my master node and PMs on InfiniDB2 (PM1), InfiniDB3 (PM2), and InfiniDB3 (PM3) which are slave machines.

root@infinidb2# idbmysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.1.39 Calpont InfiniDB 4.0-1

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;
+---------------------+
| Database |
+---------------------+
| information_schema |
| calpontsys |
| hdfs_load_test |
| infinidb_querystats |
| infinidb_vtable |
| mysql |
| test |
+---------------------+
7 rows in set (0.04 sec)

mysql> use hdfs_load_test;
Database changed
mysql>
mysql>
mysql>
mysql> create table test(c1 int, c2 int)engine=infinidb;
[b]ERROR 122 (HY000): CAL0009: Error while calling getSysCatDBRoot[/b]

Please help with the issue.

radams
radams's picture
Offline
Last seen: 9 hours 12 min ago
Joined: Jan 3 2011
Administrator

Posts: 487

Robert Adams
Re: IDB for Apache Hadoop: ERROR 122 (HY000): CAL0009

Hi,

The error is indicating the system catalog is not present. Based on the description, the um on this system is infinidb1. In your example you are trying to run idbmysql from the PM "root@infinidb2# idbmysql". Please make sure you are running the idbmysql command on the UM. If you get the same error when running on the UM, verify postConfigure created the system catalog by running the following command.

# /usr/local/Calpont/bin/editem -i

Thanks,

Robert
Calpont