Details
-
Bug
-
Resolution: Duplicate
-
Low
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
- duplicates
-
JRASERVER-59061 Jira Mail Handler error "invalid byte sequence for encoding "UTF8": 0x00" prevents creation of issues by email
- Closed
-
JRASERVER-15159 Issue ID is not reused, if JIRA fails to create an issue from an email message.
- Closed
- is caused by
-
JRASERVER-59061 Jira Mail Handler error "invalid byte sequence for encoding "UTF8": 0x00" prevents creation of issues by email
- Closed