Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

roachtest: npgsql failed [crashes with unsupported binary serialization of multidimensional arrays] #118206

Closed
cockroach-teamcity opened this issue Jan 23, 2024 · 17 comments · Fixed by #118376
Closed

roachtest: npgsql failed [crashes with unsupported binary serialization of multidimensional arrays] #118206

cockroach-teamcity opened this issue Jan 23, 2024 · 17 comments · Fixed by #118376
Assignees
@yuzefovich
Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. P-1 Issues/test failures with a fix SLA of 1 month T-sql-queries SQL Queries Team
Milestone
24.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Jan 23, 2024 •
edited by cockroach-jira-scripts

roachtest.npgsql failed with artifacts on master @ 585ffa0acfa6dd771aad8320d3a9e219acf56656:

--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).Send_unknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E+24::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).Write_as_ArraySegment_of_char -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(Cascade) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1E+28::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_more_properties_than_attributes -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("-1.4::numeric(10,0)",-1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTypeTests(NonMultiplexing).Double -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1000000000000000000000000::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-4::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_without_getter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Text_as_array_of_chars -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("100000000::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_private_setter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Date_as_DateOnly -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1.5::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.000000000001::numeric",0.000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1.5::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.FunctionTests.Void -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1.2::numeric(10,4)",1.2000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_without_setter -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1000000000000000000000000::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Write_Record_is_not_supported -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0.0001::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.0001::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("10000000000000000::numeric",10000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Datemultirange_as_array_of_NpgsqlRange_of_DateTime -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).IEnumerable_throws_friendly_exception -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("-1.5::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("0.000000000001::numeric",0.000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_struct_with_property -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).Boolean -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).TextReader -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Timestamp_as_long -  (unexpected)
--- FAIL: Npgsql.Tests.FunctionTests.DeriveParameters_non_existing_function -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).LogicalDecodingMessage(False) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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-35609
@cockroach-teamcity cockroach-teamcity added branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Jan 23, 2024
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone Jan 23, 2024
@rafiss rafiss self-assigned this Jan 23, 2024
@rafiss rafiss added P-1 Issues/test failures with a fix SLA of 1 month and removed release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Jan 23, 2024
@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ 2bc9c820cd35cc4756a408a51efab005d4b48604:

--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).TwoPhase(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_more_properties_than_attributes -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("1E+20::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-1.4::numeric(10,0)",-1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(NonMultiplexing).Inet_v6_as_IPAddress -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("10000::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1::numeric(10,2)",1.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.0000000000000001::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).IPAddress_Any -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("111.22223333444455556666777788::numeric",111.22223333444455556666777788m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).BitVector32 -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_private_setter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.LegacyDateTimeTests.Timestamptz_local_DateTime_converts -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Text_as_ArraySegment_of_chars -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1E+16::numeric",10000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.CommonReplicationTests<LogicalReplicationConnection>.Synchronous_replication -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1.2::numeric(10,2)",1.20m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("10000000000000000000000000000::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_overflow_is_safe -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(None) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0.0036882500000000000000000000",0.0036882500000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("-1.5::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).Inet_v6_as_NpgsqlInet -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_two_properties_inverted -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeTests(NonMultiplexing).Table_as_composite(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0::numeric",0m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).Stream -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1E+20::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(Multiplexing).IList_non_generic -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Update_for_index_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Timestamptz_as_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Text_as_array_of_bytes -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.Timeout_getting_connector_from_exhausted_pool(True) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1.5::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1234567844445555.000000000",1234567844445555.000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E-12::numeric",0.000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.0001::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).DbType_causes_inference -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.DataSource_UserCertificateValidationCallback_is_invoked(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("10000000000000000::numeric",10000000000000000m) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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!

@rafiss
Copy link
Collaborator

rafiss commented Jan 23, 2024

The logs are filled with thousands of messages like:

Npgsql.NpgsqlException : Failed to connect to 127.0.0.1:29000

This actually first started happening On Jan 20; see: #117734 (comment)

It looks like #117613 is the only roachtest PR that went in on Jan 19, so I'll reassign this to TestEng.

@rafiss rafiss changed the title roachtest: npgsql failed roachtest: npgsql failed [thousands of Failed to connect to 127.0.0.1:29000] Jan 23, 2024
@rafiss rafiss removed their assignment Jan 23, 2024
@rafiss rafiss added T-testeng TestEng Team and removed T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Jan 23, 2024
@blathers-crl blathers[crl]
Copy link

blathers-crl bot commented Jan 23, 2024

cc @cockroachdb/test-eng

@blathers-crl blathers-crl bot added this to Triage in Test Engineering Jan 23, 2024
@renatolabs
Copy link
Collaborator

I don't think this is a problem with the test infrastructure. Cockroach is crashing early in the test with a panic:

E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +panic: ‹unexpected err from buffer: unimplemented: unsupported binary serialization of multidimensional arrays›

@rafiss
Copy link
Collaborator

rafiss commented Jan 23, 2024

ah, thanks for spotting that. that is related to #117838 then

@rafiss rafiss changed the title roachtest: npgsql failed [thousands of Failed to connect to 127.0.0.1:29000] roachtest: npgsql failed [crashes with unsupported binary serialization of multidimensional arrays] Jan 23, 2024
@rafiss rafiss added T-sql-queries SQL Queries Team and removed T-testeng TestEng Team labels Jan 23, 2024
@rafiss rafiss removed this from Triage in Test Engineering Jan 23, 2024
@rafiss
Copy link
Collaborator

rafiss commented Jan 23, 2024

Looks like the repro is to execute SELECT ARRAY[ARRAY[1], ARRAY[2]] and request the results in the binary format. We should be able to add a regression test for this in pkg/sql/pgwire/testdata/pgtest/array

E240123 21:36:09.942244 16354 9@sql/conn_executor.go:1176 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1018  a SQL panic has occurred while executing the following statement:
E240123 21:36:09.942244 16354 9@sql/conn_executor.go:1176 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1018 +‹SELECT ARRAY[ARRAY[1], ARRAY[2]]›
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019  a panic has occurred!
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +panic: ‹unexpected err from buffer: unimplemented: unsupported binary serialization of multidimensional arrays›
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +(1) attached stack trace
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  -- stack trace:
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:949
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | [...repeated from below...]
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +Wraps: (2) while executing: SELECT ARRAY[ARRAY[_], ARRAY[_]]
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +Wraps: (3) attached stack trace
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  -- stack trace:
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:949
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | runtime.gopanic
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | 	GOROOT/src/runtime/panic.go:914
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).bufferBatch
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:946
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*commandResult).AddBatch
E240123 21:36:09.942356 16354 1@util/log/logcrash/crash_reporting.go:196 ⋮ [T1,Vsystem,n1,client=127.0.0.1:35242,hostssl,user=‹npgsql_tests›] 1019 +  | 	github.com/cockroachdb/cockroach/pkg/sql/pgwire/command_result.go:264

@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ e0fbbe4c1334580bf05d6d6fb0d406a327e43944:

--- FAIL: Npgsql.Tests.Types.DateTimeTests.Timestamp_as_long -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Delete_for_default_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.FullTextSearchTests(NonMultiplexing).TsQuery("'a' <-> 'b'",'a' <-> 'b') -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(Multiplexing).Bitstring_with_multiple_bits_as_bool_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("936490726837837729197",936490726837837729197m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).Inet_v6_as_tuple -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(None) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_class_with_field -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(NonMultiplexing).IPAddress_Any -  (unexpected)
--- FAIL: Npgsql.Tests.AuthenticationTests(NonMultiplexing).Use_pgpass_from_homedir -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1E+20::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("0.00000000000000000001::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1E-20::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Bitstring_with_multiple_bits_as_bool_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Date_as_int -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Array_of_single_bits -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("1::numeric(10,2)",1.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).TwoPhase(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_less_properties_than_attributes_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("9364907268378377291970000",9364907268378377291970000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_class_with_property -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E+16::numeric",10000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).LogicalDecodingMessage(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).AllResultTypesAreUnknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-20::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.AuthenticationTests(NonMultiplexing).Use_pgpass_from_connection_string -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).TextReader -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Insert -  (unexpected)
--- FAIL: Npgsql.Tests.StoredProcedureTests.DeriveParameters_procedure_various -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Jagged_arrays_not_supported -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("-79228162514264337593543950335::numeric",decimal.MinValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(Multiplexing).Bind_int_then_array_of_int -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Text_as_string -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTypeTests(NonMultiplexing).Read_overflow<Int64>(0L,9.223372036854776E+18d,"decimal") -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("100000000::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("11112222000000000000",11112222000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(Multiplexing).Write_as_NonSeekable_stream -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).IPAddress_Any -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1::numeric(10,2)",1.00m) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ e996b2f9587ec45bc2e419603ea95b86b4d1e379:

--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Update_for_full_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0.00000001::numeric",0.00000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.DataSource_UserCertificateValidationCallback_is_invoked(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_string -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_MemoryStream_truncated -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_without_getter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Update_for_index_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E+20::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Interval_as_NpgsqlInterval -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Truncate(RestartIdentity) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E+8::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1.2::numeric(10,4)",1.2000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.FullTextSearchTests(Multiplexing).TsQuery("'a'",'a') -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_poco_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1.2::numeric(10,1)",1.2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(Multiplexing).Write_as_ArraySegment -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Write_as_string -  (unexpected)
--- FAIL: Npgsql.Tests.CommandTests(NonMultiplexing).Named_parameters_are_not_supported_when_EnableSqlParsing_is_disabled -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_private_getter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Cannot_mix_DateTime_Kinds_in_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("9364907268378377291970000",9364907268378377291970000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).ValueMetadata -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(Cascade, RestartIdentity) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("10000000000000000000000000000::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.MultipleHostsTests.IntegrationTest(True,True) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("-1.5::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).Write_as_ArraySegment_of_char -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_struct_with_property -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).Read_unknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).BigInteger_large -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E+4::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.SslMode_Require_throws_without_TSC -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).As_string_with_GetTextReader -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Read_two_empty_arrays -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1.2::numeric(10,1)",1.2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.0001::numeric",0.0001m) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ 45cd83b6838bd515c273955c90ade06ca9fa8794:

--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Aliased_DbTypes(AnsiStringFixedLength) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Truncate -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).UnknownResultTypeList -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("3649072683783772919700000000",3649072683783772919700000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E-24::numeric",0.000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Uuid -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("10000::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).TwoPhase(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1.2::numeric(10,5)",1.20000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E+0::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Update_for_default_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(NonMultiplexing).Breaking_connection_while_loading_database_info -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Text_as_array_of_chars -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Write_as_string_validation -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.Connection_UserCertificateValidationCallback_is_invoked(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1::numeric(10,2)",1.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Unsupported_DbType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("-79228162514264337593543950335::numeric",decimal.MinValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1E-16::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1.2::numeric(10,3)",1.200m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E-20::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.0001::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+28::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(NonMultiplexing).Client_encoding_is_UTF8_by_default -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).BitVector32_too_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTypeTests(Multiplexing).Int64 -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.Timeout_getting_connector_from_exhausted_pool(True) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.ClearPool(1) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("11112222000000000000",11112222000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).DbType_causes_inference -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(Multiplexing).Write_as_string -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_char_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Interval_with_microsecond -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_two_parameters_reversed -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E+24::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.0000000000000000000000000001::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(Multiplexing).Timezone_env_var -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(NonMultiplexing).PhysicalConnectionInitializer_async_with_break -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Read_null_as_non_nullable_array_throws -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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!

@michae2
Copy link
Collaborator

michae2 commented Jan 26, 2024

@yuzefovich, considering that we don't yet support multi-dimensional arrays in most places, perhaps due to incompatibilities with PG, I'm wondering if we should revert #117838 until we're fully ready to tackle #32552?

@yuzefovich yuzefovich removed this from Triage in SQL Foundations Jan 26, 2024
@yuzefovich yuzefovich self-assigned this Jan 26, 2024
@yuzefovich
Copy link
Member

Fully-reverting #117838 seems wrong to me. Disallowing nested arrays in checkResultType before that change was safe, but it was overly conservative. I think the right way forward is to have necessary error checks in places where we don't support the multi-dimensional arrays. This issue highlights actually a somewhat different bug - that we shouldn't panic in bufferBatch if there is an error when constructing PGWire messages.

@yuzefovich
Copy link
Member

Simply turning this panic into an error results in closing the connection (which doesn't sound good). Please share your thoughts in the slack.

@yuzefovich yuzefovich mentioned this issue Jan 26, 2024
Merged
@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ b59a83a1cd31d8e00f39cf32b1cf99b41b96e28e:

--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).Write_as_ArraySegment_of_char -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).As_JsonDocument -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Datemultirange_as_array_of_NpgsqlRange_of_DateTime -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Boolean -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-1.5::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-8::numeric",0.00000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeInfinityTests(True).Timestamp_write -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Aliased_postgres_types("name",Name) -  (unexpected)
--- FAIL: Npgsql.Tests.StoredProcedureTests.With_output_parameters(False,True) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.ClearPool(2) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.LegacyDateTimeTests.Timestamptz_local_DateTime_converts -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Update_for_full_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1.2::numeric(10,3)",1.200m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("100000000::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("10000::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_private_setter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_explicit_property_name -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.Connection_UserCertificateValidationCallback_is_invoked(True) -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(NonMultiplexing).DatabaseInfo_is_shared -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1E-16::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("11.222233334444555566667777888::numeric",11.222233334444555566667777888m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("10000000000000000000000000000::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).AllResultTypesAreUnknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeInfinityTests(True).Date_DateTime_write -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).AllResultTypesAreUnknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.000000000000000000000001::numeric",0.000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).CreatePgOutputReplicationSlot -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Zero_dimensional -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.0000000000000000000000000001::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(None) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_poco -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Truncate -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Truncate(None) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Text_as_array_of_bytes -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(Multiplexing).Timezone_env_var -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeInfinityTests(True).Date_DateOnly_read -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Unsupported_DbType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Text_long -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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 cockroach-teamcity mentioned this issue Jan 27, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ 0baf22a03d5f55e2611701bc723e3e0b713ab051:

--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1.4::numeric(10,0)",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_explicit_property_name -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-24::numeric",0.000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1E+28::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("10000::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("100000000::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E+4::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.TimeTz_before_utc_zero -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("936490726837837729197",936490726837837729197m) -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(Multiplexing).Clone -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("10000::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Mixed_element_types -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1234567844445555.000000000",1234567844445555.000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.ClearPool_with_busy -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+24::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.InternalTypeTests(Multiplexing).Read_internal_char -  (unexpected)
--- FAIL: Npgsql.Tests.NpgsqlEventSourceTests.Command_start_stop -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_less_parameters_than_attributes_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_less_properties_than_attributes_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Update_for_full_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(Multiplexing).Bitstring_with_multiple_bits_as_bool_throws -  (unexpected)
--- FAIL: Npgsql.Tests.MultipleHostsTests.BuildMultiHost_with_single_host_is_supported -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.0000000000000001::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.00000000000000000001::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1.4::numeric(10,0)",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("0.0000000000000001::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Bitstring_with_multiple_bits_as_bool_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(Cascade) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).DbType_causes_inference -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_two_properties_inverted -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Numeric -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Cannot_mix_DateTime_Kinds_in_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0::numeric",0m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1E+28::numeric",10000000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Write_as_string_validation -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(NonMultiplexing).Aliased_DbTypes(AnsiStringFixedLength) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Bytea -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.StoredProcedureTests.DeriveParameters_non_existing_procedure -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E-4::numeric",0.0001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).Can_read_two_json_documents -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("0.0000000000000000000000000001::numeric",0.0000000000000000000000000001m) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ 0baf22a03d5f55e2611701bc723e3e0b713ab051:

--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Read_as_string_is_not_supported -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).LogicalDecodingMessage(False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_MemoryStream_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).TextReader -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Timestamptz_as_DateTimeOffset_utc -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Dispose_while_replicating -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("-79228162514264337593543950335::numeric",decimal.MinValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Update_for_default_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1.4::numeric(10,0)",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(Multiplexing).BitArray_empty -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Read_two_empty_arrays -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("-1.4::numeric(10,0)",-1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1.2::numeric(10,2)",1.20m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("0.0000000000000000000000000001::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolManagerTests.With_canonical_connection_string -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E-16::numeric",0.0000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("100000000000000000000::numeric",100000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_string_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.LegacyDateTimeTests.Timestamptz_write_utc_DateTime_does_not_convert -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.Bug1718 -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("2.5::numeric(10,0)",3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).IList_generic -  (unexpected)
--- FAIL: Npgsql.Tests.CommandTests(NonMultiplexing).Positional_parameters_are_supported_when_EnableSqlParsing_is_disabled -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).Null -  (unexpected)
--- FAIL: Npgsql.Tests.MultipleHostsTests.IntegrationTest(True,False) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_without_setter -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Interval_as_NpgsqlInterval -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("11112222000000000000",11112222000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("936490726837837729197",936490726837837729197m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeInfinityTests(False).Date_DateOnly_write -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.ClearPool(2) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).Truncate(Cascade, RestartIdentity) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Truncate(RestartIdentity) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).Can_read_two_json_documents -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTypeTests(Multiplexing).Read_overflow<Int64>(0L,9.223372036854776E+18d,"decimal") -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.Reject_self_signed_certificate(VerifyCA) -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.SslMode_Require_throws_without_TSC -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1234567844445555.000000000",1234567844445555.000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.Timeout_getting_connector_from_exhausted_pool(True) -  (unexpected)
--- FAIL: Npgsql.Tests.TransactionTests(NonMultiplexing).Bug3686 -  (unexpected)
--- FAIL: Npgsql.Tests.Types.InternalTypeTests(Multiplexing).NpgsqlLogSequenceNumber -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Jan 29, 2024
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ 1d2534b831775dd84edcf7372d38e35ed4903278:

--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).Uuid -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Timestamp_cannot_use_as_DateTimeOffset -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Send_unknown -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.00000001::numeric",0.00000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Datemultirange_as_array_of_NpgsqlRange_of_DateOnly -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(NonMultiplexing,Jsonb).Can_read_two_json_documents -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("-2.4::numeric(10,0)",-2m) -  (unexpected)
--- FAIL: Npgsql.Tests.AuthenticationTests(Multiplexing).Connect_UserNameFromEnvironment_Succeeds -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).TwoPhase(True) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_without_getter_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("-1.4::numeric(10,0)",-1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(Multiplexing).Write_as_FileStream -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Bug4633 -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- PASS: Npgsql.Tests.ReaderNewSchemaTests(Sync).IsAutoIncrement - unknown (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(NonMultiplexing).Inet_v4_as_tuple -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Write_as_string_validation -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.TimeTz_as_DateTimeOffset -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(Multiplexing).DbType_causes_inference -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("+79228162514264337593543950335::numeric",decimal.MaxValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_with_more_properties_than_attributes -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).Update_for_full_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).Inet_v4_as_NpgsqlInet -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_struct_with_property -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).Update_for_default_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0::numeric",0m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NetworkTypeTests(Multiplexing).Inet_v6_as_IPAddress -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Read_type_without_getter -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1.2::numeric(10,3)",1.200m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_char_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeInfinityTests(False).Date_DateTime_read -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Bind_int_then_array_of_int -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("1E+0::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("11112222000000000000",11112222000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1234567844445555.000000000",1234567844445555.000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_more_properties_than_attributes -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read_BigInteger("-2.5::numeric(10,0)",-3m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.00000000000000000001::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Mixed_element_types -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+0::numeric",1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.CompositeHandlerTests.Write_type_with_less_properties_than_attributes_throws -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_poco_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("11.222233334444555566667777888::numeric",11.222233334444555566667777888m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("-1.5::numeric(10,0)",-2m) -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.npgsql failed with artifacts on master @ ed3a25e3c9459cede2f80babbfc9d44a836b6c12:

--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,DefaultTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+4::numeric",10000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V1,BinaryReplicationDataMode,DefaultTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("0.000000000000000000000001::numeric",0.000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ArrayTests(NonMultiplexing).Long_one_dimensional -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Truncate_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1E+24::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.BitStringTests(NonMultiplexing).Array_of_single_bits -  (unexpected)
--- FAIL: Npgsql.Tests.AuthenticationTests(Multiplexing).Password_source_precedence -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_Memory -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).CompositeType -  (unexpected)
--- FAIL: Npgsql.Tests.Types.MiscTypeTests(NonMultiplexing).Uuid -  (unexpected)
--- FAIL: Npgsql.Tests.ConnectionTests(Multiplexing).Connector_not_initialized_exception -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("1000000000000::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_FileStream_long -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("2.4::numeric(10,0)",2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_char_array -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("1E+12::numeric",1000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("0.0000000000000000000000000001::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write_BigInteger("0::numeric",0m) -  (unexpected)
--- FAIL: Npgsql.Tests.SecurityTests.DataSource_UserCertificateValidationCallback_is_invoked(True) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Json).As_string_with_GetTextReader -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E+24::numeric",1000000000000000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_MemoryStream_truncated -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write_BigInteger("2::numeric(10,2)",2.00m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("-79228162514264337593543950335::numeric",decimal.MinValue) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read_BigInteger("-1.4::numeric(10,0)",-1m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1E-28::numeric",0.0000000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("0.00000000000000000001::numeric",0.00000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.PoolTests.MinPoolSize_equals_MaxPoolSize -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Read("1.2::numeric(10,2)",1.20m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.DateTimeTests.Date_as_DateTime -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_string_long -  (unexpected)
--- PASS: Npgsql.Tests.ReaderOldSchemaTests(Async).IsAutoIncrement - unknown (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V2,DefaultReplicationDataMode,StreamingTransactionMode).Update_for_index_replica_identity -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("11112222000000000000",11112222000000000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.ByteaTests(NonMultiplexing).Write_as_ReadOnlyMemory -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Write("9364907268378377291970000",9364907268378377291970000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Text_as_array_of_chars -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1E-24::numeric",0.000000000000000000000001m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("100000000::numeric",100000000m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(Multiplexing).Read("1.2::numeric(10,1)",1.2m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.NumericTests(NonMultiplexing).Write("1111.2222333344445555666677778::numeric",1111.2222333344445555666677778m) -  (unexpected)
--- FAIL: Npgsql.Tests.Types.TextTests(Multiplexing).Text_as_ArraySegment_of_chars -  (unexpected)
--- FAIL: Npgsql.Tests.Types.JsonTests(Multiplexing,Jsonb).As_JsonDocument -  (unexpected)
--- FAIL: Npgsql.Tests.Types.InternalTypeTests(NonMultiplexing).NpgsqlLogSequenceNumber -  (unexpected)
--- FAIL: Npgsql.Tests.Replication.PgOutputReplicationTests(V3,DefaultReplicationDataMode,StreamingTransactionMode).Update_for_index_replica_identity -  (unexpected)
For a full summary look at the npgsql artifacts 
An updated blocklist (npgsqlBlocklist) is available in the artifacts' npgsql log
test artifacts and logs in: /artifacts/npgsql/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!

@craig craig bot closed this as completed in 51f09ee Jan 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yuzefovich yuzefovich

Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. P-1 Issues/test failures with a fix SLA of 1 month T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
24.1
Development

Successfully merging a pull request may close this issue.

sql: prevent connection closure with nested arrays and binary format yuzefovich/cockroach
5 participants
@rafiss @yuzefovich @cockroach-teamcity @michae2 @renatolabs