{"action":"opened","issue":{"url":"https://api.github.com/repos/UrbanCCD-UChicago/plenario/issues/338","repository_url":"https://api.github.com/repos/UrbanCCD-UChicago/plenario","labels_url":"https://api.github.com/repos/UrbanCCD-UChicago/plenario/issues/338/labels{/name}","comments_url":"https://api.github.com/repos/UrbanCCD-UChicago/plenario/issues/338/comments","events_url":"https://api.github.com/repos/UrbanCCD-UChicago/plenario/issues/338/events","html_url":"https://github.com/UrbanCCD-UChicago/plenario/issues/338","id":306815945,"number":338,"title":"Docker compose installation - does not add CSV data","user":{"login":"gioppoluca","id":1488715,"avatar_url":"https://avatars3.githubusercontent.com/u/1488715?v=4","gravatar_id":"","url":"https://api.github.com/users/gioppoluca","html_url":"https://github.com/gioppoluca","followers_url":"https://api.github.com/users/gioppoluca/followers","following_url":"https://api.github.com/users/gioppoluca/following{/other_user}","gists_url":"https://api.github.com/users/gioppoluca/gists{/gist_id}","starred_url":"https://api.github.com/users/gioppoluca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gioppoluca/subscriptions","organizations_url":"https://api.github.com/users/gioppoluca/orgs","repos_url":"https://api.github.com/users/gioppoluca/repos","events_url":"https://api.github.com/users/gioppoluca/events{/privacy}","received_events_url":"https://api.github.com/users/gioppoluca/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-20T10:56:01Z","updated_at":"2018-03-20T10:56:01Z","closed_at":null,"author_association":"NONE","body":"I've installed the docker compose distribution and I'm receiving this error:\r\nserver_1    | 2018-03-20 10:49:58 - INFO - werkzeug._log:87 - 158.102.240.178 - - [20/Mar/2018 10:49:58] \"POST /admin/add?dataset_url=https%3A%2F%2Fdata.cityofchicago.org%2FPublic-Safety%2FCrimes-2010%2Fq4de-h6yq HTTP/1.1\" 200 -\r\nworker_1    | [2018-03-20 10:49:58,608: INFO/PoolWorker-1] Begin. (name: \"crimes_2010_2\")\r\nworker_1    | [2018-03-20 10:49:58,608: INFO/PoolWorker-1] Begin. (name: \"crimes_2010_2\")\r\nworker_1    | [2018-03-20 10:49:58,623: ERROR/PoolWorker-1] Task plenario.tasks.add_dataset[215b1370-5705-41c2-abc8-7ef3e861faab] raised unexpected: InvalidRequestError('This Session\\'s transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.DataError) Geometry type (Point) does not match column type (Polygon)\\n [SQL: \\'UPDATE meta_master SET bbox=ST_GeomFromEWKT(%(bbox)s), column_names=%(column_names)s WHERE meta_master.source_url_hash = %(meta_master_source_url_hash)s\\'] [parameters: {\\'bbox\\': \\'0101000020E6100000023164D064D62040C65455C3D9A94640\\', \\'column_names\\': \\'{\"sensor\": \"VARCHAR\", \"time\": \"TIMESTAMP WITHOUT TIME ZONE\", \"status\": \"VARCHAR\", \"streamcode\": \"VARCHAR\", \"longitude\": \"DOUBLE PRECISION\", \"latitude\": \"DOUBLE PRECISION\"}\\', \\'meta_master_source_url_hash\\': \\'53e2b11daf436920a92044d04b111d1d\\'}]',)\r\nworker_1    | Traceback (most recent call last):\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/celery/app/trace.py\", line 367, in trace_task\r\nworker_1    |     R = retval = fun(*args, **kwargs)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/celery/app/trace.py\", line 622, in __protected_call__\r\nworker_1    |     return self.run(*args, **kwargs)\r\nworker_1    |   File \"/app/plenario/tasks.py\", line 64, in add_dataset\r\nworker_1    |     meta = get_meta(name)\r\nworker_1    |   File \"/app/plenario/tasks.py\", line 38, in get_meta\r\nworker_1    |     result = query.first()\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2755, in first\r\nworker_1    |     ret = list(self[0:1])\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2547, in __getitem__\r\nworker_1    |     return list(res)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2855, in __iter__\r\nworker_1    |     return self._execute_and_instances(context)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2876, in _execute_and_instances\r\nworker_1    |     close_with_result=True)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2885, in _get_bind_args\r\nworker_1    |     **kw\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py\", line 2867, in _connection_from_session\r\nworker_1    |     conn = self.session.connection(**kw)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py\", line 998, in connection\r\nworker_1    |     execution_options=execution_options)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py\", line 1003, in _connection_for_bind\r\nworker_1    |     engine, execution_options)\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py\", line 382, in _connection_for_bind\r\nworker_1    |     self._assert_active()\r\nworker_1    |   File \"/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py\", line 276, in _assert_active\r\nworker_1    |     % self._rollback_exception\r\nworker_1    | sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.DataError) Geometry type (Point) does not match column type (Polygon)\r\nworker_1    |  [SQL: 'UPDATE meta_master SET bbox=ST_GeomFromEWKT(%(bbox)s), column_names=%(column_names)s WHERE meta_master.source_url_hash = %(meta_master_source_url_hash)s'] [parameters: {'bbox': '0101000020E6100000023164D064D62040C65455C3D9A94640', 'column_names': '{\"sensor\": \"VARCHAR\", \"time\": \"TIMESTAMP WITHOUT TIME ZONE\", \"status\": \"VARCHAR\", \"streamcode\": \"VARCHAR\", \"longitude\": \"DOUBLE PRECISION\", \"latitude\": \"DOUBLE PRECISION\"}', 'meta_master_source_url_hash': '53e2b11daf436920a92044d04b111d1d'}]\r\n\r\n\r\nSeems strange any hints on why there is this behaviour?\r\nThanks"}}
{"actor":{"display_login":"gioppoluca"}}