Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Crowd starts with error

BT-EGM
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 11, 2019

Hi,

When Crowd started, I'm getting SQL Constraint error as follows;

 

Caused by: java.sql.SQLException: Constraint already exists: FKAD5HDVSJWPAH0OJNR
AAQT2VQS in statement [
alter table SITEAPPROVAL
add constraint FKad5hdvsjwpah0ojnraaqt2vqs
foreign key (PROFILE_ID)
references PROFILE]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

 

Caused by: java.sql.SQLException: Constraint already exists: FKHB62I9MD6E0P9OPG5
7UYII4B3 in statement [
alter table SITEAPPROVAL
add constraint FKhb62i9md6e0p9opg57uyii4b3
foreign key (SITE_ID)
references SITE]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

 

Caused by: java.sql.SQLException: Constraint already exists: FKQAF1TEP0XTTUBL9E3
LKRM3FQK in statement [
alter table SITEAPPROVAL
add constraint FKqaf1tep0xttubl9e3lkrm3fqk
foreign key (USER_ID)
references OPENIDUSER]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

 

Please Help Us, Thanks in advance.

1 answer

0 votes
Gaurav
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 20, 2019

Hi @BT-EGM ,

 

This is just harmless errors in Crowd, which you will see if you are running a version newer than 3.3.0.

This is something which you can ignore, there is a public-facing issue for this already to suppress this DDL error logs.

 

Thanks,

Gaurav

Christian Schlaefcke August 9, 2019

Hi @Gaurav, can you post the issue link, please?

Like sysadmin likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events