-
Suggestion
-
Resolution: Fixed
The table "AUTH_ATTEMPT_INFO" holds information about what login user was tried, how many times and when was last attempt.
Bamboo's backup tries to dump every table including the above one. Eventually, username(s) with invalid characters could cause problems when we creating the backup.
... 2014-10-01 22:01:39,584 INFO [QuartzScheduler_Worker-8] [XmlMigrator] Ensuring the the file has been unmounted 2014-10-01 22:01:39,584 INFO [QuartzScheduler_Worker-8] [XmlMigrator] Unmounted /path/to/backup/bamboo_backup_2014_10_01.zip 2014-10-01 22:01:39,637 INFO [QuartzScheduler_Worker-8] [ServerLifecycleManagerImpl] Server state changed to 'RUNNING' from 'PAUSED' 2014-10-01 22:01:39,637 ERROR [QuartzScheduler_Worker-8] [ScheduledBackupJob] com.ctc.wstx.exc.WstxIOException: Invalid null character in text to output com.ctc.wstx.exc.WstxIOException: Invalid null character in text to output at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:464) at org.codehaus.staxmate.out.SMOutputContext.writeCharacters(SMOutputContext.java:479) at org.codehaus.staxmate.out.SMOutputContainer.addCharacters(SMOutputContainer.java:171) at com.atlassian.bamboo.migration.SMOutputElementAppender.append(SMOutputElementAppender.java:39) at com.atlassian.bamboo.migration.stream.LoginInformationMapper.exportProperties(LoginInformationMapper.java:70) at com.atlassian.bamboo.migration.stream.LoginInformationMapper.exportProperties(LoginInformationMapper.java:22) at com.atlassian.bamboo.migration.BambooStAXMappingHelperAbstractImpl.exportXml(BambooStAXMappingHelperAbstractImpl.java:108) at com.atlassian.bamboo.migration.BambooStAXMappingListHelperAbstractImpl.exportListXml(BambooStAXMappingListHelperAbstractImpl.java:169) at com.atlassian.bamboo.migration.BambooStAXMappingListHelperAbstractImpl.exportListXml(BambooStAXMappingListHelperAbstractImpl.java:147) at com.atlassian.bamboo.migration.stream.LoginInformationMapper.exportData(LoginInformationMapper.java:125) at com.atlassian.bamboo.migration.XmlMigrator.exportToStream(XmlMigrator.java:498) at com.atlassian.bamboo.migration.XmlMigrator.exportXml(XmlMigrator.java:428) at com.atlassian.bamboo.migration.XmlMigrator$$FastClassByCGLIB$$b6578fc7.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:694) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:629) at com.atlassian.bamboo.migration.XmlMigrator$$EnhancerByCGLIB$$7f976207.exportXml(<generated>) at com.atlassian.bamboo.migration.ImportExportManagerImpl.bambooExport(ImportExportManagerImpl.java:95) at com.atlassian.bamboo.configuration.ScheduledBackupJob.execute(ScheduledBackupJob.java:75) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at com.atlassian.bamboo.utils.BambooRunnables$1.run(BambooRunnables.java:49) at com.atlassian.bamboo.security.ImpersonationHelper.runWith(ImpersonationHelper.java:31) at com.atlassian.bamboo.security.ImpersonationHelper.runWithSystemAuthority(ImpersonationHelper.java:20) at com.atlassian.bamboo.security.ImpersonationHelper$1.run(ImpersonationHelper.java:52) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) Caused by: java.io.IOException: Invalid null character in text to output at com.ctc.wstx.api.InvalidCharHandler$FailingHandler.convertInvalidChar(InvalidCharHandler.java:51) at com.ctc.wstx.sw.XmlWriter.handleInvalidChar(XmlWriter.java:623) at com.ctc.wstx.sw.RestrictedCharsAwareBufferingXmlWriter.writeCharacters(RestrictedCharsAwareBufferingXmlWriter.java:557) at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:462) ... 27 more ...
Workaround
Clean data from that table as per following. It's only used for CAPTCHA so it's not that important.
DELETE FROM AUTH_ATTEMPT_INFO;
This should solve error message during backup.
