cockroach-teamcity
commented
3 years ago (roachtest).scbench/randomload/nodes=3/ops=2000/conc=1 failed on master@d7bbe0060531063b9bee29f69bc4d23d41b84e3d:
| ],
| "expectedExecErrors": "42P10",
| "expectedCommitErrors": "",
| "message": "ROLLBACK; Successfully got expected execution error: ERROR: column \"col22_38\" is referenced by the primary key (SQLSTATE 42P10)",
| "txStatus": "TxStatusRollbackSuccess"
| }
| {
| "workerId": 0,
| "clientTimestamp": "07:54:13.226112",
| "ops": [
| "BEGIN",
| "ALTER TABLE schema16.table22 ALTER COLUMN \"col22_37\" DROP NOT NULL",
| "CREATE INDEX IF NOT EXISTS index22_81 ON schema16.table22 (col22_32, col22_34 DESC, col22_24 ASC) STORING (col22_38, col22_23, col22_31, col22_27, col22_33, col22_26, col22_39, col22_25, col22_28, col22_40)"
| ],
| "expectedExecErrors": "42701",
| "expectedCommitErrors": "",
| "message": "ROLLBACK; Successfully got expected execution error: ERROR: index \"index22_81\" already contains column \"col22_38\" (SQLSTATE 42701)",
| "txStatus": "TxStatusRollbackSuccess"
| }
| {
| "workerId": 0,
| "clientTimestamp": "07:54:13.295981",
| "ops": [
| "BEGIN",
| "CREATE TYPE schema82.enum83 AS ENUM ('aa', 'faadd', 'fsd', 'd')"
| ],
| "expectedExecErrors": "3F000",
| "expectedCommitErrors": "",
| "message": "ROLLBACK; Successfully got expected execution error: ERROR: cannot create \"schema82.enum83\" because the target database or schema does not exist (SQLSTATE 3F000)",
| "txStatus": "TxStatusRollbackSuccess"
| }
| {
| "workerId": 0,
| "clientTimestamp": "07:54:13.301305",
| "ops": [
| "BEGIN",
| "ALTER TABLE schema16.table22 ADD COLUMN col22_84 BOOL NOT NULL",
| "ALTER TABLE schema16.table22 ADD CONSTRAINT table22_col22_31_unique UNIQUE (col22_31)",
| "ALTER TABLE schema16.table22 RENAME TO schema16.table85",
| "DROP TABLE IF EXISTS public.table86 RESTRICT",
| "INSERT INTO schema16.table85 (col22_23,col22_24,col22_25,col22_26,col22_27,col22_28,col22_30,col22_31,col22_32,col22_33,col22_34,col22_35,col22_36,col22_37,col22_38,col22_39,col22_40) VALUES (9097670659936529766:::INT8,2950304233:::OID,B'0011111110110000100011001111001111100111100100',21697:::INT8,'2016-09-26 12:15:23.000829+00:00':::TIMESTAMPTZ,'{':::STRING,B'1',(-1934366156):::INT8,'\\xf33b328c3e':::BYTES,(-9130314848215947786):::INT8,'\\x96ab':::BYTES,B'10011001111011011011','\\x8c9e9e':::BYTES,NULL,'\\x':::BYTES,'\\xb4713ec943a0ed':::BYTES,false)",
| "COMMIT"
| ],
| "expectedExecErrors": "",
| "expectedCommitErrors": "",
| "message": "***UNEXPECTED COMMIT ERROR; Received an unexpected commit error: ERROR: transaction committed but schema change aborted with error: (23502): null value in column \"col22_84\" violates not-null constraint (SQLSTATE XXA00)",
| "txStatus": "TxStatusCommitFailure"
| }
Wraps: (4) exit status 20
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *main.withCommandDetails (4) *exec.ExitError
More
Artifacts: [/scbench/randomload/nodes=3/ops=2000/conc=1](https://teamcity.cockroachdb.com/viewLog.html?buildId=2553797&tab=artifacts#/scbench/randomload/nodes=3/ops=2000/conc=1) [See this test on roachdash](https://roachdash.crdb.dev/?filter=status%3Aopen+t%3A.%2Ascbench%2Frandomload%2Fnodes%3D3%2Fops%3D2000%2Fconc%3D1.%2A&sort=title&restgroup=false&display=lastcommented+project) powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)
(jayshrivastava) this timeout is a duplicate of https://github.com/cockroachdb/cockroach/issues/56425
(roachtest).scbench/randomload/nodes=3/ops=2000/conc=1 failed on master@70fb9a54d6c4d7b3c1d8ad93bb399eefef8f5d04:
More
Artifacts: [/scbench/randomload/nodes=3/ops=2000/conc=1](https://teamcity.cockroachdb.com/viewLog.html?buildId=2400468&tab=artifacts#/scbench/randomload/nodes=3/ops=2000/conc=1) [See this test on roachdash](https://roachdash.crdb.dev/?filter=status%3Aopen+t%3A.%2Ascbench%2Frandomload%2Fnodes%3D3%2Fops%3D2000%2Fconc%3D1.%2A&sort=title&restgroup=false&display=lastcommented+project) powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)
Jira issue: CRDB-3582