Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Canceled bbrf process keeps running on CouchDB #62

Open
pdelteil opened this issue May 6, 2021 · 3 comments
Open

Canceled bbrf process keeps running on CouchDB #62

pdelteil opened this issue May 6, 2021 · 3 comments
Labels
bug Something isn't working performance

Comments

@pdelteil
Copy link
Contributor

pdelteil commented May 6, 2021

I have tested this situation many times:

  1. Running a heavy process (deleting over 100k urls or domains)
  2. Press Control + C
  3. Processes on the CouchDB server keep running. Sometimes overloading the server.

I often need to restart the DB in order to get rid of the left over processes.
This might be the cause for the 'unknown error' described in another issue.

@pdelteil
Copy link
Contributor Author

pdelteil commented May 6, 2021

I'm having better results removing data using chunks:

This oneliner will remove the urls in steps of 5000 urls
chunk=5000; size=$(bbrf urls|wc -l); urls="1,${chunk}p" parts=$((size%chunk?size/chunk+1:size/chunk)) ; echo $parts ; for i in $(seq 1 $parts) ; do echo "try $i"; bbrf urls|sed -n "$urls"|bbrf url remove - ; done

@honoki
Copy link
Owner

honoki commented May 17, 2021

Thanks, Philippe. This sounds like it should help me improve performance for large input data.

@pdelteil
Copy link
Contributor Author

Your welcome @honoki.

After more testing I can confirm that using chunks works faster and it's more reliable than the regular way.

@pdelteil pdelteil changed the title [issue] Cancelling bbrf process keeps running on CouchDB [issue] Canceled bbrf process keeps running on CouchDB May 18, 2021
@honoki honoki added the bug Something isn't working label Jan 2, 2022
@honoki honoki changed the title [issue] Canceled bbrf process keeps running on CouchDB Canceled bbrf process keeps running on CouchDB Jan 2, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working performance
Projects
None yet
Development

No branches or pull requests

2 participants