Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

11 Jul 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-07-21 21:30:01 (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 5206 2025-04-09 15:30:27 2025-04-09 15:30:27
comet_orbits 10019 2025-07-21 17:48:38 2025-07-21 18:01:02
identifications 206919 2025-07-14 12:28:23 2025-07-14 12:28:23
isolated_tracklets 48751936 2025-07-21 21:28:42 2025-07-21 21:28:42
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1091 2025-06-24 16:23:23 2025-06-24 16:23:23
numbered_identifications 1241797 2025-06-22 19:43:06 2025-06-22 19:43:06
numbered_mps 811552 2018-05-31 01:04:45 2025-07-08 10:13:12
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 483007012 2025-07-21 17:48:34 2025-07-21 17:48:34
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1471588 2018-01-25 20:30:17 2025-07-21 15:01:03
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 46 2025-07-21 06:25:12.865452 2025-07-21 21:06:21.625641
neocp_events 278687 2025-07-21 21:06:21.807095 2025-07-21 21:06:21.807095
neocp_obs_archive 707885 2025-07-21 21:06:21.622397 2025-07-21 21:06:21.622397
neocp_obs 366 2025-07-21 21:06:21.614395 2025-07-21 21:06:21.614395
neocp_prev_des 66661 2025-07-21 20:24:05.481941 2025-07-21 20:24:05.481941
neocp_var 90076 2025-07-21 21:06:21.667052 2025-07-21 21:06:21.667052
current_identifications 1981152 2025-07-21 16:20:00.498264 2025-07-21 16:20:00.498264
numbered_identifications 812353 2025-07-02 20:42:14.240799 2025-07-02 21:10:12.477554
primary_objects 1499159 2025-07-21 16:20:00.47158 2025-07-21 16:20:00.47158
obs_sbn 494762746 2025-07-21 17:11:04.652684-04 2025-07-21 17:18:31.568784-04
obs_alterations_deletions 1359951 2025-07-21 17:46:15.217605 2025-07-21 17:46:15.217605
obs_alterations_redesignations 4254 2025-05-21 17:18:42.682759 2025-06-13 07:10:58.084417
obs_alterations_unassociations 421021 2025-07-21 17:46:34.538737 2025-07-21 17:46:34.538737
mpc_orbits 1452022 2025-07-21 21:12:54.05527 2025-07-21 21:12:54.05527
minor_planet_names 25565 2018-03-04 02:26:16 2025-07-08 14:12:32.989
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 494762681 2025-07-21 20:25:34.636211 2025-07-21 21:00:02.894857
MPC_mpcsbndb obs_sbn 494762681 2025-07-21 20:25:34.636211 2025-07-21 21:00:21.728263
SBN_to_AWS obs_sbn 494762687 2025-07-21 21:00:24.550146 2025-07-21 21:00:34.362556
MPC_primarydb current_identifications 1981150 2025-07-21 16:20:00.498264 2025-07-21 21:13:05.419722
MPC_mpcsbndb current_identifications 1981150 2025-07-21 16:20:00.498264 2025-07-21 21:13:06.070893
SBN_to_AWS current_identifications 1981150 2025-07-21 16:20:00.498264 2025-07-21 21:13:06.253065
MPC_primarydb minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-21 21:13:06.458114
MPC_mpcsbndb minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-21 21:13:06.614787
SBN_to_AWS minor_planet_names 25565 2025-07-08 14:12:32.989 2025-07-21 21:13:06.713383
MPC_primarydb mpc_orbits 1452022 2025-07-21 21:12:54.05527 2025-07-21 21:13:06.806878
MPC_mpcsbndb mpc_orbits 1452022 2025-07-21 21:12:54.05527 2025-07-21 21:13:07.756454
SBN_to_AWS mpc_orbits 1452022 2025-07-21 21:12:54.05527 2025-07-21 21:13:07.943034
MPC_primarydb numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-21 21:13:08.228956
MPC_mpcsbndb numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-21 21:13:08.567162
SBN_to_AWS numbered_identifications 812353 2025-07-02 21:10:12.477554 2025-07-21 21:13:08.696963
MPC_primarydb neocp_els 46 2025-07-21 21:06:21.625641 2025-07-21 21:13:08.82836
MPC_mpcsbndb neocp_els 46 2025-07-21 21:06:21.625641 2025-07-21 21:13:08.933317
SBN_to_AWS neocp_els 46 2025-07-21 21:06:21.625641 2025-07-21 21:13:09.017873
MPC_primarydb neocp_events 278687 2025-07-21 21:06:21.807095 2025-07-21 21:13:09.105214
MPC_mpcsbndb neocp_events 278687 2025-07-21 21:06:21.807095 2025-07-21 21:13:09.299523
SBN_to_AWS neocp_events 278687 2025-07-21 21:06:21.807095 2025-07-21 21:13:09.414119
MPC_primarydb neocp_obs 366 2025-07-21 21:06:21.614395 2025-07-21 21:13:09.518892
MPC_mpcsbndb neocp_obs 366 2025-07-21 21:06:21.614395 2025-07-21 21:13:09.621233
SBN_to_AWS neocp_obs 366 2025-07-21 21:06:21.614395 2025-07-21 21:13:09.706411
MPC_primarydb neocp_obs_archive 707885 2025-07-21 21:06:21.622397 2025-07-21 21:13:09.794121
MPC_mpcsbndb neocp_obs_archive 707885 2025-07-21 21:06:21.622397 2025-07-21 21:13:10.053378
SBN_to_AWS neocp_obs_archive 707885 2025-07-21 21:06:21.622397 2025-07-21 21:13:10.173222
MPC_primarydb neocp_prev_des 66661 2025-07-21 20:24:05.481941 2025-07-21 21:13:10.300276
MPC_mpcsbndb neocp_prev_des 66661 2025-07-21 20:24:05.481941 2025-07-21 21:13:10.439624
SBN_to_AWS neocp_prev_des 66661 2025-07-21 20:24:05.481941 2025-07-21 21:13:10.540868
MPC_primarydb neocp_var 90076 2025-07-21 21:06:21.667052 2025-07-21 21:13:10.634897
MPC_mpcsbndb neocp_var 90076 2025-07-21 21:06:21.667052 2025-07-21 21:13:10.79171
SBN_to_AWS neocp_var 90076 2025-07-21 21:06:21.667052 2025-07-21 21:13:10.910458
MPC_primarydb obscodes 2627 2025-07-21 19:53:43.239983 2025-07-21 21:13:11.005239
MPC_mpcsbndb obscodes 2627 2025-07-21 19:53:43.239983 2025-07-21 21:13:11.134455
SBN_to_AWS obscodes 2627 2025-07-21 19:53:43.239983 2025-07-21 21:13:11.219493
MPC_primarydb primary_objects 1499159 2025-07-21 16:20:00.47158 2025-07-21 21:13:11.306922
MPC_mpcsbndb primary_objects 1499159 2025-07-21 16:20:00.47158 2025-07-21 21:13:11.817227
SBN_to_AWS primary_objects 1499159 2025-07-21 16:20:00.47158 2025-07-21 21:13:11.966544
MPC_primarydb obs_alterations_corrections 0 2025-07-21 21:13:12.196417
MPC_mpcsbndb obs_alterations_corrections 0 2025-07-21 21:13:12.298407
SBN_to_AWS obs_alterations_corrections 0 2025-07-21 21:13:12.382911
MPC_primarydb obs_alterations_deletions 1359951 2025-07-21 17:46:15.217605 2025-07-21 21:13:12.470504
MPC_mpcsbndb obs_alterations_deletions 1359951 2025-07-21 17:46:15.217605 2025-07-21 21:13:12.951225
SBN_to_AWS obs_alterations_deletions 1359951 2025-07-21 17:46:15.217605 2025-07-21 21:13:13.077635
MPC_primarydb obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-21 21:13:13.216871
MPC_mpcsbndb obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-21 21:13:13.329544
SBN_to_AWS obs_alterations_redesignations 4254 2025-06-13 07:10:58.084417 2025-07-21 21:13:13.415336