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-10 10: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 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 50789808 2026-08-10 08:38:17 2026-08-10 08:38:17
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 524414814 2026-08-10 10:25:58 2026-08-10 10:25:58
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1570162 2023-08-22 11:48:29 2026-08-10 10:26: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 92 2026-08-10 08:11:34.825665 2026-08-10 09:44:18.256783
neocp_events 331705 2026-08-10 09:44:18.215485 2026-08-10 09:44:18.215485
neocp_obs_archive 825668 2026-08-10 09:44:18.174245 2026-08-10 09:44:18.174245
neocp_obs 940 2026-08-10 09:44:18.133387 2026-08-10 09:44:18.133387
neocp_prev_des 73366 2026-08-10 04:22:08.716339 2026-08-10 04:22:08.716339
neocp_var 196796 2026-08-10 09:44:18.346141 2026-08-10 09:44:18.346141
current_identifications 2085378 2026-08-10 10:42:48.11861 2026-08-10 10:43:26.168017
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1595205 2026-08-10 10:42:48.057795 2026-08-10 10:42:48.057795
obs_sbn 545098543 2017-07-09 20:00:00-04 2026-08-10 06:42:51.683628-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 599116 2026-08-10 10:10:20.798243 2026-08-10 10:10:20.798243
mpc_orbits 1560775 2026-08-10 10:43:39.135484 2026-08-10 10:43:47.289679
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 545098519 2026-08-10 09:57:58.454303 2026-08-10 10:00:02.151936
MPC_mpcsbndb obs_sbn 545098519 2026-08-10 09:57:58.454303 2026-08-10 10:00:14.831569
SBN_to_AWS obs_sbn 545098519 2026-08-10 09:57:58.454303 2026-08-10 10:00:54.41097
MPC_primarydb current_identifications 2085373 2026-08-10 10:36:13.740497 2026-08-10 10:36:16.692951
MPC_mpcsbndb current_identifications 2085373 2026-08-10 10:36:13.740497 2026-08-10 10:36:19.230994
SBN_to_AWS current_identifications 2085373 2026-08-10 10:36:13.740497 2026-08-10 10:36:19.40899
MPC_primarydb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 10:36:20.186605
MPC_mpcsbndb comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 10:36:20.303181
SBN_to_AWS comet_names 4389 2026-08-07 13:39:18.93276 2026-08-10 10:36:20.396462
MPC_primarydb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 10:36:20.499405
MPC_mpcsbndb minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 10:36:20.653561
SBN_to_AWS minor_planet_names 26594 2026-08-06 15:47:16.33429 2026-08-10 10:36:20.768562
MPC_primarydb mpc_orbits 1560769 2026-08-10 10:35:26.406782 2026-08-10 10:36:20.926515
MPC_mpcsbndb mpc_orbits 1560769 2026-08-10 10:35:26.406782 2026-08-10 10:36:22.589064
SBN_to_AWS mpc_orbits 1560769 2026-08-10 10:35:26.406782 2026-08-10 10:36:23.03748
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 10:36:26.839281
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 10:36:27.121444
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-10 10:36:27.277804
MPC_primarydb neocp_els 92 2026-08-10 09:44:18.256783 2026-08-10 10:36:27.576729
MPC_mpcsbndb neocp_els 92 2026-08-10 09:44:18.256783 2026-08-10 10:36:27.693369
SBN_to_AWS neocp_els 92 2026-08-10 09:44:18.256783 2026-08-10 10:36:27.784954
MPC_primarydb neocp_events 331705 2026-08-10 09:44:18.215485 2026-08-10 10:36:27.883507
MPC_mpcsbndb neocp_events 331705 2026-08-10 09:44:18.215485 2026-08-10 10:36:28.076999
SBN_to_AWS neocp_events 331705 2026-08-10 09:44:18.215485 2026-08-10 10:36:28.205195
MPC_primarydb neocp_obs 940 2026-08-10 09:44:18.133387 2026-08-10 10:36:28.365884
MPC_mpcsbndb neocp_obs 940 2026-08-10 09:44:18.133387 2026-08-10 10:36:28.480544
SBN_to_AWS neocp_obs 940 2026-08-10 09:44:18.133387 2026-08-10 10:36:28.572955
MPC_primarydb neocp_obs_archive 825668 2026-08-10 09:44:18.174245 2026-08-10 10:36:28.674327
MPC_mpcsbndb neocp_obs_archive 825668 2026-08-10 09:44:18.174245 2026-08-10 10:36:28.877189
SBN_to_AWS neocp_obs_archive 825668 2026-08-10 09:44:18.174245 2026-08-10 10:36:29.046942
MPC_primarydb neocp_prev_des 73366 2026-08-10 04:22:08.716339 2026-08-10 10:36:29.296306
MPC_mpcsbndb neocp_prev_des 73366 2026-08-10 04:22:08.716339 2026-08-10 10:36:29.442904
SBN_to_AWS neocp_prev_des 73366 2026-08-10 04:22:08.716339 2026-08-10 10:36:29.550133
MPC_primarydb neocp_var 196796 2026-08-10 09:44:18.346141 2026-08-10 10:36:29.680877
MPC_mpcsbndb neocp_var 196796 2026-08-10 09:44:18.346141 2026-08-10 10:36:29.869904
SBN_to_AWS neocp_var 196796 2026-08-10 09:44:18.346141 2026-08-10 10:36:30.001407
MPC_primarydb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 10:36:30.203146
MPC_mpcsbndb obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 10:36:30.333926
SBN_to_AWS obscodes 2715 2026-08-07 19:21:26.788283 2026-08-10 10:36:30.428362
MPC_primarydb primary_objects 1595200 2026-08-10 10:35:36.97452 2026-08-10 10:36:30.5283
MPC_mpcsbndb primary_objects 1595200 2026-08-10 10:35:36.97452 2026-08-10 10:36:30.991852
SBN_to_AWS primary_objects 1595200 2026-08-10 10:35:36.97452 2026-08-10 10:36:31.231755
MPC_primarydb obs_alterations_corrections 0 2026-08-10 10:36:32.86788
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-10 10:36:32.984414
SBN_to_AWS obs_alterations_corrections 0 2026-08-10 10:36:33.075289
MPC_primarydb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 10:36:33.170159
MPC_mpcsbndb obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 10:36:33.653569
SBN_to_AWS obs_alterations_deletions 1869921 2026-08-09 11:56:54.769066 2026-08-10 10:36:33.81056
MPC_primarydb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 10:36:34.097871
MPC_mpcsbndb obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 10:36:34.217227
SBN_to_AWS obs_alterations_redesignations 5137 2026-06-25 20:30:09.644732 2026-08-10 10:36:34.311939
MPC_primarydb obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 10:36:34.412829
MPC_mpcsbndb obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 10:36:34.670662
SBN_to_AWS obs_alterations_unassociations 599116 2026-08-10 10:10:20.798243 2026-08-10 10:36:34.807169