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

[Safiur Rahman]

I think this is the same as the one reported earlier

https://lists.gambas-basic.org/pipermail/user/2007-June/015553.html

On 2/18/23, Safiur Rahman <isafiur at gmail.com> wrote:
> 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
>


-- 
Regards
Safiur Rahman