... [Thread1] Restarting loop. [Thread2] Sleeping for 0.609 seconds. [Thread1] Sleeping for 0.443 seconds. [Thread1] Thu Dec 19 10:01:36 PM CET 2024 [Thread1] Running install script psql:search_bug.sql:1: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA [Thread2] Thu Dec 19 10:01:36 PM CET 2024 [Thread2] Running install script CREATE SCHEMA CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() psql:search_bug.sql:1: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA DROP SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE PROCEDURE CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() DROP SCHEMA DROP SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE FUNCTION oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -------+-----------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+------------------+--------+------------+-----------+-------- 17057 | afunction | 17055 | 16385 | 13655 | 100 | 0 | 0 | - | f | f | f | f | f | v | u | 1 | 0 | 25 | 25 | | | {pinput} | | | +| | | | CREATE PROCEDURE | | | | | | | | | | | | | | | | | | | | | | | | | begin +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | return 'base'; +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | END | | | | (1 row) psql:search_bug.sql:29: NOTICE: drop cascades to function mytestbugschema02.afunction(text) [Thread1] Checking result of check_sql DROP SCHEMA CREATE SCHEMA CREATE FUNCTION oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -------+-----------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+------------------+--------+------------+-----------+-------- 17057 | afunction | 17055 | 16385 | 13655 | 100 | 0 | 0 | - | f | f | f | f | f | v | u | 1 | 0 | 25 | 25 | | | {pinput} | | | +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | begin +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | return 'base'; +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | END | | | | (1 row) [Thread1] Found problem, stopping thread. [Thread2] Checking result of check_sql [Thread2] Found problem, stopping thread. Both threads have completed. real 1m31.097s user 0m1.170s sys 0m2.597s ... [Thread1] Restarting loop. [Thread1] Sleeping for 0.778 seconds. [Thread2] Sleeping for 0.84 seconds. [Thread1] Thu Dec 19 10:02:48 PM CET 2024 [Thread1] Running install script psql:search_bug.sql:1: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA CREATE SCHEMA CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() DROP SCHEMA CREATE SCHEMA CREATE PROCEDURE psql:search_bug.sql:29: NOTICE: drop cascades to function mytestbugschema02.afunction(text) [Thread2] Thu Dec 19 10:02:48 PM CET 2024 [Thread2] Running install script DROP SCHEMA CREATE SCHEMA CREATE FUNCTION oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -----+---------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+--------+--------+------------+-----------+-------- (0 rows) [Thread1] Checking result of check_sql DROP SCHEMA CREATE SCHEMA CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() [Thread1] Found problem, stopping thread. DROP SCHEMA CREATE SCHEMA CREATE PROCEDURE psql:search_bug.sql:29: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA CREATE SCHEMA CREATE FUNCTION oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -------+-----------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+-----------------------+--------+------------+-----------+-------- 16733 | afunction | 16732 | 16385 | 13655 | 100 | 0 | 0 | - | f | f | f | f | f | v | u | 1 | 0 | 25 | 25 | | | {pinput} | | | +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | begin +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | return 'overwrite'; +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | END | | | | (1 row) [Thread2] Checking result of check_sql [Thread2] Found problem, stopping thread. Both threads have completed. real 0m46.865s user 0m0.612s sys 0m1.399s ... [Thread2] Sleeping for 0.656 seconds. [Thread1] Sleeping for 0.258 seconds. [Thread1] Thu Dec 19 10:05:14 PM CET 2024 [Thread1] Running install script psql:search_bug.sql:1: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA [Thread2] Thu Dec 19 10:05:14 PM CET 2024 [Thread2] Running install script CREATE SCHEMA CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() psql:search_bug.sql:1: NOTICE: drop cascades to function mytestbugschema02.afunction(text) DROP SCHEMA DROP SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE PROCEDURE CREATE FUNCTION psql:search_bug.sql:14: NOTICE: drop cascades to function mytestbugschema01.baseproc() DROP SCHEMA DROP SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE FUNCTION CREATE PROCEDURE psql:search_bug.sql:29: NOTICE: drop cascades to function mytestbugschema02.afunction(text) oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -------+-----------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+------------------+--------+------------+-----------+-------- 17033 | afunction | 17031 | 16385 | 13655 | 100 | 0 | 0 | - | f | f | f | f | f | v | u | 1 | 0 | 25 | 25 | | | {pinput} | | | +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | begin +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | return 'base'; +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | END | | | | (1 row) [Thread1] Checking result of check_sql DROP SCHEMA CREATE SCHEMA CREATE FUNCTION oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl -------+-----------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+----------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+------------------+--------+------------+-----------+-------- 17033 | afunction | 17031 | 16385 | 13655 | 100 | 0 | 0 | - | f | f | f | f | f | v | u | 1 | 0 | 25 | 25 | | | {pinput} | | | +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | begin +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | return 'base'; +| | | | | | | | | | | | | | | | | | | | | | | | | | | | | END | | | | (1 row) [Thread2] Checking result of check_sql [Thread1] Found problem, stopping thread. [Thread2] Found problem, stopping thread. Both threads have completed. real 1m28.489s user 0m1.225s sys 0m2.601s