Database Publishing Issue

Joel Stevens's Avatar

Joel Stevens

12 Jul, 2010 06:15 PM

Hi,

I received the following error notice while publishing out a page to MySQL. I was able to replicate the problem with a page containing around 35,000 characters. From what I've read the TEXT field in MySQL should be able to hold around double that. I was curious to see if anyone else had encountered this problem.

Thanks,

        Joel

Publish of Publish Set 'web site daily publish' completed in 0 days, 1 hours, 21 minutes, 45 seconds, 516 milliseconds

There were destination failures during the publish. Jobs publishing to the same destination have been skipped for this publish.

* [mysql-database-production] : com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'content' at row 1 at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:758) at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2128) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925) at com.hannonhill.cascade.model.publish.database.JdbcDatabasePublishTransmitter.insertEntity(JdbcDatabasePublishTransmitter.java:568) at com.hannonhill.cascade.model.publish.database.JdbcDatabasePublishTransmitter.publish(JdbcDatabasePublishTransmitter.java:289) at com.hannonhill.cascade.model.publish.database.JdbcDatabasePublishTransmitter.transmit(JdbcDatabasePublishTransmitter.java:209) at com.hannonhill.cascade.model.publish.database.JdbcDatabasePublishTransmitter.transmit(JdbcDatabasePublishTransmitter.java:87) at com.hannonhill.cascade.model.publish.callback.StatusCallbackImpl.completed(StatusCallbackImpl.java:81) at com.hannonhill.publish.Publisher$AggregateStatusCallback.completed(Publisher.java:1225) at com.hannonhill.publish.Publisher.shutdown(Publisher.java:438) at com.hannonhill.publish.Publisher.idle(Publisher.java:423) at com.hannonhill.publish.Publisher.publish(Publisher.java:207) at com.hannonhill.cascade.model.service.PublishServiceImpl.poll(PublishServiceImpl.java:441) at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.TransactionalExceptionEncoderAspect.process(TransactionalExceptionEncoderAspect.java:86) at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.TransactionTimer.doSomething(TransactionTimer.java:46) at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.TransactionalExceptionDecoderAspect.process(TransactionalExceptionDecoderAspect.java:42) at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.RetryTransactionAspect.doTransaction(RetryTransactionAspect.java:59) at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.TransactionExceptionAspect.doTransaction(TransactionExceptionAspect.java:50) at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.hannonhill.cascade.aspect.ServiceAspectLogger.logServiceMethodCall(ServiceAspectLogger.java:39) at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy126.poll(Unknown Source) at com.hannonhill.cascade.model.service.PublishServiceImpl$RequestPoll.execute(PublishServiceImpl.java:556) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at com.hannonhill.cascade.util.thread.CacheSmartDelegateRunnable.run(CacheSmartDelegateRunnable.java:42) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
  1. 1 Posted by Joel Stevens on 14 Jul, 2010 02:14 PM

    Joel Stevens's Avatar

    Hey,

    We were able to track it down to a problem with Word content being pasted directly into the WYSIWYG and conflicting with MySQL.

    Thanks,

            Joel
    
  2. Support Staff 2 Posted by Tim on 14 Jul, 2010 02:21 PM

    Tim's Avatar

    Thanks for the update Joel. I'd be interested to see if the same content causes any issues in Cascade Server 6.7 since TinyMCE has been upgraded and tends to handle pasting from Word much better than it did previously.

  3. Tim closed this discussion on 14 Jul, 2010 02:21 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac