[Building Sakai] ENTITY_ Tables

[Steve Swinsburg]

I've never seen any data in those tables, possibly due to the index failure on certain MySQL versions, are they needed?

Sent from my iPad

On 09/05/2012, at 8:28 PM, Aaron Zeckoski <azeckoski at unicon.net> wrote:

> Those are just the typical INFO level messages which you are free to
> ignore (in essence, the DDL already ran and cannot run again because
> the tables already exist).
> 
> -AZ
> 
> 
> On Wed, May 9, 2012 at 4:33 AM, David Horwitz <david.horwitz at uct.ac.za> wrote:
>> Hi all
>> 
>> on current trunk I'm seing this on the 2nd and subsequent startup:
>> 
>> INFO Registered entity provider
>> (org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl$2)
>> prefix (batch) with 1 capabilities
>> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
>> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_PROPERTIES (
>> id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
>> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
>> NULL, propertyName    varchar(255) NOT NULL, propertyValue   text NOT
>> NULL, INDEX (entityRef, entityPrefix, propertyName) )]; nested exception
>> is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_PROPERTIES' already
>> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_PROPERTIES' already exists
>> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
>> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_TAG_APPLICATIONS
>> ( id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
>> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
>> NULL, tag             varchar(255) NOT NULL, INDEX (entityRef,
>> entityPrefix, tag) )]; nested exception is
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_TAG_APPLICATIONS' already
>> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_TAG_APPLICATIONS' already exists
>> 
>> 
>> The second and later restarts also fail. I'm not sure why
>> 
>> D
>> 
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> 
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
> 
> 
> -- 
> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"