Vertica - Cannot cancel a running query

[wmorin]

DBeaver wait indefinitely when I cancel a running query. The "canceled" button stay gray and the "read data" time count continue to increment. On Vertica side, I can see that the session is still running. The only workaround I can use is to close the session in Vertica. Pretty complicated.

I'm running Beaver 3.5.2 enterprise under osx El Capitan but it was also occurring under Yosemite.

You can find a screenhot of the dialog:

And here the information under configuration pane:

*** Date: jeudi 29 octobre 2015 17 h 44 CET

*** Platform Details:

*** System properties:
DRIVERS_LOCATION=/Users/wmorin/.dbeaver/.metadata/.plugins/org.jkiss.dbeaver.core
applicationXMI=org.eclipse.ui.workbench/LegacyIDE.e4xmi
awt.toolkit=sun.lwawt.macosx.LWCToolkit
eclipse.application=org.jkiss.dbeaver.core.application.standalone
eclipse.commands=-os
macosx
-ws
cocoa
-arch
x86_64
-showsplash
-launcher
/Applications/DBeaver.app/Contents/MacOS/dbeaver
-name
Dbeaver
--launcher.library
/Applications/DBeaver.app/Contents/MacOS//../Eclipse/plugins/org.eclipse.equinox.launcher.cocoa.macosx.x86_64_1.1.300.v20150602-1417/eclipse_1611.so
-startup
/Applications/DBeaver.app/Contents/MacOS//../Eclipse/plugins/org.eclipse.equinox.launcher_1.3.100.v20150511-1540.jar
--launcher.overrideVmargs
-keyring
/Users/wmorin/.eclipse_keyring
-showlocation
-vm
/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/bin/../jre/lib/server/libjvm.dylib
eclipse.home.location=file:/Applications/DBeaver.app/Contents/Eclipse/
eclipse.launcher=/Applications/DBeaver.app/Contents/MacOS/dbeaver
eclipse.launcher.name=Dbeaver
eclipse.p2.data.area=@config.dir/../p2
eclipse.p2.profile=DefaultProfile
eclipse.product=com.jkiss.dbeaver.ent.application.enterprise
eclipse.startTime=1446137050480
eclipse.stateSaveDelayInterval=30000
eclipse.vm=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/bin/../jre/lib/server/libjvm.dylib
eclipse.vmargs=-XstartOnFirstThread
-Dorg.eclipse.swt.internal.carbon.smallFonts
-Djava.class.path=/Applications/DBeaver.app/Contents/MacOS//../Eclipse/plugins/org.eclipse.equinox.launcher_1.3.100.v20150511-1540.jar
equinox.use.ds=true
file.encoding=UTF-8
file.encoding.pkg=sun.io
file.separator=/
ftp.nonProxyHosts=local|*.local|169.254/16|*.169.254/16
gopherProxySet=false
gosh.args=--nointeractive
http.nonProxyHosts=local|*.local|169.254/16|*.169.254/16
java.awt.graphicsenv=sun.awt.CGraphicsEnvironment
java.awt.printerjob=sun.lwawt.macosx.CPrinterJob
java.class.path=/Applications/DBeaver.app/Contents/MacOS//../Eclipse/plugins/org.eclipse.equinox.launcher_1.3.100.v20150511-1540.jar
java.class.version=52.0
java.endorsed.dirs=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/endorsed
java.ext.dirs=/Users/wmorin/Library/Java/Extensions:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/ext:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java
java.home=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre
java.io.tmpdir=/var/folders/39/t54h7vqx63g8_kkvqbj842mc0000gn/T/
java.library.path=/Users/wmorin/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.8.0_45-b14
java.specification.name=Java Platform API Specification
java.specification.vendor=Oracle Corporation
java.specification.version=1.8
java.vendor=Oracle Corporation
java.vendor.url=http://java.oracle.com/
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
java.version=1.8.0_45
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Oracle Corporation
java.vm.specification.version=1.8
java.vm.vendor=Oracle Corporation
java.vm.version=25.45-b02
line.separator=

