-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 3.3.3
-
Component/s: Email notifications
-
3.03
The problem is that Sybase refuses to store empty strings and stores spaces instead:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/2485
The reason they provide for this is that an empty value means NULL and as "" is not NULL they have to store a space. Fascinating logic, every other db we support, which is quite a few, seems to deal with it fine.
At the moment the subscriptions die with:
2005-10-28 17:40:36,322 ERROR [atlassian.mail.queue.MailQueueImpl] Error occurred in sending e-mail: com.atlassian.jira.mail.SubscriptionMailQueueItem subject: 'Subscription: Test Filter' Owner: 'admin
com.atlassian.mail.MailException: com.opensymphony.user.EntityNotFoundException: No group found
at com.atlassian.jira.mail.SubscriptionMailQueueItem.send(SubscriptionMailQueueItem.java:67)
at com.atlassian.mail.queue.MailQueueImpl.sendBuffer(MailQueueImpl.java:67)
at com.atlassian.jira.service.services.mail.MailQueueService.run(MailQueueService.java:23)
at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:59)
at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
Caused by: com.opensymphony.user.EntityNotFoundException: No group found
at com.opensymphony.user.UserManager.getEntity(UserManager.java:302)
at com.opensymphony.user.UserManager.getGroup(UserManager.java:172)
at com.atlassian.jira.mail.SubscriptionMailQueueItem.send(SubscriptionMailQueueItem.java:52)
... 6 more
Need to ensure that we store NULL instead of '' for personal subscriptions.