sql: several privileges show without user action #46757
Description
I started a cluster on roachprod and noticed that it made several privilege jobs:
root@localhost:26257/defaultdb> show jobs;
job_id | job_type | description | statement | user_name | status | running_status | created | started | finished | modified | fraction_completed | error | coordinator_id
---------------------+---------------+---------------------+-----------+-----------+-----------+----------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------+-------+-----------------
542428507073282049 | SCHEMA CHANGE | updating privileges | | root | succeeded | NULL | 2020-03-30 22:14:03.417699+00:00 | 2020-03-30 22:14:03.426879+00:00 | 2020-03-30 22:14:03.429971+00:00 | 2020-03-30 22:14:03.429491+00:00 | 1 | | 1
542428507010629633 | SCHEMA CHANGE | updating privileges | | root | succeeded | NULL | 2020-03-30 22:14:03.398563+00:00 | 2020-03-30 22:14:03.407858+00:00 | 2020-03-30 22:14:03.411415+00:00 | 2020-03-30 22:14:03.410912+00:00 | 1 | | 1
542428506943520769 | SCHEMA CHANGE | updating privileges | | root | succeeded | NULL | 2020-03-30 22:14:03.378102+00:00 | 2020-03-30 22:14:03.387405+00:00 | 2020-03-30 22:14:03.390739+00:00 | 2020-03-30 22:14:03.390019+00:00 | 1 | | 1
542428506877296641 | SCHEMA CHANGE | updating privileges | | root | succeeded | NULL | 2020-03-30 22:14:03.357827+00:00 | 2020-03-30 22:14:03.368937+00:00 | 2020-03-30 22:14:03.372304+00:00 | 2020-03-30 22:14:03.371828+00:00 | 1 | | 1
(4 rows)
Time: 1.960419msWhat are these jobs? I can't see any information about these jobs.
To repro:
export CLUSTER=andy-3node
roachprod create $CLUSTER -n 4 --clouds=aws --aws-machine-type-ssd=c5d.4xlarge
roachprod run $CLUSTER -- "sudo umount /mnt/data1; sudo mount -o discard,defaults,nobarrier /mnt/data1/; mount | grep /mnt/data1"
roachprod stage $CLUSTER:1-3 cockroach
roachprod stage $CLUSTER:4 workload
roachprod start $CLUSTER:1-3
roachprod adminurl --open $CLUSTER:1
V20.1.0-BETA.4-187-G93CB2EB