sql exception:1711
I am getting the following error from my external mysql server. in [workspace]/.metadata/.log I see the following message: !ENTRY com.fnfr.foundation 4 4 2013-09-18 16:37:50.857 !MESSAGE getExecutionIssue() got sql exception:1711 !STACK 0 com.fnfr.foundation.exceptions.SpirentException: getExecutionIssue() got sql exception:1711 at com.fnfr.svt.testreport.database.manager.DbTestReport.getExecutionIssue(DbTestReport.java:113) at com.fnfr.svt.execution.kernel.TestReporter.getExecutionIssueAt(TestReporter.java:323) at com.fnfr.svt.execution.kernel.BaseStepExecutor.renderIssueTable(BaseStepExecutor.java:1216) at com.fnfr.svt.execution.kernel.ExecStepExecutor.generateSummarize(ExecStepExecutor.java:737) at com.fnfr.svt.execution.kernel.ExecutionProcess.generateSummarize(ExecutionProcess.java:908) at com.fnfr.svt.workspaceserver.testcaseexecutor.TestCaseExecutor.notifyExecutionCompleted(TestCaseExecutor.java:664) at com.fnfr.svt.execution.kernel.ExecutionProcess.fireExecutionCompleted(ExecutionProcess.java:1665) at com.fnfr.svt.execution.kernel.ExecutionProcess.finishExecution(ExecutionProcess.java:1257) at com.fnfr.svt.execution.kernel.ExecutionProcess.notifyCompleted(ExecutionProcess.java:593) at com.fnfr.svt.execution.kernel.ExecutionThread.ffrun(ExecutionThread.java:792) at com.fnfr.foundation.FanfareRunnable.run(FanfareRunnable.java:91) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:835) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5571) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5491) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5531) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at com.fnfr.svt.testreport.database.manager.DbTestReport.getExecutionIssue(DbTestReport.java:100) ... 11 more can you explain what is exception 1711, also how can I avoid/fix it.
Hi Please modify the following field in my.cnf file. a. Comment out the option wait_timeout=30 in above file. Eg: #wait_timeout=30 my.cnf file location: In Linux: /etc/mysql/my.cnf to set global options, In Windows:(my.ini) C:\Program Files\MySQL\MySQL Server X.Y Hope this will resolve the issue and let us know if you still face the problem.
Hi, As per the log, it seems the error might be related to log in or configuration. Please post a query at
support@spirent.com. They will assist you. Thanks, Sai Kiran
5 People are following this question.
