Bug #5052 | java.lang.NegativeArraySizeException thrown when querying | ||
---|---|---|---|
Submitted: | 14 Aug 2004 1:45 | Modified: | 31 Aug 2004 0:48 |
Reporter: | Matthew Schultz | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / J | Severity: | S1 (Critical) |
Version: | 3.1.3-beta | OS: | Linux (Linux Kernel 2.4.26) |
Assigned to: | CPU Architecture: | Any |
[14 Aug 2004 1:45]
Matthew Schultz
[16 Aug 2004 18:52]
Mark Matthews
Is this on MySQL-4.1.x or 4.0.x? Could you please test with the latest nightly snapshot from http://downloads.mysql.com/snapshots.php?
[18 Aug 2004 17:38]
Matthew Schultz
When testing with useUnicode=true and characterEncoding=utf8 options, the nightly build connector (mysql-connector-java-3.1-nightly-20040818) doesn't throw any errors but when setting useCompression=true, I get an error again: Error Executing Database Query. Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.lang.ArrayIndexOutOfBoundsException STACKTRACE: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at com.mysql.jdbc.CompressedInputStream.read(CompressedInputStream.java:133) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1801) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2297) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2697) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:731) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1200) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2156) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:398) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1861) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1297) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1615) at com.mysql.jdbc.Connection.execSQL(Connection.java:2228) at com.mysql.jdbc.Connection.execSQL... The error occurred in /home/www/rootsite/categories/menu.cfm: line 189 Called from /home/www/rootsite/categories/menu.cfm: line 139 Called from /home/www/rootsite/categories/menu.cfm: line 59 Called from /home/www/rootsite/categories/menu.cfm: line 1 Called from /home/www/rootsite/header.cfm: line 175 Called from /home/www/rootsite/header.cfm: line 1 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 81 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 1 Called from /home/www/rootsite/categories/menu.cfm: line 189 Called from /home/www/rootsite/categories/menu.cfm: line 139 Called from /home/www/rootsite/categories/menu.cfm: line 59 Called from /home/www/rootsite/categories/menu.cfm: line 1 Called from /home/www/rootsite/header.cfm: line 175 Called from /home/www/rootsite/header.cfm: line 1 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 81 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 1 Called from /home/www/rootsite/categories/menu.cfm: line 189 Called from /home/www/rootsite/categories/menu.cfm: line 139 Called from /home/www/rootsite/categories/menu.cfm: line 59 Called from /home/www/rootsite/categories/menu.cfm: line 1 Called from /home/www/rootsite/header.cfm: line 175 Called from /home/www/rootsite/header.cfm: line 1 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 81 Called from /home/www/elcortezhotelcasino.com/categories/index.cfm: line 1 187 : SELECT * 188 : FROM categories 189 : WHERE admin = #adminCat# AND parent = '#category#' AND displayMenu = 1 <cfif adminCat eq 0>AND (protection = 3<cfif sessionLogin is not ""> OR protection = 2</cfif><cfif sessionLogin is ""> OR protection = 1</cfif>)</cfif> AND ((startDate = '#request.dbNullDateTime#' AND endDate = '#request.dbNullDateTime#') OR (startDate <= '#previewDate#' AND endDate >= '#previewDate#')) 190 : </cfquery> 191 : <!---Check subcategory permissions to find out whether or not they should be displayed---> SQL SELECT * FROM categories WHERE admin = 0 AND parent = '54DAF6BE-57E8-45D7-A61B7B88026F9240' AND displayMenu = 1 AND (protection = 3 OR protection = 1) AND ((startDate = '0000-00-00 00:00:00' AND endDate = '0000-00-00 00:00:00') OR (startDate <= '2004-08-18' AND endDate >= '2004-08-18')) DATASOURCE elcortez SQLSTATE 08S01 Please try the following: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.8a2) Gecko/20040714 Remote Address 68.104.22.7 Referrer http://www.elcortezhotelcasino.com/ Date/Time 18-Aug-04 08:33 AM Stack Trace at cfmenu2ecfm1513246095._factor10(/home/www/rootsite/categories/menu.cfm:189) at cfmenu2ecfm1513246095._factor13(/home/www/rootsite/categories/menu.cfm:139) at cfmenu2ecfm1513246095._factor15(/home/www/rootsite/categories/menu.cfm:59) at cfmenu2ecfm1513246095.runPage(/home/www/rootsite/categories/menu.cfm:1) at cfheader2ecfm883003480._factor4(/home/www/rootsite/header.cfm:175) at cfheader2ecfm883003480.runPage(/home/www/rootsite/header.cfm:1) at cfindex2ecfm123074080._factor6(/home/www/elcortezhotelcasino.com/categories/index.cfm:81) at cfindex2ecfm123074080.runPage(/home/www/elcortezhotelcasino.com/categories/index.cfm:1) at cfmenu2ecfm1513246095._factor10(/home/www/rootsite/categories/menu.cfm:189) at cfmenu2ecfm1513246095._factor13(/home/www/rootsite/categories/menu.cfm:139) at cfmenu2ecfm1513246095._factor15(/home/www/rootsite/categories/menu.cfm:59) at cfmenu2ecfm1513246095.runPage(/home/www/rootsite/categories/menu.cfm:1) at cfheader2ecfm883003480._factor4(/home/www/rootsite/header.cfm:175) at cfheader2ecfm883003480.runPage(/home/www/rootsite/header.cfm:1) at cfindex2ecfm123074080._factor6(/home/www/elcortezhotelcasino.com/categories/index.cfm:81) at cfindex2ecfm123074080.runPage(/home/www/elcortezhotelcasino.com/categories/index.cfm:1) at cfmenu2ecfm1513246095._factor10(/home/www/rootsite/categories/menu.cfm:189) at cfmenu2ecfm1513246095._factor13(/home/www/rootsite/categories/menu.cfm:139) at cfmenu2ecfm1513246095._factor15(/home/www/rootsite/categories/menu.cfm:59) at cfmenu2ecfm1513246095.runPage(/home/www/rootsite/categories/menu.cfm:1) at cfheader2ecfm883003480._factor4(/home/www/rootsite/header.cfm:175) at cfheader2ecfm883003480.runPage(/home/www/rootsite/header.cfm:1) at cfindex2ecfm123074080._factor6(/home/www/elcortezhotelcasino.com/categories/index.cfm:81) at cfindex2ecfm123074080.runPage(/home/www/elcortezhotelcasino.com/categories/index.cfm:1) com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.lang.ArrayIndexOutOfBoundsException STACKTRACE: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at com.mysql.jdbc.CompressedInputStream.read(CompressedInputStream.java:133) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1801) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2297) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2697) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:731) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1200) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2156) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:398) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1861) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1297) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1615) at com.mysql.jdbc.Connection.execSQL(Connection.java:2228) at com.mysql.jdbc.Connection.execSQL(Connection.java:2159) at com.mysql.jdbc.Statement.execute(Statement.java:869) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212) at coldfusion.sql.Executive.executeQuery(Executive.java:974) at coldfusion.sql.Executive.executeQuery(Executive.java:886) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) at cfmenu2ecfm1513246095._factor10(/home/www/rootsite/categories/menu.cfm:189) at cfmenu2ecfm1513246095._factor13(/home/www/rootsite/categories/menu.cfm:139) at cfmenu2ecfm1513246095._factor15(/home/www/rootsite/categories/menu.cfm:59) at cfmenu2ecfm1513246095.runPage(/home/www/rootsite/categories/menu.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfheader2ecfm883003480._factor4(/home/www/rootsite/header.cfm:175) at cfheader2ecfm883003480.runPage(/home/www/rootsite/header.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfindex2ecfm123074080._factor6(/home/www/elcortezhotelcasino.com/categories/index.cfm:81) at cfindex2ecfm123074080.runPage(/home/www/elcortezhotelcasino.com/categories/index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ** END NESTED EXCEPTION ** at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2703) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:731) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1200) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2156) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:398) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1861) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1297) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1615) at com.mysql.jdbc.Connection.execSQL(Connection.java:2228) at com.mysql.jdbc.Connection.execSQL(Connection.java:2159) at com.mysql.jdbc.Statement.execute(Statement.java:869) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212) at coldfusion.sql.Executive.executeQuery(Executive.java:974) at coldfusion.sql.Executive.executeQuery(Executive.java:886) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) at cfmenu2ecfm1513246095._factor10(/home/www/rootsite/categories/menu.cfm:189) at cfmenu2ecfm1513246095._factor13(/home/www/rootsite/categories/menu.cfm:139) at cfmenu2ecfm1513246095._factor15(/home/www/rootsite/categories/menu.cfm:59) at cfmenu2ecfm1513246095.runPage(/home/www/rootsite/categories/menu.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfheader2ecfm883003480._factor4(/home/www/rootsite/header.cfm:175) at cfheader2ecfm883003480.runPage(/home/www/rootsite/header.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfindex2ecfm123074080._factor6(/home/www/elcortezhotelcasino.com/categories/index.cfm:81) at cfindex2ecfm123074080.runPage(/home/www/elcortezhotelcasino.com/categories/index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
[18 Aug 2004 17:39]
Matthew Schultz
This is with mysql-4.1.3-beta
[31 Aug 2004 0:48]
Mark Matthews
Thank you for taking the time to report a problem. Unfortunately you are not using a current version of the product your reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/ If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of MySQL.