Minor Planet Center Annex

@ SBN

DOWNTIME ANNOUNCEMENT

Intermittent network outages due to network upgrades by the university and department:

  • EST 10pm Thu 8 Jan thru 7pm Fri 9 Jan

Thank you for your patience.

 

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-13 18:40: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 11214 2025-01-03 03:38:22 2026-01-12 23:01:03
identifications 211637 2026-01-13 16:34:23 2026-01-13 16:34:23
isolated_tracklets 49693120 2026-01-13 18:38:16 2026-01-13 18:38:16
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 502462375 2026-01-13 16:39:32 2026-01-13 16:39:32
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1507220 2025-09-06 13:00:07 2026-01-13 17:02: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 102 2026-01-13 13:37:03.641759 2026-01-13 18:44:12.611339
neocp_events 306483 2026-01-13 18:44:12.793606 2026-01-13 18:44:12.793606
neocp_obs_archive 768678 2026-01-13 18:44:12.603545 2026-01-13 18:44:12.603545
neocp_obs 841 2026-01-13 18:44:12.596685 2026-01-13 18:44:12.596685
neocp_prev_des 70404 2026-01-13 17:14:15.839149 2026-01-13 17:14:15.839149
neocp_var 196157 2026-01-13 18:44:12.661972 2026-01-13 18:44:12.661972
current_identifications 2017609 2026-01-13 18:43:58.00653 2026-01-13 18:43:58.00653
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1533337 2026-01-13 18:43:57.965878 2026-01-13 18:43:57.965878
obs_sbn 523125567 2026-01-13 06:05:45.993041-05 2026-01-13 13:44:24.010787-05
obs_alterations_deletions 1465753 2026-01-13 17:06:39.201483 2026-01-13 17:06:39.201483
obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-03 19:19:15.911342
obs_alterations_unassociations 531438 2026-01-13 18:10:08.2008 2026-01-13 18:10:08.2008
mpc_orbits 1489448 2021-02-03 22:42:21.836019 2026-01-13 18:44:38.403963
minor_planet_names 25992 2011-10-28 14:58:12 2026-01-12 19:34:38.184247
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 523101927 2026-01-13 18:00:02.254919 2026-01-13 18:00:02.811308
MPC_mpcsbndb obs_sbn 523102106 2026-01-13 18:00:25.268239 2026-01-13 18:00:25.805894
SBN_to_AWS obs_sbn 523102290 2026-01-13 18:00:48.064022 2026-01-13 18:00:49.58187
MPC_primarydb current_identifications 2017574 2026-01-13 18:01:16.010824 2026-01-13 18:01:31.252022
MPC_mpcsbndb current_identifications 2017574 2026-01-13 18:01:16.010824 2026-01-13 18:01:31.804451
SBN_to_AWS current_identifications 2017574 2026-01-13 18:01:16.010824 2026-01-13 18:01:32.010449
MPC_primarydb minor_planet_names 25992 2026-01-12 19:34:38.184247 2026-01-13 18:01:32.239057
MPC_mpcsbndb minor_planet_names 25992 2026-01-12 19:34:38.184247 2026-01-13 18:01:32.375957
SBN_to_AWS minor_planet_names 25992 2026-01-12 19:34:38.184247 2026-01-13 18:01:32.467377
MPC_primarydb mpc_orbits 1489413 2026-01-13 18:01:31.862114 2026-01-13 18:01:32.557715
MPC_mpcsbndb mpc_orbits 1489413 2026-01-13 18:01:34.783828 2026-01-13 18:01:35.313587
SBN_to_AWS mpc_orbits 1489413 2026-01-13 18:01:33.478476 2026-01-13 18:01:35.759145
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-13 18:01:36.237618
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-13 18:01:36.604011
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-13 18:01:36.729787
MPC_primarydb neocp_els 100 2026-01-13 17:58:27.258931 2026-01-13 18:01:36.864357
MPC_mpcsbndb neocp_els 100 2026-01-13 17:58:27.258931 2026-01-13 18:01:36.949219
SBN_to_AWS neocp_els 100 2026-01-13 17:58:27.258931 2026-01-13 18:01:37.029711
MPC_primarydb neocp_events 306478 2026-01-13 17:58:27.455588 2026-01-13 18:01:37.113144
MPC_mpcsbndb neocp_events 306478 2026-01-13 17:58:27.455588 2026-01-13 18:01:37.288033
SBN_to_AWS neocp_events 306478 2026-01-13 17:58:27.455588 2026-01-13 18:01:37.400349
MPC_primarydb neocp_obs 824 2026-01-13 17:58:27.232695 2026-01-13 18:01:37.505885
MPC_mpcsbndb neocp_obs 824 2026-01-13 17:58:27.232695 2026-01-13 18:01:37.597561
SBN_to_AWS neocp_obs 824 2026-01-13 17:58:27.232695 2026-01-13 18:01:37.679044
MPC_primarydb neocp_obs_archive 768661 2026-01-13 17:58:27.246542 2026-01-13 18:01:37.763188
MPC_mpcsbndb neocp_obs_archive 768661 2026-01-13 17:58:27.246542 2026-01-13 18:01:38.010051
SBN_to_AWS neocp_obs_archive 768661 2026-01-13 17:58:27.246542 2026-01-13 18:01:38.136337
MPC_primarydb neocp_prev_des 70404 2026-01-13 17:14:15.839149 2026-01-13 18:01:38.267167
MPC_mpcsbndb neocp_prev_des 70404 2026-01-13 17:14:15.839149 2026-01-13 18:01:38.390081
SBN_to_AWS neocp_prev_des 70404 2026-01-13 17:14:15.839149 2026-01-13 18:01:38.477812
MPC_primarydb neocp_var 192806 2026-01-13 17:58:27.31005 2026-01-13 18:01:38.570599
MPC_mpcsbndb neocp_var 192806 2026-01-13 17:58:27.31005 2026-01-13 18:01:38.761093
SBN_to_AWS neocp_var 192806 2026-01-13 17:58:27.31005 2026-01-13 18:01:38.879913
MPC_primarydb obscodes 2669 2026-01-13 16:57:56.370211 2026-01-13 18:01:38.980221
MPC_mpcsbndb obscodes 2669 2026-01-13 16:57:56.370211 2026-01-13 18:01:39.087262
SBN_to_AWS obscodes 2669 2026-01-13 16:57:56.370211 2026-01-13 18:01:39.168805
MPC_primarydb primary_objects 1533302 2026-01-13 18:01:15.980352 2026-01-13 18:01:39.253184
MPC_mpcsbndb primary_objects 1533302 2026-01-13 18:01:15.980352 2026-01-13 18:01:39.713243
SBN_to_AWS primary_objects 1533302 2026-01-13 18:01:15.980352 2026-01-13 18:01:39.872159
MPC_primarydb obs_alterations_corrections 0 2026-01-13 18:01:40.050695
MPC_mpcsbndb obs_alterations_corrections 0 2026-01-13 18:01:40.143798
SBN_to_AWS obs_alterations_corrections 0 2026-01-13 18:01:40.224198
MPC_primarydb obs_alterations_deletions 1465753 2026-01-13 17:06:39.201483 2026-01-13 18:01:40.30807
MPC_mpcsbndb obs_alterations_deletions 1465753 2026-01-13 17:06:39.201483 2026-01-13 18:01:40.799971
SBN_to_AWS obs_alterations_deletions 1465753 2026-01-13 17:06:39.201483 2026-01-13 18:01:40.925623
MPC_primarydb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-13 18:01:41.083202
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-13 18:01:41.180848
SBN_to_AWS obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-13 18:01:41.262764