search

ckan / ckanext-googleanalytics

CKAN extension to integrate Google Analytics data into CKAN. Gives download stats on package pages, list of most popular packages, etc.
GNU Affero General Public License v3.0
35 stars 81 forks source link

Unsupported reflection of expression-based index #29

Open jakubklimek opened 7 years ago

jakubklimek commented 7 years ago

I am getting the following warnings when running the loadanalytics command to retrieve GA statistics (https://github.com/ckan/ckanext-googleanalytics#setting-up-statistics-retrieval-from-google-analytics) with ckan 2.6.1 (not tested with previous versions)

/usr/lib/ckan/dcat/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:53: SAWarning: Skipped unsupported reflection of expression-based index idx_pkg_lname
  ret = fn(self, con, *args, **kw)
/usr/lib/ckan/dcat/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:53: SAWarning: Skipped unsupported reflection of expression-based index idx_pkg_slname
  ret = fn(self, con, *args, **kw)
/usr/lib/ckan/dcat/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:53: SAWarning: Skipped unsupported reflection of expression-based index idx_pkg_suname
  ret = fn(self, con, *args, **kw)
/usr/lib/ckan/dcat/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:53: SAWarning: Skipped unsupported reflection of expression-based index idx_pkg_uname
  ret = fn(self, con, *args, **kw)
/usr/lib/ckan/dcat/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py:53: SAWarning: Skipped unsupported reflection of expression-based index idx_user_name_index
  ret = fn(self, con, *args, **kw)

Any ideas?

LukeTully commented 7 years ago

Also seeing this. Same version.

gleb-rudenko commented 7 years ago

Will take a loook

gleb-rudenko commented 7 years ago

Did some investigation and I don't think it's GA issue, it's more CKAN issue and SqlAlchemy version it using. google some similar issues: https://lists.okfn.org/pipermail/ckan-dev/2014-September/008096.html

there are more.