search

cloudreve / Cloudreve

🌩支持多家云存储的云盘系统 (Self-hosted file management and sharing system, supports multiple storage providers)
https://cloudreve.org
GNU General Public License v3.0
22.05k stars 3.45k forks source link

Cloudreve WOPI API 500错误 #1696

Closed CDN18 closed 1 year ago

CDN18 commented 1 year ago

Describe the bug 自建的WOPI预览服务在获取文件时出错，cloudreve日志显示500错误。

To Reproduce Steps to reproduce the behavior:

  1. 按配置Cloudreve和CODE WOPI服务，
  2. 在cloudreve打开一个office文件
  3. 检查日志，此时cloudreve日志会先出现一条200记录再出现一条500记录，wopi服务的日志则返回connection reset

Expected behavior 正常浏览文件

Screenshots

Cloudreve日志

(/Users/aaronliu/Projects/Cloudreve/models/user.go:139) 
[2023-04-11 21:27:18]  [0.81ms]  SELECT * FROM "cd_users"  WHERE "cd_users"."deleted_at" IS NULL AND ((status = 0) AND ("cd_users"."id" = 1)) ORDER BY "cd_users"."id" ASC LIMIT 1  
[1 rows affected or returned ] 

(/Users/aaronliu/Projects/Cloudreve/models/user.go:139) 
[2023-04-11 21:27:18]  [0.48ms]  SELECT * FROM "cd_groups"  WHERE "cd_groups"."deleted_at" IS NULL AND (("id" IN (1))) ORDER BY "cd_groups"."id" ASC  
[1 rows affected or returned ] 

(/Users/aaronliu/Projects/Cloudreve/models/file.go:113) 
[2023-04-11 21:27:18]  [0.41ms]  SELECT * FROM "cd_files"  WHERE "cd_files"."deleted_at" IS NULL AND ((id in (2133)))  
[1 rows affected or returned ] 

(/Users/aaronliu/Projects/Cloudreve/models/folder.go:139) 
[2023-04-11 21:27:18]  [0.37ms]  SELECT * FROM "cd_folders"  WHERE "cd_folders"."deleted_at" IS NULL AND ((id in (1) AND owner_id = 1))  
[1 rows affected or returned ] 
[GIN] 2023/04/11 - 21:27:18 | 200 |    4.325021ms |    **.**.**.** | GET      "/api/v3/wopi/files/wz0AHK?access_token=e30cda63-42f5-4e41-8b26-bc5bf2e29b38.JZgcMGnwH2rmPZe7stWIujHgxXfN3o9IKCyhlYL3tfSosakBSGBYAI4fCCaXTX8Z&access_token_ttl=1681277226624&permission=edit"

(/Users/aaronliu/Projects/Cloudreve/models/user.go:139) 
[2023-04-11 21:27:18]  [0.70ms]  SELECT * FROM "cd_users"  WHERE "cd_users"."deleted_at" IS NULL AND ((status = 0) AND ("cd_users"."id" = 1)) ORDER BY "cd_users"."id" ASC LIMIT 1  
[1 rows affected or returned ] 

(/Users/aaronliu/Projects/Cloudreve/models/user.go:139) 
[2023-04-11 21:27:18]  [0.44ms]  SELECT * FROM "cd_groups"  WHERE "cd_groups"."deleted_at" IS NULL AND (("id" IN (1))) ORDER BY "cd_groups"."id" ASC  
[1 rows affected or returned ] 

(/Users/aaronliu/Projects/Cloudreve/models/file.go:113) 
[2023-04-11 21:27:18]  [0.36ms]  SELECT * FROM "cd_files"  WHERE "cd_files"."deleted_at" IS NULL AND ((id in (2133)))  
[1 rows affected or returned ] 
[GIN] 2023/04/11 - 21:27:18 | 500 |  288.141692ms |   **.**.**.** | GET      "/api/v3/wopi/files/wz0AHK/contents?access_token=e30cda63-42f5-4e41-8b26-bc5bf2e29b38.JZgcMGnwH2rmPZe7stWIujHgxXfN3o9IKCyhlYL3tfSosakBSGBYAI4fCCaXTX8Z&access_token_ttl=1681277226624&permission=edit"

WOPI服务日志

collabora  | wsd-00001-00052 2023-04-11 19:20:11.911754 +0000 [ docbroker_002 ] ERR  WOPI::GetFile [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit] failed with Status Code: 500| wsd/Storage.cpp:1172
collabora  | wsd-00001-00052 2023-04-11 19:20:11.912123 +0000 [ docbroker_002 ] ERR  Cannot download document from WOPI storage uri [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit]. Error: WOPI::GetFile [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit] failed: | wsd/Storage.cpp:1103
collabora  | wsd-00001-00052 2023-04-11 19:20:11.912192 +0000 [ docbroker_002 ] ERR  loading document exception: WOPI::GetFile [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit] failed: | wsd/DocumentBroker.cpp:2456
collabora  | wsd-00001-00052 2023-04-11 19:20:11.912213 +0000 [ docbroker_002 ] ERR  Failed to add session to [https://cloudreve.domain:443/api/v3/wopi/files/wz0AHK] with URI [https://cloudreve.domain/api/v3/wopi/files/wz0AHK?access_token=088777d7-55ae-447d-9290-a5e39cc477a9.9MAEdeF0yZRqUhcd4ICu98MiC1GyTZyKrlJZnxpIXa7VwIc06bo3tASIfDTwaXpd&access_token_ttl=1681276799156&permission=edit]: WOPI::GetFile [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit] failed: | wsd/DocumentBroker.cpp:2418
collabora  | wsd-00001-00052 2023-04-11 19:20:11.912256 +0000 [ docbroker_002 ] ERR  Storage error while starting session on https://cloudreve.domain:443/api/v3/wopi/files/wz0AHK for socket #22. Terminating connection. Error: WOPI::GetFile [https://cloudreve.domain/api/v3/wopi/files/wz0AHK/contents?access_token=&access_token_ttl=1681276799156&permission=edit] failed: | wsd/COOLWSD.cpp:4946collabora  | wsd-00001-00052 2023-04-11 19:20:11.914328 +0000 [ docbroker_002 ] ERR  #22: Error while handling poll at 1 in docbroker_002: #22 (write): unknown. BIO error: 336150819, rc: -1: error:14094123:SSL routines:ssl3_read_bytes:application data after close notify:
collabora  | 140590869268224:error:14094123:SSL routines:ssl3_read_bytes:application data after close notify:../ssl/record/rec_layer_s3.c:1592:
collabora  | 
collabora  | 140590869268224:error:1420C0CF:SSL routines:ssl_write_internal:protocol is shutdown:../ssl/ssl_lib.c:1917:
collabora  | | net/Socket.cpp:450
collabora  | wsd-00001-00052 2023-04-11 19:20:11.919273 +0000 [ docbroker_002 ] ERR  #35: Read failed, have 0 buffered bytes (ECONNRESET: Connection reset by peer)| net/Socket.hpp:1151
collabora  | wsd-00001-00052 2023-04-11 19:20:11.919450 +0000 [ docbroker_002 ] WRN  #35: Unassociated Kit (45) disconnected unexpectedly| wsd/COOLWSD.cpp:3426
collabora  | sh: 1: /usr/bin/coolmount: Operation not permitted
collabora  | sh: 1: /usr/bin/coolmount: Operation not permitted
collabora  | sh: 1: /usr/bin/coolmount: Operation not permitted

Desktop (please complete the following information):

Additional context 使用的存储为AWS S3（Cloudflare R2）

CDN18 commented 1 year ago

经排查，是存储策略配置问题，抱歉