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

2 posts / 0 new
Last post
amr06's picture
Last seen: 9 months 2 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> 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's picture
Last seen: 6 hours 10 min ago
Joined: Jan 3 2011

Posts: 493

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


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