Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-66153

JIRA increments pcounter when UTF encoding errors occurs

    XMLWordPrintable

Details

    Description

      If a JIRA mail handler encounters a UTF encoding error, no issue will be created, but the pcounter of a project will still be incremented. The mail will never be removed from the inbox so the mail handler will try to process the mail constantly.

      Because the mail is never removed, the ticket IDs will be incremented constantly, causing some strange jumps when creating tickets.

      [Created via e-mail received from: "User Name" <inbox@inbox.com>]][priority,5][timeestimate,null][duedate,null][timeoriginalestimate,null][watches,0][key,KEY-xxxx] (SQL Exception while executing the following:INSERT INTO public.jiraissue (ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: invalid byte sequence for encoding "UTF8": 0x00
        Hint: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".))
      	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:451)
      	at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssueObject(DefaultIssueManager.java:517)
      	at com.atlassian.jira.service.util.handler.DefaultMessageHandlerContext.createIssue(DefaultMessageHandlerContext.java:73)
      	at com.atlassian.jira.service.services.mail.DelegatingMessageHandlerContext.createIssue(DelegatingMessageHandlerContext.java:47)
      	at com.atlassian.jira.plugins.mail.handlers.CreateIssueHandler.handleMessage(CreateIssueHandler.java:242)
      	at com.atlassian.jira.plugins.mail.handlers.CreateOrCommentHandler.handleMessage(CreateOrCommentHandler.java:133)
      	at com.atlassian.jira.service.services.mail.MailFetcherService$1.process(MailFetcherService.java:368)
      	at com.atlassian.jira.service.services.mail.MailFetcherService$MessageProviderImpl.getAndProcessMail(MailFetcherService.java:271)
      	at com.atlassian.jira.service.services.mail.MailFetcherService.runImpl(MailFetcherService.java:356)
      	at com.atlassian.jira.service.services.file.AbstractMessageHandlingService.run(AbstractMessageHandlingService.java:257)
      	at com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:61)
      	at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:47)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
      Caused by: com.atlassian.jira.workflow.WorkflowException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Summary here][status,1][votes,0][assignee,user][security,null][resolutiondate,null][type,7][timespent,null][id,39385][reporter,reporterUser][project,10092][environment,null][created,2013-03-20 15:20:07.626][updated,2013-03-20 15:20:07.626][workflowId,41356][description,EMAIL BODY CONTENT HERE
      

      The SQL log will show these messages constantly

      atlassian-jira-sql.log.1:2013-03-20 14:36:01,539 ProjectCounterUpdateThread-1 ServiceRunner   Support Emails 2ms "UPDATE public.project SET  pcounter = '4900'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:36:02,342 ProjectCounterUpdateThread-2 ServiceRunner   Support Emails 1ms "UPDATE public.project SET  pcounter = '4901'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:38:01,391 ProjectCounterUpdateThread-3 ServiceRunner   Support Emails 3ms "UPDATE public.project SET  pcounter = '4902'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:38:02,572 ProjectCounterUpdateThread-0 ServiceRunner   Support Emails 2ms "UPDATE public.project SET  pcounter = '4903'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:40:01,777 ProjectCounterUpdateThread-1 ServiceRunner   Support Emails 3ms "UPDATE public.project SET  pcounter = '4904'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:40:02,894 ProjectCounterUpdateThread-2 ServiceRunner   Support Emails 1ms "UPDATE public.project SET  pcounter = '4905'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:42:01,991 ProjectCounterUpdateThread-3 ServiceRunner   Support Emails 2ms "UPDATE public.project SET  pcounter = '4906'  WHERE ID='10092'"
      atlassian-jira-sql.log.1:2013-03-20 14:42:02,908 ProjectCounterUpdateThread-0 ServiceRunner   Support Emails 2ms "UPDATE public.project SET  pcounter = '4907'  WHERE ID='10092'"
      

      No issues will be created or any other errors appearing to the user, causing confusing as the project counter jumps around at seemingly random.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              73f0b2e75f82 Sorin Sbarnea (Citrix)
              Votes:
              3 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: