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-20 19: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 11215 2026-01-14 17:20:39 2026-01-14 18:01:04
identifications 211641 2026-01-14 12:15:20 2026-01-14 12:15:20
isolated_tracklets 49737418 2026-01-20 19:18:14 2026-01-20 19:18: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 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 502474215 2026-01-20 17:48:13 2026-01-20 17:48:13
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1508703 2023-02-01 10:05:11 2026-01-20 18:01:12
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 110 2026-01-13 04:48:28.123049 2026-01-20 19:21:02.778919
neocp_events 308608 2026-01-20 19:13:12.751969 2026-01-20 19:13:12.751969
neocp_obs_archive 773794 2026-01-20 19:13:12.493333 2026-01-20 19:13:12.493333
neocp_obs 1456 2026-01-20 19:13:12.452108 2026-01-20 19:13:12.452108
neocp_prev_des 70676 2026-01-20 19:06:33.19189 2026-01-20 19:06:33.19189
neocp_var 204450 2026-01-20 19:13:12.619334 2026-01-20 19:13:12.619334
current_identifications 2019001 2026-01-20 17:46:29.877559 2026-01-20 17:47:30.210656
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1534727 2026-01-20 17:46:29.778013 2026-01-20 17:46:29.778013
obs_sbn 524853070 2026-01-20 14:10:09.037978-05 2026-01-20 14:18:12.621933-05
obs_alterations_deletions 1467382 2026-01-20 13:14:06.705129 2026-01-20 13:14:06.705129
obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-03 19:19:15.911342
obs_alterations_unassociations 534127 2026-01-20 19:18:10.676411 2026-01-20 19:18:10.676411
mpc_orbits 1490944 2021-02-04 01:39:22.911979 2026-01-20 19:06:19.226842
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
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 524853053 2026-01-20 18:56:24.441395 2026-01-20 19:00:02.807135
MPC_mpcsbndb obs_sbn 524853053 2026-01-20 18:56:24.441395 2026-01-20 19:00:19.93532
SBN_to_AWS obs_sbn 524853053 2026-01-20 18:56:24.441395 2026-01-20 19:00:43.337699
MPC_primarydb current_identifications 2019001 2026-01-20 17:47:30.210656 2026-01-20 19:01:22.111432
MPC_mpcsbndb current_identifications 2019001 2026-01-20 17:47:30.210656 2026-01-20 19:01:22.624655
SBN_to_AWS current_identifications 2019001 2026-01-20 17:47:30.210656 2026-01-20 19:01:22.844374
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-01-20 19:01:23.07684
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-01-20 19:01:23.221191
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-01-20 19:01:23.320695
MPC_primarydb mpc_orbits 1490944 2026-01-20 18:56:24.441395 2026-01-20 19:01:23.416776
MPC_mpcsbndb mpc_orbits 1490944 2026-01-20 18:56:24.441395 2026-01-20 19:01:25.29094
SBN_to_AWS mpc_orbits 1490944 2026-01-20 18:56:24.441395 2026-01-20 19:01:25.496703
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-20 19:01:25.723511
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-20 19:01:26.057566
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2026-01-20 19:01:26.195656
MPC_primarydb neocp_els 111 2026-01-20 18:44:33.72838 2026-01-20 19:01:26.336825
MPC_mpcsbndb neocp_els 111 2026-01-20 18:44:33.72838 2026-01-20 19:01:26.438413
SBN_to_AWS neocp_els 111 2026-01-20 18:44:33.72838 2026-01-20 19:01:26.525788
MPC_primarydb neocp_events 308605 2026-01-20 18:44:33.998303 2026-01-20 19:01:26.61631
MPC_mpcsbndb neocp_events 308605 2026-01-20 18:44:33.998303 2026-01-20 19:01:26.798029
SBN_to_AWS neocp_events 308605 2026-01-20 18:44:33.998303 2026-01-20 19:01:26.917731
MPC_primarydb neocp_obs 1456 2026-01-20 18:44:33.646009 2026-01-20 19:01:27.028521
MPC_mpcsbndb neocp_obs 1456 2026-01-20 18:44:33.646009 2026-01-20 19:01:27.130379
SBN_to_AWS neocp_obs 1456 2026-01-20 18:44:33.646009 2026-01-20 19:01:27.218198
MPC_primarydb neocp_obs_archive 773790 2026-01-20 18:44:33.686945 2026-01-20 19:01:27.308012
MPC_mpcsbndb neocp_obs_archive 773790 2026-01-20 18:44:33.686945 2026-01-20 19:01:27.560405
SBN_to_AWS neocp_obs_archive 773790 2026-01-20 18:44:33.686945 2026-01-20 19:01:27.695907
MPC_primarydb neocp_prev_des 70675 2026-01-20 18:05:55.44695 2026-01-20 19:01:27.83254
MPC_mpcsbndb neocp_prev_des 70675 2026-01-20 18:05:55.44695 2026-01-20 19:01:27.966163
SBN_to_AWS neocp_prev_des 70675 2026-01-20 18:05:55.44695 2026-01-20 19:01:28.068751
MPC_primarydb neocp_var 206450 2026-01-20 18:44:33.859632 2026-01-20 19:01:28.165804
MPC_mpcsbndb neocp_var 206450 2026-01-20 18:44:33.859632 2026-01-20 19:01:28.354831
SBN_to_AWS neocp_var 206450 2026-01-20 18:44:33.859632 2026-01-20 19:01:28.480217
MPC_primarydb obscodes 2669 2026-01-20 16:37:02.421427 2026-01-20 19:01:28.584792
MPC_mpcsbndb obscodes 2669 2026-01-20 16:37:02.421427 2026-01-20 19:01:28.699034
SBN_to_AWS obscodes 2669 2026-01-20 16:37:02.421427 2026-01-20 19:01:28.787268
MPC_primarydb primary_objects 1534727 2026-01-20 17:46:29.778013 2026-01-20 19:01:28.877717
MPC_mpcsbndb primary_objects 1534727 2026-01-20 17:46:29.778013 2026-01-20 19:01:29.270504
SBN_to_AWS primary_objects 1534727 2026-01-20 17:46:29.778013 2026-01-20 19:01:29.433782
MPC_primarydb obs_alterations_corrections 0 2026-01-20 19:01:29.617085
MPC_mpcsbndb obs_alterations_corrections 0 2026-01-20 19:01:29.718323
SBN_to_AWS obs_alterations_corrections 0 2026-01-20 19:01:29.804744
MPC_primarydb obs_alterations_deletions 1467382 2026-01-20 13:14:06.705129 2026-01-20 19:01:29.894425
MPC_mpcsbndb obs_alterations_deletions 1467382 2026-01-20 13:14:06.705129 2026-01-20 19:01:30.30884
SBN_to_AWS obs_alterations_deletions 1467382 2026-01-20 13:14:06.705129 2026-01-20 19:01:30.447534
MPC_primarydb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-20 19:01:30.596763
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-20 19:01:30.702661
SBN_to_AWS obs_alterations_redesignations 4515 2026-01-03 19:19:15.911342 2026-01-20 19:01:30.790806