yyerror: 1: syntax error at TEMPORARY
|
Could not get a ExeMgr connection.
|
ClientRotator::write() failed: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp: Could not get a connection to a ExeMgr
|
Could not get a ExeMgr connection.
|
ClientRotator::write() failed: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp: Could not get a connection to a ExeMgr
|
|
|
MariaDB [tdms]> call columnstore_info.table_usage(NULL,NULL);
|
ERROR 1644 (45000): Error acquiring table_usage lock
|
|
select count(*) from tablename_columnstore ;
|
|
Select query is running for 2+ hours and not providing any output on Columnstore Table .
|
Please help with the issue fix
|
|
MariaDB [(none)]> show processlist ;
|
+----+-------------+-----------+------+---------+------+--------------------------+-------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------+------+---------+------+--------------------------+-------------------------------------------+----------+
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 13 | root | localhost | XXXX| Query | 222 | Sending data | select * from infinidb_vtable.$vtable_13 | 0.000 |
|
| 14 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
|