PostGIS installation error: "postgis-1.4.so: undefined symbol: ARR_NULLBITMAP"

[Ben Welsh]

Hello,

I'm installing the GeoDjango dependencies, as well as psql on a fresh Linux machine.

$ uname -a
Linux ...snip.. x86_64 x86_64 x86_64 GNU/Linux

I walked through the exact keystrokes for source compilation in the documentation -- but ran into an error when trying to configure my `template_postgis` database like so:


# psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql

And the following shows up in the psql error logs.

NOTICE:  type "spheroid" is not yet defined
DETAIL:  Creating a shell type definition.

ERROR:  could not load library "/usr/lib64/pgsql/postgis-1.4.so": /usr/lib64/pgsql/postgis-1.4.so: undefined symbol: ARR_NULLBITMAP
ERROR:  current transaction is aborted, commands ignored until end of transaction block

ERROR:  current transaction is aborted, commands ignored until end of transaction block
...and on and on...

Has anyone seen this before? Is there something I screwed up?

I had some earlier errors that said "libgeos_c.so.1: cannot open shared object file", but was able to get past them by setting a new symbolic link to the library and running ldconfig.


Sincerely,

Ben.

[Dane Springmeyer]

On Aug 19, 2009, at 2:47 PM, Ben Welsh wrote:

> I had some earlier errors that said "libgeos_c.so.1: cannot open
> shared object file", but was able to get past them by setting a new
> symbolic link to the library and running ldconfig.

On a 64 bit machine I also had some odd library problems with geos
from source the first try at building - something todo with
incompatibility in architecture that was solved by a make clean &&
make && make install. I'd try a fresh rebuild of geos, then postgis.

Dane

[Richard Garbutt]

Hi Ben,

I had this error recently when installing on 64bit centos 5. I worked
around the problem by removing postgis 1.4 and installing postgis
1.3.6.

hth,

Richard

[Ben Welsh]

Richard,

Thanks for that advice. I'm going to try Dane's idea, and if it fails maybe follow your path.

Is there an advised way to remove PostGIS after it's been compiled?

Ben.

[Richard Garbutt]

Ben,

I think I did make uninstall from the postgis source directory. Not
sure if it's advised but it worked for me.

Richard

[Ben Welsh]

Unfortunately, Dane's trick didn't seem to work. So I ran 'make uninstall' in postgis1.4 and installed 1.36. as Richard suggested. It worked. Thanks everybody.

[Justin Bronn]

Ben Welsh wrote:
> Unfortunately, Dane's trick didn't seem to work. So I ran 'make
> uninstall' in postgis1.4 and installed 1.36. as Richard suggested. It
> worked. Thanks everybody.

Can you provide the Linux distribution and version you're using? (I know
it's 64-bit) I want to see if I can reproduce on a VM locally, and see
if I need to modify the build instructions or file a bug w/the PostGIS team.

-Justin

[Ben Welsh]

Here are a couple commands. Let me know if I'm not giving you what you need.

$ lsb_release -a
LSB Version:    :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description:    CentOS release 5.3 (Final)
Release:        5.3
Codename:       Final

$ cat /proc/version
Linux version 2.6.18-128.el5xen (mock...@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-44)) #1 SMP Wed Jan 21 11:12:42 EST 2009

$ cat /etc/issue
CentOS release 5.3 (Final)
Kernel \r on an \m