I don't think this is a DDL issue, it looks to me like your database is in an inconsistent state (e.g. when Jobs were being created all tables were not backed up).Can you dump your database then try and wipe it and try the upload again?
Afraid I'm not familiar with postgres but I'm sure DB dumping is pretty common... Chris On Mon, 05 Mar 2012 11:02:03 +0800 zengshan <[email protected]> wrote: > I am now using the 1.3-rc6 version, where is the sql script?(I am now > using the postgresql database)and how can I turn off the auto ddl? > thank you very much! 2012-03-05 > > > > ZENG SHAN > Tel,861088236837 > E-mail,[email protected] > Computing Center > Institute of High Energy Physics,CAS > > > > > 发件人：Hank Magnuski > 发送时间：2012-03-05 10:55 > 主题：Re: [Matterhorn-users]回复: Re: Fw: upload recording maxsize > 收件人：Matterhorn Users > 抄送： > > > What Matterhorn release are you on? I suggest you upgrade to the > latest 1.3.rc7, initialize your database with the sql script, turn > off auto ddl and try again. > > > On Sun, Mar 4, 2012 at 5:28 PM, zengshan <[email protected]> wrote: > > Hi Hank, > After I upload a video which is 670MB, the log shows that(and it > keeps existed after the upload opertion is failed): Caused by: > org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "unq_job_arguments_0" _______________________________________________ Matterhorn-users mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
