search

depositar / ckanext-data-depositario

CKAN extension for depositar
https://data.depositar.io
Other
3 stars 3 forks source link

無法產生表格資料之預覽 #5

Closed u10313335 closed 3 years ago

u10313335 commented 5 years ago

預期行為

要顯示已上傳的表格資料之預覽，如範例。

實際行為

無法顯示預覽，或是發生如 #4 般上傳到一半就停止的情形。切換到該筆資料的編輯頁面下的「DataStore」頁籤，會出現類似以下的錯誤訊息：

錯誤： File "local/lib/python2.7/site-packages/apscheduler/scheduler.py", line 512, in _run_job retval = job.func(*job.args, **job.kwargs) File "src/datapusher/datapusher/jobs.py", line 324, in push_to_datastore resource = get_resource(resource_id, ckan_url, api_key) File "src/datapusher/datapusher/jobs.py", line 274, in get_resource 'Authorization': api_key} File "local/lib/python2.7/site-packages/requests/api.py", line 110, in post return request('post', url, data=data, json=json, **kwargs) File "local/lib/python2.7/site-packages/requests/api.py", line 56, in request return session.request(method=method, url=url, **kwargs) File "local/lib/python2.7/site-packages/requests/sessions.py", line 475, in request resp = self.send(prep, **send_kwargs) File "local/lib/python2.7/site-packages/requests/sessions.py", line 596, in send r = adapter.send(request, **kwargs) File "local/lib/python2.7/site-packages/requests/adapters.py", line 487, in send raise ConnectionError(e, request=request) ConnectionError(MaxRetryError("HTTPSConnectionPool(host='demo.depositar.io', port=443): Max retries exceeded with url: /api/3/action/resource_show (Caused by NewConnectionError('<requests.packages.urllib3.connection.VerifiedHTTPSConnection object at 0x7faca28fd790>: Failed to establish a new connection: [Errno -2] Name or service not known',))",),)

如何重現此情形

上傳表格格式之資料 (CSV、XLS 等) 後，瀏覽該筆已上傳資料。

u10313335 commented 5 years ago

經數次嘗試均無法重現此錯誤。

根據錯誤訊息，主因應是 DataPusher 套件 (負責將 CSV 儲存至 DataStore 資料庫) 與 DataStore 連線時，無法正確解析網域名稱。

目前採取的措施為：

  1. 在伺服器網路設定加入 Google DNS (8.8.8.8)
  2. 更新 DataPusher 版本至 0.0.15

預計先觀察一段時間，看是否仍有此問題。

u10313335 commented 3 years ago

後續沒有發生類似問題回報，故關閉此議題。