workload/schemachanger: stabilize workload for mixed version issues#162261
workload/schemachanger: stabilize workload for mixed version issues#162261craig[bot] merged 1 commit intocockroachdb:masterfrom
Conversation
rafiss
left a comment
There was a problem hiding this comment.
thanks for tracking these down, just had small questions
@rafiss made 3 comments.
Reviewable status:complete! 0 of 0 LGTMs obtained (waiting on @DarrylWong, @fqazi, and @nameisbhaskar).
pkg/sql/paramparse/paramparse.go line 43 at r1 (raw file):
switch v := eval.UnwrapDatum(ctx, evalCtx, val).(type) { case *tree.DString: val, err := strconv.ParseFloat(string(*v), 64)
i fixed a few of these here too: #161472
let's make this error consistent:
if err != nil {
return 0, pgerrors.Wrapf(pgcode.InvalidParameterValue, err, "error decoding %q", name)
}
also, do you know why #161472 was not sufficient? can you add a basic logictest showing what wasn't being handled before?
pkg/workload/schemachange/operation_generator.go line 3742 at r2 (raw file):
FROM information_schema.columns WHERE table_name SIMILAR TO 'table_w[0-9]_+%%' AND column_name <> 'rowid' AND column_name NOT LIKE 'crdb_internal%%%%'
why do we need %%%%? it seems like the %% before may have been a mistake
489ecbb to
8b590eb
Compare
fqazi
left a comment
There was a problem hiding this comment.
@fqazi made 2 comments.
Reviewable status:complete! 0 of 0 LGTMs obtained (waiting on @DarrylWong, @nameisbhaskar, and @rafiss).
pkg/workload/schemachange/operation_generator.go line 3742 at r2 (raw file):
Previously, rafiss (Rafi Shamim) wrote…
why do we need
%%%%? it seems like the%%before may have been a mistake
Done.
pkg/sql/paramparse/paramparse.go line 43 at r1 (raw file):
Previously, rafiss (Rafi Shamim) wrote…
i fixed a few of these here too: #161472
let's make this error consistent:
if err != nil { return 0, pgerrors.Wrapf(pgcode.InvalidParameterValue, err, "error decoding %q", name) }also, do you know why #161472 was not sufficient? can you add a basic logictest showing what wasn't being handled before?
I backed this part out, and it was because I was on a stale master 🤦 .
fqazi
left a comment
There was a problem hiding this comment.
@fqazi made 1 comment.
Reviewable status:complete! 0 of 0 LGTMs obtained (waiting on @DarrylWong, @nameisbhaskar, and @rafiss).
pkg/sql/paramparse/paramparse.go line 43 at r1 (raw file):
Previously, fqazi (Faizan Qazi) wrote…
I backed this part out, and it was because I was on a stale master 🤦 .
We only need to handle the mixed version case
rafiss
left a comment
There was a problem hiding this comment.
@rafiss reviewed 1 file and made 1 comment.
Reviewable status:complete! 1 of 0 LGTMs obtained (waiting on @DarrylWong and @nameisbhaskar).
|
@rafiss TFTR! bors r+ |
|
bors r+ |
|
👎 Rejected by PR status |
Previously, when we added logic to fetch whether a column has an on_update expression from information_schema, we did not version gate it appropriately. This could result in failures in mixed-version environments. This patch adds a version gate and speculatively assumes that, in mixed-version environments, every column has this expression. We also expect uncatagorized errors when setting storage parameters during mixed version, due to float errors hitting problems. Fixes: cockroachdb#159458 Release note: None
8b590eb to
8c870d1
Compare
|
bors r+ |
1 similar comment
|
bors r+ |
|
bors ping |
|
pong |
|
bors r+ |
|
Build succeeded: |
|
blathers backport 26.1 |
|
Based on the specified backports for this PR, I applied new labels to the following linked issue(s). Please adjust the labels as needed to match the branches actually affected by the issue(s), including adding any known older branches. Issue #159458: branch-release-26.1. 🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf. |
|
Encountered an error creating backports. Some common things that can go wrong:
You might need to create your backport manually using the backport tool. error creating merge commit from 8c870d1 to blathers/backport-release-26.1-162261: POST https://api.github.com/repos/fqazi/cockroach/merges: 409 Merge conflict [] you may need to manually resolve merge conflicts with the backport tool. Backport to branch 26.1 failed. See errors above. 🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf. |
Previously, when we added logic to fetch whether a column has an
on_update expression from information_schema, we did not version gate it
appropriately. This could result in failures in mixed-version
environments. This patch adds a version gate and speculatively assumes
that, in mixed-version environments, every column has this expression.
We also expect uncatagorized errors when setting storage parameters
during mixed version, due to float errors hitting problems.
Fixes: #159458
Release note: None