| Commit message (Expand) | Author | Age |
|---|
| * | Add a lookup_builds field to the build_servers table•••This is to allow for build servers where only the substitutes should be
queried, and it shouldn't be assumed that they're running Cuirass.
| Christopher Baines | 2020-05-24 |
| * | Move around --no-tablespaces•••Turns out, at the moment, this is ineffective when combined with the archive
formats, like the custom format in use. Therefore, move it to the pg_restore
command, where hopefully it'll work.
| Christopher Baines | 2020-05-16 |
| * | Don't include tablespace assignments in the backup dump•••This is a comprimise, as this won't help restoring the backup in situations
you want tablespaces, but I'm currently viewing tablespaces as a deployment
concern, so maybe the right thing to do is exclude them. This approach will at
least keep the same behaviour in terms of restoring the backups locally.
This will fix the small dump creation process on data.guix.gnu.org, which is
currently broken because of the tablespace assignments when trying to restore
the backups.
| Christopher Baines | 2020-05-14 |
| * | Split out querying of build servers and substitute servers•••These are related things, but somewhat separate. This change should make it
easier to deal with changes regarding querying build servers, and querying
substitute servers.
| Christopher Baines | 2020-05-03 |
| * | Set a statement timeout of 60 seconds for web requests•••This will help stop queries running for an unnecessarily long time, longer
than NGinx will wait for example.
| Christopher Baines | 2020-04-24 |
| * | Rebuild the package derivation ranges table for the small backup•••This is better than just deleting the entries that don't match up with the
remaining revisions, but also not very useful for local development (due to
the lack of data).
| Christopher Baines | 2020-03-31 |
| * | Give the temporary database more working memory•••In the hope that this makes the script faster.
| Christopher Baines | 2020-03-26 |
| * | Use EXPLAIN ANALYZE for the creation of tmp_derivations•••In the create-small-backup script, as this is quite a slow part, it's useful
to get more information.
| Christopher Baines | 2020-03-26 |
| * | Handle a couple more tables in create-small-backup•••derivation_output_details_sets, and derivations_by_output_details_set. This
required moving around some of the code.
| Christopher Baines | 2020-03-26 |
| * | Use the --no-comments option to pg_dump•••Hopefully this will help with the pg_restore in the create-small-backup
script:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2875; 0 0 COMMENT EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql
Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
| Christopher Baines | 2020-03-25 |
| * | Handle channel instances in create-small-backup•••Otherwise this table is empty.
| Christopher Baines | 2020-03-25 |
| * | Handle system test derivations in create-small-backup•••Otherwise this table is empty.
| Christopher Baines | 2020-03-25 |
| * | Stop using package_versions_by_guix_revision_range•••It's been replaced by the package_derivations_by_guix_revision_range table.
| Christopher Baines | 2020-03-24 |
| * | Avoid failures related to renice and ionice•••These parts of the backup scripts are optional, so don't fail if they don't
work.
| Christopher Baines | 2020-03-20 |
| * | Move and improve the "starting the server" message•••Move it after the output relating to narinfo signing, and include the host.
| Christopher Baines | 2020-03-14 |
| * | Improve handling of errors•••Adjust the previously unused error page code, and start to use it. Only show
the error if configured to do so, to avoid leaking secret information.
| Christopher Baines | 2020-03-14 |
| * | Don't use TRUNCATE CASCADE in the create small backup script•••As it makes it clearer what tables will be truncated.
| Christopher Baines | 2020-03-13 |
| * | Trip the derivation output details table in the small data dump | Christopher Baines | 2020-03-13 |
| * | Trim derivation source file tables in the small data dump | Christopher Baines | 2020-03-13 |
| * | Add scripts for generating database dumps | Christopher Baines | 2020-03-02 |
| * | Support customising the latest branch revision max processes•••This makes it possible to set a higher or lower value depending on what you
want.
| Christopher Baines | 2020-02-28 |
| * | Make it possible to query builds servers for specific outputs | Christopher Baines | 2020-02-16 |
| * | Add verbose output to the query-build-servers script | Christopher Baines | 2020-02-15 |
| * | Warn if process-branch-updated-mbox won't match any emails | Christopher Baines | 2020-02-01 |
| * | Guard against failures when loading the narinfo signing public key | Christopher Baines | 2019-12-26 |
| * | Fix the option alist element names for the narinfo signing key | Christopher Baines | 2019-12-26 |
| * | Serve narinfo files for derivations | Christopher Baines | 2019-12-26 |
| * | Fix the query-build-servers script when no commits are provided | Christopher Baines | 2019-12-23 |
| * | Fix the default max-processes for the process-jobs script | Christopher Baines | 2019-12-22 |
| * | Allow customising the maximum number of processes | Christopher Baines | 2019-12-16 |
| * | Add options to the query-build-servers script•••So you can select to query specific build servers.
| Christopher Baines | 2019-12-12 |
| * | Query build servers for narinfo files•••As well as making it possible to only query build servers for builds relating
to a specific revision.
wip-narinfo | Christopher Baines | 2019-11-30 |
| * | Rework the builds and build_status tables as well as related code•••Allow for build status information to be submitted by POST request. This
required some changes to the builds and build_status tables, as for example,
the Cuirass build id may not be available, and the derivation may not be know
yet, so just record the derivation file name.
| Christopher Baines | 2019-11-24 |
| * | Add a script to help manage build servers•••This computes and displays the tokens needed to send build events to the Guix
Data Service.
| Christopher Baines | 2019-11-23 |
| * | Rewrite localhost for sqitch•••As this means that like psql, the unix socket will be used.
| Christopher Baines | 2019-10-01 |
| * | Add a new script to process emails in an mbox file•••This can be used with the mbox files for the guix-commits mailing list to add
older emails in to the database.
| Christopher Baines | 2019-09-28 |
| * | Switch to processing emails as bytevectors•••This is better, as different parts of the email might be encoded differently,
and guile-email will take care of this if handed a bytevector.
| Christopher Baines | 2019-09-26 |
| * | Improve error handling for processing emails | Christopher Baines | 2019-08-31 |
| * | Add a process-job command•••This allows easily processing an individual job by id. This may be useful to
use manually, but also when processing jobs in parallel, as forking doesn't
work well with the libpq library used by squee.
| Christopher Baines | 2019-07-12 |
| * | Associate a name with database connections•••This helps when working out which connection to the database is doing what.
| Christopher Baines | 2019-07-12 |
| * | Use line buffering for the input and output ports•••As these are used for logging, which is done on a line by line basis. Remove
the now redundant calls to (force-output).
| Christopher Baines | 2019-06-17 |
| * | Add --port and --host as options to the guix-data-service | Christopher Baines | 2019-06-13 |
| * | Add an option to create a pid-file•••This'll help the a service manager (like the shepherd) know when the service
is ready, which at the moment, means the database migrations have happened.
| Christopher Baines | 2019-06-11 |
| * | Change to the sqitch directory to run deploy•••As this means it can find the relevant files.
| Christopher Baines | 2019-06-11 |
| * | Pass the --db-client option to sqitch deploy•••So that it can always find psql.
| Christopher Baines | 2019-06-11 |
| * | Pass --plan-file to the sqitch deploy command | Christopher Baines | 2019-06-08 |
| * | Add a --update-database option•••This runs Sqitch on startup, which should make managing the database easier,
as you just have to restart the service with this option, and the database
should be updated if necessary.
| Christopher Baines | 2019-06-07 |
| * | Add missing (guix-data-service database) import | Christopher Baines | 2019-04-17 |
| * | Extract out some database functionality to another module | Christopher Baines | 2019-04-14 |
| * | Remove built guix-data-service-process-branch-updated-email file•••It should never have been committed.
| Christopher Baines | 2019-04-08 |