Closed ckjpn closed 5 months ago
This happened for another page as well, so it's a bug not uniquely related to the above page.
I tried to edit this page, too. https://en.wiki.tatoeba.org/articles/show/projects-using-tatoeba
# Projects using Tatoeba
The following page lists projects that use Tatoeba. A "project" can be anything: website, mobile app, research paper, textbook, video...
[http://a4esl.org/temporary/tatoeba/links.html](Link to Projects Using Tatoeba.org's Data and/or the Tanaka Corpus)
-----
See also:
**10,000 sentences**
*About: 10,000 sentences: an Android app to help you learn new words in foreign languages
* URL
[https://github.com/tkrajina/10000sentences(https://github.com/tkrajina/10000sentences)
**thegui’s translations visualization**
* URL: [http://tguinard.github.io/](http://tguinard.github.io/)
* More info: [https://tatoeba.org/eng/wall/show_message/21926#message_21926](https://tatoeba.org/eng/wall/show_message/21926#message_21926)
-----
**CK's tab-delimited bilingual sentence pairs**
[How to Make an Anki Deck with Tatoeba Sentences Using Tab-delimited Bilingual Sentence Pairs that include only Proofread English linked to Native Speaker Sentences](http://www.manythings.org/anki/)
Looks like a bug in Tatowiki. Restarting it just solved the issue, so I am writing down what I noticed in case that bug happens again.
Errors in tatowiki log (journalctl -u tatowiki
), such as:
May 01 21:26:41 sloth tatowiki[29321]: 2023-05-01 21:26:41; cppcms, error: database is locked (SqliteModel.cpp:90)
May 08 00:07:11 sloth tatowiki[29321]: 2023-05-08 00:07:11; tatowiki, error: database is locked (Articles.cpp:109)
Reading operations on the database work, but writing do not, for instance using the CLI:
sqlite> insert into uploads values (200,"foobar", 1675010574);
Error: database is locked
lsof
on the database file reveals a lot of opened file descriptors (88 in total), all opened by tatowiki.
Only one tatowiki process is running.
systemctl restart tatowiki
hangs, leaving tatowiki in some unresponsive state. Need to kill -9
tatowiki and then start it again.
Note: some people reported that using the database in WAL mode solved the problem in their case.
This happened again. Same symptoms, but on the top of that, tatowiki processes were using 100% of the CPU. I enabled WAL mode and restarted tatowiki on tatoeba.org, let’s see if the problem happens again.
So far the problem did not happen again.
Before replying to a message sent to team (at) tatoeba.org, I tried to update this page, https://en.wiki.tatoeba.org/articles/edit/using-the-tatoeba-corpus , with the following text. Clicking, "save" and also trying "save and continue" did not save the text. Only what's up to
## Processing the Tatoeba Corpus
is the change.