roachtest: pgjdbc failed [ProcedureTransactionTest failed] #119937

cockroach-teamcity · 2024-03-05T16:02:44Z

roachtest.pgjdbc failed with artifacts on master @ bf013ea0a5311726e65d37e8f047ce39ea2d5f10:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-bf013ea0a5311726e65d37e8f047ce39ea2d5f10
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations _{This test on roachdash | Improve this report!

Jira issue: CRDB-36400}

The text was updated successfully, but these errors were encountered:

rafiss · 2024-03-05T16:35:46Z

error is:

org.junit.ComparisonFailure: expected:<428[09]> but was:<428[83]>
 at org.junit.Assert.assertEquals(Assert.java:117) at org.junit.Assert.assertEquals(Assert.java:146)
 at org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction(EscapeSyntaxCallModeCallIfNoReturnTest.java:49)

See the test code here for the SQL commands it is sending: https://github.com/pgjdbc/pgjdbc/blob/9effea487dca529dc5cb0e71600a8c6509819c56/pgjdbc/src/test/java/org/postgresql/test/jdbc3/EscapeSyntaxCallModeCallIfNoReturnTest.java#L33-L51

This is the same as #119208. PR #119493 was supposed to resolve it, but seems like there is still an issue. cc @yuzefovich

cockroach-teamcity · 2024-03-06T16:03:57Z

roachtest.pgjdbc failed with artifacts on master @ ce5f34ea97475f45fa354e58aacf424779d0de49:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-ce5f34ea97475f45fa354e58aacf424779d0de49
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

yuzefovich · 2024-03-07T03:06:20Z

Sorry, I should've checked whether #119493 resolved the issue before closing #119208.

cockroach-teamcity · 2024-03-07T16:06:19Z

roachtest.pgjdbc failed with artifacts on master @ f4dc2b59541e11cf06e2b948c7c37bf1aed21868:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-f4dc2b59541e11cf06e2b948c7c37bf1aed21868
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-08T17:26:31Z

roachtest.pgjdbc failed with artifacts on master @ 559994e230ac3776dd1188e66678cce9205ab345:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-559994e230ac3776dd1188e66678cce9205ab345
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-09T13:48:42Z

roachtest.pgjdbc failed with artifacts on master @ 72646a555214c0705781e440b9df585d5eea9511:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-72646a555214c0705781e440b9df585d5eea9511
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-10T16:04:19Z

roachtest.pgjdbc failed with artifacts on master @ 41da9eccc216413c09cc66ad4c6bfa5f92c506e3:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-41da9eccc216413c09cc66ad4c6bfa5f92c506e3
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-11T14:20:16Z

roachtest.pgjdbc failed with artifacts on master @ 41da9eccc216413c09cc66ad4c6bfa5f92c506e3:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.2-dev-41da9eccc216413c09cc66ad4c6bfa5f92c506e3
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-12T12:56:19Z

roachtest.pgjdbc failed with artifacts on master @ 431d56840cacdc86638ccb48e9f3bdc16897d341:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.3-dev-431d56840cacdc86638ccb48e9f3bdc16897d341
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-13T13:13:53Z

roachtest.pgjdbc failed with artifacts on master @ 2ac5657aef0fd878973191079b6f3aadbc9c9266:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.3-dev-2ac5657aef0fd878973191079b6f3aadbc9c9266
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-16T12:40:27Z

roachtest.pgjdbc failed with artifacts on master @ 34caf9d2c267f95f6aef2713708806e6f14948d6:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.3-dev-34caf9d2c267f95f6aef2713708806e6f14948d6
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-17T10:20:35Z

roachtest.pgjdbc failed with artifacts on master @ 067e48d29b9093038f6fcf2074cd761ffdcd4fe2:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.3-dev-067e48d29b9093038f6fcf2074cd761ffdcd4fe2
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-18T10:26:59Z

roachtest.pgjdbc failed with artifacts on master @ 0b6de9c809f8a4df2ba943a8c9dd023adb03b01d:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.3-dev-0b6de9c809f8a4df2ba943a8c9dd023adb03b01d
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-19T09:44:56Z

