Skip to content

release-26.3: pkg/sql/sqlstats/sqlstats_test: TestDataDrivenTest failed #172249

Description

@cockroach-teamcity

pkg/sql/sqlstats/sqlstats_test.TestDataDrivenTest failed on release-26.3 @ 6879db81aee3560b4faf87a93a85d59cc0d0da3a:

=== RUN   TestDataDrivenTest
    test_log_scope.go:172: test logs captured to: outputs.zip/logTestDataDrivenTest350410016
    test_log_scope.go:82: use -show-logs to present logs inline
    sqlstats_test.go:99: -- test log scope end --
test logs left over in: outputs.zip/logTestDataDrivenTest350410016
--- FAIL: TestDataDrivenTest (92.61s)
=== RUN   TestDataDrivenTest/plpgsql
    test_server_shim.go:168: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
    test_server_shim.go:639: DRPC is enabled (via testserver factory defaults)
    sqlstats_test.go:73: error executing query="CREATE TABLE IF NOT EXISTS test(a int);\n  CREATE OR REPLACE PROCEDURE insert_incremental(n INT)\n  LANGUAGE plpgsql\n  AS $$\n  DECLARE\n    i INT := 0;\n    next_val INT;\n  BEGIN\n    WHILE i < n LOOP\n      SELECT coalesce(max(a), 0) + 1 INTO next_val FROM test;\n      INSERT INTO test(a) VALUES (next_val);\n      i := i + 1;\n    END LOOP;\n  END;\n  $$;\nCALL insert_incremental(5);" args=[]: pq: function 107 does not exist
    datadriven.go:343: 
        fatal during /mnt/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/sql/sqlstats/sqlstats_test_/sqlstats_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/sqlstats/testdata/plpgsql:1:
        CREATE TABLE IF NOT EXISTS test(a int);
          CREATE OR REPLACE PROCEDURE insert_incremental(n INT)
          LANGUAGE plpgsql
          AS $$
          DECLARE
            i INT := 0;
            next_val INT;
          BEGIN
            WHILE i < n LOOP
              SELECT coalesce(max(a), 0) + 1 INTO next_val FROM test;
              INSERT INTO test(a) VALUES (next_val);
              i := i + 1;
            END LOOP;
          END;
          $$;
        CALL insert_incremental(5);
--- FAIL: TestDataDrivenTest/plpgsql (27.49s)

Parameters:

  • attempt=1
  • race=true
  • run=1
  • shard=1
Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachlabs/obs-prs

This test on roachdash | Improve this report!

Jira issue: CRDB-65459

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.T-observabilitybranch-release-26.3release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions