There was a problem backing up data for the null plugin

[Tamer Sherif]

I have Jira service desk 3.15.3 hosted on Windows server 2012 R2 with MySQL database 5.5.

I am trying to back up Jira but i always get error 'There was a problem backing up data for the null plugin'

Here is the related logs inside atlassian-jira.log:

2018-11-08 16:20:22,004 http-nio-80-exec-4 WARN t.sherif 980x4241x1 vtyd6l x.x.x.x /secure/admin/XmlBackup.jspa [c.a.j.w.action.util.XmlBackup] The filename that will be used for exporting is: 'C:\Program Files\Atlassian\Application Data\JIRA\export\8-11-2018.zip'
2018-11-08 16:21:30,784 http-nio-80-exec-9 INFO m.badawy 981x4326x2 12eoxm1 x.x.x.x /secure/AjaxIssueAction.jspa [c.a.j.p.webhooks.matcher.JqlEventMatcher_SLOW] JQL query '{project = "Messaging-SMS"} AND {labels = "Connect"} AND {key in ("SMSSUP-28677")}' produced lucene query and took '796' ms to run.
2018-11-08 16:22:43,392 http-nio-80-exec-4 INFO t.sherif 980x4241x1 vtyd6l x.x.x.x /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Data export completed in 141388ms. Wrote 2588069 entities to export in memory.
2018-11-08 16:22:43,392 http-nio-80-exec-4 INFO t.sherif 980x4241x1 vtyd6l x.x.x.x /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Attempting to save the Active Objects Backup
2018-11-08 16:23:23,063 http-nio-80-exec-4 ERROR t.sherif 980x4241x1 vtyd6l x.x.x.x /secure/admin/XmlBackup.jspa [c.a.j.bc.dataimport.DefaultExportService] Error during Active Objects Backup
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin>:
 at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
 at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:57)
 at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:52)
 at com.atlassian.dbexporter.exporter.DataExporter$1.call(DataExporter.java:49)
 at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:28)
 at com.atlassian.dbexporter.exporter.DataExporter.export(DataExporter.java:49)
 at com.atlassian.dbexporter.DbExporter.exportData(DbExporter.java:49)
 at com.atlassian.activeobjects.backup.ActiveObjectsBackup.save(ActiveObjectsBackup.java:110)
 at com.atlassian.jira.bc.dataimport.DefaultExportService.exportActiveObjects(DefaultExportService.java:184)
 at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:86)
 at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:67)
 at com.atlassian.jira.web.action.util.XmlBackup.doExecute(XmlBackup.java:100)
 ... 1 filtered
 at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
 ... 7 filtered
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
 ... 48 filtered
 at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
 ... 4 filtered
 at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
 ... 12 filtered
 at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
 ... 20 filtered
 at com.intenso.jira.contentinjection.filter.ContentInjectionFilter.doFilter(ContentInjectionFilter.java:71)
 ... 45 filtered
 at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
 ... 1 filtered
 at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
 ... 39 filtered
 at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
 ... 5 filtered
 at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
 at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
 at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
 at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)
 at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
 at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
 at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
 ... 4 filtered
 at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
 ... 8 filtered
 at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
 ... 4 filtered
 at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
 ... 26 filtered
 at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
 ... 24 filtered
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4343382 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
 at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:578)
 at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:418)
 at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3115)
 at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2344)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2739)
 at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4807)
 at org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:540)
 at org.apache.commons.dbcp2.DelegatingConnection.setAutoCommit(DelegatingConnection.java:540)
 at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.setAutoCommit(DelegatingConnection.java:49)
 ... 3 filtered
 at java.lang.reflect.Method.invoke(Method.java:498)
 at net.java.ao.DelegateConnectionHandler.delegate(DelegateConnectionHandler.java:118)
 at net.java.ao.DelegateConnectionHandler.invoke(DelegateConnectionHandler.java:85)
 at com.sun.proxy.$Proxy3974.setAutoCommit(Unknown Source)
 ... 2 filtered
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.atlassian.activeobjects.spi.ConnectionHandler.delegate(ConnectionHandler.java:38)
 at com.atlassian.activeobjects.spi.ConnectionHandler.invoke(ConnectionHandler.java:33)
 at com.sun.proxy.$Proxy4147.setAutoCommit(Unknown Source)
 at com.atlassian.dbexporter.jdbc.JdbcUtils.withNoAutoCommit(JdbcUtils.java:54)

 Any suggestion is appreciated.

[Henrique Bittencourt · Accepted solution]

Hi Tamer!

Seems that this is a MySQL issue:

Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4343382 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
 at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:578)

The max_allowed_packet is too small if I'm not mistaken. You will need to edit my.ini or my.cnf in MySQL and increase this value. More info can be found here:

• com.mysql.jdbc.PacketTooBigException

Hope this helps!

Best Regards.

[Tamer Sherif]

Thanks Henrique this solved the issue.