-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest: schemachange/random-load failed #56235
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Description
(jayshrivastava) This issue is resolved by #56589, but there are different errors listed in the comments of this issue.
(roachtest).schemachange/random-load failed on master@e25ee7ad4bcdeda49f40eb52c24d2d1b1aa67a86:
| | ./workload run schemachange --verbose=1 --tolerate-errors=false --histograms=perf/stats.json --max-ops 5000 --concurrency 20
| | ```
| Wraps: (3) exit status 1
| Error types: (1) errors.Cmd (2) *hintdetail.withDetail (3) *exec.ExitError
|
| stdout:
| <... some data truncated by circular buffer; go to artifacts for details ...>
| ABLE public.table199 RENAME COLUMN "col199_210" TO "col199_211";
| ROLLBACK; ERROR: column "col199_210" does not exist (SQLSTATE 42703)
| BEGIN
| SELECT 'validating all objects';
| ALTER TABLE schema1.table146 ADD COLUMN col146_184 FLOAT8 NULL;
| CREATE TABLE schema79.table213 AS SELECT col146_9, col146_1, col146_7, col146_8, col146_2, col146_6, col146_10, col146_4, col146_0, col146_3, col146_5, col146_9, col146_3, col146_2, col146_10, col146_5, col146_7, col146_6, col146_11, col146_4, col146_8, col146_5, col146_0, col146_4, col146_1, col146_11, col146_9, col146_10, col146_3, col146_2, col146_6, col146_7 FROM schema1.table146, schema1.table146, schema1.table146;
| ROLLBACK; expected SQLSTATE(S) 42712, and got ERROR: source name "table146" specified more than once (missing AS clause) (SQLSTATE 42712)
| BEGIN
| ALTER TABLE schema1.table146 RENAME TO schema1.table186;
| COMMIT; ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=0ed8e02c key=/Table/SystemConfigSpan/Start pri=0.01781415 epo=0 ts=1604404353.536831218,1 min=1604404352.697989400,0 seq=12} lock=true stat=PENDING rts=1604404352.697989400,0 wto=false max=1604404353.197989400,0 (SQLSTATE 40001)
| BEGIN
| SELECT 'validating all objects';
| SELECT 'validating all objects';
| SELECT 'validating all objects';
| SELECT 'validating all objects';
| ALTER TABLE schema1.table146 ADD COLUMN col146_189 BIT(22) NOT NULL;
| COMMIT; ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=cd109eac key=/Table/SystemConfigSpan/Start pri=0.00741524 epo=0 ts=1604404353.536831218,1 min=1604404352.560522852,0 seq=11} lock=true stat=PENDING rts=1604404352.560522852,0 wto=false max=1604404353.060522852,0 (SQLSTATE 40001)
| BEGIN
| DROP INDEX schema1.table146@"table146_col146_0_col146_3_col146_10_col146_2_col146_8_col146_11_idx";
| ALTER TABLE schema1.table146 RENAME TO schema1.table216;
| COMMIT; ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=8f983fef key=/Table/SystemConfigSpan/Start pri=0.01290590 epo=0 ts=1604404353.536831218,1 min=1604404353.118079344,0 seq=21} lock=true stat=PENDING rts=1604404353.118079344,0 wto=false max=1604404353.618079344,0 (SQLSTATE 40001)
| BEGIN
| ALTER TABLE schema1.table146 RENAME TO schema1.table197;
| ALTER VIEW public.view217 RENAME TO public.view218;
| ROLLBACK; ERROR: relation "public.view217" does not exist (SQLSTATE 42P01)
| BEGIN
| ALTER TABLE schema1.table146 ALTER COLUMN "col146_0" SET NOT NULL;
| COMMIT; ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=e077351a key=/Table/SystemConfigSpan/Start pri=0.08053295 epo=0 ts=1604404353.794390207,1 min=1604404353.210289453,0 seq=11} lock=true stat=PENDING rts=1604404353.210289453,0 wto=false max=1604404353.710289453,0 (SQLSTATE 40001)
| BEGIN
| DROP TABLE schema1.table146;
| SELECT 'validating all objects';
| SELECT 'validating all objects';
| CREATE SEQUENCE "seq219";
| COMMIT; ***FAIL: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=c4f974d8 key=/Table/SystemConfigSpan/Start pri=0.00910610 epo=0 ts=1604404353.794390207,1 min=1604404353.302568594,0 seq=19} lock=true stat=PENDING rts=1604404353.302568594,0 wto=false max=1604404353.802568594,0 (SQLSTATE 40001)
| BEGIN
| ALTER TABLE schema1.table146 RENAME COLUMN "col146_9" TO "col146_200";
| ALTER TABLE schema1.table146 ALTER COLUMN "col146_4" SET NOT NULL;
| DROP INDEX schema1.table146@"table146_col146_0_idx";
| DROP SEQUENCE "seq131";
| DROP TABLE schema1.table146;
| ROLLBACK; ERROR: cannot update progress on succeeded job (id 604025498857832449) (SQLSTATE XXUUU)
Wraps: (4) exit status 20
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError
More
Artifacts: /schemachange/random-load
See this test on roachdash
powered by pkg/cmd/internal/issues
Jira issue: CRDB-2963
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.