[MCOL-1789] Problem with cpimport.bin (pm1) Created: 2018-10-10  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: thomas lloancy Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: 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



 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:31:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.