[Gambas-user] Doing query of Stored procedure with no related data crashes gambas

[Safiur Rahman]

Hi

I query a stored procedure every 30 second by specifying an argument
in mysql/mariadb eg.

res = $qrScanCon.Exec("CALL spGetTransByTraceId('" & sIndex & "')")

a) When the data is present then reult is available. I can use the
result. No problem.

b) When the data is not present then result is not returned. In this case

When the query is executed in MySQL terminal the message produced is:
  Empty set (0.017 sec)
  Query OK, 0 rows affected (0.017 sec)

But the gambas query above shows error and crashes
Query failed: Commands out of sync; you can't run this command now

Even if I use "TRY" eg.
Try res = $qrScanCon.Exec("CALL spGetTransByTraceId('" & sIndex & "')")
  If res And If res.Available Then

Gambas never returns the result even if the stored procedure gets data later on

I am using development version (gambas daily ppa)

System Information:
[System]
Gambas=3.18.90
OperatingSystem=Linux
Distribution=Ubuntu 22.04.1 LTS
Kernel=5.15.0-60-generic
Architecture=x86_64
Cores=2
Memory=3727M
Language=en_US.UTF-8
Desktop=UBUNTU
DesktopResolution=96
DesktopScale=8
WidgetTheme=yaru
Font=Ubuntu,11

[Programs]
gcc=gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0

[Libraries]
Cairo=libcairo.so.2.11600.0
Curl=libcurl.so.4.7.0
DBus=libdbus-1.so.3.19.13
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2404.29
GStreamer=libgstreamer-1.0.so.0.2003.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2404.29
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.118.0.0
QT5=libQt5Core.so.5.15.3
RSvg=librsvg-2.so.2.48.0
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DESKTOP_SESSION=ubuntu-xorg
DISPLAY=:0
GB_GUI=gb.gtk3
GDMSESSION=ubuntu-xorg
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=23844
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GNOME_SHELL_SESSION_MODE=ubuntu
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK_MODULES=gail:atk-bridge
HOME=<home>
INVOCATION_ID=6d2f1c1ca39f4ccabfd34e71b0e1b720
JOURNAL_STREAM=8:35413
LANG=en_US.UTF-8
LC_ADDRESS=bho_NP
LC_ALL=en_US.UTF-8
LC_IDENTIFICATION=bho_NP
LC_MEASUREMENT=bho_NP
LC_MONETARY=bho_NP
LC_NAME=bho_NP
LC_NUMERIC=bho_NP
LC_PAPER=bho_NP
LC_TELEPHONE=bho_NP
LC_TIME=bho_NP
LOGNAME=<user>
MANAGERPID=2790
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin
PWD=<home>
QT_ACCESSIBILITY=1
QT_IM_MODULE=ibus
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/3085,unix/<hostname>:/tmp/.ICE-unix/3085
SHELL=/bin/bash
SHLVL=0
SSH_AGENT_LAUNCHER=gnome-keyring
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
SYSTEMD_EXEC_PID=3118
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=2
XAUTHORITY=/run/user/1000/gdm/Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-ubuntu-xorg:/etc/xdg
XDG_CURRENT_DESKTOP=ubuntu:GNOME
XDG_DATA_DIRS=/usr/share/ubuntu-xorg:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
XDG_MENU_PREFIX=gnome-
XDG_RUNTIME_DIR=/run/user/1000
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=ubuntu-xorg
XDG_SESSION_TYPE=x11
XMODIFIERS=@im=ibus

-- 
Regards
Safiur Rahman