Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-32362

ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT"

XMLWordPrintable

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Below exception occurs after migrating database from MySQL to Oracle database.

      java.sql.SQLException: ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 306, maximum: 255)

      Below is the DDL for the particular table:

        CREATE TABLE "C530TEST"."ATTACHMENTS" 
   (	"ATTACHMENTID" NUMBER(19,0) NOT NULL ENABLE, 
	"TITLE" VARCHAR2(255) NOT NULL ENABLE, 
	"CONTENTTYPE" VARCHAR2(255) NOT NULL ENABLE, 
	"PAGEID" NUMBER(19,0) NOT NULL ENABLE, 
	"CREATOR" VARCHAR2(255), 
	"CREATIONDATE" DATE, 
	"LASTMODIFIER" VARCHAR2(255), 
	"LASTMODDATE" DATE, 
	"FILESIZE" NUMBER(19,0), 
	"ATTACHMENT_COMMENT" VARCHAR2(255), 
	"ATTVERSION" NUMBER(10,0), 
	"PREVVER" NUMBER(19,0), 
	 PRIMARY KEY ("ATTACHMENTID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE, 
	 CONSTRAINT "FK54475F908C38FBEA" FOREIGN KEY ("PAGEID")
	  REFERENCES "C530TEST"."CONTENT" ("CONTENTID") ENABLE, 
	 CONSTRAINT "FK_ATTACHMENTS_LASTMODIFIER" FOREIGN KEY ("LASTMODIFIER")
	  REFERENCES "C530TEST"."USER_MAPPING" ("USER_KEY") ENABLE, 
	 CONSTRAINT "FK54475F9017D4A070" FOREIGN KEY ("PREVVER")
	  REFERENCES "C530TEST"."ATTACHMENTS" ("ATTACHMENTID") ENABLE, 
	 CONSTRAINT "FK_ATTACHMENTS_CREATOR" FOREIGN KEY ("CREATOR")
	  REFERENCES "C530TEST"."USER_MAPPING" ("USER_KEY") ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"

      Please investigate the possibilities of having it increased to avoid similar issues.

      Thank you and regards,
      Lazuardi

            [CONFSERVER-32362] ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT"

            Adam Barnes (Inactive) added a comment -
            Atlassian update

            Thank you for raising this suggestion. We regret to inform you that due to limited demand, we have no plans to implement it in the foreseeable future. In order to set expectations, we're closing this request now. Sometimes potentially valuable tickets do get closed where the Summary or Description has not caught the attention of the community. If you feel that this suggestion is valuable, consider describing in more detail or outlining how this request will help you achieve your goals. We may then be able to provide better guidance. Thanks again.
            Regards,
            Confluence Product Management

            Adam Barnes (Inactive) added a comment - Atlassian update Thank you for raising this suggestion. We regret to inform you that due to limited demand, we have no plans to implement it in the foreseeable future. In order to set expectations, we're closing this request now. Sometimes potentially valuable tickets do get closed where the Summary or Description has not caught the attention of the community. If you feel that this suggestion is valuable, consider describing in more detail or outlining how this request will help you achieve your goals. We may then be able to provide better guidance. Thanks again. Regards, Confluence Product Management

            Yuriy Golobokov added a comment -

            I also want to mention that this is applicable not only for this table, but for all tables containing CHAR and VARCHAR2 fields.

            Yuriy Golobokov added a comment - I also want to mention that this is applicable not only for this table, but for all tables containing CHAR and VARCHAR2 fields.

            Yuriy Golobokov added a comment - - edited

            I want to add more details:

            We do use utf-8 in MySQL and AL32UTF8 in Oracle.
            So, I suppose that's not the "wrong encoding" case.

            As I said in Confluence support ticket:

            It turned out that MySQL count letters and Oracle count bytes by default. And we use Russian language along with English. That's why our cyrillic 255 characters value in MySQL won't fit in Oracle 255 byte field.

            I believe that Oracle tables should be created with definition of character limitations instead of default.
            I. e.
            CREATE TABLE ... ( "TITLE" VARCHAR2(255CHAR)
            instead of
            CREATE TABLE ... ( "TITLE" VARCHAR2(255)
            or
            CREATE TABLE ... ( "TITLE" VARCHAR2(255BYTE)

            Then string length limitations will be consistent between MySQL and Oracle DBs.

            Yuriy Golobokov added a comment - - edited I want to add more details: We do use utf-8 in MySQL and AL32UTF8 in Oracle. So, I suppose that's not the "wrong encoding" case. As I said in Confluence support ticket: It turned out that MySQL count letters and Oracle count bytes by default. And we use Russian language along with English. That's why our cyrillic 255 characters value in MySQL won't fit in Oracle 255 byte field. I believe that Oracle tables should be created with definition of character limitations instead of default. I. e. CREATE TABLE ... ( "TITLE" VARCHAR2(255CHAR) instead of CREATE TABLE ... ( "TITLE" VARCHAR2(255) or CREATE TABLE ... ( "TITLE" VARCHAR2(255BYTE) Then string length limitations will be consistent between MySQL and Oracle DBs.

              Unassigned Unassigned
              mrizki MuhammadA
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: