Exclude AUTH_ATTEMPT_INFO from Bamboo's backup

XMLWordPrintable

      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.

            Assignee:
            Przemek Bruski
            Reporter:
            Rafael Sperafico (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: