Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
4.0, 4.0.1, 4.0.2, 4.1, 4.1.1, 4.1.2, 4.2
-
Trunk 4.2 - r128675, Postgres 8.4.4
-
4
-
2
-
Severity 2 - Major
-
Description
When starting up JIRA under a Turkish locale you are unable to create issues. It looks like Ofbiz is being hit by http://www.mattryall.net/blog/2009/02/the-infamous-turkish-locale-bug. You get the following warnings and errors:
2010-09-29 11:13:57,092 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: ALTER TABLE public.favouriteassociations ADD ID NUMERIC(18,0) Error was: org.postgresql.util.PSQLException: ERROR: column "id" of relation "favouriteassociations" already exists 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "DESCR?PT?ON" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "F?ELD?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Column "CUSTOMF?ELD" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field 2010-09-29 11:13:57,092 main WARN [core.entity.jdbc.DatabaseUtil] Field "description" of entity "FieldConfigScheme" is missing its corresponding column "DESCRIPTION" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] Could not add column "DESCRIPTION" to table "public.fieldconfigscheme" 2010-09-29 11:13:57,093 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,285 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following: SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig' Error was: 2010-09-29 11:14:15,286 main WARN [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?. 2010-09-29 11:14:15,286 main ERROR [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null 2010-09-29 11:14:15,288 main ERROR [sal.jira.scheduling.JiraPluginScheduler] Error adding service to jira org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ServiceConfig][id,null][time,28800000][name,Service Provider Token Remover][clazz,com.atlassian.sal.jira.scheduling.JiraPluginSchedule rService] (SQL Exception while executing the following:INSERT INTO public.serviceconfig (ID, delaytime, CLAZZ, servicename) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149)
2010-09-29 12:49:20,291 http-8090-Processor6 ERROR admin 769x2237x1 vqg7s 0:0:0:0:0:0:0:1%0 /secure/CreateIssueDetails.jspa [atlassian.jira.workflow.SimpleWorkflowManager] Error occured while creating issue. com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint)) at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry(OfbizWorkflowStore.java:119)
Work around
The only workaround is to start JIRA under a non-Turkish locale. You can still see JIRA in Turkish when you do this. Check out JRA-22386 for details on how to do this.
Attachments
Issue Links
- is incorporated by
-
JRASERVER-22386 JIRA does not run under a Turkish locale
- Closed