Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

23 Jan 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-02-24 14:30:02 (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 11220 2026-02-19 16:33:17 2026-02-19 17:01:02
identifications 211641 2026-01-14 12:15:20 2026-01-14 12:15:20
isolated_tracklets 49794816 2026-02-24 14:08:19 2026-02-24 14:08:19
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 2011-10-28 09:36:11 2026-01-12 14:34: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 502507015 2026-02-24 13:51:49 2026-02-24 13:51:49
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1535421 2026-02-24 13:51:53 2026-02-24 14: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 92 2026-02-24 14:29:11.966213 2026-02-24 14:29:11.966213
neocp_events 312450 2026-02-24 14:29:12.054591 2026-02-24 14:29:12.054591
neocp_obs_archive 782280 2026-02-24 14:29:11.896835 2026-02-24 14:29:11.896835
neocp_obs 1367 2026-02-24 14:29:11.883788 2026-02-24 14:29:11.883788
neocp_prev_des 71136 2026-02-24 13:56:49.480672 2026-02-24 13:56:49.480672
neocp_var 175151 2026-02-24 14:29:11.910362 2026-02-24 14:29:11.910362
current_identifications 2045601 2026-02-24 14:04:34.030375 2026-02-24 14:04:34.030375
numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-11 03:01:35.42883
primary_objects 1561319 2026-02-24 14:04:33.990149 2026-02-24 14:04:33.990149
obs_sbn 530023400 2026-02-24 08:21:11.560597-05 2026-02-24 09:33:38.752225-05
obs_alterations_deletions 1492355 2026-02-24 10:21:44.453736 2026-02-24 10:21:44.453736
obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-03 19:19:15.911342
obs_alterations_unassociations 559462 2026-02-24 14:10:11.333353 2026-02-24 14:10:11.333353
mpc_orbits 1517698 2021-02-04 00:58:56.07807 2026-02-24 14:33:44.540711
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
obscodes 2679 2026-02-17 16:33:00.104295 2026-02-17 16:33:00.104295
comet_names 4282 2025-12-11 19:53:04.596625 2026-02-18 17:43:57.991089
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 529979942 2026-02-24 14:00:01.331069 2026-02-24 14:00:02.155383
MPC_mpcsbndb obs_sbn 529980299 2026-02-24 14:00:18.990635 2026-02-24 14:00:19.728455
SBN_to_AWS obs_sbn 529980780 2026-02-24 14:00:41.864883 2026-02-24 14:00:43.500728
MPC_primarydb current_identifications 2045601 2026-02-24 14:04:34.030375 2026-02-24 14:05:35.562821
MPC_mpcsbndb current_identifications 2045601 2026-02-24 14:04:34.030375 2026-02-24 14:05:36.189799
SBN_to_AWS current_identifications 2045601 2026-02-24 14:04:34.030375 2026-02-24 14:05:36.42599
MPC_primarydb comet_names 4282 2026-02-18 17:43:57.991089 2026-02-24 14:05:36.695551
MPC_mpcsbndb comet_names 4282 2026-02-18 17:43:57.991089 2026-02-24 14:05:36.796577
SBN_to_AWS comet_names 4282 2026-02-18 17:43:57.991089 2026-02-24 14:05:36.882875
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-24 14:05:36.97389
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-24 14:05:37.131038
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-24 14:05:37.232161
MPC_primarydb mpc_orbits 1517698 2026-02-24 14:05:36.256419 2026-02-24 14:05:37.327203
MPC_mpcsbndb mpc_orbits 1517698 2026-02-24 14:05:38.289241 2026-02-24 14:05:38.959469
SBN_to_AWS mpc_orbits 1517698 2026-02-24 14:05:37.530813 2026-02-24 14:05:39.479971
MPC_primarydb numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-24 14:05:41.235795
MPC_mpcsbndb numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-24 14:05:41.618801
SBN_to_AWS numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-24 14:05:41.778955
MPC_primarydb neocp_els 91 2026-02-24 13:32:44.504603 2026-02-24 14:05:41.928416
MPC_mpcsbndb neocp_els 91 2026-02-24 13:32:44.504603 2026-02-24 14:05:42.027585
SBN_to_AWS neocp_els 91 2026-02-24 13:32:44.504603 2026-02-24 14:05:42.113394
MPC_primarydb neocp_events 312448 2026-02-24 13:56:49.513847 2026-02-24 14:05:42.215321
MPC_mpcsbndb neocp_events 312448 2026-02-24 13:56:49.513847 2026-02-24 14:05:42.403156
SBN_to_AWS neocp_events 312448 2026-02-24 13:56:49.513847 2026-02-24 14:05:42.524961
MPC_primarydb neocp_obs 1359 2026-02-24 13:30:52.116111 2026-02-24 14:05:42.64635
MPC_mpcsbndb neocp_obs 1359 2026-02-24 13:30:52.116111 2026-02-24 14:05:42.755604
SBN_to_AWS neocp_obs 1359 2026-02-24 13:30:52.116111 2026-02-24 14:05:42.84318
MPC_primarydb neocp_obs_archive 782272 2026-02-24 13:30:52.129031 2026-02-24 14:05:42.937022
MPC_mpcsbndb neocp_obs_archive 782272 2026-02-24 13:30:52.129031 2026-02-24 14:05:43.181771
SBN_to_AWS neocp_obs_archive 782272 2026-02-24 13:30:52.129031 2026-02-24 14:05:43.325796
MPC_primarydb neocp_prev_des 71136 2026-02-24 13:56:49.480672 2026-02-24 14:05:43.464626
MPC_mpcsbndb neocp_prev_des 71136 2026-02-24 13:56:49.480672 2026-02-24 14:05:43.597806
SBN_to_AWS neocp_prev_des 71136 2026-02-24 13:56:49.480672 2026-02-24 14:05:43.701038
MPC_primarydb neocp_var 173151 2026-02-24 13:32:44.658644 2026-02-24 14:05:43.798251
MPC_mpcsbndb neocp_var 173151 2026-02-24 13:32:44.658644 2026-02-24 14:05:43.971227
SBN_to_AWS neocp_var 173151 2026-02-24 13:32:44.658644 2026-02-24 14:05:44.105111
MPC_primarydb obscodes 2679 2026-02-17 16:33:00.104295 2026-02-24 14:05:44.232326
MPC_mpcsbndb obscodes 2679 2026-02-17 16:33:00.104295 2026-02-24 14:05:44.348809
SBN_to_AWS obscodes 2679 2026-02-17 16:33:00.104295 2026-02-24 14:05:44.436065
MPC_primarydb primary_objects 1561319 2026-02-24 14:04:33.990149 2026-02-24 14:05:44.52682
MPC_mpcsbndb primary_objects 1561319 2026-02-24 14:04:33.990149 2026-02-24 14:05:45.08135
SBN_to_AWS primary_objects 1561319 2026-02-24 14:04:33.990149 2026-02-24 14:05:45.252367
MPC_primarydb obs_alterations_corrections 0 2026-02-24 14:05:45.440315
MPC_mpcsbndb obs_alterations_corrections 0 2026-02-24 14:05:45.536964
SBN_to_AWS obs_alterations_corrections 0 2026-02-24 14:05:45.622929
MPC_primarydb obs_alterations_deletions 1492355 2026-02-24 10:21:44.453736 2026-02-24 14:05:45.71551
MPC_mpcsbndb obs_alterations_deletions 1492355 2026-02-24 10:21:44.453736 2026-02-24 14:05:46.206821
SBN_to_AWS obs_alterations_deletions 1492355 2026-02-24 10:21:44.453736 2026-02-24 14:05:46.348357
MPC_primarydb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-24 14:05:46.501589
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-24 14:05:46.600272
SBN_to_AWS obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-24 14:05:46.687141
MPC_primarydb obs_alterations_unassociations 559339 2026-02-24 10:16:31.109894 2026-02-24 14:05:46.776359
MPC_mpcsbndb obs_alterations_unassociations 559339 2026-02-24 10:16:31.109894 2026-02-24 14:05:47.052114
SBN_to_AWS obs_alterations_unassociations 559339 2026-02-24 10:16:31.109894 2026-02-24 14:05:47.181781