July 20, 2018 at 9:53 am
Please be aware that I am currently researching this issue as well, just looking to see if others have run into this problem as well. Any ideas or suggestions are welcome. The SQL error we found in the SQL Error log is 26073.
SQL error
Date 7/20/2018 1:27:04 AM
Log SQL Server (Current - 7/19/2018 9:38:00 PM)
Source Server
Message
TCP connection closed but a child process of SQL Server maybe holding a duplicate of the connection's socket. Consider enabling theTcpAbortiveClose SQL Server registry setting and restarting SQL Server. If theproblem persists, contact Technical Support.
Indexer error…
2018-07-20 01:27:06,009 [elasticsearch[JonathanRichards][generic][T#39]] INFO org.elasticsearch.client.transport -[Jonathan Richards] failed to get node info for {#transport#-1}{127.0.0.1}{127.0.0.1:9300},disconnecting...
org.elasticsearch.transport.ReceiveTimeoutTransportException:[][127.0.0.1:9300][cluster:monitor/nodes/liveness] request_id [4295] timed outafter [5367ms]
at org.elasticsearch.transport.TransportService$TimeoutHandler.run(TransportService.java:679)~[elasticsearch-2.3.4.jar:2.3.4]
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
2018-07-20 01:27:19,936 [pool-2-thread-3] ERRORcom.issinc.cidne.indexer.document.DocumentProcessor - Could not index document
org.elasticsearch.client.transport.NoNodeAvailableException:None of the configured nodes were available: [{PhilipFetter}{oRdyPgqzQcCMAoeRstoCyQ}{127.0.0.1}{127.0.0.1:9300}]
atorg.elasticsearch.client.transport.TransportClientNodesService$RetryListener.onFailure(TransportClientNodesService.java:244)~[elasticsearch-2.3.4.jar:2.3.4]
at org.elasticsearch.action.ActionListenerResponseHandler.handleException(ActionListenerResponseHandler.java:46)~[elasticsearch-2.3.4.jar:2.3.4]
atorg.elasticsearch.transport.TransportService$Adapter$3.run(TransportService.java:622)~[elasticsearch-2.3.4.jar:2.3.4]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
org.elasticsearch.transport.NodeDisconnectedException:[Philip Fetter][127.0.0.1:9300][indices:data/write/bulk] disconnected
2018-07-20 01:27:23,575 [pool-2-thread-1] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XMLbean definitions from class path resource[org/springframework/jdbc/support/sql-error-codes.xml]
2018-07-20 01:27:30,519 [pool-2-thread-1] INFO org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded:[DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2018-07-20 01:27:30,922 [pool-2-thread-1] ERRORcom.issinc.cidne.indexer.report.JdbcReportDao - Error processing batch.
org.springframework.dao.DataAccessResourceFailureException:PreparedStatementCallback; SQL [SELECT * FROM TARGETENGAGEMENTPUBLISHEDREPORTSTATUSINFOWHERE isDeprecated != 1 AND reportkey = '09C46E4D-A76F-7F06-933BBDA302C404C9'];I/O Error: Read timed out; nested exception is java.sql.SQLException: I/OError: Read timed out
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) ~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:682)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:155)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processSubtable(JdbcReportDao.java:374)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao.access$800(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao$7.processRow(JdbcReportDao.java:308)~[indexer-2.3.11-SNAPSHOT.jar:na]
atorg.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1484)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processBatch(JdbcReportDao.java:244)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao.access$400(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao$5.run(JdbcReportDao.java:185)~[indexer-2.3.11-SNAPSHOT.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_172]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
Caused by: java.sql.SQLException: I/O Error: Read timed out
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1059)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:493)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)~[jtds-1.3.0.jar:1.3.0]
atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
atorg.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
... 20 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_172]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)~[na:1.8.0_172]
at java.net.SocketInputStream.read(SocketInputStream.java:171) ~[na:1.8.0_172]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_172]
at java.io.DataInputStream.readFully(DataInputStream.java:195) ~[na:1.8.0_172]
at java.io.DataInputStream.readFully(DataInputStream.java:169) ~[na:1.8.0_172]
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:881)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:762)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:99)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3999)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1052) ~[jtds-1.3.0.jar:1.3.0]
... 26 common frames omitted
2018-07-20 01:27:30,922 [pool-2-thread-1] ERRORcom.issinc.cidne.indexer.report.JdbcReportDao - Error processing batch.
org.springframework.dao.DataAccessResourceFailureException:StatementCallback; SQL [SELECT * FROM TargetEngagementPublishedReport rWHERE ReportKey IN('B3BDF500-CED2-0C21-997D9A5FEF602311','B3EED21F-B126-CF0F-8BC574293EC99529','B413900D-FEEC-F0AA-70196601812C9F38','B41DE21F-915A-036E-888FE354E73462BC','B47EECED-A971-A6C3-0A8E5F9CFBFBE77A','B4C38FC3-FFE3-035A-E12D26BD99861EBF','B4D89E1E-A651-8482-E9A1D51A32ABEBDF','B505BF99-A979-FA26-E286458EAB37A08E','B50C6859-AE9A-8712-F0F938B82F3DE955','B513278B-E249-39EF-1451CBAB1D74C690','B54C1375-D236-9ABD-818EAF8093E953A4','B5AC2353-CA77-8A15-01ED108035421F51','B625E9A0-C8A8-F6AF-7E5EA7965E81C9A2','B64A6B08-E7E9-A6FF-08B3BA402B54FF3F','B6605FE0-E9AC-CA9B-DAEABD7E925079DE','B666F6E1-C850-EEFD-3F5B2C81F0DE3A5A','B685A205-CAB1-1C9C-B2B3A9C246E842B6','B6A63315-0252-FB11-44FD32A45E7E3CD4','B6E4DFE9-BA5E-1E3F-B3CE032BA246FAA2','B6F87BE1-ECC7-8CF8-838A9D70FF6B3F1D','B7500506-0821-6827-457BCE6C36D7DD6D','B7534785-0797-F4AD-E509007C77523E4E','B785D41B-D87D-93F9-E30948C632C64D4A','B78A94C9-9637-5354-DC110F225D7CAA02','B7B5F498-C1E2-B8D9-64F68DE4FED8320D','B86AD554-ACC0-8A66-52C9B222B4253E71','B875983E-BBB0-04C9-308CA803A1494EFD','B87AD53A-A79B-CD63-5444A764C30C01CA','B87B3EC1-A349-2805-CFA1CAADC96BB149','B8A46A89-B97D-7F88-0851EA991448C08C','B8AA7ED2-CFA3-0A39-899937A6D66FF56F','B8BF29DA-C601-C3C2-67C1DEC86043739C','B939AD6C-AC30-A90B-3F6E01164F098219','B9AFC1C9-B467-53CF-8D46FE15318775BD','B9C9A3D2-98B2-4A5D-9BF9-172319BBEE87','BA0EA857-EAF2-87FA-B734962CDDB631C4','BA1D800A-F330-92AA-6F0FA3A59563F9D5','BAA5909D-E95F-1041-5680EBC1A108D84B','BAB55EC3-94E0-2027-A58AD8091D63F396','BAB57C0B-9C3A-1960-C102EE4026949F87','BACF5B3A-BC40-865F-241101E9A316D995','BAF7E0DD-ACCE-15EB-61E5395D36D1365A','BAFBED88-D1A2-FF4C-F37F44EBA3C5C6A0','BB06FD4F-D4A7-6ACA-FA57F95A21E06BF5','BB5BFB0A-E12B-7994-202AE6A787B795AF','BBFD2610-F714-45A6-9BDB-A9D93C7B4045','BC1BC9DB-A230-7732-2D423FDD577DB9F7','BC2110FB-AAC3-B293-1CCA8CE8AC992BA3','BC2A7AFD-F9A4-6773-A4BBB04E2AC441CB','BC2DAC5A-0CF5-1577-F5AEDA895C999BCD','BD4429CD-B898-821B-317E8E1D406E278A','BDA22ADA-A8A8-4C48-70DA4020BD411886','BDD56897-F60B-5B34-9E448320A78FE259','BE07FBC7-9552-C6A1-52AF8DE13FD4AF43','BE29E55B-E9F3-7AC2-32DAC9E9373B3AB9','BE5ADE13-FF5E-3CB1-8581D8C729BE41B4','BE88B030-BE3D-47F4-8D2A-5335A7EDB6A3','BF7C0D99-D0AE-4918-2119764D02118974','BF7E6A97-D2DB-D1BD-5B7579FF6750F625','BF9E72D9-003A-4F78-9352-B40008F8EF55','BFD164B2-9CEF-05D5-AF6AC5884FFDE74A','C02DF0CE-0FF8-8657-1146C6ACDA881F6F','C0497BBE-FB43-633E-8392012EA7510D4D','C05EA285-CED0-9EFC-06DD4E59834D09A1','C06BAEFC-FC18-7223-5C7DD3FD13D31553','C07E9CF4-BDF1-AD44-88C2B9F00E1BF3B8','C09926D2-0A3F-4270-3F19395A0AED28AC','C0E7A9A0-E42B-6200-B3DB2891FAD81388','C124F56B-9989-BC8E-FD6CCE4BEDF01773','C1C7CC94-A904-A3E3-2BD967807F9C2F5E','C1E3A4D4-B094-635D-D11C667E3E1FAD2B','C201A0C1-BD48-E0B9-D61299A160AF13E7','C367C2D8-E216-021D-10A3F9221F2C1057','C399424F-AFA0-2432-D1D62D36176BF3A8','C40BEF9E-04DD-87D0-39EB7F4500615DB1','C40EBE4A-D7F5-92CE-F6D64DFD91B0EA70','C421C89B-C085-FC86-6C8DA17CB76D6F6B','C4335808-BB5E-DADB-21A2D0380F58C515','C4C7BF41-9512-F302-A5BD2CC4BC137CCC','C51D90F6-0DFB-6576-7D7B5F8F1FA0A15D','C5782EBD-FD94-47FE-BC7F-0E00F5AF68FB','C57DF460-EE44-7571-B1624513F7898378','C5A20CDA-A6F5-9B86-E3362D4EE76BC7A6','C5A7D733-60C6-4A29-B818-270CFF2A438D','C5F659DC-D0F0-6290-4837F5F3C0A63F1B','C5FD789F-BF48-DA7B-39C79221FF0129CF','C6204D9E-E6CD-21C5-9F16DE14DDC7FE1F','C63D8EC6-F3A7-FACD-B870EA7C7B855F13','C6722309-F006-CC12-3165754579DE15DA','C69C296A-F64D-EAB2-59878B32A2EE7879','C6D096CF-B141-4DCF-B59B-29FDD4CC6223','C716AB00-DF26-DEBE-DA5178FA4206D100','C7224B2C-F919-5D8C-950DFE09BE0DA67C','C75CE149-E583-CD35-C7EFB17A6C787BD0','C7621506-0853-7A1F-2ED75761C6BD7C41','C7836CD4-BD6E-92FB-9C143E400C67D43D','C7978661-F503-CA92-14C7A89EB788DF17','C7DC4325-F069-7284-9C079793E142E0D5','C838626D-E174-E08F-4640CB79A29CA91F','C843632A-A01E-5AFF-45B2267F239F8122','C87444A9-FF56-8E06-CA4F5E8B699AAFF5','C8935409-0FE1-5858-DE67BB568665B041','C8AD3D55-FDC5-6722-A27C1C8709FC683E','C8F59F89-B91C-4710-A42A-7D590A4154CF','C99DA2F2-F3A6-2141-3B803BF21E2640E1','C9F22F90-D76E-2ED6-E0CE3B36B040320C','CA0039B0-E21F-DE3B-7537593F0C487DCD','CA0BA8E6-7F33-45B8-A650-189954D46B1C','CA7D5349-0E49-2537-833F3C96EA786502','CB104216-EAE1-AB19-6CA4C21B68745ECF','CB15DFAA-DA85-8617-095901F1535C3DE5','CB9D5BAC-04A4-6A76-F728E7F36B78294C','CBF7452C-BCD2-46DD-1414CAC3B20EB674','CC41FABE-B526-4FA1-0D4562AE7EAC8B34','CC4EF901-00C6-AE21-9B0642FCF511BD8D','CC899FB3-D82E-EED1-36DE45A52B326EA3','CCD35D57-9CB8-589D-6C3FEC65D1EC7520','CCEFD0D4-B84D-B6F3-699294BB61A60DFF','CD33DD32-B502-7739-7283B10C72C01ACC','CD7951E4-AA63-E16B-E73E82B2D323D7FD','CD915AC1-E818-1B01-4664AB693E865EEF','CDB520E9-DE85-39FD-40B52C286473646F','CDBF24A2-AD3D-CD28-D11C1420CAC6B9E6','CE1A6B52-92DA-A847-2A9597D62D20E525','CE27BA8B-F40E-FB9D-8FD17ABB5CD0382D','CEE3BC1D-DBBE-617D-6DB2A518BDE2A17F','CF556723-DE05-BF89-6BE23BCB7093AABC','D028A037-911C-ED3C-2AB9AA4E723D35C6','D07A9EC9-055D-87EF-5FF5E1D048F9E4A3','D0B14724-8BB2-489C-9144-57DDFC9D340E','D11C58DA-FC4F-484B-9051-16B22A3F0F0D','D154D709-E82E-491C-85C0-1AACAEBBD54D','D163F71E-DA95-964B-CAA02BB0A87FE255','D1B1E8B2-AC58-25B1-19DDDC2BA05C0425','D1D077FC-B362-3A28-1B64CBC994EFEE82','D243106B-B71D-4A53-3B5D04DE0D2C9C1C','D2482530-A447-4951-A0C5-A570E8DAFDEE','D2A8E15F-F3DC-6BF0-7B24D44146592914','D2BF1F20-C7E6-81A4-2527FCFE317B7A2C','D2C1CF1D-EE9A-9327-6C4DC8DF387BFF97','D2D33784-9DBF-D988-11F03466670EB83F','D2DBC827-EA78-D90A-BE2E454147AD2FB8','D2E340DB-9808-9886-CEFD6417255D7A6E','D316860C-C640-518A-06387C90BAC67CE8','D35BD981-BB4D-6BE6-639E6156CBD74E3A','D3812970-CC21-0B38-24FE7DF50CD8133F','D3F9C97C-F873-DA2C-53E533E5B1B0E9B2','D40C645B-0294-EA5A-41D8A4DEADD07406','D41BAD5B-A1AE-3190-63A2447103D0FE19','D433A179-B6A6-6356-0E9DB28E09CDCF31','D44B6609-B0AC-8379-A80D4CD9A525F409','D462FF98-BA23-698D-092F55577737105C','D48074C9-E7D3-9D50-2D2C9748E0EBDE80','D4B3FE7D-93B4-3730-55AE1F81E5EF1639','D4C23DAC-AE1B-9C3D-74776399B7801679','D4F0C937-BB17-BD37-50113A0A5C3F8E7D','D51590EB-CB05-C38E-D2423C2A45C402B3','D532BE23-BA53-7406-DF47440C0EF05A6E','D53A1CD9-C754-4B6C-85DBD66F2679EC6E','D587052E-ADEB-83DE-6D48BD9DD5647F54','D59D29B7-E3B1-502F-161A1D81848BE5CD','D5BBED01-3ABE-4FB1-996D-E5D33B140B79','D5D3CD07-9E0E-10E0-E896EE1EFEE0E152','D6B3EA36-C561-A0BF-FC7D7F5F4F5BD4ED','D7B43F68-3213-4788-8789-AFA0200A3BF2','D8567C23-DA19-51A5-04A2338816B07090','D88C788A-A7AD-8B6F-BD3F24A1C4CBFB1F','D9B9F16E-98E0-197B-10D7F1BB1DD42DD0','DA812D4E-97BE-08CA-F9CE3D29A54C818E','DAE4D650-B00B-C201-B3E5A075497F70D0','DB70C443-0E18-DFD3-6EB901B8C00AAD50','DC11CED0-F6C9-DBFF-278B923A652F421C','DC66B3F7-610A-450D-9F56-C314BE50B802','DCB64CDC-3F25-474A-81DC-E7A42D60DAE2','DCE8FC2B-CB8A-7C62-E30C6D73F74E0387','DD48889C-B1D2-4174-074A1BD5C86D9A0A','DD736302-A039-A99D-0DB83F2A5B598A0E','DDACDC66-FD35-6EBB-AA83D845DC2421DE','DDC0E2A5-945A-D33C-AA970918DFF6B36A','DE0C2175-DC0B-4304-49C56CE0B3E35EDD','DE3264BB-0560-92CA-A0905E7665BD3882','DF09BAE5-0C69-4D22-B3098EDCBCBD03E4','DF6286BA-1226-4E57-A853-13B7F2D8F2D0','DF70FC0D-FE2F-FB41-1A42B261DBDA31EC','DFF4BC45-A0B3-4E56-A70E-A69612C8BDBD','E006410D-FBD1-3B8A-BE63DBE0B66A0703','E05FA26F-EF31-CC1A-5458D28DE9225C41','E09AC8F2-C0E4-852E-F79EB4A58F0DB821','E0DB8C6E-B8D9-FC08-B9E6C24E5C230C2C','E105647A-EFA2-7D81-AE833634E6A196EF','E10C91D9-BB87-D58A-2B539202045C1846','E16EF7C7-A882-2518-016BB9CD464353F7','E16F14E1-01DB-C781-6C6D5279A649D245','E17E6FCB-B1B6-B5BC-482B6D50EB4FFEB1','E19086CC-E732-A573-22949E0F74EA67F4','E1D55B12-ACC4-7177-44134889BC8B2BD5','E1DAC711-B491-F35B-ABD1D0B1866E4615','E1E4EEC0-9638-F641-B7D8E60636EA5A67','E1E58328-C28F-0D73-B357972CB5690286','E20D08B0-B0E1-46CB-6D0574FF103D0ACC','E289D074-C750-0346-F5EA2C0148220FE6','E375C38D-45C4-44A6-B4AA-BD3AACDC8142','E37D5B64-F262-B863-5F9520CF9B908E78','E41CC122-0213-F993-BA9A0026E6B32F8D','E4236600-EE33-0AD2-F2A6C4A082A3B59E','E4693610-0A8A-3F58-F34A1FC01BBDF141','E485929E-E05E-AE21-246C42F813E34360','E49DFB01-AD31-32B9-61BE30340BA1F4C5','E4BCDED4-BB8D-6559-672FD02F57717ACE','E4D0CE59-F3DA-F3E1-9ED28C747CC466D1','E4D91052-F2B3-A98C-90786CABDD50B2ED','E4F79616-A466-F060-1ACEE24E119F5534','E5058D12-0928-876D-E21919D0807AC80A','E5467E3F-04C9-0644-BDBC9027914D8E75','E551B81E-F67F-88A4-CFD1893915ED563D','E592A5EC-EC40-3199-3264675F808A087E','E5A36E8A-E566-AC2D-8BF5D98E3F9D9625','E5A99A61-1423-4BC4-AC5B-31A6A52DF171','E5C80543-FA67-B145-DB42B131B36BDE37','E5F4F677-C6A0-F49F-20CA9FB5D267F2E5','E60FEEEC-B042-DB02-5D20EFA49DF84C43','E649987A-FD6B-A9D3-0128BE38E8906633','E67794E4-9750-88D6-059631481FE41DA4','E67A9998-D601-D000-1696E7DCC28BC1AC','E68A6DAE-E8E9-85C2-DE53142242D4D854','E6FDF2E5-E48D-A4D2-830DEB78C4594413','E8185B67-E9A3-5D2E-5D97DEC38D48B817','E82D3C1D-CF3E-1477-A11713CA547415AF','E9211109-E903-490E-0A4646720279510F','E9B7B32F-4F72-4D08-856F-9951C722A3D7','EA14C59E-CEA8-AE4B-BF91D437F8515ED1','EAE4825B-9BE3-4EC6-8916-E026B3D6CBB8','EAED3445-CE7E-E38D-9710D45B234838A2','EAFB51A4-AA37-3479-477BA94B38F7E5E1','EB4A8DA1-0AAA-E34B-2221A419D1474912','EBA05E5C-A4B4-EEAF-1C59B0CCF8E5048F','EBF8D7D7-E957-6931-AA0358914B5CD34A','EC3133CE-D447-1AE5-2656C57A63087D0B','EC950BB5-B848-0536-F182B87D6603E1DB','ECBF34A9-C190-AFBC-0D1E83AE9489F705','ED0ECF0C-EFB0-F091-855369568E7BC9B6','ED152AAE-E802-5E73-33CE0A21BE6F579F','ED253391-D56D-6330-0EF317B5E839F293','ED2706E5-975B-0299-8797347DAECB2A0E','ED3C30E6-0834-00C5-293E72292C6D5893','ED6915FB-B064-87E8-0B1D87A477879AC8','EDD75669-DF26-0033-08EDC1492217386F','EDEA3FEC-DBC1-03FB-A93411FC12FB417A','EDEF8ABC-9530-71C0-3707DD37654AD2FF','EDF53F90-F31A-7CF5-37BD40BA096582D4')];I/O Error: Connection reset by peer: socket write error; nested exception isjava.sql.SQLException: I/O Error: Connection reset by peer: socket write error
atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processBatch(JdbcReportDao.java:244)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao.access$400(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao$5.run(JdbcReportDao.java:185)~[indexer-2.3.11-SNAPSHOT.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_172]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
Caused by: java.sql.SQLException: I/O Error: Connectionreset by peer: socket write error
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1059)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:493)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)~[jtds-1.3.0.jar:1.3.0]
atorg.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)~[commons-dbcp-1.4.jar:1.4]
atorg.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)~[commons-dbcp-1.4.jar:1.4]
atorg.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
... 10 common frames omitted
Caused by: java.net.SocketException: Connection reset bypeer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_172]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)~[na:1.8.0_172]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)~[na:1.8.0_172]
at java.io.DataOutputStream.write(DataOutputStream.java:107) ~[na:1.8.0_172]
at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:717)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:570)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.RequestStream.write(RequestStream.java:316)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL70(TdsCore.java:3929)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1039)~[jtds-1.3.0.jar:1.3.0]
... 16 common frames omitted
2018-07-20 01:27:30,922 [pool-2-thread-2] ERRORcom.issinc.cidne.indexer.report.JdbcReportDao - Error processing batch.
org.springframework.dao.DataAccessResourceFailureException:PreparedStatementCallback; SQL [SELECT * FROMTARGETENGAGEMENTPUBLISHEDREPORTGOCOMMENTS WHERE isDeprecated != 1 AND reportkey= '33262474-E7FE-C168-B9A2549BF6353E04']; I/O Error: Read timed out; nestedexception is java.sql.SQLException: I/O Error: Read timed out
atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:682)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:155)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processSubtable(JdbcReportDao.java:374)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao.access$800(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao$7.processRow(JdbcReportDao.java:308)~[indexer-2.3.11-SNAPSHOT.jar:na]
at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1484)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at com.issinc.cidne.indexer.report.JdbcReportDao.processBatch(JdbcReportDao.java:244)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao.access$400(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao$5.run(JdbcReportDao.java:185)~[indexer-2.3.11-SNAPSHOT.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_172]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
Caused by: java.sql.SQLException: I/O Error: Read timed out
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1059)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1185)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.JtdsConnection.prepareSQL(JtdsConnection.java:706)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1028)~[jtds-1.3.0.jar:1.3.0]
atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
... 20 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_172]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[na:1.8.0_172]
at java.net.SocketInputStream.read(SocketInputStream.java:171) ~[na:1.8.0_172]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_172]
at java.io.DataInputStream.readFully(DataInputStream.java:195) ~[na:1.8.0_172]
at java.io.DataInputStream.readFully(DataInputStream.java:169) ~[na:1.8.0_172]
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:881)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:762)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:99)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3999)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1052)~[jtds-1.3.0.jar:1.3.0]
... 27 common frames omitted
2018-07-20 01:27:30,940 [pool-2-thread-3] ERRORcom.issinc.cidne.indexer.report.JdbcReportDao - Error processing batch.
org.springframework.dao.DataAccessResourceFailureException:StatementCallback; SQL [SELECT * FROM TargetEngagementPublishedReport rWHERE ReportKey IN('705863D1-D54B-462D-C57AAC13BF4FECD2','709569A5-AB58-DFC1-80A5A70F4B7BDA2F','70F56422-AFF8-2F30-1DC5A52D110A6E8E','7106274B-A799-1C0F-CA6D0716CF4DD236','71748F15-E557-E978-E6C258A85932F74B','718278F3-B03D-EFA8-AC1466A1D566EAD9','71859BF2-FEFD-1D69-69E4735EF5931CDF','7201C4AF-97EF-7291-7726092670325EF1','723C0716-C6E9-4371-2DEB24EB3D292F10','7244912B-9DC8-7332-91D2A13FCC3BDC12','72800E04-7CA5-45BE-99E9-104A08F1FF8B','72806C46-A237-43A2-8A50C817C74BAADC','72809471-F1CE-5585-2DF92F08499A5591','72BCBE11-EA0C-DD37-CF511818C6D7CA1E','730FECAB-DF2D-7E95-278B9E33181DA88F','735840D5-01BF-60E6-5A4B76BCF3F4738B','73869B6D-0391-2133-CB900E6AB261CEC9','7457315A-98B3-1019-A6446CF7CBDDBC69','746427A8-EB61-04F8-31506BA55A04916D','74A51019-CBF0-53AF-5D1245603A97F4D8','75006FB0-0D4F-732F-FDFC65E8227B9B21','7528C9D9-F9C3-0F55-B2B733FDBC41F978','759071C4-9222-6822-5CF256D10563F724','75A22A3F-D2A6-3E91-DC4DDA85B3C183D9','75B4B138-C71A-7DEC-C464F69D4B2D0954','75B8DD1B-A9B7-3999-CAF96E36FFDEA898','75E8486A-E8A1-6B28-BD8F2957CC3E9778','76CDFF14-91A9-E392-2610F26ED39EA520','76D50643-B053-8F08-98455A48317BCDBF','7727C2FE-0D4C-CA05-E5C4F29D05FD206E','772AC081-C65C-301A-98F80A51022B82BF','774E4E14-E391-6436-D76230147EEFA1EA','77D2D7CD-D7C8-E10C-CBB5D6FC55407A4C','77D5AB65-CBA5-8082-AB6C4E0B4163FAA1','78058002-9386-70B1-A62DA532C6BEF0A1','789A0C53-E8BF-60CB-FBA5E2A6BED3C375','78DD9773-EDC7-E03D-7D1A67EF3DBF9BB5','796AA7E6-F347-494E-8641-E365C69539E5','7A16A3BF-C622-F81C-AEAF5F626F61339D','7A1E9B65-CBCC-E99A-B48878CCB6515832','7A262A16-A095-7507-9B906D0DF045CA84','7A434B72-050D-DF47-13D91AF10DC28AA4','7A477EEC-CF9D-55FD-8BD7E92AC8E56BBE','7ADA3C3F-0B68-9ED8-961B5232E0C00CF0','7B234820-9018-F68E-C008E0EB9D444F95','7BFA9348-C849-082F-F4A3B9D546EB51A7','7CBD08F3-D95D-2063-082A6648340A7C93','7CDEC580-CBF5-5F9D-7B83F082382A95CE','7D13F452-9772-B0A8-9CB4F120D0D4893D','7D2BCAF7-E116-131B-76520BDDDA1A4A39','7D68B340-B1E8-8BCD-62DFAB95225C0CBF','7D9E02D1-B32D-9FD2-449E9D0A481B8525','7DB13513-A21D-6967-D4B9ABB596D6DC11','7DC1B25C-F98E-CDC0-6EF68547E2747DFF','7DDA1803-C2FD-6CFB-71B7E8DF4E1A855F','7DEEDE6F-031C-DB56-5FF40B3A398B4001','7DFF4C1D-0DA6-CB54-391115622E0218EF','7E2145C0-0807-EFB6-41D5B53CC435E250','7E298BE1-0EA7-50F6-C40CB91BBBD5F596','7E4C4117-B863-A9B2-1BEE39CDE5791189','7E593356-ED12-7583-96BA561DD0DB39F1','7E7D823B-2878-4AB1-92A8-65F084485353','7EBC830E-927B-7AC9-2A1E3D4F55075503','7EFB2925-E39D-3138-7350701AFC897F73','7F14C5DC-9A2E-3C39-0258D0D3CEE603EE','7F26D432-9DA9-5961-38A783CAF005D545','7F2A0B67-9582-6086-E7B13BC9BAD1A902','7F738E9D-EDEA-9399-36B9AB89385C957A','7F99A7A9-0ABC-9A8A-A7B272291B5A065E','801542B2-B0BC-0CE9-6F7EA9DF11E3520F','805540C8-9970-F2EC-DE6639F322A3F78C','808DFFCB-BADB-B953-CFE2AF8812833C31','80DF399D-E628-C269-201731AF715322FA','812502EF-A22E-406F-F1B52CF45FF39555','81920965-E41B-0A6B-081DD9DF4F0EC05C','81B1CB74-C352-A667-66EB95FF6A1DC615','81F7398A-5A0D-480B-881A-778FFD5148FB','82111091-A2D5-795C-39B1ADC53EDFF225','821CD6B1-C8D1-04BA-5BB75E973EF06B0B','8249DBCD-BD22-6644-8746ECBACD3239F8','824C10E9-FF65-ADC5-8177EC07ADB29FDF','826F4D9B-BE19-63E2-E5443FAD12E12D04','8297BD8E-B4D1-AB82-4A72C187831D481F','82DF4669-97BA-5047-3FCAD90D59332386','8320691B-AF13-9BE6-12703F3252109A45','833E034D-A9ED-6734-E80E7EB8DD7F7F6B','837000D3-DB63-B5CC-E7F7D61BE7960A40','83796A08-ACC2-1F70-A91FD4ABE93324FC','8382E57A-EEDE-3A03-1FA1F3D272FF07DB','83CB2A73-C1EE-C9C4-7812BEE1E13ADA33','83D61D6F-93EA-04BC-C8779B299AA4EA03','840137C7-C6E2-28EE-E59E7C7C9C3DDDE7','841DB26D-FD76-293F-3E22E927F47671C2','8426CB18-BF2C-8FEA-4776EC96C0486A23','8481198F-0F85-128F-00E4CEF66CC7649E','84AAF88D-99F0-57B9-B0547E62B1C4B9E2','84C427AD-D079-D918-9A5A719F6EFBAA83','8500065E-9486-8FF9-6382E2237684BDC7','850530E1-E3DF-E6B3-13CD5BE66BE5BC03','8524465F-F068-FCA9-5E4FB4D949F75218','85723826-9BE3-DE8A-D81FD656FFFC5A22','857F8142-DD2B-A3D6-57C092A9C664497E','85B725C6-078D-67CF-4BBAB7D6EF3F30C4','85F5AEFE-C0A7-DF44-E93B22E00BE39256','86A88487-9D3E-E109-6D3BC6E505308AC5','87256662-FF67-1424-E6E65EC615247F18','87270CEA-0CD0-2D1E-C1D073254CB20C3E','87655EC9-AAD0-E739-EBBA0447BBC6D9B7','877D1961-DE7C-F2F2-821F51E0396A4889','889E16A1-E50F-482D-8DBD-55BE1F190F13','8905638B-FC57-F466-F7D1194AC51BB998','8983734B-4DA3-470D-AE6C-D9986BC2431B','89B83085-8C33-4ABE-BDEC-7907D68C41F3','8A7BEDFF-E634-BD62-C008432964461453','8B4D81DA-F74D-935A-C3A8CAD06088ED7D','8B4DCD30-FC4F-239E-ECCA66E378A52826','8B79CD25-E209-169F-84F06BB437427328','8C1798E8-F227-BD49-49C0E3B640839C92','8C1A7BFD-0B1B-011B-5D606624D626003D','8CB6B255-D412-9CA1-B4D872CB8EF3F9B4','8CCDFCBA-DECE-F959-472ECDCA4CEC8E49','8CD712DB-9346-1A7E-480FEDBF829389AB','8CF01080-D1BA-0879-C4D4AB2CB1F68D5F','8D3940F9-D8D2-C4C2-8E863F99617A5F12','8D796598-DC45-CC63-7452656DF2072ED0','8D8220B8-87E6-4092-A2F9-5481E64949BD','8DF436CA-A7C6-086D-220FD80581469E71','8ED19A13-0F20-60BF-2293483CBBBF6A18','8EEF5AA9-B3FC-40C2-C0D5455E2AD504E7','8F61EE34-CB3E-E461-24750669DBD14AA7','8F7A6C5F-0E14-7682-626C920615D39C25','8F821B2D-F3E7-FBDA-04FD0A6C2CD860BB','8FE2B7C2-0554-4133-8DAC8F214DF0388D','901093DE-FBC1-73B5-C0A0CA4869BAB041','90266509-9E6C-78BD-1E3930AE7D0219ED','90272F52-EB6F-245B-A488DE3FD370C245','90328F5E-A470-40DB-8372-5F9A40D77A5D','905BF793-F9AE-00E3-BDCC60FE12B1465A','90D4F791-D478-386C-6C40A56A575F345F','914BBDCF-BE03-2A0A-BB59E6C378B54129','9187E443-D136-1460-616B748D7F4147A7','919B1F7A-D143-6FA8-E03A072DBB3642FC','92314B4E-9699-1018-4A79C95A2665FB22','92A8FE1B-912A-8122-11714BCDD6EE49E6','92BAF1A3-98F6-8041-A16667EAC628A4F8','92CA2A2F-ABD0-EE3D-1AC68FE4227F555C','933978DF-FA6F-3776-A3C6878221D3E289','93674DAC-E08E-7B3E-0DBA25E590177034','93760E85-9198-50B7-FCE8692C74DFECBF','939A041F-0332-7AE7-055D923B3A13815F','943EA72F-9968-68B7-72EDE0BDC9B0EB77','94B640CA-EF7B-C6F8-A606F31631D9FD7D','9519B965-9F31-AFB7-AEE4DA6DEE6CF791','952D97F4-0023-31D8-8A2B8EAA278BFA1A','9593F42F-DFD2-E6AD-9F3E0A0779742DD1','9639E686-AB1F-99D3-2BCBB5CD8608FF51','96B52444-AFA1-1D12-520BEC260D62D3B7','96BB85C9-9C65-A511-1504E3D2577E6E03','96BD10EA-02AF-B2A3-5F53DB59CA320B1B','96CC28C2-9AD2-721E-5746360575FBAF5E','96E823D0-A044-6FE9-1AAEDE7FA34DB6FE','96FC268F-A432-43D3-9071-913DF1A4B8AD','979708E6-A09C-9AD7-E7590E32DDB5D9D8','9849DC2A-06A8-ECFC-39A0C8E875A3D176','98CAC4F8-95BA-B6A9-17923AA11B828DB7','99700A5B-CB5A-C392-C65069F04108DD2B','998BF0DD-D458-4E52-AC46-1CD43F25BAE0','9A049063-0694-7AD8-9E47D88F06ED6BA4','9A584915-BDA3-F8CC-892AFDDDF8425FA7','9A777132-0AA6-FACB-9E076DC9FDD6111B','9A7A39AE-06E7-E986-3A3000CDDCCD91DD','9AAC3598-C9F7-E8C2-A5980C7CB036ED2D','9B0B11EF-0ED2-4729-25EE49BCAF76D313','9B3BBDFE-B107-AAE5-294FECE0D9EEC636','9B49833F-FB0B-CBE6-1BBA1D92BC572BBD','9BBB7254-DB5F-1301-555C63BCED879105','9BDEBCA4-CA18-4430-8640F384EF146043','9CA48DEF-F3FA-8B13-08E97ABEB4D07863','9CD77C00-E4DB-8477-D802063304552BC7','9CF65D14-A051-22FA-EABAF4C0A1538E8A','9D1A83A3-FC7C-3161-9C5B6526C2B47DFB','9D75F34D-F203-B790-FB4734D0E0B9F3BD','9D84DFD8-EC63-9DA1-A8E1C79686F17BE9','9D9BCF17-A55A-A142-4CEEADF18A787A22','9DB47AB4-A6FD-7069-802EE75C2963765C','9DFE59C1-BDFE-613C-418DD353BCC384E1','9E01BA07-B860-6D8A-A151B490827FD40A','9E2CCE5C-ABAF-082B-F50CB7D50D6377EA','9E7A525F-9949-C1FB-434FF68C2D39D325','9ECE59DB-C9B8-76CF-AE611F53657FFCB8','A0908F6D-EF32-C1C8-179582D523525BBC','A099D50D-08EE-E935-2DDDF98998DC9A4E','A0B9B6ED-F8CC-4723-B15628B4B846B52C','A10ADCA1-F75C-480D-DB06EA5C79BE150E','A12F3920-F6D3-BB77-18F55F9CFAD062D5','A1559BEA-BD99-793A-903DE6CBAF459E67','A19C385E-D5E9-4C31-B119581332FC4B16','A1B5845F-CE89-5701-AFDB4CA459B59A24','A1BA29C5-DA93-DD8D-52C5C9EC34F175EB','A21D1B09-7495-457C-AB8D-32B3D0BB9724','A2A37B35-B591-7A08-A880EDE5BCCE1C17','A2E88BAF-BB75-3B05-ACC2C5FA1EBC3606','A38CB837-DE98-F65E-43D7F7989BDB38D8','A3A1B007-BAA5-2D3C-9396688FA7D42824','A3B33C59-F371-24B3-C572E0D6B8C13E24','A3F270D5-0529-1D43-9094101170EB06E6','A3F32A10-FC9A-B9C0-29C2C67ED9847B34','A4147205-A1B0-F3D3-3606593EFB441075','A4A00C2D-ED9A-AB4D-4BE6973806E8AFC3','A50E4367-A7A6-3A46-7B84CED428C7DB46','A51D9AE0-E0FA-1695-80975942005AED00','A54A38ED-F230-D0C5-C33C16FDFE1EC901','A610994D-FBCF-3621-058D32F614835574','A699558E-D83D-97C4-23190485D3DCBB1D','A69D5EF5-ABBB-EB95-17D805F1028F061D','A712A304-0A5B-E99A-F1D05DFEA839CA92','A7278097-C7A1-B9D8-5319D12EDA3D57F9','A7AFC13C-B103-FEB1-C7BA840AB3B102F9','A7C26233-D31F-5DFA-8BC603FD7D190069','A7D6F614-CD99-C404-8DE60345292F7999','A8022C96-B470-ED04-F2DCC13C5D48F5B2','A802CAC0-9940-57F0-F80E1CDC9968DC2C','A932A2C4-CD95-0691-97E4A0023901CF4F','A9678593-01E2-C04C-AEF3734FA942F70C','AA3242F1-D397-EB59-90D054E07FA5BAD4','AA832562-A3A5-85DE-F9DCFDB8086F36C8','AB0FE16C-AFA4-425F-2BF83DDB92B0EE4A','AC3A7A74-9816-6947-3CB2E2A149DC087A','AC54EAD5-FBEB-72FE-3A07B25A8C0CF90F','ACEFB19F-E08E-179C-C575007C9A097A21','AD078570-CBEC-B071-5B27F42855F7D685','AD521A7B-A148-F492-FB9DFB2E18EC44FB','AE2CBBDE-B38E-A308-209D1F70F41DAA31','AE64D33F-A860-4D61-83BE-0E56A06398D2','AEB5E967-0B52-A608-A2CF7AD48DB7B8CC','AF4CEF7C-9AD1-777D-8C672E6BFE511E87','AF84D70D-CB3B-03F5-D7A8CA0702750ACB','B0097339-CDF3-6C0B-00CD8074D1E343BF','B08CAB38-BE47-BF80-46156366D472308A','B09531AC-EBF4-95C4-41C028ACD1DF4829','B0C72D3F-CDA4-125B-4C084E492804CA42','B116B5CE-B4A8-AEDA-A2215CFEE0C58AA2','B140F485-AC3C-0084-FB541DCDA4843087','B1A0AC16-DB6F-A934-2E7512CF0DB8F8E5','B1D658E8-95C1-E2F9-A058589E658A5B4E','B1E2D42B-9A5A-B823-9E121350A6B41CEC','B1F7D1A9-FCF8-F691-C02579565D242B4F','B2686658-D6C6-8927-9C55C3C40B1347AC','B27F2C16-AE1E-7F50-0D7EAE6D25E438C7','B3B0DD99-BCB2-093A-AE5DF1B680F78FA5')];I/O Error: Connection reset by peer: socket write error; nested exception isjava.sql.SQLException: I/O Error: Connection reset by peer: socket write error
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) ~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at com.issinc.cidne.indexer.report.JdbcReportDao.processBatch(JdbcReportDao.java:244)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao.access$400(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao$5.run(JdbcReportDao.java:185)~[indexer-2.3.11-SNAPSHOT.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_172]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
Caused by: java.sql.SQLException: I/O Error: Connectionreset by peer: socket write error
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1059)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:493)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)~[jtds-1.3.0.jar:1.3.0]
atorg.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)~[commons-dbcp-1.4.jar:1.4]
atorg.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)~[commons-dbcp-1.4.jar:1.4]
atorg.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
... 10 common frames omitted
Caused by: java.net.SocketException: Connection reset bypeer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.8.0_172]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)~[na:1.8.0_172]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)~[na:1.8.0_172]
at java.io.DataOutputStream.write(DataOutputStream.java:107) ~[na:1.8.0_172]
at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:717)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:570)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.RequestStream.write(RequestStream.java:316)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL70(TdsCore.java:3929) ~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1039)~[jtds-1.3.0.jar:1.3.0]
... 16 common frames omitted
2018-07-20 01:27:32,700 [pool-2-thread-4] ERRORcom.issinc.cidne.indexer.report.JdbcReportDao - Error processing batch.
org.springframework.dao.DataAccessResourceFailureException:PreparedStatementCallback; SQL [SELECT * FROMTARGETENGAGEMENTPUBLISHEDREPORTATTENDEE WHERE isDeprecated != 1 AND reportkey ='84CCFB0F-1D1C-4202-BB4D-340FD9EE5DF6']; I/O Error: Connection reset; nestedexception is java.sql.SQLException: I/O Error: Connection reset
atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:682)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:155)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processSubtable(JdbcReportDao.java:374)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao.access$800(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
atcom.issinc.cidne.indexer.report.JdbcReportDao$7.processRow(JdbcReportDao.java:308)~[indexer-2.3.11-SNAPSHOT.jar:na]
atorg.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1484)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
atcom.issinc.cidne.indexer.report.JdbcReportDao.processBatch(JdbcReportDao.java:244)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao.access$400(JdbcReportDao.java:68)~[indexer-2.3.11-SNAPSHOT.jar:na]
at com.issinc.cidne.indexer.report.JdbcReportDao$5.run(JdbcReportDao.java:185)~[indexer-2.3.11-SNAPSHOT.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_172]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[na:1.8.0_172]
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[na:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_172]
Caused by: java.sql.SQLException: I/O Error: Connectionreset
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1059)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:493)~[jtds-1.3.0.jar:1.3.0]
atnet.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)~[jtds-1.3.0.jar:1.3.0]
atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
atorg.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)~[commons-dbcp-1.4.jar:1.4]
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)~[spring-jdbc-3.2.1.RELEASE.jar:3.2.1.RELEASE]
... 20 common frames omitted
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210) ~[na:1.8.0_172]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_172]
at java.io.DataInputStream.readFully(DataInputStream.java:195) ~[na:1.8.0_172]
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:916)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:762)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:99)~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3999) ~[jtds-1.3.0.jar:1.3.0]
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1052)~[jtds-1.3.0.jar:1.3.0]
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply