Oops, I've wiped it out and am kinda scared to undo our production cluster at the moment. Can I give you feedback when am done with setting up the rest of our production cluster? I'll try reconstruct what I did on a dev environment. But just to recap these are the steps I took (am sunning SLES 11.1); Installed the latest community version of MySQL (v5.5.9-1) and matterhorn user and DB with UTF-8 encoding Imported the matterhorn sql file using: mysql -p matterhorn < mysql5.sql Started up a worker node (SLES 11.1) without ddl running branch 1.1.x revision 9873 :)
-- Lovemore Nalube OLE Developer (Vula) University of Cape Town http://www.cet.uct.ac.za/LovemoreN >>> On 2/20/2011 at 8:36 AM, in message <[email protected]>, Josh Holtzman <[email protected]> wrote: 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 <[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 ( tel:%2B27%2021%20650%209111 ). 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 ( tel:%2B27%2021%20650%209111 ). 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] _______________________________________________ ### 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] _______________________________________________
