Skip to content

make integration errors returned #65

@tuhaihe

Description

@tuhaihe
[gpadmin@cdw cloudberry-backup]$ make integration
fatal: No tags can describe 'b60130e8062e0b2a0a031b959bc742869ceedf5d'.
Try --always, or create some tags.
ginkgo -r --keep-going --randomize-suites --randomize-all --no-color integration 2>&1
Running Suite: database query tests - /home/gpadmin/cloudberry-backup/integration
=================================================================================
Random Seed: 1770697461 - will randomize all specs

Will run 549 of 552 specs
••••••S•••••••••••••••••S•••••••••••
------------------------------
• [FAILED] [0.016 seconds]
backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE WEB EXTERNAL table with an EXECUTE statement containing special characters
/home/gpadmin/cloudberry-backup/integration/predata_externals_create_test.go:61

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:25.241
------------------------------
••••••••••••S•••
------------------------------
• [FAILED] [0.007 seconds]
backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with CUSTOM formatter
/home/gpadmin/cloudberry-backup/integration/predata_externals_create_test.go:103

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:25.522
------------------------------
••••••••••••••••
------------------------------
P [PENDING]
backup integration tests GetExternalTableDefinitions returns a slice for a complex external table definition TEXT format delimiter
/home/gpadmin/cloudberry-backup/integration/predata_externals_queries_test.go:124
------------------------------
••••••••••••••••S••••••••S••••••S•S••
------------------------------
• [FAILED] [0.010 seconds]
backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with FORMAT delimiter
/home/gpadmin/cloudberry-backup/integration/predata_externals_create_test.go:124

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:28.091
------------------------------
••••••••••••••••••••••S••••
------------------------------
• [FAILED] [0.013 seconds]
backup integration tests GetExternalTableDefinitions [It] returns a slice for a basic external table definition
/home/gpadmin/cloudberry-backup/integration/predata_externals_queries_test.go:17

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:28.779
------------------------------
• [FAILED] [0.007 seconds]
backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with CSV FORMAT options
/home/gpadmin/cloudberry-backup/integration/predata_externals_create_test.go:85

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:28.783
------------------------------
••••S••••••••
••••••••S•••••••••••••••••••••••••••••••
------------------------------
P [PENDING]
backup integration tests GetPartitionDefinitions returns a value for a partition definition for a table with a negative partition value
/home/gpadmin/cloudberry-backup/integration/predata_table_defs_queries_test.go:402
------------------------------
S•••••••••••••••
------------------------------
• [FAILED] [0.001 seconds]
backup integration tests GetCollations [It] returns a slice of with specific collation
/home/gpadmin/cloudberry-backup/integration/predata_types_queries_test.go:371

  [FAILED] CREATE COLLATION public.some_coll (provider = 'libc', locale = 'de_DE');
  Expected
      <*pgconn.PgError | 0x400079fa40>: 
      ERROR: could not create locale "de_DE": No such file or directory (SQLSTATE 22023)
      {
          Severity: "ERROR",
          Code: "22023",
          Message: "could not create locale \"de_DE\": No such file or directory",
          Detail: "The operating system could not find any locale data for the locale name \"de_DE\".",
          Hint: "",
          Position: 0,
          InternalPosition: 0,
          InternalQuery: "",
          Where: "",
          SchemaName: "",
          TableName: "",
          ColumnName: "",
          DataTypeName: "",
          ConstraintName: "",
          File: "pg_locale.c",
          Line: 1441,
          Routine: "report_newlocale_failure",
      }
  to be nil
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99 @ 02/09/26 20:24:32.085
------------------------------
••••S•••••••••
------------------------------
• [FAILED] [0.027 seconds]
backup integration tests PrintStatisticsStatementsForTable [It] prints attribute and tuple statistics for a table
/home/gpadmin/cloudberry-backup/integration/statistics_create_test.go:18

  [FAILED] 

  UPDATE pg_class
  SET
        relpages = 2::int,
        reltuples = 2.000000::real
  WHERE oid = 'public.foo'::regclass::oid;


  DELETE FROM pg_statistic WHERE starelid = 'public.foo'::regclass::oid AND staattnum = 1;


  INSERT INTO pg_statistic VALUES (
        'public.foo'::regclass::oid,
        1::smallint,
        false::boolean,
        0.000000::real,
        4::integer,
        -1.000000::real,
        2::smallint,
        8::smallint,
        0::smallint,
        0::smallint,
        0::smallint,
        97::oid,
        97::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        array_in('{"1","2"}', 'int4'::regtype::oid, -1),
        array_in('{"2"}', 'int4'::regtype::oid, -1),
        NULL,
        NULL,
        NULL);


  DELETE FROM pg_statistic WHERE starelid = 'public.foo'::regclass::oid AND staattnum = 2;


  INSERT INTO pg_statistic VALUES (
        'public.foo'::regclass::oid,
        2::smallint,
        false::boolean,
        0.000000::real,
        2::integer,
        -1.000000::real,
        2::smallint,
        8::smallint,
        0::smallint,
        0::smallint,
        0::smallint,
        664::oid,
        664::oid,
        0::oid,
        0::oid,
        0::oid,
        100::oid,
        100::oid,
        0::oid,
        0::oid,
        0::oid,
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        array_in('{"a","b"}', 'text'::regtype::oid, -1),
        array_in('{"2"}', 'text'::regtype::oid, -1),
        NULL,
        NULL,
        NULL);


  DELETE FROM pg_statistic WHERE starelid = 'public.foo'::regclass::oid AND staattnum = 3;


  INSERT INTO pg_statistic VALUES (
        'public.foo'::regclass::oid,
        3::smallint,
        false::boolean,
        0.000000::real,
        1::integer,
        -1.000000::real,
        2::smallint,
        8::smallint,
        0::smallint,
        0::smallint,
        0::smallint,
        58::oid,
        58::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        0::oid,
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        NULL::real[],
        array_in('{"f","t"}', 'bool'::regtype::oid, -1),
        array_in('{"2"}', 'bool'::regtype::oid, -1),
        NULL,
        NULL,
        NULL);

  Expected
      <*pgconn.PgError | 0x40001392c0>: 
      ERROR: invalid input syntax for type boolean: "2" (SQLSTATE 22P02)
      {
          Severity: "ERROR",
          Code: "22P02",
          Message: "invalid input syntax for type boolean: \"2\"",
          Detail: "",
          Hint: "",
          Position: 0,
          InternalPosition: 0,
          InternalQuery: "",
          Where: "",
          SchemaName: "",
          TableName: "",
          ColumnName: "",
          DataTypeName: "",
          ConstraintName: "",
          File: "bool.c",
          Line: 151,
          Routine: "boolin",
      }
  to be nil
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99 @ 02/09/26 20:24:32.409
------------------------------
S••••••••S•••••••S••••••••••••••••••••••••••S•
------------------------------
↺ [FLAKEY TEST - TOOK 2 ATTEMPTS TO PASS] [0.078 seconds]
backup integration tests BackupDataForAllTables backs up multiple tables with valid data
/home/gpadmin/cloudberry-backup/integration/data_backup_test.go:58
------------------------------
••••••••••••••••••••••
------------------------------
• [FAILED] [0.010 seconds]
backup integration tests GetExternalTableDefinitions [It] returns a slice for a basic external web table definition
/home/gpadmin/cloudberry-backup/integration/predata_externals_queries_test.go:35

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:33.799
------------------------------
••••
•••••••••••••••
------------------------------
• [FAILED] [0.001 seconds]
backup integration create statement tests PrintCreateCollationStatement [It] creates a specific collation
/home/gpadmin/cloudberry-backup/integration/predata_types_create_test.go:278

  [FAILED] 
  CREATE COLLATION public.testcollation (LC_COLLATE = 'de_DE', LC_CTYPE = 'de_DE', PROVIDER = 'libc');
  Expected
      <*pgconn.PgError | 0x4001caf950>: 
      ERROR: could not create locale "de_DE": No such file or directory (SQLSTATE 22023)
      {
          Severity: "ERROR",
          Code: "22023",
          Message: "could not create locale \"de_DE\": No such file or directory",
          Detail: "The operating system could not find any locale data for the locale name \"de_DE\".",
          Hint: "",
          Position: 0,
          InternalPosition: 0,
          InternalQuery: "",
          Where: "",
          SchemaName: "",
          TableName: "",
          ColumnName: "",
          DataTypeName: "",
          ConstraintName: "",
          File: "pg_locale.c",
          Line: 1441,
          Routine: "report_newlocale_failure",
      }
  to be nil
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99 @ 02/09/26 20:24:34.321
------------------------------
••••
------------------------------
• [FAILED] [0.007 seconds]
backup integration create statement tests PrintExternalTableCreateStatement [It] creates a WRITABLE EXTERNAL table
/home/gpadmin/cloudberry-backup/integration/predata_externals_create_test.go:142

  [FAILED] Expected structs to match but:
  Mismatch on field RejectLimitType
  Expected
      <string>: \xff
  to equal
      <string>: 
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:34.386
------------------------------
•••••••••••••••••••••••••••••••••••••
•••
------------------------------
• [FAILED] [0.029 seconds]
backup integration tests PrintStatisticsStatementsForTable [It] prints attribute and tuple statistics for a quoted table
/home/gpadmin/cloudberry-backup/integration/statistics_create_test.go:63

  [FAILED] Expected structs to match but:
  Mismatch on field Values1
  Expected
      <pq.StringArray | len:1, cap:1>: ["t"]
  to equal
      <pq.StringArray | len:1, cap:1>: ["1"]
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:35.173
------------------------------
••••••S••••••••••••S•••••••••S•S••
•••••••••••••••••••••
------------------------------
• [FAILED] [0.021 seconds]
backup integration tests GetAttributeStatistics [It] returns attribute statistics for a table
/home/gpadmin/cloudberry-backup/integration/statistics_queries_test.go:33

  [FAILED] Expected structs to match but:
  Mismatch on field Kind3
  Expected
      <int>: 8
  to equal
      <int>: 0
  Mismatch on field Operator3
  Expected
      <uint32>: 97
  to equal
      <uint32>: 0
  Mismatch on field Values3
  Expected
      <pq.StringArray | len:1, cap:1>: ["4"]
  to equal
      <pq.StringArray | len:0, cap:0>: nil
  In [It] at: /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113 @ 02/09/26 20:24:35.859
