[MCOL-1046] Insert Into Select * From can corrupt table Created: 2017-11-21  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.0.11
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Matthew Minix Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

Centos 7


Attachments: Text File debugend.log     Text File err (2).log     Text File info.log    

 Description   

This occurred after inserting something like 20 GB into a table, which involved probably a fair amount of deletes - inserts

After doing this successfully there was an error and now the table wont accept any data, outputting

Get error 1 "Operation not permitted" from storage engine Columnstore

when any insert is attempted

I'm planning on attaching snippets from the various logs, attempting while creating the issue is failing for some reason. It appears to me like maybe a race condition was hit and the attempted cleanup failed, there are several references to "a BRM get hwm error" - but searching for that only brings up the infinidb source code on github



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-11-21 ]

It looks like there is a serious issue with your extent map. Can you please run the ColumnStore support tool and send up the results? This will allow us to see much more of what was going on when it happened:

https://mariadb.com/kb/en/library/system-troubleshooting-mariadb-columnstore/#mariadb-columnstore-support-report-tool

Comment by Matthew Minix [ 2017-11-22 ]

Yes, I wont be able to until this weekend but will then, thank you!

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

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

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