[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-498) Postgres Hudson configurations fail by SQLGrammarException

[Strong Liu (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36212#action_36212 ] 

Strong Liu commented on HSEARCH-498:
------------------------------------

    drop table Person
18:49:14,770 DEBUG SchemaExport:362 - Unsuccessful: drop table Person
18:49:14,770 DEBUG SchemaExport:363 - ERROR: cannot drop table person because other objects depend on it
18:49:14,770 DEBUG SchemaExport:377 - 
    drop sequence hibernate_sequence
18:49:15,181 DEBUG SchemaExport:362 - Unsuccessful: drop sequence hibernate_sequence
18:49:15,181 DEBUG SchemaExport:363 - ERROR: sequence "hibernate_sequence" does not exist
18:49:15,181 DEBUG SchemaExport:377 - 
    create table EmailAddress (
        id int4 not null,
        address varchar(255),
        isDefaultAddress bool not null,
        SPECIALPERSON_FK int4,
        primary key (id)
    )
18:49:15,593 DEBUG SchemaExport:377 - 
    create table Person (
        DISC varchar(31) not null,
        id int4 not null,
        name varchar(255),
        DEFAULT_EMAILADDRESS_FK int4,
        primary key (id)
    )
18:49:15,900 ERROR SchemaExport:348 - Unsuccessful: create table Person (DISC varchar(31) not null, id int4 not null, name varchar(255), DEFAULT_EMAILADDRESS_FK int4, primary key (id))
18:49:15,900 ERROR SchemaExport:349 - ERROR: relation "person" already exists
18:49:15,901 DEBUG SchemaExport:377 - 
    alter table EmailAddress 
        add constraint FKC9F634D8F8545DF0 
        foreign key (SPECIALPERSON_FK) 
        references Person
18:49:16,307 DEBUG SchemaExport:377 - 
    alter table Person 
        add constraint FK8E4887758C04039A 
        foreign key (DEFAULT_EMAILADDRESS_FK) 
        references EmailAddress
18:49:16,716 ERROR SchemaExport:348 - Unsuccessful: alter table Person add constraint FK8E4887758C04039A foreign key (DEFAULT_EMAILADDRESS_FK) references EmailAddress
18:49:16,716 ERROR SchemaExport:349 - ERROR: column "default_emailaddress_fk" referenced in foreign key constraint does not exist
18:49:16,716 DEBUG SchemaExport:377 - 

> Postgres Hudson configurations fail by SQLGrammarException
> ----------------------------------------------------------
>
>                 Key: HSEARCH-498
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-498
>             Project: Hibernate Search
>          Issue Type: Sub-task
>            Reporter: Sanne Grinovero
>            Assignee: Strong Liu
>             Fix For: 3.2.0.CR1
>
>
> See http://hudson.jboss.org/hudson/view/hibernate/job/hibernate-search-trunk/database=postgresql824,jdk=java15_default,label=hibernate/lastBuild/testReport/org.hibernate.search.test.worker.duplication/WorkDuplicationTest/testNoWorkDuplication/

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira