Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.6
-
None
Description
MariaDB [infraco_columns]> drop table my_table;
ERROR 1815 (HY000): Internal error: CAL0009: Drop table failed due to IDB-2009: Unable to perform the drop table operation because cpimport.bin (pm1) with PID 5221 is currently holding the table lock for session -1.
And i have the same very bug with:
mysql -utoto -ptoto -P3333 -e "select * from my_table limit 2" -q -N my_db --protocol=tcp | docker exec mcs /bin/sh -c "/usr/local/mariadb/columnstore/bin/cpimport -s '|' target_db target_table"
mysql: [Warning] Using a password on the command line interface can be insecure.
Locale is : C
Using table OID 3344 as the default JOB ID
Input file(s) will be read from : STDIN
Job description file : /usr/local/mariadb/columnstore/data/bulk/tmpjob/3344_D20181010_T191421_S376824_Job_3344.xml
Log file for this job: /usr/local/mariadb/columnstore/data/bulk/log/Job_3344.log
2018-10-10 19:14:21 (5608) INFO : successfully loaded job file /usr/local/mariadb/columnstore/data/bulk/tmpjob/3344_D20181010_T191421_S376824_Job_3344.xml
2018-10-10 19:14:21 (5608) INFO : Job file loaded, run time for this step : 0.0615461 seconds
2018-10-10 19:14:21 (5608) INFO : PreProcessing check starts
2018-10-10 19:14:31 (5608) ERR : Unable to acquire lock for table target_db.target_table; OID-3344; table currently locked by process-cpimport.bin (pm1); pid-5221; session-1; txn-1 [1203]
Error in loading job data
Here the processlist for both problems:
MariaDB [infraco_columns]> show processlist;
--------------------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info | Progress |
--------------------------------------------------------------------------------------------------
| 3 | system user | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | |
| 1 | system user | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | |
| 2 | system user | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | |
| 4 | system user | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | |
| 5 | system user | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | |
| 14 | root | localhost | target_db | Query | 0 | init | show processlist | 0.000 |
--------------------------------------------------------------------------------------------------
Thomas