org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUser#6357021]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1

atlassian.com | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Login Fails Due to java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' - Atlassian Documentation

    atlassian.com | 7 months ago
    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUser#6357021]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1
  2. 0

    java.sql.SQLException: You can't specify target table 'user_details' for update in FROM clause

    Stack Overflow | 2 years ago | Sejal Rudani
    org.hibernate.exception.GenericJDBCException: could not execute update query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  3. 0

    Incorrect string value as I try to store a file as longblob into a mysql database

    Stack Overflow | 2 years ago | user1883212
    java.sql.SQLException: Incorrect string value: '\xA2\x04\x02(\xA0\x00...' for column 'value' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    failover with mysql and spring-data-jpa

    Stack Overflow | 2 years ago | JayabalanAaron
    java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
  6. 0

    Why this org.hibernate.exception.GenericJDBCException: could not update occurs only on the remote (virtual) server

    Stack Overflow | 5 years ago | Dark Star1
    javax.servlet.ServletException: java.lang.Exception: org.hibernate.exception.GenericJDBCException: could not update: [fr.model.employee.Employee#510]
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. java.sql.SQLException

    Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    10 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeUpdate
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    1 frame
  4. net.sf.hibernate
    CriteriaImpl.uniqueResult
    1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
    2. net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:661)
    3. net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:621)
    4. net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
    5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2464)
    6. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2450)
    7. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2408)
    8. net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1836)
    9. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3667)
    10. net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
    11. net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
    11 frames
  5. com.atlassian.crowd
    HibernateUserDao$3.doInHibernate
    1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao$3.doInHibernate(HibernateUserDao.java:492)
    1 frame
  6. Hibernate
    HibernateTemplate.execute
    1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
    2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
    2 frames
  7. com.atlassian.crowd
    HibernateUserDao.findByExternalId
    1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUserByExternalId(HibernateUserDao.java:487)
    2. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByExternalId(HibernateUserDao.java:459)
    3. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByExternalId(HibernateUserDao.java:435)
    3 frames
  8. com.atlassian.confluence
    CachedCrowdUserDao.findByExternalId
    1. com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId(CachedCrowdUserDao.java:164)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  11. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  13. com.sun.proxy
    $Proxy35.findByExternalId
    1. com.sun.proxy.$Proxy35.findByExternalId(Unknown Source)
    1 frame
  14. com.atlassian.crowd
    DbCachingRemoteChangeOperations.updateUsers
    1. com.atlassian.crowd.directory.AbstractInternalDirectory.findUserByExternalId(AbstractInternalDirectory.java:156)
    2. com.atlassian.crowd.directory.DbCachingRemoteChangeOperations.updateUsers(DbCachingRemoteChangeOperations.java:221)
    2 frames
  15. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  16. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  17. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  18. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  19. com.atlassian.crowd
    DirectoryPollerJobBean.executeInternal
    1. com.atlassian.crowd.directory.$Proxy1569.updateUsers(Unknown Source)
    2. com.atlassian.crowd.directory.DirectoryCacheImplUsingChangeOperations.addOrUpdateCachedUsers(DirectoryCacheImplUsingChangeOperations.java:59)
    3. com.atlassian.crowd.directory.ldap.cache.RemoteDirectoryCacheRefresher.synchroniseAllUsers(RemoteDirectoryCacheRefresher.java:68)
    4. com.atlassian.crowd.directory.ldap.cache.AbstractCacheRefresher.synchroniseAll(AbstractCacheRefresher.java:78)
    5. com.atlassian.crowd.directory.DbCachingRemoteDirectory.synchroniseCache(DbCachingRemoteDirectory.java:998)
    6. com.atlassian.crowd.manager.directory.DirectorySynchroniserImpl.synchronise(DirectorySynchroniserImpl.java:75)
    7. com.atlassian.crowd.directory.DbCachingDirectoryPoller.pollChanges(DbCachingDirectoryPoller.java:50)
    8. com.atlassian.crowd.manager.directory.monitor.poller.DirectoryPollerJobBean.executeInternal(DirectoryPollerJobBean.java:29)
    8 frames
  20. Spring Context Support
    QuartzJobBean.execute
    1. org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    1 frame
  21. quartz
    JobRunShell.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    1 frame
  22. com.atlassian.confluence
    ConfluenceQuartzThreadPool$1.run
    1. com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:20)
    1 frame
  23. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
    1 frame