Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

25 Feb 2026

  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

2026-03-24 13: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 5215 2026-03-06 22:06:00 2026-03-06 22:06:00
comet_orbits 12566 2018-10-29 23:02:13 2026-03-21 22:01:25
identifications 218135 2026-03-24 12:27:35 2026-03-24 12:27:35
isolated_tracklets 49861173 2026-03-24 13:07:07 2026-03-24 13:07:07
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 1333152 2026-03-05 21:16:52 2026-03-05 21:16:52
numbered_mps 887103 2026-03-05 21:21:21 2026-03-20 15:09:13
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 512015346 2026-03-24 12:31:19 2026-03-24 12:31:19
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1535214 2026-03-05 21:11:26 2026-03-24 13:01:42
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 104 2026-02-03 15:31:03.146684 2026-03-24 13:21:30.489341
neocp_events 318050 2026-03-24 13:07:07.974418 2026-03-24 13:07:07.974418
neocp_obs_archive 796653 2026-03-24 13:06:57.147249 2026-03-24 13:06:57.147249
neocp_obs 1610 2026-03-24 13:06:57.064951 2026-03-24 13:06:57.064951
neocp_prev_des 71685 2026-03-24 13:07:07.918587 2026-03-24 13:07:07.918587
neocp_var 213823 2026-03-24 13:06:57.261135 2026-03-24 13:06:57.261135
current_identifications 2047982 2026-03-24 13:04:52.185034 2026-03-24 13:05:46.388886
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560563 2026-03-24 13:04:52.156549 2026-03-24 13:04:52.156549
obs_sbn 532567392 2026-03-24 09:18:32.45393-04 2026-03-24 09:30:17.594801-04
obs_alterations_deletions 1495538 2026-03-24 10:11:08.9577 2026-03-24 10:11:08.9577
obs_alterations_redesignations 5010 2026-03-23 20:57:57.48142 2026-03-23 20:57:57.48142
obs_alterations_unassociations 565161 2026-03-23 21:24:22.067004 2026-03-23 21:24:22.067004
mpc_orbits 1518955 2021-02-03 22:41:56.470409 2026-03-24 13:29:03.379493
minor_planet_names 26118 2013-03-28 19:50:22 2026-03-20 19:08:47.331146
obscodes 2687 2019-05-25 00:11:24.513966 2026-03-18 19:10:45.593554
comet_names 4369 2026-03-21 17:41:18.237003 2026-03-21 17:41:18.237003
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 532545907 2026-03-24 12:56:00.993605 2026-03-24 13:00:02.872905
MPC_mpcsbndb obs_sbn 532545907 2026-03-24 12:56:00.993605 2026-03-24 13:00:16.090638
SBN_to_AWS obs_sbn 532545907 2026-03-24 12:56:00.993605 2026-03-24 13:00:39.443291
MPC_primarydb current_identifications 2047981 2026-03-24 12:27:33.039918 2026-03-24 13:01:23.07027
MPC_mpcsbndb current_identifications 2047981 2026-03-24 12:27:33.039918 2026-03-24 13:01:23.80918
SBN_to_AWS current_identifications 2047981 2026-03-24 12:27:33.039918 2026-03-24 13:01:23.945979
MPC_primarydb comet_names 4369 2026-03-21 17:41:18.237003 2026-03-24 13:01:24.117533
MPC_mpcsbndb comet_names 4369 2026-03-21 17:41:18.237003 2026-03-24 13:01:24.227032
SBN_to_AWS comet_names 4369 2026-03-21 17:41:18.237003 2026-03-24 13:01:24.315092
MPC_primarydb minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-24 13:01:24.405736
MPC_mpcsbndb minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-24 13:01:24.562502
SBN_to_AWS minor_planet_names 26118 2026-03-20 19:08:47.331146 2026-03-24 13:01:24.665215
MPC_primarydb mpc_orbits 1518954 2026-03-24 12:39:24.913446 2026-03-24 13:01:24.760894
MPC_mpcsbndb mpc_orbits 1518954 2026-03-24 12:39:24.913446 2026-03-24 13:01:26.502808
SBN_to_AWS mpc_orbits 1518954 2026-03-24 12:39:24.913446 2026-03-24 13:01:26.698369
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-24 13:01:26.863724
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-24 13:01:27.235302
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-24 13:01:27.37237
MPC_primarydb neocp_els 106 2026-03-24 12:40:32.546688 2026-03-24 13:01:27.518356
MPC_mpcsbndb neocp_els 106 2026-03-24 12:40:32.546688 2026-03-24 13:01:27.62782
SBN_to_AWS neocp_els 106 2026-03-24 12:40:32.546688 2026-03-24 13:01:27.715763
MPC_primarydb neocp_events 318047 2026-03-24 12:40:32.658966 2026-03-24 13:01:27.80642
MPC_mpcsbndb neocp_events 318047 2026-03-24 12:40:32.658966 2026-03-24 13:01:28.015564
SBN_to_AWS neocp_events 318047 2026-03-24 12:40:32.658966 2026-03-24 13:01:28.131845
MPC_primarydb neocp_obs 1614 2026-03-24 12:40:32.412797 2026-03-24 13:01:28.24426
MPC_mpcsbndb neocp_obs 1614 2026-03-24 12:40:32.412797 2026-03-24 13:01:28.355369
SBN_to_AWS neocp_obs 1614 2026-03-24 12:40:32.412797 2026-03-24 13:01:28.443481
MPC_primarydb neocp_obs_archive 796651 2026-03-24 12:40:32.453327 2026-03-24 13:01:28.534395
MPC_mpcsbndb neocp_obs_archive 796651 2026-03-24 12:40:32.453327 2026-03-24 13:01:28.818152
SBN_to_AWS neocp_obs_archive 796651 2026-03-24 12:40:32.453327 2026-03-24 13:01:28.954927
MPC_primarydb neocp_prev_des 71683 2026-03-24 10:06:44.020929 2026-03-24 13:01:29.094034
MPC_mpcsbndb neocp_prev_des 71683 2026-03-24 10:06:44.020929 2026-03-24 13:01:29.246192
SBN_to_AWS neocp_prev_des 71683 2026-03-24 10:06:44.020929 2026-03-24 13:01:29.348909
MPC_primarydb neocp_var 217823 2026-03-24 12:40:32.499867 2026-03-24 13:01:29.447623
MPC_mpcsbndb neocp_var 217823 2026-03-24 12:40:32.499867 2026-03-24 13:01:29.637414
SBN_to_AWS neocp_var 217823 2026-03-24 12:40:32.499867 2026-03-24 13:01:29.766526
MPC_primarydb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-24 13:01:29.874122
MPC_mpcsbndb obscodes 2687 2026-03-18 19:10:45.593554 2026-03-24 13:01:30.007134
SBN_to_AWS obscodes 2687 2026-03-18 19:10:45.593554 2026-03-24 13:01:30.095414
MPC_primarydb primary_objects 1560562 2026-03-24 11:08:25.229494 2026-03-24 13:01:30.18623
MPC_mpcsbndb primary_objects 1560562 2026-03-24 11:08:25.229494 2026-03-24 13:01:30.660464
SBN_to_AWS primary_objects 1560562 2026-03-24 11:08:25.229494 2026-03-24 13:01:30.829123
MPC_primarydb obs_alterations_corrections 0 2026-03-24 13:01:31.01426
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-24 13:01:31.122936
SBN_to_AWS obs_alterations_corrections 0 2026-03-24 13:01:31.209824
MPC_primarydb obs_alterations_deletions 1495538 2026-03-24 10:11:08.9577 2026-03-24 13:01:31.300579
MPC_mpcsbndb obs_alterations_deletions 1495538 2026-03-24 10:11:08.9577 2026-03-24 13:01:31.874366
SBN_to_AWS obs_alterations_deletions 1495538 2026-03-24 10:11:08.9577 2026-03-24 13:01:32.008835
MPC_primarydb obs_alterations_redesignations 5010 2026-03-23 20:57:57.48142 2026-03-24 13:01:32.159893
MPC_mpcsbndb obs_alterations_redesignations 5010 2026-03-23 20:57:57.48142 2026-03-24 13:01:32.276211
SBN_to_AWS obs_alterations_redesignations 5010 2026-03-23 20:57:57.48142 2026-03-24 13:01:32.364777
MPC_primarydb obs_alterations_unassociations 565161 2026-03-23 21:24:22.067004 2026-03-24 13:01:32.455775
MPC_mpcsbndb obs_alterations_unassociations 565161 2026-03-23 21:24:22.067004 2026-03-24 13:01:32.773612
SBN_to_AWS obs_alterations_unassociations 565161 2026-03-23 21:24:22.067004 2026-03-24 13:01:32.904108