db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A.S.Thiwanka Somasiri (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-4601) Shutting down just a single database should log a different message than shutting down the system
Date Sun, 11 Apr 2010 07:34:40 GMT

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

A.S.Thiwanka Somasiri edited comment on DERBY-4601 at 4/11/10 3:34 AM:
-----------------------------------------------------------------------

Hi all,
             As I understood, Kathey focussed on the derby.log file.The ij tool is ok with
the output it displays.But the thing is that the derby.log shows the same output for derby
database shutdown and the system shutdown.It gives the results as follows:

ij command to shutdown derby database : CONNECT 'jdbc:derby:firstdb;shutdown=true';
derby.log :
2010-04-11 04:44:27.682 GMT:
Shutting down instance a816c00e-0127-eb2d-9710-0000032be180 with class
loader sun.misc.Launcher$AppClassLoader@2c2bbd86

ij command to shutdown system : CONNECT 'jdbc:derby:;shutdown=true';
derby.log :
2010-04-11 04:44:37.944 GMT:
Shutting down instance 601a400f-0127-eb2d-9710-0000032be180 with class
loader sun.misc.Launcher$AppClassLoader@2c2bbd86

As this says both db and sys shutdowns gives the same output.The thing I need to know is,
"whether the Derby system is down even after the above second ij command is issued?"
I need to clarify which derby;log output is correct in this case.Better if someone can explain
this.

Thanks.

      was (Author: asthiwanka):
    Hi all,
             As I understood, Kathey focussed on the derby.log file.The ij tool is ok with
the output it displays.But the thing is that the derby.log shows the same output for derby
database shutdown and the system shutdown.It gives the results as follows:

ij command to shutdown derby database : CONNECT 'jdbc:derby:firstdb;shutdown=true';
derby.log :
2010-04-11 04:44:27.682 GMT:
Shutting down instance a816c00e-0127-eb2d-9710-0000032be180 with class
loader sun.misc.Launcher$AppClassLoader@2c2bbd86

ij command to shutdown system : CONNECT 'jdbc:derby:;shutdown=true';
derby.log :
2010-04-11 04:44:37.944 GMT:
Shutting down instance 601a400f-0127-eb2d-9710-0000032be180 with class
loader sun.misc.Launcher$AppClassLoader@2c2bbd86

As this says both db and sys shutdowns gives the same output.The thing I need to know is,
"whether the Derby system is down even after the above second ij command is issued?"

Thanks.
  
> Shutting down just a single database should log a different message than shutting down
the system
> -------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4601
>                 URL: https://issues.apache.org/jira/browse/DERBY-4601
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.5.3.0
>            Reporter: Kathey Marsden
>            Priority: Minor
>
> When shutting down just a single database and not the Derby system, the log should print
a message that just that database was shutdown as I believe Derby is still loaded.
> e.g.
> ij version 10.6
> ij> run 'testMessages.sql';
> ij> connect 'jdbc:derby:wombat';
> ij> connect 'jdbc:derby:wombat2';
> ij(CONNECTION1)> connect 'jdbc:derby:wombat2;shutdown=true';
> ERROR 08006: Database 'wombat2' shutdown.
> ij(CONNECTION1)> connect 'jdbc:derby:;shutdown=true';
> ERROR XJ015: Derby system shutdown.
> yields the following log:
> 2010-03-26 15:27:16.375 GMT:
>  Booting Derby version The Apache Software Foundation - Apache Derby - 10.6.0.0 alpha
- (927879M): instance a816c00e-0127-9b15-988d-0000002083e0 
> on database directory C:\kmarsden\repro\DERBY-4588\wombat   with class loader sun.misc.Launcher$AppClassLoader@42c042c0
> Database Class Loader started - derby.database.classpath=''
> ----------------------------------------------------------------
> 2010-03-26 15:27:16.921 GMT:
>  Booting Derby version The Apache Software Foundation - Apache Derby - 10.6.0.0 alpha
- (927879M): instance 601a400f-0127-9b15-988d-0000002083e0 
> on database directory C:\kmarsden\repro\DERBY-4588\wombat2   with class loader sun.misc.Launcher$AppClassLoader@42c042c0
> Database Class Loader started - derby.database.classpath=''
> 2010-03-26 15:27:17.171 GMT:
> Shutting down instance 601a400f-0127-9b15-988d-0000002083e0 with class loader sun.misc.Launcher$AppClassLoader@42c042c0

> ----------------------------------------------------------------
> 2010-03-26 15:27:17.218 GMT:
> Shutting down instance a816c00e-0127-9b15-988d-0000002083e0 with class loader sun.misc.Launcher$AppClassLoader@42c042c0

> ----------------------------------------------------------------
> The first shutdown should say that just the database wombat2 was shutdown, not the entire
system.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message