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-05-31 06:40: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 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 49972393 2026-05-31 02:38:25 2026-05-31 02:38:25
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 512095456 2026-05-31 05:31:17 2026-05-31 05:31:17
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1559111 2026-05-31 05:30:02 2026-05-31 06: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 15 2026-05-31 05:57:07.350004 2026-05-31 05:57:07.350004
neocp_events 325241 2026-05-31 06:37:15.840573 2026-05-31 06:37:15.840573
neocp_obs_archive 813699 2026-05-31 05:57:07.02446 2026-05-31 05:57:07.02446
neocp_obs 93 2026-05-31 05:57:06.869819 2026-05-31 05:57:06.869819
neocp_prev_des 72600 2026-05-31 06:37:07.764798 2026-05-31 06:37:07.764798
neocp_var 42604 2026-05-31 05:57:07.153005 2026-05-31 05:57:07.153005
current_identifications 2071728 2026-05-31 05:30:04.415448 2026-05-31 05:30:54.701049
numbered_identifications 887936 2026-03-24 19:55:09.966554 2026-03-24 19:55:09.966554
primary_objects 1584185 2026-05-31 05:30:04.170451 2026-05-31 05:30:04.170451
obs_sbn 539950811 2026-05-31 02:36:48.207747-04 2026-05-31 02:37:11.382923-04
obs_alterations_deletions 1690907 2026-05-30 06:48:01.904967 2026-05-30 06:48:01.904967
obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-04-07 06:22:54.863572
obs_alterations_unassociations 581094 2026-05-31 04:09:38.13779 2026-05-31 04:09:38.13779
mpc_orbits 1549091 2026-02-24 11:07:08.499006 2026-05-31 06:37:11.382923
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:26.475272 2026-05-27 23:09:26.958103
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 539950805 2026-05-31 05:48:21.306883 2026-05-31 06:00:02.952872
MPC_mpcsbndb obs_sbn 539950805 2026-05-31 05:48:21.306883 2026-05-31 06:00:24.194587
SBN_to_AWS obs_sbn 539950805 2026-05-31 05:48:21.306883 2026-05-31 06:00:48.361161
MPC_primarydb current_identifications 2071728 2026-05-31 05:30:54.701049 2026-05-31 06:23:10.493145
MPC_mpcsbndb current_identifications 2071728 2026-05-31 05:30:54.701049 2026-05-31 06:23:12.005944
SBN_to_AWS current_identifications 2071728 2026-05-31 05:30:54.701049 2026-05-31 06:23:12.150172
MPC_primarydb comet_names 4376 2026-05-26 21:03:40.256139 2026-05-31 06:23:12.558344
MPC_mpcsbndb comet_names 4376 2026-05-26 21:03:40.256139 2026-05-31 06:23:12.668497
SBN_to_AWS comet_names 4376 2026-05-26 21:03:40.256139 2026-05-31 06:23:12.752895
MPC_primarydb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-31 06:23:12.848819
MPC_mpcsbndb minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-31 06:23:12.995415
SBN_to_AWS minor_planet_names 26199 2026-05-07 14:26:32.139498 2026-05-31 06:23:13.094526
MPC_primarydb mpc_orbits 1549091 2026-05-31 06:22:15.579238 2026-05-31 06:23:13.238323
MPC_mpcsbndb mpc_orbits 1549091 2026-05-31 06:22:15.579238 2026-05-31 06:23:14.936763
SBN_to_AWS mpc_orbits 1549091 2026-05-31 06:22:15.579238 2026-05-31 06:23:15.286343
MPC_primarydb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-31 06:23:19.676353
MPC_mpcsbndb numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-31 06:23:20.050671
SBN_to_AWS numbered_identifications 887800 2026-03-24 19:55:09.966554 2026-05-31 06:23:20.181759
MPC_primarydb neocp_els 15 2026-05-31 05:57:07.350004 2026-05-31 06:23:20.464546
MPC_mpcsbndb neocp_els 15 2026-05-31 05:57:07.350004 2026-05-31 06:23:20.575537
SBN_to_AWS neocp_els 15 2026-05-31 05:57:07.350004 2026-05-31 06:23:20.660241
MPC_primarydb neocp_events 325239 2026-05-31 05:57:07.541373 2026-05-31 06:23:20.751186
MPC_mpcsbndb neocp_events 325239 2026-05-31 05:57:07.541373 2026-05-31 06:23:20.949599
SBN_to_AWS neocp_events 325239 2026-05-31 05:57:07.541373 2026-05-31 06:23:21.066604
MPC_primarydb neocp_obs 93 2026-05-31 05:57:06.869819 2026-05-31 06:23:21.219207
MPC_mpcsbndb neocp_obs 93 2026-05-31 05:57:06.869819 2026-05-31 06:23:21.329028
SBN_to_AWS neocp_obs 93 2026-05-31 05:57:06.869819 2026-05-31 06:23:21.412902
MPC_primarydb neocp_obs_archive 813699 2026-05-31 05:57:07.02446 2026-05-31 06:23:21.507005
MPC_mpcsbndb neocp_obs_archive 813699 2026-05-31 05:57:07.02446 2026-05-31 06:23:21.814711
SBN_to_AWS neocp_obs_archive 813699 2026-05-31 05:57:07.02446 2026-05-31 06:23:21.945074
MPC_primarydb neocp_prev_des 72599 2026-05-31 05:30:45.863951 2026-05-31 06:23:22.174958
MPC_mpcsbndb neocp_prev_des 72599 2026-05-31 05:30:45.863951 2026-05-31 06:23:22.328452
SBN_to_AWS neocp_prev_des 72599 2026-05-31 05:30:45.863951 2026-05-31 06:23:22.427148
MPC_primarydb neocp_var 42604 2026-05-31 05:57:07.153005 2026-05-31 06:23:22.544851
MPC_mpcsbndb neocp_var 42604 2026-05-31 05:57:07.153005 2026-05-31 06:23:22.701235
SBN_to_AWS neocp_var 42604 2026-05-31 05:57:07.153005 2026-05-31 06:23:22.800946
MPC_primarydb obscodes 2703 2026-05-27 23:09:26.958103 2026-05-31 06:23:22.930533
MPC_mpcsbndb obscodes 2703 2026-05-27 23:09:26.958103 2026-05-31 06:23:23.059844
SBN_to_AWS obscodes 2703 2026-05-27 23:09:26.958103 2026-05-31 06:23:23.145876
MPC_primarydb primary_objects 1584185 2026-05-31 05:30:04.170451 2026-05-31 06:23:23.237958
MPC_mpcsbndb primary_objects 1584185 2026-05-31 05:30:04.170451 2026-05-31 06:23:23.740915
SBN_to_AWS primary_objects 1584185 2026-05-31 05:30:04.170451 2026-05-31 06:23:23.914726
MPC_primarydb obs_alterations_corrections 0 2026-05-31 06:23:25.50346
MPC_mpcsbndb obs_alterations_corrections 0 2026-05-31 06:23:25.610444
SBN_to_AWS obs_alterations_corrections 0 2026-05-31 06:23:25.692928
MPC_primarydb obs_alterations_deletions 1690907 2026-05-30 06:48:01.904967 2026-05-31 06:23:25.779517
MPC_mpcsbndb obs_alterations_deletions 1690907 2026-05-30 06:48:01.904967 2026-05-31 06:23:26.336789
SBN_to_AWS obs_alterations_deletions 1690907 2026-05-30 06:48:01.904967 2026-05-31 06:23:26.468442
MPC_primarydb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-31 06:23:26.822222
MPC_mpcsbndb obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-31 06:23:26.939099
SBN_to_AWS obs_alterations_redesignations 5083 2026-04-07 06:22:54.863572 2026-05-31 06:23:27.023459
MPC_primarydb obs_alterations_unassociations 581094 2026-05-31 04:09:38.13779 2026-05-31 06:23:27.115853
MPC_mpcsbndb obs_alterations_unassociations 581094 2026-05-31 04:09:38.13779 2026-05-31 06:23:27.419591
SBN_to_AWS obs_alterations_unassociations 581094 2026-05-31 04:09:38.13779 2026-05-31 06:23:27.547666