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 19:10: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 50789061 2026-08-04 15:06:11 2026-08-04 15:06:11
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 524408870 2026-08-04 12:35:52 2026-08-04 12:35:52
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1569718 2025-07-25 21:28:16 2026-08-04 13:01:47
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 51 2026-08-04 18:53:08.137934 2026-08-04 18:53:08.137934
neocp_events 330791 2026-08-04 18:53:08.223385 2026-08-04 18:53:08.223385
neocp_obs_archive 824051 2026-08-04 18:53:08.006746 2026-08-04 18:53:08.006746
neocp_obs 644 2026-08-04 18:53:07.965846 2026-08-04 18:53:07.965846
neocp_prev_des 73267 2026-08-04 18:49:45.54951 2026-08-04 18:49:45.54951
neocp_var 113167 2026-08-04 18:53:08.095848 2026-08-04 18:53:08.095848
current_identifications 2084399 2022-06-20 18:37:31.809881 2026-08-04 18:03:18.084639
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594328 2026-08-04 17:08:53.797005 2026-08-04 17:08:53.797005
obs_sbn 544535590 2025-01-03 10:33:06.790333-05 2026-08-04 15:13:09.486813-04
obs_alterations_deletions 1858844 2026-08-04 19:11:23.597394 2026-08-04 19:11:23.597394
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 597352 2026-08-04 18:10:27.934872 2026-08-04 18:10:27.934872
mpc_orbits 1559807 2024-01-11 18:11:08.204292 2026-08-04 19:13:40.256613
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 544534453 2026-08-04 17:59:31.333782 2026-08-04 18:00:02.334941
MPC_mpcsbndb obs_sbn 544534453 2026-08-04 18:00:20.909232 2026-08-04 18:00:29.296569
SBN_to_AWS obs_sbn 544534453 2026-08-04 18:01:07.745656 2026-08-04 18:01:12.100255
MPC_primarydb current_identifications 2084399 2026-08-04 18:03:18.084639 2026-08-04 18:33:30.278501
MPC_mpcsbndb current_identifications 2084399 2026-08-04 18:03:18.084639 2026-08-04 18:33:31.974393
SBN_to_AWS current_identifications 2084399 2026-08-04 18:03:18.084639 2026-08-04 18:33:32.189525
MPC_primarydb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 18:33:32.972027
MPC_mpcsbndb comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 18:33:33.092281
SBN_to_AWS comet_names 4387 2026-07-16 16:23:29.552606 2026-08-04 18:33:33.184566
MPC_primarydb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 18:33:33.298552
MPC_mpcsbndb minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 18:33:33.497726
SBN_to_AWS minor_planet_names 26586 2026-07-28 20:29:44.961106 2026-08-04 18:33:33.6025
MPC_primarydb mpc_orbits 1559807 2026-08-04 18:33:19.088486 2026-08-04 18:33:33.758466
MPC_mpcsbndb mpc_orbits 1559807 2026-08-04 18:33:19.088486 2026-08-04 18:33:35.911005
SBN_to_AWS mpc_orbits 1559807 2026-08-04 18:33:19.088486 2026-08-04 18:33:36.226381
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 18:33:39.981876
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 18:33:40.412739
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-04 18:33:40.561215
MPC_primarydb neocp_els 51 2026-08-04 18:06:24.484073 2026-08-04 18:33:40.890096
MPC_mpcsbndb neocp_els 51 2026-08-04 18:06:24.484073 2026-08-04 18:33:41.008849
SBN_to_AWS neocp_els 51 2026-08-04 18:06:24.484073 2026-08-04 18:33:41.09981
MPC_primarydb neocp_events 330786 2026-08-04 18:06:24.473025 2026-08-04 18:33:41.196096
MPC_mpcsbndb neocp_events 330786 2026-08-04 18:06:24.473025 2026-08-04 18:33:41.534262
SBN_to_AWS neocp_events 330786 2026-08-04 18:06:24.473025 2026-08-04 18:33:41.659291
MPC_primarydb neocp_obs 638 2026-08-04 18:06:24.390518 2026-08-04 18:33:41.830097
MPC_mpcsbndb neocp_obs 638 2026-08-04 18:06:24.390518 2026-08-04 18:33:41.95037
SBN_to_AWS neocp_obs 638 2026-08-04 18:06:24.390518 2026-08-04 18:33:42.042003
MPC_primarydb neocp_obs_archive 824045 2026-08-04 18:06:24.431346 2026-08-04 18:33:42.143774
MPC_mpcsbndb neocp_obs_archive 824045 2026-08-04 18:06:24.431346 2026-08-04 18:33:42.465059
SBN_to_AWS neocp_obs_archive 824045 2026-08-04 18:06:24.431346 2026-08-04 18:33:42.643745
MPC_primarydb neocp_prev_des 73266 2026-08-04 17:09:31.381661 2026-08-04 18:33:42.89621
MPC_mpcsbndb neocp_prev_des 73266 2026-08-04 17:09:31.381661 2026-08-04 18:33:43.074957
SBN_to_AWS neocp_prev_des 73266 2026-08-04 17:09:31.381661 2026-08-04 18:33:43.425957
MPC_primarydb neocp_var 112377 2026-08-04 18:06:24.573923 2026-08-04 18:33:43.55543
MPC_mpcsbndb neocp_var 112377 2026-08-04 18:06:24.573923 2026-08-04 18:33:43.731299
SBN_to_AWS neocp_var 112377 2026-08-04 18:06:24.573923 2026-08-04 18:33:43.861135
MPC_primarydb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 18:33:44.083393
MPC_mpcsbndb obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 18:33:44.274414
SBN_to_AWS obscodes 2714 2026-07-31 17:40:51.125112 2026-08-04 18:33:44.368251
MPC_primarydb primary_objects 1594326 2026-08-04 17:08:53.797005 2026-08-04 18:33:44.468731
MPC_mpcsbndb primary_objects 1594326 2026-08-04 17:08:53.797005 2026-08-04 18:33:45.499177
SBN_to_AWS primary_objects 1594326 2026-08-04 17:08:53.797005 2026-08-04 18:33:45.755843
MPC_primarydb obs_alterations_corrections 0 2026-08-04 18:33:47.382932
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-04 18:33:47.502333
SBN_to_AWS obs_alterations_corrections 0 2026-08-04 18:33:47.591923
MPC_primarydb obs_alterations_deletions 1856611 2026-08-04 17:51:33.663754 2026-08-04 18:33:47.689562
MPC_mpcsbndb obs_alterations_deletions 1856611 2026-08-04 17:51:33.663754 2026-08-04 18:33:49.004624
SBN_to_AWS obs_alterations_deletions 1856611 2026-08-04 17:51:33.663754 2026-08-04 18:33:49.162171
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 18:33:49.442205
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 18:33:49.57382
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-04 18:33:49.669056
MPC_primarydb obs_alterations_unassociations 597352 2026-08-04 18:10:27.934872 2026-08-04 18:33:49.769538
MPC_mpcsbndb obs_alterations_unassociations 597352 2026-08-04 18:10:27.934872 2026-08-04 18:33:50.168218
SBN_to_AWS obs_alterations_unassociations 597352 2026-08-04 18:10:27.934872 2026-08-04 18:33:50.298582