View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000619 | Pgpool-II | Bug | public | 2020-06-17 13:30 | 2020-08-24 09:27 |
| Reporter | gregn123 | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.1.2 | ||||
| Target Version | 4.1.3 | Fixed in Version | 4.1.3 | ||
| Summary | 0000619: Regression test 055.backend_all_down fails if PG_INSTALL_DIR is not set to "/usr/local/pgsql/bin" (the default value) | ||||
| Description | Regression test 055.backend_all_down does not respect the PG_INSTALL_DIR setting in regress.sh - the test fails with the following type of error if PG_INSTALL_DIR is changed to something other than (the default value) "/usr/local/pgsql/bin": /usr/local/pgsql12/bin/pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory. The problem is caused by the LD_LIBRARY_PATH value being hard-wired in src/test/regression/tests/055.backend_all_down/test.sh: echo "LD_LIBRARY_PATH=/usr/local/pgsql/lib" > pgpool.sh This only works correctly if PG_INSTALL_DIR is /usr/local/pgsql/bin Instead, it should be: echo "LD_LIBRARY_PATH=$PGBIN/../lib" > pgpool.sh I've attached a patch. Please review. | ||||
| Steps To Reproduce | Install Postgres to a non-default location (i.e. something other than /usr/local/pgsql), set PG_INSTALL_DIR (in regress.sh) to corresponding bin directory, and run the pgpool2 regression tests. | ||||
| Additional Information | NOTE: regression test 019.log_client_messages correctly sets LD_LIBRARY_PATH to $PGBIN/../lib | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
This issue is fixed in 4.0.3. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=296455b5a8f796c9136879fd7b5aaeae2f0738aa This commit use pg_config to get PostgreSQL lib path. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-06-17 13:30 | gregn123 | New Issue | |
| 2020-06-17 13:30 | gregn123 | File Added: 0001-Fix-LD_LIBRARY_PATH-setting-in-test-055.backend_all_.patch | |
| 2020-06-17 15:58 | pengbo | Assigned To | => pengbo |
| 2020-06-17 15:58 | pengbo | Status | new => assigned |
| 2020-06-17 15:58 | pengbo | Description Updated | |
| 2020-06-17 15:58 | pengbo | Steps to Reproduce Updated | |
| 2020-08-24 09:27 | administrator | Note Added: 0003505 | |
| 2020-08-24 09:27 | administrator | Status | assigned => closed |
| 2020-08-24 09:27 | administrator | Fixed in Version | => 4.1.3 |
| 2020-08-24 09:27 | administrator | Target Version | => 4.1.3 |
