aboutsummaryrefslogtreecommitdiff
Commit message (Expand)AuthorAge
...
* Handle NULL better insert-missing-data-and-return-all-ids queries•••Actually check if fields can be NULL, and if they can be then include some extra conditions for the comparison. This will at least make the queries smaller, I'm not sure if it will have an effect on performance. Christopher Baines2020-03-29
* Add a function to fetch information about a table•••Mostly so whether a field can contain NULL values can be determined. Christopher Baines2020-03-29
* Make jobs unique by commit•••Given that a commit, regardless of what repository it comes from should contain the same exactly the same data, just track jobs by commit. Christopher Baines2020-03-28
* Include data in JSON response for the branch page•••Signed-off-by: Christopher Baines <mail@cbaines.net> spf502020-03-28
* Give the temporary database more working memory•••In the hope that this makes the script faster. Christopher Baines2020-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 Baines2020-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 Baines2020-03-26
* Add an unimplemented JSON response for the branch pageChristopher Baines2020-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 Baines2020-03-25
* Create an index on narinfo_fetch_records•••This greatly improves the performance of the derivation-outputs page. Christopher Baines2020-03-25
* Handle channel instances in create-small-backup•••Otherwise this table is empty. Christopher Baines2020-03-25
* Handle system test derivations in create-small-backup•••Otherwise this table is empty. Christopher Baines2020-03-25
* Remove redundant DISTINCT from the derivation range INSERT query•••This was redundant and slow, so don't do it. Christopher Baines2020-03-24
* Pass #:store to checkers that support it•••The derivation checker currently opens a store connection on its own, but by passing the already open connection in, it won't have to do that, and hopefully this will make checking all the packages faster. Christopher Baines2020-03-24
* Stop using package_versions_by_guix_revision_range•••It's been replaced by the package_derivations_by_guix_revision_range table. Christopher Baines2020-03-24
* Implement version history using the derivations table•••Rather than having two big tables looking at the history, just use the derivations table as it has all the information. This will allow deleting the package_versions_by_guix_revision_range table which should help save time when importing revisions, and reduce the size of the database. Christopher Baines2020-03-24
* Fix the date ordering on the package output history pageChristopher Baines2020-03-24
* Sort the lint-warning-message-ids when querying•••This might solve errors where the Guix Data Service is trying to insert a lint_warning_message_set that already exists. Christopher Baines2020-03-23
* Say that there are no lint warnings•••Rather than having an empty table. Christopher Baines2020-03-21
* Change the sort order for derivations on the package version page•••Put the non-cross built derivations first. Christopher Baines2020-03-21
* Add a page for package output history on a branch•••This complements the existing pages for the version history, and derivation history. As well as the new page, the buttons and styling of the two existing pages has been made to match better to enable easier navigation between the pages. Christopher Baines2020-03-21
* Add a new function to get the outputs for a package on a branch•••Similar to the one above for derivations, this just looks at outputs. This filters out equivalent derivations, which can be useful. Christopher Baines2020-03-21
* Fix some tab issues in the Makefile.am fileChristopher Baines2020-03-20
* 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 Baines2020-03-20
* Generate and store system test derivations for all supported systems•••Rather than just the native system. I'm not quite sure of the value here, as I guess system tests should behave the same regardless of the way the software is compiled, but this seems like it could be useful, and being explicit about the system the derivation is for is good. Christopher Baines2020-03-20
* Fix marking jobs as failed when exceptions are raised•••The switch away from catch broke this, I obviously still don't quite get how with-exception-handler works. Therefore, use it twice as that seems to help. Christopher Baines2020-03-19
* Move and improve the "starting the server" message•••Move it after the output relating to narinfo signing, and include the host. Christopher Baines2020-03-14
* Provide more information if the server can't bind the port•••As this could be a common problem. Christopher Baines2020-03-14
* Improve the 404 pages•••Render some HTML rather than the plain response. Christopher Baines2020-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 Baines2020-03-14
* Increase the batch size for fetching builds/narinfo files•••To increase the likelyhood that all the builds and narinfo files for the latest revisions are fetched. Christopher Baines2020-03-14
* Set an order for select-outputs-without-known-nar-entries•••Pulling out the recent entries first. Christopher Baines2020-03-14
* Don't use TRUNCATE CASCADE in the create small backup script•••As it makes it clearer what tables will be truncated. Christopher Baines2020-03-13
* Trip the derivation output details table in the small data dumpChristopher Baines2020-03-13
* Trim derivation source file tables in the small data dumpChristopher Baines2020-03-13
* Query for more recent derivation outputs by default•••Rather than looking for the oldest unknown outputs, as the new ones are generally more useful. Christopher Baines2020-03-12
* Remove peek call that snuck in to the builds moduleChristopher Baines2020-03-02
* Add scripts for generating database dumpsChristopher Baines2020-03-02
* Update http-multiple-get•••Update this by copying the code from Guix again. Christopher Baines2020-03-02
* Improve the builds verbose outputChristopher Baines2020-03-01
* Make the dumps page work when dumps is a symlinkChristopher Baines2020-03-01
* Order build statuses by id, not timestamp•••Some builds from Cuirass change status at the same timestamp, so use the id for ordering instead. Christopher Baines2020-03-01
* Redirect to the latest version of a fileChristopher Baines2020-02-29
* 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 Baines2020-02-28
* Log the time spent in a locked sectionChristopher Baines2020-02-28
* Improve the locking around fetching channel instances•••I think there's still the potential for a race condition when working with the cached checkout of the repository, but this lock was far too wide. The sensitive section is just the latest-channel-instances call, as it adds the relevant files to the store, and that's what's returned. Christopher Baines2020-02-28
* Use Guile 3 for developmentChristopher Baines2020-02-27
* Enable using Guile 3Christopher Baines2020-02-27
* Do some more mocking in the jobs-load-new-guix-revision tests•••To help with getting them running on Guile 3. Christopher Baines2020-02-27
* Improve the error reporting within process-load-new-guix-revision-job•••By including a backtrace. Christopher Baines2020-02-27