Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3085

Exception with unclear message

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 8.7
    • Misc. Connectors
    • None
    • Hide

      Source databse - Greenplum
      VDB view model - BQT1
      tables: smalla -
      `INTKEY` integer primary key,
      `STRINGKEY` varing(10),
      `INTNUM` integer,
      `STRINGNUM` varing(10),
      `FLOATNUM` real,
      `LONGNUM` bigint,
      `DOUBLENUM` double,
      `BYTENUM` smallint,
      `DATEVALUE` date,
      `TIMEVALUE` time,
      `TIMESTAMPVALUE` timestamp,
      `BOOLEANVALUE` boolean,
      `CHARVALUE` character(1),
      `SHORTVALUE` smallint,
      `BIGINTEGERVALUE` bigint,
      `BIGDECIMALVALUE` decimal(10,0),
      `OBJECTVALUE` bytea

      SQL Query - SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a

      Show
      Source databse - Greenplum VDB view model - BQT1 tables: smalla - `INTKEY` integer primary key, `STRINGKEY` varing(10), `INTNUM` integer, `STRINGNUM` varing(10), `FLOATNUM` real, `LONGNUM` bigint, `DOUBLENUM` double, `BYTENUM` smallint, `DATEVALUE` date, `TIMEVALUE` time, `TIMESTAMPVALUE` timestamp, `BOOLEANVALUE` boolean, `CHARVALUE` character(1), `SHORTVALUE` smallint, `BIGINTEGERVALUE` bigint, `BIGDECIMALVALUE` decimal(10,0), `OBJECTVALUE` bytea SQL Query - SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a

      Description of problem:
      Unexpected exception. Returned exception indicates that query failed but there is no reason in message.

      Actual results:
      TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."timevalue", cast(g_0."bytenum" AS smallint), (SELECT g_1."floatnum" FROM "smalla" AS g_1 WHERE g_1."intkey" = g_0."intkey" AND g_1."intkey" = (SELECT g_2."intkey" FROM "smalla" AS g_2 WHERE g_2."stringnum" > '10' AND g_2."intkey" = g_1."intkey")) FROM "smalla" AS g_0]

      Expected results:
      Remote org.postgresql.util.PSQLException: ERROR: Interconnect Error: Unexpected Motion Node Id: 2. This means a motion node that wasn't setup is requesting interconnect resources.

      Additional info:
      Log and exception stack trace in attachment.

        1. exception-stack-trace
          6 kB
        2. full-server.log
          2.53 MB
        3. server.log
          18 kB

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: