openstates / issues

Having trouble? Looking to contribute? Issues live here!
15 stars 2 forks source link

NY-events failing since at least 2023-05-25 #1062

Closed openstates-bot closed 1 year ago

openstates-bot commented 1 year ago

NY-events has failed 3 times since 2023-05-25

Logs:

    return self.cursor.execute(sql, params)
django.db.utils.DataError: value too long for type character varying(500)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/bin/os-update", line 8, in <module>
    sys.exit(main())
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/cli/update.py", line 478, in main
    report = do_update(args, other, juris)
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/cli/update.py", line 313, in do_update
    report["import"] = do_import(juris, args)
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/cli/update.py", line 194, in do_import
    report.update(event_importer.import_directory(datadir))
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/importers/base.py", line 259, in import_directory
    return self.import_data(json_stream())
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/importers/base.py", line 299, in import_data
    obj_id, what = self.import_item(data)
  File "/root/.cache/pypoetry/virtualenvs/openstates-scrapers-vRcYrsYN-py3.9/lib/python3.9/site-packages/openstates/importers/base.py", line 372, in import_item
    raise DataImportError(
openstates.exceptions.DataImportError: value too long for type character varying(500)
 while importing {'name': 'Senate Finance', 'all_day': False, 'start_date': '2023-05-31T15:00:00+00:00', 'end_date': '', 'status': 'confirmed', 'classification': 'event', 'description': "The Committee on Finance will consider the following nominations:\n\nAPPEARING\n\nGloribelle J. Perez, Member, Workers' Compensation Board\n\nNOT APPEARING\n\nClarissa M. Rodriguez, Member, Workers' Compensation Board\nCary F. Staller, Trustee, State University of New York\nBarbaralee Diamonstein-Spielvogel, Trustee, City University of New York\nSandra Wilkin Frowley, Trustee, City University of New York\nDavid Harris, Trustee, Higher Education Services Corporation\nManuel Rivera, Trustee, Higher Education Services Corporation\nRichard N. Gottfried, Convention Center Operating Corporation\nJennifer Cunningham, Member, Palisades Interstate Park Commission\nSandra Lewis, Member, Alleghany State Park Commission\nDia Carabajal, Member, Finger Lakes State Park Commission\nJoel Frater, Member, Genesee State Park Commission\nEmily Saland, Member, Taconic State Park Commission\nJared Rodriguez, Member, Taconic Stat\ne Park Commission\nJoel Frater, Member, Genesee State Park Commission\nEmily Saland, Member, Taconic State Park Commission\nJared Rodriguez, Member, Taconic State Park Commission\nMark Blue, Member, Niagara Frontier Transportation Authority\nAdam W. Perry, Member, Niagara Frontier Transportation Authority\n\nUpon the conclusion of the meeting of the Committee on Finance, the Committee on Finance will reconvene jointly with the Committee on Crime Victims, Crime and Correction to consider the following nominations:\n\nAPPEARING\n\nTerrence W. Moran, Member, State Commission of Correction\nAna M. Enright, Member, Board of Parole\nErin McCabe, Member, Board of Parole\nDonna Henken, Member, Board of Parole\nErnest F. Hart, Member, Board of Parole", 'upstream_id': '', 'location': <EventLocation: Room 124 CAP>, 'links': [], 'sources': [{'url': 'https://www.nysenate.gov/committees/finance', 'note': ''}], 'extras': {}, 'dedupe_key': "Senate Finance#\nThe Committee on Finance will consider the following nominations:\n\nAPPEARING\n\nGloribelle J. Perez, Member, Workers' Compensation Board\n\nNOT APPEARING\n\nClarissa M. Rodriguez, Member, Workers' Compensation Board\nCary F. Staller, Trustee, State University of New York\nBarbaralee Diamonstein-Spielvogel, Trustee, City University of New York\nSandra Wilkin Frowley, Trustee, City University of New York\nDavid Harris, Trustee, Higher Education Services Corporation\nManuel Rivera, Trustee, Higher Education Services Corporation\nRichard N. Gottfried, Convention Center Operating Corporation\nJennifer Cunningham, Member, Palisades Interstate Park Commission\nSandra Lewis, Member, Alleghany State Park Commission\nDia Carabajal, Member, Finger Lakes State Park Commission\nJoel Frater, Member, Genesee State Park Commission\nEmily Saland, Member, Taconic State Park Commission\nJared Rodriguez, Member, Taconic Stat\ne Park Commission\nJoel Frater, Member, Genesee State Park Commission\nEmily Saland, Member, Taconic State Park Commission\nJared Rodriguez, Member, Taconic State Park Commission\nMark Blue, Member, Niagara Frontier Transportation Authority\nAdam W. Perry, Member, Niagara Frontier Transportation Authority\n\nUpon the conclusion of the meeting of the Committee on Finance, the Committee on Finance will reconvene jointly with the Committee on Crime Victims, Crime and Correction to consider the following nominations:\n\nAPPEARING\n\nTerrence W. Moran, Member, State Commission of Correction\nAna M. Enright, Member, Board of Parole\nErin McCabe, Member, Board of Parole\nDonna Henken, Member, Board of Parole\nErnest F. Hart, Member, Board of Parole\n#Room 124 CAP#2023-05-31 11:00:00-04:00", 'jurisdiction_id': 'ocd-jurisdiction/country:us/state:ny/government', 'deleted': False} as <class 'openstates.data.models.event.Event'>
openstates-bot commented 1 year ago

closed via successful run on 2023-06-01