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 "A.S.Thiwanka Somasiri (JIRA)" <ji...@apache.org> on 2010/04/11 09:34:40 UTC
[jira] Issue Comment Edited: (DERBY-4601) Shutting down just a
single database should log a different message than shutting down the
system
[ 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