From 4b28f6b9a4dbc41354065659fa4d60b793d0e8d1 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Mon, 30 Sep 2024 08:49:48 -0500
Subject: [PATCH] Garbage collect when out of memory

---
 src/pgwui_sql/views/sql.py | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/src/pgwui_sql/views/sql.py b/src/pgwui_sql/views/sql.py
index 2d326e8..5dcabc9 100644
--- a/src/pgwui_sql/views/sql.py
+++ b/src/pgwui_sql/views/sql.py
@@ -22,6 +22,7 @@ import attrs
 import codecs
 import csv
 import datetime
+import gc
 import logging
 import markupsafe
 import psycopg.errors
@@ -346,6 +347,7 @@ class SQLResultsHandler(pgwui_core.core.SessionDBHandler):
                 self.make_sql_results(cur)
             except MemoryError:
                 self.sql_results = []
+                gc.collect()
                 raise sql_ex.MemoryError()
 
     def factory(self, ue):
-- 
2.34.1