Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

21 May 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-06-02 23:20: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 12628 2023-09-20 23:40:02 2026-05-28 20:01:03
identifications 218331 2026-04-14 12:33:30 2026-04-14 12:33:30
isolated_tracklets 49973720 2026-06-02 23:08:24 2026-06-02 23:08:24
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 2024-02-21 19:12:24 2026-05-07 10:18:37
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 512096102 2026-06-02 12:20:32 2026-06-02 12:20:32
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1559148 2015-01-08 22:53:07 2026-06-02 13:01:06
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 11 2026-05-25 11:24:13.150564 2026-06-02 10:03:30.802858
neocp_events 325283 2026-06-02 15:47:43.025109 2026-06-02 15:47:43.025109
neocp_obs_archive 813724 2026-06-02 10:03:30.7199 2026-06-02 10:03:30.7199
neocp_obs 71 2026-06-02 10:03:30.679069 2026-06-02 10:03:30.679069
neocp_prev_des 72608 2026-06-02 11:00:33.132693 2026-06-02 11:00:33.132693
neocp_var 34829 2026-06-02 10:03:30.897523 2026-06-02 10:03:30.897523
current_identifications 2071748 2020-07-30 16:17:28.931001 2026-06-02 22:27:20.427364
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-02 22:27:20.380719
primary_objects 1584205 2021-02-26 14:01:08.364174 2026-06-02 18:32:11.181459
obs_sbn 539978134 2026-06-02 19:05:09.298599-04 2026-06-02 19:08:22.540969-04
obs_alterations_deletions 1694485 2026-06-02 04:20:02.215184 2026-06-02 04:20:02.215184
obs_alterations_redesignations 5083 2026-03-18 20:47:44.531467 2026-05-31 19:35:10.075266
obs_alterations_unassociations 581115 2026-06-02 18:59:47.150189 2026-06-02 18:59:47.150189
mpc_orbits 1549112 2026-06-01 17:34:33.992285 2026-06-02 22:51:28.188347
minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-07 14:26:32.139498
obscodes 2703 2019-05-25 00:11:22.017419 2026-06-01 18:22:48.009037
comet_names 4376 2026-05-26 21:03:40.256139 2026-05-26 21:03:40.256139
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 539978102 2026-06-02 21:47:29.219318 2026-06-02 22:00:02.073465
MPC_mpcsbndb obs_sbn 539978102 2026-06-02 21:47:29.219318 2026-06-02 22:00:15.015876
SBN_to_AWS obs_sbn 539978102 2026-06-02 21:47:29.219318 2026-06-02 22:00:58.690729
MPC_primarydb current_identifications 2071748 2026-06-02 22:27:20.427364 2026-06-02 22:28:57.969732
MPC_mpcsbndb current_identifications 2071748 2026-06-02 22:27:20.427364 2026-06-02 22:28:58.772455
SBN_to_AWS current_identifications 2071748 2026-06-02 22:27:20.427364 2026-06-02 22:28:58.951777
MPC_primarydb comet_names 4376 2026-05-26 21:03:40.256139 2026-06-02 22:28:59.631183
MPC_mpcsbndb comet_names 4376 2026-05-26 21:03:40.256139 2026-06-02 22:28:59.736646
SBN_to_AWS comet_names 4376 2026-05-26 21:03:40.256139 2026-06-02 22:28:59.826375
MPC_primarydb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-06-02 22:28:59.925605
MPC_mpcsbndb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-06-02 22:29:00.069027
SBN_to_AWS minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-06-02 22:29:00.17429
MPC_primarydb mpc_orbits 1549112 2026-06-02 22:27:20.380719 2026-06-02 22:29:00.321175
MPC_mpcsbndb mpc_orbits 1549112 2026-06-02 22:27:20.380719 2026-06-02 22:29:01.952767
SBN_to_AWS mpc_orbits 1549112 2026-06-02 22:27:20.380719 2026-06-02 22:29:02.277011
MPC_primarydb numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-02 22:29:03.507313
MPC_mpcsbndb numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-02 22:29:03.782933
SBN_to_AWS numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-02 22:29:03.919793
MPC_primarydb neocp_els 8 2026-06-01 23:34:59.927373 2026-06-02 22:29:04.214465
MPC_mpcsbndb neocp_els 8 2026-06-01 23:34:59.927373 2026-06-02 22:29:04.316587
SBN_to_AWS neocp_els 8 2026-06-01 23:34:59.927373 2026-06-02 22:29:04.404089
MPC_primarydb neocp_events 325283 2026-06-02 15:47:43.025109 2026-06-02 22:29:04.498201
MPC_mpcsbndb neocp_events 325283 2026-06-02 15:47:43.025109 2026-06-02 22:29:04.679482
SBN_to_AWS neocp_events 325283 2026-06-02 15:47:43.025109 2026-06-02 22:29:04.797834
MPC_primarydb neocp_obs 37 2026-06-01 23:34:59.816313 2026-06-02 22:29:04.952545
MPC_mpcsbndb neocp_obs 37 2026-06-01 23:34:59.816313 2026-06-02 22:29:05.053846
SBN_to_AWS neocp_obs 37 2026-06-01 23:34:59.816313 2026-06-02 22:29:05.141948
MPC_primarydb neocp_obs_archive 813724 2026-06-02 10:03:30.7199 2026-06-02 22:29:05.239858
MPC_mpcsbndb neocp_obs_archive 813724 2026-06-02 10:03:30.7199 2026-06-02 22:29:05.429556
SBN_to_AWS neocp_obs_archive 813724 2026-06-02 10:03:30.7199 2026-06-02 22:29:05.57383
MPC_primarydb neocp_prev_des 72608 2026-06-02 11:00:33.132693 2026-06-02 22:29:05.809547
MPC_mpcsbndb neocp_prev_des 72608 2026-06-02 11:00:33.132693 2026-06-02 22:29:05.941571
SBN_to_AWS neocp_prev_des 72608 2026-06-02 11:00:33.132693 2026-06-02 22:29:06.04423
MPC_primarydb neocp_var 28852 2026-06-01 23:34:59.855762 2026-06-02 22:29:06.164196
MPC_mpcsbndb neocp_var 28852 2026-06-01 23:34:59.855762 2026-06-02 22:29:06.307744
SBN_to_AWS neocp_var 28852 2026-06-01 23:34:59.855762 2026-06-02 22:29:06.415037
MPC_primarydb obscodes 2703 2026-06-01 18:22:48.009037 2026-06-02 22:29:06.522589
MPC_mpcsbndb obscodes 2703 2026-06-01 18:22:48.009037 2026-06-02 22:29:06.63583
SBN_to_AWS obscodes 2703 2026-06-01 18:22:48.009037 2026-06-02 22:29:06.72539
MPC_primarydb primary_objects 1584205 2026-06-02 18:32:11.181459 2026-06-02 22:29:06.821466
MPC_mpcsbndb primary_objects 1584205 2026-06-02 18:32:11.181459 2026-06-02 22:29:07.261807
SBN_to_AWS primary_objects 1584205 2026-06-02 18:32:11.181459 2026-06-02 22:29:07.47983
MPC_primarydb obs_alterations_corrections 0 2026-06-02 22:29:09.080146
MPC_mpcsbndb obs_alterations_corrections 0 2026-06-02 22:29:09.182815
SBN_to_AWS obs_alterations_corrections 0 2026-06-02 22:29:09.269373
MPC_primarydb obs_alterations_deletions 1694485 2026-06-02 04:20:02.215184 2026-06-02 22:29:09.359799
MPC_mpcsbndb obs_alterations_deletions 1694485 2026-06-02 04:20:02.215184 2026-06-02 22:29:09.786447
SBN_to_AWS obs_alterations_deletions 1694485 2026-06-02 04:20:02.215184 2026-06-02 22:29:09.942361
MPC_primarydb obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-02 22:29:10.285023
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-02 22:29:10.390652
SBN_to_AWS obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-02 22:29:10.479884
MPC_primarydb obs_alterations_unassociations 581115 2026-06-02 18:59:47.150189 2026-06-02 22:29:10.5762
MPC_mpcsbndb obs_alterations_unassociations 581115 2026-06-02 18:59:47.150189 2026-06-02 22:29:10.818582
SBN_to_AWS obs_alterations_unassociations 581115 2026-06-02 18:59:47.150189 2026-06-02 22:29:10.951831