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 13:20: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 50789797 2026-08-09 12:48:19 2026-08-09 12:48: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 524414749 2026-08-09 12:39:10 2026-08-09 12:39:10
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1570159 2026-06-03 02:55:12 2026-08-09 13:01:50
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 87 2026-08-09 12:54:01.581779 2026-08-09 13:21:32.065367
neocp_events 331566 2026-08-09 12:54:01.694889 2026-08-09 12:54:01.694889
neocp_obs_archive 825447 2026-08-09 12:54:01.444659 2026-08-09 12:54:01.444659
neocp_obs 819 2026-08-09 12:54:01.403039 2026-08-09 12:54:01.403039
neocp_prev_des 73354 2026-08-09 11:54:58.992375 2026-08-09 11:54:58.992375
neocp_var 187390 2026-08-09 12:54:01.532797 2026-08-09 12:54:01.532797
current_identifications 2084842 2026-08-09 11:59:53.694582 2026-08-09 12:48:37.024647
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594669 2026-08-09 11:59:53.634459 2026-08-09 11:59:53.634459
obs_sbn 544971377 2026-08-09 08:38:45.248921-04 2026-08-09 08:48:17.539883-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 598650 2026-08-09 10:10:48.14625 2026-08-09 10:10:48.14625
mpc_orbits 1560240 2026-04-22 02:45:58.094556 2026-08-09 13:09:13.696061
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 544969871 2026-08-09 11:59:57.414943 2026-08-09 12:00:02.580835
MPC_mpcsbndb obs_sbn 544969871 2026-08-09 11:59:57.414943 2026-08-09 12:00:15.320963
SBN_to_AWS obs_sbn 544969871 2026-08-09 11:59:57.414943 2026-08-09 12:00:56.404475
MPC_primarydb current_identifications 2084842 2026-08-09 11:59:53.694582 2026-08-09 12:36:13.422676
MPC_mpcsbndb current_identifications 2084842 2026-08-09 11:59:53.694582 2026-08-09 12:36:14.435818
SBN_to_AWS current_identifications 2084842 2026-08-09 11:59:53.694582 2026-08-09 12:36:14.608068
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 12:36:15.37721
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 12:36:15.497421
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-09 12:36:15.5933
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 12:36:15.698492
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 12:36:15.86806
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-09 12:36:15.977475
MPC_primarydb mpc_orbits 1560239 2026-08-09 11:59:44.077356 2026-08-09 12:36:16.135596
MPC_mpcsbndb mpc_orbits 1560239 2026-08-09 11:59:44.077356 2026-08-09 12:36:18.728544
SBN_to_AWS mpc_orbits 1560239 2026-08-09 11:59:44.077356 2026-08-09 12:36:19.063302
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 12:36:22.848761
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 12:36:23.190077
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-09 12:36:23.335128
MPC_primarydb neocp_els 77 2026-08-09 12:28:11.093768 2026-08-09 12:36:23.628108
MPC_mpcsbndb neocp_els 77 2026-08-09 12:28:11.093768 2026-08-09 12:36:23.744184
SBN_to_AWS neocp_els 77 2026-08-09 12:28:11.093768 2026-08-09 12:36:23.838616
MPC_primarydb neocp_events 331546 2026-08-09 12:28:11.208115 2026-08-09 12:36:23.939715
MPC_mpcsbndb neocp_events 331546 2026-08-09 12:28:11.208115 2026-08-09 12:36:24.172792
SBN_to_AWS neocp_events 331546 2026-08-09 12:28:11.208115 2026-08-09 12:36:24.301198
MPC_primarydb neocp_obs 785 2026-08-09 12:28:10.912775 2026-08-09 12:36:24.466073
MPC_mpcsbndb neocp_obs 785 2026-08-09 12:28:10.912775 2026-08-09 12:36:24.583429
SBN_to_AWS neocp_obs 785 2026-08-09 12:28:10.912775 2026-08-09 12:36:24.678033
MPC_primarydb neocp_obs_archive 825413 2026-08-09 12:28:10.95473 2026-08-09 12:36:24.78302
MPC_mpcsbndb neocp_obs_archive 825413 2026-08-09 12:28:10.95473 2026-08-09 12:36:25.064831
SBN_to_AWS neocp_obs_archive 825413 2026-08-09 12:28:10.95473 2026-08-09 12:36:25.24133
MPC_primarydb neocp_prev_des 73354 2026-08-09 11:54:58.992375 2026-08-09 12:36:25.494149
MPC_mpcsbndb neocp_prev_des 73354 2026-08-09 11:54:58.992375 2026-08-09 12:36:25.647655
SBN_to_AWS neocp_prev_des 73354 2026-08-09 11:54:58.992375 2026-08-09 12:36:25.760502
MPC_primarydb neocp_var 167846 2026-08-09 12:28:11.045183 2026-08-09 12:36:25.889124
MPC_mpcsbndb neocp_var 167846 2026-08-09 12:28:11.045183 2026-08-09 12:36:26.079388
SBN_to_AWS neocp_var 167846 2026-08-09 12:28:11.045183 2026-08-09 12:36:26.203114
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 12:36:26.387279
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 12:36:26.536755
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-09 12:36:26.634754
MPC_primarydb primary_objects 1594669 2026-08-09 11:59:53.634459 2026-08-09 12:36:26.738446
MPC_mpcsbndb primary_objects 1594669 2026-08-09 11:59:53.634459 2026-08-09 12:36:27.281117
SBN_to_AWS primary_objects 1594669 2026-08-09 11:59:53.634459 2026-08-09 12:36:27.503965
MPC_primarydb obs_alterations_corrections 0 2026-08-09 12:36:29.118299
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-09 12:36:29.235354
SBN_to_AWS obs_alterations_corrections 0 2026-08-09 12:36:29.329223
MPC_primarydb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-09 12:36:29.427146
MPC_mpcsbndb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-09 12:36:30.242053
SBN_to_AWS obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-09 12:36:30.394272
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 12:36:30.691665
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 12:36:30.816231
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-09 12:36:30.914165
MPC_primarydb obs_alterations_unassociations 598650 2026-08-09 10:10:48.14625 2026-08-09 12:36:31.018507
MPC_mpcsbndb obs_alterations_unassociations 598650 2026-08-09 10:10:48.14625 2026-08-09 12:36:31.334582
SBN_to_AWS obs_alterations_unassociations 598650 2026-08-09 10:10:48.14625 2026-08-09 12:36:31.471627