roachtest.pgjdbc failed with artifacts on master @ a2f1f379ee52ceee2b2aa6769f1fa162f8d6b8a7:

(orm_helpers.go:221).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-a2f1f379ee52ceee2b2aa6769f1fa162f8d6b8a7
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-20T14:50:21Z

roachtest.pgjdbc failed with artifacts on master @ f0116ea373a2b87155e7f0264df4f783ce177360:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-f0116ea373a2b87155e7f0264df4f783ce177360
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-21T13:10:12Z

roachtest.pgjdbc failed with artifacts on master @ 3060756a084cc437114d64265e79ace5720a7317:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-3060756a084cc437114d64265e79ace5720a7317
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5082 tests passed
703 tests failed
72 tests skipped
185 tests ignored
2 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- PASS: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - https://github.com/cockroachdb/cockroach/issues/17511 (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

120844: workflows: run `examples-orms` on non-FIPS machines r=rail a=rickystewart This was an accident. Epic: CRDB-8308 Release note: None 120849: roachtest: update pgjdbc blocklist r=yuzefovich a=yuzefovich Two tests now pass. Also record two known failures tracked by 119937 as expected (I'm looking into them but we might need to accept these failures as expected, tbd). Addresses: #119937. Epic: None Release note: None Co-authored-by: Ricky Stewart <[email protected]> Co-authored-by: Yahor Yuzefovich <[email protected]>

cockroach-teamcity · 2024-03-23T13:54:36Z

roachtest.pgjdbc failed with artifacts on master @ 4a9385cacb82e7a8d6d37e5d9a26a6b7c845aab6:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-4a9385cacb82e7a8d6d37e5d9a26a6b7c845aab6
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

yuzefovich · 2024-03-24T02:06:32Z

Right now there are 4 failures around OUT parameters:

--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallIfNoReturnTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)

First two have the same root cause - the test expects error code 42809 WrongObjectType but receives 42883 UndefinedFunction. The test appears to do roughly the following:

CREATE OR REPLACE FUNCTION myiofunc(a INOUT int, b OUT int) AS 'BEGIN b := a; a := 1; END;' LANGUAGE plpgsql;
CALL myiofunc(1, 10);

which does return 42809 code when run manually via SQL shell. It seems like it is a quirk of JDBC driver.

Two other failures are a recently introduced bug being fixed in #120945.

yuzefovich · 2024-03-24T03:49:03Z

Never mind my last comment - the failure file has multiple errors and I only looked at the first one. There appears to be an issue with handling prepared statements. Here is a reproduction of one issue in the PGTest

send
Query {"String": "CREATE TABLE temp(a INT)"}
Query {"String": "CREATE PROCEDURE proc(a INOUT INT) AS 'BEGIN INSERT INTO temp VALUES(a); END;' LANGUAGE plpgsql"}
----

until
ReadyForQuery
ReadyForQuery
----
{"Type":"CommandComplete","CommandTag":"CREATE TABLE"}
{"Type":"ReadyForQuery","TxStatus":"I"}
{"Type":"CommandComplete","CommandTag":"CREATE PROCEDURE"}
{"Type":"ReadyForQuery","TxStatus":"I"}

send
Parse {"Name": "s0", "Query": "call proc($1)"}
Bind {"DestinationPortal": "p0", "PreparedStatement": "s0", "Parameters": [{"text":"1"}]}
Execute {"Portal": "p0"}
Sync
----

until
ReadyForQuery
----
{"Type":"ParseComplete"}
{"Type":"BindComplete"}
{"Type":"DataRow","Values":[{"text":"1"}]}
{"Type":"CommandComplete","CommandTag":"CALL"}
{"Type":"ReadyForQuery","TxStatus":"I"}

send
Query {"String": "SELECT * FROM temp"}
Query {"String": "DROP PROCEDURE proc"}
Query {"String": "DROP TABLE temp"}
----

until ignore=RowDescription
ReadyForQuery
ReadyForQuery
ReadyForQuery
----
{"Type":"DataRow","Values":[{"text":"1"}]}
{"Type":"CommandComplete","CommandTag":"SELECT 1"}
{"Type":"ReadyForQuery","TxStatus":"I"}
{"Type":"CommandComplete","CommandTag":"DROP PROCEDURE"}
{"Type":"ReadyForQuery","TxStatus":"I"}
{"Type":"CommandComplete","CommandTag":"DROP TABLE"}
{"Type":"ReadyForQuery","TxStatus":"I"}

RECV *pgproto3.ErrorResponse: &{Severity:ERROR SeverityUnlocalized:ERROR Code:0A000 Message:cached plan must not change result type Detail: Hint: Position:0 InternalPosition:0 InternalQuery: Where: SchemaName: TableName: ColumnName: DataTypeName: ConstraintName: File:plan_opt.go Line:712 Routine:runExecBuilder UnknownFields:map[]}

cockroach-teamcity · 2024-03-24T09:18:38Z

roachtest.pgjdbc failed with artifacts on master @ c994982a8be5af89f594e115e897dd6d62cf99d8:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-c994982a8be5af89f594e115e897dd6d62cf99d8
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.4-rc release-blocker]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-25T12:52:53Z

roachtest.pgjdbc failed with artifacts on master @ c994982a8be5af89f594e115e897dd6d62cf99d8:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-c994982a8be5af89f594e115e897dd6d62cf99d8
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5079 tests passed
706 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
3 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.plugin.AuthenticationPluginTest.testAuthPluginSASL - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot T-sql-foundations branch-release-23.2.4-rc release-blocker]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

yuzefovich · 2024-03-25T21:17:15Z

Failure in org.postgresql.test.plugin.AuthenticationPluginTest.testAuthPluginSASL is

    <failure message="org.postgresql.util.PSQLException: ERROR: job 954532448465354753 could not be loaded: job with ID 954532448465354753 does not exist&#10;  Hint: The job may not have succeeded." type="org.postgresql.util.PSQLException">org.postgresql.util.PSQLException: ERROR: job 954532448465354753 could not be loaded: job with ID 954532448465354753 does not exist
...
    <failure message="org.postgresql.util.PSQLException: ERROR: parameter &quot;password_encryption&quot; cannot be changed" type="org.postgresql.util.PSQLException">org.postgresql.util.PSQLException: ERROR: parameter &quot;password_encryption&quot; cannot be changed

It seems like a flake given that the previous run on exactly the same SHA didn't trigger this failure, so I'm ignoring it, for now at least.

cockroach-teamcity · 2024-03-26T10:43:14Z

roachtest.pgjdbc failed with artifacts on master @ 6df7436b6388eb7823b9f63a42aa75e1fbc89a85:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-6df7436b6388eb7823b9f63a42aa75e1fbc89a85
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2.4-rc]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-27T15:15:38Z

roachtest.pgjdbc failed with artifacts on master @ ec9444f8287663777c5ebceff61bcd280491ba08:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.4-dev-ec9444f8287663777c5ebceff61bcd280491ba08
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2.4-rc]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-28T15:10:45Z

roachtest.pgjdbc failed with artifacts on master @ 460707194644edbf4c6258d09b46d9877c8eefa6:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.5-dev-460707194644edbf4c6258d09b46d9877c8eefa6
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2.4-rc]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-29T10:34:02Z

roachtest.pgjdbc failed with artifacts on master @ 0dce29441187eda187aad472543997b06c2b01ea:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.5-dev-0dce29441187eda187aad472543997b06c2b01ea
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2.4-rc]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

cockroach-teamcity · 2024-03-29T13:22:51Z

roachtest.pgjdbc failed with artifacts on release-24.1 @ 557f4e6fe89d683d49082d88ba5adf6660e8f16f:

