[Bug 969715] New: postgresql93-postgis 2.2.1 error: undefined symbol: GEOSClipByRect
http://bugzilla.opensuse.org/show_bug.cgi?id=969715 Bug ID: 969715 Summary: postgresql93-postgis 2.2.1 error: undefined symbol: GEOSClipByRect Classification: openSUSE Product: openSUSE Distribution Version: 13.2 Hardware: Other OS: openSUSE 13.2 Status: NEW Severity: Normal Priority: P5 - None Component: Other Assignee: bnc-team-screening@forge.provo.novell.com Reporter: someuniquename@gmail.com QA Contact: qa-bugs@suse.de Found By: --- Blocker: --- Hi. I installed postgresql93-postgis 2.2.1 from Application:Geo repository. When i tried to use it i got an error:
psql -U postgres demorest demorest=# CREATE EXTENSION postgis; ERROR: could not load library "/usr/lib/postgresql93/lib64/postgis-2.2.so": /usr/lib/postgresql93/lib64/postgis-2.2.so: undefined symbol: GEOSClipByRect
The reason that postgis 2.2+ should require libgeos-3.5 or higher, but my version was 3.4. I had to manually update it to resolve issue. I wish i could just send pull request in OBS, but noticed that identical spec-file is autogenerated for few versions of postgis and it is quite hard to modify it for postgis 2.2 only. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
Angelos Tzotsos
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c1
--- Comment #1 from Angelos Tzotsos
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c2
--- Comment #2 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c3
--- Comment #3 from Angelos Tzotsos
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c4
--- Comment #4 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c5
--- Comment #5 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c6
Bruno Friedmann
From where was coming your geos 3.4 package (oss,geo,packman?) you can check in /var/log/zypp/history* when it was installed last time.
-- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c7
--- Comment #7 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c8
Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c9
--- Comment #9 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c10
--- Comment #10 from Roman Evstifeev
actual package postgis require the right version of geos see my previous example.
rpm -q --requires postgresql93-postgis display that postgis require any version of libgeos_c.so.1()(64bit)
As your postgis2 was in another Vendor repo
postgis2 was from the same repo as my current postgresql93-postgis. (Application:Geo) But back in 2015 my geos package somehow got picked up from another repo (home:ecsos).
I would assume that installing postgresql93-postgis wouldn't allow the vendor change.
No, this is not true. I installed with yast, and option "allow vendor change" is enabled.
For that could you provide a testcase with a clean 13.2
I believe that such test will pass. I am experiencing upgrade problems, not the clean installation. I only thought it would be nice if other users like me will not have problems with upgrading. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c13
--- Comment #13 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c14
--- Comment #14 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c15
--- Comment #15 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c17
--- Comment #17 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c18
--- Comment #18 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c19
--- Comment #19 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c20
--- Comment #20 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c21
--- Comment #21 from Roman Evstifeev
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c22
Martin Pluskal
I would say as Application:Geo is a final and devel repository, we will not be able to produce a silver bullet for everycase.
Roman, Angelos do you have any package on Leap that force geos 3.4.2 ? If none, then I would recommend an update in the .changes + description that people trying to use postgis from Application:Geo should after adding the repository do a zypper -v dup --from Application:Geo to upgrade any component to the one present in A:G ... Which is the normal recommended way for any additionnal repository.
This will help people like Roman having a component (perhaps older) to be upgraded to the last one we have in A:G.
Otherwise, we will have to open a Maintenance Ticket against Leap + SLE12 to have geos upgraded there (and explaining why :-)) hmpf this would be tricky as geos on Leap does not have split package for shared library, such change would introduce new package and likely require rebuild of geos dependencies (gdal).
-- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c23
--- Comment #23 from Martin Pluskal
Is it possible to have postgis linked to geos statically?
I assume that you mean postgis to use statically linked geos? Technically it would be possible, but such solution would be just wrong - there are reasons why static linking is not used and actively discouraged/forbidden in most distributions. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c24
--- Comment #24 from Roman Evstifeev
I assume that you mean postgis to use statically linked geos? Technically it would be possible, but such solution would be just wrong - there are reasons why static linking is not used and actively discouraged/forbidden in most distributions.
Static linking have some drawbacks, but maybe for this particular case it can be used as a solution? Is it forbidden in openSUSE official repos? If it is forbidden in the official repo - maybe some conditional blocks in the spec will allow to link statically only in the devel repo, while official repo will have dynamically linked one? -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c25
--- Comment #25 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c26
--- Comment #26 from Bruno Friedmann
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c27
--- Comment #27 from Angelos Tzotsos
http://bugzilla.opensuse.org/show_bug.cgi?id=969715
http://bugzilla.opensuse.org/show_bug.cgi?id=969715#c28
Bruno Friedmann
participants (1)
-
bugzilla_noreply@novell.com