Uderc programming article aggregator sites

30EA4 Problem using MySql: "Query execution was interrupted"

Tags:
Answers: Have 12 answers
Advertisement
Any query executes the first time but a second execution always causes the error "Query execution was interrupted"
(Update: I just installed the prodcution release of sql delveloper 2.1.1.64.45 and have the same issue)
I am using MySql driver 5.1.15
Others seem to have a similar issue and I tries the older JDBC drivers but the 5.0.4 cause the connection to hang and the 5.0.8 caused the same problem "Query execution was interrupted"
Vendor Code 1317 Query execution was interrupted MySQL
I am using Windows7 64 bit (sql developer and jdk are 32 bit), see below
MySql version
-------------------------------------------------------+
| Variable_name | Value |
-------------------------------------------------------+
| innodb_version | 1.1.4 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.8 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86 |
| version_compile_os | Win64 |
-------------------------------------------------------+
SQL Develper Info:
About
Oracle SQL Developer 3.0.03
Version 3.0.03
Build MAIN-03.97
Copyright © 2005, 2011 Oracle. All Rights Reserved.
IDE Version: 11.1.1.4.37.59.36
Product ID: oracle.sqldeveloper
Product Version: 11.1.2.03.97
Version
Component     Version
=========     =======
Java(TM) Platform     1.6.0_24
Oracle IDE     3.0.03.97
Versioning Support     3.0.03.97
Properties
Name     Value
====     =====
awt.toolkit     sun.awt.windows.WToolkit
class.load.environment     oracle.ide.boot.IdeClassLoadEnvironment
class.load.log.level     CONFIG
class.transfer     delegate
file.encoding     Cp1252
file.encoding.pkg     sun.io
file.separator     \
http.agent     Mozilla/5.0 (Java 1.6.0_24; Windows 7 6.1 x86; en_IE) ICEbrowser/v6_1_3
ice.browser.forcegc     false
ice.pilots.html4.ignoreNonGenericFonts     true
ice.pilots.html4.tileOptThreshold     0
ide.AssertTracingDisabled     true
ide.bootstrap.start     7381246437329
ide.build     MAIN-03.97
ide.conf     C:\Program Files (x86)\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.config_pathname     C:\Program Files (x86)\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.debugbuild     false
ide.devbuild     false
ide.extension.search.path     sqldeveloper/extensions:jdev/extensions:ide/extensions
ide.firstrun     true
ide.java.minversion     1.6.0_04
ide.launcherProcessId     2204
ide.main.class     oracle.ide.boot.IdeLauncher
ide.patches.dir     ide/lib/patches
ide.pref.dir     C:\Users\mark\AppData\Roaming\SQL Developer
ide.pref.dir.base     C:\Users\mark\AppData\Roaming
ide.product     oracle.sqldeveloper
ide.shell.enableFileTypeAssociation     C:\Program Files (x86)\sqldeveloper\sqldeveloper.exe
ide.splash.screen     splash.gif
ide.startingArg0     C:\Program Files (x86)\sqldeveloper\sqldeveloper.exe
ide.startingcwd     C:\Program Files (x86)\sqldeveloper
ide.user.dir     C:\Users\mark\AppData\Roaming\SQL Developer
ide.user.dir.var     IDE_USER_DIR
ide.vcs.noapplications     true
ide.work.dir     C:\Users\mark\Documents\SQL Developer
ide.work.dir.base     C:\Users\mark\Documents
ilog.propagatesPropertyEditors     false
java.awt.graphicsenv     sun.awt.Win32GraphicsEnvironment
java.awt.printerjob     sun.awt.windows.WPrinterJob
java.class.path     ..\..\ide\lib\ide-boot.jar
java.class.version     50.0
java.endorsed.dirs     C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\endorsed
java.ext.dirs     C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
java.home     C:\Program Files (x86)\Java\jdk1.6.0_24\jre
java.io.tmpdir     C:\Users\mark\AppData\Local\Temp\
java.library.path     C:\Program Files (x86)\sqldeveloper;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files\TortoiseSVN\bin;C:\Program Files\SlikSvn\bin\;C:\Program Files (x86)\Java\jdk1.6.0_24\bin;C:\Program Files (x86)\OpenVPN\bin;C:\tools\apache-maven-3.0.2\bin;C:\tools\mysql-5.5.8-winx64\bin
java.naming.factory.initial     oracle.javatools.jndi.LocalInitialContextFactory
java.protocol.handler.pkgs     oracle.jdevimpl.handler
java.runtime.name     Java(TM) SE Runtime Environment
java.runtime.version     1.6.0_24-b07
java.specification.name     Java Platform API Specification
java.specification.vendor     Sun Microsystems Inc.
java.specification.version     1.6
java.util.logging.config.file     logging.conf
java.vendor     Sun Microsystems Inc.
java.vendor.url     http://java.sun.com/
java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
java.version     1.6.0_24
java.vm.info     mixed mode
java.vm.name     Java HotSpot(TM) Client VM
java.vm.specification.name     Java Virtual Machine Specification
java.vm.specification.vendor     Sun Microsystems Inc.
java.vm.specification.version     1.0
java.vm.vendor     Sun Microsystems Inc.
java.vm.version     19.1-b02
jdbc.library     /C:/Program Files (x86)/sqldeveloper/jdbc/lib/ojdbc6.jar
line.separator     \r\n
log.file.name     ..//log/datamodeler.log
oracle.home     C:\Program Files (x86)\sqldeveloper
oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG     true
oracle.jdbc.mapDateToTimestamp     false
oracle.translated.locales     de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
oracle.xdkjava.compatibility.version     9.0.4
orai18n.library     /C:/Program Files (x86)/sqldeveloper/jlib/orai18n.jar
os.arch     x86
os.name     Windows 7
os.version     6.1
path.separator     ;
reserved_filenames     con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
sqldev.debug     false
sun.arch.data.model     32
sun.boot.class.path     C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\resources.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\rt.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\sunrsasign.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\jsse.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\jce.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\charsets.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\lib\modules\jdk.boot.jar;C:\Program Files (x86)\Java\jdk1.6.0_24\jre\classes
sun.boot.library.path     C:\Program Files (x86)\Java\jdk1.6.0_24\jre\bin
sun.cpu.endian     little
sun.cpu.isalist     pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop     windows
sun.io.unicode.encoding     UnicodeLittle
sun.java2d.ddoffscreen     false
sun.jnu.encoding     Cp1252
sun.management.compiler     HotSpot Client Compiler
sun.os.patch.level     
svnkit.sax.useDefault     true
user.country     IE
user.dir     C:\Program Files (x86)\sqldeveloper\sqldeveloper\bin
user.home     C:\Users\mark
user.language     en
user.name     mark
user.timezone     Europe/Paris
user.variant     
windows.shell.font.languages     
Extensions
Name     Identifier     Version     Status
====     ==========     =======     ======
Check For Updates     oracle.ide.webupdate     11.1.1.4.37.59.36     Loaded
Code Editor     oracle.ide.ceditor     11.1.1.4.37.59.36     Loaded
Component Palette     oracle.ide.palette1     11.1.1.4.37.59.36     Loaded
Data Miner     oracle.dmt.dataminer     11.2.0.1.9.96     Loaded
Database Connection Support     oracle.jdeveloper.db.connection     11.1.1.4.37.59.36     Loaded
Database Object Explorers     oracle.ide.db.explorer     11.1.1.4.37.59.36     Loaded
Database UI     oracle.ide.db     11.1.1.4.37.59.36     Loaded
Diagram Framework     oracle.diagram     11.1.1.4.37.59.36     Loaded
Diagram Javadoc Extension     oracle.diagram.javadoc     11.1.1.4.37.59.36     Loaded
Diagram Thumbnail     oracle.diagram.thumbnail     11.1.1.4.37.59.36     Loaded
Diff/Merge     oracle.ide.diffmerge     11.1.1.4.37.59.36     Loaded
Extended IDE Platform     oracle.javacore     11.1.1.4.37.59.36     Loaded
External Tools     oracle.ide.externaltools     11.1.1.4.37.59.36     Loaded
File Support     oracle.ide.files     11.1.1.4.37.59.36     Loaded
Help System     oracle.ide.help     11.1.1.4.37.59.36     Loaded
History Support     oracle.jdeveloper.history     11.1.1.4.37.59.36     Loaded
Import/Export Support     oracle.ide.importexport     11.1.1.4.37.59.36     Loaded
Index Migrator support     oracle.ideimpl.indexing-migrator     11.1.1.4.37.59.36     Loaded
JDeveloper Runner     oracle.jdeveloper.runner     11.1.1.4.37.59.36     Loaded
JViews Registration Addin     oracle.diagram.registration     11.1.1.4.37.59.36     Loaded
Log Window     oracle.ide.log     11.1.1.4.37.59.36     Loaded
Mac OS X Adapter     oracle.ideimpl.apple     11.1.1.4.37.59.36     Loaded
Navigator     oracle.ide.navigator     11.1.1.4.37.59.36     Loaded
Object Gallery     oracle.ide.gallery     11.1.1.4.37.59.36     Loaded
Oracle IDE     oracle.ide     11.1.1.4.37.59.36     Loaded
Oracle SQL Developer     oracle.sqldeveloper     11.1.2.03.97     Loaded
Oracle SQL Developer - 3rd Party Database Browsers     oracle.sqldeveloper.thirdparty.browsers     11.1.1.03.97     Loaded
Oracle SQL Developer - DBA Navigator     oracle.sqldeveloper.dbanavigator     11.1.1.03.97     Loaded
Oracle SQL Developer - Extras     oracle.sqldeveloper.extras     1.1.1.03.97     Loaded
Oracle SQL Developer - File Navigator     oracle.sqldeveloper.filenavigator     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Antlr3 Translator     oracle.sqldeveloper.migration.translation.core_antlr3     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Application Migration     oracle.sqldeveloper.migration.application     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Core     oracle.sqldeveloper.migration     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations DB2     oracle.sqldeveloper.migration.db2     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations DB2 Translator     oracle.sqldeveloper.migration.translation.db2     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Microsoft Access     oracle.sqldeveloper.migration.msaccess     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Microsoft SQL Server     oracle.sqldeveloper.migration.sqlserver     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations MySQL     oracle.sqldeveloper.migration.mysql     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Sybase Adaptive Server     oracle.sqldeveloper.migration.sybase     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations T-SQL Translator     oracle.sqldeveloper.migration.translation.core     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Teradata     oracle.sqldeveloper.migration.teradata     11.1.1.03.97     Loaded
Oracle SQL Developer - Migrations Translation UI     oracle.sqldeveloper.migration.translation.gui     11.1.1.03.97     Loaded
Oracle SQL Developer - Object Viewer     oracle.sqldeveloper.oviewer     11.1.1.03.97     Loaded
Oracle SQL Developer - Real Time SQL Monitoring     oracle.sqldeveloper.sqlmonitor     11.1.1.03.97     Loaded
Oracle SQL Developer - Reports     oracle.sqldeveloper.report     11.1.1.03.97     Loaded
Oracle SQL Developer - Scheduler     oracle.sqldeveloper.scheduler     11.1.1.03.97     Loaded
Oracle SQL Developer - Schema Browser     oracle.sqldeveloper.schemabrowser     11.1.1.03.97     Loaded
Oracle SQL Developer - SearchBar     oracle.sqldeveloper.searchbar     11.1.1.03.97     Loaded
Oracle SQL Developer - Snippet     oracle.sqldeveloper.snippet     11.1.1.03.97     Loaded
Oracle SQL Developer - Spatial     oracle.sqldeveloper.spatial     11.1.1.03.97     Loaded
Oracle SQL Developer - TimesTen     oracle.sqldeveloper.timesten     2.0.0.03.97     Loaded
Oracle SQL Developer - Tuning     oracle.sqldeveloper.tuning     11.1.1.03.97     Loaded
Oracle SQL Developer - Unit Test     oracle.sqldeveloper.unit_test     11.1.1.03.97     Loaded
Oracle SQL Developer - User Extensions Support     oracle.sqldeveloper.userextensions     11.1.1.03.97     Loaded
Oracle SQL Developer - Worksheet v2     oracle.sqldeveloper.worksheet     11.1.1.03.97     Loaded
Oracle SQL Developer - XML Schema     oracle.sqldeveloper.xmlschema     11.1.1.03.97     Loaded
Oracle SQL Developer Data Modeler     oracle.datamodeler     3.0.0.665     Loaded
Oracle SQL Developer Data Modeler - Reports     oracle.sqldeveloper.datamodeler_reports     11.1.1.03.97     Loaded
PROBE Debugger     oracle.jdeveloper.db.debug.probe     11.1.1.4.37.59.36     Loaded
Peek     oracle.ide.peek     11.1.1.4.37.59.36     Loaded
Persistent Storage     oracle.ide.persistence     11.1.1.4.37.59.36     Loaded
Property Inspector     oracle.ide.inspector     11.1.1.4.37.59.36     Loaded
QuickDiff     oracle.ide.quickdiff     11.1.1.4.37.59.36     Loaded
Replace With     oracle.ide.replace     11.1.1.4.37.59.36     Loaded
Runner     oracle.ide.runner     11.1.1.4.37.59.36     Loaded
VHV     oracle.ide.vhv     11.1.1.4.37.59.36     Loaded
Versioning Support     oracle.jdeveloper.vcs     11.1.1.4.37.59.36     Loaded
Versioning Support for Subversion     oracle.jdeveloper.subversion     11.1.1.4.37.59.36     Loaded
Virtual File System     oracle.ide.vfs     11.1.1.4.37.59.36     Loaded
Web Browser and Proxy     oracle.ide.webbrowser     11.1.1.4.37.59.36     Loaded
XML Editing Framework IDE Extension     oracle.ide.xmlef     11.1.1.4.37.59.36     Loaded
audit     oracle.ide.audit     11.1.1.4.37.59.36     Loaded
classpath: protocol handler extension     oracle.jdeveloper.classpath     11.1.1.0.0     Loaded
jdukshare     oracle.bm.jdukshare     11.1.1.4.37.59.36     Loaded
mof-xmi     oracle.mof.xmi     11.1.1.4.37.59.36     Loaded
oracle.ide.dependency     oracle.ide.dependency     11.1.1.4.37.59.36     Loaded
oracle.ide.indexing     oracle.ide.indexing     11.1.1.4.37.59.36     Loaded
palette2     oracle.ide.palette2     11.1.1.4.37.59.36     Loaded
status     oracle.ide.status     11.1.1.4.37.59.36     Loaded
Edited by: user501466 on 19-Mar-2011 03:21
Advertisement
The best answer: Hi Dermot,
Some clarification.
I have tried these 3 drivers below with the following results:
5.0.4 First Query succeeds, Second gives error "Unknown prepared statement handler (131072) given to mysqld_stmt_execute". At this point I can exit SQL Developer. If I run it a third time then the query does not complete and any attempt to exit SQL Developer results in "Connection is currently busy, try again?" and ultimately I have to kill it.
5.0.8 First Query succeeds, Second Query fails with Query execution was interrupted. Subsequent queries give the same result.
5.1.15 Same as 5.0.8
I tried your suggestion, removed the driver, restarted, installed the 5.0.4 driver and restated and ran the test,
(I added a drop table so I could run it repeatedly) and it works repeatedly if I choose "Run as script F5".
DROP TABLE table1;
CREATE TABLE table1(col1 int);
INSERT INTO Table1 values(1);
SELECT * FROM table1;
SELECT * FROM table1;
But If I execute the query "select * from table1" using "Run Statement Ctrl-Enter" twice then I get problem behaviour as described above.
I looked in the logfile for SQLDeveloper but it was empty.
I also tried creating a new database as root and connecting as root (same result)
I also tried the NightlyBuild of 5.1 and 6.0 but gave the same result as 5.1.5.
I have two other tools for accessing MySql: Toad and MySql workbench, both of which work but I've used SQL Developer with Oracle for some years and would like to keep using it.
I just tried connecting to a remote MySQL database and that seems to work without problems.
I'm thinking it may be related to some incompatibility between SQLDeveloper and the MySQL installed locally.
I'll try another version....
Ok I installed a 32 bit version of MySql 5.5.10. I thought things were working but now I still get the problem but it is much more intermittent.
Now I can get it by modifying the query ie.
select * from table1; (works repeatedly untill followed by a change to the query)
select * from table1 order by col1; (fails)
Another case
select * from table1 order by col1; (works repeatedly)
select * from table1 order by col1 asc; (fails first time)
very weird...
Edited by: user501466 on 26-Mar-2011 06:19