Hello everyone, I encountered a timeout issue when opening an xlsx containing many formulas while using the document builder,
Two processing methods have been tried but have not been resolved:
- Modify/etc/only about office/documentserver/nginx/includes/ds-dcservice. conf to add timeout related configurations
- Added CPU cores and memory to the server,
I’m wondering if I didn’t find the correct timeout related configuration, so it didn’t take effect；May I ask how to solve this?
Participation:
{
'async': true,//asynchronous mode has already been used
"url": " http://prod-paas-evo.haoyuntech.com/hyee16d.docbuilder "
}
The final result obtained is:
{
"error": -2//The official website says this is a timeout error generated
}
The content of hyee16d.docbuilder is as follows:,
//Note that the xlsx file here contains many formulas, including two sheet pages. Each sheet page has 3000 rows of data and contains 10 columns where formulas have been written
builder.OpenFile(" 4498a472-a13b-4d14-bd66-f752072c187a.xlsx ");
Var oWorksheet0=Api. GetSheet ("Order Summary");
var deleteRowRange0 = oWorksheet0.GetRows("205:16000");
deleteRowRange0.Delete("up");
builder.SaveFile("xlsx", "resultExcel.xlsx");
builder.CloseFile();
4498a472-a13b-4d14-bd66-f752072c187a.xlsx (4.2 MB)
The captured logs are shown below：
==> /var/log/onlyoffice/documentserver/converter/out.log <==
[2024-07-14T02:35:20.875] [ERROR] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - stdout:
[2024-07-14T02:35:20.875] [ERROR] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - stderr:
[2024-07-14T02:35:20.876] [ERROR] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - ExitCode (code=0;signal=SIGTERM;error:-83)
[2024-07-14T02:35:20.881] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - output (data={"ctx":{"tenant":"localhost","docId":"bld_79fc42d0778c5cc2","userId":"userId"},"cmd":{"builderParams":{},"c":"builder","id":"bld_79fc42d0778c5cc2","format":"docbuilder","url":"http://192.168.14.126:7090/hy/saas/hy/fhcggl/viewimg/hy$fhcggl$2024_7_14$2b5df6cb-5930-4266-be49-068d786d8646.docbuilder","title":"bin","outputpath":"bin","status_info":-83,"nobase64":true}})
[2024-07-14T02:35:20.881] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - postProcess
[2024-07-14T02:35:20.886] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - deleteFolderRecursive
[2024-07-14T02:35:20.887] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - End Task
==> /var/log/onlyoffice/documentserver/docservice/out.log <==
[2024-07-14T02:35:20.893] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - receiveTask start: {"ctx":{"tenant":"localhost","docId":"bld_79fc42d0778c5cc2","userId":"userId"},"cmd":{"builderParams":{},"c":"builder","id":"bld_79fc42d0778c5cc2","format":"docbuilder","url":"http://192.168.14.126:7090/hy/saas/hy/fhcggl/viewimg/hy$fhcggl$2024_7_14$2b5df6cb-5930-4266-be49-068d786d8646.docbuilder","title":"bin","outputpath":"bin","status_info":-83,"nobase64":true}}
[2024-07-14T02:35:20.898] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - receiveTask end
==> /var/log/onlyoffice/documentserver/converter/out.log <==
[2024-07-14T02:35:20.899] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - ackTask addResponse
[2024-07-14T02:35:20.899] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - ackTask ack
==> /var/log/onlyoffice/documentserver/docservice/out.log <==
[2024-07-14T02:35:23.233] [INFO] [localhost] [docId] [userId] nodeJS - forceSaveTimeout start
[2024-07-14T02:35:23.234] [INFO] [localhost] [docId] [userId] nodeJS - forceSaveTimeout end
[2024-07-14T02:35:23.518] [INFO] [localhost] [docId] [userId] nodeJS - builderRequest start
[2024-07-14T02:35:23.520] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - Start convert request
[2024-07-14T02:35:23.526] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - End convert request end false status -83
[2024-07-14T02:35:23.526] [DEBUG] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - End builderRequest request: urls = undefined end = false error = -83
[2024-07-14T02:35:23.526] [INFO] [localhost] [bld_79fc42d0778c5cc2] [userId] nodeJS - builderRequest end