Oops - an error has occurred

We are getting an error when admin user login into confluence.

(So, we cannot find the SEN serial#.)

 

 

capture.GIF

 

Below is an error message.

---------------------------------------------------------------------------------

2017-10-16 10:11:21,173 ERROR [http-bio-8090-exec-6] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Field 'group_type' doesn't have a default value
2017-10-16 10:11:21,178 ERROR [http-bio-8090-exec-6] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
2017-10-16 10:11:21,182 ERROR [http-bio-8090-exec-6] [[Standalone].[localhost].[/].[action]] log Servlet.service() for servlet [action] in context with path [] threw exception
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#14057521]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1364]; Field 'group_type' doesn't have a default value; nested exception is java.sql.SQLException: Field 'group_type' doesn't have a default value
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
at com.atlassian.crowd.embedded.hibernate2.HibernateMembershipDao.internalFindAllUserMemberships(HibernateMembershipDao.java:180)
at

 

.......


2017-10-16 10:11:21,186 INFO [http-bio-8090-exec-6] [atlassian.confluence.status.SystemErrorInformationLogger] writeToLog
Request Unique ID : edd4da85-61d1-4f48-970a-2329490f4716

--------------------------
JVM Stats
--------------------------
allocatedHeap = 1073741824
usedMemory = 784946216
availablePermGen = 77702800
totalMemory = 1073741824
freeMemory = 288795608
maxPermGen = 268435456
usedPermGen = 190732656
freeMemoryInMegabytes = 275
freeAllocatedHeap = 288795608
availableHeap = 288795608
usedMemoryInMegabytes = 748
maxHeap = 1073741824
usedHeap = 784946216
totalMemoryInMegabytes = 1024
--------------------------

Request Information
--------------------------
URL: https://confluence.kinx.kr/500page.jsp
Scheme: https
Server: confluence.kinx.kr
Port: 443
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: null
--------------------------
Attributes
--------------------------
javax.servlet.forward.request_uri: /dologin.action
javax.servlet.forward.context_path:
javax.servlet.forward.servlet_path: /dologin.action
os_securityfilter_already_filtered: true
atlassian.core.seraph.original.url: /500page.jsp
com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter: true
javax.servlet.error.status_code: 500
javax.servlet.error.servlet_name: action
com.atlassian.gzipfilter.GzipFilter_already_filtered: true
loginfilter.already.filtered: true
com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered: true
Confluence-Request-Time: 1508148680837
javax.servlet.error.message:
com.opensymphony.sitemesh.APPLIED_ONCE: true
com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered: true
__cleanup_recursion_counter: 0
com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter_already_filtered: true
javax.servlet.error.exception: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#14057521]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1364]; Field 'group_type' doesn't have a default value; nested exception is java.sql.SQLException: Field 'group_type' doesn't have a default value
com.atlassian.confluence.login.direct: true
javax.servlet.error.request_uri: /dologin.action
com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter: true
--------------------------
Parameters
--------------------------
os_destination : /admin/raisesupportrequest.action
os_username : dykim36@kinx.net
login : Log in
caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#14057521]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1364]; Field 'group_type' doesn't have a default value; nested exception is java.sql.SQLException: Field 'group_type' doesn't have a default value
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
caused by: java.sql.SQLException: Field 'group_type' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)

1 answer

0 votes

That sounds like the database is set up incorrectly for Crowd.  I suspect you have the "strict trans tables" flag on.

Oh...thanks.

So you mean...i should turn off "strict trans tables" option?

Yes.

Hi, Nic. 

I'm sorry. That option was not set already...

I checked with this query "SELECT @@sql_mode;"

I found the answer.

The mysql data backup was wrong. So, cwd_membership table has weird columns.

 

The cwd_membership table should not include group_type field.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 11, 2018 in Confluence

What are your project planning tips?

Hello Community,  Jessica here from the Confluence product marketing team! Today I wanted to get your takes on project planning –– what works, what doesn’t, how do you know if you’re doing it r...

320 views 1 4
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you