Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

21 Jan 2025

  1. Nominal.

Please report concerns!

KEY

Database Replication

Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2025-02-18 15:50:02 (GMT)

Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.

MariaDB mpc_development:

Source file of data: statusDB.csv

Table Count Created_at Updated_at
comet_names 5202 2017-03-15 16:46:33 2025-02-02 03:55:25
comet_orbits 9877 2020-02-05 20:51:19 2025-02-11 22:01:02
identifications 204278 2025-02-18 12:29:43 2025-02-18 12:29:43
isolated_tracklets 48232009 2025-02-18 15:17:26 2025-02-18 15:17:26
mp_discoverers 1937686 2014-10-19 04:36:17 2025-01-30 01:06:24
mpc_indices 396 2025-02-18 15:30:02 2025-02-18 15:30:02
numbered_comet_identifications 1075 2024-10-16 07:14:24 2024-10-16 07:14:24
numbered_identifications 1199480 2025-02-07 17:43:41 2025-02-07 17:43:41
numbered_mps 773916 2024-12-04 00:54:24 2025-02-11 16:12:22
obs_request_observers 52 2019-07-24 16:57:48 2019-07-24 16:57:48
obs_request_users 7 2015-12-04 00:25:22 2015-12-04 00:25:22
observations 468478969 2025-02-18 14:13:21 2025-02-18 14:13:21
orbit_uncertainties 785438 2019-06-05 12:14:34 2024-12-03 08:16:15
orbits 1454112 2015-01-08 22:08:35 2025-02-18 15:51:58
radar_observations 1507 2024-12-04 04:59:18 2024-12-04 04:59:18
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 27 2025-01-06 13:25:45.176306 2025-02-18 14:10:25.504316
neocp_events 262299 2025-02-18 15:52:13.454683 2025-02-18 15:52:13.454683
neocp_obs_archive 666792 2025-02-18 14:10:25.458955 2025-02-18 14:10:25.458955
neocp_obs 536 2025-02-18 14:10:25.415472 2025-02-18 14:10:25.415472
neocp_prev_des 64563 2025-02-18 15:52:13.328798 2025-02-18 15:52:13.328798
neocp_var 48625 2025-02-18 14:10:40.819446 2025-02-18 14:10:40.819446
current_identifications 1963416 2025-02-18 14:30:40.716234 2025-02-18 14:31:35.44885
numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-06 01:18:26.171581
primary_objects 1482714 2025-02-18 14:30:40.649065 2025-02-18 14:30:40.649065
obs_sbn 479357829 2025-02-18 04:52:49.171514-05 2025-02-18 10:52:06.175525-05
obs_alterations_deletions 1315523 2025-02-18 00:59:44.679949 2025-02-18 00:59:44.679949
obs_alterations_redesignations 4163 2025-02-14 11:55:38.39341 2025-02-14 11:55:38.39341
obs_alterations_unassociations 365176 2025-02-18 12:13:30.139713 2025-02-18 12:13:30.139713
mpc_orbits 1430670 2021-02-03 22:59:50.245409 2025-02-18 15:52:56.24462
No change to Postgres mpc_sbn database structure

YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old

Replication status view MPC-master → [SBN] → MPC-replica:

Server Table Count Updated_at Queried_at
MPC_primarydb obs_sbn 479348845 2025-02-18 14:57:54.299639 2025-02-18 15:00:01.805395
MPC_mpcsbndb obs_sbn 479348845 2025-02-18 14:57:54.299639 2025-02-18 15:00:14.187218
SBN_to_AWS obs_sbn 479348845 2025-02-18 14:57:54.299639 2025-02-18 15:05:12.209812
MPC_primarydb current_identifications 1963416 2025-02-18 14:31:35.44885 2025-02-18 15:10:07.505943
MPC_mpcsbndb current_identifications 1963416 2025-02-18 14:31:35.44885 2025-02-18 15:10:07.927459
SBN_to_AWS current_identifications 1963416 2025-02-18 14:31:35.44885 2025-02-18 15:10:08.115112
MPC_primarydb mpc_orbits 1430670 2025-02-18 15:10:02.114861 2025-02-18 15:10:08.381675
MPC_mpcsbndb mpc_orbits 1430670 2025-02-18 15:10:02.114861 2025-02-18 15:10:09.035726
SBN_to_AWS mpc_orbits 1430670 2025-02-18 15:10:02.114861 2025-02-18 15:10:09.208716
MPC_primarydb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-18 15:10:09.470244
MPC_mpcsbndb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-18 15:10:09.876776
SBN_to_AWS numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-18 15:10:10.008809
MPC_primarydb neocp_els 27 2025-02-18 14:10:25.504316 2025-02-18 15:10:10.223836
MPC_mpcsbndb neocp_els 27 2025-02-18 14:10:25.504316 2025-02-18 15:10:10.321732
SBN_to_AWS neocp_els 27 2025-02-18 14:10:25.504316 2025-02-18 15:10:10.403842
MPC_primarydb neocp_events 262298 2025-02-18 14:10:40.955749 2025-02-18 15:10:10.574761
MPC_mpcsbndb neocp_events 262298 2025-02-18 14:10:40.955749 2025-02-18 15:10:10.716438
SBN_to_AWS neocp_events 262298 2025-02-18 14:10:40.955749 2025-02-18 15:10:10.827525
MPC_primarydb neocp_obs 536 2025-02-18 14:10:25.415472 2025-02-18 15:10:11.024517
MPC_mpcsbndb neocp_obs 536 2025-02-18 14:10:25.415472 2025-02-18 15:10:11.12165
SBN_to_AWS neocp_obs 536 2025-02-18 14:10:25.415472 2025-02-18 15:10:11.203699
MPC_primarydb neocp_obs_archive 666792 2025-02-18 14:10:25.458955 2025-02-18 15:10:11.37498
MPC_mpcsbndb neocp_obs_archive 666792 2025-02-18 14:10:25.458955 2025-02-18 15:10:11.543911
SBN_to_AWS neocp_obs_archive 666792 2025-02-18 14:10:25.458955 2025-02-18 15:10:11.661355
MPC_primarydb neocp_prev_des 64562 2025-02-18 13:35:25.869091 2025-02-18 15:10:11.867881
MPC_mpcsbndb neocp_prev_des 64562 2025-02-18 13:35:25.869091 2025-02-18 15:10:11.982801
SBN_to_AWS neocp_prev_des 64562 2025-02-18 13:35:25.869091 2025-02-18 15:10:12.079085
MPC_primarydb neocp_var 48625 2025-02-18 14:10:40.819446 2025-02-18 15:10:12.264717
MPC_mpcsbndb neocp_var 48625 2025-02-18 14:10:40.819446 2025-02-18 15:10:12.384732
SBN_to_AWS neocp_var 48625 2025-02-18 14:10:40.819446 2025-02-18 15:10:12.484934
MPC_primarydb primary_objects 1482714 2025-02-18 14:30:40.649065 2025-02-18 15:10:12.672289
MPC_mpcsbndb primary_objects 1482714 2025-02-18 14:30:40.649065 2025-02-18 15:10:12.907017
SBN_to_AWS primary_objects 1482714 2025-02-18 14:30:40.649065 2025-02-18 15:10:13.072018
MPC_primarydb obs_alterations_corrections 0 2025-02-18 15:10:13.323859
MPC_mpcsbndb obs_alterations_corrections 0 2025-02-18 15:10:13.421694
SBN_to_AWS obs_alterations_corrections 0 2025-02-18 15:10:13.503911
MPC_primarydb obs_alterations_deletions 1315523 2025-02-18 00:59:44.679949 2025-02-18 15:10:13.674906
MPC_mpcsbndb obs_alterations_deletions 1315523 2025-02-18 00:59:44.679949 2025-02-18 15:10:13.967544
SBN_to_AWS obs_alterations_deletions 1315523 2025-02-18 00:59:44.679949 2025-02-18 15:10:14.088789
MPC_primarydb obs_alterations_redesignations 4163 2025-02-14 11:55:38.39341 2025-02-18 15:10:14.297128
MPC_mpcsbndb obs_alterations_redesignations 4163 2025-02-14 11:55:38.39341 2025-02-18 15:10:14.398096
SBN_to_AWS obs_alterations_redesignations 4163 2025-02-14 11:55:38.39341 2025-02-18 15:10:14.481497