a

Minor Planet Center Annex

@ SBN

 

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-21 20: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 12795 2026-08-19 21:33:14 2026-08-19 22:01:02
identifications 223187 2026-07-14 12:33:56 2026-07-14 12:33:56
isolated_tracklets 50789979 2026-08-18 19:48:20 2026-08-18 19:48:20
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-08-17 14:54:31
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 524426646 2026-08-21 17:08:10 2026-08-21 17:08:10
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1573540 2026-08-21 17:08:14 2026-08-21 18: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 50 2026-08-20 05:49:23.132223 2026-08-21 20:49:33.823378
neocp_events 333556 2026-08-21 20:49:33.816073 2026-08-21 20:49:33.816073
neocp_obs_archive 828597 2026-08-21 20:49:33.812455 2026-08-21 20:49:33.812455
neocp_obs 618 2026-08-21 20:49:33.804146 2026-08-21 20:49:33.804146
neocp_prev_des 73599 2026-08-21 19:05:26.297204 2026-08-21 19:05:26.297204
neocp_var 115504 2026-08-21 20:49:33.84754 2026-08-21 20:49:33.84754
current_identifications 2088315 2026-08-21 17:06:32.008365 2026-08-21 17:07:40.301159
numbered_identifications 896611 2026-06-02 22:27:20.380719 2026-06-03 16:22:06.978451
primary_objects 1597907 2026-08-21 17:06:31.962499 2026-08-21 17:06:31.962499
obs_sbn 546955325 2026-08-20 03:36:20.591573-04 2026-08-21 16:53:34.606748-04
obs_alterations_deletions 2123819 2026-08-21 20:38:48.449227 2026-08-21 20:38:48.449227
obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-12 19:41:29.142496
obs_alterations_unassociations 601362 2026-08-21 18:10:29.815107 2026-08-21 18:10:29.815107
mpc_orbits 1563616 2021-02-04 02:09:18.974812 2026-08-21 20:35:19.031233
minor_planet_names 26623 2024-08-15 18:31:11.706972 2026-08-17 18:54:31.231141
obscodes 2717 2026-08-14 19:43:59.64199 2026-08-14 19:43:59.64199
comet_names 4390 2026-08-19 21:28:36.239316 2026-08-19 21:28:36.239316
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 546917249 2026-08-21 19:53:08.754902 2026-08-21 20:00:02.424844
MPC_mpcsbndb obs_sbn 546917249 2026-08-21 19:53:08.754902 2026-08-21 20:00:56.024601
SBN_to_AWS obs_sbn 546917249 2026-08-21 19:53:08.754902 2026-08-21 20:01:35.015839
MPC_primarydb current_identifications 2088315 2026-08-21 17:07:40.301159 2026-08-21 20:16:32.044313
MPC_mpcsbndb current_identifications 2088315 2026-08-21 17:07:40.301159 2026-08-21 20:16:33.272815
SBN_to_AWS current_identifications 2088315 2026-08-21 17:07:40.301159 2026-08-21 20:16:33.44212
MPC_primarydb comet_names 4390 2026-08-19 21:28:36.239316 2026-08-21 20:16:33.639313
MPC_mpcsbndb comet_names 4390 2026-08-19 21:28:36.239316 2026-08-21 20:16:33.757357
SBN_to_AWS comet_names 4390 2026-08-19 21:28:36.239316 2026-08-21 20:16:33.834792
MPC_primarydb minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-08-21 20:16:33.914465
MPC_mpcsbndb minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-08-21 20:16:34.113419
SBN_to_AWS minor_planet_names 26623 2026-08-17 18:54:31.231141 2026-08-21 20:16:34.210084
MPC_primarydb mpc_orbits 1563616 2026-08-21 20:16:31.697744 2026-08-21 20:16:34.293504
MPC_mpcsbndb mpc_orbits 1563616 2026-08-21 20:16:33.986043 2026-08-21 20:16:36.816205
SBN_to_AWS mpc_orbits 1563616 2026-08-21 20:16:33.986043 2026-08-21 20:16:37.241102
MPC_primarydb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-21 20:16:37.71921
MPC_mpcsbndb numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-21 20:16:38.198151
SBN_to_AWS numbered_identifications 896611 2026-06-03 16:22:06.978451 2026-08-21 20:16:38.351992
MPC_primarydb neocp_els 50 2026-08-21 20:09:30.136185 2026-08-21 20:16:38.482611
MPC_mpcsbndb neocp_els 50 2026-08-21 20:09:30.136185 2026-08-21 20:16:38.604312
SBN_to_AWS neocp_els 50 2026-08-21 20:09:30.136185 2026-08-21 20:16:38.682196
MPC_primarydb neocp_events 333554 2026-08-21 20:09:30.11595 2026-08-21 20:16:38.760014
MPC_mpcsbndb neocp_events 333554 2026-08-21 20:09:30.11595 2026-08-21 20:16:38.992743
SBN_to_AWS neocp_events 333554 2026-08-21 20:09:30.11595 2026-08-21 20:16:39.119638
MPC_primarydb neocp_obs 614 2026-08-21 20:09:30.090593 2026-08-21 20:16:39.226694
MPC_mpcsbndb neocp_obs 614 2026-08-21 20:09:30.090593 2026-08-21 20:16:39.350944
SBN_to_AWS neocp_obs 614 2026-08-21 20:09:30.090593 2026-08-21 20:16:39.447245
MPC_primarydb neocp_obs_archive 828593 2026-08-21 20:09:30.106305 2026-08-21 20:16:39.525781
MPC_mpcsbndb neocp_obs_archive 828593 2026-08-21 20:09:30.106305 2026-08-21 20:16:39.848015
SBN_to_AWS neocp_obs_archive 828593 2026-08-21 20:09:30.106305 2026-08-21 20:16:39.983149
MPC_primarydb neocp_prev_des 73599 2026-08-21 19:05:26.297204 2026-08-21 20:16:40.116021
MPC_mpcsbndb neocp_prev_des 73599 2026-08-21 19:05:26.297204 2026-08-21 20:16:40.278997
SBN_to_AWS neocp_prev_des 73599 2026-08-21 19:05:26.297204 2026-08-21 20:16:40.369599
MPC_primarydb neocp_var 115504 2026-08-21 20:09:30.199141 2026-08-21 20:16:40.456033
MPC_mpcsbndb neocp_var 115504 2026-08-21 20:09:30.199141 2026-08-21 20:16:40.63055
SBN_to_AWS neocp_var 115504 2026-08-21 20:09:30.199141 2026-08-21 20:16:40.752175
MPC_primarydb obscodes 2717 2026-08-14 19:43:59.64199 2026-08-21 20:16:40.837699
MPC_mpcsbndb obscodes 2717 2026-08-14 19:43:59.64199 2026-08-21 20:16:40.972998
SBN_to_AWS obscodes 2717 2026-08-14 19:43:59.64199 2026-08-21 20:16:41.052138
MPC_primarydb primary_objects 1597907 2026-08-21 17:06:31.962499 2026-08-21 20:16:41.129888
MPC_mpcsbndb primary_objects 1597907 2026-08-21 17:06:31.962499 2026-08-21 20:16:42.182118
SBN_to_AWS primary_objects 1597907 2026-08-21 17:06:31.962499 2026-08-21 20:16:42.40273
MPC_primarydb obs_alterations_corrections 0 2026-08-21 20:16:42.58895
MPC_mpcsbndb obs_alterations_corrections 0 2026-08-21 20:16:42.695639
SBN_to_AWS obs_alterations_corrections 0 2026-08-21 20:16:42.770179
MPC_primarydb obs_alterations_deletions 2123758 2026-08-21 19:22:37.379469 2026-08-21 20:16:42.850365
MPC_mpcsbndb obs_alterations_deletions 2123758 2026-08-21 19:22:37.379469 2026-08-21 20:16:43.653702
SBN_to_AWS obs_alterations_deletions 2123758 2026-08-21 19:22:37.379469 2026-08-21 20:16:43.790518
MPC_primarydb obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-21 20:16:43.976853
MPC_mpcsbndb obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-21 20:16:44.096107
SBN_to_AWS obs_alterations_redesignations 5194 2026-08-12 19:41:29.142496 2026-08-21 20:16:44.172841
MPC_primarydb obs_alterations_unassociations 601362 2026-08-21 18:10:29.815107 2026-08-21 20:16:44.25251
MPC_mpcsbndb obs_alterations_unassociations 601362 2026-08-21 18:10:29.815107 2026-08-21 20:16:44.639358
SBN_to_AWS obs_alterations_unassociations 601362 2026-08-21 18:10:29.815107 2026-08-21 20:16:44.771884