500错误

[lencshu]

大佬麻烦看看这个bug是因为什么？ docker里面跑的ghcr.io/xjasonlyu/avdc-api, http访问返回成功{"message":"AVDC-API","status":true}

但是实际刮削的时候有错误

jellyfin里面:

[22:26:11] [INF] [59] Jellyfin.Plugin.AVDC.Providers.MovieProvider: [AVDC] GetMetadata for video: IPX-610
[22:26:12] [ERR] [60] Jellyfin.Plugin.AVDC.Providers.MovieProvider: [AVDC] GetActress for 梓ヒカリ failed: Response status code does not indicate success: 500 (INTERNAL SERVER ERROR).,
[22:26:12] [INF] [60] Jellyfin.Plugin.AVDC.Providers.ImageProvider: [AVDC] GetImages for video: IPX-610,
[22:26:12] [ERR] [61] Jellyfin.Plugin.AVDC.Providers.ImageProvider: [AVDC] GetMetadata for IPX-610 failed: Response status code does not indicate success: 500 (INTERNAL SERVER ERROR).

avdc-api:

[2021-04-03 22:26:12,217] ERROR in app: Exception on /actress/梓ヒカリ [GET],
Traceback (most recent call last):,
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3144, in execute_sql,
    cursor.execute(sql, params or ()),
sqlite3.OperationalError: no such table: actresses,
,
During handling of the above exception, another exception occurred:,
,
Traceback (most recent call last):,
  File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request,
    rv = self.dispatch_request(),
  File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request,
    return self.view_functions[rule.endpoint](**req.view_args),
  File "/app/server/views.py", line 59, in _actress,
    actress = api.GetActressByName(name, update=update),
  File "/app/server/api.py", line 152, in GetActressByName,
    actress = db_api.GetActressByName(name),
  File "/app/server/db_api.py", line 32, in GetActressByName,
    result: Actresses = Actresses.get((Actresses.name == name)),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 6438, in get,
    return sq.get(),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 6884, in get,
    return clone.execute(database)[0],
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 1907, in inner,
    return method(self, database, *args, **kwargs),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 1978, in execute,
    return self._execute(database),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 2150, in _execute,
    cursor = database.execute(self),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3157, in execute,
    return self.execute_sql(sql, params, commit=commit),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3151, in execute_sql,
    self.commit(),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 2917, in __exit__,
    reraise(new_type, new_type(exc_value, *exc_args), traceback),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 190, in reraise,
    raise value.with_traceback(tb),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3144, in execute_sql,
    cursor.execute(sql, params or ()),
peewee.OperationalError: no such table: actresses,
10.0.3.3 - - [03/Apr/2021 22:26:12] "GET /actress/梓ヒカリ HTTP/1.1" 500 -,
[2021-04-03 22:26:12,321] ERROR in app: Exception on /metadata/IPX-610 [GET],
Traceback (most recent call last):,
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3144, in execute_sql,
    cursor.execute(sql, params or ()),
sqlite3.OperationalError: no such table: metadata,
,
During handling of the above exception, another exception occurred:,
,
Traceback (most recent call last):,
  File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request,
    rv = self.dispatch_request(),
  File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request,
    return self.view_functions[rule.endpoint](**req.view_args),
  File "/app/server/api.py", line 36, in wrapper,
    return fn(parseVID(vid)[0]),
  File "/app/server/views.py", line 94, in _metadata,
    m = api.GetMetadataByVID(vid, update=update),
  File "/app/server/api.py", line 136, in GetMetadataByVID,
    m = _getLocalMetadata(vid),
  File "/app/server/api.py", line 131, in _getLocalMetadata,
    return db_api.GetMetadataByVID(vid),
  File "/app/server/db_api.py", line 15, in GetMetadataByVID,
    result: Metadata = Metadata.get((Metadata.vid == vid) |,
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 6438, in get,
    return sq.get(),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 6884, in get,
    return clone.execute(database)[0],
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 1907, in inner,
    return method(self, database, *args, **kwargs),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 1978, in execute,
    return self._execute(database),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 2150, in _execute,
    cursor = database.execute(self),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3157, in execute,
    return self.execute_sql(sql, params, commit=commit),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3151, in execute_sql,
    self.commit(),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 2917, in __exit__,
    reraise(new_type, new_type(exc_value, *exc_args), traceback),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 190, in reraise,
    raise value.with_traceback(tb),
  File "/usr/local/lib/python3.9/site-packages/peewee.py", line 3144, in execute_sql,
    cursor.execute(sql, params or ()),
peewee.OperationalError: no such table: metadata,

avdc.db我打开看了，metadata和actresses这俩表都是存在的，所以为啥会返回500错误？

[xjasonlyu]

我的锅，昨天加了个in memory database，默认用了memory sqlite。

你加一个环境变量AVDC_DBURL=sqlite:///avdc.db试试

[lencshu]

ok，加上就通了