Huanshere / Huanshere/VideoLingo

下载的时候报错 Connection aborted.', ConnectionResetError,然后不停重复下载。(似乎不是一次性下载成功处理音频的时候也会报错)

Open
#371 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
18.5k
Forks
2k
Avg merge
7h 41m
Merged PRs (30d)
12

Description

Traceback (most recent call last):
File "D:\VideoLingo\batch\utils\batch_processor.py", line 98, in
process_batch()
File "D:\VideoLingo\batch\utils\batch_processor.py", line 86, in process_batch
df.to_excel('batch/tasks_setting.xlsx', index=False)
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\pandas\util_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\pandas\core\generic.py", line 2417, in to_excel
formatter.write(
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\pandas\io\formats\excel.py", line 952, in write
writer._write_cells(
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\pandas\io\excel_openpyxl.py", line 490, in _write_cells
xcell.value, fmt = self._value_with_fmt(cell.val)
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\openpyxl\cell\cell.py", line 218, in value
self._bind_value(value)
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\openpyxl\cell\cell.py", line 197, in _bind_value
value = self.check_string(value)
File "C:\Users\14027.conda\envs\videolingo\lib\site-packages\openpyxl\cell\cell.py", line 165, in check_string
raise IllegalCharacterError(f"{value} cannot be used in worksheets.")
[download] Got error: ('Connection aborted.', ConnectionResetError(10054, '远程主机强迫关闭了一个现有的连接。', None, 10054, None)) cannot be used in worksheets.
请按任意键继续. . .

=======================

请问是我的vps的问题还是下载程序的问题。能否改进下下载程序

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start in batch/utils/batch_processor.py at process_batch() and the df.to_excel('batch/tasks_setting.xlsx') call, then reproduce the reported batch download failure. Trace how the download error reaches the Excel export and why downloading repeats. Done means the failure is handled without repeated downloads and batch/tasks_setting.xlsx can still be written; no tests are mentioned in the issue.

Written by the indexing model from the issue text.

Assessment

Tech stack
pandas, python
Domain
backend, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.