a

Minor Planet Center Annex

@ SBN

DOWNTIME ANNOUNCEMENT

The SBN Annex server and hosted applications may be down between August 7th and August 10th owing to facility upgrades. Please plan accordingly.

Thank you for your patience.

 

Database Status: GREEN

26 Jun 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-08-10 16: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 5227 2026-06-03 09:27:00 2026-06-03 09:27:00
comet_orbits 12785 2014-02-10 15:54:13 2026-08-07 20:01:03
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50789808 2026-08-10 08:38:17 2026-08-10 08:38:17
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1295 2026-06-03 09:12:00 2026-06-03 09:12:00
numbered_identifications 1342746 2026-06-03 02:55:41 2026-06-03 02:55:41
numbered_mps 895910 2011-10-27 02:54:58 2026-08-06 11:46:35
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 524415245 2026-08-10 15:58:29 2026-08-10 15:58:29
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1570738 2021-08-31 13:00:20 2026-08-10 16:01:03
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 91 2026-08-09 05:26:49.749374 2026-08-10 15:22:06.805344
neocp_events 331714 2026-08-10 16:02:19.891369 2026-08-10 16:02:19.891369
neocp_obs_archive 825687 2026-08-10 15:07:13.480069 2026-08-10 15:07:13.480069
neocp_obs 949 2026-08-10 15:07:13.43785 2026-08-10 15:07:13.43785
neocp_prev_des 73368 2026-08-10 16:02:19.791614 2026-08-10 16:02:19.791614
neocp_var 194796 2026-08-10 15:07:13.651586 2026-08-10 15:07:13.651586
current_identifications 2085511 2026-08-10 16:52:44.677391 2026-08-10 16:53:22.023478
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1595338 2026-08-10 16:52:44.619594 2026-08-10 16:52:44.619594
obs_sbn 545099314 2017-07-09 20:00:00-04 2026-08-10 12:52:48.430412-04
obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-09 11:56:54.769066
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 10:10:20.798243
mpc_orbits 1560908 2026-08-10 16:53:34.555732 2026-08-10 16:53:42.912925
minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-06 15:47:16.33429
obscodes 2715 2019-05-25 00:11:25.802013 2026-08-07 19:21:26.788283
comet_names 4389 2026-08-07 13:39:18.93276 2026-08-07 13:39:18.93276
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 545099298 2026-08-10 15:59:06.281234 2026-08-10 16:00:02.167374
MPC_mpcsbndb obs_sbn 545099298 2026-08-10 15:59:06.281234 2026-08-10 16:00:14.709953
SBN_to_AWS obs_sbn 545099298 2026-08-10 15:59:06.281234 2026-08-10 16:00:55.603345
MPC_primarydb current_identifications 2085504 2026-08-10 16:36:16.771511 2026-08-10 16:36:24.774871
MPC_mpcsbndb current_identifications 2085504 2026-08-10 16:36:16.771511 2026-08-10 16:36:26.50922
SBN_to_AWS current_identifications 2085504 2026-08-10 16:36:16.771511 2026-08-10 16:36:26.679041
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 16:36:27.449409
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 16:36:27.566268
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 16:36:27.659402
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 16:36:27.762514
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 16:36:27.928288
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 16:36:28.038168
MPC_primarydb mpc_orbits 1560900 2026-08-10 16:35:34.027167 2026-08-10 16:36:28.198008
MPC_mpcsbndb mpc_orbits 1560900 2026-08-10 16:35:34.027167 2026-08-10 16:36:29.800344
SBN_to_AWS mpc_orbits 1560900 2026-08-10 16:35:34.027167 2026-08-10 16:36:30.127532
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 16:36:34.7189
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 16:36:35.011222
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 16:36:35.150103
MPC_primarydb neocp_els 90 2026-08-10 15:22:06.805344 2026-08-10 16:36:35.452165
MPC_mpcsbndb neocp_els 90 2026-08-10 15:22:06.805344 2026-08-10 16:36:35.565275
SBN_to_AWS neocp_els 90 2026-08-10 15:22:06.805344 2026-08-10 16:36:35.656667
MPC_primarydb neocp_events 331714 2026-08-10 16:02:19.891369 2026-08-10 16:36:35.755066
MPC_mpcsbndb neocp_events 331714 2026-08-10 16:02:19.891369 2026-08-10 16:36:35.94929
SBN_to_AWS neocp_events 331714 2026-08-10 16:02:19.891369 2026-08-10 16:36:36.074166
MPC_primarydb neocp_obs 945 2026-08-10 15:07:13.43785 2026-08-10 16:36:36.239256
MPC_mpcsbndb neocp_obs 945 2026-08-10 15:07:13.43785 2026-08-10 16:36:36.354205
SBN_to_AWS neocp_obs 945 2026-08-10 15:07:13.43785 2026-08-10 16:36:36.446205
MPC_primarydb neocp_obs_archive 825687 2026-08-10 15:07:13.480069 2026-08-10 16:36:36.546814
MPC_mpcsbndb neocp_obs_archive 825687 2026-08-10 15:07:13.480069 2026-08-10 16:36:36.740751
SBN_to_AWS neocp_obs_archive 825687 2026-08-10 15:07:13.480069 2026-08-10 16:36:36.918703
MPC_primarydb neocp_prev_des 73368 2026-08-10 16:02:19.791614 2026-08-10 16:36:37.163807
MPC_mpcsbndb neocp_prev_des 73368 2026-08-10 16:02:19.791614 2026-08-10 16:36:37.310756
SBN_to_AWS neocp_prev_des 73368 2026-08-10 16:02:19.791614 2026-08-10 16:36:37.417099
MPC_primarydb neocp_var 192796 2026-08-10 15:07:13.651586 2026-08-10 16:36:37.542257
MPC_mpcsbndb neocp_var 192796 2026-08-10 15:07:13.651586 2026-08-10 16:36:37.728811
SBN_to_AWS neocp_var 192796 2026-08-10 15:07:13.651586 2026-08-10 16:36:37.852305
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 16:36:38.056499
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 16:36:38.184205
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 16:36:38.276878
MPC_primarydb primary_objects 1595331 2026-08-10 16:36:16.675671 2026-08-10 16:36:38.377499
MPC_mpcsbndb primary_objects 1595331 2026-08-10 16:36:16.675671 2026-08-10 16:36:38.864918
SBN_to_AWS primary_objects 1595331 2026-08-10 16:36:16.675671 2026-08-10 16:36:39.082922
MPC_primarydb obs_alterations_corrections 0 2026-08-10 16:36:40.754964
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-10 16:36:40.869437
SBN_to_AWS obs_alterations_corrections 0 2026-08-10 16:36:40.960211
MPC_primarydb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 16:36:41.055035
MPC_mpcsbndb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 16:36:41.56351
SBN_to_AWS obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 16:36:41.704204
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 16:36:41.993732
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 16:36:42.111773
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 16:36:42.206235
MPC_primarydb obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 16:36:42.305965
MPC_mpcsbndb obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 16:36:42.565775
SBN_to_AWS obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 16:36:42.704199