Selecting all rows in a large database (10.000.000+ lines) crashes the app

[abcRede]

Describe the bug If you open any database and manually issue a query to select all rows in a large table, it crashes the application with the following log:

Flatpak install: [dev@dev-abcrede-2 ~]$ flatpak run it.fabiodistasio.AntaresSQL Wayland socket is available, running natively on Wayland. To disable, remove the --socket=wayland permission. Passing the following arguments to Electron: --enable-gpu-rasterization --enable-zero-copy --enable-gpu-compositing --enable-native-gpu-memory-buffers --enable-oop-rasterization --disable-gpu-blocklist --ozone-platform-hint=auto --enable-features=UseSkiaRenderer, WaylandWindowDecorations [3 zypak-helper] Wait found events, but sd-event found none [3:0304/082402.084125:ERROR:bus.cc(399)] Failed to connect to the bus: Failed to connect to socket /run/dbus/system_bus_socket: Arquivo ou diretório inexistente [3:0304/082403.072401:ERROR:bus.cc(399)] Failed to connect to the bus: Failed to connect to socket /run/dbus/system_bus_socket: Arquivo ou diretório inexistente [3:0304/082403.072434:ERROR:bus.cc(399)] Failed to connect to the bus: Failed to connect to socket /run/dbus/system_bus_socket: Arquivo ou diretório inexistente [3:0304/082403.573575:ERROR:object_proxy.cc(590)] Failed to call method: org.kde.KWallet.isEnabled: object_path= /modules/kwalletd5: org.freedesktop.DBus.Error.ServiceUnknown: org.freedesktop.DBus.Error.ServiceUnknown [3:0304/082403.573591:ERROR:kwallet_dbus.cc(107)] Error contacting kwalletd5 (isEnabled) [3:0304/082403.573686:ERROR:object_proxy.cc(590)] Failed to call method: org.kde.KLauncher.start_service_by_desktop_name: object_path= /KLauncher: org.freedesktop.DBus.Error.ServiceUnknown: org.freedesktop.DBus.Error.ServiceUnknown [3:0304/082403.573691:ERROR:kwallet_dbus.cc(79)] Error contacting klauncher to start kwalletd5 [3:0304/082403.573766:ERROR:object_proxy.cc(590)] Failed to call method: org.kde.KWallet.close: object_path= /modules/kwalletd5: org.freedesktop.DBus.Error.ServiceUnknown: org.freedesktop.DBus.Error.ServiceUnknown [3:0304/082403.573771:ERROR:kwallet_dbus.cc(459)] Error contacting kwalletd5 (close) /app/bin/startantares, linha 30: 3 Trace/breakpoint trap (imagem do núcleo gravada)zypak-wrapper /app/main/antares "${FLAGS[@]}" "$@"

AUR (bin) install: [dev@dev-abcrede-2 ~]$ antares-sql Trace/breakpoint trap (imagem do núcleo gravada)

To Reproduce

• Open the app and connect to any database
• Open a new tab
• Issue a simple select in a very large table (SELECT * FROM your_big_table)
• The application should crash, even if there are memory available in the host.

Expected behavior The application should either paginate the results, like DataGrip, or handle the exception and show an error to the user, instead of closing the application. Application (please complete the following information):

• App client: MySQL 8.0.29
• App version: 0.7.22
• Installation source: Arch Linux (AUR & Flatpack, both are reproducible)

Environment (please complete the following information):

• OS name: Arch Linux
• OS version: rolling
• DB name: MySQL
• DB version: MySQL 8.0.29

Additional context I have checked that:

• The hosts didn't run out of memory during the query execution;
• There was no errors in MySQL side;
• The query, although really slow, managed to complete in MySQL Workbench and faster (due pagination + automatically inserting limit statement in the query) in DataGrip

[abcRede]

Might be related:

• https://www.electronjs.org/blog/v8-memory-cage

[Fabio286]

I think the implementation of an auto pagination would be the best solution.