Guest User

Untitled

a guest
Oct 26th, 2017
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.26 KB | None | 0 0
  1. [pool-1-thread-1][INFO][2017-10-25 14:23:57][CONSOLE] Keywords Update Partition 204 of 204
  2. [pool-1-thread-1][INFO][2017-10-25 14:50:39][CONSOLE] Keywords Synchronization update local database
  3. [pool-1-thread-1][WARN][2017-10-25 14:50:39][org.hibernate.orm.connections.pooling] HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  4. [pool-1-thread-1][INFO][2017-10-25 14:50:39][org.hibernate.orm.connections.pooling] HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://sem-engine-manager-prod.cuwgsnrugkby.us-west-2.rds.amazonaws.com:3306/sem_engine_prod?serverTimezone=UTC&useSSL=false]
  5. [pool-1-thread-1][INFO][2017-10-25 14:50:39][org.hibernate.orm.connections.pooling] HHH10001001: Connection properties: {user=sem_admin, password=****}
  6. [pool-1-thread-1][INFO][2017-10-25 14:50:39][org.hibernate.orm.connections.pooling] HHH10001003: Autocommit mode: false
  7. [pool-1-thread-1][INFO][2017-10-25 14:50:39][o.h.e.j.c.i.DriverManagerConnectionProviderImpl] HHH000115: Hibernate connection pool size: 20 (min=1)
  8. [pool-1-thread-1][INFO][2017-10-25 14:50:39][org.hibernate.dialect.Dialect] HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
  9. Timer Name : Start updating entities
  10. Value : 3.519 min
  11. [pool-1-thread-1][INFO][2017-10-25 14:54:12][org.hibernate.orm.connections.pooling] HHH10001008: Cleaning up connection pool [jdbc:mysql://sem-engine-manager-prod.cuwgsnrugkby.us-west-2.rds.amazonaws.com:3306/sem_engine_prod?serverTimezone=UTC&useSSL=false]
  12. [pool-1-thread-1][INFO][2017-10-25 14:54:12][CONSOLE] Keyword Found To Update : 1543023
  13. Keyword Not Found Need To Insert: 56353
  14. [pool-1-thread-1][WARN][2017-10-25 14:54:12][org.hibernate.orm.connections.pooling] HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  15. [pool-1-thread-1][INFO][2017-10-25 14:54:12][org.hibernate.orm.connections.pooling] HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://sem-engine-manager-prod.cuwgsnrugkby.us-west-2.rds.amazonaws.com:3306/sem_engine_prod?serverTimezone=UTC&useSSL=false]
  16. [pool-1-thread-1][INFO][2017-10-25 14:54:12][org.hibernate.orm.connections.pooling] HHH10001001: Connection properties: {user=sem_admin, password=****}
  17. [pool-1-thread-1][INFO][2017-10-25 14:54:12][org.hibernate.orm.connections.pooling] HHH10001003: Autocommit mode: false
  18. [pool-1-thread-1][INFO][2017-10-25 14:54:12][o.h.e.j.c.i.DriverManagerConnectionProviderImpl] HHH000115: Hibernate connection pool size: 20 (min=1)
  19. [pool-1-thread-1][INFO][2017-10-25 14:54:12][org.hibernate.dialect.Dialect] HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
  20. [pool-1-thread-1][INFO][2017-10-25 14:54:12][o.h.h.i.QueryTranslatorFactoryInitiator] HHH000397: Using ASTQueryTranslatorFactory
  21. [pool-1-thread-1][WARN][2017-10-25 14:56:16][o.h.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 0, SQLState: S1000
  22. [pool-1-thread-1][ERROR][2017-10-25 14:56:16][o.h.engine.jdbc.spi.SqlExceptionHelper] Unexpected exception encountered during query.
  23. [pool-1-thread-1][WARN][2017-10-25 14:56:16][o.h.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 0, SQLState: 08S01
  24. [pool-1-thread-1][ERROR][2017-10-25 14:56:16][o.h.engine.jdbc.spi.SqlExceptionHelper] Communications link failure
  25. The last packet successfully received from the server was 8 milliseconds ago. The last packet sent successfully to the server was 70,117 milliseconds ago.
  26. [pool-1-thread-1][ERROR][2017-10-25 14:56:16][o.s.s.s.TaskUtils$LoggingErrorHandler] Unexpected error occurred in scheduled task.
  27. javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Unable to release JDBC Connection
  28. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
  29. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
  30. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
  31. at db.repository.DbRepository.getAdTexts(DbRepository.java:420)
  32. at db.repository.DbRepository.getCampaignData(DbRepository.java:298)
  33. at sem.context.LocalDBContext.<init>(LocalDBContext.java:33)
  34. at sem.synchronize.SynchronizeTextAds.synchronize(SynchronizeTextAds.java:64)
  35. at sem.builders.ReSynchronizeWithExternalDataBuilder.synchronize(ReSynchronizeWithExternalDataBuilder.java:182)
  36. at com.ssense.sem.cron.PeriodicJobRunner.runBidManagement(PeriodicJobRunner.java:199)
  37. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  38. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  39. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40. at java.lang.reflect.Method.invoke(Method.java:498)
  41. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
  42. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  43. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
  44. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  45. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  46. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  47. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  48. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  49. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  50. at java.lang.Thread.run(Thread.java:748)
  51. Caused by: org.hibernate.exception.JDBCConnectionException: Unable to release JDBC Connection
  52. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
  53. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  54. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  55. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  56. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:208)
  57. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.afterTransaction(LogicalConnectionManagedImpl.java:171)
  58. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.afterTransaction(JdbcCoordinatorImpl.java:282)
  59. at org.hibernate.internal.SessionImpl.afterOperation(SessionImpl.java:555)
  60. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1493)
  61. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
  62. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
  63. ... 20 common frames omitted
  64. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  65. The last packet successfully received from the server was 8 milliseconds ago. The last packet sent successfully to the server was 70,117 milliseconds ago.
  66. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:590)
  67. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:57)
  68. at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
  69. at com.mysql.cj.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:3773)
  70. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.add(PooledConnections.java:68)
  71. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.closeConnection(DriverManagerConnectionProviderImpl.java:195)
  72. at org.hibernate.internal.NonContextualJdbcConnectionAccess.releaseConnection(NonContextualJdbcConnectionAccess.java:46)
  73. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:205)
  74. ... 26 common frames omitted
  75. Caused by: com.mysql.cj.core.exceptions.CJCommunicationsException: Communications link failure
  76. The last packet successfully received from the server was 8 milliseconds ago. The last packet sent successfully to the server was 70,117 milliseconds ago.
  77. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  78. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  79. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  80. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  81. at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
  82. at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)
  83. at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:133)
  84. at com.mysql.cj.core.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:149)
  85. at com.mysql.cj.mysqla.io.MysqlaProtocol.sendCommand(MysqlaProtocol.java:650)
  86. at com.mysql.cj.mysqla.io.MysqlaProtocol.sqlQueryDirect(MysqlaProtocol.java:950)
  87. at com.mysql.cj.mysqla.MysqlaSession.sqlQueryDirect(MysqlaSession.java:431)
  88. at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1974)
  89. ... 31 common frames omitted
  90. Caused by: java.lang.NullPointerException: null
  91. at com.mysql.cj.mysqla.io.MysqlaProtocol.clearInputStream(MysqlaProtocol.java:824)
  92. at com.mysql.cj.mysqla.io.MysqlaProtocol.sendCommand(MysqlaProtocol.java:612)
  93. ... 34 common frames omitted
Add Comment
Please, Sign In to add comment