[MCOL-5639] Tooling/Process Improvements - How can we replicate/reproduce client issues quicker/easier Created: 2024-01-10  Updated: 2024-02-05

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

Type: New Feature Priority: Major
Reporter: Allen Herrera Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Idea 1:
sometimes engineers need the exact disk/metafiles to triage whats happening. building some kind of service that bundles all relevant disk, with permission of customer that devs can redeploy/triage. basically cloning an environment or sending a full backup over the internet or to an FTP server. could be massive for large customers and time consuming.

Idea 2:
Build a flag to save csv's/imports/ stuff not captured already by columnstore_reproductions
https://github.com/mariadb-corporation/columnstore-tooling/blob/main/support/debug/columnstore_reproductions.sh
columnstore_reproductions is based off the debug.log and is a script to replay queries ran that are logged in the debug.log,the script bundles the table schemas and data for said tables or can easily populate fake data. unfortunately i cant replay inserts/cpimports because i would need the csv used, and inserts are part of binlogs not debug.log, but finding a way to either toggle something so columnstore keeps the data it imported for replay purposes or some other means of replaying workload


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