Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-1832

4.2: Error in db_update_field_definition : ERROR: value too long for type character varying(250) -> BAILING OUT

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • xCM 4.2
    • xCM 4.2
    • None
    • 4.2 16791

    Description

      Hi Benjamin,

      I do not know if this problem still occurs on the latest 4.2 build (but I was just restestin a two weeks old Jahia 4.2 DB and when restarting my server, the first access to a given template was each time thowing an exception (+ an error on the page). The second access to the same page works fine.

      So quite strange as it seems to me my DB was ok before going to holidays. I will try to migrate my content to the latest 4.2 builds... but perhpas this problem only occurs after reboot... So I still enter a JIRA for it.

      45047 INFO [org.jahia.bin.Jahia] - Processed [/jahia/Jahia/] user=[guest] ip=[127.0.0.1] in [22281ms]
      88922 INFO [org.jahia.content.CrossReferenceManager] - Preloading Object links for ref object ContentPage_2 in cache
      89094 INFO [org.jahia.content.CrossReferenceManager] - Preloding Object Links, has loaded 1 entries in cache
      89563 ERROR [org.jahia.services.fields.JahiaFieldDefinitionsDB] - Error in db_update_field_definition : ERROR: value too long for type character varying(250) -> BAILING OUT
      89563 ERROR [org.jahia.taglibs.declarations.DeclareFieldTag] - Field boxTitlemain_1 was already in container
      org.jahia.exceptions.JahiaException: Cannot update fields definitions in the database, Error in db_update_field_definition : ERROR: value too long for type character varying(250)
      at org.jahia.services.fields.JahiaFieldDefinitionsDB.db_create_field_defprop(JahiaFieldDefinitionsDB.java:350)
      at org.jahia.services.fields.JahiaFieldDefinitionsDB.db_update_field_defprop(JahiaFieldDefinitionsDB.java:383)
      at org.jahia.services.fields.JahiaFieldBaseService.saveFieldDefinition(JahiaFieldBaseService.java:1486)
      at org.jahia.registries.JahiaFieldDefinitionsRegistry.setDefinition(JahiaFieldDefinitionsRegistry.java:160)
      at org.jahia.data.containers.JahiaContainerSet.declareField(JahiaContainerSet.java:325)
      at org.jahia.taglibs.declarations.DeclareFieldTag.doStartTag(DeclareFieldTag.java:114)
      at org.apache.jsp.box_jsp._jspService(box_jsp.java:760)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
      at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
      at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:627)
      at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:518)

      TestRail: Results

        Attachments

          1. 42.txt
            223 kB
            Stephane Croisier

          Activity

            People

              pap@commaro.com_old Benjamin Papez (Inactive)
              scroisier Stephane Croisier (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                TestRail: Runs

                  TestRail: Cases

                    Packages

                      Version Package
                      xCM 4.2