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-04 00:30: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 12778 2025-02-07 23:25:28 2026-07-28 21:01:03
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50789049 2026-08-03 12:18:16 2026-08-03 12:18:16
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 2026-06-03 02:57:32 2026-07-28 16:29:45
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 524408061 2026-08-03 23:40:25 2026-08-03 23:40:25
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1569680 2026-08-03 23:37:36 2026-08-04 00: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 41 2026-08-03 12:12:20.963431 2026-08-04 00:22:47.236991
neocp_events 330668 2026-08-04 00:22:47.195 2026-08-04 00:22:47.195
neocp_obs_archive 823843 2026-08-04 00:22:47.1535 2026-08-04 00:22:47.1535
neocp_obs 657 2026-08-04 00:22:47.111614 2026-08-04 00:22:47.111614
neocp_prev_des 73254 2026-08-03 23:39:47.478821 2026-08-03 23:39:47.478821
neocp_var 94705 2026-08-04 00:22:47.328251 2026-08-04 00:22:47.328251
current_identifications 2084388 2026-08-03 23:39:06.428945 2026-08-03 23:40:00.104952
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594343 2026-08-03 23:39:06.366631 2026-08-03 23:39:06.366631
obs_sbn 544389466 2026-08-03 20:19:19.543414-04 2026-08-03 20:20:50.208027-04
obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-03 21:25:04.19656
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 597192 2026-08-03 22:10:08.298007 2026-08-03 22:10:08.298007
mpc_orbits 1559798 2021-02-04 02:03:56.048573 2026-08-04 00:20:50.208027
minor_planet_names 26586 2026-03-12 16:50:47.342026 2026-07-28 20:29:44.961106
obscodes 2714 2019-05-25 00:11:26.941588 2026-07-31 17:40:51.125112
comet_names 4387 2026-07-16 16:23:29.552606 2026-07-16 16:23:29.552606
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 544389456 2026-08-03 23:40:01.991251 2026-08-04 00:00:02.392831
MPC_mpcsbndb obs_sbn 544389456 2026-08-03 23:40:01.991251 2026-08-04 00:00:19.826965
SBN_to_AWS obs_sbn 544389456 2026-08-03 23:40:01.991251 2026-08-04 00:01:00.37412
MPC_primarydb obs_sbn 544388780 2026-08-03 21:57:24.637263 2026-08-03 22:00:02.971178
MPC_mpcsbndb obs_sbn 544388780 2026-08-03 21:57:24.637263 2026-08-03 22:00:19.414504
SBN_to_AWS obs_sbn 544388780 2026-08-03 21:57:24.637263 2026-08-03 22:01:00.266512
MPC_primarydb current_identifications 2084386 2026-08-03 22:29:56.933397 2026-08-03 22:33:00.789257
MPC_mpcsbndb current_identifications 2084386 2026-08-03 22:29:56.933397 2026-08-03 22:33:01.630386
SBN_to_AWS current_identifications 2084386 2026-08-03 22:29:56.933397 2026-08-03 22:33:01.802774
MPC_primarydb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-03 22:33:02.568061
MPC_mpcsbndb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-03 22:33:02.682676
SBN_to_AWS comet_names 4387 2026-07-16 16:23:29.552606 2026-08-03 22:33:02.774041
MPC_primarydb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-03 22:33:02.875873
MPC_mpcsbndb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-03 22:33:03.033096
SBN_to_AWS minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-03 22:33:03.138166
MPC_primarydb mpc_orbits 1559796 2026-08-03 22:33:03.177629 2026-08-03 22:33:03.292419
MPC_mpcsbndb mpc_orbits 1559796 2026-08-03 22:33:03.177629 2026-08-03 22:33:04.92788
SBN_to_AWS mpc_orbits 1559796 2026-08-03 22:33:03.177629 2026-08-03 22:33:05.269775
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-03 22:33:09.13387
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-03 22:33:09.42024
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-03 22:33:09.574443
MPC_primarydb neocp_els 43 2026-08-03 22:24:26.184826 2026-08-03 22:33:09.88216
MPC_mpcsbndb neocp_els 43 2026-08-03 22:24:26.184826 2026-08-03 22:33:09.996079
SBN_to_AWS neocp_els 43 2026-08-03 22:24:26.184826 2026-08-03 22:33:10.086195
MPC_primarydb neocp_events 330652 2026-08-03 22:24:26.144062 2026-08-03 22:33:10.183973
MPC_mpcsbndb neocp_events 330652 2026-08-03 22:24:26.144062 2026-08-03 22:33:10.388325
SBN_to_AWS neocp_events 330652 2026-08-03 22:24:26.144062 2026-08-03 22:33:10.51503
MPC_primarydb neocp_obs 671 2026-08-03 22:24:26.061289 2026-08-03 22:33:10.676293
MPC_mpcsbndb neocp_obs 671 2026-08-03 22:24:26.061289 2026-08-03 22:33:10.792931
SBN_to_AWS neocp_obs 671 2026-08-03 22:24:26.061289 2026-08-03 22:33:10.883721
MPC_primarydb neocp_obs_archive 823811 2026-08-03 22:24:26.102642 2026-08-03 22:33:10.983964
MPC_mpcsbndb neocp_obs_archive 823811 2026-08-03 22:24:26.102642 2026-08-03 22:33:11.189127
SBN_to_AWS neocp_obs_archive 823811 2026-08-03 22:24:26.102642 2026-08-03 22:33:11.365461
MPC_primarydb neocp_prev_des 73252 2026-08-03 20:36:56.60883 2026-08-03 22:33:11.604178
MPC_mpcsbndb neocp_prev_des 73252 2026-08-03 20:36:56.60883 2026-08-03 22:33:11.749899
SBN_to_AWS neocp_prev_des 73252 2026-08-03 20:36:56.60883 2026-08-03 22:33:11.855983
MPC_primarydb neocp_var 98802 2026-08-03 22:24:26.279124 2026-08-03 22:33:11.98144
MPC_mpcsbndb neocp_var 98802 2026-08-03 22:24:26.279124 2026-08-03 22:33:12.153822
SBN_to_AWS neocp_var 98802 2026-08-03 22:24:26.279124 2026-08-03 22:33:12.272449
MPC_primarydb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-03 22:33:12.544833
MPC_mpcsbndb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-03 22:33:12.675219
SBN_to_AWS obscodes 2714 2026-07-31 17:40:51.125112 2026-08-03 22:33:12.767823
MPC_primarydb primary_objects 1594341 2026-08-03 21:03:17.428764 2026-08-03 22:33:12.867221
MPC_mpcsbndb primary_objects 1594341 2026-08-03 21:03:17.428764 2026-08-03 22:33:13.34209
SBN_to_AWS primary_objects 1594341 2026-08-03 21:03:17.428764 2026-08-03 22:33:13.573952
MPC_primarydb obs_alterations_corrections 0 2026-08-03 22:33:15.196303
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-03 22:33:15.310778
SBN_to_AWS obs_alterations_corrections 0 2026-08-03 22:33:15.400417
MPC_primarydb obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-03 22:33:15.493334
MPC_mpcsbndb obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-03 22:33:15.947408
SBN_to_AWS obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-03 22:33:16.096746
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-03 22:33:16.375018
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-03 22:33:16.491485
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-03 22:33:16.582956