You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <de...@db.apache.org> on 2006/04/14 09:07:00 UTC
[jira] Created: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
syntax errors with ibm15 on zOS in a number of lang tests
---------------------------------------------------------
Key: DERBY-1220
URL: http://issues.apache.org/jira/browse/DERBY-1220
Project: Derby
Type: Bug
Components: Regression Test Failure
Versions: 10.2.0.0
Environment: ibm15 zOS
Reporter: Myrna van Lunteren
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Manjula Kutty (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536031 ]
Manjula Kutty commented on DERBY-1220:
--------------------------------------
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.
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: https://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren updated DERBY-1220:
--------------------------------------
Component: SQL
(was: Regression Test Failure)
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Manjula Kutty (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521206 ]
Manjula Kutty commented on DERBY-1220:
--------------------------------------
One more test which has the same behaviour on z/OS
subquery.sql
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: https://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren updated DERBY-1220:
--------------------------------------
Attachment: floattypess3.sql
floatman102.out
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.
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
> Attachments: floatman102.out, floattypess3.sql
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren updated DERBY-1220:
--------------------------------------
Summary: intermittant incorrect syntax errors with ij with ibm15 on zOS (was: syntax errors with ibm15 on zOS in a number of lang tests)
changing the description to avoid giving the impression this is a test issue.
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren updated DERBY-1220:
--------------------------------------
Attachment: derby.log
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533400 ]
Kathey Marsden commented on DERBY-1220:
---------------------------------------
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?
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: https://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=comments#action_12374549 ]
Myrna van Lunteren commented on DERBY-1220:
-------------------------------------------
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).
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: Regression Test Failure
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=comments#action_12439619 ]
Myrna van Lunteren commented on DERBY-1220:
-------------------------------------------
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
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren reassigned DERBY-1220:
-----------------------------------------
Assign To: (was: Myrna van Lunteren)
Unassigning myself as its not a test issue and I have no expertise looking into this further.
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: floatman102.out, floattypess3.sql
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=comments#action_12376459 ]
Myrna van Lunteren commented on DERBY-1220:
-------------------------------------------
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:
--------------------------------------
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
> Attachments: floatman102.out, floattypess3.sql
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=comments#action_12374479 ]
Myrna van Lunteren commented on DERBY-1220:
-------------------------------------------
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.
-----------------------------------------------
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: Regression Test Failure
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1220) syntax errors with ibm15 on zOS in a
number of lang tests
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1220?page=all ]
Myrna van Lunteren reassigned DERBY-1220:
-----------------------------------------
Assign To: Myrna van Lunteren
> syntax errors with ibm15 on zOS in a number of lang tests
> ---------------------------------------------------------
>
> Key: DERBY-1220
> URL: http://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Type: Bug
> Components: Regression Test Failure
> Versions: 10.2.0.0
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Assignee: Myrna van Lunteren
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-1220) intermittant incorrect syntax errors
with ij with ibm15 on zOS
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-1220.
-----------------------------------
Resolution: Invalid
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
> intermittant incorrect syntax errors with ij with ibm15 on zOS
> --------------------------------------------------------------
>
> Key: DERBY-1220
> URL: https://issues.apache.org/jira/browse/DERBY-1220
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6
> Environment: ibm15 zOS
> Reporter: Myrna van Lunteren
> Attachments: derby.log, floatman102.out, floattypess3.sql
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.