DDD

Ja està arreglat. S'ha de passar periòdicament una tasca per netejar aquestes entrades:

http://ddd.uab.cat/search?p=Abad&f=author&action_browse=Llista

Ha trigat menys de 20 segons:

2010-05-03 17:46:20 --> Task #4696 started.
2010-05-03 17:46:20 --> CLEANING OF UNREFERENCED bibXXx VALUES STARTED
2010-05-03 17:46:39 --> CLEANING OF UNREFERENCED bibXXx VALUES FINISHED
2010-05-03 17:46:39 --> Task #4696 finished. [DONE]

L'he posat perquè s'executi cada dia.

Encara no el puc posar cada dia. El script inveniogc fa diferents tasques:

$ inveniogc --help

Usage: /home/ddd/invenio/bin/inveniogc [options]

Command options:

  -l, --logs        Clean old logs and temporary files.
  -g, --guests        Clean expired guest user related information. [default action]
  -b, --bibxxx        Clean unreferenced bibliographic values in bibXXx tables.
  -c, --cache        Clean cache by removing old files.
  -d, --documents    Clean deleted documents and revisions older than 3650 days.
  -T, --tasks        Clean the BibSched queue removing/archiving old DONE tasks.
  -a, --all        Clean all of the above.

Scheduling options:

  -u, --user=USER    User name to submit the task as, password needed.
  -t, --runtime=TIME    Time to execute the task (now), e.g.: +15s, 5m, 3h, 2002-10-27 13:57:26
  -s, --sleeptime=SLEEP    Sleeping frequency after which to repeat task (no), e.g.: 30m, 2h, 1d
  -P, --priority=PRIORITY    Priority level (an integer, 0 is default)
  -N, --task_specific_name=TASK_SPECIFIC_NAME    Advanced option

General options:

  -h, --help        Print this help.
  -V, --version        Print version information.
  -v, --verbose=LEVEL    Verbose level (0=min, 1=default, 9=max).

Però quan li he dit que les faci totes, ha bloquejat la base de dades amb el missatge ''Too many connections'' i l'he hagut de matar:

ddd@homs:~/tmp$ ilog 4697
---log---
2010-05-03 17:50:00 --> Task #4697 started.
2010-05-03 17:50:00 --> CLEANING OF GUEST SESSIONS STARTED
2010-05-03 17:50:00 --> - deleting expired sessions
2010-05-03 17:50:00 --> - deleting guest users without session
2010-05-03 17:50:00 --> - deleting user_queries referencing non-existent users
2010-05-03 17:52:18 --> - deleting queries not attached to any user

A la propera versió el Tibor diu que es poderan posar aquestes tasques per executar-se a una hora específica, p. ex., del cap de setmana o de nit, però ara mateix s'ha d'afinar una mica a mà.

Ja està posat perquè s'executi de matinada els dissabtes. Deixo la tasca oberta per confirmar el resultat.