InfiniDB engine not recognized after building from source

4 posts / 0 new
Last post
lelsen
lelsen's picture
Offline
Last seen: 1 month 1 week ago
Joined: Apr 2 2014
Junior Boarder

Posts: 6

Lennart Elsen
InfiniDB engine not recognized after building from source

Hi all, 

 

I wonder whether some encountered this peculiar problem as well or whether I'm simply doing something in the wrong way:

 

Currently, I am considering to add some custom code to InfiniDB. In order to first check whether the system runs, I compiled version 4.5 from source and set it up as detailed in the installation guide and in the Readme.md on the github page.

 

The problem is that the InfiniDB engine is not recognized even though I specified it explicitly in the table definition:

 

CREATE TABLE my_table (col1 int ) ENGINE=InfiniDB;

 

When I check with "SHOW CREATE TABLE my_table;" the engine is displayed as "MyISAM". The following posts describe the same issue, however, they did not solve my problem:

 

http://infinidb.co/community/storage-engine-problem-with-create-table

http://infinidb.co/community/problem-runing-cpimport-table-not-round-error

http://infinidb.co/community/verifying-engine-is-correct

 

I double checked whether InfiniDB can run on my system by using the precompiled binaries from the .deb packages. It works with the InfiniDB engine.

 

The order of compilation is that I first compile InfiniDB Mysql and then InfiniDB. All the dependencies listed on the GitHub page were installed. Is there anything else in terms of libraries/dependencies such that the InfiniDB storage engine can be used?

 

I am currently using Ubuntu 13.10. Any pointers are greatly appreciated.

 

radams
radams's picture
Offline
Last seen: 1 day 7 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
InfiniDB engine not recognized after building from source

 

 

Hi,

 

Please check to see which engines are available.

 

mysql> show engines;                                                                                                                                                   
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
| InfiniDB   | YES     | InfiniDB storage engine                                    | YES          | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)
 
 
Thanks,
 
Robert
 
 
lelsen
lelsen's picture
Offline
Last seen: 1 month 1 week ago
Joined: Apr 2 2014
Junior Boarder

Posts: 6

Lennart Elsen
Hi Robert,

Hi Robert,

 

thanks for the reply. InfiniDB was not supported when I ran "show engines;".

 

I did a complete reinstall on a fresh system that never ran InfiniDB before and the engine was supported. My best guess as to why it failed before is because some files may have still been flying around from a previous installation, breaking some functionality.

 

 

davidhill
davidhill's picture
Offline
Last seen: 1 month 4 days ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
InfiniDB engine creation

The InfiniDB engine gets created as part of running postConfigure. postConfigure will run 2 scripts, which will create the engine as well as setup the system-catalog.

 

If you have run postConfigure and for some reason the engine didn't get created, you can try doing the following steps:

 

# /etc/init.d/mysql-Calpont stop

# /usr/local/Calpont/bin/post-mysqld-install

# /usr/local/Calpont/bin/post-mysql-install

# /etc/init.d/mysql-Calpont start

 

Then check for the engine..

 

David Hill (InfiniDB)