Bug 25248

Summary: mysql-workbench crashed after selecting "Database→Connect to database→OK"
Product: Mageia Reporter: Jybz <j.biernacki+mga>
Component: RPM PackagesAssignee: All Packagers <pkg-bugs>
Status: RESOLVED OLD QA Contact:
Severity: major    
Priority: Normal CC: jani.valimaa
Version: 7   
Target Milestone: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Source RPM: mysql-workbench CVE:
Status comment:

Description Jybz 2019-08-09 14:47:53 CEST 
Hi all !

mysql-workbench crash.

First I couldn't connect to localhost using socket, I found the bug report 25071
https://bugs.mageia.org/show_bug.cgi?id=25071
with the rpm in update_testing to solve it, it seemed to work, but the schemas area shows none table. When clicking to select a connection to database, it crashed (segfault).

Database → Connect to database → *selecting the default Local Instance 3306* → OK ↓
segfault.

See under a more detailed logs :



# rpm -Uvh ftp://ftp.belnet.be/mirror/mageia/distrib/7/x86_64/media/core/updates_testing/lib64mysqlcppconn7-1.1.9-2.1.mga7.x86_64.rpm
Récupération de ftp://ftp.belnet.be/mirror/mageia/distrib/7/x86_64/media/core/updates_testing/lib64mysqlcppconn7-1.1.9-2.1.mga7.x86_64.rpm
Verifying...                          ################################# [100%]
Préparation...                       ################################# [100%]
Mise à jour / installation...
   1:lib64mysqlcppconn7-1.1.9-2.1.mga7################################# [ 50%]
Nettoyage/suppression...
   2:lib64mysqlcppconn7-1.1.9-2.mga7  ################################# [100%]



$ mysql-workbench --log-level=debug3 --log-to-stderr -v

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:68:35: The style property GtkButton:child-displacement-x is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:69:35: The style property GtkButton:child-displacement-y is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:70:34: The style property GtkCheckButton:indicator-size is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:71:36: The style property GtkCheckMenuItem:indicator-size is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:73:46: The style property GtkScrolledWindow:scrollbars-within-bevel is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.284: Theme parsing error: gtk.css:76:30: The style property GtkExpander:expander-size is deprecated and shouldn't be used anymore. It will be removed in a future version

(mysql-workbench-bin:24502): Gtk-WARNING **: 14:31:32.285: Theme parsing error: gtk.css:83:29: The style property GtkStatusbar:shadow-type is deprecated and shouldn't be used anymore. It will be removed in a future version
Logger set to level 'debug3'. '1111111'
14:31:32 [INF][      WBContext]: Logger set to level 'debug3'
14:31:32 [DB2][ mforms backend]: Initializing mforms factory
14:31:32 [DB1][      WBContext]: Creating WBContext
14:31:32 [INF][   WBContext UI]: Initializing workbench context UI with these values:
        base dir: /usr/share/mysql-workbench
        plugin path: /usr/lib64/mysql-workbench/plugins
        struct path: /usr/share/mysql-workbench/grt
        module path: /usr/lib64/mysql-workbench/modules
        library path: /usr/share/mysql-workbench/libraries
        user data dir: /home/jybz/.mysql/workbench
        open at start: 
        open type: 
        run at startup: 
        run type: 
        Force SW rendering: No
        Force OpenGL: No
        quit when done: No
14:31:32 [INF][      WBContext]: WbContext::init
14:31:32 [DB1][  GRTDispatcher]: starting worker thread
14:31:32 [DB1][  GRTDispatcher]: worker thread running
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb_admin_grt.py' (python)
14:31:32 [INF][            WBA]: Looking for extension modules for WBA...
14:31:32 [INF][            WBA]: 0 extension modules found
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_copy_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb_utils_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sql92_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db.mysql.sqlparser.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sybase_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sqlite_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/sqlide_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_generic_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sql92_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_mssql_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_mysql_fe_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_postgresql_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/utilities.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_generic_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb_docs_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db.mysql.query.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_mysql_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db.mysql.parser.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sqlanywhere_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/text_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_mssql_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db.mysql.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sqlite_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/table_utils_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/code_utils_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sybase_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb_query_analysis_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_sqlanywhere_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_mysql_migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/migration_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb_dev_utils_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/db_postgresql_re_grt.py' (python)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/modules/wb.model.grt.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/wb.model.editors.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/db.search.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/db.mysql.editors.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/db.mysql.diff.reporting.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/db.mysql.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/wb.model.snippets.wbp.so' (cpp)
14:31:32 [DB2][            grt]: Trying to load module '<base dir>/../../lib64/mysql-workbench/plugins/wb.printing.wbp.so' (cpp)
14:31:32 [DB1][      WBContext]: Initializing rdbms modules
14:31:32 [DB1][      WBContext]: Cleaning up old options
14:31:32 [WRN][            grt]: /home/jybz/.mysql/workbench/connections.xml:27: link '72e70888-baa1-11e9-b054-3402862076e1' <object GrtObject> key=owner could not be resolved
14:31:32 [DB1][component_physical]: Loaded connection list, 1 connections found.
14:31:32 [DB3][       WBModule]: Environment variables:
 GS_LIB=/home/jybz/.fonts
