diff --git a/kallithea/tests/test.ini b/kallithea/tests/test.ini
--- a/kallithea/tests/test.ini
+++ b/kallithea/tests/test.ini
@@ -531,8 +531,7 @@ keys = generic, color_formatter, color_f
 #############
 
 [logger_root]
-#level = NOTSET
-level = DEBUG
+level = NOTSET
 handlers = console
 
 [logger_routes]
@@ -561,10 +560,8 @@ qualname = kallithea
 propagate = 1
 
 [logger_sqlalchemy]
-#level = INFO
-level = ERROR
-#handlers = console_sql
-handlers = console
+level = INFO
+handlers = console_sql
 qualname = sqlalchemy.engine
 propagate = 0
 
@@ -582,14 +579,16 @@ propagate = 1
 class = StreamHandler
 args = (sys.stderr,)
 #level = INFO
-level = NOTSET
-formatter = generic
+level = DEBUG
+#formatter = generic
+formatter = color_formatter
 
 [handler_console_sql]
 class = StreamHandler
 args = (sys.stderr,)
 level = WARN
-formatter = generic
+#formatter = generic
+formatter = color_formatter_sql
 
 ################
 ## FORMATTERS ##
diff --git a/scripts/generate-ini.py b/scripts/generate-ini.py
--- a/scripts/generate-ini.py
+++ b/scripts/generate-ini.py
@@ -62,15 +62,16 @@ ini_files = [
                 'beaker.cache.lock_dir': '%(here)s/../../data/test/cache/lock',
                 'sqlalchemy.db1.url': 'sqlite:///%(here)s/kallithea_test.sqlite',
             },
-            '[logger_root]': {
+            '[handler_console]': {
                 'level': 'DEBUG',
+                'formatter': 'color_formatter',
             },
-            '[logger_sqlalchemy]': {
-                'level': 'ERROR',
-                'handlers': 'console',
-            },
-            '[handler_console]': {
-                'level': 'NOTSET',
+            # The 'handler_console_sql' block is very similar to the one in
+            # development.ini, but without the explicit 'level=DEBUG' setting:
+            # it causes duplicate sqlalchemy debug logs, one through
+            # handler_console_sql and another through another path.
+            '[handler_console_sql]': {
+                'formatter': 'color_formatter_sql',
             },
         },
     ),