You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@texera.apache.org by "carloea2 (via GitHub)" <gi...@apache.org> on 2026/05/21 06:52:19 UTC
[I] Workflow upload hangs forever: pgroonga MeCab index on `content` blocks every INSERT [texera]
carloea2 opened a new issue, #5142:
URL: https://github.com/apache/texera/issues/5142
### What happened?
A bug happened!
### How to reproduce?
q
### Branch
main
### Commit Hash (Optional)
_No response_
### What browsers are you seeing the problem on?
_No response_
### Relevant log output
```shell
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs [texera]
Posted by "Yicong-Huang (via GitHub)" <gi...@apache.org>.
Yicong-Huang commented on issue #5142:
URL: https://github.com/apache/texera/issues/5142#issuecomment-4524707127
> I do not think the search function is working or at least used frequently.
That's orthogonal. Maintain index is needed regardless. If search does not work we should fix it, separately. If search is not used very frequently, maybe because it's not easy to use, then we should improve its user experience. We don't have data to show if that's used frequently or not, though.
Anyway, i still suggest we decouple the workflow content insertion/updating and updating to index somehow. Workflow update is a very frequent endpoint.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs [texera]
Posted by "carloea2 (via GitHub)" <gi...@apache.org>.
carloea2 closed issue #5142: Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs
URL: https://github.com/apache/texera/issues/5142
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs [texera]
Posted by "carloea2 (via GitHub)" <gi...@apache.org>.
carloea2 commented on issue #5142:
URL: https://github.com/apache/texera/issues/5142#issuecomment-4530500446
I agree content search should be preserved, but today it is coupled to the hot write path: `/workflow/persist` writes directly to `workflow`, and the PGroonga index is on `workflow.content`, so every insert/update must synchronously update that index.
So I think the fix should be two-stage:
1. Unblock heavy workflow saves first by removing/limiting `content` from the synchronous PGroonga index, or changing the tokenizer/timeouts so JSON content cannot hang writes.
2. Restore safer content search separately through an async index path, e.g. a search table/queue updated after the workflow transaction commits.
Maybe @mengw15 or @Ma77Ball have some better solution?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs [texera]
Posted by "Yicong-Huang (via GitHub)" <gi...@apache.org>.
Yicong-Huang commented on issue #5142:
URL: https://github.com/apache/texera/issues/5142#issuecomment-4521174763
can we decouple insertion/updates with index update? I don't think we can simply drop the index as we need to search workflow content. ideally we should make index updates not blocking transactional updates to workflow itself.
This is really a hot path: workflows are being updated quite often when users are editing. So we'd better fulfill the correctness (make sure update can succeed) first.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Workflow upload hangs indefinitely: pgroonga `TokenMecab` index on `workflow.content` blocks INSERTs [texera]
Posted by "carloea2 (via GitHub)" <gi...@apache.org>.
carloea2 commented on issue #5142:
URL: https://github.com/apache/texera/issues/5142#issuecomment-4524317863
I do not think the search function is working or at least used frequently.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@texera.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org