topic Strange issue in Alfresco-while executing code. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/strange-issue-in-alfresco-while-executing-code/m-p/192185#M145315 <HTML><HEAD></HEAD><BODY><SPAN>Hello </SPAN><BR /><BR /><SPAN>Recently 1 strange issue I encountered in Alfresco. Suppose</SPAN><BR /><BR /><SPAN>1)&nbsp;&nbsp;&nbsp;When I run a sample program (say FirstJCRClient.java) it executes properly giving correct result. </SPAN><BR /><SPAN>2)&nbsp;&nbsp;&nbsp;After that I start Alfresco server and then stop it (using alf_stop script); </SPAN><BR /><SPAN>3)&nbsp;&nbsp;&nbsp;Go back to eclipse and try running FirstFoundationClient, it throws error (as below). </SPAN><BR /><BR /><SPAN>** Note that this is not the case when I perform 1st step –&gt; skip 2nd step and perform 3rd step. FirstFoundationClient executes properly giving correct result.</SPAN><BR /><BR /><SPAN>###################################################################################################</SPAN><BR /><SPAN>Log details:</SPAN><BR /><BR /><SPAN>17:53:30,965 WARN&nbsp; [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one</SPAN><BR /><SPAN>17:53:33,589 WARN&nbsp; [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.</SPAN><BR /><SPAN>17:53:36,589 INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.</SPAN><BR /><SPAN>17:53:38,027 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-60166.sql (Generated).</SPAN><BR /><SPAN>17:53:43,011 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:</SPAN><BR /><SPAN>&nbsp;&nbsp; SQL:&nbsp; alter table alf_access_control_entry add index FKFFF41F99B25A50BF (authority_id), add constraint FKFFF41F99B25A50BF foreign key (authority_id) references alf_authority (recipient)</SPAN><BR /><SPAN>&nbsp;&nbsp; Error: Can't create table '.\alfresco\#sql-464_542.frm' (errno: 150)</SPAN><BR /><SPAN>&nbsp;&nbsp; File: C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-60166.sql</SPAN><BR /><SPAN>&nbsp;&nbsp; Line: 26</SPAN><BR /><SPAN>17:53:43,043 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed</SPAN><BR /><SPAN>java.sql.SQLException: Can't create table '.\alfresco\#sql-464_542.frm' (errno: 150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)</SPAN><BR /><SPAN>###################################################################################################</SPAN><BR /><BR /><SPAN>1 thing skeptical to me is when I stop alfresco server, it every time throwing error like:</SPAN><BR /><BR /><SPAN>***********************************************************************************************************************</SPAN><BR /><SPAN>Server log details:</SPAN><BR /><BR /><SPAN>“LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository”</SPAN><BR /><SPAN>***********************************************************************************************************************</SPAN><BR /><BR /><SPAN>Does the prior issue is because of the later one? Any comments or suggestions? Work around I got for this drop database, create it again things will be back on track. But this is temporary solution. I cannot think of dropping my db in production&nbsp; :roll: </SPAN><BR /><BR /><SPAN>Thanks n reg-</SPAN><BR /><SPAN>Amit.</SPAN></BODY></HTML> Wed, 08 Oct 2008 13:32:48 GMT amit_wmw 2008-10-08T13:32:48Z Strange issue in Alfresco-while executing code. https://connect.hyland.com/t5/alfresco-archive/strange-issue-in-alfresco-while-executing-code/m-p/192185#M145315 Hello Recently 1 strange issue I encountered in Alfresco. Suppose1)&nbsp;&nbsp;&nbsp;When I run a sample program (say FirstJCRClient.java) it executes properly giving correct result. 2)&nbsp;&nbsp;&nbsp;After that I start Alfresco server and then stop it (using alf_stop script); 3)&nbsp;&nbsp;&nbsp;Go back to eclipse and try running FirstFound Wed, 08 Oct 2008 13:32:48 GMT https://connect.hyland.com/t5/alfresco-archive/strange-issue-in-alfresco-while-executing-code/m-p/192185#M145315 amit_wmw 2008-10-08T13:32:48Z Re: Strange issue in Alfresco-while executing code. https://connect.hyland.com/t5/alfresco-archive/strange-issue-in-alfresco-while-executing-code/m-p/192186#M145316 <HTML><HEAD></HEAD><BODY><SPAN>Hi Amit, the LogMananger.repositorySelector (note: "mananger" instead of "manager", always makes me giggle) is unrelated, and is a sort of well-known log4j/tomcat handoff bug. Here's a </SPAN><A href="http://www.mail-archive.com/log4j-user@logging.apache.org/msg09782.html" rel="nofollow noopener noreferrer">succinct explanation of the bug</A><SPAN> and here's </SPAN><A href="https://issues.apache.org/bugzilla/show_bug.cgi?id=43867" rel="nofollow noopener noreferrer">a representative discussion of the bug</A><SPAN>. Maybe someone else on the boards has figured out how to hide it, but I suspect it's going to be showing up in our logs for a while yet.</SPAN><BR /><BR /><SPAN>Looking at your error log, I wonder if the issue is that alfresco's MySQL account has insufficient permission to create new tables. Have you tried running MySQLInnoDBDialect-60166.sql from the MySQL command line, logged in with alfresco's MySQL account?</SPAN></BODY></HTML> Mon, 26 Jan 2009 20:44:46 GMT https://connect.hyland.com/t5/alfresco-archive/strange-issue-in-alfresco-while-executing-code/m-p/192186#M145316 nadaoneal 2009-01-26T20:44:46Z