QTINC=/usr/lib/qt3/include
KDE_FULL_SESSION=true
LD_LIBRARY_PATH=/usr/lib64/mysql-workbench:
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.zst=01;31:*.tzst=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.iso=01;31:*.wim=01;31:*.swm=01;31:*.dwm=01;31:*.esd=01;31:*.jpg=01;35:*.jpeg=01;35:*.JPG=01;35:*.JPEG=01;35:*.mjpg=01;35:*.mjpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.ico=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.divx=01;35:*.xvid=01;35:*.3gp=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.gem=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m4a=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.oga=00;36:*.opus=00;36:*.spx=00;36:*.xspf=00;36:*.mp2=00;36:*.mod=00;36:*.xm=00;36:*.s3m=00;36:*.it=00;36:*.wma=00;36:*~=47;30:*.bak=47;30:*.swp=47;30:*.bck=47;30:*.bk=47;30:*.old=47;30:*.tmp=47;30:*.save=47;30:*.rpmsave=47;30:*.rpmnew=47;30:
MWB_BINARIES_DIR=/usr/bin
XDG_MENU_PREFIX=plasma-
QTDIR5=/usr/lib64/qt5
LANG=fr_FR.UTF-8
HISTCONTROL=ignoredups
DISPLAY=:0
PROFILEHOME=
HOSTNAME=localhost.localdomain
QTDIR=/usr/lib64/qt4
SHELL_SESSION_ID=bb44f087366d4247ab609353a725dd53
MWB_DATA_DIR=/usr/share/mysql-workbench
COLORTERM=truecolor
LC_SOURCED=1
XDG_VTNR=1
XDG_SESSION_ID=1
USER=jybz
DESKTOP_SESSION=/usr/share/xsessions/01plasma
MWB_PLUGIN_DIR=/usr/lib64/mysql-workbench/plugins
KONSOLE_VERSION=190400
MWB_MODULE_DIR=/usr/lib64/mysql-workbench/modules
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:/home/jybz/.gtkrc-2.0:/home/jybz/.config/gtkrc-2.0
QT4DOCDIR=/usr/share/doc/qt4
SCREENDIR=/home/jybz/tmp
INPUTRC=/etc/inputrc
PWD=/home/jybz/outils/LimeSuite/builddir/bin
SSH_ASKPASS=/usr/libexec/openssh/ssh-askpass
HOME=/home/jybz
TMP=/tmp
MWB_LIBRARY_DIR=/usr/share/mysql-workbench/libraries
BROWSER=/usr/bin/www-browser
XDG_SESSION_TYPE=x11
XDG_DATA_DIRS=/var/lib/plasma5-profiles/common/share:/usr/local/share:/usr/share
MGA_MENU_STYLE=mageia
NLSPATH=/usr/share/locale/%l/%N
KONSOLE_DBUS_SESSION=/Sessions/3
XDG_SESSION_DESKTOP=KDE
CANBERRA_DRIVER=pulse
TMPDIR=/tmp
SYSTEMD_PAGER=/usr/bin/less -FR
LADSPA_PATH=/usr/lib64/ladspa/
GTK_MODULES=canberra-gtk-module
MAIL=/var/spool/mail/jybz
QTLIB=/usr/lib64
QT_PLUGIN_PATH=/usr/lib64/qt5/plugins:/usr/lib64/qt5/plugins/kcms:
SHELL=/bin/bash
TERM=xterm-256color
QT5DOCDIR=/usr/share/doc/qt5
KONSOLE_DBUS_SERVICE=:1.36
XDG_SESSION_CLASS=user
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XMODIFIERS=@im=none
XCURSOR_THEME=breeze_cursors
SECSHELL=1
XDG_CURRENT_DESKTOP=KDE
KONSOLE_PROFILE_NAME=Par défaut
PYTHONSTARTUP=/etc/pythonrc.py
COLORFGBG=15;0
SHLVL=4
XDG_SEAT=seat0
LANGUAGE=fr_FR.UTF-8:fr
DBC_DRIVER_PATH=/usr/lib64/mysql-workbench
G_FILENAME_ENCODING=@locale
GTK_RC_FILES=/etc/gtk/gtkrc:/home/jybz/.gtkrc:/home/jybz/.config/gtkrc
WINDOWID=56623111
LESSCHARSET=koi8-r
LOGNAME=jybz
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
XDG_RUNTIME_DIR=/run/user/1000
XAUTHORITY=/tmp/xauth-1000-_0
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
QT_AUTO_SCREEN_SCALE_FACTOR=0
XDG_CONFIG_DIRS=/etc/xdg:/etc/xdg/kf5:/var/lib/plasma5-profiles/common/xdg
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:/usr/lib64/qt5/bin:/usr/lib64/qt4/bin:/home/jybz/workspaces/MesScripts:/home/jybz/workspaces/MesBins:/home/jybz/.local/bin:/home/jybz/bin:/home/jybz/workspaces/MesScripts:/home/jybz/workspaces/MesBins
KDE_SESSION_UID=1000
KDE_SESSION_VERSION=5
GCONF_TMPDIR=/tmp
META_CLASS=download
HISTSIZE=1000
QT_XFT=0
SESSION_MANAGER=local/localhost.localdomain:@/tmp/.ICE-unix/5385,unix/localhost.localdomain:/tmp/.ICE-unix/5385
LESSOPEN=|/usr/bin/lesspipe.sh %s
_=/usr/bin/mysql-workbench-bin

