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-07 12:10: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 5227 2026-06-03 09:27:00 2026-06-03 09:27:00
comet_orbits 12634 2026-06-03 02:55:48 2026-06-03 02:55:48
identifications 221431 2026-06-06 12:58:56 2026-06-06 12:58:56
isolated_tracklets 49982588 2026-06-07 11:58:47 2026-06-07 11:58:47
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1295 2026-06-03 09:12:00 2026-06-03 09:12:00
numbered_identifications 1342746 2026-06-03 02:55:41 2026-06-03 02:55:41
numbered_mps 895910 2011-10-28 17:37:34 2026-06-05 18:04: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 524356379 2026-06-07 11:04:43 2026-06-07 11:04:43
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1563222 2026-06-07 11:04:47 2026-06-07 12:01:02
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 17 2026-06-07 11:27:47.961837 2026-06-07 11:27:47.961837
neocp_events 325492 2026-06-07 11:27:48.158523 2026-06-07 11:27:48.158523
neocp_obs_archive 814151 2026-06-07 11:27:47.363445 2026-06-07 11:27:47.363445
neocp_obs 121 2026-06-07 11:27:47.088136 2026-06-07 11:27:47.088136
neocp_prev_des 72632 2026-06-07 11:04:06.346744 2026-06-07 11:04:06.346744
neocp_var 46931 2026-06-07 11:27:47.542588 2026-06-07 11:27:47.542588
current_identifications 2078907 2026-06-04 02:41:48.073085 2026-06-07 11:59:35.937314
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1589528 2026-06-07 11:58:33.434961 2026-06-07 11:58:33.434961
obs_sbn 540290823 2021-03-31 18:48:30.025757-04 2026-06-07 08:13:18.760573-04
obs_alterations_deletions 1694552 2026-06-07 06:32:06.269429 2026-06-07 06:32:06.269429
obs_alterations_redesignations 5090 2026-06-07 11:57:46.499225 2026-06-07 11:57:46.499225
obs_alterations_unassociations 588362 2026-06-07 10:10:07.613125 2026-06-07 10:10:07.613125
mpc_orbits 1554776 2026-06-04 04:07:05.20108 2026-06-07 11:59:26.48863
minor_planet_names 26233 2015-03-09 02:37:18 2026-06-05 22:04:35.704855
obscodes 2704 2026-06-05 19:58:18.609462 2026-06-05 19:58:18.609462
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 540290521 2026-06-07 10:59:57.475843 2026-06-07 11:00:02.754407
MPC_mpcsbndb obs_sbn 540290521 2026-06-07 10:59:57.475843 2026-06-07 11:00:21.461609
SBN_to_AWS obs_sbn 540290521 2026-06-07 10:59:57.475843 2026-06-07 11:01:04.759121
MPC_primarydb current_identifications 2078907 2026-06-07 11:28:51.01642 2026-06-07 11:29:22.431752
MPC_mpcsbndb current_identifications 2078907 2026-06-07 11:28:51.01642 2026-06-07 11:29:23.62603
SBN_to_AWS current_identifications 2078907 2026-06-07 11:28:51.01642 2026-06-07 11:29:23.806594
MPC_primarydb comet_names 4376 2026-05-26 21:03:40.256139 2026-06-07 11:29:24.554762
MPC_mpcsbndb comet_names 4376 2026-05-26 21:03:40.256139 2026-06-07 11:29:24.666155
SBN_to_AWS comet_names 4376 2026-05-26 21:03:40.256139 2026-06-07 11:29:24.755757
MPC_primarydb minor_planet_names 26233 2026-06-05 22:04:35.704855 2026-06-07 11:29:24.855437
MPC_mpcsbndb minor_planet_names 26233 2026-06-05 22:04:35.704855 2026-06-07 11:29:25.015646
SBN_to_AWS minor_planet_names 26233 2026-06-05 22:04:35.704855 2026-06-07 11:29:25.119061
MPC_primarydb mpc_orbits 1554799 2026-06-07 11:29:18.76183 2026-06-07 11:29:25.265755
MPC_mpcsbndb mpc_orbits 1554799 2026-06-07 11:29:18.76183 2026-06-07 11:29:27.184146
SBN_to_AWS mpc_orbits 1554799 2026-06-07 11:29:18.76183 2026-06-07 11:29:27.548856
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-06-07 11:29:30.419326
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-06-07 11:29:30.777952
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-06-07 11:29:30.934943
MPC_primarydb neocp_els 17 2026-06-07 11:27:47.961837 2026-06-07 11:29:31.229788
MPC_mpcsbndb neocp_els 17 2026-06-07 11:27:47.961837 2026-06-07 11:29:31.338249
SBN_to_AWS neocp_els 17 2026-06-07 11:27:47.961837 2026-06-07 11:29:31.425942
MPC_primarydb neocp_events 325492 2026-06-07 11:27:48.158523 2026-06-07 11:29:31.519248
MPC_mpcsbndb neocp_events 325492 2026-06-07 11:27:48.158523 2026-06-07 11:29:31.717305
SBN_to_AWS neocp_events 325492 2026-06-07 11:27:48.158523 2026-06-07 11:29:31.842298
MPC_primarydb neocp_obs 121 2026-06-07 11:27:47.088136 2026-06-07 11:29:31.998894
MPC_mpcsbndb neocp_obs 121 2026-06-07 11:27:47.088136 2026-06-07 11:29:32.107137
SBN_to_AWS neocp_obs 121 2026-06-07 11:27:47.088136 2026-06-07 11:29:32.1942
MPC_primarydb neocp_obs_archive 814151 2026-06-07 11:27:47.363445 2026-06-07 11:29:32.290854
MPC_mpcsbndb neocp_obs_archive 814151 2026-06-07 11:27:47.363445 2026-06-07 11:29:32.570202
SBN_to_AWS neocp_obs_archive 814151 2026-06-07 11:27:47.363445 2026-06-07 11:29:32.737064
MPC_primarydb neocp_prev_des 72632 2026-06-07 11:04:06.346744 2026-06-07 11:29:32.971997
MPC_mpcsbndb neocp_prev_des 72632 2026-06-07 11:04:06.346744 2026-06-07 11:29:33.114452
SBN_to_AWS neocp_prev_des 72632 2026-06-07 11:04:06.346744 2026-06-07 11:29:33.218222
MPC_primarydb neocp_var 46931 2026-06-07 11:27:47.542588 2026-06-07 11:29:33.339802
MPC_mpcsbndb neocp_var 46931 2026-06-07 11:27:47.542588 2026-06-07 11:29:33.49047
SBN_to_AWS neocp_var 46931 2026-06-07 11:27:47.542588 2026-06-07 11:29:33.607919
MPC_primarydb obscodes 2704 2026-06-05 19:58:18.609462 2026-06-07 11:29:33.752192
MPC_mpcsbndb obscodes 2704 2026-06-05 19:58:18.609462 2026-06-07 11:29:33.876897
SBN_to_AWS obscodes 2704 2026-06-05 19:58:18.609462 2026-06-07 11:29:33.966993
MPC_primarydb primary_objects 1589549 2026-06-07 11:03:23.933868 2026-06-07 11:29:34.063714
MPC_mpcsbndb primary_objects 1589549 2026-06-07 11:03:23.933868 2026-06-07 11:29:34.597953
SBN_to_AWS primary_objects 1589549 2026-06-07 11:03:23.933868 2026-06-07 11:29:34.834731
MPC_primarydb obs_alterations_corrections 0 2026-06-07 11:29:36.456928
MPC_mpcsbndb obs_alterations_corrections 0 2026-06-07 11:29:36.566938
SBN_to_AWS obs_alterations_corrections 0 2026-06-07 11:29:36.653451
MPC_primarydb obs_alterations_deletions 1694552 2026-06-07 06:32:06.269429 2026-06-07 11:29:36.744241
MPC_mpcsbndb obs_alterations_deletions 1694552 2026-06-07 06:32:06.269429 2026-06-07 11:29:37.319845
SBN_to_AWS obs_alterations_deletions 1694552 2026-06-07 06:32:06.269429 2026-06-07 11:29:37.491764
MPC_primarydb obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-07 11:29:37.836252
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-07 11:29:37.950145
SBN_to_AWS obs_alterations_redesignations 5083 2026-05-31 19:35:10.075266 2026-06-07 11:29:38.041011
MPC_primarydb obs_alterations_unassociations 588362 2026-06-07 10:10:07.613125 2026-06-07 11:29:38.138226
MPC_mpcsbndb obs_alterations_unassociations 588362 2026-06-07 10:10:07.613125 2026-06-07 11:29:38.427166
SBN_to_AWS obs_alterations_unassociations 588362 2026-06-07 10:10:07.613125 2026-06-07 11:29:38.564895