search

freelawproject / courtlistener

A fully-searchable and accessible archive of court data including growing repositories of opinions, oral arguments, judges, judicial financial records, and federal filings.
https://www.courtlistener.com
Other
553 stars 151 forks source link

`make_dev_data` `document_parsing_exception` when making an Opinion Document #3767

Closed david-clark-1043 closed 9 months ago

david-clark-1043 commented 9 months ago

Following a fresh git clone and the wiki's dev instructions. Ran into an error making dev data.

Running

 docker exec -it cl-django python /opt/courtlistener/manage.py make_dev_data

Results in the following abbreviated logs:

INFO 2024-02-11 20:50:41,010 (/opt/courtlistener/cl/lib/management/commands/make_dev_data.py handle): "Creating dummy data. Making at least 10 objects of each type."
INFO 2024-02-11 20:50:41,010 (/opt/courtlistener/cl/lib/management/commands/make_dev_data.py handle): "Making 10 dockets and all their dependent objects"
... sql debug logs ...
... stacktrace ...
celery.utils.serialization.UnpickleableExceptionWrapper: BadRequestError(
...
body={
    "error": {
        "type": "document_parsing_exception",
        "reason": "[1:3081] failed to parse field [cluster_child] of type [text] in document with id 'o_1'. Preview of field's value: '{parent=1, name=opinion}'",
        "caused_by": {
            "type": "illegal_state_exception",
            "reason": "Can't get text on a START_OBJECT at 1:3053",
        },
    },
    "status": 400,
}
...
Full Output ```python INFO 2024-02-11 20:50:41,010 (/opt/courtlistener/cl/lib/management/commands/make_dev_data.py handle): "Creating dummy data. Making at least 10 objects of each type." INFO 2024-02-11 20:50:41,010 (/opt/courtlistener/cl/lib/management/commands/make_dev_data.py handle): "Making 10 dockets and all their dependent objects" DEBUG 2024-02-11 20:50:41,025 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.006) UPDATE "search_court" SET "parent_court_id" = NULL, "pacer_court_id" = NULL, "pacer_has_rss_feed" = NULL, "pacer_rss_entry_types" = '', "date_last_pacer_contact" = NULL, "fjc_court_id" = '', "date_modified" = '2024-02-12 04:50:41.011362+00:00'::timestamptz, "in_use" = true, "has_opinion_scraper" = false, "has_oral_argument_scraper" = false, "position" = 971.415, "citation_string" = '', "short_name" = 'District court for the Zoo', "full_name" = 'Appeals court for the Eruptanyom', "url" = 'https://bowman-dean.com/', "start_date" = NULL, "end_date" = NULL, "jurisdiction" = 'TRX', "notes" = '' WHERE "search_court"."id" = 'bilyd'; args=('', '', datetime.datetime(2024, 2, 12, 4, 50, 41, 11362, tzinfo=datetime.timezone.utc), True, False, False, 971.415, '', 'District court for the Zoo', 'Appeals court for the Eruptanyom', 'https://bowman-dean.com/', 'TRX', '', 'bilyd'); alias=default" DEBUG 2024-02-11 20:50:41,028 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.002) INSERT INTO "search_court" ("id", "parent_court_id", "pacer_court_id", "pacer_has_rss_feed", "pacer_rss_entry_types", "date_last_pacer_contact", "fjc_court_id", "date_modified", "in_use", "has_opinion_scraper", "has_oral_argument_scraper", "position", "citation_string", "short_name", "full_name", "url", "start_date", "end_date", "jurisdiction", "notes") VALUES ('bilyd', NULL, NULL, NULL, '', NULL, '', '2024-02-12 04:50:41.026136+00:00'::timestamptz, true, false, false, 971.415, '', 'District court for the Zoo', 'Appeals court for the Eruptanyom', 'https://bowman-dean.com/', NULL, NULL, 'TRX', ''); args=('bilyd', None, None, None, '', None, '', datetime.datetime(2024, 2, 12, 4, 50, 41, 26136, tzinfo=datetime.timezone.utc), True, False, False, 971.415, '', 'District court for the Zoo', 'Appeals court for the Eruptanyom', 'https://bowman-dean.com/', None, None, 'TRX', ''); alias=default" DEBUG 2024-02-11 20:50:41,028 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) UPDATE "search_court" SET "parent_court_id" = NULL, "pacer_court_id" = NULL, "pacer_has_rss_feed" = NULL, "pacer_rss_entry_types" = '', "date_last_pacer_contact" = NULL, "fjc_court_id" = '', "date_modified" = '2024-02-12 04:50:41.028505+00:00'::timestamptz, "in_use" = true, "has_opinion_scraper" = false, "has_oral_argument_scraper" = false, "position" = 141.257, "citation_string" = '', "short_name" = 'District court for the Zoo', "full_name" = 'Superior court for the Zoo', "url" = 'https://house-garcia.org/', "start_date" = NULL, "end_date" = NULL, "jurisdiction" = 'SS', "notes" = '' WHERE "search_court"."id" = 'nawqd'; args=('', '', datetime.datetime(2024, 2, 12, 4, 50, 41, 28505, tzinfo=datetime.timezone.utc), True, False, False, 141.257, '', 'District court for the Zoo', 'Superior court for the Zoo', 'https://house-garcia.org/', 'SS', '', 'nawqd'); alias=default" DEBUG 2024-02-11 20:50:41,029 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) INSERT INTO "search_court" ("id", "parent_court_id", "pacer_court_id", "pacer_has_rss_feed", "pacer_rss_entry_types", "date_last_pacer_contact", "fjc_court_id", "date_modified", "in_use", "has_opinion_scraper", "has_oral_argument_scraper", "position", "citation_string", "short_name", "full_name", "url", "start_date", "end_date", "jurisdiction", "notes") VALUES ('nawqd', NULL, NULL, NULL, '', NULL, '', '2024-02-12 04:50:41.029013+00:00'::timestamptz, true, false, false, 141.257, '', 'District court for the Zoo', 'Superior court for the Zoo', 'https://house-garcia.org/', NULL, NULL, 'SS', ''); args=('nawqd', None, None, None, '', None, '', datetime.datetime(2024, 2, 12, 4, 50, 41, 29013, tzinfo=datetime.timezone.utc), True, False, False, 141.257, '', 'District court for the Zoo', 'Superior court for the Zoo', 'https://house-garcia.org/', None, None, 'SS', ''); alias=default" DEBUG 2024-02-11 20:50:41,035 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.004) INSERT INTO "search_docket" ("date_created", "date_modified", "source", "court_id", "appeal_from_id", "appeal_from_str", "originating_court_information_id", "idb_data_id", "assigned_to_id", "assigned_to_str", "referred_to_id", "referred_to_str", "panel_str", "date_last_index", "date_cert_granted", "date_cert_denied", "date_argued", "date_reargued", "date_reargument_denied", "date_filed", "date_terminated", "date_last_filing", "case_name_short", "case_name", "case_name_full", "slug", "docket_number", "docket_number_core", "pacer_case_id", "cause", "nature_of_suit", "jury_demand", "jurisdiction_type", "appellate_fee_status", "appellate_case_type_information", "mdl_status", "filepath_local", "filepath_ia", "filepath_ia_json", "ia_upload_failure_count", "ia_needs_upload", "ia_date_first_change", "view_count", "date_blocked", "blocked") VALUES ('2024-02-12 04:50:41.031478+00:00'::timestamptz, '2024-02-12 04:50:41.031482+00:00'::timestamptz, 30, 'bilyd', 'nawqd', '', NULL, NULL, NULL, '', NULL, '', '', NULL, NULL, NULL, '2019-05-21'::date, NULL, NULL, NULL, NULL, NULL, '', 'Cruz, Hebert and Stokes v. Alvarado LLC', 'Adams, Porter and Frazier, White-Deleon, Holmes-Davies, Brown, Marsh and Lester, and Davis Inc v. Andrew Reed, Dennis Allen, Shawn Ward, Kendra Curry, and Alicia Campbell', 'cruz-hebert-and-stokes-v-alvarado-llc', '2:54-cv-35708', '5435708', 175462, '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, 0, NULL, false) RETURNING "search_docket"."id"; args=(datetime.datetime(2024, 2, 12, 4, 50, 41, 31478, tzinfo=datetime.timezone.utc), datetime.datetime(2024, 2, 12, 4, 50, 41, 31482, tzinfo=datetime.timezone.utc), Int2(30), 'bilyd', 'nawqd', '', None, None, None, '', None, '', '', None, None, None, datetime.date(2019, 5, 21), None, None, None, None, None, '', 'Cruz, Hebert and Stokes v. Alvarado LLC', 'Adams, Porter and Frazier, White-Deleon, Holmes-Davies, Brown, Marsh and Lester, and Davis Inc v. Andrew Reed, Dennis Allen, Shawn Ward, Kendra Curry, and Alicia Campbell', 'cruz-hebert-and-stokes-v-alvarado-llc', '2:54-cv-35708', '5435708', 175462, '', '', '', '', '', '', '', '', '', '', None, None, None, Int4(0), None, False); alias=default" DEBUG 2024-02-11 20:50:41,039 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "search_docket"."id", "search_docket"."date_created", "search_docket"."date_modified", "search_docket"."source", "search_docket"."court_id", "search_docket"."appeal_from_id", "search_docket"."appeal_from_str", "search_docket"."originating_court_information_id", "search_docket"."idb_data_id", "search_docket"."assigned_to_id", "search_docket"."assigned_to_str", "search_docket"."referred_to_id", "search_docket"."referred_to_str", "search_docket"."panel_str", "search_docket"."date_last_index", "search_docket"."date_cert_granted", "search_docket"."date_cert_denied", "search_docket"."date_argued", "search_docket"."date_reargued", "search_docket"."date_reargument_denied", "search_docket"."date_filed", "search_docket"."date_terminated", "search_docket"."date_last_filing", "search_docket"."case_name_short", "search_docket"."case_name", "search_docket"."case_name_full", "search_docket"."slug", "search_docket"."docket_number", "search_docket"."docket_number_core", "search_docket"."pacer_case_id", "search_docket"."cause", "search_docket"."nature_of_suit", "search_docket"."jury_demand", "search_docket"."jurisdiction_type", "search_docket"."appellate_fee_status", "search_docket"."appellate_case_type_information", "search_docket"."mdl_status", "search_docket"."filepath_local", "search_docket"."filepath_ia", "search_docket"."filepath_ia_json", "search_docket"."ia_upload_failure_count", "search_docket"."ia_needs_upload", "search_docket"."ia_date_first_change", "search_docket"."view_count", "search_docket"."date_blocked", "search_docket"."blocked" FROM "search_docket" WHERE "search_docket"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:41,059 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_court"."id", "search_court"."parent_court_id", "search_court"."pacer_court_id", "search_court"."pacer_has_rss_feed", "search_court"."pacer_rss_entry_types", "search_court"."date_last_pacer_contact", "search_court"."fjc_court_id", "search_court"."date_modified", "search_court"."in_use", "search_court"."has_opinion_scraper", "search_court"."has_oral_argument_scraper", "search_court"."position", "search_court"."citation_string", "search_court"."short_name", "search_court"."full_name", "search_court"."url", "search_court"."start_date", "search_court"."end_date", "search_court"."jurisdiction", "search_court"."notes" FROM "search_court" WHERE "search_court"."id" = 'bilyd' LIMIT 21; args=('bilyd',); alias=default" DEBUG 2024-02-11 20:50:41,061 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT 1 AS "a" FROM "search_bankruptcyinformation" WHERE "search_bankruptcyinformation"."docket_id" = 1 LIMIT 1; args=(Int4(1), 1); alias=default" DEBUG 2024-02-11 20:50:41,061 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT 1 AS "a" FROM "search_bankruptcyinformation" WHERE "search_bankruptcyinformation"."docket_id" = 1 LIMIT 1; args=(Int4(1), 1); alias=default" DEBUG 2024-02-11 20:50:41,065 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.003) SELECT "people_db_party"."id", "people_db_party"."date_created", "people_db_party"."date_modified", "people_db_party"."name", "people_db_party"."extra_info" FROM "people_db_party" INNER JOIN "people_db_partytype" ON ("people_db_party"."id" = "people_db_partytype"."party_id") WHERE "people_db_partytype"."docket_id" = 1; args=(1,); alias=default" /usr/local/lib/python3.12/site-packages/elasticsearch/_sync/client/__init__.py:397: SecurityWarning: Connecting to 'https://cl-es:9200' using TLS with verify_certs=False is insecure _transport = transport_class( DEBUG 2024-02-11 20:50:42,090 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.002) INSERT INTO "search_opinioncluster" ("date_created", "date_modified", "docket_id", "judges", "date_filed", "date_filed_is_approximate", "slug", "case_name_short", "case_name", "case_name_full", "scdb_id", "scdb_decision_direction", "scdb_votes_majority", "scdb_votes_minority", "source", "procedural_history", "attorneys", "nature_of_suit", "posture", "syllabus", "headnotes", "summary", "disposition", "history", "other_dates", "cross_reference", "correction", "citation_count", "precedential_status", "date_blocked", "blocked", "filepath_json_harvard", "arguments", "headmatter") VALUES ('2024-02-12 04:50:42.088192+00:00'::timestamptz, '2024-02-12 04:50:42.088202+00:00'::timestamptz, 1, '', '1994-01-09'::date, false, 'williams-v-sutton-smith-and-meyer', '', 'Williams v. Sutton, Smith and Meyer', 'Bautista Inc, Clay, Perkins and Campbell, Wilson and Sons, Webster-Carpenter, and Pennington, Ware and Pena v. Barbara Taylor, Veronica Bautista, Stephen Burnett, Isaac Conley, and Marvin Chandler', '', NULL, NULL, NULL, 'RU', '', '', '', '', '', '', '', '', '', '', '', '', 0, 'In-chambers', NULL, false, '', '', '') RETURNING "search_opinioncluster"."id"; args=(datetime.datetime(2024, 2, 12, 4, 50, 42, 88192, tzinfo=datetime.timezone.utc), datetime.datetime(2024, 2, 12, 4, 50, 42, 88202, tzinfo=datetime.timezone.utc), 1, '', datetime.date(1994, 1, 9), False, 'williams-v-sutton-smith-and-meyer', '', 'Williams v. Sutton, Smith and Meyer', 'Bautista Inc, Clay, Perkins and Campbell, Wilson and Sons, Webster-Carpenter, and Pennington, Ware and Pena v. Barbara Taylor, Veronica Bautista, Stephen Burnett, Isaac Conley, and Marvin Chandler', '', None, None, None, 'RU', '', '', '', '', '', '', '', '', '', '', '', '', Int4(0), 'In-chambers', None, False, '', '', ''); alias=default" DEBUG 2024-02-11 20:50:42,091 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinioncluster"."id", "search_opinioncluster"."date_created", "search_opinioncluster"."date_modified", "search_opinioncluster"."docket_id", "search_opinioncluster"."judges", "search_opinioncluster"."date_filed", "search_opinioncluster"."date_filed_is_approximate", "search_opinioncluster"."slug", "search_opinioncluster"."case_name_short", "search_opinioncluster"."case_name", "search_opinioncluster"."case_name_full", "search_opinioncluster"."scdb_id", "search_opinioncluster"."scdb_decision_direction", "search_opinioncluster"."scdb_votes_majority", "search_opinioncluster"."scdb_votes_minority", "search_opinioncluster"."source", "search_opinioncluster"."procedural_history", "search_opinioncluster"."attorneys", "search_opinioncluster"."nature_of_suit", "search_opinioncluster"."posture", "search_opinioncluster"."syllabus", "search_opinioncluster"."headnotes", "search_opinioncluster"."summary", "search_opinioncluster"."disposition", "search_opinioncluster"."history", "search_opinioncluster"."other_dates", "search_opinioncluster"."cross_reference", "search_opinioncluster"."correction", "search_opinioncluster"."citation_count", "search_opinioncluster"."precedential_status", "search_opinioncluster"."date_blocked", "search_opinioncluster"."blocked", "search_opinioncluster"."filepath_json_harvard", "search_opinioncluster"."arguments", "search_opinioncluster"."headmatter" FROM "search_opinioncluster" WHERE "search_opinioncluster"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,092 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_docket"."id", "search_docket"."date_created", "search_docket"."date_modified", "search_docket"."source", "search_docket"."court_id", "search_docket"."appeal_from_id", "search_docket"."appeal_from_str", "search_docket"."originating_court_information_id", "search_docket"."idb_data_id", "search_docket"."assigned_to_id", "search_docket"."assigned_to_str", "search_docket"."referred_to_id", "search_docket"."referred_to_str", "search_docket"."panel_str", "search_docket"."date_last_index", "search_docket"."date_cert_granted", "search_docket"."date_cert_denied", "search_docket"."date_argued", "search_docket"."date_reargued", "search_docket"."date_reargument_denied", "search_docket"."date_filed", "search_docket"."date_terminated", "search_docket"."date_last_filing", "search_docket"."case_name_short", "search_docket"."case_name", "search_docket"."case_name_full", "search_docket"."slug", "search_docket"."docket_number", "search_docket"."docket_number_core", "search_docket"."pacer_case_id", "search_docket"."cause", "search_docket"."nature_of_suit", "search_docket"."jury_demand", "search_docket"."jurisdiction_type", "search_docket"."appellate_fee_status", "search_docket"."appellate_case_type_information", "search_docket"."mdl_status", "search_docket"."filepath_local", "search_docket"."filepath_ia", "search_docket"."filepath_ia_json", "search_docket"."ia_upload_failure_count", "search_docket"."ia_needs_upload", "search_docket"."ia_date_first_change", "search_docket"."view_count", "search_docket"."date_blocked", "search_docket"."blocked" FROM "search_docket" WHERE "search_docket"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,094 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "people_db_person"."id" FROM "people_db_person" INNER JOIN "search_opinioncluster_non_participating_judges" ON ("people_db_person"."id" = "search_opinioncluster_non_participating_judges"."person_id") WHERE "search_opinioncluster_non_participating_judges"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,095 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_court"."id", "search_court"."parent_court_id", "search_court"."pacer_court_id", "search_court"."pacer_has_rss_feed", "search_court"."pacer_rss_entry_types", "search_court"."date_last_pacer_contact", "search_court"."fjc_court_id", "search_court"."date_modified", "search_court"."in_use", "search_court"."has_opinion_scraper", "search_court"."has_oral_argument_scraper", "search_court"."position", "search_court"."citation_string", "search_court"."short_name", "search_court"."full_name", "search_court"."url", "search_court"."start_date", "search_court"."end_date", "search_court"."jurisdiction", "search_court"."notes" FROM "search_court" WHERE "search_court"."id" = 'bilyd' LIMIT 21; args=('bilyd',); alias=default" DEBUG 2024-02-11 20:50:42,096 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "people_db_person"."id", "people_db_person"."date_created", "people_db_person"."date_modified", "people_db_person"."is_alias_of_id", "people_db_person"."date_completed", "people_db_person"."fjc_id", "people_db_person"."slug", "people_db_person"."name_first", "people_db_person"."name_middle", "people_db_person"."name_last", "people_db_person"."name_suffix", "people_db_person"."date_dob", "people_db_person"."date_granularity_dob", "people_db_person"."date_dod", "people_db_person"."date_granularity_dod", "people_db_person"."dob_city", "people_db_person"."dob_state", "people_db_person"."dob_country", "people_db_person"."dod_city", "people_db_person"."dod_state", "people_db_person"."dod_country", "people_db_person"."gender", "people_db_person"."religion", "people_db_person"."ftm_total_received", "people_db_person"."ftm_eid", "people_db_person"."has_photo" FROM "people_db_person" INNER JOIN "search_opinioncluster_panel" ON ("people_db_person"."id" = "search_opinioncluster_panel"."person_id") WHERE "search_opinioncluster_panel"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,098 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "search_citation"."id", "search_citation"."cluster_id", "search_citation"."volume", "search_citation"."reporter", "search_citation"."page", "search_citation"."type" FROM "search_citation" WHERE "search_citation"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,099 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "search_opinion"."id" FROM "search_opinion" WHERE "search_opinion"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,099 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id" FROM "people_db_person" INNER JOIN "search_opinioncluster_panel" ON ("people_db_person"."id" = "search_opinioncluster_panel"."person_id") WHERE "search_opinioncluster_panel"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,100 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT COUNT(*) AS "__count" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 8); args=(1, Int2(8)); alias=default" DEBUG 2024-02-11 20:50:42,101 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT COUNT(*) AS "__count" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 6); args=(1, Int2(6)); alias=default" DEBUG 2024-02-11 20:50:42,174 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinioncluster"."id", "search_opinioncluster"."date_created", "search_opinioncluster"."date_modified", "search_opinioncluster"."docket_id", "search_opinioncluster"."judges", "search_opinioncluster"."date_filed", "search_opinioncluster"."date_filed_is_approximate", "search_opinioncluster"."slug", "search_opinioncluster"."case_name_short", "search_opinioncluster"."case_name", "search_opinioncluster"."case_name_full", "search_opinioncluster"."scdb_id", "search_opinioncluster"."scdb_decision_direction", "search_opinioncluster"."scdb_votes_majority", "search_opinioncluster"."scdb_votes_minority", "search_opinioncluster"."source", "search_opinioncluster"."procedural_history", "search_opinioncluster"."attorneys", "search_opinioncluster"."nature_of_suit", "search_opinioncluster"."posture", "search_opinioncluster"."syllabus", "search_opinioncluster"."headnotes", "search_opinioncluster"."summary", "search_opinioncluster"."disposition", "search_opinioncluster"."history", "search_opinioncluster"."other_dates", "search_opinioncluster"."cross_reference", "search_opinioncluster"."correction", "search_opinioncluster"."citation_count", "search_opinioncluster"."precedential_status", "search_opinioncluster"."date_blocked", "search_opinioncluster"."blocked", "search_opinioncluster"."filepath_json_harvard", "search_opinioncluster"."arguments", "search_opinioncluster"."headmatter" FROM "search_opinioncluster" WHERE "search_opinioncluster"."id" IN (1); args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,175 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_docket"."id", "search_docket"."date_created", "search_docket"."date_modified", "search_docket"."source", "search_docket"."court_id", "search_docket"."appeal_from_id", "search_docket"."appeal_from_str", "search_docket"."originating_court_information_id", "search_docket"."idb_data_id", "search_docket"."assigned_to_id", "search_docket"."assigned_to_str", "search_docket"."referred_to_id", "search_docket"."referred_to_str", "search_docket"."panel_str", "search_docket"."date_last_index", "search_docket"."date_cert_granted", "search_docket"."date_cert_denied", "search_docket"."date_argued", "search_docket"."date_reargued", "search_docket"."date_reargument_denied", "search_docket"."date_filed", "search_docket"."date_terminated", "search_docket"."date_last_filing", "search_docket"."case_name_short", "search_docket"."case_name", "search_docket"."case_name_full", "search_docket"."slug", "search_docket"."docket_number", "search_docket"."docket_number_core", "search_docket"."pacer_case_id", "search_docket"."cause", "search_docket"."nature_of_suit", "search_docket"."jury_demand", "search_docket"."jurisdiction_type", "search_docket"."appellate_fee_status", "search_docket"."appellate_case_type_information", "search_docket"."mdl_status", "search_docket"."filepath_local", "search_docket"."filepath_ia", "search_docket"."filepath_ia_json", "search_docket"."ia_upload_failure_count", "search_docket"."ia_needs_upload", "search_docket"."ia_date_first_change", "search_docket"."view_count", "search_docket"."date_blocked", "search_docket"."blocked" FROM "search_docket" WHERE "search_docket"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,176 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_court"."id", "search_court"."parent_court_id", "search_court"."pacer_court_id", "search_court"."pacer_has_rss_feed", "search_court"."pacer_rss_entry_types", "search_court"."date_last_pacer_contact", "search_court"."fjc_court_id", "search_court"."date_modified", "search_court"."in_use", "search_court"."has_opinion_scraper", "search_court"."has_oral_argument_scraper", "search_court"."position", "search_court"."citation_string", "search_court"."short_name", "search_court"."full_name", "search_court"."url", "search_court"."start_date", "search_court"."end_date", "search_court"."jurisdiction", "search_court"."notes" FROM "search_court" WHERE "search_court"."id" = 'bilyd' LIMIT 21; args=('bilyd',); alias=default" DEBUG 2024-02-11 20:50:42,202 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id", "people_db_person"."date_created", "people_db_person"."date_modified", "people_db_person"."is_alias_of_id", "people_db_person"."date_completed", "people_db_person"."fjc_id", "people_db_person"."slug", "people_db_person"."name_first", "people_db_person"."name_middle", "people_db_person"."name_last", "people_db_person"."name_suffix", "people_db_person"."date_dob", "people_db_person"."date_granularity_dob", "people_db_person"."date_dod", "people_db_person"."date_granularity_dod", "people_db_person"."dob_city", "people_db_person"."dob_state", "people_db_person"."dob_country", "people_db_person"."dod_city", "people_db_person"."dod_state", "people_db_person"."dod_country", "people_db_person"."gender", "people_db_person"."religion", "people_db_person"."ftm_total_received", "people_db_person"."ftm_eid", "people_db_person"."has_photo" FROM "people_db_person" INNER JOIN "search_opinioncluster_panel" ON ("people_db_person"."id" = "search_opinioncluster_panel"."person_id") WHERE "search_opinioncluster_panel"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,203 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id", "people_db_person"."date_created", "people_db_person"."date_modified", "people_db_person"."is_alias_of_id", "people_db_person"."date_completed", "people_db_person"."fjc_id", "people_db_person"."slug", "people_db_person"."name_first", "people_db_person"."name_middle", "people_db_person"."name_last", "people_db_person"."name_suffix", "people_db_person"."date_dob", "people_db_person"."date_granularity_dob", "people_db_person"."date_dod", "people_db_person"."date_granularity_dod", "people_db_person"."dob_city", "people_db_person"."dob_state", "people_db_person"."dob_country", "people_db_person"."dod_city", "people_db_person"."dod_state", "people_db_person"."dod_country", "people_db_person"."gender", "people_db_person"."religion", "people_db_person"."ftm_total_received", "people_db_person"."ftm_eid", "people_db_person"."has_photo" FROM "people_db_person" INNER JOIN "search_opinioncluster_non_participating_judges" ON ("people_db_person"."id" = "search_opinioncluster_non_participating_judges"."person_id") WHERE "search_opinioncluster_non_participating_judges"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,203 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_citation"."id", "search_citation"."cluster_id", "search_citation"."volume", "search_citation"."reporter", "search_citation"."page", "search_citation"."type" FROM "search_citation" WHERE "search_citation"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,204 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinion"."id", "search_opinion"."date_created", "search_opinion"."date_modified", "search_opinion"."cluster_id", "search_opinion"."author_id", "search_opinion"."author_str", "search_opinion"."per_curiam", "search_opinion"."joined_by_str", "search_opinion"."type", "search_opinion"."sha1", "search_opinion"."page_count", "search_opinion"."download_url", "search_opinion"."local_path", "search_opinion"."plain_text", "search_opinion"."html", "search_opinion"."html_lawbox", "search_opinion"."html_columbia", "search_opinion"."html_anon_2020", "search_opinion"."xml_harvard", "search_opinion"."html_with_citations", "search_opinion"."extracted_by_ocr" FROM "search_opinion" WHERE "search_opinion"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,204 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_citation"."id", "search_citation"."cluster_id", "search_citation"."volume", "search_citation"."reporter", "search_citation"."page", "search_citation"."type" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 6) LIMIT 1; args=(1, Int2(6)); alias=default" DEBUG 2024-02-11 20:50:42,205 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_citation"."id", "search_citation"."cluster_id", "search_citation"."volume", "search_citation"."reporter", "search_citation"."page", "search_citation"."type" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 8) LIMIT 1; args=(1, Int2(8)); alias=default" DEBUG 2024-02-11 20:50:42,208 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinion"."id", "search_opinion"."date_created", "search_opinion"."date_modified", "search_opinion"."cluster_id", "search_opinion"."author_id", "search_opinion"."author_str", "search_opinion"."per_curiam", "search_opinion"."joined_by_str", "search_opinion"."type", "search_opinion"."sha1", "search_opinion"."page_count", "search_opinion"."download_url", "search_opinion"."local_path", "search_opinion"."plain_text", "search_opinion"."html", "search_opinion"."html_lawbox", "search_opinion"."html_columbia", "search_opinion"."html_anon_2020", "search_opinion"."xml_harvard", "search_opinion"."html_with_citations", "search_opinion"."extracted_by_ocr" FROM "search_opinion" WHERE "search_opinion"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,891 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.002) INSERT INTO "people_db_person" ("date_created", "date_modified", "is_alias_of_id", "date_completed", "fjc_id", "slug", "name_first", "name_middle", "name_last", "name_suffix", "date_dob", "date_granularity_dob", "date_dod", "date_granularity_dod", "dob_city", "dob_state", "dob_country", "dod_city", "dod_state", "dod_country", "gender", "religion", "ftm_total_received", "ftm_eid", "has_photo") VALUES ('2024-02-12 04:50:42.889251+00:00'::timestamptz, '2024-02-12 04:50:42.889259+00:00'::timestamptz, NULL, '2024-02-12 04:50:42.888312+00:00'::timestamptz, NULL, 'lisa-rodriguez-sanders-iv', 'Lisa Rodriguez', '', 'Sanders', '4', NULL, '', NULL, '', 'West Kevin', 'ND', 'United States', '', '', 'United States', 'f', '', NULL, NULL, false) RETURNING "people_db_person"."id"; args=(datetime.datetime(2024, 2, 12, 4, 50, 42, 889251, tzinfo=datetime.timezone.utc), datetime.datetime(2024, 2, 12, 4, 50, 42, 889259, tzinfo=datetime.timezone.utc), None, datetime.datetime(2024, 2, 12, 4, 50, 42, 888312, tzinfo=datetime.timezone.utc), None, 'lisa-rodriguez-sanders-iv', 'Lisa Rodriguez', '', 'Sanders', '4', None, '', None, '', 'West Kevin', 'ND', 'United States', '', '', 'United States', 'f', '', None, None, False); alias=default" DEBUG 2024-02-11 20:50:42,894 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.002) SELECT "people_db_position"."id", "people_db_position"."date_created", "people_db_position"."date_modified", "people_db_position"."position_type", "people_db_position"."job_title", "people_db_position"."sector", "people_db_position"."person_id", "people_db_position"."court_id", "people_db_position"."school_id", "people_db_position"."organization_name", "people_db_position"."location_city", "people_db_position"."location_state", "people_db_position"."appointer_id", "people_db_position"."supervisor_id", "people_db_position"."predecessor_id", "people_db_position"."date_nominated", "people_db_position"."date_elected", "people_db_position"."date_recess_appointment", "people_db_position"."date_referred_to_judicial_committee", "people_db_position"."date_judicial_committee_action", "people_db_position"."judicial_committee_action", "people_db_position"."date_hearing", "people_db_position"."date_confirmation", "people_db_position"."date_start", "people_db_position"."date_granularity_start", "people_db_position"."date_termination", "people_db_position"."termination_reason", "people_db_position"."date_granularity_termination", "people_db_position"."date_retirement", "people_db_position"."nomination_process", "people_db_position"."vote_type", "people_db_position"."voice_vote", "people_db_position"."votes_yes", "people_db_position"."votes_no", "people_db_position"."votes_yes_percent", "people_db_position"."votes_no_percent", "people_db_position"."how_selected", "people_db_position"."has_inferred_values" FROM "people_db_position" WHERE "people_db_position"."person_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,897 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.002) INSERT INTO "search_opinion" ("date_created", "date_modified", "cluster_id", "author_id", "author_str", "per_curiam", "joined_by_str", "type", "sha1", "page_count", "download_url", "local_path", "plain_text", "html", "html_lawbox", "html_columbia", "html_anon_2020", "xml_harvard", "html_with_citations", "extracted_by_ocr") VALUES ('2024-02-12 04:50:42.895250+00:00'::timestamptz, '2024-02-12 04:50:42.895258+00:00'::timestamptz, 1, 1, 'Lisa Rodriguez Sanders IV', false, '', '070rehearing', '34e43f31059c51dcb685db1b2e0626c60454bbce', NULL, NULL, '', 'Least look stage expect allow. Enter year daughter. Movement ten sign. Local few recent accept religious great once. Time pass strong open star century. Nature blue forget. Organization seek loss site friend simple not. Design win collection read find agreement. Under commercial style theory reality political hard. Though knowledge day to agent debate role. Fast possible fear dream probably. Station few authority get. Go city position analysis wear hear. Difference computer thousand chair well serious common. None good actually north. Rock the five subject magazine year deal. Book method fall entire. Laugh indeed range meet executive realize we move. Money available amount my foot. Leader increase rock song laugh protect federal. The Democrat response lay. International trade today per after. Six authority this explain lead right wide political. Measure appear leader. Character either physical. Pull authority network whose trip land all. Over eye myself. Hold that indicate up child rule challenge. Music debate industry college way nothing. Similar voice less media notice themselves indicate. Either price include occur respond. Month authority store though. Remain candidate shake box member office. When wrong fact bank. Debate sell human show beyond must he eight. Management call such together region money. None majority about inside two cover day. Believe camera history suggest feeling quickly. Person professor who they former civil. Oil remain four quality option they plan return. Require nearly agency wait lot shoulder save. Series question move way center live. Chance her ground black Republican any. Something center someone big someone. Certainly think environment opportunity past. Brother idea necessary girl. Could doctor machine artist. Prevent agree scientist grow wind condition phone. Exist visit experience gun lead. Where with box treatment medical. End attack for. Wide situation create account leg friend data. Month heavy plant risk second project.', '', '', '', '', '', '', false) RETURNING "search_opinion"."id"; args=(datetime.datetime(2024, 2, 12, 4, 50, 42, 895250, tzinfo=datetime.timezone.utc), datetime.datetime(2024, 2, 12, 4, 50, 42, 895258, tzinfo=datetime.timezone.utc), 1, 1, 'Lisa Rodriguez Sanders IV', False, '', '070rehearing', '34e43f31059c51dcb685db1b2e0626c60454bbce', None, None, '', 'Least look stage expect allow. Enter year daughter.\nMovement ten sign. Local few recent accept religious great once.\nTime pass strong open star century. Nature blue forget. Organization seek loss site friend simple not. Design win collection read find agreement.\nUnder commercial style theory reality political hard. Though knowledge day to agent debate role.\nFast possible fear dream probably. Station few authority get. Go city position analysis wear hear. Difference computer thousand chair well serious common.\nNone good actually north. Rock the five subject magazine year deal.\nBook method fall entire. Laugh indeed range meet executive realize we move. Money available amount my foot.\nLeader increase rock song laugh protect federal. The Democrat response lay.\nInternational trade today per after. Six authority this explain lead right wide political. Measure appear leader.\nCharacter either physical. Pull authority network whose trip land all.\nOver eye myself. Hold that indicate up child rule challenge.\nMusic debate industry college way nothing. Similar voice less media notice themselves indicate.\nEither price include occur respond. Month authority store though. Remain candidate shake box member office.\nWhen wrong fact bank. Debate sell human show beyond must he eight.\nManagement call such together region money. None majority about inside two cover day. Believe camera history suggest feeling quickly. Person professor who they former civil.\nOil remain four quality option they plan return.\nRequire nearly agency wait lot shoulder save. Series question move way center live. Chance her ground black Republican any.\nSomething center someone big someone. Certainly think environment opportunity past.\nBrother idea necessary girl. Could doctor machine artist. Prevent agree scientist grow wind condition phone.\nExist visit experience gun lead. Where with box treatment medical.\nEnd attack for. Wide situation create account leg friend data. Month heavy plant risk second project.', '', '', '', '', '', '', False); alias=default" DEBUG 2024-02-11 20:50:42,898 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinion"."id", "search_opinion"."date_created", "search_opinion"."date_modified", "search_opinion"."cluster_id", "search_opinion"."author_id", "search_opinion"."author_str", "search_opinion"."per_curiam", "search_opinion"."joined_by_str", "search_opinion"."type", "search_opinion"."sha1", "search_opinion"."page_count", "search_opinion"."download_url", "search_opinion"."local_path", "search_opinion"."plain_text", "search_opinion"."html", "search_opinion"."html_lawbox", "search_opinion"."html_columbia", "search_opinion"."html_anon_2020", "search_opinion"."xml_harvard", "search_opinion"."html_with_citations", "search_opinion"."extracted_by_ocr" FROM "search_opinion" WHERE "search_opinion"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,899 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinioncluster"."id", "search_opinioncluster"."date_created", "search_opinioncluster"."date_modified", "search_opinioncluster"."docket_id", "search_opinioncluster"."judges", "search_opinioncluster"."date_filed", "search_opinioncluster"."date_filed_is_approximate", "search_opinioncluster"."slug", "search_opinioncluster"."case_name_short", "search_opinioncluster"."case_name", "search_opinioncluster"."case_name_full", "search_opinioncluster"."scdb_id", "search_opinioncluster"."scdb_decision_direction", "search_opinioncluster"."scdb_votes_majority", "search_opinioncluster"."scdb_votes_minority", "search_opinioncluster"."source", "search_opinioncluster"."procedural_history", "search_opinioncluster"."attorneys", "search_opinioncluster"."nature_of_suit", "search_opinioncluster"."posture", "search_opinioncluster"."syllabus", "search_opinioncluster"."headnotes", "search_opinioncluster"."summary", "search_opinioncluster"."disposition", "search_opinioncluster"."history", "search_opinioncluster"."other_dates", "search_opinioncluster"."cross_reference", "search_opinioncluster"."correction", "search_opinioncluster"."citation_count", "search_opinioncluster"."precedential_status", "search_opinioncluster"."date_blocked", "search_opinioncluster"."blocked", "search_opinioncluster"."filepath_json_harvard", "search_opinioncluster"."arguments", "search_opinioncluster"."headmatter" FROM "search_opinioncluster" WHERE "search_opinioncluster"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,916 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id", "people_db_person"."date_created", "people_db_person"."date_modified", "people_db_person"."is_alias_of_id", "people_db_person"."date_completed", "people_db_person"."fjc_id", "people_db_person"."slug", "people_db_person"."name_first", "people_db_person"."name_middle", "people_db_person"."name_last", "people_db_person"."name_suffix", "people_db_person"."date_dob", "people_db_person"."date_granularity_dob", "people_db_person"."date_dod", "people_db_person"."date_granularity_dod", "people_db_person"."dob_city", "people_db_person"."dob_state", "people_db_person"."dob_country", "people_db_person"."dod_city", "people_db_person"."dod_state", "people_db_person"."dod_country", "people_db_person"."gender", "people_db_person"."religion", "people_db_person"."ftm_total_received", "people_db_person"."ftm_eid", "people_db_person"."has_photo" FROM "people_db_person" WHERE "people_db_person"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,918 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "search_opinionscited"."cited_opinion_id" FROM "search_opinionscited" WHERE "search_opinionscited"."citing_opinion_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,919 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.001) SELECT "people_db_person"."id" FROM "people_db_person" INNER JOIN "search_opinion_joined_by" ON ("people_db_person"."id" = "search_opinion_joined_by"."person_id") WHERE "search_opinion_joined_by"."opinion_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,920 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_docket"."id", "search_docket"."date_created", "search_docket"."date_modified", "search_docket"."source", "search_docket"."court_id", "search_docket"."appeal_from_id", "search_docket"."appeal_from_str", "search_docket"."originating_court_information_id", "search_docket"."idb_data_id", "search_docket"."assigned_to_id", "search_docket"."assigned_to_str", "search_docket"."referred_to_id", "search_docket"."referred_to_str", "search_docket"."panel_str", "search_docket"."date_last_index", "search_docket"."date_cert_granted", "search_docket"."date_cert_denied", "search_docket"."date_argued", "search_docket"."date_reargued", "search_docket"."date_reargument_denied", "search_docket"."date_filed", "search_docket"."date_terminated", "search_docket"."date_last_filing", "search_docket"."case_name_short", "search_docket"."case_name", "search_docket"."case_name_full", "search_docket"."slug", "search_docket"."docket_number", "search_docket"."docket_number_core", "search_docket"."pacer_case_id", "search_docket"."cause", "search_docket"."nature_of_suit", "search_docket"."jury_demand", "search_docket"."jurisdiction_type", "search_docket"."appellate_fee_status", "search_docket"."appellate_case_type_information", "search_docket"."mdl_status", "search_docket"."filepath_local", "search_docket"."filepath_ia", "search_docket"."filepath_ia_json", "search_docket"."ia_upload_failure_count", "search_docket"."ia_needs_upload", "search_docket"."ia_date_first_change", "search_docket"."view_count", "search_docket"."date_blocked", "search_docket"."blocked" FROM "search_docket" WHERE "search_docket"."id" = 1 LIMIT 21; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,921 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_court"."id", "search_court"."parent_court_id", "search_court"."pacer_court_id", "search_court"."pacer_has_rss_feed", "search_court"."pacer_rss_entry_types", "search_court"."date_last_pacer_contact", "search_court"."fjc_court_id", "search_court"."date_modified", "search_court"."in_use", "search_court"."has_opinion_scraper", "search_court"."has_oral_argument_scraper", "search_court"."position", "search_court"."citation_string", "search_court"."short_name", "search_court"."full_name", "search_court"."url", "search_court"."start_date", "search_court"."end_date", "search_court"."jurisdiction", "search_court"."notes" FROM "search_court" WHERE "search_court"."id" = 'bilyd' LIMIT 21; args=('bilyd',); alias=default" DEBUG 2024-02-11 20:50:42,921 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id", "people_db_person"."date_created", "people_db_person"."date_modified", "people_db_person"."is_alias_of_id", "people_db_person"."date_completed", "people_db_person"."fjc_id", "people_db_person"."slug", "people_db_person"."name_first", "people_db_person"."name_middle", "people_db_person"."name_last", "people_db_person"."name_suffix", "people_db_person"."date_dob", "people_db_person"."date_granularity_dob", "people_db_person"."date_dod", "people_db_person"."date_granularity_dod", "people_db_person"."dob_city", "people_db_person"."dob_state", "people_db_person"."dob_country", "people_db_person"."dod_city", "people_db_person"."dod_state", "people_db_person"."dod_country", "people_db_person"."gender", "people_db_person"."religion", "people_db_person"."ftm_total_received", "people_db_person"."ftm_eid", "people_db_person"."has_photo" FROM "people_db_person" INNER JOIN "search_opinioncluster_panel" ON ("people_db_person"."id" = "search_opinioncluster_panel"."person_id") WHERE "search_opinioncluster_panel"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,922 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_citation"."id", "search_citation"."cluster_id", "search_citation"."volume", "search_citation"."reporter", "search_citation"."page", "search_citation"."type" FROM "search_citation" WHERE "search_citation"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,922 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "search_opinion"."id" FROM "search_opinion" WHERE "search_opinion"."cluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,923 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT "people_db_person"."id" FROM "people_db_person" INNER JOIN "search_opinioncluster_panel" ON ("people_db_person"."id" = "search_opinioncluster_panel"."person_id") WHERE "search_opinioncluster_panel"."opinioncluster_id" = 1; args=(1,); alias=default" DEBUG 2024-02-11 20:50:42,924 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT COUNT(*) AS "__count" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 8); args=(1, Int2(8)); alias=default" DEBUG 2024-02-11 20:50:42,924 (/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py debug_sql): "(0.000) SELECT COUNT(*) AS "__count" FROM "search_citation" WHERE ("search_citation"."cluster_id" = 1 AND "search_citation"."type" = 6); args=(1, Int2(6)); alias=default" Traceback (most recent call last): File "/opt/courtlistener/manage.py", line 15, in main() File "/opt/courtlistener/manage.py", line 11, in main execute_from_command_line(sys.argv) File "/usr/local/lib/python3.12/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line utility.execute() File "/usr/local/lib/python3.12/site-packages/django/core/management/__init__.py", line 436, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python3.12/site-packages/django/core/management/base.py", line 413, in run_from_argv self.execute(*args, **cmd_options) File "/usr/local/lib/python3.12/site-packages/django/core/management/base.py", line 459, in execute output = self.handle(*args, **options) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/courtlistener/cl/lib/management/commands/make_dev_data.py", line 119, in handle Factory.create_batch(count) File "/usr/local/lib/python3.12/site-packages/factory/base.py", line 540, in create_batch return [cls.create(**kwargs) for _ in range(size)] ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/base.py", line 528, in create return cls._generate(enums.CREATE_STRATEGY, kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/django.py", line 121, in _generate return super()._generate(strategy, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/base.py", line 465, in _generate return step.build() ^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/builder.py", line 283, in build postgen_results[declaration_name] = declaration.declaration.evaluate_post( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/declarations.py", line 652, in evaluate_post return self.call(instance, step, postgen_context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/declarations.py", line 733, in call return step.recurse(factory, passed_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/builder.py", line 228, in recurse return builder.build(parent_step=self, force_sequence=force_sequence) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/builder.py", line 283, in build postgen_results[declaration_name] = declaration.declaration.evaluate_post( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/declarations.py", line 652, in evaluate_post return self.call(instance, step, postgen_context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/declarations.py", line 733, in call return step.recurse(factory, passed_kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/builder.py", line 228, in recurse return builder.build(parent_step=self, force_sequence=force_sequence) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/builder.py", line 274, in build instance = self.factory_meta.instantiate( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/base.py", line 317, in instantiate return self.factory._create(model, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/factory/django.py", line 174, in _create return manager.create(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 679, in create obj.save(force_insert=True, using=self.db) File "/opt/courtlistener/cl/search/models.py", line 3457, in save super(Opinion, self).save(*args, **kwargs) File "/usr/local/lib/python3.12/site-packages/django/db/models/base.py", line 822, in save self.save_base( File "/usr/local/lib/python3.12/site-packages/model_utils/tracker.py", line 375, in inner return original(instance, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/model_utils/tracker.py", line 375, in inner return original(instance, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/django/db/models/base.py", line 924, in save_base post_save.send( File "/usr/local/lib/python3.12/site-packages/django/dispatch/dispatcher.py", line 189, in send response = receiver(signal=self, sender=sender, **named) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/courtlistener/cl/lib/elasticsearch_utils.py", line 93, in wrapper_func func(*args, **kwargs) File "/opt/courtlistener/cl/lib/es_signal_processor.py", line 727, in handle_save transaction.on_commit( File "/usr/local/lib/python3.12/site-packages/django/db/transaction.py", line 134, in on_commit get_connection(using).on_commit(func, robust) File "/usr/local/lib/python3.12/site-packages/django/db/backends/base/base.py", line 746, in on_commit func() File "/opt/courtlistener/cl/lib/es_signal_processor.py", line 736, in ).apply_async() ^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/celery/canvas.py", line 1034, in apply_async return self.apply(args, kwargs, **options) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/celery/canvas.py", line 1272, in apply last and (last.get(),), **dict(self.options, **options)) ^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/celery/result.py", line 1026, in get raise self.result if isinstance( File "/usr/local/lib/python3.12/site-packages/celery/app/trace.py", line 477, in trace_task R = retval = fun(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/celery/app/autoretry.py", line 38, in run return task._orig_run(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/courtlistener/cl/search/tasks.py", line 382, in es_save_document response = es_document(**es_args, **doc).save( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/elasticsearch_dsl/document.py", line 478, in save meta = es.index( ^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/elasticsearch/_sync/client/utils.py", line 402, in wrapped return api(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/elasticsearch/_sync/client/__init__.py", line 2249, in index return self.perform_request( # type: ignore[return-value] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.12/site-packages/elasticsearch/_sync/client/_base.py", line 320, in perform_request raise HTTP_EXCEPTIONS.get(meta.status, ApiError)( celery.utils.serialization.UnpickleableExceptionWrapper: BadRequestError('document_parsing_exception', meta=ApiResponseMeta(status=400, http_version='1.1', headers={'X-elastic-product': 'Elasticsearch', 'content-type': 'application/vnd.elasticsearch+json;compatible-with=8', 'content-length': '520'}, duration=0.01712822914123535, node=NodeConfig(scheme='https', host='cl-es', port=9200, path_prefix='', headers={'user-agent': 'elasticsearch-py/8.11.1 (Python/3.12.2; elastic-transport/8.11.0)'}, connections_per_node=10, request_timeout=10.0, http_compress=False, verify_certs=False, ca_certs='/opt/courtlistener/docker/elastic/ca.crt', client_cert=None, client_key=None, ssl_assert_hostname=None, ssl_assert_fingerprint=None, ssl_version=None, ssl_context=None, ssl_show_warn=True, _extras={})), body={'error': {'root_cause': [{'type': 'document_parsing_exception', 'reason': "[1:3081] failed to parse field [cluster_child] of type [text] in document with id 'o_1'. Preview of field's value: '{parent=1, name=opinion}'"}], 'type': 'document_parsing_exception', 'reason': "[1:3081] failed to parse field [cluster_child] of type [text] in document with id 'o_1'. Preview of field's value: '{parent=1, name=opinion}'", 'caused_by': {'type': 'illegal_state_exception', 'reason': "Can't get text on a START_OBJECT at 1:3053"}}, 'status': 400}) ```

It seems like cluster_child is being set to text maybe from OpinionClusterDocument's prepare just having "opinion_cluster" and then JSON is passed as the value for OpinionDocuments with its prepare returning {"name": "opinion", "parent": parent_id}. But, I am not 100% sure of that.

# where es is an elasticsearch_dsl connection
>>> es.indices.get_mapping()
{
    "opinion_index": {
        "mappings": {
            "properties": {
                "cluster_child": {
                    "type": "text",
                    "fields": {
                        "keyword": {"type": "keyword", "ignore_above": 256}
                    },
                },
# ...
mlissner commented 9 months ago

@albertisfu looks like we've got another issue with making dev data (along with #3306). Can you see if this is the same issue?

albertisfu commented 9 months ago

Yes, this is the same issue as #3306. I'll work on the fix that we talked about last week.

david-clark-1043 commented 9 months ago

Ah! Sorry for not searching the history. I figured if it wasn't new, it would've been affecting everyone.

mlissner commented 9 months ago

You're not wrong. Our devs have probably been stubbornly working around this one, and, to be fair, I haven't assigned anybody to fix it, so it hasn't gotten fixed. Anyhow, closing as a dup, but hopefully we'll get it fixed soon.