14:31:32 [INF][      WBContext]: System info:
        MySQL Workbench Community (GPL) for Linux/Unix version 6.3.10 CE build 12092614 (64 bit)
        Configuration Directory: /home/jybz/.mysql/workbench
        Data Directory: /usr/share/mysql-workbench
        Cairo Version: 1.16.0
        OS: Mageia release 7 (Official) for x86_64 x86_64
        CPU: 4x Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz (2392.621MHz) - 7,69GiB RAM
No video adapter info available
        Distribution: Mageia 7

        Fips mode enabled: no

Ready.

14:31:32 [INF][    WQE backend]: Found auto-save workspace /home/jybz/.mysql/workbench/sql_workspaces/Local_instance_3306-1.autosave
14:31:32 [DB1][      WBContext]: Saved connection list (MySQL: 1)
14:31:32 [DB1][      WBContext]: Calling SQLIDEUtils.initialize0()...
14:31:32 [DB1][      WBContext]: Calling WbAdmin.initialize()...
14:31:36 [DB1][      WBContext]: No connection specified, showing connection selection dialog...
14:31:38 [DB3][SQL Editor Form]: Creating KeepAliveInterval timer...
14:31:38 [DB1][ mforms backend]: Looking up password for 'root'@'Mysql@localhost:3306' has failed
14:31:38 [DB3][    WQE backend]: Connecting SQL editor...
14:31:38 [DB3][       GRT task]: Sending task "execute sql queries" to dispatcher (wait)...
14:31:38 [DB1][  GRTDispatcher]: starting worker thread
14:31:38 [DB1][  GRTDispatcher]: worker thread running
14:31:38 [DB3][  GRTDispatcher]: Running task "execute sql queries"
14:31:38 [DB2][SQL Editor Form]: Notifying server state change of Mysql@localhost:3306 to running
14:31:38 [INF][SQL Editor Form]: Opened connection 'Local instance 3306' to Mageia MariaDB Server version 10.3.16-MariaDB
14:31:38 [DB3][    WQE backend]: Connection to SQL editor succeeded
14:31:38 [DB3][  GRTDispatcher]: Task "execute sql queries" finished
14:31:38 [DB3][       GRT task]: Sending task "Live Schema Refresh Task" to dispatcher (don't wait)...
14:31:38 [DB1][  GRTDispatcher]: starting worker thread
14:31:38 [DB1][  GRTDispatcher]: worker thread running
14:31:38 [DB3][  GRTDispatcher]: Running task "Live Schema Refresh Task"
14:31:38 [DB3][MySQL Name Cache]: Creating worker thread
14:31:38 [DB2][MySQL Name Cache]: Entering worker thread
14:31:38 [DB2][  column_widths]: Using column width cache file /home/jybz/.mysql/workbench/cache/Local_instance_3306.column_widths
14:31:38 [DB3][MySQL Name Cache]: Updating schema listLeaving worker thread
14:31:38 [DB1][      WBContext]: Saved connection list (MySQL: 1)
14:31:38 [ERR][      WBContext]: Unsupported server version: Mageia MariaDB Server 10.3.16-MariaDB
/usr/bin/mysql-workbench : ligne 9 : 24502 Erreur de segmentation  (core dumped)/usr/bin/mysql-workbench-bin $*



As we see "[ERR][      WBContext]: Unsupported server version: Mageia MariaDB Server 10.3.16-MariaDB"
I guess it is related to bug :
https://bugs.mageia.org/show_bug.cgi?id=17192
David Walser 2019-08-11 17:55:36 CEST

CC: (none) => jani.valimaa
Assignee: bugsquad => pkg-bugs

Comment 1 Aurelien Oudelet 2021-07-06 13:14:22 CEST 
Mageia 7 is EOL since July 1st 2021.
There will not have any further bugfix for this release.

You are encouraged to upgrade to Mageia 8 as soon as possible.

@reporter, if this bug still apply with Mageia 8, please let us know it.

@packager, if you work on the Mageia 7 version of your package, please check the Mageia 8 package if issue is also present. In this case, please fix the Mageia 8 version instead.

This bug report will be closed OLD if there is no further notice within 1st September 2021.
Comment 2 Marja Van Waes 2021-09-07 14:10:29 CEST 
Hi bug reporter and hi assignee and others involved,

Please reopen this bug report if it is still valid for Mageia 8 or 9(cauldron), and change "Version:" in the upper left of this report accordingly.

This report is being closed as OLD because it was filed against Mageia 7, for which  support ended on June 30th 2021.

Thanks,
Marja

Resolution: (none) => OLD
Status: NEW => RESOLVED