Alfresco application not starting on Tomcat

[xymak1y]

Hello,

following setup:
xampp-win32-1.7.4-VC6 including MySQL and Tomcat, and MySQL connector mysql-connector-java-5.1.14 (not community). The database connection is working, Alfresco added a alf_bootstrap_lock  table to it, so the connection is up and running.

Java opts:

set JAVA_OPTS=-Xms256m -Xmx1024m -Xss96k -XX:MaxPermSize=256m -server‍

During deployment, memory usage is spiking. Going up to 500MB at times. Takes forever for Tomcat to shut down, too.
Also the cmd.exe output hangs for a very long time at

Here is the log for a fresh deployment of alfresco.war
http://nopaste.voric.com/paste.php?f=ugvcrv

In TC manager, I see alfresco, but I can't start it. I get an error message if I do.

Something is going wrong with the Schema Update during deployment, I think.
Deployment and starting both hang at this output for a significantly long time:

12:49:29,594  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.M
ySQLInnoDBDialect.

Here is a screenshot of the user setup for MySQL:
[img]http://i.imgur.com/rEQZK.gif[/img]

Any ideas?

Thanks!

[mrogers]

"org.alfresco.error.AlfrescoRuntimeException: 01070000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again."

You probably got impatient and killed Alfresco while it was installing the DB.    It should take a couple of minutes.    If this is a new install then drop the database and delete the content store and start again.    If not restore from backup.

[xymak1y]

I emptied the database, removed all users and set it up from scratch:

CREATE DATABASE alfresco DEFAULT CHARACTER SET utf8;

GRANT ALL ON alfresco.* TO 'alfresco'@'localhost' identified BY 'alfresco' WITH
GRANT OPTION;

GRANT ALL ON alfresco.* TO 'alfresco'@'localhost.localdomain' identified BY
'alfresco' WITH GRANT OPTION;‍‍‍‍‍‍‍

I then cleaned up the stopped TC, cleaned up the /webapps directory, and re-deployed all three .war files.

This is the log file after deploying:

http://nopaste.voric.com/paste.php?f=lpuqlk

Apparently the SQL is malformed? The database is running on InnoDB engine.