[MCOL-4975] viewtablelock does not shows active locking though shutdownSystem command says there is one. Created: 2022-01-28  Updated: 2022-03-29

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Allen Lee (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MCOL-4986 How to force a ColumnStore lock to be... Open

 Description   

When running `shutdownsystem` command, it shows `There are active transactions being processed`, but when checking viewtablelock, it shows there is nothing.

[root@host ~]# /usr/local/mariadb/columnstore/bin/viewtablelock
No tables are locked in the database.
 
mcsadmin> shutdownsystem y
shutdownsystem Tue Jan 25 23:49:38 2022
 
This command stops the processing of applications on all Modules within the MariaDB ColumnStore System
 
Checking for active transactions
 
There are active transactions being processed
Your options are:
Cancel -- Cancel the shutdown request
Wait -- Wait for write operations to end and then shutdown
Force -- Force a shutdown
What would you like to do: [Cancel]:

And of course, show processlist and `mcsadmin getActiveSQLStatements` show nothing is running.



 Comments   
Comment by Roman [ 2022-02-16 ]

Hey allen.lee@mariadb.com
Could you find us a suitable Extent Map state(see the last comment in the linked issue for details) so we can proceed with this issue?

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