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-09 07:00: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 50789776 2026-08-08 22:18:19 2026-08-08 22:18:19
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 524414196 2026-08-09 03:56:24 2026-08-09 03:56:24
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1569871 2026-08-09 03:56:34 2026-08-09 04: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 70 2026-08-07 06:14:18.843792 2026-08-09 06:53:36.85685
neocp_events 331471 2026-08-09 06:53:36.816135 2026-08-09 06:53:36.816135
neocp_obs_archive 825268 2026-08-09 06:53:36.774428 2026-08-09 06:53:36.774428
neocp_obs 707 2026-08-09 06:53:36.733498 2026-08-09 06:53:36.733498
neocp_prev_des 73345 2026-08-09 03:55:36.048232 2026-08-09 03:55:36.048232
neocp_var 153294 2026-08-09 06:53:36.947431 2026-08-09 06:53:36.947431
current_identifications 2084708 2026-02-06 09:02:57.736717 2026-08-09 06:58:03.660816
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594540 2026-08-09 03:54:50.94884 2026-08-09 03:54:50.94884
obs_sbn 544968977 2026-03-23 08:21:38.109932-04 2026-08-09 03:03:32.185344-04
obs_alterations_deletions 1869919 2026-08-09 03:16:09.286027 2026-08-09 03:16:09.286027
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 598628 2026-08-08 22:11:33.035874 2026-08-08 22:11:33.035874
mpc_orbits 1560108 2023-02-26 13:45:14.491624 2026-08-09 07:04:06.828839
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 544965417 2026-08-09 06:00:00.695657 2026-08-09 06:00:02.874191
MPC_mpcsbndb obs_sbn 544966140 2026-08-09 06:00:31.532816 2026-08-09 06:00:33.910591
SBN_to_AWS obs_sbn 544967309 2026-08-09 06:01:12.797931 2026-08-09 06:01:18.135086
MPC_primarydb current_identifications 2084708 2026-08-09 05:45:01.460436 2026-08-09 06:36:29.891898
MPC_mpcsbndb current_identifications 2084708 2026-08-09 05:45:01.460436 2026-08-09 06:36:30.902671
SBN_to_AWS current_identifications 2084708 2026-08-09 05:45:01.460436 2026-08-09 06:36:31.072307
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 06:36:31.821213
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 06:36:31.934162
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 06:36:32.033199
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 06:36:32.140719
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 06:36:32.29774
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 06:36:32.411778
MPC_primarydb mpc_orbits 1560108 2026-08-09 06:36:15.416684 2026-08-09 06:36:32.574475
MPC_mpcsbndb mpc_orbits 1560108 2026-08-09 06:36:15.416684 2026-08-09 06:36:34.404993
SBN_to_AWS mpc_orbits 1560108 2026-08-09 06:36:15.416684 2026-08-09 06:36:34.751818
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 06:36:38.523011
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 06:36:38.883139
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 06:36:39.035301
MPC_primarydb neocp_els 69 2026-08-09 06:35:32.250164 2026-08-09 06:36:39.343859
MPC_mpcsbndb neocp_els 69 2026-08-09 06:35:32.250164 2026-08-09 06:36:39.455891
SBN_to_AWS neocp_els 69 2026-08-09 06:35:32.250164 2026-08-09 06:36:39.552413
MPC_primarydb neocp_events 331463 2026-08-09 06:35:32.434976 2026-08-09 06:36:39.663486
MPC_mpcsbndb neocp_events 331463 2026-08-09 06:35:32.434976 2026-08-09 06:36:39.869797
SBN_to_AWS neocp_events 331463 2026-08-09 06:35:32.434976 2026-08-09 06:36:40.002582
MPC_primarydb neocp_obs 697 2026-08-09 06:34:04.287346 2026-08-09 06:36:40.176528
MPC_mpcsbndb neocp_obs 697 2026-08-09 06:34:04.287346 2026-08-09 06:36:40.286496
SBN_to_AWS neocp_obs 697 2026-08-09 06:34:04.287346 2026-08-09 06:36:40.383038
MPC_primarydb neocp_obs_archive 825258 2026-08-09 06:34:04.328224 2026-08-09 06:36:40.489998
MPC_mpcsbndb neocp_obs_archive 825258 2026-08-09 06:34:04.328224 2026-08-09 06:36:40.766421
SBN_to_AWS neocp_obs_archive 825258 2026-08-09 06:34:04.328224 2026-08-09 06:36:40.92537
MPC_primarydb neocp_prev_des 73345 2026-08-09 03:55:36.048232 2026-08-09 06:36:41.189332
MPC_mpcsbndb neocp_prev_des 73345 2026-08-09 03:55:36.048232 2026-08-09 06:36:41.336703
SBN_to_AWS neocp_prev_des 73345 2026-08-09 03:55:36.048232 2026-08-09 06:36:41.448903
MPC_primarydb neocp_var 151393 2026-08-09 06:35:32.31052 2026-08-09 06:36:41.583476
MPC_mpcsbndb neocp_var 151393 2026-08-09 06:35:32.31052 2026-08-09 06:36:41.750403
SBN_to_AWS neocp_var 151393 2026-08-09 06:35:32.31052 2026-08-09 06:36:41.879424
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 06:36:41.989999
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 06:36:42.1295
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 06:36:42.228907
MPC_primarydb primary_objects 1594537 2026-08-09 03:54:50.94884 2026-08-09 06:36:42.334465
MPC_mpcsbndb primary_objects 1594537 2026-08-09 03:54:50.94884 2026-08-09 06:36:42.81533
SBN_to_AWS primary_objects 1594537 2026-08-09 03:54:50.94884 2026-08-09 06:36:43.03856
MPC_primarydb obs_alterations_corrections 0 2026-08-09 06:36:44.699506
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-09 06:36:44.811138
SBN_to_AWS obs_alterations_corrections 0 2026-08-09 06:36:44.907459
MPC_primarydb obs_alterations_deletions 1869919 2026-08-09 03:16:09.286027 2026-08-09 06:36:45.007401
MPC_mpcsbndb obs_alterations_deletions 1869919 2026-08-09 03:16:09.286027 2026-08-09 06:36:45.638769
SBN_to_AWS obs_alterations_deletions 1869919 2026-08-09 03:16:09.286027 2026-08-09 06:36:45.791938
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 06:36:46.08972
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 06:36:46.206026
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 06:36:46.305276
MPC_primarydb obs_alterations_unassociations 598628 2026-08-08 22:11:33.035874 2026-08-09 06:36:46.411853
MPC_mpcsbndb obs_alterations_unassociations 598628 2026-08-08 22:11:33.035874 2026-08-09 06:36:46.718331
SBN_to_AWS obs_alterations_unassociations 598628 2026-08-08 22:11:33.035874 2026-08-09 06:36:46.859788