Advertisement
Guest User

Symmetric Log

a guest
Jul 8th, 2014
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.97 KB | None | 0 0
  1. 2014-07-07 10:54:18,987 INFO [cassa-2] [MySqlSymmetricDialect] [symmetric-startup] The DbDialect being used is org.jumpmind.symmetric.db.mysql.MySqlSymmetricDialect
  2. 2014-07-07 10:54:19,080 INFO [cassa-2] [ExtensionPointManager] [symmetric-startup] Found 7 extension points that will be registered
  3. 2014-07-07 10:54:19,080 INFO [cassa-2] [AbstractSymmetricEngine] [symmetric-startup] Initializing SymmetricDS database
  4. 2014-07-07 10:54:19,080 INFO [cassa-2] [MySqlSymmetricDialect] [symmetric-startup] Checking if SymmetricDS tables need created or altered
  5. 2014-07-07 10:54:25,897 INFO [cassa-2] [AbstractSymmetricEngine] [symmetric-startup] Done initializing SymmetricDS database
  6. 2014-07-07 10:54:26,163 INFO [cassa-2] [AbstractSymmetricEngine] [symmetric-startup] Starting registered node [group=casse, id=2, externalId=2]
  7. 2014-07-07 10:54:26,163 INFO [cassa-2] [TriggerRouterService] [symmetric-startup] Synchronizing triggers
  8. 2014-07-07 10:54:33,276 INFO [cassa-2] [TriggerRouterService] [symmetric-startup] Done synchronizing triggers
  9. 2014-07-07 10:54:33,276 INFO [cassa-2] [RouterJob] [symmetric-startup] Starting job.routing on periodic schedule: every 5000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  10. 2014-07-07 10:54:33,276 INFO [cassa-2] [PushJob] [symmetric-startup] Starting job.push on periodic schedule: every 10000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  11. 2014-07-07 10:54:33,276 INFO [cassa-2] [PullJob] [symmetric-startup] Starting job.pull on periodic schedule: every 10000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  12. 2014-07-07 10:54:33,276 INFO [cassa-2] [OutgoingPurgeJob] [symmetric-startup] Starting job.purge.outgoing with cron expression: 0 0 0 * * *
  13. 2014-07-07 10:54:33,276 INFO [cassa-2] [IncomingPurgeJob] [symmetric-startup] Starting job.purge.incoming with cron expression: 0 0 0 * * *
  14. 2014-07-07 10:54:33,276 INFO [cassa-2] [DataGapPurgeJob] [symmetric-startup] Starting job.purge.datagaps with cron expression: 0 0 0 * * *
  15. 2014-07-07 10:54:33,276 INFO [cassa-2] [StatisticFlushJob] [symmetric-startup] Starting job.stat.flush with cron expression: 0 0/5 * * * *
  16. 2014-07-07 10:54:33,276 INFO [cassa-2] [SyncTriggersJob] [symmetric-startup] Starting job.synctriggers with cron expression: 0 0 0 * * *
  17. 2014-07-07 10:54:33,276 INFO [cassa-2] [HeartbeatJob] [symmetric-startup] Starting job.heartbeat on periodic schedule: every 900000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  18. 2014-07-07 10:54:33,276 INFO [cassa-2] [WatchdogJob] [symmetric-startup] Starting job.watchdog on periodic schedule: every 3600000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  19. 2014-07-07 10:54:33,276 INFO [cassa-2] [StageManagementJob] [symmetric-startup] Starting job.stage.management on periodic schedule: every 15000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  20. 2014-07-07 10:54:33,276 INFO [cassa-2] [JobManager] [symmetric-startup] Job job.refresh.cache not configured for auto start
  21. 2014-07-07 10:54:33,276 INFO [cassa-2] [FileSyncTrackerJob] [symmetric-startup] Starting job.file.sync.tracker with cron expression: 0 0/5 * * * *
  22. 2014-07-07 10:54:33,276 INFO [cassa-2] [FileSyncPullJob] [symmetric-startup] Starting job.file.sync.pull on periodic schedule: every 60000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  23. 2014-07-07 10:54:33,276 INFO [cassa-2] [FileSyncPushJob] [symmetric-startup] Starting job.file.sync.push on periodic schedule: every 60000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  24. 2014-07-07 10:54:33,276 INFO [cassa-2] [InitialLoadExtractorJob] [symmetric-startup] Starting job.initial.load.extract on periodic schedule: every 10000ms with the first run at Mon Jul 07 10:54:41 CEST 2014
  25. 2014-07-07 10:54:33,276 INFO [cassa-2] [AbstractSymmetricEngine] [symmetric-startup] Started SymmetricDS
  26. 2014-07-07 10:54:33,276 INFO [cassa-2] [AbstractSymmetricEngine] [symmetric-startup] SymmetricDS: type=server, name=cassa-2, version=3.5.19, groupId=casse, externalId=2, databaseName=MySQL, databaseVersion=5.6, driverName=MySQL-AB JDBC Driver, driverVersion=mysql-connector-java-5.1.17 ( Revision: ${bzr.revision-id} )
  27. 2014-07-07 10:54:41,419 INFO [cassa-2] [NodeService] [cassa-2-job-13] Failed to load the node identity because: select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type from sym_node c inner join sym_node_identity i on c.node_id = i.node_id . Returning casse:2:2
  28. 2014-07-07 10:54:41,419 INFO [cassa-2] [ClusterService] [cassa-2-job-13] This node picked a server id of server-PC
  29. 2014-07-07 10:54:41,419 INFO [cassa-2] [NodeService] [cassa-2-job-5] Failed to load the node identity because: select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type from sym_node c inner join sym_node_identity i on c.node_id = i.node_id . Returning casse:2:2
  30. 2014-07-07 10:54:41,419 ERROR [cassa-2] [InitialLoadExtractorJob] [cassa-2-job-9] select distinct(node_id) from sym_extract_request where status=?
  31. org.jumpmind.db.sql.SqlException: select distinct(node_id) from sym_extract_request where status=?
  32. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
  33. at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:104)
  34. at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:123)
  35. at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:187)
  36. at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:182)
  37. at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:123)
  38. at org.jumpmind.symmetric.service.impl.DataExtractorService.getExtractRequestNodes(DataExtractorService.java:952)
  39. at org.jumpmind.symmetric.service.impl.DataExtractorService.queueWork(DataExtractorService.java:926)
  40. at org.jumpmind.symmetric.job.InitialLoadExtractorJob.doJob(InitialLoadExtractorJob.java:20)
  41. at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180)
  42. at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224)
  43. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
  44. at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  45. at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
  46. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  47. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  48. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  49. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  50. at java.lang.Thread.run(Unknown Source)
  51. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections"
  52. at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source)
  53. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  54. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  55. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  56. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  57. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
  58. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
  59. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
  60. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1120)
  61. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
  62. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
  63. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
  64. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
  65. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
  66. at sun.reflect.GeneratedConstructorAccessor28.newInstance(Unknown Source)
  67. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  68. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  69. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  70. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
  71. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
  72. at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
  73. at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
  74. at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
  75. at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
  76. at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  77. at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:61)
  78. ... 17 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement