ReportServer Forum

sdavies68

Member

Registered: 2015-02-11

Mysql Timeouts with RP2.2

Hello,

I am having the same error experienced in older RS versions with MySQL timeouts.

http://forum.reportserver.net/viewtopic.php?id=98

I have tried looking for the pool.cf file, but cannot find it on RS2.2.1-5602

Last edited by sdavies68 (2015-02-11 11:54:54)

sdavies68

Member

Registered: 2015-02-11

Re: Mysql Timeouts with RP2.2

OK, I have found the pool file under the File system in Administrator (I was looking for it in the OS).

This is the pool configuration

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <pool>
      <defaultconfig>
         <maxPoolSize>40</maxPoolSize>
         <initialPoolSize>10</initialPoolSize>
         <acquireRetryAttempts>10</acquireRetryAttempts>
         <acquireRetryDelay>500</acquireRetryDelay>
         <checkoutTimeout>60000</checkoutTimeout>
         <maxConnectionAge>7200</maxConnectionAge>
         <maxIdleTime>3600</maxIdleTime>
      </defaultconfig>
   </pool>
</configuration>

This is the error I get

Error: An error occured during report execution.
The report could not be executed: Could not open connection to: jdbc:mysql://172.31.254.62:3306/portal210 with user: {username}. java.sql.SQLNonTransientConnectionException: Could not read resultset: unexpected end of stream, read 0bytes from 4
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not open connection to: jdbc:mysql://{serverip}:3306/portal210 with user: {username}. java.sql.SQLNonTransientConnectionException: Could not read resultset: unexpected end of stream, read 0bytes from 4 at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:527) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:402) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportById(ReportExportServlet.java:270) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportByIdViaRequest(ReportExportServlet.java:261) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:162) at
.......
.......

I click the refresh (sometimes twice) and it loads the report fine.

Thorsten J. Krause

Guest

Re: Mysql Timeouts with RP2.2

Hi,

did you check the value of the wait_timeout property for your mysql server? You can do this with the query

show variables like "wait_timeout"

the default value is 28800 (8hrs) which is way more than the maxConnectionAge the pool uses, so there should be no problems. But perhaps your server just isn't using the default value.

Cheers,
Thorsten

sdavies68

Member

Registered: 2015-02-11

Re: Mysql Timeouts with RP2.2

My value was 15!

I have change it to 3600 and will monitor.

Thank-you

Last edited by sdavies68 (2015-02-12 08:20:39)