org.eclipse.equinox.launcher.splash.location=/Applications/DBeaver.app/Contents/Eclipse/configuration/org.eclipse.equinox.launcher/org.jkiss.dbeaver.core.application_3.5.2/splash.bmp
org.eclipse.equinox.simpleconfigurator.configUrl=file:org.eclipse.equinox.simpleconfigurator/bundles.info
org.eclipse.swt.internal.carbon.smallFonts=
org.osgi.framework.executionenvironment=OSGi/Minimum-1.0,OSGi/Minimum-1.1,OSGi/Minimum-1.2,JavaSE/compact1-1.8,JavaSE/compact2-1.8,JavaSE/compact3-1.8,JRE-1.1,J2SE-1.2,J2SE-1.3,J2SE-1.4,J2SE-1.5,JavaSE-1.6,JavaSE-1.7,JavaSE-1.8
org.osgi.framework.language=fr
org.osgi.framework.os.name=MacOSX
org.osgi.framework.os.version=10.11.1
org.osgi.framework.processor=x86-64
org.osgi.framework.system.capabilities=osgi.ee; osgi.ee="OSGi/Minimum"; version:List<Version>="1.0, 1.1, 1.2",osgi.ee; osgi.ee="JRE"; version:List<Version>="1.0, 1.1",osgi.ee; osgi.ee="JavaSE"; version:List<Version>="1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8",osgi.ee; osgi.ee="JavaSE/compact1"; version:List<Version>="1.8",osgi.ee; osgi.ee="JavaSE/compact2"; version:List<Version>="1.8",osgi.ee; osgi.ee="JavaSE/compact3"; version:List<Version>="1.8"
org.osgi.framework.system.packages=javax.accessibility,javax.activation,javax.activity,javax.annotation,javax.annotation.processing,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.jws,javax.jws.soap,javax.lang.model,javax.lang.model.element,javax.lang.model.type,javax.lang.model.util,javax.management,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.script,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.nimbus,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.tools,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.bind,javax.xml.bind.annotation,javax.xml.bind.annotation.adapters,javax.xml.bind.attachment,javax.xml.bind.helpers,javax.xml.bind.util,javax.xml.crypto,javax.xml.crypto.dom,javax.xml.crypto.dsig,javax.xml.crypto.dsig.dom,javax.xml.crypto.dsig.keyinfo,javax.xml.crypto.dsig.spec,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.soap,javax.xml.stream,javax.xml.stream.events,javax.xml.stream.util,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stax,javax.xml.transform.stream,javax.xml.validation,javax.xml.ws,javax.xml.ws.handler,javax.xml.ws.handler.soap,javax.xml.ws.http,javax.xml.ws.soap,javax.xml.ws.spi,javax.xml.ws.spi.http,javax.xml.ws.wsaddressing,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.css,org.w3c.dom.events,org.w3c.dom.html,org.w3c.dom.ls,org.w3c.dom.ranges,org.w3c.dom.stylesheets,org.w3c.dom.traversal,org.w3c.dom.views,org.w3c.dom.xpath,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers
org.osgi.framework.uuid=c084a747-5c7e-0015-1606-8995c41648be
org.osgi.framework.vendor=Eclipse
org.osgi.framework.version=1.8.0
org.osgi.supports.framework.extension=true
org.osgi.supports.framework.fragment=true
org.osgi.supports.framework.requirebundle=true
os.arch=x86_64
os.name=Mac OS X
os.version=10.11.1
osgi.arch=x86_64
osgi.bundles=reference:file:org.eclipse.equinox.simpleconfigurator_1.1.100.v20150423-1455.jar@1:start
osgi.bundles.defaultStartLevel=4
osgi.compatibility.bootdelegation=true
osgi.configuration.area=file:/Applications/DBeaver.app/Contents/Eclipse/configuration/
osgi.framework=file:/Applications/DBeaver.app/Contents/Eclipse/plugins/org.eclipse.osgi_3.10.101.v20150820-1432.jar
osgi.framework.extensions=
osgi.framework.shape=jar
osgi.framework.useSystemProperties=true
osgi.install.area=file:/Applications/DBeaver.app/Contents/Eclipse/
osgi.instance.area=file:/Users/wmorin/.dbeaver/
osgi.logfile=/Users/wmorin/.dbeaver/.metadata/.log
osgi.nl=fr_FR
osgi.os=macosx
osgi.splashLocation=/Applications/DBeaver.app/Contents/Eclipse/configuration/org.eclipse.equinox.launcher/org.jkiss.dbeaver.core.application_3.5.2/splash.bmp
osgi.splashPath=platform:/base/plugins/org.jkiss.dbeaver.core.application
osgi.syspath=/Applications/DBeaver.app/Contents/Eclipse/plugins
osgi.tracefile=/Users/wmorin/.dbeaver/.metadata/trace.log
osgi.ws=cocoa
path.separator=:
socksNonProxyHosts=local|*.local|169.254/16|*.169.254/16
sun.arch.data.model=64
sun.boot.class.path=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/sunrsasign.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/classes
sun.boot.library.path=/Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home/jre/lib
sun.cpu.endian=little
sun.cpu.isalist=
sun.io.unicode.encoding=UnicodeBig
sun.jnu.encoding=UTF-8
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
sun.os.patch.level=unknown
user.country=FR
user.dir=/Applications/DBeaver.app/Contents/MacOS
user.home=/Users/wmorin
user.language=fr
user.name=wmorin
user.timezone=Europe/Paris

*** Features:

*** Plug-in Registry:
com.codahale.metrics.core (3.0.2) "Metrics Core" [Resolved]
com.datastax.driver.core (2.1.7.1) "DataStax Java Driver for Apache Cassandra - Core" [Resolved]
com.datastax.driver.dse (2.1.7.1) "DataStax Java Driver for Apache Cassandra - DataStax Enterprise Module" [Resolved]
com.github.jsqlparser (0.9.3) "com.github.jsqlparser" [Resolved]
com.google.gson (2.2.4.v201311231704) "Google GSON" [Resolved]
com.google.guava (15.0.0.v201403281430) "Guava: Google Core Libraries for Java" [Resolved]
com.ibm.icu.base (54.1.1.v201501272100) "International Components for Unicode for Java (ICU4J) Replacement plug-in" [Active]
com.jcraft.jsch (0.1.53.v201508180515) "JSch" [Resolved]
com.jkiss.dbeaver.ent.application (3.5.2) "DBeaver Enterprise Application" [Starting]
com.jkiss.dbeaver.ent.base (1.0.10) "Base Enterprise classes" [Starting]
com.jkiss.dbeaver.ent.cassandra (1.2.11) "Apache Cassandra CQL Extension" [Starting]
com.jkiss.dbeaver.ent.mongodb (1.3.2) "MongoDB Extension" [Starting]
com.jkiss.dbeaver.ent.qmdb (1.0.6) "QM Persistence Support" [Active]
io.netty.buffer (4.0.27.Final) "Netty/Buffer" [Resolved]
io.netty.codec (4.0.27.Final) "Netty/Codec" [Resolved]
io.netty.common (4.0.27.Final) "Netty/Common" [Resolved]
io.netty.handler (4.0.27.Final) "Netty/Handler" [Resolved]
io.netty.transport (4.0.27.Final) "Netty/Transport" [Resolved]
javax.annotation (1.2.0.v201401042248) "javax.annotation Bundle" [Resolved]
javax.inject (1.0.0.v20091030) "Atinject Dependency Injection Annotations" [Resolved]
javax.xml (1.3.4.v201005080400) "JAXP XML" [Resolved]
org.apache.batik.css (1.7.0.v201011041433) "Apache Batik CSS" [Resolved]
org.apache.batik.util (1.7.0.v201011041433) "Apache Batik Utilities" [Resolved]
org.apache.batik.util.gui (1.7.0.v200903091627) "Apache Batik GUI Utilities" [Resolved]
org.apache.commons.jexl (2.1.1) "Commons JEXL" [Resolved]
org.apache.commons.jxpath (1.3.0.v200911051830) "Apache Commons JXPath" [Resolved]
org.apache.commons.logging (1.1.1.v201101211721) "Apache Commons Logging Plug-in" [Resolved]
org.eclipse.compare.core (3.5.500.v20150505-1058) "Core Compare Support" [Starting]
org.eclipse.core.commands (3.7.0.v20150422-0725) "Commands" [Resolved]
org.eclipse.core.contenttype (3.5.0.v20150421-2214) "Eclipse Content Mechanism" [Active]
org.eclipse.core.databinding (1.5.0.v20150422-0725) "JFace Data Binding" [Starting]
org.eclipse.core.databinding.observable (1.5.0.v20150422-0725) "JFace Data Binding Observables" [Active]
org.eclipse.core.databinding.property (1.5.0.v20150422-0725) "JFace Data Binding Properties" [Starting]
org.eclipse.core.expressions (3.5.0.v20150421-2214) "Expression Language" [Active]
org.eclipse.core.filesystem (1.5.0.v20150725-1910) "Core File Systems" [Active]
org.eclipse.core.filesystem.macosx (1.3.0.v20140124-1940) "Core File System for Macintosh" [Resolved]
org.eclipse.core.jobs (3.7.0.v20150330-2103) "Eclipse Jobs Mechanism" [Active]
org.eclipse.core.resources (3.10.1.v20150725-1910) "Core Resource Management" [Active]
org.eclipse.core.runtime (3.11.1.v20150903-1804) "Core Runtime" [Active]
org.eclipse.core.runtime.compatibility.registry (3.6.0.v20150318-1505) "Eclipse Registry Compatibility Fragment" [Resolved]
org.eclipse.draw2d (3.10.1.201508170204) "Graphical Editing Framework Draw2d" [Starting]
org.eclipse.e4.core.commands (0.11.0.v20150422-0725) "Eclipse e4 core commands" [Active]
org.eclipse.e4.core.contexts (1.4.0.v20150828-0818) "Eclipse Contexts" [Active]
org.eclipse.e4.core.di (1.5.0.v20150421-2214) "Eclipse Dependency Injection" [Active]
org.eclipse.e4.core.di.annotations (1.4.0.v20150528-1451) "Eclipse Dependency Injection Annotations" [Resolved]
org.eclipse.e4.core.di.extensions (0.13.0.v20150421-2214) "Eclipse Dependency Injection Extensions" [Active]
org.eclipse.e4.core.services (2.0.0.v20150403-1912) "Eclipse Application Services" [Active]
org.eclipse.e4.emf.xpath (0.1.100.v20150513-0856) "Eclipse Model Xpath" [Resolved]
org.eclipse.e4.ui.bindings (0.11.0.v20150422-0725) "Eclipse Bindings Support" [Active]
org.eclipse.e4.ui.css.core (0.11.0.v20150511-1937) "Eclipse CSS Core Support" [Resolved]
org.eclipse.e4.ui.css.swt (0.12.0.v20150511-1003) "Eclipse CSS SWT Support" [Active]
org.eclipse.e4.ui.css.swt.theme (0.10.0.v20150422-0725) "Eclipse CSS SWT Theme Support" [Active]
org.eclipse.e4.ui.di (1.1.0.v20150422-0725) "Eclipse UI Dependency Injection" [Active]
org.eclipse.e4.ui.model.workbench (1.1.100.v20150407-1430) "Eclipse Workbench Model" [Active]
org.eclipse.e4.ui.services (1.2.0.v20150422-0725) "Eclipse UI Application Services" [Active]
org.eclipse.e4.ui.widgets (1.1.0.v20150427-1751) "Eclipse UI Custom widgets" [Resolved]
org.eclipse.e4.ui.workbench (1.3.0.v20150531-1948) "Eclipse e4 Workbench" [Active]
org.eclipse.e4.ui.workbench.addons.swt (1.2.0.v20150512-1414) "Eclipse e4 Workbench Add-ons" [Active]
org.eclipse.e4.ui.workbench.renderers.swt (0.13.0.v20150901-1347) "Eclipse e4 Workbench SWT Renderer" [Active]
org.eclipse.e4.ui.workbench.renderers.swt.cocoa (0.11.300.v20150507-1945) "Eclipse UI MacOS X Enhancements" [Resolved]
org.eclipse.e4.ui.workbench.swt (0.13.0.v20150504-0621) "Eclipse e4 Workbench SWT" [Active]
org.eclipse.e4.ui.workbench3 (0.13.0.v20150422-0725) "Bundle for Workbench APIs available in e4" [Resolved]
org.eclipse.emf.common (2.11.0.v20150805-0538) "EMF Common" [Active]
org.eclipse.emf.ecore (2.11.1.v20150805-0538) "EMF Ecore" [Active]
org.eclipse.emf.ecore.change (2.11.0.v20150805-0538) "EMF Change Model" [Starting]
org.eclipse.emf.ecore.xmi (2.11.1.v20150805-0538) "EMF XML/XMI Persistence" [Active]
org.eclipse.equinox.app (1.3.300.v20150423-1356) "Equinox Application Container" [Active]
org.eclipse.equinox.common (3.7.0.v20150402-1709) "Common Eclipse Runtime" [Active]
org.eclipse.equinox.ds (1.4.300.v20150423-1356) "Declarative Services" [Active]
org.eclipse.equinox.event (1.3.100.v20140115-1647) "Event Admin" [Active]
org.eclipse.equinox.launcher (1.3.100.v20150511-1540) "Equinox Launcher" [Resolved]
org.eclipse.equinox.launcher.cocoa.macosx.x86_64 (1.1.300.v20150602-1417) "Equinox Launcher MacOSX Cocoa Fragment" [Resolved]
org.eclipse.equinox.preferences (3.5.300.v20150408-1437) "Eclipse Preferences Mechanism" [Active]
org.eclipse.equinox.registry (3.6.0.v20150318-1503) "Extension Registry Support" [Active]
org.eclipse.equinox.simpleconfigurator (1.1.100.v20150423-1455) "Simple Configurator" [Active]
org.eclipse.equinox.util (1.0.500.v20130404-1337) "Equinox Util Bundle" [Active]
org.eclipse.gef (3.10.1.201508170204) "Graphical Editing Framework GEF" [Starting]
org.eclipse.help (3.6.0.v20130326-1254) "Help System Core" [Active]
org.eclipse.jface (3.11.0.v20150602-1400) "JFace" [Active]
org.eclipse.jface.databinding (1.7.0.v20150406-2148) "JFace Data Binding for SWT and JFace" [Resolved]
org.eclipse.jface.text (3.10.0.v20150603-1752) "JFace Text" [Resolved]
org.eclipse.osgi (3.10.101.v20150820-1432) "OSGi System Bundle" [Active]
org.eclipse.osgi.services (3.5.0.v20150519-2006) "OSGi Release 4.2.0 Services" [Resolved]
org.eclipse.platform (4.5.1.v20150904-0015) "Eclipse Platform" [Resolved]
org.eclipse.swt (3.104.1.v20150825-0743) "Standard Widget Toolkit" [Resolved]
org.eclipse.swt.cocoa.macosx.x86_64 (3.104.1.v20150825-0743) "Standard Widget Toolkit for Mac OS X (Cocoa)" [Resolved]
org.eclipse.text (3.5.400.v20150505-1044) "Text" [Resolved]
org.eclipse.ui (3.107.0.v20150507-1945) "Eclipse UI" [Active]
org.eclipse.ui.forms (3.6.200.v20150506-2029) "Eclipse Forms" [Active]
org.eclipse.ui.intro (3.4.300.v20141007-1449) "Welcome Framework" [Starting]
org.eclipse.ui.themes (1.1.0.v20150511-0913) "Eclipse SDK Themes" [Resolved]
org.eclipse.ui.views (3.8.0.v20150422-0725) "Views" [Active]
org.eclipse.ui.views.log (1.0.600.v20150513-1840) "Log View" [Starting]
org.eclipse.ui.workbench (3.107.0.v20150825-2206) "Eclipse Workbench" [Active]
org.eclipse.ui.workbench.texteditor (3.9.100.v20141023-1946) "Text Editor Framework" [Active]
org.h2 (1.3.168.v201212121212) "H2 Database Engine" [Resolved]
org.jkiss.dbeaver.core (3.5.2) "DBeaver Core Plug-in" [Active]
org.jkiss.dbeaver.core.application (3.5.2) "DBeaver Standalone" [Active]
org.jkiss.dbeaver.ext.db2 (2.1.2) "DB2 Plug-in" [Starting]
org.jkiss.dbeaver.ext.derby (1.1.2) "Apache Derby Plug-in" [Active]
org.jkiss.dbeaver.ext.erd (2.0.19) "ERD Plug-in" [Starting]
org.jkiss.dbeaver.ext.firebird (1.0.18) "FireBird Plug-in" [Active]
org.jkiss.dbeaver.ext.generic (2.3.2) "Generic Plug-in" [Active]
org.jkiss.dbeaver.ext.import_config (2.0.19) "Import Config Plug-in" [Starting]
org.jkiss.dbeaver.ext.informix (1.0.8) "Informix Plug-in" [Active]
org.jkiss.dbeaver.ext.mssql (1.0.11) "MSSQL Plug-in" [Active]
org.jkiss.dbeaver.ext.mysql (2.1.2) "MySQL Plug-in" [Starting]
org.jkiss.dbeaver.ext.oracle (2.1.2) "Oracle Plug-in" [Starting]
org.jkiss.dbeaver.ext.postgresql (1.1.2) "PostgreSQL Plug-in" [Active]
org.jkiss.dbeaver.ext.vertica (1.0.10) "Vertica Plug-in" [Active]
org.jkiss.dbeaver.model (1.0.6) "DBeaver Model Plug-in" [Active]
org.jkiss.utils (2.1.0) "JKISS Utils" [Resolved]
org.mongodb.mongo-java-driver (3.0.3) "mongo-java-driver" [Resolved]
org.objectweb.asm (5.0.1.v201404251740) "ASM" [Resolved]
org.slf4j.api (1.7.2.v20121108-1250) "SLF4J API" [Resolved]
org.w3c.css.sac (1.3.1.v200903091627) "W3C CSS SAC" [Resolved]
org.w3c.dom.events (3.0.0.draft20060413_v201105210656) "W3C DOM Level 3 Events" [Resolved]
org.w3c.dom.smil (1.0.1.v200903091627) "W3C SMIL DOM" [Resolved]
org.w3c.dom.svg (1.1.0.v201011041433) "W3C SVG DOM" [Resolved]

