Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

17 Dec 2025

  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-01-01 15: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 11206 2023-09-20 23:40:01 2025-12-23 21:01:03
identifications 211503 2026-01-01 12:28:40 2026-01-01 12:28:40
isolated_tracklets 49669414 2026-01-01 15:08:14 2026-01-01 15:08:14
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 2022-04-06 05:12:11 2025-12-16 17:23:23
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 502448412 2026-01-01 15:17:58 2026-01-01 15:17:58
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1502825 2026-01-01 15:18:01 2026-01-01 15:18:01
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 70 2025-12-15 14:05:48.422003 2026-01-01 15:21:24.180025
neocp_events 305045 2026-01-01 15:17:09.175335 2026-01-01 15:17:09.175335
neocp_obs_archive 765731 2026-01-01 15:11:38.631583 2026-01-01 15:11:38.631583
neocp_obs 707 2026-01-01 15:11:38.589983 2026-01-01 15:11:38.589983
neocp_prev_des 70249 2026-01-01 15:17:09.149017 2026-01-01 15:17:09.149017
neocp_var 133873 2026-01-01 15:11:38.765106 2026-01-01 15:11:38.765106
current_identifications 2013110 2026-01-01 15:16:26.386885 2026-01-01 15:17:26.290213
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1528901 2026-01-01 15:16:26.359159 2026-01-01 15:16:26.359159
obs_sbn 521700997 2026-01-01 10:36:39.00852-05 2026-01-01 10:37:46.749744-05
obs_alterations_deletions 1445633 2026-01-01 01:44:09.94128 2026-01-01 01:44:09.94128
obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2025-12-05 16:11:33.171335
obs_alterations_unassociations 530675 2026-01-01 09:48:27.433297 2026-01-01 09:48:27.433297
mpc_orbits 1484899 2021-02-04 03:06:15.365918 2026-01-01 15:37:46.749744
minor_planet_names 25963 2018-05-31 01:04:42 2025-12-22 18:37:02.674927
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 521700747 2026-01-01 14:51:45.597492 2026-01-01 15:00:02.10725
MPC_mpcsbndb obs_sbn 521700747 2026-01-01 14:51:45.597492 2026-01-01 15:00:13.677235
SBN_to_AWS obs_sbn 521700747 2026-01-01 14:51:45.597492 2026-01-01 15:00:38.075502
MPC_primarydb current_identifications 2013109 2026-01-01 14:50:57.072151 2026-01-01 15:01:17.046444
MPC_mpcsbndb current_identifications 2013109 2026-01-01 14:50:57.072151 2026-01-01 15:01:17.552629
SBN_to_AWS current_identifications 2013109 2026-01-01 14:50:57.072151 2026-01-01 15:01:17.802701
MPC_primarydb minor_planet_names 25963 2025-12-22 18:37:02.674927 2026-01-01 15:01:18.047372
MPC_mpcsbndb minor_planet_names 25963 2025-12-22 18:37:02.674927 2026-01-01 15:01:18.201612
SBN_to_AWS minor_planet_names 25963 2025-12-22 18:37:02.674927 2026-01-01 15:01:18.295652
MPC_primarydb mpc_orbits 1484898 2026-01-01 14:52:05.018679 2026-01-01 15:01:18.386512
MPC_mpcsbndb mpc_orbits 1484898 2026-01-01 14:52:05.018679 2026-01-01 15:01:20.151753
SBN_to_AWS mpc_orbits 1484898 2026-01-01 14:52:05.018679 2026-01-01 15:01:20.434635
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-01 15:01:20.743138
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-01 15:01:21.025175
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-01 15:01:21.158342
MPC_primarydb neocp_els 71 2026-01-01 14:56:27.633438 2026-01-01 15:01:21.294289
MPC_mpcsbndb neocp_els 71 2026-01-01 14:56:27.633438 2026-01-01 15:01:21.403526
SBN_to_AWS neocp_els 71 2026-01-01 14:56:27.633438 2026-01-01 15:01:21.484703
MPC_primarydb neocp_events 305043 2026-01-01 14:56:27.825126 2026-01-01 15:01:21.56944
MPC_mpcsbndb neocp_events 305043 2026-01-01 14:56:27.825126 2026-01-01 15:01:21.748549
SBN_to_AWS neocp_events 305043 2026-01-01 14:56:27.825126 2026-01-01 15:01:21.864585
MPC_primarydb neocp_obs 705 2026-01-01 14:56:11.250086 2026-01-01 15:01:21.969459
MPC_mpcsbndb neocp_obs 705 2026-01-01 14:56:11.250086 2026-01-01 15:01:22.079336
SBN_to_AWS neocp_obs 705 2026-01-01 14:56:11.250086 2026-01-01 15:01:22.160298
MPC_primarydb neocp_obs_archive 765729 2026-01-01 14:56:11.291021 2026-01-01 15:01:22.244689
MPC_mpcsbndb neocp_obs_archive 765729 2026-01-01 14:56:11.291021 2026-01-01 15:01:22.460403
SBN_to_AWS neocp_obs_archive 765729 2026-01-01 14:56:11.291021 2026-01-01 15:01:22.589052
MPC_primarydb neocp_prev_des 70248 2025-12-31 21:05:44.384165 2026-01-01 15:01:22.720966
MPC_mpcsbndb neocp_prev_des 70248 2025-12-31 21:05:44.384165 2026-01-01 15:01:22.866713
SBN_to_AWS neocp_prev_des 70248 2025-12-31 21:05:44.384165 2026-01-01 15:01:22.9631
MPC_primarydb neocp_var 133873 2026-01-01 14:56:27.695956 2026-01-01 15:01:23.056119
MPC_mpcsbndb neocp_var 133873 2026-01-01 14:56:27.695956 2026-01-01 15:01:23.243763
SBN_to_AWS neocp_var 133873 2026-01-01 14:56:27.695956 2026-01-01 15:01:23.361075
MPC_primarydb obscodes 2667 2025-12-31 17:10:56.819632 2026-01-01 15:01:23.457658
MPC_mpcsbndb obscodes 2667 2025-12-31 17:10:56.819632 2026-01-01 15:01:23.58249
SBN_to_AWS obscodes 2667 2025-12-31 17:10:56.819632 2026-01-01 15:01:23.665489
MPC_primarydb primary_objects 1528900 2026-01-01 14:50:18.809122 2026-01-01 15:01:23.751072
MPC_mpcsbndb primary_objects 1528900 2026-01-01 14:50:18.809122 2026-01-01 15:01:24.163642
SBN_to_AWS primary_objects 1528900 2026-01-01 14:50:18.809122 2026-01-01 15:01:24.328631
MPC_primarydb obs_alterations_corrections 0 2026-01-01 15:01:24.508852
MPC_mpcsbndb obs_alterations_corrections 0 2026-01-01 15:01:24.617588
SBN_to_AWS obs_alterations_corrections 0 2026-01-01 15:01:24.699575
MPC_primarydb obs_alterations_deletions 1445633 2026-01-01 01:44:09.94128 2026-01-01 15:01:24.78483
MPC_mpcsbndb obs_alterations_deletions 1445633 2026-01-01 01:44:09.94128 2026-01-01 15:01:25.170107
SBN_to_AWS obs_alterations_deletions 1445633 2026-01-01 01:44:09.94128 2026-01-01 15:01:25.300719
MPC_primarydb obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2026-01-01 15:01:25.444892
MPC_mpcsbndb obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2026-01-01 15:01:25.809583
SBN_to_AWS obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2026-01-01 15:01:25.89235