------------------------------
•••••••••••••••••••••••••••••••••••••••••••••••••••••S••S•••
------------------------------
P [PENDING]
backup integration create statement tests PrintCreateFunctionStatement Tests for GPDB 7 creates a function with TRANSFORM FOR TYPE
/home/gpadmin/cloudberry-backup/integration/predata_functions_create_test.go:225
------------------------------
•••••S•••••••••••••••••••••••••••••••••••••••SS••••••••••••••••••••••••••••

Summarizing 12 Failures:
  [FAIL] backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE WEB EXTERNAL table with an EXECUTE statement containing special characters
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with CUSTOM formatter
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with FORMAT delimiter
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration tests GetExternalTableDefinitions [It] returns a slice for a basic external table definition
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration create statement tests PrintExternalTableCreateStatement [It] creates a READABLE EXTERNAL table with CSV FORMAT options
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration tests GetCollations [It] returns a slice of with specific collation
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99
  [FAIL] backup integration tests PrintStatisticsStatementsForTable [It] prints attribute and tuple statistics for a table
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99
  [FAIL] backup integration tests GetExternalTableDefinitions [It] returns a slice for a basic external web table definition
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration create statement tests PrintCreateCollationStatement [It] creates a specific collation
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/testhelper/functions.go:99
  [FAIL] backup integration create statement tests PrintExternalTableCreateStatement [It] creates a WRITABLE EXTERNAL table
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration tests PrintStatisticsStatementsForTable [It] prints attribute and tuple statistics for a quoted table
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113
  [FAIL] backup integration tests GetAttributeStatistics [It] returns attribute statistics for a table
  /home/gpadmin/go/pkg/mod/github.com/apache/cloudberry-go-libs@v1.0.12-0.20250910014224-fc376e8a1056/structmatcher/structmatcher.go:113

Ran 524 of 552 Specs in 20.633 seconds
FAIL! -- 512 Passed | 12 Failed | 1 Flaked | 3 Pending | 25 Skipped
--- FAIL: TestQueries (20.64s)
FAIL

Ginkgo ran 1 suite in 21.957188427s

Test Suite Failed
make: *** [Makefile:75: integration] Error 1

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions