search

microo8 / plgo

easily create postgresql extensions in golang; moved to gitlab.com/microo8/plgo
292 stars 23 forks source link

undefined symbol: getmissingattr #24

Closed AoAnima closed 5 years ago

AoAnima commented 5 years ago

Hi Vlado! yesterday everything was fine, today there was an error I upload files '/usr/lib/postgresql/11/lib/main.h' '/usr/lib/postgresql/11/lib/main.so' '/usr/share/postgresql/11/extension/main.control' '/usr/share/postgresql/11/extension/main--0.1.sql'

create extension main;

[XX000] ERROR: load the library "/usr/lib/postgresql/11/lib/main.so" failed: /usr/lib/postgresql/11/lib/main.so: undefined symbol: getmissingattr

What could it be ? and how to set another package name not main?

AoAnima commented 5 years ago

in main.so ...__varsize elog_start elog_finish SPI_getbinval getmissingattr heap_getsysattr nocachegetattr cstring_to_text.... and _cgo_97f110e298b6_Cfunc_SPI_gettype getmissingattr _cgo_97f110e298b6_Cfunc_parseTypeString _cgo_wait_runtime_init_done datum_to_heap_tuple elog_start _cgo_97f110e298b6

microo8 commented 5 years ago

Did you update your postgresql? I've found that getmissingattr is a new function. http://www.postgresql-archive.org/loading-plpython-error-tp6071944p6071952.html

try to recompile your extension.

AoAnima commented 5 years ago

Yesterday everything was fine! Since yesterday, I have not updated the postgres, as it was 11 and it is 11. I have already deleted a million times and recompiled the plgo and your example :(

AoAnima commented 5 years ago

I remembered yesterday I have updated 190+ packages, among them 2019-02-26 09:10:29 upgrade postgresql-client-common:all 197.pgdg18.10+1 199.pgdg18.10+1 2019-02-26 09:10:29 status half-configured postgresql-client-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-client-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status half-installed postgresql-client-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status triggers-pending man-db:amd64 2.8.4-2 2019-02-26 09:10:29 status half-installed postgresql-client-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-client-common:all 199.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-client-common:all 199.pgdg18.10+1 2019-02-26 09:10:29 upgrade postgresql-common:all 197.pgdg18.10+1 199.pgdg18.10+1 2019-02-26 09:10:29 status half-configured postgresql-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status half-installed postgresql-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status triggers-pending systemd:amd64 239-7ubuntu10.6 2019-02-26 09:10:29 status half-installed postgresql-common:all 197.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-common:all 199.pgdg18.10+1 2019-02-26 09:10:29 status unpacked postgresql-common:all 199.pgdg18.10+1 2019-02-26 09:11:11 upgrade postgresql-client-11:amd64 11.1-1.pgdg18.10+1 11.2-1.pgdg18.10+1 2019-02-26 09:11:11 status half-configured postgresql-client-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:11 status unpacked postgresql-client-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:11 status half-installed postgresql-client-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:11 status half-installed postgresql-client-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:11 status unpacked postgresql-client-11:amd64 11.2-1.pgdg18.10+1 2019-02-26 09:11:11 status unpacked postgresql-client-11:amd64 11.2-1.pgdg18.10+1 2019-02-26 09:11:11 upgrade postgresql-11:amd64 11.1-1.pgdg18.10+1 11.2-1.pgdg18.10+1 2019-02-26 09:11:11 status half-configured postgresql-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:12 status unpacked postgresql-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:12 status half-installed postgresql-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status half-installed postgresql-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status unpacked postgresql-11:amd64 11.2-1.pgdg18.10+1 2019-02-26 09:11:13 status unpacked postgresql-11:amd64 11.2-1.pgdg18.10+1 2019-02-26 09:11:13 upgrade postgresql-server-dev-11:amd64 11.1-1.pgdg18.10+1 11.2-1.pgdg18.10+1 2019-02-26 09:11:13 status half-configured postgresql-server-dev-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status unpacked postgresql-server-dev-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status half-installed postgresql-server-dev-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status half-installed postgresql-server-dev-11:amd64 11.1-1.pgdg18.10+1 2019-02-26 09:11:13 status unpacked postgresql-server-dev-11:amd64 11.2-1.pgdg18.10+1 2019-02-26 09:11:13 status unpacked postgresql-server-dev-11:amd64 11.2-1.pgdg18.10+1

Could this cause an error?

AoAnima commented 5 years ago

Understood! The working computer was updated, but the server is not there, updated the server, updated the postgres on server, and it all worked!