[ckan-dev] CKAN 2.3 errors spatial

Julio Acuña julio.acuna.carrillo at gmail.com
Tue Mar 17 17:44:14 UTC 2015


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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150317/d5db2ce1/attachment-0003.html>


More information about the ckan-dev mailing list