topic Error with derby db in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-with-derby-db/m-p/196696#M149826 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>my alfresco hang up during using the web client. Restarting Alfresco results in the following errors:</SPAN><BR /><BR /><SPAN>1:42:24,658 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Failed to start database 'alf_data/derby_data/alfresco', see the next exception for details.</SPAN><BR /><SPAN>Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /opt/alfresco/alf_data/derby_data/alfresco.</SPAN><BR /><BR /><SPAN>What processes do I have to kill to solve the problem?: </SPAN><BR /><BLOCKQUOTE class="jive-quote">smitty-op:/opt/alfresco # lsof -i<BR />COMMAND&nbsp;&nbsp;&nbsp;&nbsp; PID&nbsp;&nbsp;&nbsp;&nbsp; USER&nbsp;&nbsp; FD&nbsp;&nbsp; TYPE&nbsp; DEVICE SIZE NODE NAME<BR />portmap&nbsp;&nbsp;&nbsp; 2104&nbsp;&nbsp; nobody&nbsp;&nbsp;&nbsp; 3u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5298&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP *:sunrpc <BR />portmap&nbsp;&nbsp;&nbsp; 2104&nbsp;&nbsp; nobody&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5301&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:sunrpc (LISTEN)<BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp;&nbsp; 6u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5289&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP localhost:svrloc (LISTEN)<BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp;&nbsp; 7u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5290&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP smitty-op.site:svrloc (LISTEN)<BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp;&nbsp; 8u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5291&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP 239.255.255.253:svrloc <BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp;&nbsp; 9u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP SVRLOC.MCAST.NET:svrloc <BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp; 10u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5322&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP smitty-op.site:svrloc <BR />slpd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2111&nbsp;&nbsp; daemon&nbsp;&nbsp; 11u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5323&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP 255.255.255.255:svrloc <BR />zmd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2210&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp;&nbsp; 5u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5518&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP localhost:novell-zen (LISTEN)<BR />sshd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2252&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp;&nbsp; 3u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5619&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:ssh (LISTEN)<BR />master&nbsp;&nbsp;&nbsp;&nbsp; 2331&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp; 11u&nbsp; IPv4&nbsp;&nbsp;&nbsp; 5953&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:smtp (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9062&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 294u&nbsp; IPv4 1338460&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:50500 (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9062&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 295u&nbsp; IPv4 1338461&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:53618 (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp; 47u&nbsp; IPv4 1363144&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http-alt (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 311u&nbsp; IPv4 1363174&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:45926 (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 372u&nbsp; IPv4 1363224&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UDP *:netbios-ns <BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 373u&nbsp; IPv4 1363229&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:microsoft-ds (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 374u&nbsp; IPv4 1363230&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:netbios-ssn (LISTEN)<BR />java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13844&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; 375u&nbsp; IPv4 1363231&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP smitty-op.site:ftp (LISTEN)<BR />sshd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29003&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp;&nbsp; 3u&nbsp; IPv4 1256299&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP smitty-op.site:ssh-&gt;localhost:41266 (ESTABLISHED)<BR />httpd2-pr 30559&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />sshd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30564&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp;&nbsp; 3u&nbsp; IPv4 1008957&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP smitty-op.site:ssh-&gt;129.247.161.21:routematch (ESTABLISHED)<BR />httpd2-pr 32051&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />httpd2-pr 32052&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />httpd2-pr 32053&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />httpd2-pr 32054&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />httpd2-pr 32055&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)<BR />httpd2-pr 32455&nbsp;&nbsp; wwwrun&nbsp;&nbsp;&nbsp; 4u&nbsp; IPv4&nbsp; 383351&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TCP *:http (LISTEN)</BLOCKQUOTE></BODY></HTML> Tue, 16 Sep 2008 10:41:07 GMT thomas91 2008-09-16T10:41:07Z Error with derby db https://connect.hyland.com/t5/alfresco-archive/error-with-derby-db/m-p/196696#M149826 Hello,my alfresco hang up during using the web client. Restarting Alfresco results in the following errors:1:42:24,658 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedCaused by: java.sql.SQLException: Failed to start database 'alf_data/derby_data/alfresco', see the Tue, 16 Sep 2008 10:41:07 GMT https://connect.hyland.com/t5/alfresco-archive/error-with-derby-db/m-p/196696#M149826 thomas91 2008-09-16T10:41:07Z Re: Error with derby db https://connect.hyland.com/t5/alfresco-archive/error-with-derby-db/m-p/196697#M149827 <HTML><HEAD></HEAD><BODY><SPAN>ok solve it myself:</SPAN><BR /><SPAN>by killing the processes shown with ps -A|grep java</SPAN></BODY></HTML> Tue, 16 Sep 2008 11:27:50 GMT https://connect.hyland.com/t5/alfresco-archive/error-with-derby-db/m-p/196697#M149827 thomas91 2008-09-16T11:27:50Z