db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4645) Dropping one of the XPLAIN system tables while XPLAIN is enabled results into an exception. Trying it again succeeds.
Date Mon, 10 May 2010 20:08:29 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12865900#action_12865900
] 

Mamta A. Satoor commented on DERBY-4645:
----------------------------------------

Bryan, after the first drop table attempt, there is the exception as shown in the repro above(details
of it in derby.log). If I do a select from SYSXPLAIN_STATEMENT_TIMINGS after doing the first
drop, I am still able to see the table. The second drop table attempt at SYSXPLAIN_STATEMENT_TIMINGS
succeeds and a select from SYSXPLAIN_STATEMENT_TIMINGS after the second drop table fails.
Following shows this behavior inside ij


$ java org.apache.derby.tools.ij 
ij version 10.6 
ij> connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true'; 
ij> CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1); 
0 rows inserted/updated/deleted 
ij> CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1); 
0 rows inserted/updated/deleted 
ij> CALL SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA'); 
0 rows inserted/updated/deleted 
ij> values syscs_util.syscs_get_xplain_schema(); 
1 
-------------------------------------------------------------------------------- 
XPLAINSCHEMA 
1 row selected 
ij> set schema XPLAINSCHEMA; 
0 rows inserted/updated/deleted 
ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
ERROR 42X05: (20000) Table/View 'XPLAINSCHEMA.SYSXPLAIN_STATEMENT_TIMINGS' does not exist.
ij> select * from SYSXPLAIN_STATEMENT_TIMINGS;
TIMING_ID                           |PARSE_TIME          |BIND_TIME           |O
PTIMIZE_TIME       |GENERATE_TIME       |COMPILE_TIME        |EXECUTE_TIME
  |BEGIN_COMP_TIME           |END_COMP_TIME             |BEGIN_EXE_TIME
   |END_EXE_TIME
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------
522b00e8-0128-83ca-0d42-000000041138|0                   |0                   |0
                   |0                   |0                   |0
  |2010-05-10 12:56:30.796   |2010-05-10 12:56:30.796   |2010-05-10 12:56:30.796
   |2010-05-10 12:56:30.796
36e280fc-0128-83ca-0d42-000000041138|31                  |0                   |0
                   |0                   |31                  |0
  |2010-05-10 12:56:31.875   |2010-05-10 12:56:31.906   |2010-05-10 12:56:31.906
   |2010-05-10 12:56:31.906

2 rows selected
ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
0 rows inserted/updated/deleted
ij> select * from SYSXPLAIN_STATEMENT_TIMINGS;
ERROR 42X05: Table/View 'SYSXPLAIN_STATEMENT_TIMINGS' does not exist.

> Dropping one of the XPLAIN system tables while XPLAIN is enabled results into an exception.
Trying it again succeeds.
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4645
>                 URL: https://issues.apache.org/jira/browse/DERBY-4645
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.6.1.0
>            Reporter: Mamta A. Satoor
>            Priority: Minor
>         Attachments: derby.log
>
>
> Ran into an exception when I tried dropping system table SYSXPLAIN_STATEMENT_TIMINGS
after enabling XPLAIN logging using CALL SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA');
The second attempt at dropping the table succeeds
> eg ij script
> $ java org.apache.derby.tools.ij
> ij version 10.6
> ij> connect 'jdbc:derby:c:/dellater/buddytest10_6_1;create=true';
> ij> CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
> 0 rows inserted/updated/deleted
> ij> CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);
> 0 rows inserted/updated/deleted
> ij> CALL SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA('XPLAINSCHEMA');
> 0 rows inserted/updated/deleted
> ij> values syscs_util.syscs_get_xplain_schema();
> 1
> --------------------------------------------------------------------------------
> XPLAINSCHEMA
> 1 row selected
> ij> set schema XPLAINSCHEMA;
> 0 rows inserted/updated/deleted
> ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
> java.sql.SQLSyntaxErrorException: Table/View 'XPLAINSCHEMA.SYSXPLAIN_STATEMENT_TIMINGS'
does not exist.
> ij> drop table SYSXPLAIN_STATEMENT_TIMINGS;
> 0 rows inserted/updated/deleted
> I wonder if this is happening because we are trying to write into SYSXPLAIN_STATEMENT_TIMINGS
as part of the XPLAIN functionality when first drop table for SYSXPLAIN_STATEMENT_TIMINGS
is issued. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message