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-11 15: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 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 50789837 2026-08-11 14:48:15 2026-08-11 14:48:15
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 524416278 2026-08-11 13:59:56 2026-08-11 13:59:56
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1571116 2026-08-11 13:59:59 2026-08-11 14: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 111 2026-08-11 15:00:00.376753 2026-08-11 15:21:07.918867
neocp_events 331884 2026-08-11 15:19:37.594741 2026-08-11 15:19:37.594741
neocp_obs_archive 825944 2026-08-11 15:19:37.552912 2026-08-11 15:19:37.552912
neocp_obs 1026 2026-08-11 15:19:37.510878 2026-08-11 15:19:37.510878
neocp_prev_des 73379 2026-08-11 14:48:22.904823 2026-08-11 14:48:22.904823
neocp_var 234599 2026-08-11 15:19:37.728382 2026-08-11 15:19:37.728382
current_identifications 2085851 2026-08-11 15:32:36.946521 2026-08-11 15:32:36.946521
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1595678 2026-08-11 15:32:36.893443 2026-08-11 15:32:36.893443
obs_sbn 545422657 2017-09-28 15:37:18-04 2026-08-11 11:33:34.151155-04
obs_alterations_deletions 1946194 2026-08-11 02:22:19.365933 2026-08-11 02:22:19.365933
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 599528 2026-08-11 14:18:42.825239 2026-08-11 14:18:42.825239
mpc_orbits 1561246 2026-08-11 15:17:45.427261 2026-08-11 15:18:00.701823
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 545421274 2026-08-11 13:59:30.717165 2026-08-11 14:00:02.721357
MPC_mpcsbndb obs_sbn 545421274 2026-08-11 13:59:30.717165 2026-08-11 14:00:25.287703
SBN_to_AWS obs_sbn 545421274 2026-08-11 13:59:30.717165 2026-08-11 14:01:07.614568
MPC_primarydb current_identifications 2085819 2026-08-11 14:36:24.393037 2026-08-11 14:36:39.116388
MPC_mpcsbndb current_identifications 2085819 2026-08-11 14:36:24.393037 2026-08-11 14:36:40.073177
SBN_to_AWS current_identifications 2085819 2026-08-11 14:36:24.393037 2026-08-11 14:36:40.250098
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-11 14:36:41.024736
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-11 14:36:41.141197
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-11 14:36:41.240618
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-11 14:36:41.350346
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-11 14:36:41.51123
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-11 14:36:41.62544
MPC_primarydb mpc_orbits 1561214 2026-08-11 14:36:37.72861 2026-08-11 14:36:41.788416
MPC_mpcsbndb mpc_orbits 1561214 2026-08-11 14:36:37.72861 2026-08-11 14:36:43.514616
SBN_to_AWS mpc_orbits 1561214 2026-08-11 14:36:37.72861 2026-08-11 14:36:43.91809
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-11 14:36:47.069645
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-11 14:36:47.448261
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-11 14:36:47.598793
MPC_primarydb neocp_els 104 2026-08-11 14:35:13.977519 2026-08-11 14:36:47.906696
MPC_mpcsbndb neocp_els 104 2026-08-11 14:35:13.977519 2026-08-11 14:36:48.022797
SBN_to_AWS neocp_els 104 2026-08-11 14:35:13.977519 2026-08-11 14:36:48.121088
MPC_primarydb neocp_events 331859 2026-08-11 14:35:14.077988 2026-08-11 14:36:48.227247
MPC_mpcsbndb neocp_events 331859 2026-08-11 14:35:14.077988 2026-08-11 14:36:48.430841
SBN_to_AWS neocp_events 331859 2026-08-11 14:35:14.077988 2026-08-11 14:36:48.562119
MPC_primarydb neocp_obs 983 2026-08-11 14:35:13.8728 2026-08-11 14:36:48.73008
MPC_mpcsbndb neocp_obs 983 2026-08-11 14:35:13.8728 2026-08-11 14:36:48.847535
SBN_to_AWS neocp_obs 983 2026-08-11 14:35:13.8728 2026-08-11 14:36:48.946584
MPC_primarydb neocp_obs_archive 825898 2026-08-11 14:35:13.884761 2026-08-11 14:36:49.055508
MPC_mpcsbndb neocp_obs_archive 825898 2026-08-11 14:35:13.884761 2026-08-11 14:36:49.32592
SBN_to_AWS neocp_obs_archive 825898 2026-08-11 14:35:13.884761 2026-08-11 14:36:49.508529
MPC_primarydb neocp_prev_des 73377 2026-08-11 13:59:15.065756 2026-08-11 14:36:49.759408
MPC_mpcsbndb neocp_prev_des 73377 2026-08-11 13:59:15.065756 2026-08-11 14:36:49.91851
SBN_to_AWS neocp_prev_des 73377 2026-08-11 13:59:15.065756 2026-08-11 14:36:50.033294
MPC_primarydb neocp_var 220679 2026-08-11 14:35:13.93422 2026-08-11 14:36:50.165002
MPC_mpcsbndb neocp_var 220679 2026-08-11 14:35:13.93422 2026-08-11 14:36:50.359345
SBN_to_AWS neocp_var 220679 2026-08-11 14:35:13.93422 2026-08-11 14:36:50.494348
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-11 14:36:50.677734
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-11 14:36:50.813601
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-11 14:36:50.913154
MPC_primarydb primary_objects 1595646 2026-08-11 14:36:24.361948 2026-08-11 14:36:51.020424
MPC_mpcsbndb primary_objects 1595646 2026-08-11 14:36:24.361948 2026-08-11 14:36:51.531186
SBN_to_AWS primary_objects 1595646 2026-08-11 14:36:24.361948 2026-08-11 14:36:51.755859
MPC_primarydb obs_alterations_corrections 0 2026-08-11 14:36:53.422255
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-11 14:36:53.538477
SBN_to_AWS obs_alterations_corrections 0 2026-08-11 14:36:53.635383
MPC_primarydb obs_alterations_deletions 1946194 2026-08-11 02:22:19.365933 2026-08-11 14:36:53.735811
MPC_mpcsbndb obs_alterations_deletions 1946194 2026-08-11 02:22:19.365933 2026-08-11 14:36:54.396401
SBN_to_AWS obs_alterations_deletions 1946194 2026-08-11 02:22:19.365933 2026-08-11 14:36:54.56228
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-11 14:36:54.891787
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-11 14:36:55.0151
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-11 14:36:55.116315
MPC_primarydb obs_alterations_unassociations 599528 2026-08-11 14:18:42.825239 2026-08-11 14:36:55.223791
MPC_mpcsbndb obs_alterations_unassociations 599528 2026-08-11 14:18:42.825239 2026-08-11 14:36:55.524752
SBN_to_AWS obs_alterations_unassociations 599528 2026-08-11 14:18:42.825239 2026-08-11 14:36:55.668778