Jahia in English > MYSQL blob field...

0 (0 Good)
0 (0 Bad)

MYSQL blob field issue

by  cachavez »  2011/06/07 18:48

Hello all.

I'm getting the following issue when I try to import the site:

2011-03-10 10:36:37,096: ERROR [org.quartz.core.ErrorLogger] - An error occured while marking executed job complete. job= 'ImportJob.BackgroundJob-0f7cd8a8-3e93-4269-9957-1688a2db72f0'
org.quartz.JobPersistenceException: Couldn't update job data: Data truncation: Data too long for column 'JOB_DATA' at row 1 [See nested exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:1933)
at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1279)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1489)
at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:384)
at org.quartz.core.JobRunShell.run(JobRunShell.java:268)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateJobData(StdJDBCDelegate.java:815)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:1927)
at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1279)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1489)
at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:384)
at org.quartz.core.JobRunShell.run(JobRunShell.java:268)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)


The field is in the table: JAHIA_QRTZ_JOB_DETAILS
The field is defined as: `JOB_DATA` mediumblob,

The following is the char set configuration:

mysql/1

--
Cheers.
Carlos Ch?�vez.

  (cachavez)

Number of messages  32
Registration date
0 (0 Good)
0 (0 Bad)

Re: MYSQL blob field issue

by  shyrkov »  2011/06/07 18:48

Hello Carlos,

we will investigate this issue and come back to you as soon as possible.
We will track the progress in our JIRA system: [url=http/1org/browse/QA-1321:37rkgnfo]QA-1321[/url:37rkgnfo]

Kind regards
Sergiy
  • Re: MYSQL blob field issue
    2011/06/07 18:48

    shyrkov Hello Carlos,<br/><br/>we will investigate this issue and come back to you as soon as possible.<br/>We will track the progress in our JIRA system: [url=http/1org/browse/QA-1321:37rkgnfo]QA-1321[/url:37rkgnfo]<br/><br/>Kind regards<br/>Sergiy

  • Number of messages  407
    Registration date Jun 7, 2011
    0 (0 Good)
    0 (0 Bad)

    Re: MYSQL blob field issue

    by  cachavez »  2011/06/07 18:48

    Hi Sergiy, thanks.

    I tried the import with mysql-server-4.1.22-2 and mysql-server-5.1.55-1.
    The jahia version is: jahia5.0.6_r25558, I also tried with jahia5.0.5_r25219.
    My database is in UTF-8.

    Now, It seems that the database from where the import was done, it is in latin1, I don't know how it was possible install Jahia in a database with that encoding because when I tried to install on a database in latin1 I got the following error:

    This database doesn't seem to support extended charsets.

    Trying to diagnose this issue, I change the property utf8Encoding to false, then It allow me to install jahia in a mysql database with latin1 encoding, but still getting me the BLOB issue.

    --
    Cheers.
    Carlos Ch?�vez.

      (cachavez)

    Number of messages  32
    Registration date
    0 (0 Good)
    0 (0 Bad)

    Re: MYSQL blob field issue

    by  cachavez »  2011/06/07 18:48

    Hi Sergiy

    I also saw it a lot of this warning:

    2011-03-11 12:33:17,174: WARN [org.jahia.services.importexport.ImportHandler] - Definitions not found : flashContainerListList / ContentPage_183 (Generic)
    2011-03-11 12:33:17,175: WARN [org.jahia.services.importexport.ImportHandler] - Not imported : flashContainerListList (55441d95-42ed-4363-9bc6-41acc4d0755b)

    do you know possible issues that cause this warning ?

    --
    Cheers.
    Carlos Ch?�vez.

      (cachavez)

    Number of messages  32
    Registration date
    0 (0 Good)
    0 (0 Bad)

    Re: MYSQL blob field issue

    by  shyrkov »  2011/06/07 18:48

    Hello Carlos,

    sorry, I though, you are talking about Jahia 6.5.

    You could try altering the JOB_DATA column from mediumblob to longblob.
    But I will suggest, you post a ticket in [url=http/1com/:246frqg7]Jahia Support[/url:246frqg7] to let the problem be investigated faster and in more details.

    Kind regards
    Sergiy
  • Re: MYSQL blob field issue
    2011/06/07 18:48

    shyrkov Hello Carlos,<br/><br/>sorry, I though, you are talking about Jahia 6.5.<br/><br/>You could try altering the JOB_DATA column from mediumblob to longblob.<br/>But I will suggest, you post a ticket in [url=http/1com/:246frqg7]Jahia Support[/url:246frqg7] to let the problem be investigated faster and in more details.<br/><br/>Kind regards<br/>Sergiy

  • Number of messages  407
    Registration date Jun 7, 2011
    0 (0 Good)
    0 (0 Bad)

    Re: MYSQL blob field issue

    by  lara »  2011/06/07 18:48

    good post :mrgreen:

      (lara)

    Number of messages  1
    Registration date
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page