jobs: Force builders to refresh repository data all the time

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sync: Write timestamp so that we can track when mirrors were synced last

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

mirrors: Fix joining paths

The original path of the mirror was unintentionally dropped.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Store groups as string array

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Store build ID as UUID

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Store build arches and apply them when creating jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Only check out those files that we need

Since the entire build service is very heavy on I/O, we should avoid
writing files that we don't need.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Create an index over the superseeded_by field

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Capture & store Pakfire log on dist()

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

config: Add PakfireLogger class

This class can be used to capture the log from Pakfire in order to debug
issues easier.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Fix styling of edit page

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Call dispatch after launching any jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Fix call to launch builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repo: Add simple API operations

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Don't remove builds that have been removed before

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Reset jobs as successful if following jobs succeed

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Show logs of previous attempts

Fixes: #13249 - jobs: Add option to download logs from previous attempts
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Immediately launch builds in the transaction

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Read archive metadata in executor thread

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Fail more gracefully if a package has been deleted from disk

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Re-add accidentially removed import of the queue module

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Don't keep so many connections open and idle

Since we usually peak briefly, we will fork a lot of PostgreSQL
processes that we will never need again. In order to avoid wasting too
much memory, we close those connections quicker, but at least 8 open so
that new tasks will quickly be able to acquire a database connection.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds+jobs: Use new methods to access database objects

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Show message if no jobs are queued

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Log deleting packages

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Try to delete packages if creating build fails

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Don't try to overwrite existing packages

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Remove some unnecessary imports

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Extract filelists in a separate thread

Since we need to read the entire archive to extract the entire filelist
with all its meta information, we need to move this into a separate
thread.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Tail logs more efficiently

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Automatically launch builds after dist

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

cache: Tidy up code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: Create a simple rate limiter

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Do not try to update a bug that has never been created

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

cache: Implement an async redis cache driver

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Launch installcheck in transactions and wait for it

It can happen that a transaction is being rolled back and an
installcheck has been queued which will then run into errors.

Since the installcheck is now fast enough, we can simply wait for it
with the exception of relaunching any pending jobs in repositories which
will be run as one single task in the background.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitoring: Put the rate limiter in the correct place

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitoring: Complete configuration before running the first check

Because we are communicating with Bugzilla (potentially) we might undo a
lot of stuff if there is any error.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

config: Pass configuration as file object

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

config: Make Pakfire an async context manager

This should help us to block less when initializing a Pakfire instance.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

users: Show controls to create repos when none exist

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Use new version compare function

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: Use aiofiles for asyncio handling of temporary files

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

index: Show recently finished jobs instead of pending ones

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Move job queue

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Add option to only show failed builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: queue: Show build time for finished jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: queue: Show status for failed/finished jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Group by date

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Add pagination to new page

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Create new page that lists all finished jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: Create UI module for queued jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Fix indefinite loop in dispatch function

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Fix SQL query to fetch all release/scratch builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

logstreams: Increase the maximum number of log messages stored

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

logstream: Lock buffer when it is being modified

This might be cheaper than copying it when it becomes large.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

Revert "logstreams: Don't wait until all messages have been delivered to all consumers"

This reverts commit 1fa487c5455f3e4a63ae0755c466c2a7ee62b4e5.

This might potentially shuffle the messages :(

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Run fewer installchecks

Only run this for jobs that have previously failed.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Perform installcheck before a job is being dispatched

I would like to perform fewer of the installchecks because they unlikely
to fail and rather expensive to run.

This is a safety net so that we will never dispatch any jobs that cannot
be built.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

logstreams: Copy buffer before sending it off

collections.deque() does not allow us to append new messages while we
are reading from it.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

logstreams: Don't wait until all messages have been delivered to all consumers

This will just queue tasks for all new messages and allows us to get
back to processing the next message quicker.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Return zero for total build time if there are no builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Include disabled builders in autoscale

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repositories: Master repositories as async as possible

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

robots.txt: Disallow download files from packages

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: make_url: Filter out any values that are None

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Commit forgotten bug templates

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Use the more efficient version comparison function

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Close connections sooner

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Move database operations into the main thread

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Replace more occurences of the UUID type

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Move all sorts of database operations into the main thread

We no longer support any database operations from any other thread than
the main thread (because otherwise we cannot figure out which Task we
are running in).

For that reason, we have to split a couple of tasks off at different
times and send blocking operations to an executor thread later.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: psycopg3 is returning UUIDs as UUID type instead of string

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Fix cleaning up the repository if none was created

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Replace the old database model with a connection pool

This patch introduces a connection pool to the database. When a function
is executing a query, a connection will be handed to the (asyncio) Task
and remains with that task until its end.

That way, multiple concurrent tasks (even when they are running in the
same thread) will have an exclusive connection to the database which
will avoid that we overwrite and commit transactions of other tasks.

Additionally, transactions can now be nested as psycopg's transactions
are more advanced than the previous Transaction class.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: Move temporary tables into CTEs

It was a nice idea, but if we want to pool connections, we will only
create the temporary tables on one connection with the others losing
out.

An alternative could have been to create all tables on all connections
first, but I suppose that is going to create a lot of unnecessary
overhead for short-lived connections.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: jobs: Add HTTP status code to exception

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Remove aliases for common exceptions

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

database: Migrate to psycopg3

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Show better tags

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

CSS: Don't use our custom red as it clashes with the primary colour

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Fix rendering page when source has never been fetched

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Create dist jobs for all packages on the initial commit import

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Store empty strings if summary/description are empty

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

db: Sync schema

I don't quite know why the diff is so large when there have been only a
few fields changed...

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Catch the correct exception on disconnect

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: Avoid removing the tmp directory

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

distros: Actually filter the latest release

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

releases: Implement controls to publish

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

releases: "Publish" instead of "Release"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

distros: Link to releases

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

releases: Implement controls to delete a release

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

events: Add releases

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

releases: Add controls to create and edit releases

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release: Drop reference to repositories

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

releases: Change prerelease to stable

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

distros: Add scaffolding for releases

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Add detail page for commits

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Add any watchers from commits to builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Refactor Commit class

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>