(orm_helpers.go:227).summarizeFailed: 
Tests run on Cockroach v24.1.0-alpha.5-dev-557f4e6fe89d683d49082d88ba5adf6660e8f16f
Tests run against pgjdbc REL42.3.3
5785 Total Tests Run
5080 tests passed
705 tests failed
72 tests skipped
185 tests ignored
0 tests passed unexpectedly
2 tests failed unexpectedly
0 tests expected failed but skipped
0 tests expected failed but not run
---
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcWithNoTxnControl - unknown (unexpected)
--- FAIL: org.postgresql.test.jdbc3.ProcedureTransactionTest.testProcAutoCommitFalse - unknown (unexpected)
For a full summary look at the pgjdbc artifacts 
An updated blocklist (pgjdbcBlockList) is available in the artifacts' pgjdbc log
test artifacts and logs in: /artifacts/pgjdbc/run_1

Parameters:

ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

roachtest: pgjdbc failed #120976 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.2.4-rc]
roachtest: pgjdbc failed #120630 roachtest: pgjdbc failed [C-test-failure O-roachtest O-robot P-2 T-sql-foundations branch-release-23.1]

_{This test on roachdash | Improve this report!}

yuzefovich · 2024-03-29T18:36:24Z

I have fixes for ProcedureTransactionTest (although the test still doesn't pass - due to #121375).

I still don't understand why we produce a different error code for org.postgresql.test.jdbc3.EscapeSyntaxCallModeCallTest.testInvokeFunction. I tried to reproduce it with a PGTest but it passes (and matches what I get locally with postgres too):

send
Query {"String": "CREATE OR REPLACE FUNCTION myiofunc(a INOUT int, b OUT int) AS 'BEGIN b := a; a := 1; END;' LANGUAGE plpgsql"}
----

until
ReadyForQuery
----
{"Type":"CommandComplete","CommandTag":"CREATE FUNCTION"}
{"Type":"ReadyForQuery","TxStatus":"I"}

send
Parse {"Name": "s1", "Query": "CALL myiofunc($1, $2)"}
Bind {"DestinationPortal": "p1", "PreparedStatement": "s1", "Parameters": [{"text":"1"},{"text":"2"}]}
Execute {"Portal": "p1"}
Sync
----

until
ErrorResponse
ReadyForQuery
----
{"Type":"ErrorResponse","Code":"42809"}
{"Type":"ReadyForQuery","TxStatus":"I"}

send
Query {"String": "DROP FUNCTION myiofunc"}
----

until ignore=RowDescription
ReadyForQuery
----
{"Type":"CommandComplete","CommandTag":"DROP FUNCTION"}
{"Type":"ReadyForQuery","TxStatus":"I"}

cockroach-teamcity added this to the 24.1 milestone Mar 5, 2024

rafiss changed the title ~~roachtest: pgjdbc failed~~ roachtest: pgjdbc failed [expected WrongObjectType error, but got UndefinedFunction] Mar 5, 2024

rafiss added T-sql-queries SQL Queries Team and removed T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Mar 5, 2024

cockroach-teamcity added this to SQL Queries Mar 5, 2024

github-project-automation bot moved this to Triage in SQL Queries Mar 5, 2024

yuzefovich self-assigned this Mar 5, 2024

yuzefovich removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Mar 5, 2024

yuzefovich moved this from Triage to Active in SQL Queries Mar 5, 2024

yuzefovich mentioned this issue Mar 12, 2024

sql: some preliminary changes for output parameter support in procedures #120029

Merged

rafiss added GA-blocker branch-release-24.1 Used to mark GA and release blockers, technical advisories, and bugs for 24.1 labels Mar 12, 2024

cockroach-teamcity mentioned this issue Mar 18, 2024

roachtest: pgjdbc failed #120630

Closed

rytaft added the P-1 Issues/test failures with a fix SLA of 1 month label Mar 20, 2024

yuzefovich mentioned this issue Mar 21, 2024

roachtest: update pgjdbc blocklist #120849

Merged

yuzefovich mentioned this issue Mar 24, 2024

sql: miscellaneous cleanup around OUT parameters #120945

Merged

cockroach-teamcity mentioned this issue Mar 24, 2024

roachtest: pgjdbc failed #120976

Closed

yuzefovich mentioned this issue Mar 26, 2024

sql: fix handling CALL of procedures with TxnControlExpr #121162

Merged

rafiss changed the title ~~roachtest: pgjdbc failed [expected WrongObjectType error, but got UndefinedFunction]~~ roachtest: pgjdbc failed [ProcedureTransactionTest failed] Mar 27, 2024

craig bot closed this as completed in e8a8125 Mar 30, 2024

github-project-automation bot moved this from Active to Done in SQL Queries Mar 30, 2024

blathers-crl bot mentioned this issue Mar 30, 2024

release-24.1: sql: fix handling CALL of procedures with TxnControlExpr #121394

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

roachtest: pgjdbc failed [ProcedureTransactionTest failed] #119937

roachtest: pgjdbc failed [ProcedureTransactionTest failed] #119937

cockroach-teamcity commented Mar 5, 2024 •

edited by cockroach-jira-scripts

Loading

rafiss commented Mar 5, 2024 •

edited

Loading

cockroach-teamcity commented Mar 6, 2024

yuzefovich commented Mar 7, 2024

cockroach-teamcity commented Mar 7, 2024

cockroach-teamcity commented Mar 8, 2024

cockroach-teamcity commented Mar 9, 2024

cockroach-teamcity commented Mar 10, 2024

cockroach-teamcity commented Mar 11, 2024

cockroach-teamcity commented Mar 12, 2024

cockroach-teamcity commented Mar 13, 2024

cockroach-teamcity commented Mar 16, 2024

cockroach-teamcity commented Mar 17, 2024

cockroach-teamcity commented Mar 18, 2024

cockroach-teamcity commented Mar 19, 2024

cockroach-teamcity commented Mar 20, 2024

cockroach-teamcity commented Mar 21, 2024

cockroach-teamcity commented Mar 23, 2024

yuzefovich commented Mar 24, 2024

yuzefovich commented Mar 24, 2024

cockroach-teamcity commented Mar 24, 2024

cockroach-teamcity commented Mar 25, 2024

yuzefovich commented Mar 25, 2024

cockroach-teamcity commented Mar 26, 2024

cockroach-teamcity commented Mar 27, 2024

cockroach-teamcity commented Mar 28, 2024

cockroach-teamcity commented Mar 29, 2024

cockroach-teamcity commented Mar 29, 2024

yuzefovich commented Mar 29, 2024

roachtest: pgjdbc failed [ProcedureTransactionTest failed] #119937

roachtest: pgjdbc failed [ProcedureTransactionTest failed] #119937

Comments

cockroach-teamcity commented Mar 5, 2024 • edited by cockroach-jira-scripts Loading

rafiss commented Mar 5, 2024 • edited Loading

cockroach-teamcity commented Mar 6, 2024

yuzefovich commented Mar 7, 2024

cockroach-teamcity commented Mar 7, 2024

cockroach-teamcity commented Mar 8, 2024

cockroach-teamcity commented Mar 9, 2024

cockroach-teamcity commented Mar 10, 2024

cockroach-teamcity commented Mar 11, 2024

cockroach-teamcity commented Mar 12, 2024

cockroach-teamcity commented Mar 13, 2024

cockroach-teamcity commented Mar 16, 2024

cockroach-teamcity commented Mar 17, 2024

cockroach-teamcity commented Mar 18, 2024

cockroach-teamcity commented Mar 19, 2024

cockroach-teamcity commented Mar 20, 2024

cockroach-teamcity commented Mar 21, 2024

cockroach-teamcity commented Mar 23, 2024

yuzefovich commented Mar 24, 2024

yuzefovich commented Mar 24, 2024

cockroach-teamcity commented Mar 24, 2024

cockroach-teamcity commented Mar 25, 2024

yuzefovich commented Mar 25, 2024

cockroach-teamcity commented Mar 26, 2024

cockroach-teamcity commented Mar 27, 2024

cockroach-teamcity commented Mar 28, 2024

cockroach-teamcity commented Mar 29, 2024

cockroach-teamcity commented Mar 29, 2024

yuzefovich commented Mar 29, 2024

cockroach-teamcity commented Mar 5, 2024 •

edited by cockroach-jira-scripts

Loading

rafiss commented Mar 5, 2024 •

edited

Loading