| 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) |
|---|
| 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) |
|---|
| 52 | at org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:35) |
|---|
| 53 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) |
|---|
| 54 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) |
|---|
| 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] |
|---|
