org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)

GitHub | aviriel | 3 months ago
  1. 0

    GitHub comment 2#242971339

    GitHub | 3 months ago | aviriel
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
  2. 0

    Upgrade 4.2.f > 5.0.c issue | Alfresco Forums

    alfresco.com | 1 year ago
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
  3. 0

    nutz 1.4.2 postgresql 的问题

    GitHub | 5 years ago | csg0328
    org.postgresql.util.PSQLException: ERROR: column "article_createdate" of relation "t_article" does not exist 位置:114
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error with ocr example in develop branch

    GitHub | 3 years ago | feiranwang
    org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "" Position: 184
  6. 0

    Fail to assign IDs distribution keys in GP

    GitHub | 3 years ago | zifeishan
    org.postgresql.util.PSQLException: ERROR: Cannot parallelize an UPDATE statement that updates the distribution columns

  1. silex 16 times, last 3 weeks ago
  2. silex 1 times, last 5 months ago
10 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: value too long for type character varying(1024)

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.execute
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    3. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    3 frames
  4. MyBatis
    DefaultSqlSession.update
    1. org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
    2. org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
    3. org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
    4. org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
    5. org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
    6. org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
    6 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor323.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  6. MyBatis-Spring
    SqlSessionTemplate$SqlSessionInterceptor.invoke
    1. org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
    1 frame
  7. com.sun.proxy
    $Proxy16.update
    1. com.sun.proxy.$Proxy16.update(Unknown Source)
    1 frame
  8. MyBatis-Spring
    SqlSessionTemplate.update
    1. org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:269)
    1 frame
  9. org.alfresco.repo
    PatchServiceImpl.applyOutstandingPatches
    1. org.alfresco.repo.domain.patch.ibatis.AppliedPatchDAOImpl.updateAppliedPatchEntity(AppliedPatchDAOImpl.java:57)
    2. org.alfresco.repo.domain.patch.AbstractAppliedPatchDAOImpl.updateAppliedPatch(AbstractAppliedPatchDAOImpl.java:45)
    3. org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork$2.execute(PatchServiceImpl.java:627)
    4. org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
    5. org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.save(PatchServiceImpl.java:577)
    6. org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:471)
    7. org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:325)
    8. org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:302)
    9. org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:191)
    9 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:497)
    4 frames
  11. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  12. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  13. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  14. com.sun.proxy
    $Proxy123.applyOutstandingPatches
    1. com.sun.proxy.$Proxy123.applyOutstandingPatches(Unknown Source)
    1 frame
  15. org.alfresco.repo
    PatchExecuter.onBootstrap
    1. org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:76)
    2. org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
    3. org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:1)
    4. org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
    5. org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
    5 frames
  16. org.springframework.extensions
    AbstractLifecycleBean.onApplicationEvent
    1. org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
    1 frame
  17. org.alfresco.repo
    SafeApplicationEventMulticaster.multicastEvent
    1. org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)
    2. org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)
    2 frames
  18. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
    2. org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)
    3. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
    3 frames
  19. Spring
    ContextLoaderListener.contextInitialized
    1. org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
    2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
    3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
    3 frames
  20. org.alfresco.web
    ContextLoaderListener.contextInitialized
    1. org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
    1 frame
  21. Glassfish Core
    HostConfig$DeployDescriptor.run
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
    2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)
    3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    4. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    5. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    6. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
    7. org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
    8. org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)
    8 frames
  22. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    5. java.lang.Thread.run(Thread.java:745)
    5 frames