I'd still like to figure out what went wrong, and whether or not we have a bug. Do you see any differences in the host registration table between the DDL script and a mysql schema dump from your running system?
Thanks, Josh On Sun, Feb 20, 2011 at 4:29 AM, Lovemore Nalube <[email protected]>wrote: > I am running r9873. I worked around the problem by letting the nodes use > auto ddl for the initial startup. > > > -- > Lovemore Nalube > OLE Developer (Vula) > University of Cape Town > http://www.cet.uct.ac.za/LovemoreN > > >>> On 2/19/2011 at 11:10 AM, in message <AANLkTi=4Jziw7-C+LMPHf2wevgz= > [email protected]>, Josh Holtzman <[email protected]> > wrote: > I'm also using the 1.1.x branch, at revision 9938, using mysql5 with > the DDL script from svn, but I don't see this error. > > > Looks like the HOST_REGISTRATION table is missing a default value. > > The database schema shouldn't have default values for ID columns, > since the JPA implementation takes care of ID generation. Here's the > relevant Java that determines this behavior (from > HostRegistration.java): > > @Id > @Column > @GeneratedValue > protected Long id; > > By default, Eclipselink uses a table named "SEQUENCE" to hand out > identifiers. > > I've included some information about my mysql server below. Are you > running a different mysql version? Is the code revision you're > running aligned with the DDL revision? > > Thanks, > Josh > > mysql> \s > -------------- > mysql Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using > EditLine wrapper > > Connection id: 1 > Current database: matterhorn > Current user: root@localhost > SSL: Not in use > Current pager: stdout > Using outfile: '' > Using delimiter: ; > Server version: 5.0.91-log Source distribution > Protocol version: 10 > Connection: Localhost via UNIX socket > Server characterset: utf8 > Db characterset: utf8 > Client characterset: latin1 > Conn. characterset: latin1 > UNIX socket: /var/mysql/mysql.sock > Uptime: 3 days 22 hours 42 min 1 sec > > Threads: 4 Questions: 527 Slow queries: 0 Opens: 51 Flush tables: > 1 Open tables: 13 Queries per second avg: 0.002 > -------------- > > mysql> describe host_registration; > +-------------+--------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-------------+--------------+------+-----+---------+-------+ > | ID | bigint(20) | NO | PRI | NULL | | > | HOST | varchar(255) | NO | UNI | NULL | | > | MAINTENANCE | tinyint(1) | NO | | 0 | | > | MAX_JOBS | int(11) | NO | | NULL | | > | ONLINE | tinyint(1) | NO | | 0 | | > +-------------+--------------+------+-----+---------+-------+ > 5 rows in set (0.00 sec) > > On Sat, Feb 19, 2011 at 5:38 AM, Lovemore Nalube > <[email protected]> wrote: > > > > Hi Everyone > > > > I'm sitting on this database error at host registration: > > > > Caused by: > org.opencastproject.serviceregistry.api.ServiceRegistryException: > javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse > Persistence Services - 2.0.2.v20100323-r6872): > org.eclipse.persistence.exceptions.DatabaseException > > Internal Exception: java.sql.SQLException: Field 'ID' doesn't have a > default value > > Error Code: 1364 > > Call: INSERT INTO HOST_REGISTRATION (HOST, MAINTENANCE, MAX_JOBS, ONLINE) > VALUES (?, ?, ?, ?) > > bind => [http://srvslsopc003.uct.ac.za, false, 4, true] > > Query: InsertObjectQuery(http://gsadcbjdhbv.uct.ac.za) > > at > org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.registerHost(ServiceRegistryJpaImpl.java:468) > > at > org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.activate(ServiceRegistryJpaImpl.java:161) > > This happens on a clean install of Matterhorn and MySql (v5.5.9-1) after > manually running the ddl sql scripts. The Matterhorn startup fails after > this. > > > > Looks like the HOST_REGISTRATION table is missing a default value. If > this is a bug on the 1.1.x branch I'll file a jira. > > > > Thanks > > > > > > -- > > Lovemore Nalube > > OLE Developer (Vula) > > University of Cape Town > > http://www.cet.uct.ac.za/LovemoreN > > > > > > ### > > > > UNIVERSITY OF CAPE TOWN > > > > This e-mail is subject to the UCT ICT policies and e-mail disclaimer > published on our website at > http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 > 21 650 9111. This e-mail is intended only for the person(s) to whom it is > addressed. If the e-mail has reached you in error, please notify the author. > If you are not the intended recipient of the e-mail you may not use, > disclose, copy, redirect or print the content. If this e-mail is not related > to the business of UCT it is sent by the sender in the sender's individual > capacity. > > > > ### > > > > _______________________________________________ > > Matterhorn mailing list > > [email protected] > > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > > > > To unsubscribe please email > > [email protected] > > _______________________________________________ > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ > > ### > > UNIVERSITY OF CAPE TOWN > > This e-mail is subject to the UCT ICT policies and e-mail disclaimer > published on our website at > http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 > 21 650 9111. This e-mail is intended only for the person(s) to whom it is > addressed. If the e-mail has reached you in error, please notify the author. > If you are not the intended recipient of the e-mail you may not use, > disclose, copy, redirect or print the content. If this e-mail is not related > to the business of UCT it is sent by the sender in the sender's individual > capacity. > > ### > > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ >
_______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
