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-17 03:50: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 11219 2026-02-13 22:16:37 2026-02-13 23:01:04
identifications 211641 2026-01-14 12:15:20 2026-01-14 12:15:20
isolated_tracklets 49770557 2026-02-17 03:48:21 2026-02-17 03:48:21
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 502498467 2026-02-17 03:47:59 2026-02-17 03:47:59
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534270 2026-02-17 03:48:16 2026-02-17 03:48:16
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 64 2026-02-16 08:15:36.590038 2026-02-17 03:55:31.616558
neocp_events 311371 2026-02-17 03:55:31.825331 2026-02-17 03:55:31.825331
neocp_obs_archive 779655 2026-02-17 03:55:31.61335 2026-02-17 03:55:31.61335
neocp_obs 1125 2026-02-17 03:55:31.604008 2026-02-17 03:55:31.604008
neocp_prev_des 71026 2026-02-17 03:46:57.162619 2026-02-17 03:46:57.162619
neocp_var 113411 2026-02-17 03:55:31.683116 2026-02-17 03:55:31.683116
current_identifications 2044467 2026-02-17 03:46:13.816255 2026-02-17 03:47:16.164897
numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-11 03:01:35.42883
primary_objects 1560197 2026-02-17 03:46:13.774046 2026-02-17 03:46:13.774046
obs_sbn 528519883 2026-02-16 22:40:09.037137-05 2026-02-16 22:48:17.714914-05
obs_alterations_deletions 1473695 2026-02-17 02:31:29.829006 2026-02-17 02:31:29.829006
obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-03 19:19:15.911342
obs_alterations_unassociations 554166 2026-02-17 03:28:30.120916 2026-02-17 03:28:30.120916
mpc_orbits 1516542 2026-02-17 03:46:36.746306 2026-02-17 03:46:36.746306
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
obscodes 2678 2026-02-10 17:33:01.155941 2026-02-10 17:33:01.155941
comet_names 4295 2023-08-15 14:55:17.305679 2026-02-05 00:12:51.9462
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 528519844 2026-02-17 02:58:13.497063 2026-02-17 03:00:02.047716
MPC_mpcsbndb obs_sbn 528519844 2026-02-17 02:58:13.497063 2026-02-17 03:00:14.688716
SBN_to_AWS obs_sbn 528519844 2026-02-17 02:58:13.497063 2026-02-17 03:00:40.11487
MPC_primarydb current_identifications 2044466 2026-02-17 00:47:57.953698 2026-02-17 03:08:40.372459
MPC_mpcsbndb current_identifications 2044466 2026-02-17 00:47:57.953698 2026-02-17 03:08:41.006885
SBN_to_AWS current_identifications 2044466 2026-02-17 00:47:57.953698 2026-02-17 03:08:41.240296
MPC_primarydb comet_names 4280 2026-02-05 00:12:51.9462 2026-02-17 03:08:42.150548
MPC_mpcsbndb comet_names 4280 2026-02-05 00:12:51.9462 2026-02-17 03:08:42.259953
SBN_to_AWS comet_names 4280 2026-02-05 00:12:51.9462 2026-02-17 03:08:42.347497
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-17 03:08:42.444766
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-17 03:08:42.594076
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-02-17 03:08:42.694785
MPC_primarydb mpc_orbits 1516541 2026-02-17 03:06:51.78938 2026-02-17 03:08:42.794516
MPC_mpcsbndb mpc_orbits 1516541 2026-02-17 03:06:51.78938 2026-02-17 03:08:44.316137
SBN_to_AWS mpc_orbits 1516541 2026-02-17 03:06:51.78938 2026-02-17 03:08:44.666975
MPC_primarydb numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-17 03:08:49.657983
MPC_mpcsbndb numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-17 03:08:49.945967
SBN_to_AWS numbered_identifications 875981 2026-02-11 03:01:35.42883 2026-02-17 03:08:50.08126
MPC_primarydb neocp_els 65 2026-02-17 03:01:59.049238 2026-02-17 03:08:50.310876
MPC_mpcsbndb neocp_els 65 2026-02-17 03:01:59.049238 2026-02-17 03:08:50.419771
SBN_to_AWS neocp_els 65 2026-02-17 03:01:59.049238 2026-02-17 03:08:50.507476
MPC_primarydb neocp_events 311364 2026-02-17 03:01:59.358274 2026-02-17 03:08:50.601394
MPC_mpcsbndb neocp_events 311364 2026-02-17 03:01:59.358274 2026-02-17 03:08:50.780535
SBN_to_AWS neocp_events 311364 2026-02-17 03:01:59.358274 2026-02-17 03:08:50.90418
MPC_primarydb neocp_obs 1118 2026-02-17 03:01:58.925995 2026-02-17 03:08:51.052004
MPC_mpcsbndb neocp_obs 1118 2026-02-17 03:01:58.925995 2026-02-17 03:08:51.158091
SBN_to_AWS neocp_obs 1118 2026-02-17 03:01:58.925995 2026-02-17 03:08:51.244793
MPC_primarydb neocp_obs_archive 779638 2026-02-17 03:01:59.00824 2026-02-17 03:08:51.341596
MPC_mpcsbndb neocp_obs_archive 779638 2026-02-17 03:01:59.00824 2026-02-17 03:08:51.504908
SBN_to_AWS neocp_obs_archive 779638 2026-02-17 03:01:59.00824 2026-02-17 03:08:51.637045
MPC_primarydb neocp_prev_des 71025 2026-02-17 00:47:32.457241 2026-02-17 03:08:51.863378
MPC_mpcsbndb neocp_prev_des 71025 2026-02-17 00:47:32.457241 2026-02-17 03:08:51.999837
SBN_to_AWS neocp_prev_des 71025 2026-02-17 00:47:32.457241 2026-02-17 03:08:52.099936
MPC_primarydb neocp_var 115411 2026-02-17 03:01:59.180157 2026-02-17 03:08:52.21904
MPC_mpcsbndb neocp_var 115411 2026-02-17 03:01:59.180157 2026-02-17 03:08:52.383917
SBN_to_AWS neocp_var 115411 2026-02-17 03:01:59.180157 2026-02-17 03:08:52.503942
MPC_primarydb obscodes 2678 2026-02-10 17:33:01.155941 2026-02-17 03:08:52.763339
MPC_mpcsbndb obscodes 2678 2026-02-10 17:33:01.155941 2026-02-17 03:08:52.882718
SBN_to_AWS obscodes 2678 2026-02-10 17:33:01.155941 2026-02-17 03:08:52.970482
MPC_primarydb primary_objects 1560196 2026-02-17 00:46:36.182904 2026-02-17 03:08:53.066961
MPC_mpcsbndb primary_objects 1560196 2026-02-17 00:46:36.182904 2026-02-17 03:08:53.483868
SBN_to_AWS primary_objects 1560196 2026-02-17 00:46:36.182904 2026-02-17 03:08:53.641381
MPC_primarydb obs_alterations_corrections 0 2026-02-17 03:08:55.215118
MPC_mpcsbndb obs_alterations_corrections 0 2026-02-17 03:08:55.321408
SBN_to_AWS obs_alterations_corrections 0 2026-02-17 03:08:55.40764
MPC_primarydb obs_alterations_deletions 1473695 2026-02-17 02:31:29.829006 2026-02-17 03:08:55.497827
MPC_mpcsbndb obs_alterations_deletions 1473695 2026-02-17 02:31:29.829006 2026-02-17 03:08:55.871852
SBN_to_AWS obs_alterations_deletions 1473695 2026-02-17 02:31:29.829006 2026-02-17 03:08:56.009574
MPC_primarydb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-17 03:08:56.195905
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-17 03:08:56.304966
SBN_to_AWS obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-02-17 03:08:56.392835
MPC_primarydb obs_alterations_unassociations 554160 2026-02-17 02:10:06.045098 2026-02-17 03:08:56.487258
MPC_mpcsbndb obs_alterations_unassociations 554160 2026-02-17 02:10:06.045098 2026-02-17 03:08:56.724511
SBN_to_AWS obs_alterations_unassociations 554160 2026-02-17 02:10:06.045098 2026-02-17 03:08:56.854035