search

vidardb / pgrocks-fdw

Bring RocksDB to PostgreSQL as an extension. It is the first foreign data wrapper (FDW) that introduces LSM-tree into PostgreSQL. The underneath storage engine can be RocksDB. The FDW also serves for VidarDB engine, a versatile storage engine for various workloads. See the link for more info about VidarDB engine.
https://www.vidardb.com
Apache License 2.0
122 stars 11 forks source link

Cannot start the pgrocks after installation #45

Open Change72 opened 1 year ago

Change72 commented 1 year ago

My OS: Ubuntu 20.04 I followed the readme and finished the installation. By the way, I notice it does not support a secondary index in the limitation part. Just to make sure, does it still support spatial index(R-Tree)?

● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: active (exited) since Sat 2022-10-29 23:27:32 MST; 8min ago Process: 2026248 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 2026248 (code=exited, status=0/SUCCESS)

Oct 29 23:27:32 en4217753l systemd[1]: Starting PostgreSQL RDBMS... Oct 29 23:27:32 en4217753l systemd[1]: Finished PostgreSQL RDBMS.

2022-10-29 19:37:47.000 MST [1788256] LOG: starting PostgreSQL 13.8 (Ubuntu 13.8-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit 2022-10-29 19:37:47.000 MST [1788256] LOG: listening on IPv4 address "127.0.0.1", port 5432 2022-10-29 19:37:47.001 MST [1788256] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2022-10-29 19:37:47.002 MST [1788257] LOG: database system was shut down at 2022-10-29 19:37:45 MST 2022-10-29 19:37:47.005 MST [1788256] LOG: database system is ready to accept connections 2022-10-29 19:57:44.374 MST [1788256] LOG: received fast shutdown request 2022-10-29 19:57:44.374 MST [1788256] LOG: aborting any active transactions 2022-10-29 19:57:44.376 MST [1788256] LOG: background worker "logical replication launcher" (PID 1788263) exited with exit code 1 2022-10-29 19:57:44.376 MST [1788258] LOG: shutting down 2022-10-29 19:57:44.382 MST [1788256] LOG: database system is shut down 2022-10-29 19:57:44.537 MST [1816513] FATAL: could not load library "/usr/lib/postgresql/13/lib/kv_fdw.so": /lib/x86_64-linux-gnu/libjemalloc.so.2: cannot allocate memory in static TLS block 2022-10-29 19:57:44.538 MST [1816513] LOG: database system is shut down pg_ctl: could not start server Examine the log output. 2022-10-29 23:18:36.461 MST [2017198] FATAL: could not load library "/usr/lib/postgresql/13/lib/kv_fdw.so": /lib/x86_64-linux-gnu/libjemalloc.so.2: cannot allocate memory in static TLS block 2022-10-29 23:18:36.461 MST [2017198] LOG: database system is shut down pg_ctl: could not start server Examine the log output. 2022-10-29 23:27:32.545 MST [2026247] FATAL: could not load library "/usr/lib/postgresql/13/lib/kv_fdw.so": /lib/x86_64-linux-gnu/libjemalloc.so.2: cannot allocate memory in static TLS block 2022-10-29 23:27:32.545 MST [2026247] LOG: database system is shut down pg_ctl: could not start server Examine the log output.

jsc0218 commented 1 year ago

This fdw version does not support secondary index. Though we are developing a table_am version, but R-tree is not in our recent road map currently. Could you briefly show your use cases why using rocksdb & r-tree?

Change72 commented 1 year ago

I need to write plenty of spatial data during the experiment. Rocksdb becomes a good choice since its high write performance, and I can also disable the compaction.

As the experiment finished, I want to build a r-tree spatial index to accelerate the query efficiency.

Change72 commented 1 year ago

Hi, I want to run pgrocks and do some tests. But the upper problem cannot be solved: "could not load library "/usr/lib/postgresql/13/lib/kv_fdw.so": /lib/x86_64-linux-gnu/libjemalloc.so.2: cannot allocate memory in static TLS block"

jsc0218 commented 1 year ago

Can you try 13.2 version instead? Otherwise, you may have to wait for our update.