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 06: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 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 524408174 2026-08-04 04:37:48 2026-08-04 04:37:48
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1569684 2026-08-04 04:37:57 2026-08-04 05: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 37 2026-08-03 11:23:02.774568 2026-08-04 06:24:36.701771
neocp_events 330712 2026-08-04 06:24:36.661164 2026-08-04 06:24:36.661164
neocp_obs_archive 823912 2026-08-04 06:24:36.619438 2026-08-04 06:24:36.619438
neocp_obs 594 2026-08-04 06:24:36.57856 2026-08-04 06:24:36.57856
neocp_prev_des 73260 2026-08-04 04:37:06.79961 2026-08-04 04:37:06.79961
neocp_var 86841 2026-08-04 06:24:36.792268 2026-08-04 06:24:36.792268
current_identifications 2084396 2022-06-02 09:49:22.030146 2026-08-04 06:33:22.44499
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594347 2026-08-04 04:36:22.536514 2026-08-04 04:36:22.536514
obs_sbn 544389728 2024-02-12 15:00:04.740475-05 2026-08-04 02:43:13.125483-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 1559805 2026-06-04 21:25:22.096492 2026-08-04 06:43:44.668157
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 544389711 2026-08-04 05:59:38.532233 2026-08-04 06:00:02.42362
MPC_mpcsbndb obs_sbn 544389711 2026-08-04 05:59:38.532233 2026-08-04 06:00:22.188107
SBN_to_AWS obs_sbn 544389711 2026-08-04 06:00:32.286643 2026-08-04 06:01:01.582799
MPC_primarydb current_identifications 2084396 2026-08-04 05:21:08.748253 2026-08-04 06:33:17.883913
MPC_mpcsbndb current_identifications 2084396 2026-08-04 05:21:08.748253 2026-08-04 06:33:18.881522
SBN_to_AWS current_identifications 2084396 2026-08-04 05:21:08.748253 2026-08-04 06:33:19.060227
MPC_primarydb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 06:33:19.83352
MPC_mpcsbndb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 06:33:19.950932
SBN_to_AWS comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 06:33:20.046767
MPC_primarydb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 06:33:20.153235
MPC_mpcsbndb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 06:33:20.308718
SBN_to_AWS minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 06:33:20.421106
MPC_primarydb mpc_orbits 1559805 2026-08-04 06:33:19.280607 2026-08-04 06:33:20.580954
MPC_mpcsbndb mpc_orbits 1559805 2026-08-04 06:33:19.280607 2026-08-04 06:33:22.490229
SBN_to_AWS mpc_orbits 1559805 2026-08-04 06:33:19.280607 2026-08-04 06:33:22.842729
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 06:33:26.802179
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 06:33:27.069048
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 06:33:27.213945
MPC_primarydb neocp_els 37 2026-08-04 06:24:36.701771 2026-08-04 06:33:27.526141
MPC_mpcsbndb neocp_els 37 2026-08-04 06:24:36.701771 2026-08-04 06:33:27.642363
SBN_to_AWS neocp_els 37 2026-08-04 06:24:36.701771 2026-08-04 06:33:27.735972
MPC_primarydb neocp_events 330712 2026-08-04 06:24:36.661164 2026-08-04 06:33:27.836988
MPC_mpcsbndb neocp_events 330712 2026-08-04 06:24:36.661164 2026-08-04 06:33:28.0287
SBN_to_AWS neocp_events 330712 2026-08-04 06:24:36.661164 2026-08-04 06:33:28.159085
MPC_primarydb neocp_obs 594 2026-08-04 06:24:36.57856 2026-08-04 06:33:28.319617
MPC_mpcsbndb neocp_obs 594 2026-08-04 06:24:36.57856 2026-08-04 06:33:28.435412
SBN_to_AWS neocp_obs 594 2026-08-04 06:24:36.57856 2026-08-04 06:33:28.530973
MPC_primarydb neocp_obs_archive 823912 2026-08-04 06:24:36.619438 2026-08-04 06:33:28.636133
MPC_mpcsbndb neocp_obs_archive 823912 2026-08-04 06:24:36.619438 2026-08-04 06:33:28.832401
SBN_to_AWS neocp_obs_archive 823912 2026-08-04 06:24:36.619438 2026-08-04 06:33:29.013039
MPC_primarydb neocp_prev_des 73260 2026-08-04 04:37:06.79961 2026-08-04 06:33:29.262228
MPC_mpcsbndb neocp_prev_des 73260 2026-08-04 04:37:06.79961 2026-08-04 06:33:29.407341
SBN_to_AWS neocp_prev_des 73260 2026-08-04 04:37:06.79961 2026-08-04 06:33:29.518279
MPC_primarydb neocp_var 86841 2026-08-04 06:24:36.792268 2026-08-04 06:33:29.647378
MPC_mpcsbndb neocp_var 86841 2026-08-04 06:24:36.792268 2026-08-04 06:33:29.81619
SBN_to_AWS neocp_var 86841 2026-08-04 06:24:36.792268 2026-08-04 06:33:29.937891
MPC_primarydb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 06:33:30.182038
MPC_mpcsbndb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 06:33:30.311142
SBN_to_AWS obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 06:33:30.407544
MPC_primarydb primary_objects 1594339 2026-08-04 04:36:22.536514 2026-08-04 06:33:30.509455
MPC_mpcsbndb primary_objects 1594339 2026-08-04 04:36:22.536514 2026-08-04 06:33:30.976142
SBN_to_AWS primary_objects 1594339 2026-08-04 04:36:22.536514 2026-08-04 06:33:31.199669
MPC_primarydb obs_alterations_corrections 0 2026-08-04 06:33:32.843602
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-04 06:33:32.957412
SBN_to_AWS obs_alterations_corrections 0 2026-08-04 06:33:33.051184
MPC_primarydb obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-04 06:33:33.149043
MPC_mpcsbndb obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-04 06:33:33.589371
SBN_to_AWS obs_alterations_deletions 1856423 2026-08-03 21:25:04.19656 2026-08-04 06:33:33.743373
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 06:33:34.032873
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 06:33:34.150148
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 06:33:34.2466
MPC_primarydb obs_alterations_unassociations 597192 2026-08-03 22:10:08.298007 2026-08-04 06:33:34.350207
MPC_mpcsbndb obs_alterations_unassociations 597192 2026-08-03 22:10:08.298007 2026-08-04 06:33:34.605176
SBN_to_AWS obs_alterations_unassociations 597192 2026-08-03 22:10:08.298007 2026-08-04 06:33:34.746564