*** User Preferences:
#Thu Oct 29 17:44:49 CET 2015
/bundle_defaults/org.eclipse.ui/ENABLE_DETACHED_VIEWS=true
/bundle_defaults/org.jkiss.dbeaver.core/enable.auto.activation=true
/bundle_defaults/org.eclipse.ui.workbench/MULTI_KEY_ASSIST_TIME=1000
/bundle_defaults/org.eclipse.ui.workbench/EDITORLIST_SORT_CRITERIA=0
/bundle_defaults/org.jkiss.dbeaver.core/resultset.behavior.doubleClick=INLINE_EDITOR
/bundle_defaults/org.eclipse.ui.workbench/shouldPromptForEnablement=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_qmdb=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_teradata=true
/instance/org.eclipse.ui.views.log/activate=true
/bundle_defaults/org.eclipse.core.resources/description.buildorder=
@org.eclipse.e4.ui.css.swt.theme=0.10.0.v20150422-0725
/bundle_defaults/org.jkiss.dbeaver.core/resultset.edit.key.use_all_columns=false
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_postgresql=true
/instance/org.jkiss.dbeaver.ext.erd/Palette\ Size=253
/bundle_defaults/org.eclipse.ui/PROMPT_WHEN_SAVEABLE_STILL_OPEN=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_mysql=true
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.closeBrackets=true
/bundle_defaults/org.eclipse.ui/RECENTLY_USED_WORKINGSETS_SIZE=5
/bundle_defaults/org.jkiss.dbeaver.core/resultset.edit.longaslob=true
/bundle_defaults/org.eclipse.ui.workbench/LAYOUT_DIRECTION=0
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_oracle=true
/bundle_defaults/org.eclipse.ui.workbench/HeapStatus.showMax=false
/instance/org.jkiss.dbeaver.core/resultset.presentation.active=spreadsheet
/instance/org.jkiss.dbeaver.core/search.data.sample-rows=10
/bundle_defaults/org.eclipse.ui.workbench/TEXT_DIRECTION=
/bundle_defaults/org.eclipse.ui/ENABLE_MIN_MAX=true
/bundle_defaults/org.eclipse.core.resources/description.autobuilding=true
/bundle_defaults/org.eclipse.ui/KEY_CONFIGURATION_ID=org.eclipse.ui.defaultAcceleratorConfiguration
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.minIntegerDigits=1
/bundle_defaults/org.jkiss.dbeaver.core/script.auto.folders=false
/bundle_defaults/org.jkiss.dbeaver.core/resultset.text.max.column.size=255
/bundle_defaults/org.jkiss.dbeaver.core/qm.maxEntries=200
/bundle_defaults/org.eclipse.ui/VIEW_TAB_POSITION=128
/bundle_defaults/org.jkiss.dbeaver.core/qm.queryTypes=USER,USER_SCRIPT
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.time.pattern=HH\:mm\:ss
/instance/org.eclipse.ui.workbench/ColorsAndFontsPreferencePage.expandedCategories=Torg.eclipse.ui.workbenchMisc\tTorg.jkiss.dbeaver.ui.presentation.sql
/bundle_defaults/org.jkiss.dbeaver.core/ui.proxy.password=
/bundle_defaults/org.eclipse.core.resources/description.filestatelongevity=604800000
/bundle_defaults/org.eclipse.ui.workbench/USE_IPERSISTABLE_EDITORS=true
/bundle_defaults/org.eclipse.ui/USE_WINDOW_WORKING_SET_BY_DEFAULT=false
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_derby=true
/bundle_defaults/org.jkiss.dbeaver.core/database.editor.separate.connection=false
/bundle_defaults/org.eclipse.ui/ENABLE_32_STICKY_CLOSE_BEHAVIOR=false
/instance/org.jkiss.dbeaver.core/project.active=General
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_exasol=true
/bundle_defaults/org.eclipse.ui/USE_COLORED_LABELS=true
/bundle_defaults/org.jkiss.dbeaver.core/qm.storeLogs=false
/bundle_defaults/org.eclipse.ui.workbench/EDITOR_TAB_WIDTH=3
/instance/org.jkiss.dbeaver.core/search.metadata.object-source=vertica-1400055145437-1266956981
/bundle_defaults/org.jkiss.dbeaver.core/text.edit.undo.level=200
/instance/org.jkiss.dbeaver.core/search.metadata.mask=geo
/bundle_defaults/org.eclipse.ui/disableNewFastView=false
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.maxFractionDigits=3
/bundle_defaults/org.jkiss.dbeaver.core/resultset.show.cellIcons=true
\!/=
/instance/org.jkiss.dbeaver.core/viewPanelRatio=750
/bundle_defaults/org.eclipse.ui/SHOW_OTHER_IN_PERSPECTIVE_MENU=true
/bundle_defaults/org.jkiss.dbeaver.core/resultset.binary.editor=EDITOR
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_nuodb=true
/bundle_defaults/org.eclipse.ui.workbench/REUSE_OPEN_EDITORS_BOOLEAN=false
/bundle_defaults/org.eclipse.ui.workbench/coolBarVisible=true
/bundle_defaults/org.jkiss.dbeaver.core/resultset.autofetch.next.segment=true
@org.eclipse.ui.workbench=3.107.0.v20150825-2206
/bundle_defaults/org.jkiss.dbeaver.core/resultset.order.serverSide=true
/instance/org.jkiss.dbeaver.core/search.dialog.cur-provider=database_metadata
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.minFractionDigits=0
/bundle_defaults/org.eclipse.ui/ENABLE_ANIMATIONS=false
/bundle_defaults/org.jkiss.dbeaver.core/script.error.handling=STOP_ROLLBACK
/instance/org.jkiss.dbeaver.core/resultset.maxrows=100
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_mysql3=true
/bundle_defaults/org.jkiss.dbeaver.core/proposals.short.name=false
/bundle_defaults/org.eclipse.ui.workbench/OPEN_AFTER_DELAY=false
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_h2_server=true
/instance/org.jkiss.dbeaver.core/export.scripts.out.dir=/Users/wmorin
/bundle_defaults/org.eclipse.core.resources/description.maxbuilditerations=10
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_informix=true
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.closeDoubleQuotes=true
/bundle_defaults/org.eclipse.core.resources/description.applyfilestatepolicy=true
/bundle_defaults/org.eclipse.ui.workbench/perspectiveBarVisible=true
/bundle_defaults/org.jkiss.dbeaver.core/qm.historyDays=90
/instance/org.jkiss.dbeaver.core/search.metadata.history.0=geo
/bundle_defaults/org.eclipse.ui/LINK_NAVIGATOR_TO_EDITOR=false
/instance/org.eclipse.ui.views.log/orderType=2
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_linter=true
/bundle_defaults/org.jkiss.dbeaver.core/agent.long.operation.notify=false
/bundle_defaults/org.jkiss.dbeaver.core/statement.timeout=10000
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_msaccess_ucanaccess=true
/bundle_defaults/org.eclipse.ui.workbench/SELECT_ON_HOVER=false
/bundle_defaults/org.jkiss.dbeaver.core/navigator.group.by.driver=false
/bundle_defaults/org.jkiss.dbeaver.core/textDragAndDropEnabled=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_oracle_oracle_thin=true
@org.jkiss.dbeaver.core=3.5.2
/instance/org.eclipse.e4.ui.css.swt.theme/themeid=org.eclipse.e4.ui.css.theme.e4_classic
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_db2_db2=true
/bundle_defaults/org.jkiss.dbeaver.core/script.commit.lines=1000
/bundle_defaults/org.jkiss.dbeaver.core/ui.drivers.sources=http\://dbeaver.jkiss.org/files/jdbc/
/bundle_defaults/org.eclipse.ui/showIntro=true
/bundle_defaults/org.jkiss.dbeaver.core/qm.objectTypes=txn,query
/bundle_defaults/org.eclipse.ui/SHOW_TEXT_ON_PERSPECTIVE_BAR=true
/bundle_defaults/org.eclipse.core.resources/snapshots.operations=100
/bundle_defaults/org.jkiss.dbeaver.core/navigator.sort.case.insensitive=false
/bundle_defaults/org.eclipse.core.resources/description.disableLinking=false
/bundle_defaults/org.eclipse.ui.workbench/ENABLED_DECORATORS=
/bundle_defaults/org.eclipse.core.resources/description.maxfilestates=50
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_mongodb=true
/instance/org.eclipse.ui.workbench/org.eclipse.ui.commands=<?xml version\="1.0" encoding\="UTF-8"?>\n<org.eclipse.ui.commands/>
/bundle_defaults/org.jkiss.dbeaver.core/resultset.behavior.autoSwitchMode=false
/bundle_defaults/org.eclipse.core.resources/description.snapshotinterval=300000
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_csvjdbc=true
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.currentLineColor=230,230,230
/bundle_defaults/org.eclipse.ui.workbench/DISABLE_OPEN_EDITOR_IN_PLACE=false
/instance/org.jkiss.dbeaver.core/driver.license.accept.postgresql=true\:1429875433369\:wmorin
@org.eclipse.ui.workbench.texteditor=3.9.100.v20141023-1946
/instance/org.jkiss.dbeaver.core/org.jkiss.dbeaver.core.confirm.disconnect_txn=never
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.closeBeginEndStatement=true
/instance/org.jkiss.dbeaver.core/search.metadata.max-results=100
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.resetCursorOnExecute=false
/instance/org.jkiss.dbeaver.ext.erd/erd.attr.visibility=ALL
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_sybase=true
/instance/org.eclipse.ui.views.log/groupBy=0
/bundle_defaults/org.eclipse.ui/SHOW_OPEN_ON_PERSPECTIVE_BAR=true
/instance/org.eclipse.ui.views.log/maxLogTailSize=1
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_sqlite_jdbc=true
/bundle_defaults/org.eclipse.ui/SHOW_FILTERED_TEXTS=true
/instance/org.jkiss.dbeaver.core/search.metadata.object-type=org.jkiss.dbeaver.model.struct.rdb.DBSTable
/bundle_defaults/org.jkiss.dbeaver.core/hex.font.size=10
/bundle_defaults/org.eclipse.ui/SHOW_SYSTEM_JOBS=false
file_export_version=3.0
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.matchingBracketsColor=128,128,128
/bundle_defaults/org.eclipse.ui.workbench/EDITORLIST_SELECTION_SCOPE=1
/bundle_defaults/org.eclipse.ui.workbench/KEYS_PREFERENCE_SELECTED_TAB=0
/bundle_defaults/org.jkiss.dbeaver.core/qm.logDirectory=/Users/wmorin/.dbeaver/.metadata
/bundle_defaults/org.eclipse.core.resources/refresh.enabled=false
/bundle_defaults/org.eclipse.ui.workbench/COLOR_ICONS=true
/bundle_defaults/org.jkiss.dbeaver.core/hex.font.name=Courier New
/bundle_defaults/org.jkiss.dbeaver.core/agent.long.operation.timeout=30
/bundle_defaults/org.jkiss.dbeaver.core/script.fetch.resultset=false
/bundle_defaults/org.jkiss.dbeaver.core/navigator.editor.full-name=false
/bundle_defaults/org.eclipse.ui/SHOW_MULTIPLE_EDITOR_TABS=true
/bundle_defaults/org.jkiss.dbeaver.core/resultset.commit.oneditapply=false
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_gemfire_xd=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_sap_maxdb=true
/bundle_defaults/org.eclipse.ui/SHIFT_OPEN_NEW_PERSPECTIVE=OPEN_PERSPECTIVE_REPLACE
/bundle_defaults/org.jkiss.dbeaver.core/ui.editors.reopen-after-restart=true
/bundle_defaults/org.jkiss.dbeaver.core/resultset.commit.oncontentapply=false
/bundle_defaults/org.jkiss.dbeaver.core/proposal.insert.case=0
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_mysql_mysql5=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_ingres=true
/instance/org.jkiss.dbeaver.core/ui.auto.update.check.time=1441014883632
/instance/org.jkiss.dbeaver.core/dataformat.profile.language=fr
/instance/org.jkiss.dbeaver.ext.erd/erd.grid.enabled=false
/bundle_defaults/org.eclipse.ui.workbench/HeapStatus.updateInterval=500
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.printMargin=false
/bundle_defaults/org.eclipse.core.resources/refresh.lightweight.enabled=false
/instance/org.eclipse.ui.views.log/show_filter_text=true
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.printMarginColumn=120
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.printMarginColor=230,230,230
/bundle_defaults/org.eclipse.ui.workbench/SINGLE_CLICK_METHOD=0
/bundle_defaults/org.jkiss.dbeaver.core/hide.duplicate.proposals=false
/bundle_defaults/org.eclipse.ui.workbench/REUSE_OPEN_EDITORS=8
/bundle_defaults/org.eclipse.ui.workbench/OPEN_PERSPECTIVE_MODE=0
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.roundingMode=HALF_EVEN
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_hsqldb_server=true
/bundle_defaults/org.jkiss.dbeaver.core/script.title.pattern=<${connectionName}> ${fileName}
/bundle_defaults/org.eclipse.ui.workbench/EDITORLIST_DISPLAY_FULL_NAME=false
/instance/org.eclipse.core.resources/version=1
/bundle_defaults/org.eclipse.ui.workbench/SHOW_MEMORY_MONITOR=false
/bundle_defaults/org.eclipse.ui.workbench/EDITORLIST_PULLDOWN_ACTIVE=false
/bundle_defaults/org.eclipse.core.resources/description.defaultbuildorder=true
/instance/org.jkiss.dbeaver.core/auto.activation.delay=0
/instance/org.jkiss.dbeaver.ext.erd/Palette\ state=4
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditor.templates.templatesPage.nameWidth=180
/bundle_defaults/org.jkiss.dbeaver.core/ui.proxy.port=1080
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.maxIntegerDigits=2147483647
/bundle_defaults/org.jkiss.dbeaver.core/resultset.edit.maxtextsize=10000000
@org.eclipse.core.resources=3.10.1.v20150725-1910
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_db2_luw_old=true
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.closeSingleQuotes=true
/bundle_defaults/org.jkiss.dbeaver.core/ui.auto.update.check=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditor.templates.templatesPage.descriptionWidth=270
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.matchingBrackets=true
/bundle_defaults/org.jkiss.dbeaver.core/script.commit.type=NO_COMMIT
/bundle_defaults/org.eclipse.ui/EDITOR_MINIMUM_CHARACTERS=-1
/bundle_defaults/org.eclipse.ui.workbench/REUSE_DIRTY_EDITORS=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_cache=true
/bundle_defaults/org.eclipse.ui/EDITOR_TAB_POSITION=128
/bundle_defaults/org.eclipse.ui.workbench/STICKY_CYCLE=false
/bundle_defaults/org.eclipse.ui.workbench/OPEN_ON_SINGLE_CLICK=false
/bundle_defaults/org.eclipse.ui.workbench/overridepresentation=false
/bundle_defaults/org.jkiss.dbeaver.core/database.props.expensive=false
/bundle_defaults/org.eclipse.ui/CLOSE_EDITORS_ON_EXIT=false
/bundle_defaults/org.eclipse.core.resources/description.maxfilestatesize=1048576
/bundle_defaults/org.jkiss.dbeaver.core/navigator.expand.on.connect=false
/bundle_defaults/org.eclipse.ui.workbench/DISABLE_DIALOG_FONT=false
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.closeComments=true
/bundle_defaults/org.eclipse.ui.workbench/ENABLE_COOL_BARS=true
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.number.useGrouping=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_mimer=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_cassandra=true
/bundle_defaults/org.eclipse.ui.workbench/ENABLE_CONFIGURABLE_PROJECT_WIZARD=false
/bundle_defaults/org.eclipse.ui/SHOW_TRADITIONAL_STYLE_TABS=true
/bundle_defaults/org.eclipse.ui/DOCK_PERSPECTIVE_BAR=topLeft
@org.eclipse.ui.views.log=1.0.600.v20150513-1840
/bundle_defaults/org.jkiss.dbeaver.core/insert.single.proposals.auto=true
/instance/org.jkiss.dbeaver.core/org.jkiss.dbeaver.core.confirm.order_resultset=always
/instance/org.eclipse.ui.workbench/ColorsAndFontsPreferencePage.selectedElement=Corg.jkiss.dbeaver.sql.editor.color.keyword.foreground
/bundle_defaults/org.jkiss.dbeaver.core/ui.proxy.user=
/bundle_defaults/org.jkiss.dbeaver.core/agent.enabled=true
/bundle_defaults/org.eclipse.ui.workbench/NL_EXTENSIONS=
/instance/org.eclipse.ui.views.log/column4=150
/instance/org.eclipse.ui.views.log/column3=150
/instance/org.eclipse.ui.views.log/column2=465
/bundle_defaults/org.eclipse.ui/PROJECT_OPEN_NEW_PERSPECTIVE=OPEN_PERSPECTIVE_REPLACE
/bundle_defaults/org.eclipse.ui/VIEW_MINIMUM_CHARACTERS=1
/bundle_defaults/org.eclipse.ui/initialFastViewBarLocation=bottom
/bundle_defaults/org.eclipse.core.resources/encoding=
/bundle_defaults/org.jkiss.dbeaver.core/resultset.show.oddRows=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_firebird_jaybird=true
/bundle_defaults/org.jkiss.dbeaver.core/auto.activation.delay=500
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.date.pattern=yyyy-MM-dd
/bundle_defaults/org.jkiss.dbeaver.core/resultset.maxrows=200
/bundle_defaults/org.jkiss.dbeaver.core/SQLEditor.currentLine=false
/instance/org.jkiss.dbeaver.core/agent.long.operation.timeout=10
/instance/org.jkiss.dbeaver.core/rulerContributions=org.jkiss.dbeaver.ui.editors.columns.linenumbers
/bundle_defaults/org.eclipse.ui/ALTERNATE_OPEN_NEW_PERSPECTIVE=OPEN_PERSPECTIVE_REPLACE
/bundle_defaults/org.jkiss.dbeaver.core/navigator.connection.doubleClick=SQL_EDITOR
/bundle_defaults/org.eclipse.ui/OPEN_NEW_PERSPECTIVE=OPEN_PERSPECTIVE_REPLACE
/bundle_defaults/org.jkiss.dbeaver.core/ui.proxy.host=
/bundle_defaults/org.eclipse.ui.workbench/RECENT_FILES=4
/bundle_defaults/org.jkiss.dbeaver.core/statement.invalidate.before.execute=false
/bundle_defaults/org.jkiss.dbeaver.core/keep.statement.open=false
/instance/org.jkiss.dbeaver.core/dataformat.profile.country=FR
/instance/org.eclipse.ui.views.log/orderValue=-1
/bundle_defaults/org.eclipse.ui.workbench/WORKBENCH_SAVE_INTERVAL=5
/bundle_defaults/org.jkiss.dbeaver.core/ui.drivers.home=
@org.jkiss.dbeaver.ext.erd=2.0.19
/bundle_defaults/org.eclipse.ui.workbench/ENABLE_NEW_MENUS=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_mssql=true
/bundle_defaults/org.eclipse.ui.workbench/MULTI_KEY_ASSIST=true
/instance/org.jkiss.dbeaver.core/search-view.max-results=100
/bundle_defaults/org.eclipse.core.resources/delta.expiration=2592000000
/bundle_defaults/org.jkiss.dbeaver.core/dataformat.type.timestamp.pattern=yyyy-MM-dd HH\:mm\:ss
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_generic_netezza=true
/instance/org.eclipse.ui.workbench.texteditor/org.eclipse.ui.workbench.texteditortemplates.templatesPage.context.expand.sql_mysql_mariaDB=true
/bundle_defaults/org.eclipse.ui.workbench/BIDI_SUPPORT=false

