Problem with deleting an issue in Jira (v7.10.1#710002)

[webncut]

Hi :),

I updated to 7.10 from 7.08... all works well.

But when I try to delete an Issue the System post that error:

Technische Details
Verweisnummer des Protokolls: 687097ff-96f9-4101-8dad-35fb0e796ccc

Ursache
Verweiser-URL: http://Xxx.xx:1550/secure/RapidBoard.jspa?rapidView=1&projectKey=TODO&view=detail&selectedIssue=TODO-26

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
 - name:MySQL
 - version:5.7.9
 - minor version:7
 - major version:5
Driver:
 - name:MySQL Connector Java
 - version:mysql-connector-java-5.1.38 ( Revision: fe541c166cec739c74cc727c5da96c1028b4834a )

java.sql.SQLException: Field 'ID' doesn't have a default value
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
 Database:
 - name:MySQL
 - version:5.7.9
 - minor version:7
 - major version:5
 Driver:
 - name:MySQL Connector Java
 - version:mysql-connector-java-5.1.38 ( Revision: fe541c166cec739c74cc727c5da96c1028b4834a )
 
 java.sql.SQLException: Field 'ID' doesn't have a default value
 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:94) [?:?]
 at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:266) [?:?]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [?:1.8.0_151]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_151]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_151]
 at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_151]
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) [?:?]
 at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) [?:?]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) [?:?]
 at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) [?:?]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) [?:?]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
 at com.sun.proxy.$Proxy3247.create(Unknown Source) [?:?]
 ... .
 ... 284 more

All DB checks and index should be fine.... What can I do with that "java.sql.SQLException: Field 'ID' doesn't have a default value" Problem in my SQL Database?

Kind regards

Marcel Schiwek

[Andy Heinzer]

@webncut From reading your stacktrace, it is not clear to me which table is trying to be updated here.   So I believe we're going to need to see more complete logs to better help here.  Unfortunately, our Community site does not yet allow for uploading of such binary files.  So I created a support case for you here where we can gather those logs.  Please see https://getsupport.atlassian.com/servicedesk/customer/portal/20/GHS-121108 for more details.

@Radek Dostál In this case, Marcel does not have access to the main customer support portal.  For starter licenses, users that try to post to https://support.atlassian.com are actually getting redirected here to community.

[Radek Dostál]

Ah, thanks for clarifying :)

My bad - that didn't occur to me.

[Radek Dostál]

Hi Marcel,

These questions are better discussed with Atlassian Support as they can properly analyze and help you resolve technical issues.

You could get lucky on the forums, but there're no guarantees.

Regards,

Radek

[webncut]

I thought there are also the Atlassian developer here?

I cant find another way for an direkt question to an Atlassian Developer...!

"Atlassian developers and support staff are part of this community too and can answer your more technical questions."