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.
  • MYSQL blob field issue
    2011/06/07 18:48

    cachavez Hello all.<br/><br/>I'm getting the following issue when I try to import the site:<br/><br/>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'<br/>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]<br/> at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:1933)<br/> at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1279)<br/> at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1489)<br/> at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:384)<br/> at org.quartz.core.JobRunShell.run(JobRunShell.java:268)<br/> at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)<br/>* Nested Exception (Underlying Cause) ---------------<br/>com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1<br/> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)<br/> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)<br/> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)<br/> at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)<br/> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)<br/> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)<br/> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br/> at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateJobData(StdJDBCDelegate.java:815)<br/> at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:1927)<br/> at org.quartz.impl.jdbcjobstore.JobStoreTX.triggeredJobComplete(JobStoreTX.java:1279)<br/> at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1489)<br/> at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:384)<br/> at org.quartz.core.JobRunShell.run(JobRunShell.java:268)<br/> at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)<br/><br/><br/>The field is in the table: JAHIA_QRTZ_JOB_DETAILS<br/>The field is defined as: `JOB_DATA` mediumblob,<br/><br/>The following is the char set configuration:<br/><br/>mysql/1<br/><br/>--<br/>Cheers.<br/>Carlos Ch?�vez.

  • Number of messages  32
    Registration date Jun 7, 2011
    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.
  • Re: MYSQL blob field issue
    2011/06/07 18:48

    cachavez Hi Sergiy, thanks.<br/><br/>I tried the import with mysql-server-4.1.22-2 and mysql-server-5.1.55-1.<br/>The jahia version is: jahia5.0.6_r25558, I also tried with jahia5.0.5_r25219.<br/>My database is in UTF-8.<br/><br/>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:<br/><br/>This database doesn't seem to support extended charsets.<br/><br/>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.<br/><br/>--<br/>Cheers.<br/>Carlos Ch?�vez.

  • Number of messages  32
    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

    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.
  • Re: MYSQL blob field issue
    2011/06/07 18:48

    cachavez Hi Sergiy<br/><br/>I also saw it a lot of this warning:<br/><br/>2011-03-11 12:33:17,174: WARN [org.jahia.services.importexport.ImportHandler] - Definitions not found : flashContainerListList / ContentPage_183 (Generic)<br/>2011-03-11 12:33:17,175: WARN [org.jahia.services.importexport.ImportHandler] - Not imported : flashContainerListList (55441d95-42ed-4363-9bc6-41acc4d0755b)<br/><br/>do you know possible issues that cause this warning ?<br/><br/>--<br/>Cheers.<br/>Carlos Ch?�vez.

  • Number of messages  32
    Registration date Jun 7, 2011
    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:
  • Re: MYSQL blob field issue
    2011/06/07 18:48

    lara good post <!-- s:mrgreen: --><img src="{SMILIES_PATH}/icon_mrgreen.gif" alt=":mrgreen:" title="Mr. Green" /><!-- s:mrgreen: -->

  • Number of messages  1
    Registration date Jun 7, 2011
    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