Comments (14)
from rum.
Thanks. Could you tag that as a new release so I can update the Debian package?
from rum.
Stamped 1.3.10
Thanks!
from rum.
I'm afraid something broke there:
--- /srv/projects/postgresql/rum/rum/expected/security.out 2021-06-30 14:21:19.533586666 +0200
+++ /srv/projects/postgresql/rum/rum/results/security.out 2022-05-26 11:26:37.627962177 +0200
@@ -1,5 +1,5 @@
-- Check security CVE-2020-14350
CREATE FUNCTION rum_anyarray_similar(anyarray,anyarray) RETURNS bool AS $$ SELECT false $$ LANGUAGE SQL;
CREATE EXTENSION rum;
-ERROR: function "rum_anyarray_similar" already exists with same argument types
+ERROR: could not load library "/home/cbe/postgresql/rum/rum/debian/postgresql-14-rum/usr/lib/postgresql/14/lib/rum.so": /home/cbe/postgresql/rum/rum/debian/postgresql-14-rum/usr/lib/postgresql/14/lib/rum.so: undefined symbol: postgresql_sort__done_semaphore
All PG versions (10..14) are affected.
from rum.
Build log: https://salsa.debian.org/postgresql/postgresql-rum/-/jobs/2812273/raw
from rum.
Tried to reproduce this on PG 14.0-14.3
make USE_PGXS=1 distclean
make USE_PGXS=1
make USE_PGXS=1 install
make USE_PGXS=1 installcheck
I haven't found any faults. Can you try to clean and try again? Or please specify how do you build rum/Postgres and which branch states you use?
from rum.
I can reproduce the problem in several environments (notebook, Debian CI host, apt.postgresql.org buildd). Running directly on the 1.3.10 tag without the debian/ bits:
make USE_PGXS=1 distclean
make USE_PGXS=1
sudo make USE_PGXS=1 install
pg_virtualenv make USE_PGXS=1 installcheck
Creating new PostgreSQL cluster 14/regress ...
/usr/lib/postgresql/14/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/14/bin' --dbname=contrib_regression security rum rum_validate rum_hash ruminv timestamp orderby orderby_hash altorder altorder_hash limits int2 int4 int8 float4 float8 money oid time timetz date interval macaddr inet cidr text varchar char bytea bit varbit numeric rum_weight array
(using postmaster on localhost, port 5433)
============== dropping database "contrib_regression" ==============
HINWEIS: Datenbank »contrib_regression« existiert nicht, wird übersprungen
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test security ... FAILED 39 ms
...
head regression.diffs
diff -U3 /srv/projects/postgresql/rum/rum/expected/security.out /srv/projects/postgresql/rum/rum/results/security.out
--- /srv/projects/postgresql/rum/rum/expected/security.out 2022-05-25 22:37:42.000000000 +0200
+++ /srv/projects/postgresql/rum/rum/results/security.out 2022-05-26 14:16:00.743831887 +0200
@@ -1,5 +1,5 @@
-- Check security CVE-2020-14350
CREATE FUNCTION rum_anyarray_similar(anyarray,anyarray) RETURNS bool AS $$ SELECT false $$ LANGUAGE SQL;
CREATE EXTENSION rum;
-ERROR: function "rum_anyarray_similar" already exists with same argument types
+ERROR: could not load library "/usr/lib/postgresql/14/lib/rum.so": /usr/lib/postgresql/14/lib/rum.so: undefined symbol: postgresql_sort__done_semaphore
DROP FUNCTION rum_anyarray_similar(anyarray,anyarray);
psql (14.3 (Debian 14.3-1+b1)) on Debian unstable/amd64
from rum.
Can you tell me postgres branch state? I see 14.3-1+b1 and can not understand what's that state of 14 branch (tried the newest one, though and found no problems with it). I start to suppose some problem with PostgreSQL package you used. Have you tried PG built from source?
Again I would continue trying to reproduce if knew PG branch state that fails.
from rum.
BTW looks similar to the problem reported (unrelated to RUM): https://www.postgresql.org/message-id/16555-de24d39c1e421f14%40postgresql.org
from rum.
I'm building PG from source all the time since I'm the one who puts the packages into Debian and apt.postgresql.org where 14.3-1+b1 is coming from.
rum branch is the 1.3.10 tag.
from rum.
There is a reported problem with building Postgres with link-time-optimization i.e. -flto CFLAG (link above). Is it possible to disable it?
from rum.
I don't think LTO is being used in the PG builds; only the .bc files used for llvmjit are lto-ized, but neither the PG server build [1] nor the rum build [2].
[1] https://buildd.debian.org/status/fetch.php?pkg=postgresql-14&arch=amd64&ver=14.3-1%2Bb1&stamp=1652502731&raw=0
[2] https://pgdgbuild.dus.dg-i.net/job/postgresql-rum-binaries/34/architecture=amd64,distribution=sid/console
But it indeed looks like the problem is something in that direction.
from rum.
I guess the breaking change since 1.3.9 is that rum is now re-defining the tuplesort machinery from core PG. I don't understand yet why that's necessary, but at least the bit where it's overwriting the trace_sort GUC seems wrong (it should use the existing definition):
https://github.com/postgrespro/rum/blob/master/src/tuplesort14.c#L140
from rum.
Since this is a new issue independent from the original one, I've opened #108.
from rum.
Related Issues (20)
- Querying 1.6 million records using RUM index takes 2 seconds HOT 1
- rum compile warnings on pg14.0 HOT 2
- New release with PG14 support HOT 2
- Ошибка: could not load library "/usr/pgsql-14/lib/rum.so" при выполнении create extension HOT 5
- rum_anyarray_addon_ops index not working HOT 1
- Is there a way to weight the rum_ts_score function?
- why the rum index not working HOT 9
- ERROR: could not load library rum.so: undefined symbol: postgresql_sort__done_semaphore HOT 5
- Hello, may I ask why rum deleted the fast update function, what is the consideration?
- Can we compute two tsvectors like array op?
- New release with PG15 support? HOT 2
- warning on var totalCount compile on mac venture clang
- create rum index without "WITH" cause an error when select use “ORDER BY”
- In a query, `||` does not work when nested in `<->` HOT 3
- Index with jsonb and int8?
- [bug] the result is different when rum index(for tsquery) used and not used HOT 2
- Feasibility of adding range operator for tsquery HOT 5
- Extension ready for Postgres 14? HOT 2
- [Bug] addInfo is (Datum) 0, which is expected to be not, coredump in func DatumGetByteaP HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rum.