{"action":"created","issue":{"url":"https://api.github.com/repos/opencivicdata/pupa/issues/316","repository_url":"https://api.github.com/repos/opencivicdata/pupa","labels_url":"https://api.github.com/repos/opencivicdata/pupa/issues/316/labels{/name}","comments_url":"https://api.github.com/repos/opencivicdata/pupa/issues/316/comments","events_url":"https://api.github.com/repos/opencivicdata/pupa/issues/316/events","html_url":"https://github.com/opencivicdata/pupa/issues/316","id":354977436,"node_id":"MDU6SXNzdWUzNTQ5Nzc0MzY=","number":316,"title":"Relation \"opencivicdata_jurisdiction\" does not exist","user":{"login":"jmillxyz","id":531476,"node_id":"MDQ6VXNlcjUzMTQ3Ng==","avatar_url":"https://avatars3.githubusercontent.com/u/531476?v=4","gravatar_id":"","url":"https://api.github.com/users/jmillxyz","html_url":"https://github.com/jmillxyz","followers_url":"https://api.github.com/users/jmillxyz/followers","following_url":"https://api.github.com/users/jmillxyz/following{/other_user}","gists_url":"https://api.github.com/users/jmillxyz/gists{/gist_id}","starred_url":"https://api.github.com/users/jmillxyz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmillxyz/subscriptions","organizations_url":"https://api.github.com/users/jmillxyz/orgs","repos_url":"https://api.github.com/users/jmillxyz/repos","events_url":"https://api.github.com/users/jmillxyz/events{/privacy}","received_events_url":"https://api.github.com/users/jmillxyz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-08-29T03:04:25Z","updated_at":"2018-09-04T16:26:12Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI'm running \r\n```$ docker-compose up -d postgres && docker-compose run --rm scrape tx --fastmode```\r\nand get the following error:\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/commands/update.py\", line 305, in do_handle\r\n    report['scrape'] = self.do_scrape(juris, args, scrapers)\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/commands/update.py\", line 173, in do_scrape\r\n    report[scraper_name] = scraper.do_scrape(**scrape_args)\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/scrape/base.py\", line 111, in do_scrape\r\n    for obj in self.scrape(**kwargs) or []:\r\n  File \"/opt/openstates/openstates/openstates/tx/bills.py\", line 82, in scrape\r\n    for item in analysis_files:\r\n  File \"/opt/openstates/openstates/openstates/tx/bills.py\", line 54, in _get_ftp_files\r\n    for item in self._get_ftp_files(root, '/'.join([dir_, name])):\r\n  File \"/opt/openstates/openstates/openstates/tx/bills.py\", line 54, in _get_ftp_files\r\n    for item in self._get_ftp_files(root, '/'.join([dir_, name])):\r\n  File \"/opt/openstates/openstates/openstates/tx/bills.py\", line 33, in _get_ftp_files\r\n    ftp = ftplib.FTP(root)\r\n  File \"/usr/lib/python3.6/ftplib.py\", line 117, in __init__\r\n    self.connect(host)\r\n  File \"/usr/lib/python3.6/ftplib.py\", line 152, in connect\r\n    source_address=self.source_address)\r\n  File \"/usr/lib/python3.6/socket.py\", line 724, in create_connection\r\n    raise err\r\n  File \"/usr/lib/python3.6/socket.py\", line 713, in create_connection\r\n    sock.connect(sa)\r\nConnectionRefusedError: [Errno 111] Connection refused\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/backends/utils.py\", line 85, in _execute\r\n    return self.cursor.execute(sql, params)\r\npsycopg2.ProgrammingError: relation \"opencivicdata_jurisdiction\" does not exist\r\nLINE 1: ..., \"opencivicdata_jurisdiction\".\"division_id\" FROM \"opencivic...\r\n                                                             ^\r\n\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"/opt/openstates/venv-pupa//bin/pupa\", line 11, in <module>\r\n    load_entry_point('pupa', 'console_scripts', 'pupa')()\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/__main__.py\", line 68, in main\r\n    subcommands[args.subcommand].handle(args, other)\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/commands/update.py\", line 260, in handle\r\n    return self.do_handle(args, other, juris)\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/commands/update.py\", line 314, in do_handle\r\n    save_report(report, juris.jurisdiction_id)\r\n  File \"/usr/lib/python3.6/contextlib.py\", line 52, in inner\r\n    return func(*args, **kwds)\r\n  File \"/opt/openstates/venv-pupa/src/pupa/pupa/cli/commands/update.py\", line 76, in save_report\r\n    JurisdictionModel.objects.get(pk=jurisdiction)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/manager.py\", line 82, in manager_method\r\n    return getattr(self.get_queryset(), name)(*args, **kwargs)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/query.py\", line 393, in get\r\n    num = len(clone)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/query.py\", line 250, in __len__\r\n    self._fetch_all()\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/query.py\", line 1183, in _fetch_all\r\n    self._result_cache = list(self._iterable_class(self))\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/query.py\", line 54, in __iter__\r\n    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/models/sql/compiler.py\", line 1061, in execute_sql\r\n    cursor.execute(sql, params)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/backends/utils.py\", line 68, in execute\r\n    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/backends/utils.py\", line 77, in _execute_with_wrappers\r\n    return executor(sql, params, many, context)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/backends/utils.py\", line 85, in _execute\r\n    return self.cursor.execute(sql, params)\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/utils.py\", line 89, in __exit__\r\n    raise dj_exc_value.with_traceback(traceback) from exc_value\r\n  File \"/opt/openstates/venv-pupa/lib/python3.6/site-packages/django/db/backends/utils.py\", line 85, in _execute\r\n    return self.cursor.execute(sql, params)\r\ndjango.db.utils.ProgrammingError: relation \"opencivicdata_jurisdiction\" does not exist\r\nLINE 1: ..., \"opencivicdata_jurisdiction\".\"division_id\" FROM \"opencivic...\r\n```\r\n\r\nIs there a missing table that needs to be added to pupa's migrations?"},"comment":{"url":"https://api.github.com/repos/opencivicdata/pupa/issues/comments/418432312","html_url":"https://github.com/opencivicdata/pupa/issues/316#issuecomment-418432312","issue_url":"https://api.github.com/repos/opencivicdata/pupa/issues/316","id":418432312,"node_id":"MDEyOklzc3VlQ29tbWVudDQxODQzMjMxMg==","user":{"login":"jmillxyz","id":531476,"node_id":"MDQ6VXNlcjUzMTQ3Ng==","avatar_url":"https://avatars3.githubusercontent.com/u/531476?v=4","gravatar_id":"","url":"https://api.github.com/users/jmillxyz","html_url":"https://github.com/jmillxyz","followers_url":"https://api.github.com/users/jmillxyz/followers","following_url":"https://api.github.com/users/jmillxyz/following{/other_user}","gists_url":"https://api.github.com/users/jmillxyz/gists{/gist_id}","starred_url":"https://api.github.com/users/jmillxyz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmillxyz/subscriptions","organizations_url":"https://api.github.com/users/jmillxyz/orgs","repos_url":"https://api.github.com/users/jmillxyz/repos","events_url":"https://api.github.com/users/jmillxyz/events{/privacy}","received_events_url":"https://api.github.com/users/jmillxyz/received_events","type":"User","site_admin":false},"created_at":"2018-09-04T16:26:12Z","updated_at":"2018-09-04T16:26:12Z","author_association":"NONE","body":"Yep, covered here: https://github.com/openstates/openstates#getting-started"}}
{"actor":{"display_login":"jmillxyz"}}