[serge-rider]

Can't reproduce that (I don't have a Vertica instance for testing) but most likely it is Vertica driver-specific issue.
Does cancel not happen only for some particular long-running queries or for any query?
You can test it by running query like "SELECT SLEEP(10);"

[wmorin]

Hi Serge,

I just try and it fail in the same way using "SELECT SLEEP(100)". I launch the query and click cancel, then it wait 100 second and the query result appear. It seems that it's not cancelling the request.

Maybe you can try to reproduce it using a docker Vertica instance :

docker run -d -p 5433:5433 sumitchawla/vertica

Then you can connect on port 5433 using:

host: <your docker ip>
port 5433:
username: dbadmin
password: dbadmin

[serge-rider]

Thank for idea, I'll try it.
However I suspect that Vertica driver just doesn't support query canceling.. Anyway I'll try to find some workaround.

[wmorin]

It seems to be the same issue as reported in http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=1783&p=4586&hilit=vertica#p4586

[serge-rider]

Still no luck with docker..

Anyhow - if this issue still bothers you - could you post a process thread dump when DBeaver hangs and cancel doesn't work?
To get the thread dump:

• Find DBeaver process id (ps auxf | grep dbeaver)
• Execute jstack <dbeaver-pid> > thread-dump.txt
• Post file thread-dump.txt here

Thanks in advance

[wmorin]

Hi Serge,

Happy to ear that you are on it. Find attached the dump after I hit cancel button.
Thank you fo your time. Let me know if I can help doing anything else.
thread-dump.txt

[wmorin]

Hi Serge,
Was the thread dump useful? Let me know if I can be of any help.
And by way, thank you so much for the grid control redesign! It's gorgeous!

[serge-rider]

Hey.
Yes, dump was useful, thank you.
Vertica driver doesn't support statement cancellation.
Now I'm thinking about possible workarounds (e.g. connection close or thread interrupt). But I still don't have test environment with Vertica so this issue was postponed for a while.

[wmorin]

Thank you Serge,
On my side, I try to contact HP Vertica support regarding this issue.

[serge-rider]

I'll close this issue as there is nothing I can do for now..