[Gambas-bugtracker] Bug #3066: db2 causes mariadb crashes

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3066&from=L21haW4-

steve G reported a new bug.

Summary
-------

db2 causes mariadb crashes

Type             : Bug
Priority         : High
Gambas version   : 3.20
Product          : Database component


Description
-----------

while using db2 for mysql/mariadb random crashes happen when writing to the tables. I have tried several mariadb servers and all had same response. We went from the regular gb3-db  to the gb3-db2 and programs that have this change are causing random crashes of the entire mariadb system. We have attempted many things to resolve this and find nothing works. We can restart the service and it will work until some unknown problem hits. always during after a write operation to the database. But not every time. It will work for 3 or 4 operations and be fine then the next it crashes. sometimes it works for a dozen operations then crashes. no data is lost. so far.


System information
------------------

[System]
Gambas=3.20.2
OperatingSystem=Linux
Distribution=Fedora Linux 41 (Workstation Edition)
Kernel=6.15.4-100.fc41.x86_64
Architecture=x86_64
Cores=8
Memory=11903M
Language=en_US.UTF-8
Platform=x11
Desktop=GNOME
DesktopResolution=96
DesktopScale=8
WidgetTheme=adwaita
Font=Cantarell,11
DarkTheme=False
[Programs]
dpkg=Debian 'dpkg' package management program version 1.22.15 (amd64).
gcc=gcc (GCC) 14.3.1 20250523 (Red Hat 14.3.1-1)
git=git version 2.50.0
msgmerge=msgmerge (GNU gettext-tools) 0.22.5
pngquant=4.0.0 (January 2023)
rpmbuild=RPM version 4.20.1
trans=Translate Shell       0.9.7.1
[Libraries]
Cairo=libcairo.so.2.11802.2
Curl=libcurl.so.4.8.0
DBus=libdbus-1.so.3.32.4
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2411.32
GStreamer=libgstreamer-1.0.so.0.2413.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2411.32
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.140.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.15.17
QT6=libQt6Core.so.6.8.3
RSvg=librsvg-2.so.2.59.2
SDL=libSDL2-2.0.so.0.3000.11
SQLite3=libsqlite3.so.0.8.6
[Environment]
BASH_ENV=/usr/share/lmod/lmod/init/bash
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DEBUGINFOD_IMA_CERT_PATH=/etc/keys/ima:
DEBUGINFOD_URLS=https://debuginfod.fedoraproject.org/ 
DESKTOP_SESSION=gnome
DISPLAY=:1
EDITOR=/usr/bin/nano
FPATH=/usr/share/lmod/lmod/init/ksh_funcs
GB_GUI=gb.gtk3
GDMSESSION=gnome
GDM_LANG=en_US.UTF-8
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=86844
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GPG_TTY=not a tty
HISTCONTROL=ignoredups
HISTSIZE=1000
HOME=/home/<hostname>
HOSTNAME=<hostname>
INVOCATION_ID=70634a9972e942d68adf41fff2b7d7e1
JOURNAL_STREAM=9:15066
KDEDIRS=/usr
LANG=en_US.UTF-8
LANGUAGE=en_US.UTF-8
LESSOPEN=||/usr/bin/lesspipe.sh %s
LMOD_CMD=/usr/share/lmod/lmod/libexec/lmod
LMOD_DIR=/usr/share/lmod/lmod/libexec
LMOD_PKG=/usr/share/lmod/lmod
LMOD_ROOT=/usr/share/lmod
LMOD_SETTARG_FULL_SUPPORT=no
LMOD_VERSION=8.7.55
LMOD_sys=Linux
LOGNAME=<hostname>
MAIL=/var/spool/mail/<hostname>
MANAGERPID=2504
MANPATH=/usr/share/lmod/lmod/share/man:
MEMORY_PRESSURE_WATCH=/sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@x11.service/memory.pressure
MEMORY_PRESSURE_WRITE=c29tZSAyMDAwMDAgMjAwMDAwMAA=
MODULEPATH=/etc/modulefiles:/usr/share/modulefiles:/usr/share/modulefiles/Linux:/usr/share/modulefiles/Core:/usr/share/lmod/lmod/modulefiles/Core
MODULEPATH_ROOT=/usr/share/modulefiles
MODULESHOME=/usr/share/lmod/lmod
MOZ_GMP_PATH=/usr/lib64/mozilla/plugins/gmp-gmpopenh264/system-installed
PATH=/home/<hostname>/.local/bin:/home/<hostname>/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin
PWD=/home/<hostname>
QT_IM_MODULE=ibus
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/unix:@/tmp/.ICE-unix/2646,unix/unix:/tmp/.ICE-unix/2646
SHELL=/bin/bash
SHLVL=0
SSH_AGENT_PID=2577
SSH_ASKPASS=/usr/bin/ksshaskpass
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
SYSTEMD_EXEC_PID=2692
SYSTEMD_SLEEP_FREEZE_USER_SESSIONS=0
TZ=:/etc/localtime
USER=<hostname>
USERNAME=<hostname>
WINDOWPATH=2
XAUTHORITY=/run/user/1000/gdm/Xauthority
XDG_ACTIVATION_TOKEN=gnome-shell/Gambas3/2692-21-<hostname>_TIME16829099
XDG_CURRENT_DESKTOP=GNOME
XDG_DATA_DIRS=/home/<hostname>/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share/:/usr/share/
XDG_MENU_PREFIX=gnome-
XDG_RUNTIME_DIR=/run/user/1000
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=gnome
XDG_SESSION_TYPE=x11
XMODIFIERS=@im=ibus


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----