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 "Ole Solberg (JIRA)" <ji...@apache.org> on 2008/05/14 08:47:55 UTC
[jira] Created: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
----------------------------------------------------------------------------------------------------------------------------
Key: DERBY-3674
URL: https://issues.apache.org/jira/browse/DERBY-3674
Project: Derby
Issue Type: Bug
Components: Regression Test Failure, Test
Affects Versions: 10.5.0.0
Environment: OS: SunOS 5.10
JVM: Sun 1.6.0_04
SVN: r >= 655989
Reporter: Ole Solberg
Priority: Minor
See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
<method>
store/TransactionTable.sql
</method>
<signature>
268 del
< 0 rows inserted/updated/deleted
268a268,269
> ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
</signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor reassigned DERBY-3674:
--------------------------------------
Assignee: Mamta A. Satoor
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597004#action_12597004 ]
Mamta A. Satoor commented on DERBY-3674:
----------------------------------------
The other easier alternative is I could check in SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE to see if we are dealing with VTI and if so then just return from the method and don't worry about generating ALTER TABLE sql for it. I will explore this path since it is cleaner than changing the compile and execute phase code of ALTER TABLE processing.
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ole Solberg closed DERBY-3674.
------------------------------
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
> Fix For: 10.5.0.0
>
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor resolved DERBY-3674.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.5.0.0
Haven't seen the failure again after the fix was checked in.
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
> Fix For: 10.5.0.0
>
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597003#action_12597003 ]
Mamta A. Satoor commented on DERBY-3674:
----------------------------------------
Prior to my checkin for DERBY-1062, all the work for inplace compress was handled outside of compile and execute hierarchy and the code for inplace compress was in OnlineCompress class. In that class, we checked if we are trying to compress a VTI (which in this jira entry's case is SYSCS_DIAG.TRANSACTION_TABLE) and if yes, then we did nothing and simply returned from the OnlineCompress class.
With changes for DERBY-1062, we have moved the code from OnlineCompress into ALTER TABLE related compile and execute classes(namely AlterTableNode and AlterTableConstantAction). In ALTER TABLE, we can tell in the bind phase in AlterTableNode.bindStatement() that we are dealing with VTI but there is no easy way to say we are done since we are dealing with inplace compress of VTI and hence let's quit. I can try to change code in compile and execute time to somehow ignore inplace compress on VTI but I was curious if there is a more graceful way to just quit out of compile phase (and skip execute phase all together) since we know inplace compress on VTI should be treated as no-op.
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3674) 'ALTER TABLE' is not allowed on the
System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall -
store/TransactionTable.sql
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12597235#action_12597235 ]
Mamta A. Satoor commented on DERBY-3674:
----------------------------------------
I have checked in a fix for this jira entry through revision 656797. Inplace compress on VTI will be caught earlier and we will return with no-op. All the other inplace compress requests will go through ALTER TABLE code path.
> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3674
> URL: https://issues.apache.org/jira/browse/DERBY-3674
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure, Test
> Affects Versions: 10.5.0.0
> Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
> Reporter: Ole Solberg
> Assignee: Mamta A. Satoor
> Priority: Minor
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.