Skip to content

sql/pgwire: TestConn failed #46252

@cockroach-teamcity

Description

@cockroach-teamcity

(sql/pgwire).TestConn failed on master@afd27c255065909f357f37f7c38309592e5b0da6:

I200318 14:26:20.327552 1297 sql/pgwire/conn_test.go:636  pgx log [info] Dialing PostgreSQL server - map[address:127.0.0.1:42447 network:tcp]
I200318 14:26:20.328301 1297 sql/pgwire/conn_test.go:636  pgx log [info] connection established - map[]
I200318 14:26:20.338485 31 sql/pgwire/conn_test.go:219  executed query: SELECT t.oid, CASE WHEN nsp.nspname IN ('pg_catalog', 'public') THEN t.typname ELSE (nsp.nspname || '.') || t.typname END FROM pg_type AS t LEFT JOIN pg_type AS base_type ON t.typelem = base_type.oid LEFT JOIN pg_class AS base_cls ON base_type.typrelid = base_cls.oid LEFT JOIN pg_namespace AS nsp ON t.typnamespace = nsp.oid WHERE ((t.typtype IN ('b', 'p', 'r', 'e')) AND ((base_type.oid IS NULL) OR (base_type.typtype IN ('b', 'p', 'r'))))
I200318 14:26:20.338744 31 sql/pgwire/conn_test.go:200  advancing Sync
I200318 14:26:20.339089 1297 sql/pgwire/conn_test.go:636  pgx log [info] Query - map[args:[] rowCount:%!s(int=70) sql:select t.oid,
	case when nsp.nspname in ('pg_catalog', 'public') then t.typname
		else nsp.nspname||'.'||t.typname
	end
from pg_type t
left join pg_type base_type on t.typelem=base_type.oid
left join pg_class base_cls ON base_type.typrelid = base_cls.oid
left join pg_namespace nsp on t.typnamespace=nsp.oid
where (
	  t.typtype in('b', 'p', 'r', 'e')
	  and (base_type.oid is null or base_type.typtype in('b', 'p', 'r'))
	) time:10.717886ms]
I200318 14:26:20.343557 31 sql/pgwire/conn_test.go:219  executed query: SELECT t.oid, t.typname FROM pg_type AS t JOIN pg_type AS base_type ON t.typelem = base_type.oid WHERE (t.typtype = 'b') AND (base_type.typtype = 'e')
I200318 14:26:20.343637 31 sql/pgwire/conn_test.go:200  advancing Sync
I200318 14:26:20.343803 1297 sql/pgwire/conn_test.go:636  pgx log [info] Query - map[args:[] rowCount:%!s(int=1) sql:select t.oid, t.typname
from pg_type t
  join pg_type base_type on t.typelem=base_type.oid
where t.typtype = 'b'
  and base_type.typtype = 'e' time:4.315878ms]
I200318 14:26:20.347735 31 sql/pgwire/conn_test.go:219  executed query: SELECT t.oid, t.typname, t.typbasetype FROM pg_type AS t JOIN pg_type AS base_type ON t.typbasetype = base_type.oid WHERE (t.typtype = 'd') AND (base_type.typtype = 'b')
I200318 14:26:20.347905 31 sql/pgwire/conn_test.go:200  advancing Sync
I200318 14:26:20.348102 1297 sql/pgwire/conn_test.go:636  pgx log [info] Query - map[args:[] rowCount:%!s(int=1) sql:select t.oid, t.typname, t.typbasetype
from pg_type t
  join pg_type base_type on t.typbasetype=base_type.oid
where t.typtype = 'd'
  and base_type.typtype = 'b' time:4.148565ms]
I200318 14:26:20.353415 31 sql/pgwire/conn_test.go:219  executed query: SELECT t.oid, t.typname FROM pg_type AS t JOIN pg_class AS cls ON t.typrelid = cls.oid WHERE (t.typtype = 'c') AND (cls.relkind = 'c')
I200318 14:26:20.353759 31 sql/pgwire/conn_test.go:200  advancing Sync
I200318 14:26:20.353703 1297 sql/pgwire/conn_test.go:636  pgx log [info] Query - map[args:[] rowCount:%!s(int=1) sql:select t.oid, t.typname
from pg_type t
	join pg_class cls on t.typrelid=cls.oid
where t.typtype = 'c'
	and cls.relkind='c' time:5.387743ms]
I200318 14:26:20.354072 31 sql/pgwire/conn_test.go:212  stop wait at query: SELECT 1
I200318 14:26:20.354215 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:select 1 time:219.943µs]
I200318 14:26:20.354378 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:select 2 time:91.328µs]
I200318 14:26:20.354625 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:p1 time:50.332µs]
I200318 14:26:20.354807 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:select 4; select 5; select 6; time:109.818µs]
I200318 14:26:20.355168 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:select 9 time:37.887µs]
I200318 14:26:20.355685 1297 sql/pgwire/conn_test.go:636  pgx log [info] Exec - map[args:[] commandTag: sql:bogus statement failing to parse time:435.618µs]
I200318 14:26:21.511716 116 gossip/gossip.go:1527  [n1] node has connected to cluster via gossip
I200318 14:26:21.511897 116 kv/kvserver/stores.go:266  [n1] wrote 0 node addresses to persistent storage
I200318 14:26:25.356363 1297 sql/pgwire/conn_test.go:636  pgx log [info] closed connection - map[]
I200318 14:26:25.356830 31 util/stop/stopper.go:539  quiescing
--- FAIL: TestConn (5.70s)
    conn_test.go:183: read tcp 127.0.0.1:50314->127.0.0.1:42447: i/o timeout

More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestConn PKG=./pkg/sql/pgwire TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-pgwirepgwire protocol issues.C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.branch-masterFailures and bugs on the master branch.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions