|
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
|