Oops - an error has occurred

[김도영]

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

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

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)

[Nic Brough -Adaptavist-]

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?

[Nic Brough -Adaptavist-]

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.