Error occurred when calling system catalog

2 posts / 0 new
Last post
gao1738
gao1738's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Jan 2 2014
Junior Boarder

Posts: 10

dennis gao
Error occurred when calling system catalog

Hi all,

I meet the following error when I use infinidb:

[size=2]
mysql> create table t1 (c int) engine=infinidb;
Query OK, 0 rows affected (13.36 sec)
mysql> insert into t1 values (1);
ERROR 168 (HY000): IDB-2033: Error occurred when calling system catalog.Error occured when calling system catalog (1). IDB-2023: PrimProc is not running (or connection to PrimProc dropped).
[/size]

It is the output of getprocessstatus:

[size=2]
Process Module Status Last Status Change Process ID
------------------ ------ --------------- ------------------------ ----------
ProcessMonitor um1 ACTIVE Mon Jan 13 13:12:00 2014 1984
ServerMonitor um1 ACTIVE Tue Jan 14 13:09:29 2014 15926
DBRMWorkerNode um1 ACTIVE Tue Jan 14 13:09:33 2014 15970
ExeMgr um1 ACTIVE Tue Jan 14 13:10:04 2014 17216
DDLProc um1 ACTIVE Tue Jan 14 13:10:08 2014 17246
DMLProc um1 ACTIVE Tue Jan 14 13:10:13 2014 17284
mysqld um1 ACTIVE Tue Jan 14 13:10:02 2014 2514

ProcessMonitor pm1 ACTIVE Mon Jan 13 12:45:41 2014 25625
ProcessManager pm1 ACTIVE Mon Jan 13 12:45:47 2014 25790
DBRMControllerNode pm1 ACTIVE Tue Jan 14 13:09:29 2014 27241
ServerMonitor pm1 ACTIVE Tue Jan 14 13:09:35 2014 27262
DBRMWorkerNode pm1 ACTIVE Tue Jan 14 13:09:35 2014 27308
DecomSvr pm1 ACTIVE Tue Jan 14 13:09:47 2014 27395
PrimProc pm1 ACTIVE Tue Jan 14 13:09:53 2014 27418
WriteEngineServer pm1 ACTIVE Tue Jan 14 13:10:01 2014 27470

ProcessMonitor pm2 ACTIVE Tue Jan 14 11:58:45 2014 2238
ProcessManager pm2 HOT_STANDBY Tue Jan 14 13:09:16 2014 14571
DBRMControllerNode pm2 COLD_STANDBY Tue Jan 14 13:09:36 2014
ServerMonitor pm2 ACTIVE Tue Jan 14 13:09:45 2014 14873
DBRMWorkerNode pm2 ACTIVE Tue Jan 14 13:09:45 2014 14897
DecomSvr pm2 ACTIVE Tue Jan 14 13:09:58 2014 14972
PrimProc pm2 ACTIVE Tue Jan 14 13:10:00 2014 1

radams
radams's picture
Offline
Last seen: 4 days 4 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re: Error occurred when calling system catalog

Hi Dennis,

We found an issue where a DML statement would not reset the connections to PrimProc in connector. We have opened a bug and will address the issue. If you encounter the problem again restart mysql to clear the condition.

# service mysql-Calpont restart

Thanks,

Robert