[ckan-dev] CKAN 2.3 errors spatial
Adrià Mercader
adria.mercader at okfn.org
Fri Mar 20 17:20:07 UTC 2015
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
>
More information about the ckan-dev
mailing list