saygoodbyye opened a new issue, #1878:
URL: https://github.com/apache/age/issues/1878
**Describe the bug**
Test age_global_graph sometimes fails. Mainly appears when the machine is
running slowly.
**How are you accessing AGE (Command line, driver, etc.)?**
Accessing AGE through command line.
**What data setup do we need to do?**
Apache AGE (master branch) with PostgreSQL (REL_16_STABLE).
**What is the necessary configuration info needed?**
```
./configure CFLAGS=" -Og" --enable-tap-tests --enable-debug --enable-cassert
```
**What is the command that caused the error?**
To reproduce fail several times faster I do this Makefile patch (Only to
reproduce fail faster. This fail may occur even without these changes):
```
diff --git a/Makefile b/Makefile
index 1224fc2a..0d51a9e0 100644
--- a/Makefile
+++ b/Makefile
@@ -85,35 +85,7 @@ SQLS := $(addsuffix .sql,$(SQLS))
DATA_built = $(age_sql)
# sorted in dependency order
-REGRESS = scan \
- graphid \
- agtype \
- catalog \
- cypher \
- expr \
- cypher_create \
- cypher_match \
- cypher_unwind \
- cypher_set \
- cypher_remove \
- cypher_delete \
- cypher_with \
- cypher_vle \
- cypher_union \
- cypher_call \
- cypher_merge \
- cypher_subquery \
- age_global_graph \
- age_load \
- index \
- analyze \
- graph_generation \
- name_validation \
- jsonb_operators \
- list_comprehension \
- map_projection \
- drop
-
+REGRESS=$(shell printf "age_global_graph %.0s" `seq 100` )
srcdir=`pwd`
ag_regress_dir = $(srcdir)/regress
```
Then i run make installcheck:
```
for i in `seq 1000`;do make installcheck || break;done
```
And get:
```
<...>
ok 60 - age_global_graph 1440 ms
not ok 61 - age_global_graph 1126 ms
ok 62 - age_global_graph 1181 ms
ok 63 - age_global_graph 1037 ms
<...>
```
regression.diffs:
```
diff -U3 /home/test/work/age/regress/expected/age_global_graph.out
/home/test/work/age/regress/results/age_global_graph.out
--- /home/test/work/age/regress/expected/age_global_graph.out 2024-05-14
13:18:45.498945171 +0700
+++ /home/test/work/age/regress/results/age_global_graph.out 2024-05-14
23:47:05.372383890 +0700
@@ -81,7 +81,7 @@
SELECT * FROM cypher('ag_graph_2', $$ RETURN
delete_global_graphs('ag_graph_2') $$) AS (result agtype);
result
--------
- true
+ false
(1 row)
-- delete ag_graph_1's context
@@ -97,7 +97,7 @@
SELECT * FROM cypher('ag_graph_3', $$ RETURN
delete_global_graphs('ag_graph_3') $$) AS (result agtype);
result
--------
- true
+ false
(1 row)
-- delete all graphs' context again
```
Best regards,
Egor Chindyaskin
Postgres Professional: https://postgrespro.com/
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
