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.

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

compose: TestComposeCompare failed #62602

Closed
cockroach-teamcity opened this issue Mar 25, 2021 · 88 comments
Closed

compose: TestComposeCompare failed #62602

cockroach-teamcity opened this issue Mar 25, 2021 · 88 comments
Assignees
Labels
C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@cockroach-teamcity
Copy link
Member

(compose).TestComposeCompare failed on release-21.1@fda12278d44cb229e9715e4eb0a597219843b85c:

        postgres_1    | You can change this by editing pg_hba.conf or using the option -A, or
        postgres_1    | --auth-local and --auth-host, the next time you run initdb.
        postgres_1    | waiting for server to start....2021-03-25 14:19:49.639 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-25 14:19:49.658 UTC [49] LOG:  database system was shut down at 2021-03-25 14:19:49 UTC
        postgres_1    | 2021-03-25 14:19:49.663 UTC [48] LOG:  database system is ready to accept connections
        postgres_1    |  done
        postgres_1    | server started
        postgres_1    | 
        postgres_1    | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
        postgres_1    | CREATE DATABASE
        postgres_1    | Loading PostGIS extensions into template_postgis
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down....2021-03-25 14:19:52.654 UTC [48] LOG:  received fast shutdown request
        postgres_1    | 2021-03-25 14:19:52.657 UTC [48] LOG:  aborting any active transactions
        postgres_1    | 2021-03-25 14:19:52.659 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
        postgres_1    | 2021-03-25 14:19:52.665 UTC [50] LOG:  shutting down
        postgres_1    | 2021-03-25 14:19:52.782 UTC [48] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2021-03-25 14:19:52.868 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2021-03-25 14:19:52.868 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2021-03-25 14:19:52.872 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-25 14:19:52.888 UTC [85] LOG:  database system was shut down at 2021-03-25 14:19:52 UTC
        postgres_1    | 2021-03-25 14:19:52.895 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (601.79s)
        test_1        |     --- FAIL: TestCompare/postgres (1.00s)
        test_1        |         compare_test.go:119: pgx conn: dial tcp 172.18.0.2:5432: connect: connection refused
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity cockroach-teamcity added branch-release-21.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Mar 25, 2021
@rafiss rafiss assigned rafiss and unassigned tbg Mar 25, 2021
@rafiss
Copy link
Collaborator

rafiss commented Mar 25, 2021

It's failing because it can't connect to the Postgres server.

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@f602e37e31a256980ae897917f45cba9c135b412:

        postgres_1    | You can change this by editing pg_hba.conf or using the option -A, or
        postgres_1    | --auth-local and --auth-host, the next time you run initdb.
        postgres_1    | waiting for server to start....2021-03-26 05:13:46.641 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-26 05:13:46.657 UTC [49] LOG:  database system was shut down at 2021-03-26 05:13:46 UTC
        postgres_1    | 2021-03-26 05:13:46.662 UTC [48] LOG:  database system is ready to accept connections
        postgres_1    |  done
        postgres_1    | server started
        postgres_1    | 
        postgres_1    | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
        postgres_1    | CREATE DATABASE
        postgres_1    | Loading PostGIS extensions into template_postgis
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2021-03-26 05:13:49.491 UTC [48] LOG:  received fast shutdown request
        postgres_1    | .2021-03-26 05:13:49.493 UTC [48] LOG:  aborting any active transactions
        postgres_1    | 2021-03-26 05:13:49.495 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
        postgres_1    | 2021-03-26 05:13:49.503 UTC [50] LOG:  shutting down
        postgres_1    | 2021-03-26 05:13:49.619 UTC [48] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2021-03-26 05:13:49.703 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2021-03-26 05:13:49.703 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2021-03-26 05:13:49.707 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-26 05:13:49.723 UTC [85] LOG:  database system was shut down at 2021-03-26 05:13:49 UTC
        postgres_1    | 2021-03-26 05:13:49.729 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (601.95s)
        test_1        |     --- FAIL: TestCompare/postgres (1.12s)
        test_1        |         compare_test.go:119: pgx conn: dial tcp 172.18.0.4:5432: connect: connection refused
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@rafiss
Copy link
Collaborator

rafiss commented Mar 26, 2021

#62682 should fix the not able to connect to postgres problem

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@9caf4f8d29ed00aa01188a081465d9061c5fea64:

        postgres_1    |     pg_ctl -D /var/lib/postgresql/data -l logfile start
        postgres_1    | 
        postgres_1    | waiting for server to start....2021-03-27 05:11:28.976 UTC [52] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-27 05:11:28.993 UTC [53] LOG:  database system was shut down at 2021-03-27 05:11:28 UTC
        postgres_1    | 2021-03-27 05:11:28.998 UTC [52] LOG:  database system is ready to accept connections
        postgres_1    |  done
        postgres_1    | server started
        postgres_1    | 
        postgres_1    | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
        postgres_1    | CREATE DATABASE
        postgres_1    | Loading PostGIS extensions into template_postgis
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down....2021-03-27 05:11:31.878 UTC [52] LOG:  received fast shutdown request
        postgres_1    | 2021-03-27 05:11:31.880 UTC [52] LOG:  aborting any active transactions
        postgres_1    | 2021-03-27 05:11:31.882 UTC [52] LOG:  background worker "logical replication launcher" (PID 59) exited with exit code 1
        postgres_1    | 2021-03-27 05:11:31.889 UTC [54] LOG:  shutting down
        postgres_1    | 2021-03-27 05:11:32.006 UTC [52] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2021-03-27 05:11:32.090 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2021-03-27 05:11:32.090 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2021-03-27 05:11:32.093 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-27 05:11:32.109 UTC [89] LOG:  database system was shut down at 2021-03-27 05:11:31 UTC
        postgres_1    | 2021-03-27 05:11:32.116 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (604.10s)
        test_1        |     --- FAIL: TestCompare/postgres (2.41s)
        test_1        |         compare_test.go:119: pgx conn: dial tcp 172.18.0.3:5432: connect: connection refused
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@b886d8089334416b026391f2be76bc32e3a09b8a:

        postgres_1    | You can change this by editing pg_hba.conf or using the option -A, or
        postgres_1    | --auth-local and --auth-host, the next time you run initdb.
        postgres_1    | waiting for server to start....2021-03-30 05:11:38.360 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-30 05:11:38.380 UTC [49] LOG:  database system was shut down at 2021-03-30 05:11:38 UTC
        postgres_1    | 2021-03-30 05:11:38.386 UTC [48] LOG:  database system is ready to accept connections
        postgres_1    |  done
        postgres_1    | server started
        postgres_1    | 
        postgres_1    | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
        postgres_1    | CREATE DATABASE
        postgres_1    | Loading PostGIS extensions into template_postgis
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2021-03-30 05:11:41.456 UTC [48] LOG:  received fast shutdown request
        postgres_1    | .2021-03-30 05:11:41.459 UTC [48] LOG:  aborting any active transactions
        postgres_1    | 2021-03-30 05:11:41.461 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
        postgres_1    | 2021-03-30 05:11:41.468 UTC [50] LOG:  shutting down
        postgres_1    | 2021-03-30 05:11:41.598 UTC [48] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2021-03-30 05:11:41.670 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2021-03-30 05:11:41.670 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2021-03-30 05:11:41.676 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-03-30 05:11:41.694 UTC [85] LOG:  database system was shut down at 2021-03-30 05:11:41 UTC
        postgres_1    | 2021-03-30 05:11:41.701 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (602.13s)
        test_1        |     --- FAIL: TestCompare/postgres (0.45s)
        test_1        |         compare_test.go:119: pgx conn: dial tcp 172.18.0.4:5432: connect: connection refused
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@e6d07fa0b8fb13c447805709e2eadcceb783d661:

        postgres_1    | 	CREATE INDEX ON table2 (col2_7 ASC, col2_4 ASC, col2_6 DESC, col2_0 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_0 ASC, col2_7 ASC, col2_8 ASC, col2_6 DESC, col2_3 DESC, col2_1 ASC, col2_5, col2_2);
        postgres_1    | 	CREATE TABLE table3 (col3_0 INTERVAL NOT NULL, PRIMARY KEY (col3_0));
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0);
        postgres_1    | 	CREATE INDEX ON table3 (col3_0 ASC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0 ASC);
        postgres_1    | 	CREATE INDEX ON table3 (col3_0 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        postgres_1    | 	CREATE TYPE rand_typ_0 AS ENUM ('go');
        postgres_1    | 	CREATE TYPE rand_typ_1 AS ENUM ('rf');
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (603.61s)
        test_1        |     --- FAIL: TestCompare/postgres (2.81s)
        test_1        |         compare_test.go:129: CREATE TABLE table1 (col1_0 BYTEA NULL, col1_1 "char", col1_2 REGNAMESPACE, col1_3 TEXT NULL, col1_4 UUID NULL, col1_5 INT8 NULL, col1_6 REGNAMESPACE, col1_7 TIMESTAMPTZ NOT NULL, col1_8 VARCHAR NOT NULL, col1_9 INT8, col1_10 TEXT GENERATED ALWAYS AS (lower(CAST(col1_6 AS TEXT))) STORED, col1_11 INT8 NULL GENERATED ALWAYS AS (col1_9 + (-2517)::INT8) STORED);
        test_1        |             ALTER TABLE table1 ALTER COLUMN col1_3 SET DATA TYPE TEXT;
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_1 ASC, col1_9, col1_0 ASC, col1_10 DESC, col1_4, col1_6, col1_11 DESC);
        test_1        |             CREATE INDEX ON table1 (col1_2 DESC, col1_1 DESC, col1_11 DESC) INCLUDE (col1_3, col1_4, col1_6, col1_7, col1_9);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_11 ASC, col1_2) INCLUDE (col1_1, col1_5, col1_6, col1_7, col1_8);
        test_1        |             CREATE INDEX ON table1 (col1_7, col1_6 ASC, col1_1, col1_4, col1_10 DESC);
        test_1        |             CREATE TABLE table2 (col2_0 INT8 NOT NULL, col2_1 TEXT NOT NULL, col2_2 INET NOT NULL, col2_3 TIMESTAMPTZ NOT NULL, col2_4 TIME NOT NULL, col2_5 INT8 NOT NULL, col2_6 BIT(30) NOT NULL, PRIMARY KEY (col2_1, col2_4, col2_3, col2_6, col2_0, col2_5, col2_2), col2_7 INT8 NULL GENERATED ALWAYS AS (col2_5 + col2_0) STORED, col2_8 INT8 NULL GENERATED ALWAYS AS (col2_0 + col2_5) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_7, col2_2 ASC, col2_6 ASC, col2_4 DESC, col2_1);
        test_1        |             CREATE INDEX ON table2 (col2_7 ASC, col2_4 ASC, col2_6 DESC, col2_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_0 ASC, col2_7 ASC, col2_8 ASC, col2_6 DESC, col2_3 DESC, col2_1 ASC, col2_5, col2_2);
        test_1        |             CREATE TABLE table3 (col3_0 INTERVAL NOT NULL, PRIMARY KEY (col3_0));
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0);
        test_1        |             CREATE INDEX ON table3 (col3_0 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0 ASC);
        test_1        |             CREATE INDEX ON table3 (col3_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
        test_1        |             CREATE TYPE rand_typ_0 AS ENUM ('go');
        test_1        |             CREATE TYPE rand_typ_1 AS ENUM ('rf');
        test_1        |             
        test_1        |         compare_test.go:130: postgres: exec: ERROR: syntax error at or near "(" (SQLSTATE 42601)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@rafiss
Copy link
Collaborator

rafiss commented Mar 31, 2021

i am stacking up a bunch of commits in #62706 to fix more problems as i find them. as noted in #56845 (comment) the tests were abandoned for a while so a lot of stuff decayed.

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@b36764ee67d1c6126cb763a58524a2045dab76af:

        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_4 DESC, col2_2) INCLUDE (col2_0);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_2);
        postgres_1    | 	CREATE INDEX ON table2 (col2_2 DESC, col2_0 DESC, col2_3 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_3, col2_2 DESC, col2_4 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_2);
        postgres_1    | 	ALTER TABLE table1 ADD FOREIGN KEY (col1_8) REFERENCES table2 (col2_2) ON UPDATE RESTRICT;
        postgres_1    | 	CREATE TYPE rand_typ_0 AS ENUM ('zow', 'ghhk', 'g');
        postgres_1    | 	CREATE TYPE rand_typ_1 AS ENUM ('rd', 'oypvsg');
        postgres_1    | 	CREATE TYPE rand_typ_2 AS ENUM ('wlhni', 'lbw', 'dgpc', 'xbb');
        postgres_1    | 	CREATE TYPE rand_typ_3 AS ENUM ('gkvmn', 'vgkp', 'iygdax', 'ie', 'sjnqbm', 'ml');
        postgres_1    | 	CREATE TYPE rand_typ_4 AS ENUM ('fp', 'jpe', 'xu', 'fbg');
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (603.31s)
        test_1        |     --- FAIL: TestCompare/postgres (2.25s)
        test_1        |         compare_test.go:129: CREATE TABLE table1 (col1_0 REGCLASS NULL, col1_1 TEXT, col1_2 INET[] NULL, col1_3 TIMETZ, col1_4 BYTEA, col1_5 "char" NULL, col1_6 INTERVAL, col1_7 INT8 NULL, col1_8 TEXT NULL, col1_9 INT8 NOT NULL, col1_10 INT8 NOT NULL GENERATED ALWAYS AS (col1_7 + 6673::INT8) STORED);
        test_1        |             ALTER TABLE table1 ALTER COLUMN col1_8 SET DATA TYPE TEXT;
        test_1        |             CREATE INDEX ON table1 (col1_8, col1_3) INCLUDE (col1_1, col1_4, col1_5, col1_6, col1_9, col1_10);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_10 DESC) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_5, col1_7, col1_9);
        test_1        |             CREATE INDEX ON table1 (col1_7, col1_6 DESC, col1_10 ASC, col1_1 ASC) INCLUDE (col1_0, col1_2, col1_4, col1_8, col1_9);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_0 DESC, col1_6, col1_9, col1_5 DESC, col1_10, col1_1) INCLUDE (col1_2, col1_4, col1_7);
        test_1        |             CREATE TABLE table2 (col2_0 OID, col2_1 FLOAT8, col2_2 TEXT NULL, col2_3 INT8 NOT NULL, col2_4 BOOL NOT NULL, PRIMARY KEY (col2_3));
        test_1        |             ALTER TABLE table2 ALTER COLUMN col2_2 SET DATA TYPE TEXT;
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_1 DESC, col2_0 DESC, col2_3 ASC);
        test_1        |             CREATE INDEX ON table2 (col2_1 ASC, col2_4);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_4 ASC, col2_1 DESC);
        test_1        |             CREATE INDEX ON table2 (col2_1 DESC, col2_4 DESC, col2_0 DESC, col2_3 ASC) INCLUDE (col2_2);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_4 DESC, col2_2) INCLUDE (col2_0);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_2);
        test_1        |             CREATE INDEX ON table2 (col2_2 DESC, col2_0 DESC, col2_3 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3, col2_2 DESC, col2_4 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_2);
        test_1        |             ALTER TABLE table1 ADD FOREIGN KEY (col1_8) REFERENCES table2 (col2_2) ON UPDATE RESTRICT;
        test_1        |             CREATE TYPE rand_typ_0 AS ENUM ('zow', 'ghhk', 'g');
        test_1        |             CREATE TYPE rand_typ_1 AS ENUM ('rd', 'oypvsg');
        test_1        |             CREATE TYPE rand_typ_2 AS ENUM ('wlhni', 'lbw', 'dgpc', 'xbb');
        test_1        |             CREATE TYPE rand_typ_3 AS ENUM ('gkvmn', 'vgkp', 'iygdax', 'ie', 'sjnqbm', 'ml');
        test_1        |             CREATE TYPE rand_typ_4 AS ENUM ('fp', 'jpe', 'xu', 'fbg');
        test_1        |             
        test_1        |         compare_test.go:130: postgres: exec: ERROR: syntax error at or near "(" (SQLSTATE 42601)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@eaa839f1da532d5b0076e1d32d202b9f620008cd:

        postgres_1    | 2021-04-02 05:24:54.338 UTC [112] ERROR:  column tab_44787.crdb_internal_mvcc_timestamp does not exist at character 64
        postgres_1    | 2021-04-02 05:24:54.338 UTC [112] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(
        postgres_1    | 			SELECT
        postgres_1    | 				tab_44787.tableoid AS col_48863, tab_44787.crdb_internal_mvcc_timestamp AS col_48864
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table1 AS tab_44787
        postgres_1    | 			ORDER BY
        postgres_1    | 				tab_44787.col1_0 DESC
        postgres_1    | 		)
        postgres_1    | 			AS tab_44788
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_48863 NULLS FIRST, col_48864 NULLS FIRST
        test_1        | --- FAIL: TestCompare (644.95s)
        test_1        |     --- FAIL: TestCompare/postgres (44.07s)
        test_1        |         compare_test.go:155: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("C2000-01-01 08:00:00"),
        test_1        |             + 	string("C2000-01-01 08:00:00+00"),
        test_1        |               	string("C"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			('C'::TEXT::TEXT || '2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT AS col_48870,
        test_1        |             			'C'::TEXT AS col_48871
        test_1        |             	)
        test_1        |             		AS tab_44796
        test_1        |             ORDER BY
        test_1        |             	col_48870 NULLS FIRST, col_48871 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1: [same as previous]
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@ac051fa1830f485b89c78989182704e0e594de17:

        postgres_1    | You can change this by editing pg_hba.conf or using the option -A, or
        postgres_1    | --auth-local and --auth-host, the next time you run initdb.
        postgres_1    | waiting for server to start....2021-04-03 05:14:07.031 UTC [52] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-04-03 05:14:07.047 UTC [53] LOG:  database system was shut down at 2021-04-03 05:14:06 UTC
        postgres_1    | 2021-04-03 05:14:07.052 UTC [52] LOG:  database system is ready to accept connections
        postgres_1    |  done
        postgres_1    | server started
        postgres_1    | 
        postgres_1    | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
        postgres_1    | CREATE DATABASE
        postgres_1    | Loading PostGIS extensions into template_postgis
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down....2021-04-03 05:14:09.914 UTC [52] LOG:  received fast shutdown request
        postgres_1    | 2021-04-03 05:14:09.916 UTC [52] LOG:  aborting any active transactions
        postgres_1    | 2021-04-03 05:14:09.918 UTC [52] LOG:  background worker "logical replication launcher" (PID 59) exited with exit code 1
        postgres_1    | 2021-04-03 05:14:09.926 UTC [54] LOG:  shutting down
        postgres_1    | 2021-04-03 05:14:10.039 UTC [52] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2021-04-03 05:14:10.125 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2021-04-03 05:14:10.125 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2021-04-03 05:14:10.129 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-04-03 05:14:10.145 UTC [89] LOG:  database system was shut down at 2021-04-03 05:14:10 UTC
        postgres_1    | 2021-04-03 05:14:10.150 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (604.48s)
        test_1        |     --- FAIL: TestCompare/postgres (3.12s)
        test_1        |         compare_test.go:119: pgx conn: dial tcp 172.18.0.3:5432: connect: connection refused
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@3fa241dd0d3aba2547e04ec5ef936315c0c5d3e1:

        postgres_1    | 				1::OID AS col_66313,
        postgres_1    | 				NULL AS col_66314,
        postgres_1    | 				tab_34122.col1_0 AS col_66315,
        postgres_1    | 				8::OID AS col_66316
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table1 AS tab_34122
        postgres_1    | 			WHERE
        postgres_1    | 				(st_mlinefromwkb('\x4a'::BYTEA::BYTEA)::GEOMETRY <= st_mlinefromwkb('\x43'::BYTEA::BYTEA)::GEOMETRY)
        postgres_1    | 		)
        postgres_1    | 			AS tab_34123
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_66309 NULLS FIRST,
        postgres_1    | 		col_66310 NULLS FIRST,
        postgres_1    | 		col_66311 NULLS FIRST,
        postgres_1    | 		col_66312 NULLS FIRST,
        postgres_1    | 		col_66313 NULLS FIRST,
        postgres_1    | 		col_66314 NULLS FIRST,
        postgres_1    | 		col_66315 NULLS FIRST,
        postgres_1    | 		col_66316 NULLS FIRST
        test_1        | --- FAIL: TestCompare (641.11s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (36.43s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("4.9.3"),
        test_1        |             + 	string("Rel. 5.2.0, September 15th, 2018"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT * FROM (SELECT postgis_proj_version()::STRING AS col_66331) AS tab_34130 ORDER BY col_66331 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT * FROM (SELECT postgis_proj_version()::TEXT AS col_66331) AS tab_34130 ORDER BY col_66331 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@f6904d0734d08d05ba929e8b542646981c0844d9:

        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_44844.col2_9 AS col_72639
        test_1        |             		FROM
        test_1        |             			postgres.public.table2@table2_col2_0_idx AS tab_44844
        test_1        |             			JOIN postgres.public.table1 AS tab_44845
        test_1        |             				JOIN postgres.public.table1 AS tab_44846 ON (tab_44845.col1_6) = (tab_44846.col1_6) ON
        test_1        |             					(tab_44844.col2_0) = (tab_44846.col1_6)
        test_1        |             			JOIN postgres.public.table4 AS tab_44847
        test_1        |             				JOIN postgres.public.table4 AS tab_44848 ON (tab_44847.col4_6) = (tab_44848.col4_6) ON false
        test_1        |             			JOIN postgres.public.table1@[0] AS tab_44849
        test_1        |             				JOIN postgres.public.table3@[0] AS tab_44850
        test_1        |             					JOIN postgres.public.table1@table1_col1_1_col1_3_idx AS tab_44855
        test_1        |             						JOIN postgres.public.table3@primary AS tab_44856 ON
        test_1        |             								(tab_44855.col1_5) = (tab_44856.col3_15)
        test_1        |             								AND (tab_44855.col1_3) = (tab_44856.col3_9)
        test_1        |             								AND (tab_44855.col1_1) = (tab_44856.col3_1) ON
        test_1        |             							(tab_44850.col3_13) = (tab_44856.col3_2) AND (tab_44850.col3_5) = (tab_44856.col3_5)
        test_1        |             					JOIN postgres.public.table1@[0] AS tab_44857 ON (tab_44856.col3_13) = (tab_44857.col1_5)
        test_1        |             					JOIN postgres.public.table1@[0] AS tab_44858 ON
        test_1        |             							(tab_44857.tableoid) = (tab_44858.tableoid)
        test_1        |             							AND (tab_44855.crdb_internal_mvcc_timestamp) = (tab_44858.crdb_internal_mvcc_timestamp)
        test_1        |             							AND (tab_44850.tableoid) = (tab_44858.tableoid) ON
        test_1        |             						(tab_44849.col1_6) = (tab_44855.col1_6) AND (tab_44849.col1_1) = (tab_44858.col1_1) ON
        test_1        |             					(tab_44846.col1_6) = (tab_44857.col1_6)
        test_1        |             					AND (tab_44844.col2_6) = (tab_44850.col3_11)
        test_1        |             					AND (tab_44844.col2_0) = (tab_44849.col1_6)
        test_1        |             					AND (tab_44844.col2_6) = (tab_44850.col3_14)
        test_1        |             					AND (tab_44844.col2_0) = (tab_44855.col1_4)
        test_1        |             					AND (tab_44845.col1_6) = (tab_44858.col1_4)
        test_1        |             		WHERE
        test_1        |             			(tab_44855.col1_3 AND true)
        test_1        |             	)
        test_1        |             		AS tab_44859
        test_1        |             ORDER BY
        test_1        |             	col_72639 NULLS FIRST
        test_1        |         compare_test.go:183: cockroach2: ping: context deadline exceeded
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@389cbd4be0e9ce22ca7789cd61802f1f90392c97:

        test_1        |             	col_288199 NULLS FIRST,
        test_1        |             	col_288200 NULLS FIRST
        test_1        |         compare_test.go:183: cockroach1: ping: context deadline exceeded
        test_1        |     --- FAIL: TestCompare/postgres (187.67s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("H2000-01-01 09:00:09+00"),
        test_1        |             + 	string("H2000-01-01 09:00:09+00:00"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			('H'::TEXT::TEXT || (CASE WHEN false THEN '00:00:00'::INTERVAL ELSE '00:00:09'::INTERVAL END::INTERVAL + '2000-01-01 09:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT
        test_1        |             				AS col_19755
        test_1        |             	)
        test_1        |             		AS tab_11618
        test_1        |             ORDER BY
        test_1        |             	col_19755 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			('H':::STRING::STRING || (CASE WHEN false THEN '00:00:00':::INTERVAL ELSE '00:00:09':::INTERVAL END::INTERVAL + '2000-01-01 09:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::TIMESTAMPTZ::TIMESTAMPTZ)::STRING
        test_1        |             				AS col_19755
        test_1        |             	)
        test_1        |             		AS tab_11618
        test_1        |             ORDER BY
        test_1        |             	col_19755 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@80709778b7c7de7b2b704972197022305bb3ca12:

        postgres_1    | 	CREATE UNIQUE INDEX ON table1 (col1_17, col1_2, col1_8) INCLUDE (col1_1, col1_6, col1_7, col1_9, col1_13, col1_14, col1_15, col1_16);
        postgres_1    | 	CREATE INDEX ON table1 (col1_17 ASC, col1_1, col1_12 DESC, col1_8, col1_2 DESC, col1_10 DESC, col1_0, col1_6, col1_14, col1_13 ASC, col1_16 DESC, col1_7 ASC, col1_5 DESC, col1_3 ASC);
        postgres_1    | 	CREATE INDEX ON table1 (col1_10 DESC, col1_0, col1_17 ASC, col1_13 ASC, col1_11, col1_16 ASC, col1_15, col1_5 DESC, col1_3, col1_2 DESC);
        postgres_1    | 	CREATE INDEX ON table1 (col1_5 DESC, col1_13 DESC, col1_14 ASC, col1_2 ASC, col1_11, col1_12 ASC, col1_6 ASC, col1_3, col1_8 DESC, col1_15 ASC, col1_1 ASC) INCLUDE (col1_17);
        postgres_1    | 	CREATE TABLE table2 (col2_0 FLOAT8 NOT NULL, col2_1 DECIMAL NULL, col2_2 TEXT, col2_3 UUID NULL, col2_4 DECIMAL, col2_5 INT8, col2_6 INET NOT NULL, col2_7 FLOAT8 NULL, col2_8 JSONB NULL, col2_9 FLOAT8, col2_10 INT8 NOT NULL, col2_11 DECIMAL NOT NULL, col2_12 TEXT GENERATED ALWAYS AS (lower(CAST(col2_8 AS TEXT))) STORED, col2_13 FLOAT8 NOT NULL GENERATED ALWAYS AS (col2_9 + col2_7) STORED);
        postgres_1    | 	CREATE TABLE table3 (col3_0 OID NULL, col3_1 REGPROCEDURE NULL, col3_2 CHAR NOT NULL, col3_3 INET NOT NULL, col3_4 INT8 NOT NULL, col3_5 INT8 NOT NULL, col3_6 NAME NOT NULL, col3_7 NAME NULL, col3_8 TIMETZ[] NULL, col3_9 BYTEA, PRIMARY KEY (col3_4, col3_2, col3_3), col3_10 INT8 NOT NULL GENERATED ALWAYS AS (col3_5 + 7473::INT8) STORED, col3_11 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_12 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_13 INT8 GENERATED ALWAYS AS (col3_5 + col3_4) STORED, col3_14 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col3_9 IS NULL THEN e'DiQ"r\x02\'\x10j'::TEXT ELSE '3KprTr'::TEXT END) STORED);
        postgres_1    | 	CREATE INDEX ON table3 (col3_2 DESC);
        postgres_1    | 	CREATE UNIQUE INDEX ON table3 (col3_10) INCLUDE (col3_1, col3_5, col3_6, col3_8, col3_15);
        postgres_1    | 	CREATE TABLE table4 (col4_0 NAME, col4_1 INT8, col4_2 UUID NOT NULL, col4_3 GEOGRAPHY NULL, col4_4 INET, col4_5 TIMESTAMPTZ, col4_6 TIME, col4_7 DATE NOT NULL, col4_8 TEXT, col4_9 DECIMAL NULL, PRIMARY KEY (col4_7));
        postgres_1    | 	CREATE UNIQUE INDEX ON table4 (col4_4 DESC) INCLUDE (col4_1, col4_2, col4_5, col4_8, col4_9);
        postgres_1    | 	CREATE TYPE rand_typ_0 AS ENUM ('xan', 'whezqb', 'dalisz', 'rp');
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (607.97s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     --- FAIL: TestCompare/postgres (2.69s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:150: CREATE TABLE table1 (col1_0 INTERVAL NOT NULL, col1_1 FLOAT8 NOT NULL, col1_2 "char", col1_3 TIMESTAMPTZ NULL, col1_4 BOX2D NULL, col1_5 TIMESTAMPTZ NULL, col1_6 OID NULL, col1_7 VARCHAR, col1_8 REGPROC, col1_9 BOX2D NOT NULL, PRIMARY KEY (col1_0), col1_10 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_8 IS NULL THEN 'Y.m43'::TEXT ELSE e'\x0bJrbK3'::TEXT END) STORED, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_9 AS TEXT))) STORED, col1_12 TEXT GENERATED ALWAYS AS (lower(col1_2)) STORED, col1_13 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, col1_14 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_9 AS TEXT))) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_7)) STORED, col1_16 TEXT GENERATED ALWAYS AS (lower(CAST(col1_9 AS TEXT))) STORED, col1_17 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_8 IS NULL THEN e'\U00002603'::TEXT ELSE e'8\x06AE\x06\nK'::TEXT END) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_1, col1_17 ASC, col1_13 ASC) INCLUDE (col1_2, col1_3, col1_5, col1_8, col1_9, col1_14, col1_16);
        test_1        |             CREATE INDEX ON table1 (col1_15 ASC, col1_6 DESC, col1_10 ASC, col1_13 DESC, col1_0, col1_1, col1_2 DESC, col1_11 DESC, col1_16);
        test_1        |             CREATE INDEX ON table1 (col1_1 DESC, col1_5 DESC, col1_13 ASC, col1_15 DESC, col1_6 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_17 DESC, col1_13 DESC) INCLUDE (col1_2, col1_3, col1_5, col1_8, col1_15, col1_16);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_16, col1_10 ASC, col1_8 ASC) INCLUDE (col1_1, col1_2, col1_5, col1_9, col1_13, col1_17);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_17, col1_2, col1_8) INCLUDE (col1_1, col1_6, col1_7, col1_9, col1_13, col1_14, col1_15, col1_16);
        test_1        |             CREATE INDEX ON table1 (col1_17 ASC, col1_1, col1_12 DESC, col1_8, col1_2 DESC, col1_10 DESC, col1_0, col1_6, col1_14, col1_13 ASC, col1_16 DESC, col1_7 ASC, col1_5 DESC, col1_3 ASC);
        test_1        |             CREATE INDEX ON table1 (col1_10 DESC, col1_0, col1_17 ASC, col1_13 ASC, col1_11, col1_16 ASC, col1_15, col1_5 DESC, col1_3, col1_2 DESC);
        test_1        |             CREATE INDEX ON table1 (col1_5 DESC, col1_13 DESC, col1_14 ASC, col1_2 ASC, col1_11, col1_12 ASC, col1_6 ASC, col1_3, col1_8 DESC, col1_15 ASC, col1_1 ASC) INCLUDE (col1_17);
        test_1        |             CREATE TABLE table2 (col2_0 FLOAT8 NOT NULL, col2_1 DECIMAL NULL, col2_2 TEXT, col2_3 UUID NULL, col2_4 DECIMAL, col2_5 INT8, col2_6 INET NOT NULL, col2_7 FLOAT8 NULL, col2_8 JSONB NULL, col2_9 FLOAT8, col2_10 INT8 NOT NULL, col2_11 DECIMAL NOT NULL, col2_12 TEXT GENERATED ALWAYS AS (lower(CAST(col2_8 AS TEXT))) STORED, col2_13 FLOAT8 NOT NULL GENERATED ALWAYS AS (col2_9 + col2_7) STORED);
        test_1        |             CREATE TABLE table3 (col3_0 OID NULL, col3_1 REGPROCEDURE NULL, col3_2 CHAR NOT NULL, col3_3 INET NOT NULL, col3_4 INT8 NOT NULL, col3_5 INT8 NOT NULL, col3_6 NAME NOT NULL, col3_7 NAME NULL, col3_8 TIMETZ[] NULL, col3_9 BYTEA, PRIMARY KEY (col3_4, col3_2, col3_3), col3_10 INT8 NOT NULL GENERATED ALWAYS AS (col3_5 + 7473::INT8) STORED, col3_11 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_12 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_13 INT8 GENERATED ALWAYS AS (col3_5 + col3_4) STORED, col3_14 INT8 NULL GENERATED ALWAYS AS (col3_4 + col3_5) STORED, col3_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col3_9 IS NULL THEN e'DiQ"r\x02\'\x10j'::TEXT ELSE '3KprTr'::TEXT END) STORED);
        test_1        |             CREATE INDEX ON table3 (col3_2 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_10) INCLUDE (col3_1, col3_5, col3_6, col3_8, col3_15);
        test_1        |             CREATE TABLE table4 (col4_0 NAME, col4_1 INT8, col4_2 UUID NOT NULL, col4_3 GEOGRAPHY NULL, col4_4 INET, col4_5 TIMESTAMPTZ, col4_6 TIME, col4_7 DATE NOT NULL, col4_8 TEXT, col4_9 DECIMAL NULL, PRIMARY KEY (col4_7));
        test_1        |             CREATE UNIQUE INDEX ON table4 (col4_4 DESC) INCLUDE (col4_1, col4_2, col4_5, col4_8, col4_9);
        test_1        |             CREATE TYPE rand_typ_0 AS ENUM ('xan', 'whezqb', 'dalisz', 'rp');
        test_1        |             
        test_1        |         compare_test.go:151: postgres: exec: ERROR: conversion between UTF8 and SQL_ASCII is not supported (SQLSTATE 0A000)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@69122e0b458d473d62a7bf3e3b8dbb40162fc005:

        test_1        |             							(tab_72567.col1_1) = (tab_72568.col1_1) AND (tab_72567.col1_2) = (tab_72568.col1_2) ON
        test_1        |             						(tab_72564.col1_2) = (tab_72568.col1_2) AND (tab_72565.col1_2) = (tab_72568.col1_2) ON NULL
        test_1        |             			JOIN postgres.public.table1@[0] AS tab_72569
        test_1        |             				JOIN postgres.public.table1@table1_col1_4_col1_3_col1_0_col1_5_idx AS tab_72570 ON
        test_1        |             						(tab_72569.col1_0) = (tab_72570.col1_0) ON
        test_1        |             					(tab_72566.tableoid) = (tab_72569.col1_3)
        test_1        |             					AND (tab_72563.col1_6) = (tab_72569.col1_6)
        test_1        |             					AND (tab_72563.col1_0) = (tab_72570.crdb_internal_mvcc_timestamp)
        test_1        |             					AND (tab_72565.col1_5) = (tab_72570.col1_5)
        test_1        |             					AND (tab_72565.tableoid) = (tab_72569.tableoid)
        test_1        |             					AND (tab_72565.col1_4) = (tab_72570.col1_4)
        test_1        |             	)
        test_1        |             		AS tab_72571
        test_1        |             ORDER BY
        test_1        |             	col_113927 NULLS FIRST,
        test_1        |             	col_113928 NULLS FIRST,
        test_1        |             	col_113929 NULLS FIRST,
        test_1        |             	col_113930 NULLS FIRST,
        test_1        |             	col_113931 NULLS FIRST,
        test_1        |             	col_113932 NULLS FIRST,
        test_1        |             	col_113933 NULLS FIRST,
        test_1        |             	col_113934 NULLS FIRST,
        test_1        |             	col_113935 NULLS FIRST
        test_1        |         compare_test.go:183: cockroach2: ping: context deadline exceeded
        test_1        |     --- FAIL: TestCompare/postgres (10.21s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:150: CREATE TABLE table1 (col1_0 INT8, col1_1 VARCHAR NOT NULL, col1_2 GEOMETRY, col1_3 BOX2D NULL, col1_4 REGPROC, col1_5 TIMESTAMP NULL, col1_6 NAME NULL, col1_7 TIMESTAMPTZ, col1_8 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN e'\'&\r\x10uJLb'::TEXT ELSE e'Qe9+/\x12>'::TEXT END) STORED, col1_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN e'[\f\x06n\x13|\n'::TEXT ELSE '"'::TEXT END) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_8 DESC, col1_7) INCLUDE (col1_0, col1_1, col1_2, col1_3, col1_5, col1_6);
        test_1        |             CREATE TABLE table2 (col2_0 "char", col2_1 REGTYPE NOT NULL, col2_2 REGCLASS, col2_3 VARCHAR NOT NULL, col2_4 TEXT NOT NULL, col2_5 TEXT, col2_6 BIT(44) NULL, col2_7 UUID NOT NULL, col2_8 GEOGRAPHY NULL, col2_9 INT8, col2_10 TEXT GENERATED ALWAYS AS (CASE WHEN col2_2 IS NULL THEN e'\x17 jKcf'::TEXT ELSE e'/\x16\x17\x1e|<IU'::TEXT END) STORED, col2_11 TEXT GENERATED ALWAYS AS (lower(CAST(col2_7 AS TEXT))) STORED, col2_12 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_1 IS NULL THEN 'C^Y'::TEXT ELSE e'h^\x1dJT\x0b\x1aG{'::TEXT END) STORED, col2_13 INT8 NULL GENERATED ALWAYS AS (col2_9 + (-3870324832362801463)::INT8) STORED);
        test_1        |             CREATE TABLE table3 (col3_0 TIMETZ NULL, col3_1 REGNAMESPACE NOT NULL, col3_2 TIMETZ NOT NULL, col3_3 FLOAT8 NULL, col3_4 FLOAT8 NOT NULL, col3_5 INT8, col3_6 UUID NULL, col3_7 DATE, col3_8 BOX2D NOT NULL, col3_9 BYTEA NOT NULL, col3_10 BIT(19), col3_11 JSONB NULL, col3_12 FLOAT8 NOT NULL GENERATED ALWAYS AS (col3_4 + col3_3) STORED, col3_13 TEXT GENERATED ALWAYS AS (lower(CAST(col3_7 AS TEXT))) STORED, col3_14 FLOAT8 NOT NULL GENERATED ALWAYS AS (col3_4 + col3_3) STORED, col3_15 TEXT GENERATED ALWAYS AS (lower(CAST(col3_2 AS TEXT))) STORED, col3_16 FLOAT8 NULL GENERATED ALWAYS AS (col3_3 + col3_4) STORED, col3_17 TEXT GENERATED ALWAYS AS (lower(CAST(col3_8 AS TEXT))) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_0 ASC) INCLUDE (col3_1, col3_2, col3_7, col3_10, col3_12, col3_14, col3_15);
        test_1        |             CREATE INDEX ON table3 (col3_17 DESC, col3_13, col3_7 ASC, col3_12, col3_16 ASC, col3_2 DESC, col3_14 DESC, col3_10, col3_5 ASC, col3_3, col3_4, col3_0 ASC);
        test_1        |             CREATE TYPE rand_typ_0 AS ENUM ('cmjbjg', 's', 'cnc', 'aqfl', 'b');
        test_1        |             CREATE TYPE rand_typ_1 AS ENUM ('bxffr', 'se', 'xrgf');
        test_1        |             CREATE TYPE rand_typ_2 AS ENUM ('rwrrfr', 'gqbpj', 'tj', 'deoax', 'nq', 'at');
        test_1        |             
        test_1        |         compare_test.go:151: postgres: exec: ERROR: generation expression is not immutable (SQLSTATE 42P17)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@5323c44e1c3d3d9ded95a9f20be5ba738cd542ec:

        postgres_1    | 2021-04-10 18:16:17.976 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2021-04-10 18:16:17.983 UTC [96] LOG:  database system was shut down at 2021-04-10 18:16:17 UTC
        postgres_1    | 2021-04-10 18:16:17.988 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2021-04-10 18:16:20.612 UTC [106] ERROR:  invalid byte sequence for encoding "SQL_ASCII": 0x00
        postgres_1    | 2021-04-10 18:16:20.612 UTC [106] STATEMENT:  CREATE TABLE table1 (col1_0 GEOGRAPHY NOT NULL, col1_1 VARCHAR NULL, col1_2 INET, col1_3 TIME, col1_4 FLOAT8 NOT NULL, col1_5 BIT(32), col1_6 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED);
        postgres_1    | 	CREATE INDEX ON table1 (col1_2 DESC, col1_5 DESC, col1_4 DESC, col1_6 DESC, col1_3 ASC, col1_1 ASC) INCLUDE (col1_0);
        postgres_1    | 	CREATE INDEX ON table1 (col1_5 DESC, col1_6 DESC, col1_1 ASC, col1_3 DESC, col1_2 ASC) INCLUDE (col1_0);
        postgres_1    | 	CREATE INDEX ON table1 (col1_3) INCLUDE (col1_4, col1_6);
        postgres_1    | 	CREATE TABLE table2 (col2_0 "char" NOT NULL, col2_1 BIT(13) NOT NULL, col2_2 INTERVAL, col2_3 REGPROC NULL, col2_4 INET, col2_5 UUID NULL, col2_6 JSONB NULL, col2_7 VARCHAR, col2_8 BOX2D, col2_9 CHAR NOT NULL, col2_10 "char" NOT NULL, col2_11 TEXT NOT NULL, col2_12 REGNAMESPACE NOT NULL, PRIMARY KEY (col2_9, col2_10, col2_1), col2_13 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_0)) STORED, col2_14 TEXT GENERATED ALWAYS AS (lower(col2_9)) STORED, col2_15 TEXT GENERATED ALWAYS AS (lower(col2_10)) STORED, col2_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_12 IS NULL THEN e'4\x1fl@'::TEXT ELSE e'k\x1e8'::TEXT END) STORED, col2_17 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_7 ASC, col2_16 DESC, col2_15, col2_12, col2_1 ASC) INCLUDE (col2_0, col2_5, col2_8);
        postgres_1    | 	CREATE INDEX ON table2 (col2_1 ASC, col2_12 DESC, col2_2 DESC, col2_3) INCLUDE (col2_0, col2_5, col2_16, col2_17);
        postgres_1    | 	CREATE UNIQUE INDEX ON table2 (col2_15 DESC, col2_3 ASC, col2_13 ASC, col2_0 ASC, col2_11 DESC, col2_17 ASC, col2_9, col2_7 ASC, col2_14, col2_10 ASC, col2_12 ASC, col2_16 DESC, col2_5 ASC) INCLUDE (col2_2);
        postgres_1    | 	CREATE TABLE table3 (col3_0 FLOAT8 NOT NULL, col3_1 BOOL NOT NULL, col3_2 TIME NOT NULL, col3_3 OID NULL, col3_4 INT8 NOT NULL, col3_5 REGPROC, col3_6 REGTYPE NULL, col3_7 DATE NOT NULL, col3_8 GEOMETRY, col3_9 TIME NULL, col3_10 UUID NOT NULL, col3_11 GEOGRAPHY, col3_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col3_8 AS TEXT))) STORED, col3_13 TEXT GENERATED ALWAYS AS (CASE WHEN col3_6 IS NULL THEN e'v1~7\x02'::TEXT ELSE e'\x00'::TEXT END) STORED);
        postgres_1    | 	CREATE INDEX ON table3 (col3_13 DESC) INCLUDE (col3_0, col3_3, col3_4, col3_6, col3_7, col3_8, col3_9);
        postgres_1    | 	CREATE TYPE rand_typ_0 AS ENUM ('jsxha', 'x', 'fd');
        postgres_1    | 	CREATE TYPE rand_typ_1 AS ENUM ('hbhrkg', 'dhdfw', 'yha', 'q');
        postgres_1    | 	
        test_1        | --- FAIL: TestCompare (606.80s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (2.11s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:150: CREATE TABLE table1 (col1_0 GEOGRAPHY NOT NULL, col1_1 VARCHAR NULL, col1_2 INET, col1_3 TIME, col1_4 FLOAT8 NOT NULL, col1_5 BIT(32), col1_6 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED);
        test_1        |             CREATE INDEX ON table1 (col1_2 DESC, col1_5 DESC, col1_4 DESC, col1_6 DESC, col1_3 ASC, col1_1 ASC) INCLUDE (col1_0);
        test_1        |             CREATE INDEX ON table1 (col1_5 DESC, col1_6 DESC, col1_1 ASC, col1_3 DESC, col1_2 ASC) INCLUDE (col1_0);
        test_1        |             CREATE INDEX ON table1 (col1_3) INCLUDE (col1_4, col1_6);
        test_1        |             CREATE TABLE table2 (col2_0 "char" NOT NULL, col2_1 BIT(13) NOT NULL, col2_2 INTERVAL, col2_3 REGPROC NULL, col2_4 INET, col2_5 UUID NULL, col2_6 JSONB NULL, col2_7 VARCHAR, col2_8 BOX2D, col2_9 CHAR NOT NULL, col2_10 "char" NOT NULL, col2_11 TEXT NOT NULL, col2_12 REGNAMESPACE NOT NULL, PRIMARY KEY (col2_9, col2_10, col2_1), col2_13 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_0)) STORED, col2_14 TEXT GENERATED ALWAYS AS (lower(col2_9)) STORED, col2_15 TEXT GENERATED ALWAYS AS (lower(col2_10)) STORED, col2_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_12 IS NULL THEN e'4\x1fl@'::TEXT ELSE e'k\x1e8'::TEXT END) STORED, col2_17 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_7 ASC, col2_16 DESC, col2_15, col2_12, col2_1 ASC) INCLUDE (col2_0, col2_5, col2_8);
        test_1        |             CREATE INDEX ON table2 (col2_1 ASC, col2_12 DESC, col2_2 DESC, col2_3) INCLUDE (col2_0, col2_5, col2_16, col2_17);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_15 DESC, col2_3 ASC, col2_13 ASC, col2_0 ASC, col2_11 DESC, col2_17 ASC, col2_9, col2_7 ASC, col2_14, col2_10 ASC, col2_12 ASC, col2_16 DESC, col2_5 ASC) INCLUDE (col2_2);
        test_1        |             CREATE TABLE table3 (col3_0 FLOAT8 NOT NULL, col3_1 BOOL NOT NULL, col3_2 TIME NOT NULL, col3_3 OID NULL, col3_4 INT8 NOT NULL, col3_5 REGPROC, col3_6 REGTYPE NULL, col3_7 DATE NOT NULL, col3_8 GEOMETRY, col3_9 TIME NULL, col3_10 UUID NOT NULL, col3_11 GEOGRAPHY, col3_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col3_8 AS TEXT))) STORED, col3_13 TEXT GENERATED ALWAYS AS (CASE WHEN col3_6 IS NULL THEN e'v1~7\x02'::TEXT ELSE e'\x00'::TEXT END) STORED);
        test_1        |             CREATE INDEX ON table3 (col3_13 DESC) INCLUDE (col3_0, col3_3, col3_4, col3_6, col3_7, col3_8, col3_9);
        test_1        |             CREATE TYPE rand_typ_0 AS ENUM ('jsxha', 'x', 'fd');
        test_1        |             CREATE TYPE rand_typ_1 AS ENUM ('hbhrkg', 'dhdfw', 'yha', 'q');
        test_1        |             
        test_1        |         compare_test.go:151: postgres: exec: ERROR: invalid byte sequence for encoding "SQL_ASCII": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@8f66611a35da94ccdd98103dc7e7f3b694c3e8f2:

        postgres_1    | 				B'0001' AS col_19965, 0::INT8 AS col_19966, NULL AS col_19967
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table4 AS tab_11620 CROSS JOIN postgres.public.table5 AS tab_11621
        postgres_1    | 			WHERE
        postgres_1    | 				(NULL AND EXISTS (SELECT percentile_cont('00:00:08'::INTERVAL::FLOAT8)::INTERVAL AS col_19964 FROM postgres.public.table3 AS tab_11622 GROUP BY tab_11622.col3_4 ORDER BY tab_11622.col3_4 ASC))
        postgres_1    | 		)
        postgres_1    | 			AS tab_11623
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_19965 NULLS FIRST, col_19966 NULLS FIRST, col_19967 NULLS FIRST
        test_1        | --- FAIL: TestCompare (620.25s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (16.19s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	s"0",
        test_1        |             + 	s"1",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT get_bit('\x4a':::BYTES::BYTES, 3:::INT8::INT4)::INT8 AS col_20109) AS tab_11714
        test_1        |             ORDER BY
        test_1        |             	col_20109 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT get_bit('\x4a'::BYTEA::BYTEA, 3::INT8::INT8)::INT8 AS col_20109) AS tab_11714
        test_1        |             ORDER BY
        test_1        |             	col_20109 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@dd2460e82f5786603234531d75c5fafe065c0878:

        postgres_1    | 		col_107782 NULLS FIRST
        postgres_1    | 2021-04-13 18:15:16.478 UTC [106] ERROR:  function set_masklen(inet, bigint) does not exist at character 25
        postgres_1    | 2021-04-13 18:15:16.478 UTC [106] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        postgres_1    | 2021-04-13 18:15:16.478 UTC [106] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(SELECT set_masklen('::2/0'::INET::INET, 5::INT8::INT8)::INET AS col_108269) AS tab_58812
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_108269 NULLS FIRST
        test_1        | --- FAIL: TestCompare (674.95s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (71.39s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("4.0I"),
        test_1        |             + 	string("4I"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (4.0:::FLOAT8::FLOAT8 || 'I':::STRING::STRING)::STRING AS col_108764) AS tab_59087
        test_1        |             ORDER BY
        test_1        |             	col_108764 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (4.0::FLOAT8::FLOAT8 || 'I'::TEXT::TEXT)::TEXT AS col_108764) AS tab_59087
        test_1        |             ORDER BY
        test_1        |             	col_108764 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@458eda63dfb5e7091dbe75d647f48071018d5f59:

        postgres_1    | 				tab_12521.col1_0 AS col_16252
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table1 AS tab_12521
        postgres_1    | 			WHERE
        postgres_1    | 				true
        postgres_1    | 		)
        postgres_1    | 			AS tab_12522
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_16249 NULLS FIRST, col_16250 NULLS FIRST, col_16251 NULLS FIRST, col_16252 NULLS FIRST
        test_1        | --- FAIL: TestCompare (616.16s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (12.45s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("Et"),
        test_1        |             + 	string("Etrue"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('E':::STRING::STRING || true::BOOL)::STRING AS col_16401) AS tab_12642
        test_1        |             ORDER BY
        test_1        |             	col_16401 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('E'::TEXT::TEXT || true::BOOL)::TEXT AS col_16401) AS tab_12642
        test_1        |             ORDER BY
        test_1        |             	col_16401 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

(compose).TestComposeCompare failed on release-21.1@e103b14e5d7f5bc81715f73f1cbd004bf62c2188:

        postgres_1    | 				postgres.public.table1 AS tab_4882
        postgres_1    | 			WHERE
        postgres_1    | 				st_crosses(NULL::GEOMETRY, st_buffer(st_voronoipolygons(NULL::GEOMETRY, 5.0::FLOAT8::FLOAT8, NULL::GEOMETRY)::GEOMETRY::GEOMETRY, 5.0::FLOAT8::FLOAT8, 8::INT8::INT8)::GEOMETRY::GEOMETRY)::BOOL
        postgres_1    | 			ORDER BY
        postgres_1    | 				tab_4882.col1_5 DESC
        postgres_1    | 		)
        postgres_1    | 			AS tab_4883
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_8606 NULLS FIRST, col_8607 NULLS FIRST
        test_1        | --- FAIL: TestCompare (612.03s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (8.03s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("1A"),
        test_1        |             + 	string("1.0A"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (1.0::FLOAT8::FLOAT8 || 'A'::TEXT::TEXT)::TEXT AS col_8650) AS tab_4906
        test_1        |             ORDER BY
        test_1        |             	col_8650 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT (1.0:::FLOAT8::FLOAT8 || 'A':::STRING::STRING)::STRING AS col_8650) AS tab_4906
        test_1        |             ORDER BY
        test_1        |             	col_8650 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1

More

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 2d94ccf10cd0fefd113ec48261705f8810990cf3:

        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (7.57s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	s"7",
        test_1        |             + 	int16(7),
        test_1        |               	uint32(1),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 7:::INT8 END AS col_12134,
        test_1        |             			CASE WHEN false THEN 5:::OID ELSE 1:::OID END AS col_12135
        test_1        |             	)
        test_1        |             		AS tab_6355
        test_1        |             ORDER BY
        test_1        |             	col_12134 NULLS FIRST, col_12135 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 7::INT8 END AS col_12134,
        test_1        |             			CASE WHEN false THEN 5::OID ELSE 1::OID END AS col_12135
        test_1        |             	)
        test_1        |             		AS tab_6355
        test_1        |             ORDER BY
        test_1        |             	col_12134 NULLS FIRST, col_12135 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 6267da0f19b6cdc08e9fdd39899e35212694cb78:

        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (14.76s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |               	string("H"),
        test_1        |             - 	s"2",
        test_1        |             + 	int16(2),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'H'::TEXT AS col_18893,
        test_1        |             			CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 2::INT8 END AS col_18894
        test_1        |             	)
        test_1        |             		AS tab_9207
        test_1        |             ORDER BY
        test_1        |             	col_18893 NULLS FIRST, col_18894 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			'H':::STRING AS col_18893,
        test_1        |             			CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 2:::INT8 END AS col_18894
        test_1        |             	)
        test_1        |             		AS tab_9207
        test_1        |             ORDER BY
        test_1        |             	col_18893 NULLS FIRST, col_18894 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ f60fbf28b0bb6110cf9870cc398ea169b81ff8f0:

        test_1        |             FROM
        test_1        |             	(SELECT ('2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ || 'G'::TEXT::TEXT)::TEXT AS col_348536)
        test_1        |             		AS tab_187767
        test_1        |             ORDER BY
        test_1        |             	col_348536 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        | 	panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 381153 [running]:
        test_1        | testing.tRunner.func1.1(0x1e5cdc0, 0xc000c01d00)
        test_1        | 	/usr/local/go/src/testing/testing.go:1072 +0x30d
        test_1        | testing.tRunner.func1(0xc000d9c000)
        test_1        | 	/usr/local/go/src/testing/testing.go:1075 +0x41a
        test_1        | panic(0x1e5cdc0, 0xc000c01d00)
        test_1        | 	/usr/local/go/src/runtime/panic.go:969 +0x1b9
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.encodeInvertedIndexHistogramUpperBounds(0x36d0620, 0x28ac880, 0xc000a5fe00, 0x28ac880, 0xc000a5fe00, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:371 +0x688
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.randHistogram(0xc00083fad0, 0x36d0620, 0x36d0620, 0x0, 0xc000daf7a0, 0x8)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:298 +0x10c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator.func1(0xc000b18a20)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:217 +0x9d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator(0xc00083fad0, 0xc000cd1450, 0x5, 0x5, 0x0, 0x0, 0x0, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:248 +0xbe6
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.MultiStatementMutation.Mutate(0x2595300, 0xc00083fad0, 0xc000cd1450, 0x5, 0x5, 0x0, 0xc000206500, 0x7ffffffc000000e0, 0xc000ad4980)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:92 +0x4e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/rowenc.RandCreateTables(0xc00083fad0, 0x1fe2c18, 0x5, 0x5, 0xc000dafa70, 0x3, 0x3, 0xe0, 0x203000, 0x203000)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/rowenc/testutils.go:1105 +0x224
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00083fad0, 0x30, 0x1eb5e60)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:86 +0x1be
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc00083fad0, 0xe85bdb7f80a6e78, 0x11)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:44 +0x44
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000d9c000)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:128 +0x113
        test_1        | testing.tRunner(0xc000d9c000, 0xc00083faa0)
        test_1        | 	/usr/local/go/src/testing/testing.go:1123 +0xef
        test_1        | created by testing.(*T).Run
        test_1        | 	/usr/local/go/src/testing/testing.go:1168 +0x2b3
        compare_test_1 exited with code 2
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 2
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 92e342b8f0032a5771d3e50932df4c6d7d85fe41:

        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (19.78s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	int16(2),
        test_1        |             + 	s"2",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_16619.col_33645 AS col_33647
        test_1        |             		FROM
        test_1        |             			(VALUES (st_zmflag(NULL::GEOMETRY)::INT2, 7:::OID), (2:::INT8, NULL)) AS tab_16619 (col_33645, col_33646)
        test_1        |             	)
        test_1        |             		AS tab_16620
        test_1        |             ORDER BY
        test_1        |             	col_33647 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_16619.col_33645 AS col_33647
        test_1        |             		FROM
        test_1        |             			(VALUES (st_zmflag(NULL::GEOMETRY)::INT2, 7::OID), (2::INT8, NULL)) AS tab_16619 (col_33645, col_33646)
        test_1        |             	)
        test_1        |             		AS tab_16620
        test_1        |             ORDER BY
        test_1        |             	col_33647 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ ac674b7ad588f1f76cb54f284c0ea05d2da2d634:

        test_1        |             				VALUES
        test_1        |             					('A':::STRING, NULL),
        test_1        |             					(('2000-01-01 00:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ || 'D':::STRING::STRING)::STRING, NULL),
        test_1        |             					(('B':::STRING::STRING || '00:05:00':::TIME::TIME)::STRING, 'H':::STRING),
        test_1        |             					('F':::STRING, 'G':::STRING),
        test_1        |             					('I':::STRING, 'C':::STRING)
        test_1        |             			)
        test_1        |             				AS tab_142868 (col_267980, col_267981)
        test_1        |             		WHERE
        test_1        |             			true
        test_1        |             	)
        test_1        |             		AS tab_142869
        test_1        |             ORDER BY
        test_1        |             	col_267982 NULLS FIRST, col_267983 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_142868.col_267980 AS col_267982, tab_142868.col_267981 AS col_267983
        test_1        |             		FROM
        test_1        |             			(
        test_1        |             				VALUES
        test_1        |             					('A'::TEXT, NULL),
        test_1        |             					(('2000-01-01 00:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ || 'D'::TEXT::TEXT)::TEXT, NULL),
        test_1        |             					(('B'::TEXT::TEXT || '00:05:00'::TIME::TIME)::TEXT, 'H'::TEXT),
        test_1        |             					('F'::TEXT, 'G'::TEXT),
        test_1        |             					('I'::TEXT, 'C'::TEXT)
        test_1        |             			)
        test_1        |             				AS tab_142868 (col_267980, col_267981)
        test_1        |             		WHERE
        test_1        |             			true
        test_1        |             	)
        test_1        |             		AS tab_142869
        test_1        |             ORDER BY
        test_1        |             	col_267982 NULLS FIRST, col_267983 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ c38781390f0d07cf3d39d1af9ed01b4e370aaffa:

        postgres_1    | 		col_69284 NULLS FIRST,
        postgres_1    | 		col_69285 NULLS FIRST,
        postgres_1    | 		col_69286 NULLS FIRST,
        postgres_1    | 		col_69287 NULLS FIRST,
        postgres_1    | 		col_69288 NULLS FIRST,
        postgres_1    | 		col_69289 NULLS FIRST,
        postgres_1    | 		col_69290 NULLS FIRST
        test_1        | --- FAIL: TestCompare (645.93s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (43.12s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |               	string("1001"),
        test_1        |               	nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT postgis_scripts_installed()::STRING AS col_69401, B'1001' AS col_69402, NULL AS col_69403) AS tab_36828
        test_1        |             ORDER BY
        test_1        |             	col_69401 NULLS FIRST, col_69402 NULLS FIRST, col_69403 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT postgis_scripts_installed()::TEXT AS col_69401, B'1001' AS col_69402, NULL AS col_69403) AS tab_36828
        test_1        |             ORDER BY
        test_1        |             	col_69401 NULLS FIRST, col_69402 NULLS FIRST, col_69403 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ ede1628bd625a07b3f966a36ea841009803fc8a9:

        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("E2000-01-01 01:00:00"),
        test_1        |             + 	string("E2000-01-01 01:00:00+00"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			COALESCE(
        test_1        |             				('E'::TEXT::TEXT || '2000-01-01 01:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT,
        test_1        |             				'E'::TEXT
        test_1        |             			)
        test_1        |             				AS col_15994
        test_1        |             	)
        test_1        |             		AS tab_9798
        test_1        |             ORDER BY
        test_1        |             	col_15994 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			COALESCE(
        test_1        |             				('E':::STRING::STRING || '2000-01-01 01:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::STRING,
        test_1        |             				'E':::STRING
        test_1        |             			)
        test_1        |             				AS col_15994
        test_1        |             	)
        test_1        |             		AS tab_9798
        test_1        |             ORDER BY
        test_1        |             	col_15994 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ db3cdb8913ba56599cc52766411893438b5c4b54:

        postgres_1    | 				log(0.0::FLOAT8::FLOAT8, NULL::FLOAT8)::FLOAT8 AS col_114642
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table3 AS tab_59779
        postgres_1    | 		)
        postgres_1    | 			AS tab_59780
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_114639 NULLS FIRST, col_114640 NULLS FIRST, col_114641 NULLS FIRST, col_114642 NULLS FIRST
        test_1        | --- FAIL: TestCompare (670.65s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (67.09s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("2000-01-01 01:00:00C"),
        test_1        |             + 	string("2000-01-01 01:00:00+00C"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('2000-01-01 01:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ || 'C':::STRING::STRING)::STRING AS col_115007)
        test_1        |             		AS tab_59945
        test_1        |             ORDER BY
        test_1        |             	col_115007 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('2000-01-01 01:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ || 'C'::TEXT::TEXT)::TEXT AS col_115007)
        test_1        |             		AS tab_59945
        test_1        |             ORDER BY
        test_1        |             	col_115007 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 547a1208b2bf09c2358f49dfca3259fa731aacc5:

        postgres_1    | 		)
        postgres_1    | 			AS tab_202026
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_340156 NULLS FIRST,
        postgres_1    | 		col_340157 NULLS FIRST,
        postgres_1    | 		col_340158 NULLS FIRST,
        postgres_1    | 		col_340159 NULLS FIRST,
        postgres_1    | 		col_340160 NULLS FIRST,
        postgres_1    | 		col_340161 NULLS FIRST
        test_1        | --- FAIL: TestCompare (807.67s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (203.48s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	int16(5),
        test_1        |             + 	s"5",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT COALESCE(st_zmflag(NULL::GEOMETRY)::INT2, 5:::INT8) AS col_340255) AS tab_202094
        test_1        |             ORDER BY
        test_1        |             	col_340255 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT COALESCE(st_zmflag(NULL::GEOMETRY)::INT2, 5::INT8) AS col_340255) AS tab_202094
        test_1        |             ORDER BY
        test_1        |             	col_340255 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ a671a4e57d8c7e6270a95477d30f9ced6fc5e108:

        postgres_1    | 		col_379411 NULLS FIRST,
        postgres_1    | 		col_379412 NULLS FIRST,
        postgres_1    | 		col_379413 NULLS FIRST,
        postgres_1    | 		col_379414 NULLS FIRST,
        postgres_1    | 		col_379415 NULLS FIRST,
        postgres_1    | 		col_379416 NULLS FIRST,
        postgres_1    | 		col_379417 NULLS FIRST
        test_1        | --- FAIL: TestCompare (843.43s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (241.58s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("C2000-01-01 01:00:00+00"),
        test_1        |             + 	string("C2000-01-01 01:00:00"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('C':::STRING::STRING || '2000-01-01 01:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::STRING AS col_379868)
        test_1        |             		AS tab_204888
        test_1        |             ORDER BY
        test_1        |             	col_379868 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('C'::TEXT::TEXT || '2000-01-01 01:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT AS col_379868)
        test_1        |             		AS tab_204888
        test_1        |             ORDER BY
        test_1        |             	col_379868 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 5e8abbb1796889f75550fef774632b1bb2dfa87b:

        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT COALESCE(st_zmflag(NULL::GEOMETRY)::INT2, 2::INT8) AS col_323657) AS tab_183877
        test_1        |             ORDER BY
        test_1        |             	col_323657 NULLS FIRST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        | 	panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 368534 [running]:
        test_1        | testing.tRunner.func1.1(0x1e5d940, 0xc000e1e0c0)
        test_1        | 	/usr/local/go/src/testing/testing.go:1072 +0x30d
        test_1        | testing.tRunner.func1(0xc000023200)
        test_1        | 	/usr/local/go/src/testing/testing.go:1075 +0x41a
        test_1        | panic(0x1e5d940, 0xc000e1e0c0)
        test_1        | 	/usr/local/go/src/runtime/panic.go:969 +0x1b9
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.encodeInvertedIndexHistogramUpperBounds(0x36d1620, 0x28ad520, 0xc0005d3620, 0x28ad520, 0xc0005d3620, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:371 +0x688
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.randHistogram(0xc0005d33b0, 0x36d1620, 0x36d1620, 0x0, 0xc0009297b8, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:298 +0x10c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator.func1(0xc000812d80)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:217 +0x9d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator(0xc0005d33b0, 0xc0005ace90, 0x1, 0x1, 0x0, 0x0, 0x0, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:248 +0xbe6
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.MultiStatementMutation.Mutate(0x2595f00, 0xc0005d33b0, 0xc0005ace90, 0x1, 0x1, 0x0, 0xc000b86c80, 0x7ffffffc000000e0, 0xc000085980)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:92 +0x4e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/rowenc.RandCreateTables(0xc0005d33b0, 0x1fe3818, 0x5, 0x1, 0xc000e9fa70, 0x3, 0x3, 0xe0, 0x203000, 0x203000)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/rowenc/testutils.go:1105 +0x224
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc0005d33b0, 0x30, 0x1eb69e0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:86 +0x1be
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc0005d33b0, 0x9b3599dba71b20de, 0x11)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:44 +0x44
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000023200)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:128 +0x113
        test_1        | testing.tRunner(0xc000023200, 0xc0005d3380)
        test_1        | 	/usr/local/go/src/testing/testing.go:1123 +0xef
        test_1        | created by testing.(*T).Run
        test_1        | 	/usr/local/go/src/testing/testing.go:1168 +0x2b3
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 2
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ a866c9fe3948bcfcd028b94fc06afda7268fa985:

        postgres_1    | 2021-07-03 05:16:49.271 UTC [97] LOG:  database system was shut down at 2021-07-03 05:16:49 UTC
        postgres_1    | 2021-07-03 05:16:49.276 UTC [1] LOG:  database system is ready to accept connections
        test_1        | --- FAIL: TestCompare (2.12s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/mutators (0.00s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        | panic: geos: no locations to init GEOS [recovered]
        test_1        | 	panic: geos: no locations to init GEOS
        test_1        | 
        test_1        | goroutine 36 [running]:
        test_1        | testing.tRunner.func1.1(0x1e5d940, 0xc0008ce000)
        test_1        | 	/usr/local/go/src/testing/testing.go:1072 +0x30d
        test_1        | testing.tRunner.func1(0xc0005af980)
        test_1        | 	/usr/local/go/src/testing/testing.go:1075 +0x41a
        test_1        | panic(0x1e5d940, 0xc0008ce000)
        test_1        | 	/usr/local/go/src/runtime/panic.go:969 +0x1b9
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.encodeInvertedIndexHistogramUpperBounds(0x36d1620, 0x28ad520, 0xc00053acc0, 0x28ad520, 0xc00053acc0, 0xc0008b6100)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:371 +0x688
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.randHistogram(0xc00053a960, 0x36d1620, 0x36d1620, 0xb67bffb5e299213e, 0x6, 0xb60000c000a0aefa)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:298 +0x10c
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator.func1(0xc000574120)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:217 +0x9d
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.statisticsMutator(0xc00053a960, 0xc0006a7560, 0x2, 0x2, 0x0, 0x0, 0x0, 0x0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:248 +0xbe6
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/mutations.MultiStatementMutation.Mutate(0x2595f00, 0xc00053a960, 0xc0006a7560, 0x2, 0x2, 0x0, 0xc0008ca320, 0x7ffffffc000000e0, 0xc000083980)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/mutations/mutations.go:92 +0x4e
        test_1        | github.com/cockroachdb/cockroach/pkg/sql/rowenc.RandCreateTables(0xc00053a960, 0x1fe3818, 0x5, 0x2, 0xc000591a70, 0x3, 0x3, 0xe0, 0x203000, 0x203000)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/rowenc/testutils.go:1105 +0x224
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc00053a960, 0x30, 0x1eb69e0)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:86 +0x1be
        test_1        | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc00053a960, 0x279ee18c75dcd515, 0x11)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:44 +0x44
        test_1        | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0005af980)
        test_1        | 	/go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:128 +0x113
        test_1        | testing.tRunner(0xc0005af980, 0xc00053a930)
        test_1        | 	/usr/local/go/src/testing/testing.go:1123 +0xef
        test_1        | created by testing.(*T).Run
        test_1        | 	/usr/local/go/src/testing/testing.go:1168 +0x2b3
        compare_test_1 exited with code 2
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 2
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 21b5b06ea907f4adf0fef3318848e28f454138ea:

        postgres_1    | 2021-07-05 05:16:37.176 UTC [106] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        postgres_1    | 2021-07-05 05:16:37.176 UTC [106] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(
        postgres_1    | 			SELECT
        postgres_1    | 				'H'::TEXT AS col_83551,
        postgres_1    | 				tab_46375.col3_1 AS col_83552,
        postgres_1    | 				st_geographyfromtext(tab_46375.col3_5::TEXT, 0::INT8::INT4)::GEOGRAPHY AS col_83553,
        postgres_1    | 				tab_46375.col3_7 AS col_83554,
        postgres_1    | 				tab_46375.col3_0 AS col_83555
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table3 AS tab_46375
        postgres_1    | 			WHERE
        postgres_1    | 				NULL::rand_typ_1 NOT IN (NULL, NULL)
        postgres_1    | 		)
        postgres_1    | 			AS tab_46376
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_83551 NULLS FIRST, col_83552 NULLS FIRST, col_83553 NULLS FIRST, col_83554 NULLS FIRST, col_83555 NULLS FIRST
        test_1        | --- FAIL: TestCompare (654.20s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (51.92s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.1.2 cbe925d"),
        test_1        |             + 	string("3.0.1 ec2a9aa"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::TEXT AS col_83573) AS tab_46391 ORDER BY col_83573 NULLS FIRST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::STRING AS col_83573) AS tab_46391 ORDER BY col_83573 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 32273aa49ce7006677bb1b4a0003b4ed8ac8b455:

        postgres_1    | 		col_94826 NULLS FIRST,
        postgres_1    | 		col_94827 NULLS FIRST
        test_1        | --- FAIL: TestCompare (671.88s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (68.88s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             + 	nil,
        test_1        |               	nil,
        test_1        |             - 	nil,
        test_1        |             + 	uint32(5),
        test_1        |             - 	uint32(5),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT NULL AS col_95263, NULL AS col_95264, 5:::OID AS col_95265, postgis_scripts_released()::STRING AS col_95266)
        test_1        |             		AS tab_55934
        test_1        |             ORDER BY
        test_1        |             	col_95263 NULLS FIRST, col_95264 NULLS FIRST, col_95265 NULLS FIRST, col_95266 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT NULL AS col_95263, NULL AS col_95264, 5::OID AS col_95265, postgis_scripts_released()::TEXT AS col_95266)
        test_1        |             		AS tab_55934
        test_1        |             ORDER BY
        test_1        |             	col_95263 NULLS FIRST, col_95264 NULLS FIRST, col_95265 NULLS FIRST, col_95266 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 4bdd64a13faabc2024969f68d3bca17feacb5147:

        postgres_1    | 			WHERE
        postgres_1    | 				true
        postgres_1    | 		)
        postgres_1    | 			AS tab_227584
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_439188 NULLS FIRST,
        postgres_1    | 		col_439189 NULLS FIRST,
        postgres_1    | 		col_439190 NULLS FIRST,
        postgres_1    | 		col_439191 NULLS FIRST,
        postgres_1    | 		col_439192 NULLS FIRST,
        postgres_1    | 		col_439193 NULLS FIRST
        postgres_1    | 2021-07-07 05:16:58.166 UTC [105] ERROR:  function st_geogfromwkb(bytea, integer) does not exist at character 25
        postgres_1    | 2021-07-07 05:16:58.166 UTC [105] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        postgres_1    | 2021-07-07 05:16:58.166 UTC [105] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(SELECT st_geogfromwkb('\x41'::BYTEA::BYTEA, 2::INT8::INT4)::GEOGRAPHY AS col_439893) AS tab_227987
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_439893 NULLS FIRST
        test_1        | --- FAIL: TestCompare (836.34s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (232.70s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::STRING AS col_440648) AS tab_228363 ORDER BY col_440648 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::TEXT AS col_440648) AS tab_228363 ORDER BY col_440648 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ b7eaf3b47c220003b3d949af6d48d220c5f92db4:

        postgres_1    | 				3.0::FLOAT8 AS col_7632, sqrdiff(7::DECIMAL::INT4)::DECIMAL AS col_7633
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table5 AS tab_4029
        postgres_1    | 			WHERE
        postgres_1    | 				true
        postgres_1    | 			GROUP BY
        postgres_1    | 				tab_4029.col5_14, tab_4029.col5_9
        postgres_1    | 		)
        postgres_1    | 			AS tab_4030
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_7632 NULLS FIRST, col_7633 NULLS FIRST
        postgres_1    | 2021-07-08 05:13:24.321 UTC [106] ERROR:  parse error - invalid geometry
        postgres_1    | 2021-07-08 05:13:24.321 UTC [106] HINT:  "I" <-- parse error at position 2 within geometry
        postgres_1    | 2021-07-08 05:13:24.321 UTC [106] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(SELECT NULL AS col_8209, st_geogfromtext('I'::TEXT::TEXT)::GEOGRAPHY AS col_8210) AS tab_4333
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_8209 NULLS FIRST, col_8210 NULLS FIRST
        test_1        | --- FAIL: TestCompare (612.32s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (7.34s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::STRING AS col_8473) AS tab_4461 ORDER BY col_8473 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_released()::TEXT AS col_8473) AS tab_4461 ORDER BY col_8473 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 3ee6d71402938c32c266243cffd94c2c1d7bef9a:

        postgres_1    | 		col_166524 NULLS FIRST,
        postgres_1    | 		col_166525 NULLS FIRST,
        postgres_1    | 		col_166526 NULLS FIRST,
        postgres_1    | 		col_166527 NULLS FIRST,
        postgres_1    | 		col_166528 NULLS FIRST,
        postgres_1    | 		col_166529 NULLS FIRST,
        postgres_1    | 		col_166530 NULLS FIRST,
        postgres_1    | 		col_166531 NULLS FIRST,
        postgres_1    | 		col_166532 NULLS FIRST
        test_1        | --- FAIL: TestCompare (703.57s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (100.09s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT concat(postgis_scripts_installed()::STRING::STRING)::STRING AS col_166644) AS tab_91318
        test_1        |             ORDER BY
        test_1        |             	col_166644 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT concat(postgis_scripts_installed()::TEXT::TEXT)::TEXT AS col_166644) AS tab_91318
        test_1        |             ORDER BY
        test_1        |             	col_166644 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ a59bb25a0c234e1752aa201fc8d6ccc4683c16b1:

        postgres_1    | 		col_490282 NULLS FIRST,
        postgres_1    | 		col_490283 NULLS FIRST,
        postgres_1    | 		col_490284 NULLS FIRST
        postgres_1    | 2021-07-10 05:17:57.248 UTC [106] ERROR:  function unaccent(text) does not exist at character 31
        postgres_1    | 2021-07-10 05:17:57.248 UTC [106] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        postgres_1    | 2021-07-10 05:17:57.248 UTC [106] STATEMENT:  SELECT
        postgres_1    | 		*
        postgres_1    | 	FROM
        postgres_1    | 		(
        postgres_1    | 			SELECT
        postgres_1    | 				unaccent(tab_256252.col5_6::TEXT)::TEXT AS col_490663
        postgres_1    | 			FROM
        postgres_1    | 				postgres.public.table5 AS tab_256252
        postgres_1    | 			ORDER BY
        postgres_1    | 				tab_256252.col5_1 ASC
        postgres_1    | 		)
        postgres_1    | 			AS tab_256253
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_490663 NULLS FIRST
        test_1        | --- FAIL: TestCompare (866.65s)
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     --- FAIL: TestCompare/postgres (263.61s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("3.0.1 ec2a9aa"),
        test_1        |             + 	string("3.1.2 cbe925d"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_installed()::STRING AS col_490665) AS tab_256257 ORDER BY col_490665 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT * FROM (SELECT postgis_scripts_installed()::TEXT AS col_490665) AS tab_256257 ORDER BY col_490665 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 03b83e02502e8876ecb366659156ab00f7431a51:

        postgres_1    | 		col_65417 NULLS FIRST,
        postgres_1    | 		col_65418 NULLS FIRST,
        postgres_1    | 		col_65419 NULLS FIRST,
        postgres_1    | 		col_65420 NULLS FIRST,
        postgres_1    | 		col_65421 NULLS FIRST,
        postgres_1    | 		col_65422 NULLS FIRST,
        postgres_1    | 		col_65423 NULLS FIRST
        test_1        | --- FAIL: TestCompare (964.31s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (361.39s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("D2000-01-01 08:00:00+00"),
        test_1        |             + 	string("D2000-01-01 08:00:00"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('D':::STRING::STRING || '2000-01-01 08:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::STRING AS col_65570)
        test_1        |             		AS tab_37155
        test_1        |             ORDER BY
        test_1        |             	col_65570 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('D'::TEXT::TEXT || '2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT AS col_65570)
        test_1        |             		AS tab_37155
        test_1        |             ORDER BY
        test_1        |             	col_65570 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 018479af8598930806ed99fda946c4ea72eb9d6a:

        postgres_1    | 				tab_16284.col2_0
        postgres_1    | 			HAVING
        postgres_1    | 				every(false::BOOL)::BOOL
        postgres_1    | 			ORDER BY
        postgres_1    | 				tab_16284.col2_0 ASC
        postgres_1    | 		)
        postgres_1    | 			AS tab_16285
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_23065 NULLS FIRST
        test_1        | --- FAIL: TestCompare (622.93s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (19.57s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	int16(8),
        test_1        |             + 	s"8",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 8:::INT8 END AS col_23784) AS tab_16782
        test_1        |             ORDER BY
        test_1        |             	col_23784 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT CASE WHEN false THEN st_zmflag(NULL::GEOMETRY)::INT2 ELSE 8::INT8 END AS col_23784) AS tab_16782
        test_1        |             ORDER BY
        test_1        |             	col_23784 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Jul 14, 2021
66850: sqlproxyccl: statistically load balance across tenants r=chrisseto a=chrisseto

    Previously, the SQLProxy's Directory implementation would always
    select the first instance from the pods list. As part of the
    SQLProxy's duty is load balancing, this was inadequate. This commit
    upgrades the tenant dir to have pods report their CPU load. This
    load is then used to perform a weighted distribution across all
    running tenant pods.

Release note: None

67276: roachtest: remove test which exercised 20.2-21.1 upgrade r=postamar a=ajwerner

We no longer use the master roachtest for old branches. Given that, the answer
is to just remove this test from master.

This test fails because in #67053 I removed compatibility between 20.2 and
master. We should never be trying to do that upgrade.

Fixes #67182

Release note: None

67460: cli: move the demo cluster to new sub-package `democluster` (5/) r=otan a=knz

First 15 commits are from #67459 and prior.
Please ignore those (they will disappear once the prefix PR is merged)

Only the last 5 commits belong to this PR.

This is part of a family of PRs that aim to encapsulate CLI functionality into finer grained packages.

67461: cli: SQL shell cleanups and better encapsulation (6/) r=otan a=knz

First 20 commits are from #67460 and prior.
Please ignore those (they will disappear once the prefix PR is merged)

Only the last 4 commits belong to this PR.

This is part of a family of PRs that aim to encapsulate CLI functionality into finer grained packages.

67474: cli: new sub-package `clisqlcfg` to ease the creation of a standalone SQL shell (8/) r=otan a=knz

First 28 commits are from #67462 and prior.
Please ignore those (they will disappear once the prefix PR is merged)

Only the last 2 commits belong to this PR.

This is part of a family of PRs that aim to encapsulate CLI functionality into finer grained packages.



67484: clisqlclient: drop the dependency on 'security' r=otan a=knz

Fixes #67481.
Informs #67470.

This PR only contains 1 commit (the last).
All commits except for the last belong to #67469 and prior PRs. Ignore them during review.


The 'security' package is quite large. There is no reason to embark it
into a standalone SQL shell.

Towards achieving this, this patch removes the dependency on the
'security' package from `clisqlclient` by moving the password prompt
code into a sub-package.

Release note: None

67588: compare_test: account for more differences from postgres r=otan a=rafiss

- explicit cast for constants #62602 (comment)
- don't use postgis_script builtin #62602 (comment)
- handle differences in timezone offset display #62602 (comment)

Release note: None

67594: build: update go to 1.16.6 r=rail a=rail

* [ ] Adjust the Pebble tests to run in new version.
* [x] Adjust version in Docker image ([source](./builder/Dockerfile)).
* [x] Adjust version in the TeamCity agent image ([setup script](./packer/teamcity-agent.sh))
* [x] Rebuild and push the Docker image (following [Basic Process](#basic-process))
* [x] Bump the version in `WORKSPACE` under `go_register_toolchains`. You may need to bump [rules_go](https://github.com/bazelbuild/rules_go/releases).
* [x] Bump the version in `builder.sh` accordingly ([source](./builder.sh#L6)).
* [x] Bump the version in `go-version-check.sh` ([source](./go-version-check.sh)), unless bumping to a new patch release.
* [x] Bump the go version in `go.mod`. You may also need to rerun `make vendor_rebuild` if vendoring has changed.
* [x] Bump the default installed version of Go in `bootstrap-debian.sh` ([source](./bootstrap/bootstrap-debian.sh)).
* [x] Replace other mentions of the older version of go (grep for `golang:<old_version>` and `go<old_version>`).
* [ ] Update the `builder.dockerImage` parameter in the TeamCity [`Cockroach`](https://teamcity.cockroachdb.com/admin/editProject.html?projectId=Cockroach&tab=projectParams) and [`Internal`](https://teamcity.cockroachdb.com/admin/editProject.html?projectId=Internal&tab=projectParams) projects.
* [ ] Ask the Developer Infrastructure team to deploy new TeamCity agent images according to [packer/README.md](./packer/README.md)

Release note: None

67603: roachtest: re-mark `pkg/cmd/roachtest` tests as `broken_in_bazel` r=rail a=rickystewart

`faa4c2ccdaeca01eca3ccee29a8a64973cf8b043` removed this tag, which
caused all Bazel test runs to begin failing.

Closes #67595.

Release note: None

Co-authored-by: Chris Seto <[email protected]>
Co-authored-by: Andrew Werner <[email protected]>
Co-authored-by: Raphael 'kena' Poss <[email protected]>
Co-authored-by: Rafi Shamim <[email protected]>
Co-authored-by: Rail Aliiev <[email protected]>
Co-authored-by: Ricky Stewart <[email protected]>
@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 2bf78f3f1f2d34502ab0ae884d505e08f3bd8648:

        postgres_1    | 				tab_36302.col1_1, tab_36302.col2_14, tab_36302.col2_5
        postgres_1    | 			ORDER BY
        postgres_1    | 				tab_36302.col2_5 ASC, tab_36302.col1_1 DESC, tab_36302.col2_14, tab_36302.col2_14 DESC
        postgres_1    | 		)
        postgres_1    | 			AS tab_36303
        postgres_1    | 	ORDER BY
        postgres_1    | 		col_61954 NULLS FIRST, col_61955 NULLS FIRST, col_61956 NULLS FIRST
        test_1        | --- FAIL: TestCompare (643.54s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (41.51s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare cockroach1 to postgres:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	string("H2000-01-01 01:00:00"),
        test_1        |             + 	string("H2000-01-01 01:00:00+00"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('H':::STRING::STRING || '2000-01-01 01:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ)::STRING AS col_62210)
        test_1        |             		AS tab_36461
        test_1        |             ORDER BY
        test_1        |             	col_62210 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(SELECT ('H'::TEXT::TEXT || '2000-01-01 01:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)::TEXT AS col_62210)
        test_1        |             		AS tab_36461
        test_1        |             ORDER BY
        test_1        |             	col_62210 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ aa9506903f7a71f8117e89d1e344cd91a7d50cf4:

        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |               	nil,
        test_1        |             - 	int16(1),
        test_1        |             + 	s"1",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL AS col_367579,
        test_1        |             			CASE
        test_1        |             			WHEN NULL::INT8 NOT IN (SELECT 3:::INT8::INT8 AS col_367580) THEN st_zmflag(NULL::GEOMETRY)::INT2
        test_1        |             			ELSE 1:::INT8
        test_1        |             			END
        test_1        |             				AS col_367581
        test_1        |             	)
        test_1        |             		AS tab_204313
        test_1        |             ORDER BY
        test_1        |             	col_367579 NULLS FIRST, col_367581 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			NULL AS col_367579,
        test_1        |             			CASE
        test_1        |             			WHEN NULL::INT8 NOT IN (SELECT 3::INT8::INT8 AS col_367580) THEN st_zmflag(NULL::GEOMETRY)::INT2
        test_1        |             			ELSE 1::INT8
        test_1        |             			END
        test_1        |             				AS col_367581
        test_1        |             	)
        test_1        |             		AS tab_204313
        test_1        |             ORDER BY
        test_1        |             	col_367579 NULLS FIRST, col_367581 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

compose.TestComposeCompare failed with artifacts on release-21.1 @ 42486498706391d1a63cf49fd47ffd67388293ab:

        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:133: initializing connection: cockroach1
        test_1        |         compare_test.go:133: initializing connection: postgres
        test_1        |         compare_test.go:176: compare postgres to cockroach1:
        test_1        |             unexpected diff:
        test_1        |               []interface{}(Inverse(func1, []interface{}{
        test_1        |             - 	s"1",
        test_1        |             + 	int16(1),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_70144.col_114444 AS col_114445
        test_1        |             		FROM
        test_1        |             			(VALUES (st_zmflag(NULL::GEOMETRY)::INT2), (1:::INT8), (9:::INT8), (8:::INT8), (1:::INT8))
        test_1        |             				AS tab_70144 (col_114444)
        test_1        |             	)
        test_1        |             		AS tab_70145
        test_1        |             ORDER BY
        test_1        |             	col_114445 NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |             	*
        test_1        |             FROM
        test_1        |             	(
        test_1        |             		SELECT
        test_1        |             			tab_70144.col_114444 AS col_114445
        test_1        |             		FROM
        test_1        |             			(VALUES (st_zmflag(NULL::GEOMETRY)::INT2), (1::INT8), (9::INT8), (8::INT8), (1::INT8))
        test_1        |             				AS tab_70144 (col_114444)
        test_1        |             	)
        test_1        |             		AS tab_70145
        test_1        |             ORDER BY
        test_1        |             	col_114445 NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...
        
    compose_test.go:49: exit status 1
Reproduce

To reproduce, try:

make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience @rafiss

This test on roachdash | Improve this report!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

No branches or pull requests

4 participants