[ckan-dev] CKAN 2.3 errors spatial

Florian May florian.wendelin.mayer at gmail.com
Mon Mar 23 02:43:25 UTC 2015


Mol be, Adria!

Give me a yell if there's anything I can assist you with. Happy to put in a
few dev hours if required - keen to learn how to upgrade third party deps
like leaflet-draw.

Cheers,
Florian

On Sat, Mar 21, 2015 at 1:20 AM, Adrià Mercader <adria.mercader at okfn.org>
wrote:

> Thanks Florian,
>
> I have some time set aside next week to bring ckanext-spatial up to
> speed with 2.3 and will definitely check your pointers.
>
>
> Adrià
>
> On 17 March 2015 at 17:44, Julio Acuña <julio.acuna.carrillo at gmail.com>
> wrote:
> > Thanks Florian and Adrià, I will be looking forward for the fix.
> >
> > On Fri, Mar 13, 2015 at 9:17 PM, Florian May
> > <florian.wendelin.mayer at gmail.com> wrote:
> >>
> >> Adrià,
> >>
> >> I've had a shot at fixing these. I suggest the fixes should be re-done
> in
> >> a more orderly fashion, but see my comments on details of the upgrade
> and my
> >> sandbox (link in comments) for a working implementation.
> >> Happy to assist / re-implement where appropriate and required!
> >>
> >> https://github.com/ckan/ckanext-spatial/pull/93
> >>
> >> Cheers,
> >> Florian
> >>
> >> On Fri, Mar 13, 2015 at 5:44 PM, Adrià Mercader <
> adria.mercader at okfn.org>
> >> wrote:
> >>>
> >>> Hi,
> >>>
> >>> The current master branch of ckanext-spatial will not work with 2.3
> >>> doing to requirements incompatibilities. This should be easy to fix
> >>> but we need to set some time aside to review it properly. I'll let the
> >>> list know when we can find some resources to work on this, hopefully
> >>> very soon.
> >>>
> >>> Cheers,
> >>>
> >>> Adrià
> >>>
> >>> On 13 March 2015 at 04:28, Florian May <
> florian.wendelin.mayer at gmail.com>
> >>> wrote:
> >>> > Isabel, Julio,
> >>> >
> >>> > this sounds awfully familiar... "It seems SqlAlchemy have renamed
> >>> > ColumnComparator to Comparator, and used it interchangeably as shown
> >>> > here."
> >>> > try using @chokoswitch's patched geoalchemy (using good old
> >>> > ColumnComparator) in ckanext-spatial's pip-requirements.txt like so
> and
> >>> > JTS1.13 (sourceforge) as described in section "Customise SolR to CKAN
> >>> > schema" here.
> >>> >
> >>> > HTH,
> >>> > Florian
> >>> >
> >>> > On Fri, Mar 13, 2015 at 11:08 AM, Julio Acuña
> >>> > <julio.acuna.carrillo at gmail.com> wrote:
> >>> >>
> >>> >> I have the same problem, it seems that ckanext-spatial doesn't play
> >>> >> well
> >>> >> with CKAN 2.3
> >>> >>
> >>> >> As far as I can tell, it has to do with the versions of sqlalchemy
> and
> >>> >> geoalchemy, maybe a patched version of geoalchemy could make the
> >>> >> trick, but
> >>> >> I haven't try it yet.
> >>> >>
> >>> >> Check this post
> >>> >>
> >>> >>
> http://gis.stackexchange.com/questions/109498/geoalchemy-attributeerror-type-object-columnproperty-has-no-attribute-colum
> >>> >>
> >>> >> On Tue, Mar 10, 2015 at 7:44 AM, Isabel Ruiz
> >>> >> <isaruizmellado at gmail.com>
> >>> >> wrote:
> >>> >>>
> >>> >>> Hello,
> >>> >>>
> >>> >>> I have upgraded to CKAN 2.3 and I have updated all my dependences
> >>> >>> (well,
> >>> >>> I think I have updated them :) ).
> >>> >>>
> >>> >>> I have restarted jetty and apache2.
> >>> >>>
> >>> >>> When I run CKAN, it returns this spatial error:
> >>> >>>
> >>> >>> What can be wrong?
> >>> >>>
> >>> >>> Thanks !
> >>> >>>
> >>> >>>
> >>> >>> [Tue Mar 10 13:23:47.184841 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291] mod_wsgi (pid=8508): Target WSGI script
> >>> >>> '/home/ckan/ckan/lib/default/bin/malaga.py' cannot be loaded as
> >>> >>> Python
> >>> >>> module.
> >>> >>> [Tue Mar 10 13:23:47.188418 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291] mod_wsgi (pid=8508): Exception occurred
> processing
> >>> >>> WSGI
> >>> >>> script '/home/ckan/ckan/lib/default/bin/malaga.py'.
> >>> >>> [Tue Mar 10 13:23:47.189669 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291] Traceback (most recent call last):
> >>> >>> [Tue Mar 10 13:23:47.191245 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/bin/malaga.py", line
> >>> >>> 11, in <module>
> >>> >>> [Tue Mar 10 13:23:47.193171 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     application = loadapp('config:%s' %
> >>> >>> config_filepath)
> >>> >>> [Tue Mar 10 13:23:47.194516 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
> >>> >>> line 247, in loadapp
> >>> >>> [Tue Mar 10 13:23:47.197398 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return loadobj(APP, uri, name=name, **kw)
> >>> >>> [Tue Mar 10 13:23:47.198877 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
> >>> >>> line 272, in loadobj
> >>> >>> [Tue Mar 10 13:23:47.200383 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return context.create()
> >>> >>> [Tue Mar 10 13:23:47.202156 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
> >>> >>> line 710, in create
> >>> >>> [Tue Mar 10 13:23:47.204564 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return self.object_type.invoke(self)
> >>> >>> [Tue Mar 10 13:23:47.205859 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
> >>> >>> line 146, in invoke
> >>> >>> [Tue Mar 10 13:23:47.207260 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return fix_call(context.object,
> >>> >>> context.global_conf,
> >>> >>> **context.local_conf)
> >>> >>> [Tue Mar 10 13:23:47.208436 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/util.py",
> >>> >>> line 56, in fix_call
> >>> >>> [Tue Mar 10 13:23:47.209944 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     val = callable(*args, **kw)
> >>> >>> [Tue Mar 10 13:23:47.211028 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/middleware.py",
> >>> >>> line 58,
> >>> >>> in make_app
> >>> >>> [Tue Mar 10 13:23:47.212776 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     load_environment(conf, app_conf)
> >>> >>> [Tue Mar 10 13:23:47.213900 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/environment.py",
> >>> >>> line 232,
> >>> >>> in load_environment
> >>> >>> [Tue Mar 10 13:23:47.215991 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     p.load_all(config)
> >>> >>> [Tue Mar 10 13:23:47.217006 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line
> >>> >>> 134, in
> >>> >>> load_all
> >>> >>> [Tue Mar 10 13:23:47.218879 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     load(*plugins)
> >>> >>> [Tue Mar 10 13:23:47.219960 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line
> >>> >>> 148, in
> >>> >>> load
> >>> >>> [Tue Mar 10 13:23:47.221032 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     service = _get_service(plugin)
> >>> >>> [Tue Mar 10 13:23:47.221484 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line
> >>> >>> 254, in
> >>> >>> _get_service
> >>> >>> [Tue Mar 10 13:23:47.222504 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return plugin.load()(name=plugin_name)
> >>> >>> [Tue Mar 10 13:23:47.223038 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
> >>> >>> line 2312, in load
> >>> >>> [Tue Mar 10 13:23:47.227922 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     return self.resolve()
> >>> >>> [Tue Mar 10 13:23:47.229201 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
> >>> >>> line 2318, in resolve
> >>> >>> [Tue Mar 10 13:23:47.230395 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     module = __import__(self.module_name,
> >>> >>> fromlist=['__name__'], level=0)
> >>> >>> [Tue Mar 10 13:23:47.231607 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/plugin.py",
> >>> >>> line 15, in <module>
> >>> >>> [Tue Mar 10 13:23:47.236024 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     from ckanext.spatial.lib import
> >>> >>> save_package_extent,validate_bbox, bbox_query, bbox_query_ordered
> >>> >>> [Tue Mar 10 13:23:47.237258 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/lib/__init__.py",
> >>> >>> line 7, in <module>
> >>> >>> [Tue Mar 10 13:23:47.239120 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     from ckanext.spatial.model import
> >>> >>> PackageExtent
> >>> >>> [Tue Mar 10 13:23:47.240370 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/__init__.py",
> >>> >>> line 9, in <module>
> >>> >>> [Tue Mar 10 13:23:47.242079 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     from package_extent import *
> >>> >>> [Tue Mar 10 13:23:47.243367 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/package_extent.py",
> >>> >>> line 5, in <module>
> >>> >>> [Tue Mar 10 13:23:47.245196 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     from geoalchemy import Geometry,
> >>> >>> GeometryColumn,
> >>> >>> GeometryDDL, GeometryExtensionColumn
> >>> >>> [Tue Mar 10 13:23:47.246382 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/__init__.py",
> >>> >>> line 2, in <module>
> >>> >>> [Tue Mar 10 13:23:47.248250 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     from geoalchemy.base import *
> >>> >>> [Tue Mar 10 13:23:47.249436 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]   File
> >>> >>>
> >>> >>>
> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/base.py",
> >>> >>> line 242, in <module>
> >>> >>> [Tue Mar 10 13:23:47.251387 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291]     class
> >>> >>> SpatialComparator(ColumnProperty.ColumnComparator):
> >>> >>> [Tue Mar 10 13:23:47.252634 2015] [:error] [pid 8508] [client
> >>> >>> 172.16.92.1:33291] AttributeError: type object 'ColumnProperty'
> has
> >>> >>> no
> >>> >>> attribute 'ColumnComparator'
> >>> >>> --
> >>> >>> Isabel M. Ruiz Mellado
> >>> >>> http://about.me/isabelruiz
> >>> >>>
> >>> >>> _______________________________________________
> >>> >>> ckan-dev mailing list
> >>> >>> ckan-dev at lists.okfn.org
> >>> >>> https://lists.okfn.org/mailman/listinfo/ckan-dev
> >>> >>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >>> >>>
> >>> >>
> >>> >>
> >>> >> _______________________________________________
> >>> >> ckan-dev mailing list
> >>> >> ckan-dev at lists.okfn.org
> >>> >> https://lists.okfn.org/mailman/listinfo/ckan-dev
> >>> >> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >>> >>
> >>> >
> >>> >
> >>> > _______________________________________________
> >>> > ckan-dev mailing list
> >>> > ckan-dev at lists.okfn.org
> >>> > https://lists.okfn.org/mailman/listinfo/ckan-dev
> >>> > Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >>> >
> >>> _______________________________________________
> >>> ckan-dev mailing list
> >>> ckan-dev at lists.okfn.org
> >>> https://lists.okfn.org/mailman/listinfo/ckan-dev
> >>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >>
> >>
> >>
> >> _______________________________________________
> >> ckan-dev mailing list
> >> ckan-dev at lists.okfn.org
> >> https://lists.okfn.org/mailman/listinfo/ckan-dev
> >> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >>
> >
> >
> > _______________________________________________
> > ckan-dev mailing list
> > ckan-dev at lists.okfn.org
> > https://lists.okfn.org/mailman/listinfo/ckan-dev
> > Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> >
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150323/463431db/attachment-0003.html>


More information about the ckan-dev mailing list