Uderc programming article aggregator sites

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

Answers: Have 12 answers
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 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:
Oracle SQL Developer 3.0.03
Version 3.0.03
Build MAIN-03.97
Copyright © 2005, 2011 Oracle. All Rights Reserved.
IDE Version:
Product ID: oracle.sqldeveloper
Product Version:
Component     Version
=========     =======
Java(TM) Platform     1.6.0_24
Oracle IDE
Versioning Support
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
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
Name     Identifier     Version     Status
====     ==========     =======     ======
Check For Updates     oracle.ide.webupdate     Loaded
Code Editor     oracle.ide.ceditor     Loaded
Component Palette     oracle.ide.palette1     Loaded
Data Miner     oracle.dmt.dataminer     Loaded
Database Connection Support     oracle.jdeveloper.db.connection     Loaded
Database Object Explorers     oracle.ide.db.explorer     Loaded
Database UI     oracle.ide.db     Loaded
Diagram Framework     oracle.diagram     Loaded
Diagram Javadoc Extension     oracle.diagram.javadoc     Loaded
Diagram Thumbnail     oracle.diagram.thumbnail     Loaded
Diff/Merge     oracle.ide.diffmerge     Loaded
Extended IDE Platform     oracle.javacore     Loaded
External Tools     oracle.ide.externaltools     Loaded
File Support     oracle.ide.files     Loaded
Help System     oracle.ide.help     Loaded
History Support     oracle.jdeveloper.history     Loaded
Import/Export Support     oracle.ide.importexport     Loaded
Index Migrator support     oracle.ideimpl.indexing-migrator     Loaded
JDeveloper Runner     oracle.jdeveloper.runner     Loaded
JViews Registration Addin     oracle.diagram.registration     Loaded
Log Window     oracle.ide.log     Loaded
Mac OS X Adapter     oracle.ideimpl.apple     Loaded
Navigator     oracle.ide.navigator     Loaded
Object Gallery     oracle.ide.gallery     Loaded
Oracle IDE     oracle.ide     Loaded
Oracle SQL Developer     oracle.sqldeveloper     Loaded
Oracle SQL Developer - 3rd Party Database Browsers     oracle.sqldeveloper.thirdparty.browsers     Loaded
Oracle SQL Developer - DBA Navigator     oracle.sqldeveloper.dbanavigator     Loaded
Oracle SQL Developer - Extras     oracle.sqldeveloper.extras     Loaded
Oracle SQL Developer - File Navigator     oracle.sqldeveloper.filenavigator     Loaded
Oracle SQL Developer - Migrations Antlr3 Translator     oracle.sqldeveloper.migration.translation.core_antlr3     Loaded
Oracle SQL Developer - Migrations Application Migration     oracle.sqldeveloper.migration.application     Loaded
Oracle SQL Developer - Migrations Core     oracle.sqldeveloper.migration     Loaded
Oracle SQL Developer - Migrations DB2     oracle.sqldeveloper.migration.db2     Loaded
Oracle SQL Developer - Migrations DB2 Translator     oracle.sqldeveloper.migration.translation.db2     Loaded
Oracle SQL Developer - Migrations Microsoft Access     oracle.sqldeveloper.migration.msaccess     Loaded
Oracle SQL Developer - Migrations Microsoft SQL Server     oracle.sqldeveloper.migration.sqlserver     Loaded
Oracle SQL Developer - Migrations MySQL     oracle.sqldeveloper.migration.mysql     Loaded
Oracle SQL Developer - Migrations Sybase Adaptive Server     oracle.sqldeveloper.migration.sybase     Loaded
Oracle SQL Developer - Migrations T-SQL Translator     oracle.sqldeveloper.migration.translation.core     Loaded
Oracle SQL Developer - Migrations Teradata     oracle.sqldeveloper.migration.teradata     Loaded
Oracle SQL Developer - Migrations Translation UI     oracle.sqldeveloper.migration.translation.gui     Loaded
Oracle SQL Developer - Object Viewer     oracle.sqldeveloper.oviewer     Loaded
Oracle SQL Developer - Real Time SQL Monitoring     oracle.sqldeveloper.sqlmonitor     Loaded
Oracle SQL Developer - Reports     oracle.sqldeveloper.report     Loaded
Oracle SQL Developer - Scheduler     oracle.sqldeveloper.scheduler     Loaded
Oracle SQL Developer - Schema Browser     oracle.sqldeveloper.schemabrowser     Loaded
Oracle SQL Developer - SearchBar     oracle.sqldeveloper.searchbar     Loaded
Oracle SQL Developer - Snippet     oracle.sqldeveloper.snippet     Loaded
Oracle SQL Developer - Spatial     oracle.sqldeveloper.spatial     Loaded
Oracle SQL Developer - TimesTen     oracle.sqldeveloper.timesten     Loaded
Oracle SQL Developer - Tuning     oracle.sqldeveloper.tuning     Loaded
Oracle SQL Developer - Unit Test     oracle.sqldeveloper.unit_test     Loaded
Oracle SQL Developer - User Extensions Support     oracle.sqldeveloper.userextensions     Loaded
Oracle SQL Developer - Worksheet v2     oracle.sqldeveloper.worksheet     Loaded
Oracle SQL Developer - XML Schema     oracle.sqldeveloper.xmlschema     Loaded
Oracle SQL Developer Data Modeler     oracle.datamodeler     Loaded
Oracle SQL Developer Data Modeler - Reports     oracle.sqldeveloper.datamodeler_reports     Loaded
PROBE Debugger     oracle.jdeveloper.db.debug.probe     Loaded
Peek     oracle.ide.peek     Loaded
Persistent Storage     oracle.ide.persistence     Loaded
Property Inspector     oracle.ide.inspector     Loaded
QuickDiff     oracle.ide.quickdiff     Loaded
Replace With     oracle.ide.replace     Loaded
Runner     oracle.ide.runner     Loaded
VHV     oracle.ide.vhv     Loaded
Versioning Support     oracle.jdeveloper.vcs     Loaded
Versioning Support for Subversion     oracle.jdeveloper.subversion     Loaded
Virtual File System     oracle.ide.vfs     Loaded
Web Browser and Proxy     oracle.ide.webbrowser     Loaded
XML Editing Framework IDE Extension     oracle.ide.xmlef     Loaded
audit     oracle.ide.audit     Loaded
classpath: protocol handler extension     oracle.jdeveloper.classpath     Loaded
jdukshare     oracle.bm.jdukshare     Loaded
mof-xmi     oracle.mof.xmi     Loaded
oracle.ide.dependency     oracle.ide.dependency     Loaded
oracle.ide.indexing     oracle.ide.indexing     Loaded
palette2     oracle.ide.palette2     Loaded
status     oracle.ide.status     Loaded
Edited by: user501466 on 19-Mar-2011 03:21
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