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-08 16:50: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 50789772 2026-08-08 15:18:50 2026-08-08 15:18:50
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 524414141 2026-08-08 15:49:44 2026-08-08 15:49:44
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1569868 2023-01-24 02:05:16 2026-08-08 16:01:04
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 63 2026-08-07 12:43:27.258351 2026-08-08 16:53:23.790931
neocp_events 331397 2026-08-08 16:53:23.749793 2026-08-08 16:53:23.749793
neocp_obs_archive 825154 2026-08-08 16:53:23.707566 2026-08-08 16:53:23.707566
neocp_obs 631 2026-08-08 16:53:23.701877 2026-08-08 16:53:23.701877
neocp_prev_des 73342 2026-08-08 16:46:01.171171 2026-08-08 16:46:01.171171
neocp_var 140956 2026-08-08 16:53:23.88189 2026-08-08 16:53:23.88189
current_identifications 2084597 2026-08-08 16:49:41.313474 2026-08-08 16:50:26.970605
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1594448 2026-08-08 16:49:41.264542 2026-08-08 16:49:41.264542
obs_sbn 544934528 2025-10-29 15:17:03.891013-04 2026-08-08 12:49:44.40021-04
obs_alterations_deletions 1869916 2026-08-07 21:21:10.21338 2026-08-07 21:21:10.21338
obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-06-25 20:30:09.644732
obs_alterations_unassociations 598393 2026-08-08 14:21:05.587988 2026-08-08 14:21:05.587988
mpc_orbits 1559999 2026-08-08 16:50:43.100656 2026-08-08 16:50:51.923059
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 544868369 2026-08-08 15:58:08.709525 2026-08-08 16:00:02.668036
MPC_mpcsbndb obs_sbn 544868369 2026-08-08 15:58:08.709525 2026-08-08 16:00:16.158195
SBN_to_AWS obs_sbn 544868372 2026-08-08 16:00:18.66979 2026-08-08 16:00:56.8291
MPC_primarydb current_identifications 2084594 2026-08-08 16:34:09.61135 2026-08-08 16:37:14.687517
MPC_mpcsbndb current_identifications 2084594 2026-08-08 16:34:09.61135 2026-08-08 16:37:17.526874
SBN_to_AWS current_identifications 2084594 2026-08-08 16:34:09.61135 2026-08-08 16:37:17.690329
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-08 16:37:18.460119
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-08 16:37:18.574769
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-08 16:37:18.666131
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-08 16:37:18.766485
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-08 16:37:18.926719
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-08 16:37:19.03309
MPC_primarydb mpc_orbits 1559996 2026-08-08 16:37:08.760346 2026-08-08 16:37:19.187799
MPC_mpcsbndb mpc_orbits 1559996 2026-08-08 16:37:08.760346 2026-08-08 16:37:21.091053
SBN_to_AWS mpc_orbits 1559996 2026-08-08 16:37:08.760346 2026-08-08 16:37:21.686367
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-08 16:37:24.793803
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-08 16:37:25.172432
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-08 16:37:25.311525
MPC_primarydb neocp_els 64 2026-08-08 16:29:25.519851 2026-08-08 16:37:25.619945
MPC_mpcsbndb neocp_els 64 2026-08-08 16:29:25.519851 2026-08-08 16:37:25.734448
SBN_to_AWS neocp_els 64 2026-08-08 16:29:25.519851 2026-08-08 16:37:25.82502
MPC_primarydb neocp_events 331387 2026-08-08 16:29:25.5081 2026-08-08 16:37:25.921609
MPC_mpcsbndb neocp_events 331387 2026-08-08 16:29:25.5081 2026-08-08 16:37:26.129728
SBN_to_AWS neocp_events 331387 2026-08-08 16:29:25.5081 2026-08-08 16:37:26.254197
MPC_primarydb neocp_obs 617 2026-08-08 16:29:25.462832 2026-08-08 16:37:26.415469
MPC_mpcsbndb neocp_obs 617 2026-08-08 16:29:25.462832 2026-08-08 16:37:26.529005
SBN_to_AWS neocp_obs 617 2026-08-08 16:29:25.462832 2026-08-08 16:37:26.620279
MPC_primarydb neocp_obs_archive 825136 2026-08-08 16:29:25.487964 2026-08-08 16:37:26.719793
MPC_mpcsbndb neocp_obs_archive 825136 2026-08-08 16:29:25.487964 2026-08-08 16:37:26.996844
SBN_to_AWS neocp_obs_archive 825136 2026-08-08 16:29:25.487964 2026-08-08 16:37:27.145833
MPC_primarydb neocp_prev_des 73341 2026-08-08 15:36:04.128252 2026-08-08 16:37:27.397755
MPC_mpcsbndb neocp_prev_des 73341 2026-08-08 15:36:04.128252 2026-08-08 16:37:27.551537
SBN_to_AWS neocp_prev_des 73341 2026-08-08 15:36:04.128252 2026-08-08 16:37:27.658764
MPC_primarydb neocp_var 142834 2026-08-08 16:29:25.585216 2026-08-08 16:37:27.780198
MPC_mpcsbndb neocp_var 142834 2026-08-08 16:29:25.585216 2026-08-08 16:37:27.952931
SBN_to_AWS neocp_var 142834 2026-08-08 16:29:25.585216 2026-08-08 16:37:28.07233
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-08 16:37:28.26233
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-08 16:37:28.404037
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-08 16:37:28.496782
MPC_primarydb primary_objects 1594445 2026-08-08 16:33:07.748747 2026-08-08 16:37:28.596868
MPC_mpcsbndb primary_objects 1594445 2026-08-08 16:33:07.748747 2026-08-08 16:37:29.106837
SBN_to_AWS primary_objects 1594445 2026-08-08 16:33:07.748747 2026-08-08 16:37:29.324386
MPC_primarydb obs_alterations_corrections 0 2026-08-08 16:37:30.987345
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-08 16:37:31.100269
SBN_to_AWS obs_alterations_corrections 0 2026-08-08 16:37:31.190103
MPC_primarydb obs_alterations_deletions 1869916 2026-08-07 21:21:10.21338 2026-08-08 16:37:31.283635
MPC_mpcsbndb obs_alterations_deletions 1869916 2026-08-07 21:21:10.21338 2026-08-08 16:37:31.948891
SBN_to_AWS obs_alterations_deletions 1869916 2026-08-07 21:21:10.21338 2026-08-08 16:37:32.089752
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-08 16:37:32.382495
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-08 16:37:32.502247
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-08 16:37:32.596101
MPC_primarydb obs_alterations_unassociations 598393 2026-08-08 14:21:05.587988 2026-08-08 16:37:32.695784
MPC_mpcsbndb obs_alterations_unassociations 598393 2026-08-08 14:21:05.587988 2026-08-08 16:37:33.008118
SBN_to_AWS obs_alterations_unassociations 598393 2026-08-08 14:21:05.587988 2026-08-08 16:37:33.140074