topic Re: Alfresco 3.0 fails to start -- More than one Alfresco schema was found in Alfresco Archive

Alfresco 3.0 fails to start -- More than one Alfresco schema was found

johnny_fever442 — Wed, 06 Aug 2014 23:03:46 GMT

Hi,So our Data Center took a power hit and our racks lost power. Upon reboot of the Linux server that runs Alfresco we see this in our alfresco.log:————————-18:43:34,821 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.18:43:34,949

Re: Alfresco 3.0 fails to start -- More than one Alfresco schema was found

mrogers — Thu, 07 Aug 2014 21:03:34 GMT

Is your database running? IIRC that dialect stuff nonsense can also be caused by failure to connect to the database.

The first location is the correct one. Editing stuff in web-inf is always wrong.

Re: Alfresco 3.0 fails to start -- More than one Alfresco schema was found

johnny_fever442 — Thu, 07 Aug 2014 21:31:47 GMT

Hello!

Thanks so much for the reply mrogers… you have given us hope here in Seattle.

To answer your first question, yes MySQL is running as we can see via:

[Thu Aug 07 | root@babbage:/tmp/Alf_Restore]$ service mysqld status
mysqld (pid 6342) is running…

[Thu Aug 07 | root@babbage:/tmp/Alf_Restore]$ lsof -i | grep -i mysql

mysqld 6342 mysql 3u IPv4 15767 TCP *:mysql (LISTEN)

And the user alfresco can connect to the alfresco db:

[Thu Aug 07 | root@babbage:/tmp/Alf_Restore]$ mysql -u alfresco -p alfresco
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 106
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

—————

So can you please specify what file is the correct one? Like with the exact file name?

When you say editing stuff in web-inf is always wrong both files that we tried have that in their directory path:

#1) /usr/share/apache-tomcat-6.0.20/webapps/alfresco/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties

#2) /usr/share/apache-tomcat-6.0.20/webapps/alfresco/WEB-INF/classes/alfresco/extension/custom-hibernate-dialect.properties

Should we edit door #1 or door #2?

THANKS!

-jg

Re: Alfresco 3.0 fails to start -- More than one Alfresco schema was found

johnny_fever442 — Fri, 08 Aug 2014 17:17:04 GMT

WE HAVE SOLVED IT!!! Thanks to mrogers and some more digging we found that the INNODB engine was disabled when the power outage hit. MySQL was up but the InnoDB engine was down.. that's why we were getting this error in the alfresco.log

Hope this info helps someone along the way!

Peace from SeaTown!

-jg

Re: Alfresco 3.0 fails to start -- More than one Alfresco schema was found

johnny_fever442 — Fri, 09 Jan 2015 20:01:19 GMT

For anyone ever experiencing this issue again here is a more detailed write up of the problem:

http://samurai-sysadmin.com/?p=79