Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-15093

Exclude AUTH_ATTEMPT_INFO from Bamboo's backup

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: