Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

18 Nov 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-11-29 06: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 5214 2025-10-23 17:12:59 2025-10-23 17:12:59
comet_orbits 11198 2025-02-07 23:25:28 2025-11-26 00:01:10
identifications 210959 2025-11-28 12:18:52 2025-11-28 12:18:52
isolated_tracklets 49547912 2025-11-29 06:27:36 2025-11-29 06:27:36
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1292 2025-10-23 16:03:49 2025-10-23 16:03:49
numbered_identifications 1319125 2025-10-22 17:46:28 2025-10-22 17:46:28
numbered_mps 875150 2025-10-23 01:12:58 2025-11-19 17:03:38
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 502389337 2025-11-29 03:28:23 2025-11-29 03:28:23
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1495759 2025-11-29 03:28:28 2025-11-29 04:01:09
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 140 2025-11-28 10:29:27.969852 2025-11-29 06:30:19.184794
neocp_events 299179 2025-11-29 06:30:19.390889 2025-11-29 06:30:19.390889
neocp_obs_archive 752954 2025-11-29 06:30:19.171995 2025-11-29 06:30:19.171995
neocp_obs 1451 2025-11-29 06:30:19.158638 2025-11-29 06:30:19.158638
neocp_prev_des 69429 2025-11-29 03:28:42.483935 2025-11-29 03:28:42.483935
neocp_var 269617 2025-11-29 06:30:19.230161 2025-11-29 06:30:19.230161
current_identifications 2005949 2020-07-30 16:16:48.988946 2025-11-29 06:20:29.729854
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1521994 2025-11-29 05:46:35.055154 2025-11-29 05:46:35.055154
obs_sbn 513806154 2025-11-28 13:44:04.821447-05 2025-11-29 01:33:43.648437-05
obs_alterations_deletions 1387343 2025-11-28 19:40:09.925229 2025-11-28 19:40:09.925229
obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-23 14:47:23.199793
obs_alterations_unassociations 526052 2025-11-29 06:10:06.918478 2025-11-29 06:10:06.918478
mpc_orbits 1477880 2021-02-03 22:42:13.334328 2025-11-29 06:33:56.585954
minor_planet_names 25881 2015-06-03 22:57:34 2025-11-19 22:03:16.504632
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 513787924 2025-11-29 06:00:02.403931 2025-11-29 06:00:02.933218
MPC_mpcsbndb obs_sbn 513788157 2025-11-29 06:00:22.876044 2025-11-29 06:00:23.823989
SBN_to_AWS obs_sbn 513788541 2025-11-29 06:01:06.687534 2025-11-29 06:01:08.519149
MPC_primarydb current_identifications 2005949 2025-11-29 05:47:10.592127 2025-11-29 06:10:38.863416
MPC_mpcsbndb current_identifications 2005949 2025-11-29 05:47:10.592127 2025-11-29 06:10:39.811108
SBN_to_AWS current_identifications 2005949 2025-11-29 05:47:10.592127 2025-11-29 06:10:40.099215
MPC_primarydb minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 06:10:40.583563
MPC_mpcsbndb minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 06:10:40.733961
SBN_to_AWS minor_planet_names 25881 2025-11-19 22:03:16.504632 2025-11-29 06:10:40.834912
MPC_primarydb mpc_orbits 1477880 2025-11-29 06:10:39.082154 2025-11-29 06:10:40.940547
MPC_mpcsbndb mpc_orbits 1477880 2025-11-29 06:10:42.37455 2025-11-29 06:10:43.606611
SBN_to_AWS mpc_orbits 1477880 2025-11-29 06:10:42.37455 2025-11-29 06:10:44.155906
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 06:10:45.024361
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 06:10:45.401062
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-11-29 06:10:45.545531
MPC_primarydb neocp_els 140 2025-11-29 05:31:19.664048 2025-11-29 06:10:45.697873
MPC_mpcsbndb neocp_els 140 2025-11-29 05:31:19.664048 2025-11-29 06:10:45.800303
SBN_to_AWS neocp_els 140 2025-11-29 05:31:19.664048 2025-11-29 06:10:45.888725
MPC_primarydb neocp_events 299177 2025-11-29 05:31:19.844778 2025-11-29 06:10:45.982675
MPC_mpcsbndb neocp_events 299177 2025-11-29 05:31:19.844778 2025-11-29 06:10:46.175169
SBN_to_AWS neocp_events 299177 2025-11-29 05:31:19.844778 2025-11-29 06:10:46.296727
MPC_primarydb neocp_obs 1443 2025-11-29 05:31:19.652809 2025-11-29 06:10:46.417572
MPC_mpcsbndb neocp_obs 1443 2025-11-29 05:31:19.652809 2025-11-29 06:10:46.519671
SBN_to_AWS neocp_obs 1443 2025-11-29 05:31:19.652809 2025-11-29 06:10:46.609066
MPC_primarydb neocp_obs_archive 752946 2025-11-29 05:31:19.661414 2025-11-29 06:10:46.715794
MPC_mpcsbndb neocp_obs_archive 752946 2025-11-29 05:31:19.661414 2025-11-29 06:10:46.961924
SBN_to_AWS neocp_obs_archive 752946 2025-11-29 05:31:19.661414 2025-11-29 06:10:47.114189
MPC_primarydb neocp_prev_des 69429 2025-11-29 03:28:42.483935 2025-11-29 06:10:47.262751
MPC_mpcsbndb neocp_prev_des 69429 2025-11-29 03:28:42.483935 2025-11-29 06:10:47.397941
SBN_to_AWS neocp_prev_des 69429 2025-11-29 03:28:42.483935 2025-11-29 06:10:47.504713
MPC_primarydb neocp_var 269612 2025-11-29 05:31:19.696479 2025-11-29 06:10:47.610444
MPC_mpcsbndb neocp_var 269612 2025-11-29 05:31:19.696479 2025-11-29 06:10:47.944907
SBN_to_AWS neocp_var 269612 2025-11-29 05:31:19.696479 2025-11-29 06:10:48.091098
MPC_primarydb obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 06:10:48.245292
MPC_mpcsbndb obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 06:10:48.362427
SBN_to_AWS obscodes 2662 2025-11-26 17:50:15.357439 2025-11-29 06:10:48.452354
MPC_primarydb primary_objects 1521994 2025-11-29 05:46:35.055154 2025-11-29 06:10:48.546981
MPC_mpcsbndb primary_objects 1521994 2025-11-29 05:46:35.055154 2025-11-29 06:10:49.201351
SBN_to_AWS primary_objects 1521994 2025-11-29 05:46:35.055154 2025-11-29 06:10:49.419847
MPC_primarydb obs_alterations_corrections 0 2025-11-29 06:10:49.956128
MPC_mpcsbndb obs_alterations_corrections 0 2025-11-29 06:10:50.056173
SBN_to_AWS obs_alterations_corrections 0 2025-11-29 06:10:50.143512
MPC_primarydb obs_alterations_deletions 1387343 2025-11-28 19:40:09.925229 2025-11-29 06:10:50.234762
MPC_mpcsbndb obs_alterations_deletions 1387343 2025-11-28 19:40:09.925229 2025-11-29 06:10:50.760206
SBN_to_AWS obs_alterations_deletions 1387343 2025-11-28 19:40:09.925229 2025-11-29 06:10:50.899555
MPC_primarydb obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 06:10:51.055191
MPC_mpcsbndb obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 06:10:51.162105
SBN_to_AWS obs_alterations_redesignations 4426 2025-11-23 14:47:23.199793 2025-11-29 06:10:51.251861