[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#633531: qa.debian.org: popcon tables not updated



* Yaroslav Halchenko <debian@onerussian.com>, 2011-08-18, 18:37:
Also the page signature says "Last generated on Sat Feb 19 13:14:02 2011 UTC" which seems to be a while.

This is a red herring - it's a time when the PHP file was generated, not when data was generated. However, the data is also out-of-date:
| $ cd /org/qa.debian.org/data/popcon/ && ls -l --time-style=long-iso popcon*
| -rw-rw-r-- 1 qa qa    299549 2011-06-22 15:52 popcon
| -rw-rw-r-- 1 qa qa 134221824 2011-06-22 15:51 popcon.db

/org/qa.debian.org/data/cronjobs/popcon looks like this:
| #!/bin/bash -e
| # CRON=50 15 * * *
| # MAILTO+=geissert@debian.org
|
| umask 002
| cd /org/qa.debian.org/data/popcon
|
| lockfile -r0 .popcon.lock 2> /dev/null || exit 1
|
| ./extract_popcon.py
| ./extract_popcon-tobdb.py
|
| mv -f popcon{-new,}
| mv -f popcon{-new,}.db
|
| rm -f .popcon.lock

The first script is for updating PostgreSQL database (used by DDPO), the latter for updating Berkley database (used by everything else). My testing shows that extract_popcon-tobdb.py works flawlessly; unfortunately I cannot test extract_popcon.py. Given the fact that DDPO data also appear to be out of date, I suspect that extract_popcon.py fails.

--
Jakub Wilk



Reply to: