Derby
  1. Derby
  2. DERBY-1220

intermittant incorrect syntax errors with ij with ibm15 on zOS

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      ibm15 zOS

      Description

      The following tests fail with unexpected syntax errors that do not occur with ibm14 on zOS:
      derbylang/derbylang.fail:lang/altertable.sql
      derbylang/derbylang.fail:lang/floattypes.sql

      This may still be a test issue, or a jvm issue, further research is needed.

      1. floattypess3.sql
        18 kB
        Myrna van Lunteren
      2. floatman102.out
        51 kB
        Myrna van Lunteren
      3. derby.log
        194 kB
        Myrna van Lunteren

        Activity

        Hide
        Kathey Marsden added a comment -

        Closing invalid, because this was a JVM issue. Fixed with IBM 1.6 SR1, not sure if there is a fixed version with IBM 1.5

        Show
        Kathey Marsden added a comment - Closing invalid, because this was a JVM issue. Fixed with IBM 1.6 SR1, not sure if there is a fixed version with IBM 1.5
        Hide
        Manjula Kutty added a comment -

        I ran the lang suite on Zos machine machine ibmjvm1.5 with the -Xjit:count=0 option and found the following 2 are still failing with the syntax error. But others are gone

        derbylang/derbylang.fail:lang/subquery.sql
        derbylang/derbylang.fail:lang/triggerGeneral.sql

        Both has the same syntax error wordings:

        ERROR 42X01: Syntax error: Encountered "pect" at line 1, column 6.

        Show
        Manjula Kutty added a comment - I ran the lang suite on Zos machine machine ibmjvm1.5 with the -Xjit:count=0 option and found the following 2 are still failing with the syntax error. But others are gone derbylang/derbylang.fail:lang/subquery.sql derbylang/derbylang.fail:lang/triggerGeneral.sql Both has the same syntax error wordings: ERROR 42X01: Syntax error: Encountered "pect" at line 1, column 6.
        Hide
        Kathey Marsden added a comment -

        I ran into a similar issue (but much more severe) in a prerelease IBM 1.6 JVM on Windows XP.
        It looks like a JIT issue and does not reproduce with -Xnojit. Does this problem reproduce on zseries with jit turned off?

        Show
        Kathey Marsden added a comment - I ran into a similar issue (but much more severe) in a prerelease IBM 1.6 JVM on Windows XP. It looks like a JIT issue and does not reproduce with -Xnojit. Does this problem reproduce on zseries with jit turned off?
        Hide
        Manjula Kutty added a comment -

        One more test which has the same behaviour on z/OS
        subquery.sql

        Show
        Manjula Kutty added a comment - One more test which has the same behaviour on z/OS subquery.sql
        Hide
        Myrna van Lunteren added a comment -

        With 10.2.1.5 I saw failures like this (syntax errors in completely proper sql) occurring in the following tests:
        lang/fk_nonSPS.sql
        lang/floattypes.sql
        lang/synonym.sql
        lang/triggerGeneral.sql
        and possibly
        lang/grantRevokeDDL.sql
        lang/grantRevokeDDL2.sql

        the java version was:
        java version "1.5.0"
        IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 z/OS s390-31 j9vmmz3123-20060919 (JIT enabled)
        J9VM - 20060915_08260_bHdSMr
        JIT - 20060908_1811_r8
        GC - 20060906_AA)
        JCL - 20060919

        Show
        Myrna van Lunteren added a comment - With 10.2.1.5 I saw failures like this (syntax errors in completely proper sql) occurring in the following tests: lang/fk_nonSPS.sql lang/floattypes.sql lang/synonym.sql lang/triggerGeneral.sql and possibly lang/grantRevokeDDL.sql lang/grantRevokeDDL2.sql the java version was: java version "1.5.0" IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 z/OS s390-31 j9vmmz3123-20060919 (JIT enabled) J9VM - 20060915_08260_bHdSMr JIT - 20060908_1811_r8 GC - 20060906_AA) JCL - 20060919
        Hide
        Myrna van Lunteren added a comment -

        changing the description to avoid giving the impression this is a test issue.

        Show
        Myrna van Lunteren added a comment - changing the description to avoid giving the impression this is a test issue.
        Hide
        Myrna van Lunteren added a comment -

        Unassigning myself as its not a test issue and I have no expertise looking into this further.

        Show
        Myrna van Lunteren added a comment - Unassigning myself as its not a test issue and I have no expertise looking into this further.
        Hide
        Myrna van Lunteren added a comment -

        This must be some kind of resource limit issue - with the full script for floattypes.sql and altertable.sql the problems - syntax errors in completely fine statements - occur consistently, but I've tried to bring back the floattypes.sql script to a smaller test case and have not succeeded. At some point the failure becomes harder to reproduce, until any more lines stripped away apparently do not reproduce the problem at all.

        It only occurs with the combination 10.2 and ibm15, not ibm14 or 10.1. And only on zOS.

        The build number for the jvm is:
        --------------------------------------
        java version "1.5.0"
        Java(TM) 2 Runtime Environment, Standard Edition (build pmz31dev-20060420 (SR2))
        IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 z/OS s390-31 j9vmmz3123-20060420 (JI
        T enabled)
        J9VM - 20060419_06266_bHdSMr
        JIT - 20060418_1800_r8
        GC - 20060412_AA)
        JCL - 20060420
        --------------------------------------

        At the instance of the failure, derby.log contains this:
        --------------------------------------
        2006-04-26 10:46:18.895 GMT Thread[main,5,main] (XID = 873), (SESSIONID = 0), (D
        ATABASE = wombat), (DRDAID = null), Failed Statement is: – fail
        insert into fake values 5e-37/1e1
        ERROR 42X01: Syntax error: Encountered "il" at line 1, column 6.
        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
        at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java:154)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:310)
        at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
        reInternalStatement(GenericLanguageConnectionContext.java:713)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:560)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:507)
        at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:313)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:204)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:170)
        at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
        at org.apache.derby.tools.ij.main(ij.java:60)
        Cleanup action completed

        2006-04-26 10:46:19.146 GMT:
        --------------------------------------

        Show
        Myrna van Lunteren added a comment - This must be some kind of resource limit issue - with the full script for floattypes.sql and altertable.sql the problems - syntax errors in completely fine statements - occur consistently, but I've tried to bring back the floattypes.sql script to a smaller test case and have not succeeded. At some point the failure becomes harder to reproduce, until any more lines stripped away apparently do not reproduce the problem at all. It only occurs with the combination 10.2 and ibm15, not ibm14 or 10.1. And only on zOS. The build number for the jvm is: -------------------------------------- java version "1.5.0" Java(TM) 2 Runtime Environment, Standard Edition (build pmz31dev-20060420 (SR2)) IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 z/OS s390-31 j9vmmz3123-20060420 (JI T enabled) J9VM - 20060419_06266_bHdSMr JIT - 20060418_1800_r8 GC - 20060412_AA) JCL - 20060420 -------------------------------------- At the instance of the failure, derby.log contains this: -------------------------------------- 2006-04-26 10:46:18.895 GMT Thread [main,5,main] (XID = 873), (SESSIONID = 0), (D ATABASE = wombat), (DRDAID = null), Failed Statement is: – fail insert into fake values 5e-37/1e1 ERROR 42X01: Syntax error: Encountered "il" at line 1, column 6. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304) at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java:154) at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:310) at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa reInternalStatement(GenericLanguageConnectionContext.java:713) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:560) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:507) at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:313) at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:433) at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:310) at org.apache.derby.impl.tools.ij.Main.go(Main.java:204) at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:170) at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55) at org.apache.derby.tools.ij.main(ij.java:60) Cleanup action completed 2006-04-26 10:46:19.146 GMT: --------------------------------------
        Hide
        Myrna van Lunteren added a comment -

        Attaching the script that - most of the time - still duplicates the behaviour (floattypess3.sql) and the output (floatman102.out).

        If I strip any more out the failure doesn't show up - most of the time; with this in, it occurs - most of the time.

        Show
        Myrna van Lunteren added a comment - Attaching the script that - most of the time - still duplicates the behaviour (floattypess3.sql) and the output (floatman102.out). If I strip any more out the failure doesn't show up - most of the time; with this in, it occurs - most of the time.
        Hide
        Myrna van Lunteren added a comment -

        This is a problem only with 10.2 on ibm15; does not occur with 10.1 on ibm15 nor on ibm14 (either 10.1 or 10.2).

        Show
        Myrna van Lunteren added a comment - This is a problem only with 10.2 on ibm15; does not occur with 10.1 on ibm15 nor on ibm14 (either 10.1 or 10.2).
        Hide
        Myrna van Lunteren added a comment -

        For example, a section of the diff for altertable.sql:
        ------------------------------------------------------------
        771 del
        < ERROR 42X85: Constraint 'BADSCHEMA.NEWCONS'is required to be in the same schema as table 'X'.
        771a771
        > ERROR 42X01: Syntax error: Encountered "d" at line 1, column 6.
        773a774,777
        > ERROR 42X01: Syntax error: Encountered "o" at line 1, column 6.
        > ij> create table x (x int not null, y int not null);
        > ERROR X0Y32: Table/View 'X' already exists in Schema 'APP'.
        > ij> alter table x add constraint con check (x > 1);
        775,778d778
        < ij> create table x (x int not null, y int not null);
        < 0 rows inserted/updated/deleted
        < ij> alter table x add constraint con check (x > 1);
        < 0 rows inserted/updated/deleted
        791 del
        < ERROR 42X86: ALTER TABLE failed. There is no constraint 'EMPTYSCHEMA.CON' on t
        able 'APP.X'.
        791a791
        > ERROR 42X01: Syntax error: Encountered "il" at line 1, column 6.
        -----------------------------------------------

        Show
        Myrna van Lunteren added a comment - For example, a section of the diff for altertable.sql: ------------------------------------------------------------ 771 del < ERROR 42X85: Constraint 'BADSCHEMA.NEWCONS'is required to be in the same schema as table 'X'. 771a771 > ERROR 42X01: Syntax error: Encountered "d" at line 1, column 6. 773a774,777 > ERROR 42X01: Syntax error: Encountered "o" at line 1, column 6. > ij> create table x (x int not null, y int not null); > ERROR X0Y32: Table/View 'X' already exists in Schema 'APP'. > ij> alter table x add constraint con check (x > 1); 775,778d778 < ij> create table x (x int not null, y int not null); < 0 rows inserted/updated/deleted < ij> alter table x add constraint con check (x > 1); < 0 rows inserted/updated/deleted 791 del < ERROR 42X86: ALTER TABLE failed. There is no constraint 'EMPTYSCHEMA.CON' on t able 'APP.X'. 791a791 > ERROR 42X01: Syntax error: Encountered "il" at line 1, column 6. -----------------------------------------------

          People

          • Assignee:
            Unassigned
            Reporter:
            Myrna van Lunteren
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development