search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.9k stars 3.78k forks source link

roachtest: sqlsmith/setup=empty/setting=no-mutations failed #42096

Closed cockroach-teamcity closed 4 years ago

cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/62801ce77d9055c00b0e30010f5998ea2cd86686

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1568253&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=provisional_201911010137_v19.2.0-rc.3, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191101-1568253/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:95,sqlsmith.go:100,sqlsmith.go:129,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            e'a\x0f\b/\x02_\x051?':::STRING:::NAME AS col_22125,
            tab_12876.col_22124 AS col_22126,
            tab_12873.col_22121 AS col_22127,
            tab_12874.col_22122 AS col_22128
        FROM
            (
                VALUES
                    (276189139:::INT8),
                    (NULL),
                    (363683333:::INT8),
                    ((-1003680787):::INT8),
                    (1562354338:::INT8),
                    ((-977838377):::INT8)
            )
                AS tab_12873 (col_22121)
            CROSS JOIN (VALUES (e'\x04D\x11=UF%':::STRING)) AS tab_12874 (col_22122)
            JOIN (
                    VALUES
                        ('':::STRING),
                        (e'\x02d82G':::STRING),
                        (sha256(NULL::STRING)::STRING),
                        (e'\U00002603':::STRING),
                        ('-Zw_q':::STRING),
                        (
                            CASE
                            WHEN true THEN 'RwM2P_1B':::STRING
                            ELSE (e'\t':::STRING::STRING || e'#u]l\x07`o\x1b':::STRING::STRING)::STRING
                            END
                        )
                )
                    AS tab_12875 (col_22123) ON (tab_12874.col_22122) = (tab_12875.col_22123)
            JOIN (
                    VALUES
                        ('m0%/b-':::STRING:::NAME),
                        (NULL),
                        (CASE WHEN false THEN 'K':::STRING:::NAME ELSE e'm\x035m\'<\'f':::STRING:::NAME END),
                        (e'\x13W\x11R\x1b5Tw':::STRING:::NAME),
                        (e'\U00002603':::STRING),
                        (e'\x0b\x17\x04JB\x11Y':::STRING:::NAME)
                )
                    AS tab_12876 (col_22124) ON
                    (tab_12875.col_22123) = (tab_12876.col_22124) AND (tab_12874.col_22122) = (tab_12876.col_22124)
        WHERE
            true
        LIMIT
            31:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/ca3615568aa509606410d36bc7cd70eec0484c26

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1580962&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191108-1580962/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:148,sqlsmith.go:159,test_runner.go:697: ping: dial tcp 34.70.198.253:26257: connect: connection refused
        previous sql:
        SELECT
            tab_2430.col_4199 AS col_4210,
            tab_2429.col_4198 AS col_4211,
            '-25 years -2 mons -674 days -24:51:00.864655':::INTERVAL AS col_4212,
            tab_2437.col_4208 AS col_4213,
            tab_2428.col_4197 AS col_4214
        FROM
            (
                VALUES
                    (ARRAY[3176488464:::OID]),
                    (ARRAY[1989283353:::OID]),
                    (ARRAY[25852956:::OID,1221471221:::OID,3474616352:::OID,3208489320:::OID,201884782:::OID,3504415524:::OID]),
                    (ARRAY[3219560933:::OID,4099100264:::OID])
            )
                AS tab_2428 (col_4197),
            (VALUES (())) AS tab_2429 (col_4198),
            (
                VALUES
                    ('10:43:36.55993':::TIME),
                    ('11:09:05.233721':::TIME),
                    ('00:31:55.145509':::TIME),
                    (('05:50:41.269292':::TIME::TIME + NULL::INTERVAL)::TIME),
                    ('13:53:46.523331':::TIME),
                    ('00:00:00':::TIME)
            )
                AS tab_2430 (col_4199),
            (
                VALUES
                    (
                        '{"DEYc~%WM{": 0.02907620802905439, "L?lm!#": {"foobar": []}, "baz": [{}], "c": {}, "foobar": {}, "j1P2HT?/": {"4UHwAUL": []}}':::JSONB
                    ),
                    (NULL)
            )
                AS tab_2437 (col_4208)
            LEFT JOIN (
                    VALUES
                        (NULL),
                        ('-8 years -4 mons -145 days -22:24:22.866105':::INTERVAL),
                        ('21 years 9 mons 459 days 16:58:48.494789':::INTERVAL),
                        ('1 year 10 mons 828 days 07:26:10.020081':::INTERVAL),
                        ('-29 years -6 mons -755 days -22:45:25.598176':::INTERVAL)
                )
                    AS tab_2438 (col_4209) ON false
        WHERE
            true
        ORDER BY
            tab_2429.col_4198 ASC, tab_2429.col_4198 DESC, tab_2428.col_4197 DESC;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/e206eec2aaac3620d1d27873b830bc5f781c94aa

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1580926&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191108-1580926/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:122,sqlsmith.go:127,sqlsmith.go:159,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            tab_7634.col_13120 AS col_13134,
            tab_7632.col_13117 AS col_13135,
            (
                WITH
                    with_2297 (col_13136)
                        AS (
                            SELECT
                                *
                            FROM
                                (VALUES (e'\x1fhn6d\x14T':::STRING), ('':::STRING), (e'\x10\x03\x7f':::STRING))
                                    AS tab_7646 (col_13136)
                        ),
                    with_2298 (col_13137)
                        AS (
                            SELECT
                                *
                            FROM
                                (
                                    VALUES
                                        (ltrim(e'.N1\x01ABx':::STRING::STRING)::STRING),
                                        (NULL),
                                        ('%OqKz':::STRING),
                                        (':0':::STRING),
                                        ('08':::STRING)
                                )
                                    AS tab_7647 (col_13137)
                        )
                SELECT
                    3391302140:::OID AS col_13138
                LIMIT
                    1:::INT8
            )
                AS col_13139,
            tab_7633.col_13119 AS col_13140,
            NULL AS col_13141,
            e'%\x05_xv':::STRING AS col_13142
        FROM
            (VALUES ('$M':::STRING, 946323484:::OID)) AS tab_7632 (col_13117, col_13118)
            JOIN (VALUES ((-0.3094296229652135):::FLOAT8)) AS tab_7633 (col_13119)
                LEFT JOIN (VALUES (e'@X*\b':::STRING), ('N':::STRING)) AS tab_7634 (col_13120) ON true ON
                    (tab_7632.col_13117) = (tab_7634.col_13120)
            JOIN (
                    VALUES
                        (e'TQ\x11th \x19\x16B':::STRING:::NAME, 4163452165:::OID),
                        (e'~Q\r\x16\x14g|\x10':::STRING:::NAME, 2553060732:::OID)
                )
                    AS tab_7645 (col_13132, col_13133) ON
                    (tab_7634.col_13120) = (tab_7645.col_13132)
                    AND (tab_7632.col_13117) = (tab_7645.col_13132)
                    AND (tab_7632.col_13118) = (tab_7645.col_13133)
        LIMIT
            53:::INT8;
maddyblue commented 4 years ago

See #42320

cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/33b96613ae532b25a1b6b716453bece9b60ba2d6

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1583742&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191109-1583742/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:132,sqlsmith.go:159,test_runner.go:697: error: pq: internal error: crdb_internal.encode_key(): expected tuple argument for row_tuple, found ARRAY[-26576,-5140]
        stmt:
        WITH
            with_1634 (col_9044)
                AS (
                    SELECT * FROM (VALUES ('\x9d9232671f':::BYTES), ('\x27':::BYTES), ('\x65':::BYTES)) AS tab_5233 (col_9044)
                    EXCEPT ALL
                        SELECT
                            *
                        FROM
                            (
                                VALUES
                                    (
                                        (
                                            WITH
                                                with_1631 (col_9046)
                                                    AS (
                                                        SELECT
                                                            ('1970-01-08 22:50:51.000394+00:00':::TIMESTAMP, e'\x06/Z|t\x0eQ':::STRING)
                                                                AS col_9046
                                                        FROM
                                                            (VALUES (0.20404887199401855:::FLOAT8)) AS tab_5234 (col_9045)
                                                        WHERE
                                                            false
                                                    ),
                                                with_1632 (col_9047)
                                                    AS (
                                                        SELECT
                                                            *
                                                        FROM
                                                            (
                                                                VALUES
                                                                    ('7cc0:641b:ea5a:8f4a:edf1:a5cd:9b0f:84b/46':::INET),
                                                                    ('200.12.165.193/20':::INET)
                                                            )
                                                                AS tab_5235 (col_9047)
                                                    ),
                                                with_1633 (col_9048)
                                                    AS (
                                                        SELECT
                                                            *
                                                        FROM
                                                            (
                                                                VALUES
                                                                    (e'%\x17':::STRING),
                                                                    ('"':::STRING),
                                                                    (CASE WHEN true THEN 'Ly-~PX':::STRING ELSE NULL END),
                                                                    (e'/\x0f\x10,qp':::STRING),
                                                                    (e'YY\nJ<':::STRING),
                                                                    ('O':::STRING)
                                                            )
                                                                AS tab_5236 (col_9048)
                                                    )
                                            SELECT
                                                '\xe29883':::BYTES AS col_9049
                                            FROM
                                                with_1632
                                            WHERE
                                                true
                                            LIMIT
                                                1:::INT8
                                        )
                                    ),
                                    (
                                        crdb_internal.encode_key((-2803981947708081006):::INT8::INT8, (-6798174891683570416):::INT8::INT8, ARRAY[(-26576):::INT8,(-5140):::INT8])::BYTES
                                    ),
                                    (
                                        (((left(NULL::BYTES, (-3750800264680562105):::INT8::INT8)::BYTES::BYTES || '\xd9c88e28031b':::BYTES::BYTES)::BYTES::BYTES || '\x71be78c57378':::BYTES::BYTES)::BYTES::BYTES || '\x':::BYTES::BYTES)::BYTES
                                    ),
                                    (
                                        ('\xe6c7894c4d6e9634':::BYTES::BYTES || (NULL::BYTES || '\x':::BYTES::BYTES)::BYTES::BYTES)::BYTES
                                    )
                            )
                                AS tab_5237 (col_9050)
                )
        SELECT
            with_1634.col_9044 AS col_9051
        FROM
            with_1634
        LIMIT
            41:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/c019acf1ed7afc16e04dfe324d1b98b84d39a489

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1583760&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191109-1583760/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:122,sqlsmith.go:127,sqlsmith.go:159,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            1283017636:::OID AS col_15761
        FROM
            (VALUES (1088690292:::OID)) AS tab_9114 (col_15744)
            JOIN (VALUES (9191:::INT8), (0:::INT8), (NULL), (NULL)) AS tab_9123 (col_15754)
                LEFT JOIN (
                        VALUES
                            (NULL, 3153751005:::OID),
                            (NULL, 881543904:::OID),
                            (21.83662943489434700:::DECIMAL, 2177089442:::OID),
                            (5485.895938676097263:::DECIMAL, 2170528729:::OID),
                            (67136648046.09861851:::DECIMAL, 1087788058:::OID),
                            (1.938235851590911473E+37:::DECIMAL, 3955527586:::OID)
                    )
                        AS tab_9124 (col_15755, col_15756) ON true ON (tab_9114.col_15744) = (tab_9124.col_15756)
            JOIN (
                    VALUES
                        (3145059484:::OID),
                        (2745685194:::OID),
                        (
                            (
                                WITH
                                    with_2931 (col_15757)
                                        AS (
                                            SELECT
                                                *
                                            FROM
                                                (
                                                    VALUES
                                                        ('Y#[':::STRING),
                                                        (NULL),
                                                        (e'f-\x0bu\x16,"+}':::STRING),
                                                        (e'Q][4!T\x02\t':::STRING),
                                                        (e'\x10o\x13\x05':::STRING),
                                                        (NULL)
                                                )
                                                    AS tab_9125 (col_15757)
                                        )
                                SELECT
                                    75403988:::OID AS col_15759
                                FROM
                                    with_2931,
                                    (
                                        VALUES
                                            (
                                                ((-0.549849527693626):::FLOAT8::FLOAT8 % (-0.6047212299091296):::FLOAT8::FLOAT8)::FLOAT8
                                            ),
                                            ((-1.3362896713705368):::FLOAT8),
                                            (0.0:::FLOAT8),
                                            (NULL)
                                    )
                                        AS tab_9126 (col_15758)
                                WHERE
                                    true
                                ORDER BY
                                    tab_9126.col_15758 DESC,
                                    tab_9126.col_15758 DESC,
                                    tab_9126.col_15758 ASC,
                                    tab_9126.col_15758 DESC
                                LIMIT
                                    1:::INT8
                            )
                        ),
                        (1472439862:::OID),
                        (NULL)
                )
                    AS tab_9127 (col_15760) ON
                    (tab_9124.col_15756) = (tab_9127.col_15760) AND (tab_9114.col_15744) = (tab_9127.col_15760)
        ORDER BY
            tab_9114.col_15744;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/35e138aa3c2be545fb4e17a85ea6f1b8d6525e53

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1584763&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191110-1584763/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:132,sqlsmith.go:159,test_runner.go:697: error: pq: internal error: (-0E-2019):::DECIMAL: could not evaluate -0E-2019 as Datum type DDecimal from string "0E-2019": could not parse "0E-2019" as type decimal
        stmt:
        SELECT
            ((-32768):::INT8::INT8 / 'Infinity':::DECIMAL::DECIMAL)::DECIMAL AS col_53733
        FROM
            (
                VALUES
                    ((-4726.797108829346824):::DECIMAL),
                    (
                        ((-7699357974547236125):::INT8::INT8 - (SELECT 2069538.112722205418:::DECIMAL AS col_53731 FROM (VALUES (gen_random_uuid()::UUID), ('27dcd916-2806-4509-98d7-d57c9d764ec2':::UUID)) AS tab_31368 (col_53723), (VALUES (32767:::INT8), (0:::INT8), (12115:::INT8), ((-32768):::INT8), (NULL)) AS tab_31369 (col_53724), (VALUES (()), (())) AS tab_31372 (col_53727) RIGHT JOIN (VALUES (12096465:::OID)) AS tab_31373 (col_53728) ON (false <= EXISTS (SELECT (-0.10578090149288832):::FLOAT8 AS col_53729, ARRAY[e'x ji:\bfL':::STRING,'':::STRING] AS col_53730 LIMIT 80:::INT8)) LIMIT 1:::INT8)::DECIMAL)::DECIMAL
                    ),
                    ((-6207.127676703607420):::DECIMAL),
                    (78023723898.9099592:::DECIMAL),
                    (
                        (3180744173600309833:::DECIMAL::DECIMAL + array_position(ARRAY['10:47:12.620217':::TIME,'18:36:58.309049':::TIME,'23:11:34.813569':::TIME,'21:47:06.713274':::TIME]::TIME[], '00:00:00':::TIME::TIME)::INT8::INT8)::DECIMAL
                    ),
                    ((1780308031640749062:::INT8::INT8 - (-8.823062468032812271E+36):::DECIMAL::DECIMAL)::DECIMAL)
            )
                AS tab_31374 (col_53732)
        ORDER BY
            tab_31374.col_53732 DESC
        LIMIT
            12:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/64162f27783bd59799531ff977f0fd1d0fd5ae86

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1587139&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191112-1587139/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:122,sqlsmith.go:127,sqlsmith.go:159,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            e'2\x03G':::STRING AS col_22237,
            1735712089:::OID AS col_22238,
            '':::STRING:::NAME AS col_22239,
            e'(\x171\rZ}\\F~':::STRING:::NAME AS col_22240,
            NULL AS col_22241
        FROM
            (VALUES (NULL), (e'~w0\x0fo/\x1d':::STRING:::NAME)) AS tab_12629 (col_22226)
            JOIN (VALUES (2844966425:::OID)) AS tab_12636 (col_22233)
                JOIN (VALUES (e';\x12"\x02$KS\x10':::STRING:::NAME)) AS tab_12637 (col_22234)
                    JOIN (
                            VALUES
                                (1685816986:::OID),
                                (448292014:::OID),
                                (1083487482:::OID),
                                (2642294000:::OID),
                                (1466800321:::OID)
                        )
                            AS tab_12638 (col_22235) ON true ON (tab_12636.col_22233) = (tab_12638.col_22235)
                JOIN (
                        VALUES
                            (e'\b':::STRING),
                            (e'[\x1dz':::STRING),
                            ('':::STRING),
                            (e'~C\x10\x1a"G':::STRING),
                            (e'\U00002603':::STRING),
                            (e'\x1e\x11NDsk^':::STRING)
                    )
                        AS tab_12639 (col_22236) ON (tab_12637.col_22234) = (tab_12639.col_22236) ON
                    (tab_12629.col_22226) = (tab_12639.col_22236)
        ORDER BY
            tab_12638.col_22235 ASC, tab_12636.col_22233 DESC, tab_12637.col_22234 DESC;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/53eef0857d14cc3af720e136ddaff4eeab026fd0

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1599080&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=provisional_201911182308_v19.2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191119-1599080/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
        WITH
            with_9881 (col_54231)
                AS (
                    SELECT
                        *
                    FROM
                        (
                            VALUES
                                ('-infinity':::DATE),
                                (('-infinity':::DATE::DATE + (-32768):::INT8::INT8)::DATE),
                                ('1978-07-10':::DATE),
                                ('1970-04-05':::DATE)
                        )
                            AS tab_31346 (col_54231)
                ),
            with_9882 (col_54232)
                AS (SELECT * FROM (VALUES (ARRAY[1429550819:::OID,2888852957:::OID,2332501871:::OID])) AS tab_31347 (col_54232))
        SELECT
            2167485447:::OID AS col_54269,
            tab_31349.col_54236 AS col_54270,
            NULL AS col_54271,
            tab_31376.col_54267 AS col_54272,
            2747702240:::OID AS col_54273,
            (-0.7245449423789978):::FLOAT8 AS col_54274
        FROM
            (
                VALUES
                    (3521003959:::OID, '1970-01-11 04:25:09.000007+00:00':::TIMESTAMP, 0.3248130679130554:::FLOAT8),
                    (3485516639:::OID, '1970-01-02 22:05:42.000936+00:00':::TIMESTAMP, 1.1111056804656982:::FLOAT8)
            )
                AS tab_31348 (col_54233, col_54234, col_54235)
            JOIN (VALUES (3040482128:::OID), (2809398784:::OID), (4237430986:::OID), (NULL), (3901397203:::OID))
                    AS tab_31349 (col_54236) ON (tab_31348.col_54233) = (tab_31349.col_54236)
            JOIN (
                    SELECT
                        tab_31375.col_54265 AS col_54266
                    FROM
                        (VALUES (3368753020:::OID)) AS tab_31375 (col_54265)
                    WHERE
                        true
                    LIMIT
                        48:::INT8
                )
                    AS tab_31376 (col_54267)
                JOIN (VALUES (NULL), (2697693004:::OID), (1627320076:::OID)) AS tab_31377 (col_54268) ON
                        (tab_31376.col_54267) = (tab_31377.col_54268) ON (tab_31349.col_54236) = (tab_31376.col_54267)
        WHERE
            true
        ORDER BY
            tab_31376.col_54267 DESC, tab_31376.col_54267 ASC, tab_31348.col_54235, tab_31376.col_54267 ASC;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/205330426e50b966ede8a4644d77570d8265fe66

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1602072&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

                                                    AS tab_32736 (col_56906) ON (NULL <= false)
                                        LIMIT
                                            1:::INT8
                                    )
                                ),
                                (3715529923:::OID)
                        )
                            AS tab_32737 (col_56908)
                )
        SELECT
            tab_32745.col_56922 AS col_56925,
            25085:::INT8 AS col_56926,
            (
                WITH
                    with_10383 (col_56927)
                        AS (
                            SELECT
                                *
                            FROM
                                (VALUES (B'011011000100001110110001011'), (B'111101001100101010111111111'))
                                    AS tab_32748 (col_56927)
                        ),
                    with_10384 (col_56928)
                        AS (
                            SELECT * FROM (VALUES ('-infinity':::DATE)) AS tab_32749 (col_56928)
                            EXCEPT ALL
                                SELECT
                                    *
                                FROM
                                    (
                                        VALUES
                                            ('1990-09-11':::DATE),
                                            ('1988-11-01':::DATE),
                                            (NULL),
                                            (now():::DATE::DATE),
                                            ('1986-06-23':::DATE),
                                            ('1982-02-03':::DATE)
                                    )
                                        AS tab_32750 (col_56929)
                        )
                SELECT
                    tab_32747.col_56924 AS col_56930
                FROM
                    with_10384
                ORDER BY
                    with_10384.col_56928 DESC, with_10384.col_56928
                LIMIT
                    1:::INT8
            )
                AS col_56931
        FROM
            (
                VALUES
                    (
                        (
                            WITH
                                with_10381 (col_56909, col_56910)
                                    AS (
                                        SELECT
                                            *
                                        FROM
                                            (
                                                VALUES
                                                    (NULL, ARRAY[2102481735:::OID]),
                                                    ('qG':::STRING, ARRAY[2175770297:::OID]),
                                                    ('"':::STRING, NULL),
                                                    (NULL, ARRAY[589948189:::OID,1484186854:::OID]),
                                                    (e'l\x05O':::STRING, ARRAY[1242257986:::OID,857222811:::OID]),
                                                    (e'<E\f8CO':::STRING, ARRAY[2676806369:::OID,787665363:::OID])
                                            )
                                                AS tab_32738 (col_56909, col_56910)
                                    ),
                                with_10382 (col_56911, col_56912, col_56913)
                                    AS (
                                        SELECT
                                            *
                                        FROM
                                            (
                                                VALUES
                                                    (e'\x10+j':::STRING:::NAME, 1805548927:::OID, NULL),
                                                    (
                                                        e'UALd/~\x05\x14y':::STRING:::NAME,
                                                        360561442:::OID,
                                                        e'\x17{z\x0e1':::STRING
                                                    ),
                                                    ('':::STRING:::NAME, 1922604094:::OID, e'U\'j\'}T5':::STRING)
                                            )
                                                AS tab_32739 (col_56911, col_56912, col_56913)
                                    )
                            SELECT
                                CASE WHEN true THEN 1103439235:::OID ELSE NULL END AS col_56918
                            FROM
                                (
                                    VALUES
                                        (e'\x05k':::STRING),
                                        (
                                            CASE
                                            WHEN true
                                            THEN CASE
                                            WHEN true THEN e'\U00002603':::STRING
                                            ELSE (
                                                SELECT
                                                    e'b\x06\x7f\x0bWV~%F':::STRING AS col_56916
                                                FROM
                                                    (
                                                        VALUES
                                                            (
                                                                ARRAY[14189:::INT8,7705:::INT8,(-6672):::INT8],
                                                                '11:12:10.895458-05:08:00':::TIMETZ
                                                            ),
                                                            (
                                                                ARRAY[(-1312):::INT8,17254:::INT8,(-128):::INT8,4328:::INT8],
                                                                '21:57:35.430317+08:40:00':::TIMETZ
                                                            ),
                                                            (
                                                                ARRAY[(-4316):::INT8,6985:::INT8,10489:::INT8],
                                                                '23:40:28.908814-13:53:00':::TIMETZ
                                                            )
                                                    )
                                                        AS tab_32740 (col_56914, col_56915)
                                                ORDER BY
                                                    tab_32740.col_56915 DESC
                                                LIMIT
                                                    1:::INT8
                                            )
                                            END
                                            ELSE NULL
                                            END
                                        ),
                                        ('M)o`:qiu':::STRING),
                                        (e'+1{\'\x10f\f\x1f':::STRING),
                                        (NULL)
                                )
                                    AS tab_32741 (col_56917)
                            WHERE
                                true
                            ORDER BY
                                tab_32741.col_56917, tab_32741.col_56917
                            LIMIT
                                1:::INT8
                        )
                    )
            )
                AS tab_32742 (col_56919)
            LEFT JOIN (VALUES (NULL), (NULL)) AS tab_32745 (col_56922)
                JOIN (VALUES ((-8020):::INT8), ((-4665):::INT8), (NULL)) AS tab_32746 (col_56923) ON false
                JOIN (VALUES ((-2471701940753288024):::INT8), (507624647751627292:::INT8), ((-4016769928661210735):::INT8))
                        AS tab_32747 (col_56924) ON (tab_32746.col_56923) = (tab_32747.col_56924) ON false
        WHERE
            true
        ORDER BY
            tab_32747.col_56924 ASC
        LIMIT
            44:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/668b66da0b4c7789fb13d77c43334c99a7e65793

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1604967&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191122-1604967/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            tab_21594.col_37228 AS col_37243
        FROM
            (
                VALUES
                    (NULL),
                    ('1970-01-04 15:51:36.000303+00:00':::TIMESTAMP),
                    ('1970-01-09 21:14:30.000014+00:00':::TIMESTAMP),
                    ('1970-01-03 10:47:14.00069+00:00':::TIMESTAMP),
                    ('0001-01-01 00:00:00+00:00':::TIMESTAMP),
                    ('1970-01-10 15:55:35.000356+00:00':::TIMESTAMP)
            )
                AS tab_21571 (col_37200)
            JOIN (
                    VALUES
                        (
                            ARRAY[3872464403:::OID,2835717620:::OID,1995703327:::OID,1523958392:::OID,1896470390:::OID,1192760345:::OID],
                            2229192368:::OID
                        ),
                        (ARRAY[1643745201:::OID,1538164157:::OID], NULL)
                )
                    AS tab_21594 (col_37228, col_37229)
                JOIN (
                        SELECT
                            tab_21597.col_37233 AS col_37234, B'0001110010011111101000011011000100001' AS col_37235
                        FROM
                            (
                                VALUES
                                    (B'1101100000110110011110101000001011000', 3994384486:::OID),
                                    (B'0000110101110100110011101111101001011', NULL),
                                    (B'0111100001001110110001111001111000010', 526005613:::OID),
                                    (B'1110100101000100111010011101110001101', 466565082:::OID)
                            )
                                AS tab_21597 (col_37232, col_37233)
                        WHERE
                            true
                        ORDER BY
                            tab_21597.col_37232 DESC, tab_21597.col_37232 DESC, tab_21597.col_37233 ASC, tab_21597.col_37232
                        LIMIT
                            59:::INT8
                    )
                        AS tab_21598 (col_37236, col_37237) ON (tab_21594.col_37229) = (tab_21598.col_37236)
                JOIN (
                        VALUES
                            (
                                CASE
                                WHEN true THEN '1970-01-04 02:08:51.000302+00:00':::TIMESTAMP
                                ELSE '1970-01-04 23:48:44.000517+00:00':::TIMESTAMP
                                END,
                                (-1.6456781334896229):::FLOAT8
                            ),
                            ('1970-01-08 05:17:40.000267+00:00':::TIMESTAMP, 0.8549130903096035:::FLOAT8)
                    )
                        AS tab_21601 (col_37240, col_37241)
                    RIGHT JOIN (VALUES (3474568038:::OID)) AS tab_21602 (col_37242) ON true ON
                        (tab_21594.col_37229) = (tab_21602.col_37242) AND (tab_21598.col_37236) = (tab_21602.col_37242) ON
                    (tab_21571.col_37200) = (tab_21601.col_37240)
        WHERE
            true
        LIMIT
            94:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/2e1807ad6ac9656d2afa40cda6533f6a29e80383

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1606971&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191123-1606971/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            2448469873:::OID AS col_877,
            tab_522.col_871 AS col_878,
            tab_522.col_874 AS col_879,
            2487622612:::OID AS col_880,
            tab_522.col_872 AS col_881,
            B'1011100100000001111100100000000010000101' AS col_882,
            1481117832:::OID AS col_883,
            tab_523.col_876 AS col_884
        FROM
            (VALUES (2907713860:::OID), (2096480120:::OID), (NULL), (2302165140:::OID), (2881611343:::OID)) AS tab_463 (col_782)
            JOIN (VALUES (2218905934:::OID)) AS tab_518 (col_860)
                JOIN (
                        SELECT
                            tab_521.col_865 AS col_867,
                            tab_521.col_866 AS col_868,
                            tab_520.col_864 AS col_869,
                            tab_521.col_865 AS col_870
                        FROM
                            (
                                VALUES
                                    ((-1882536780):::INT8, 130784023:::OID),
                                    (
                                        (
                                            SELECT
                                                (-1862020049):::INT8 AS col_862
                                            FROM
                                                (
                                                    VALUES
                                                        ('54fc5e80-d24b-4d9b-a840-cb297eb5f3fc':::UUID),
                                                        (NULL),
                                                        (crdb_internal.cluster_id()::UUID),
                                                        ('714681b9-735d-4db8-875a-e358fb8928a1':::UUID),
                                                        ('55374879-c64a-49aa-87f9-0dcb4f38de17':::UUID)
                                                )
                                                    AS tab_519 (col_861)
                                            LIMIT
                                                1:::INT8
                                        ),
                                        4263028782:::OID
                                    )
                            )
                                AS tab_520 (col_863, col_864),
                            (
                                VALUES
                                    ((-1101004050):::INT8, e'\x10':::STRING:::NAME),
                                    (322346995:::INT8, e'W\x13\x1f3N':::STRING:::NAME),
                                    (2032768468:::INT8, COALESCE(e'j\x01U\\Z\x1a':::STRING:::NAME, NULL)),
                                    (127:::INT8, e')\x16c':::STRING:::NAME),
                                    (40607024:::INT8, NULL)
                            )
                                AS tab_521 (col_865, col_866)
                        LIMIT
                            8:::INT8
                    )
                        AS tab_522 (col_871, col_872, col_873, col_874) ON (tab_518.col_860) = (tab_522.col_873)
                CROSS JOIN (
                        VALUES
                            (B'1101010111011000101111001101010000010110', gen_random_uuid()::UUID),
                            (NULL, NULL),
                            (B'1011111111011110001001011111010101100110', '4f4d6925-981a-4587-b53f-ce57116eca65':::UUID),
                            (B'1010000111111110010101010110100110001111', 'a7ded181-7383-4270-824a-f8d1de7abf3a':::UUID),
                            (B'0110101000010111111111011101100011111110', NULL)
                    )
                        AS tab_523 (col_875, col_876) ON
                    (tab_463.col_782) = (tab_522.col_873) AND (tab_463.col_782) = (tab_518.col_860)
        WHERE
            true
        ORDER BY
            tab_463.col_782,
            tab_523.col_876 DESC,
            tab_522.col_873 ASC,
            tab_518.col_860 DESC,
            tab_522.col_873 ASC,
            tab_518.col_860 ASC,
            tab_463.col_782 ASC;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/7dec3577461a1e53ea70582de62bbd96bf512b73

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1614006&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

                                            FROM
                                                (
                                                    VALUES
                                                        (
                                                            '{"&:T <!Jh3M~": [true], "UBR9@+vSX": {}, "a": {}, "bar": {"baz": {"baz": 1.5398153826172927}, "foo": [[], true]}, "foobar": [{}]}':::JSONB,
                                                            '+Inf':::FLOAT8,
                                                            e'z0x$+N\x0b':::STRING:::NAME,
                                                            ('1973-12-27':::DATE::DATE + '14 years 1 mon 861 days 12:39:45.153873':::INTERVAL::INTERVAL)::TIMESTAMP
                                                        ),
                                                        (
                                                            '{")Z%_(t/J^H[X": [], "bar": {"a": 1.8069320696175035, "baz": {"[9|W": []}, "foobar": [{}, []], "{XdT$tS9$}5*": {"b": {}}}, "c": {"X(1TS2)/Bt": {}, "c": {"uOfrXiX|<8": []}}}':::JSONB,
                                                            NULL,
                                                            e'\x15bm':::STRING:::NAME,
                                                            '1970-01-07 12:18:05.000627+00:00':::TIMESTAMP
                                                        ),
                                                        (
                                                            json_set('false':::JSONB::JSONB, ARRAY[e'\x02sI\'':::STRING,e'\x0f07=*7\x02]\x19':::STRING,e')7\x16f\x0f':::STRING]::STRING[], e'{"b": [{"*\'z@vu_ei": {}, "am\\"^B1$v": {}}, false], "foo": {"PeRBpd%+&]$": {}, "bar": {}, "baz": true}, "foobar": {"\\\\/~": true, "a": []}, "{Wb": {"/JiUi:": []}}':::JSONB::JSONB, NULL::BOOL)::JSONB,
                                                            (-1.3255504369735718):::FLOAT8,
                                                            '':::STRING:::NAME,
                                                            '1970-01-12 03:48:38.000329+00:00':::TIMESTAMP
                                                        )
                                                )
                                                    AS tab_11839 (col_20432, col_20433, col_20434, col_20435)
                                                JOIN (VALUES (e'N~^\x15':::STRING)) AS tab_11840 (col_20436) ON
                                                        (tab_11839.col_20434) = (tab_11840.col_20436)
                                            LIMIT
                                                1:::INT8
                                        ),
                                        ARRAY[2063563622:::OID]
                                    ),
                                    (
                                        ARRAY[]:::INT2[],
                                        ARRAY[634932818:::OID,3446172997:::OID,360567540:::OID,2254144606:::OID],
                                        ARRAY[283584450:::OID,1315477866:::OID,1555820322:::OID,409052976:::OID]
                                    ),
                                    (NULL, ARRAY[2113535948:::OID,3968716894:::OID], ARRAY[915347194:::OID,1322982149:::OID]),
                                    (
                                        ARRAY[]:::INT2[],
                                        NULL,
                                        ARRAY[735551013:::OID,3587337638:::OID,4192723228:::OID,1203004750:::OID]
                                    ),
                                    (ARRAY[581:::INT8,16494:::INT8,(-18929):::INT8,(-18295):::INT8], NULL, ARRAY[]:::OID[]),
                                    (
                                        NULL,
                                        ARRAY[819991657:::OID,1356789955:::OID,929889898:::OID,4293346925:::OID],
                                        ARRAY[2534493789:::OID,1655317562:::OID,3933066812:::OID,689330205:::OID,4277643086:::OID]
                                    )
                            )
                                AS tab_11841 (col_20438, col_20439, col_20440)
                ),
            with_3691 (col_20443)
                AS (
                    SELECT
                        *
                    FROM
                        (
                            VALUES
                                (NULL),
                                (ARRAY[516317689:::OID,52178451:::OID]),
                                (ARRAY[2105038669:::OID,442934989:::OID,2879761096:::OID]),
                                (NULL),
                                (ARRAY[2962558636:::OID]),
                                (
                                    (
                                        WITH
                                            with_3690 (col_20441)
                                                AS (
                                                    SELECT
                                                        *
                                                    FROM
                                                        (
                                                            VALUES
                                                                ('false':::JSONB),
                                                                (
                                                                    '{"UUmQA+": [{"baz": true}, true, "foobar", {"foobar": false}, []], "o!:jhSW_0& ": true}':::JSONB
                                                                ),
                                                                (
                                                                    ('{"<757fQn!b9i9": [[2.0558047997978677, 1.1550343183606646, {}], [{"bar": {"wn^V:b8T": [], "}gM^4 ": {"/O Z/8": true}}}], {"b": false, "bar": [], "zv<d": {}}, ":Gyz4"], "bar": {}}':::JSONB::JSONB->e'\x10\'\x10V"':::STRING::STRING)::JSONB
                                                                )
                                                        )
                                                            AS tab_11842 (col_20441)
                                                )
                                        SELECT
                                            NULL AS col_20442
                                        LIMIT
                                            1:::INT8
                                    )
                                )
                        )
                            AS tab_11843 (col_20443)
                    UNION
                        SELECT
                            *
                        FROM
                            (
                                VALUES
                                    (
                                        ARRAY[278475754:::OID,3610733654:::OID,4052948777:::OID,3186491771:::OID,3743235019:::OID]
                                    ),
                                    (ARRAY[3979339638:::OID,2323059566:::OID]),
                                    (ARRAY[200181142:::OID]),
                                    (ARRAY[1777777526:::OID,2987655173:::OID])
                            )
                                AS tab_11844 (col_20444)
                )
        SELECT
            with_3689.col_20426 AS col_20445, with_3689.col_20424 AS col_20446
        FROM
            with_3689
        LIMIT
            6:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/0da08d85deeafe859345c6898e0aadd0c24236fa

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1613988&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191127-1613988/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:140,sqlsmith.go:145,sqlsmith.go:177,test_runner.go:697: query timed out, but did not cancel execution:
        WITH
            with_397 (col_2347)
                AS (
                    SELECT
                        2504294662:::OID AS col_2347
                    FROM
                        (
                            VALUES
                                (e'\x00':::STRING, NULL),
                                ('':::STRING, e'\rY$i1*':::STRING),
                                (e'W\fl]':::STRING, quote_ident(e'|)PpF\x02E':::STRING::STRING)::STRING),
                                (e'd)\x1b.&:\x0e:f':::STRING, 'XNy':::STRING)
                        )
                            AS tab_1370 (col_2345, col_2346)
                    WHERE
                        true
                )
        SELECT
            e'n\x01:X\n\x05J':::STRING AS col_2367,
            '':::STRING:::NAME AS col_2368,
            e'\x1aX':::STRING AS col_2369,
            tab_1382.col_2364 AS col_2370
        FROM
            (VALUES (e'\x13"{?':::STRING), (NULL), ('':::STRING), (current_schema()::STRING)) AS tab_1371 (col_2348)
            JOIN (
                    VALUES
                        (e'gOQhv)d\x13':::STRING),
                        (':':::STRING),
                        (e'}8n\x03(\x12D':::STRING),
                        (CASE WHEN false THEN e'\U00002603':::STRING ELSE e'\'\x07':::STRING END),
                        (e'e?\\.x\x16':::STRING),
                        ('':::STRING)
                )
                    AS tab_1382 (col_2364)
                JOIN (VALUES (e'd\'[Akb)\x15':::STRING:::NAME)) AS tab_1383 (col_2365)
                    JOIN (VALUES (e'\x01vj':::STRING), ('':::STRING), (NULL), (NULL), (e'`j 1\x17\x02':::STRING))
                            AS tab_1384 (col_2366) ON (tab_1383.col_2365) = (tab_1384.col_2366) ON
                        (tab_1382.col_2364) = (tab_1383.col_2365) AND (tab_1382.col_2364) = (tab_1384.col_2366) ON
                    (tab_1371.col_2348) = (tab_1384.col_2366) AND (tab_1371.col_2348) = (tab_1382.col_2364)
        ORDER BY
            tab_1384.col_2366, tab_1384.col_2366 ASC, tab_1383.col_2365 ASC, tab_1382.col_2364 ASC, tab_1383.col_2365 ASC
        LIMIT
            25:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/39bf64d28ee5a0ab79081b8b0b29230749ea0fff

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1616610&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-2.1, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191128-1616610/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:178,sqlsmith.go:189,test_runner.go:697: ping: dial tcp 104.154.156.204:26257: connect: connection refused
        previous sql:
        WITH
            with_1066 (col_6421, col_6422)
                AS (
                    SELECT
                        *
                    FROM
                        (
                            VALUES
                                (false, ARRAY[(-15983):::INT8,(-20826):::INT8,(-18168):::INT8,31870:::INT8]),
                                (true, ARRAY[(-15033):::INT8,(-26618):::INT8,(-32736):::INT8,(-23736):::INT8,22605:::INT8]),
                                (false, ARRAY[]:::INT2[]),
                                (
                                    true,
                                    (
                                        WITH
                                            with_1064 (col_6418)
                                                AS (
                                                    SELECT
                                                        *
                                                    FROM
                                                        (
                                                            VALUES
                                                                (
                                                                    (0.22548700869083405:::FLOAT8, ARRAY[(-4148):::INT8,(-19405):::INT8])
                                                                ),
                                                                (
                                                                    (1.1480259895324707:::FLOAT8, ARRAY[(-962):::INT8,821:::INT8,13085:::INT8,(-607):::INT8])
                                                                )
                                                        )
                                                            AS tab_3718 (col_6418)
                                                ),
                                            with_1065 (col_6419)
                                                AS (
                                                    SELECT
                                                        *
                                                    FROM
                                                        (
                                                            VALUES
                                                                (2208955816:::OID),
                                                                (915474741:::OID),
                                                                (3716975188:::OID),
                                                                (4108021590:::OID),
                                                                (4192892457:::OID)
                                                        )
                                                            AS tab_3719 (col_6419)
                                                )
                                        SELECT
                                            ARRAY[8027:::INT8,(-31966):::INT8] AS col_6420
                                        FROM
                                            with_1064
                                        WHERE
                                            true
                                        GROUP BY
                                            with_1064.col_6418
                                        HAVING
                                            isnan((7661431133377433680:::INT8::INT8 % 6291759178.508112506:::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::BOOL
                                        ORDER BY
                                            with_1064.col_6418 DESC
                                        LIMIT
                                            1:::INT8
                                    )
                                ),
                                (true, ARRAY[(-18778):::INT8,(-7334):::INT8]),
                                (true, ARRAY[25051:::INT8,14826:::INT8,26502:::INT8,27924:::INT8])
                        )
                            AS tab_3720 (col_6421, col_6422)
                )
        SELECT
            ARRAY[e'Z\x143s\x0f`I\fU':::STRING,e'M\x1ba;mH\bU\x1a':::STRING,'X3t':::STRING] AS col_6471
        FROM
            with_1066,
            (
                VALUES
                    (
                        ARRAY[e'b,\x10\x1e\x18r4':::STRING,e'V9T\x1aZrY':::STRING,e'D\x0f\x1a\x02=:F\x013':::STRING,e'+"\x07\x18.?T,':::STRING]
                    ),
                    (ARRAY[]:::STRING[]),
                    (ARRAY[e'8^\r\x19[\'':::STRING,e'K\x02E':::STRING]),
                    (
                        (
                            WITH
                                with_1075 (col_6466, col_6467)
                                    AS (
                                        SELECT
                                            *
                                        FROM
                                            (
                                                VALUES
                                                    (
                                                        ARRAY[(-19505):::INT8,(-18438):::INT8,(-6585):::INT8,3440:::INT8],
                                                        'a38c:9882:f3d:e6e9:d420:68c3:4434:4906/83':::INET
                                                    )
                                            )
                                                AS tab_3754 (col_6466, col_6467)
                                    )
                            SELECT
                                ARRAY[e'\x00':::STRING,'( Tp8K':::STRING,'m;':::STRING] AS col_6468
                            FROM
                                with_1075
                            LIMIT
                                1:::INT8
                        )
                    ),
                    (ARRAY['M':::STRING,'O2':::STRING,e'\x05}M':::STRING,e'4Eh\x0f\x12':::STRING]),
                    (ARRAY[e'_\bg}}\x13\x1f':::STRING,e'\tA)fA':::STRING,e'4J\x1eWCx\n/':::STRING,'=':::STRING])
            )
                AS tab_3755 (col_6469)
            RIGHT JOIN (VALUES (2902003674:::OID), (796304712:::OID), (3800898973:::OID), (3190355853:::OID))
                    AS tab_3756 (col_6470) ON false
        WHERE
            with_1066.col_6421
        GROUP BY
            tab_3755.col_6469
        HAVING
            max(with_1066.col_6421::BOOL)::BOOL
        LIMIT
            29:::INT8;
cockroach-teamcity commented 4 years ago

SHA: https://github.com/cockroachdb/cockroach/commits/60412eb85271ecd1539971fcc6ea3bf11f1ca7a6

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1629609&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191206-1629609/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:153,sqlsmith.go:158,sqlsmith.go:191,test_runner.go:697: query timed out, but did not cancel execution:
        SELECT
            304109260:::OID AS col_23163, tab_13388.col_23155 AS col_23164, crdb_internal.is_admin()::BOOL AS col_23165
        FROM
            (VALUES ((-5033202867079715684):::INT8)) AS tab_13388 (col_23155)
            CROSS JOIN (VALUES ((-750670065683446845):::INT8)) AS tab_13389 (col_23156)
            JOIN (VALUES (4757144890149663518:::INT8), (NULL)) AS tab_13390 (col_23157)
                JOIN (VALUES (6474039176684847865:::INT8), ((-8094981604621893677):::INT8)) AS tab_13391 (col_23158) ON
                        (tab_13390.col_23157) = (tab_13391.col_23158) ON (tab_13389.col_23156) = (tab_13391.col_23158),
            (
                VALUES
                    (false, 0.0:::FLOAT8, '1970-01-04 21:39:22.000535+00:00':::TIMESTAMP, NULL),
                    (true, 0.631945013999939:::FLOAT8, '1970-01-02 02:52:39.00096+00:00':::TIMESTAMP, 2296403682:::OID),
                    (NULL, (-1.169614553451538):::FLOAT8, '1970-01-10 09:24:48.000629+00:00':::TIMESTAMP, 4244318121:::OID),
                    (NULL, '-Inf':::FLOAT8, NULL, 12663514:::OID),
                    (true, (-0.7122394442558289):::FLOAT8, '1970-01-10 11:10:05.00029+00:00':::TIMESTAMP, NULL),
                    (NULL, (-1.0979294776916504):::FLOAT8, '1970-01-01 11:29:05.000983+00:00':::TIMESTAMP, 2243080272:::OID)
            )
                AS tab_13392 (col_23159, col_23160, col_23161, col_23162)
        WHERE
            tab_13392.col_23159
        ORDER BY
            tab_13390.col_23157, tab_13392.col_23161 DESC, tab_13392.col_23162 ASC
        LIMIT
            49:::INT8;
cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on release-19.2@3441d86e83a2c2a5f3f473e480854658ca631d4f:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191212-1640179/sqlsmith/setup=empty/setting=no-mutations/run_1
    cluster.go:1152,cluster.go:1163,sqlsmith.go:98,sqlsmith.go:217,test_runner.go:700: invalid node range: 0-0 (1-4)
details

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1640179&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS=-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on master@e81faed54ee90bdfed1dddc63bb13d1ecf8806da:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191212-1640161/sqlsmith/setup=empty/setting=no-mutations/run_1
    cluster.go:1152,cluster.go:1163,sqlsmith.go:98,sqlsmith.go:217,test_runner.go:700: invalid node range: 0-0 (1-4)
details

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1640161&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS=-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on master@2f1e342c386973c35246bef68c177fcd0b8b609b:

                                                                        with_5259 AS cte_ref_1569
                                                                    WHERE
                                                                        false
                                                                )
                                                        SELECT
                                                            gen_random_uuid()::UUID AS col_30179
                                                        FROM
                                                            with_5259 AS cte_ref_1570
                                                        WHERE
                                                            true
                                                        GROUP BY
                                                            cte_ref_1570.col_30176
                                                        LIMIT
                                                            1:::INT8
                                                    ),
                                                    1614957248:::INT8
                                                )
                                        )
                                            AS tab_17768 (col_30180, col_30181)
                                )
                        SELECT
                            1973366465:::OID AS col_30182
                        FROM
                            with_5262 AS cte_ref_1571
                        LIMIT
                            10:::INT8
                    )
                LIMIT
                    1:::INT8
            )
                AS col_30184
        FROM
            (
                VALUES
                    (2328371065:::OID),
                    (2107801858:::OID),
                    (802586715:::OID),
                    (NULL),
                    (COALESCE(NULL, 2454817269:::OID)),
                    (3595992668:::OID)
            )
                AS tab_17762 (col_30169)
        ORDER BY
            tab_17762.col_30169 DESC,
            tab_17762.col_30169,
            tab_17762.col_30169 ASC,
            tab_17762.col_30169,
            tab_17762.col_30169 DESC
        LIMIT
            95:::INT8;
Repro

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1649932&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on master@a3f81bcbef596f8b8134641526a87f27c4ad8082:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191224-1661395/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: couldn't find With expression with ID 1
        stmt:
        SELECT
            (
                WITH
                    with_2172 (col_11351)
                        AS (
                            SELECT
                                *
                            FROM
                                (
                                    VALUES
                                        (8321747749277506031:::INT8),
                                        (7263317597855997123:::INT8),
                                        (NULL),
                                        (unique_rowid()::INT8),
                                        (3628205234063184384:::INT8)
                                )
                                    AS tab_6428 (col_11351)
                            INTERSECT
                                SELECT
                                    *
                                FROM
                                    (VALUES (9223372036854775807:::INT8), (127:::INT8), (958349665938078439:::INT8))
                                        AS tab_6429 (col_11352)
                        )
                SELECT
                    tab_6427.col_11350 AS col_11353
                FROM
                    with_2172 AS cte_ref_649, with_2172 AS cte_ref_650
                LIMIT
                    1:::INT8
            )
                AS col_11354,
            e'^\x05\rq0>':::STRING AS col_11355
        FROM
            (
                VALUES
                    ('':::STRING, '?':::STRING),
                    (e'K\x15Ek[\x0eA':::STRING, e'n\n\x05K':::STRING),
                    (NULL, e'\x1eXq\x1e+N':::STRING),
                    ('4':::STRING, '3V[%/f':::STRING)
            )
                AS tab_6427 (col_11349, col_11350)
        LIMIT
            41:::INT8;
Repro

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1661395&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on master@8f946b8bb62629002c5e958373b81ca9e1920dd6:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20191228-1665456/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: expected constant FD to be strict: lax-key()
        stmt:
        SELECT
            tab_14919.col_25812 AS col_25814
        FROM
            (VALUES (NULL)) AS tab_14919 (col_25812)
            FULL JOIN (VALUES ('23:59:59.999999':::TIME)) AS tab_14920 (col_25813) ON false
        WHERE
            (NOT NULL);
Repro

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1665456&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on master@a99740bb34c03ab3af7558129edce9c17c88d4f9:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200102-1670273/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:189,sqlsmith.go:217,test_runner.go:716: error: pq: internal error: expected constant FD to be strict: lax-key()
        stmt:
        SELECT
            e'\x1dc6j,X\x03\x1e':::STRING AS col_52461
        FROM
            (VALUES (broadcast('ae43:22ac:9ab1:f4c7:e7f1:6653:c52:2da1/0':::INET::INET)::INET)) AS tab_30134 (col_52459)
            FULL JOIN (VALUES (NULL)) AS tab_30135 (col_52460) ON NULL;
Repro

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1670273&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

cockroach-teamcity commented 4 years ago

(roachtest).sqlsmith/setup=empty/setting=no-mutations failed on release-19.2@7f2413b36fe1ea31a08c3ddd0d1e4b1cd006db37:

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200114-1688037/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:135,sqlsmith.go:224,test_runner.go:716: pq: unrecognized configuration parameter "experimental_enable_primary_key_changes"
Repro

Artifacts: [/sqlsmith/setup=empty/setting=no-mutations](https://teamcity.cockroachdb.com/viewLog.html?buildId=1688037&tab=artifacts#/sqlsmith/setup=empty/setting=no-mutations) ``` make stressrace TESTS=sqlsmith/setup=empty/setting=no-mutations PKG=./pkg/roachtest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)

yuzefovich commented 4 years ago

cc @rohany for the latest failure on this issue

The test failed on branch=release-19.2, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/20200114-1688037/sqlsmith/setup=empty/setting=no-mutations/run_1
    sqlsmith.go:135,sqlsmith.go:224,test_runner.go:716: pq: unrecognized configuration parameter "experimental_enable_primary_key_changes"

it seems we need to make sqlsmith version aware

rohany commented 4 years ago

ack, seems like it. I can probably just check what version the roachtest is running on and not emit that statement if needed.