| [1353] | 1 | 21:22:07,968 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of posts
|
|---|
| 2 | com.ibatis.common.jdbc.exception.NestedSQLException:
|
|---|
| 3 | --- The error occurred in alfresco/ibatis/#resource.dialect#/activities-common-SqlMap.xml.
|
|---|
| 4 | --- The error occurred while executing query.
|
|---|
| 5 | --- Check the select sequence_id as id, activity_data as activityData, activity_type as activityType, post_user_id as userId, post_date as postDate, job_task_node as jobTaskNode, site_network as siteNetwork, app_tool as appTool, status as status from alf_activity_post where status = ? .
|
|---|
| 6 | --- Check the SQL Statement (preparation failed).
|
|---|
| 7 | --- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
|
|---|
| 8 |
|
|---|
| 9 | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
|---|
| 10 | at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
|
|---|
| 11 | at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
|
|---|
| 12 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
|
|---|
| 13 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
|
|---|
| 14 | at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
|
|---|
| 15 | at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
|
|---|
| 16 | at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.selectPosts(ActivityPostDAOImpl.java:43)
|
|---|
| 17 | at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:130)
|
|---|
| 18 | at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:50)
|
|---|
| 19 | at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
|
|---|
| 20 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
|
|---|
| 21 | Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
|
|---|
| 22 |
|
|---|
| 23 | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
|---|
| 24 | at sun.reflect.GeneratedConstructorAccessor285.newInstance(Unknown Source)
|
|---|
| 25 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
|
|---|
| 26 | at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
|
|---|
| 27 | at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
|
|---|
| 28 | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
|
|---|
| 29 | at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
|
|---|
| 30 | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)
|
|---|
| 31 | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
|
|---|
| 32 | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
|
|---|
| 33 | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
|
|---|
| 34 | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
|---|
| 35 | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
|
|---|
| 36 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
|
|---|
| 37 | at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
|
|---|
| 38 | at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
|
|---|
| 39 | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
|
|---|
| 40 | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
|
|---|
| 41 | at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
|
|---|
| 42 | at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
|
|---|
| 43 | at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
|
|---|
| 44 | at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
|
|---|
| 45 | at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
|
|---|
| 46 | at sun.reflect.GeneratedMethodAccessor552.invoke(Unknown Source)
|
|---|
| [1350] | 47 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
|---|
| 48 | at java.lang.reflect.Method.invoke(Method.java:597)
|
|---|
| 49 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
|
|---|
| 50 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
|
|---|
| 51 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
|
|---|
| [1353] | 52 | at org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:35)
|
|---|
| [1350] | 53 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
|
|---|
| 54 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
|
|---|
| [1353] | 55 | at $Proxy73.getConnection(Unknown Source)
|
|---|
| 56 | at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
|
|---|
| 57 | at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:213)
|
|---|
| 58 | at $Proxy209.prepareStatement(Unknown Source)
|
|---|
| 59 | at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:541)
|
|---|
| 60 | at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:219)
|
|---|
| 61 | at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
|
|---|
| 62 | at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
|
|---|
| 63 | ... 10 more
|
|---|
| 64 | Caused by: java.net.ConnectException: Connection refused
|
|---|
| 65 | at java.net.PlainSocketImpl.socketConnect(Native Method)
|
|---|
| 66 | at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
|
|---|
| 67 | at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
|
|---|
| 68 | at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
|
|---|
| 69 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
|
|---|
| 70 | at java.net.Socket.connect(Socket.java:529)
|
|---|
| 71 | at java.net.Socket.connect(Socket.java:478)
|
|---|
| 72 | at java.net.Socket.<init>(Socket.java:375)
|
|---|
| 73 | at java.net.Socket.<init>(Socket.java:218)
|
|---|
| 74 | at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
|
|---|
| 75 | at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
|
|---|
| 76 | ... 43 more
|
|---|
| 77 | 21:22:14,137 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default]
|
|---|
| 78 | 21:22:14,167 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default]
|
|---|
| 79 | 21:22:14,664 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'googledocs' subsystem, ID: [googledocs, default]
|
|---|
| 80 | 21:22:14,665 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'googledocs' subsystem, ID: [googledocs, default]
|
|---|
| 81 | 21:22:14,665 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'email' subsystem, ID: [email, inbound]
|
|---|
| 82 | 21:22:14,665 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'email' subsystem, ID: [email, inbound]
|
|---|
| 83 | 21:22:14,793 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'Replication' subsystem, ID: [Replication, default]
|
|---|
| 84 | 21:22:14,793 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'Replication' subsystem, ID: [Replication, default]
|
|---|
| 85 | 21:22:14,814 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'Synchronization' subsystem, ID: [Synchronization, default]
|
|---|
| 86 | 21:22:14,814 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'Synchronization' subsystem, ID: [Synchronization, default]
|
|---|
| 87 | 21:22:14,815 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'fileServers' subsystem, ID: [fileServers, default]
|
|---|
| 88 | 21:22:14,826 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'fileServers' subsystem, ID: [fileServers, default]
|
|---|
| 89 | 21:22:14,828 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'OOoDirect' subsystem, ID: [OOoDirect, default]
|
|---|
| 90 | 21:22:14,829 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'OOoDirect' subsystem, ID: [OOoDirect, default]
|
|---|
| 91 | 21:22:14,829 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'email' subsystem, ID: [email, outbound]
|
|---|
| 92 | 21:22:14,829 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'email' subsystem, ID: [email, outbound]
|
|---|
| 93 | 21:22:14,830 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'imap' subsystem, ID: [imap, default]
|
|---|
| 94 | 21:22:14,830 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'imap' subsystem, ID: [imap, default]
|
|---|
| 95 | 21:22:14,913 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'thirdparty' subsystem, ID: [thirdparty, default]
|
|---|
| 96 | 21:22:14,913 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'thirdparty' subsystem, ID: [thirdparty, default]
|
|---|
| 97 | 21:22:14,948 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
|
|---|
| 98 | 21:22:14,948 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
|
|---|
| 99 | 21:22:14,949 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]
|
|---|
| 100 | 21:22:14,949 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]
|
|---|
