Page History

Rice Repository Groups

• Campus Repositories
• IT Repositories
• HPC Repositories

Statistics

{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository_group{sql}

{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_status <> 'deleted'{sql}

{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_public = false and repo_status <> 'deleted'{sql}

{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_public = true and repo_status <> 'deleted'{sql}

{sql:dataSource=wiki|output=wiki|table=false}select repo_group_code || '.' || repo_name as name from owl_repository where repo_status <> 'deleted' order by repo_size desc limit 1{sql}

{sql:dataSource=wiki|output=wiki|table=false}select distinct d.repo_group_code || '.' || d.repo_name as name from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and (d.repo_group_code, d.repo_name, d.repo_revision) in (select repo_group_code, repo_name, max(repo_revision) from owl_repository_data where repo_name <> 'subversion' and repo_group_code <> 'it.svn' group by repo_group_code, repo_name order by max desc limit 1);{sql}

{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_access_file_exists = false and repo_group_code <> 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted'{sql}

What is Subversion?

Subversion is a free/open-source version control system. That is, Subversion manages files and directories, and the changes made to them, over time. This allows you to recover older versions of your data, or examine the history of how your data changed. In this regard, many people think of a version control system as a sort of "time machine".

What is a Repository group?

A repository group is a collection of repositories that share common characteristics, like backup policy, retention policy, specialized hooks. Each repository group also has its own name space for repository names.

Can I have a Repository group for my group?

Good question. Generally, we'd like to restrict groups to only major entities who will have many repositories. This means that in most cases this will be limited to departments, if they have a need for it. Creating a repository group is a fairly major process and requires that the subversion servers be taken off line. Due to this requirement, groups will only be created at specific points in the year to avoid impacting those using the server.

Subversion Maintenance Schedule

Regular maintenance

• Wednesday mornings from 6am to 7am

Next Repository group creation

• July 27th 8am - 8pm.

{sql:dataSource=wiki|output=wiki}
select 161061273600/1024/1024 as total, trunc((161061273600 - sum(r.repo_size)*2)/1024/1024) as free, trunc((sum(r.repo_size)*2)/1024/1024) as used from owl_repository r where r.repo_status <> 'deleted'
{sql}

{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'svn' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}

{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'svn' group by name order by revision desc limit 10
{sql}

{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}

{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'it.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}

{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'hpc.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}

{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'hpc.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}