Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

18 Nov 2025

  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

2025-12-07 09:50:02 (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 5214 2025-10-23 17:12:59 2025-10-23 17:12:59
comet_orbits 11203 2025-12-06 01:39:24 2025-12-06 02:01:02
identifications 211181 2025-12-06 13:18:26 2025-12-06 13:18:26
isolated_tracklets 49564301 2025-12-07 02:18:20 2025-12-07 02:18:20
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1292 2025-10-23 16:03:49 2025-10-23 16:03:49
numbered_identifications 1319125 2025-10-22 17:46:28 2025-10-22 17:46:28
numbered_mps 875150 2025-10-23 01:12:51 2025-12-01 11:23:42
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 502402135 2025-12-06 22:14:52 2025-12-06 22:14:52
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1497221 2025-02-25 03:56:30 2025-12-06 23: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 43 2025-12-07 09:04:23.159695 2025-12-07 09:04:23.159695
neocp_events 300197 2025-12-07 09:04:23.273713 2025-12-07 09:04:23.273713
neocp_obs_archive 754600 2025-12-07 09:04:23.068883 2025-12-07 09:04:23.068883
neocp_obs 372 2025-12-07 09:04:23.027697 2025-12-07 09:04:23.027697
neocp_prev_des 69628 2025-12-06 18:47:24.624971 2025-12-06 18:47:24.624971
neocp_var 81333 2025-12-07 09:04:23.115776 2025-12-07 09:04:23.115776
current_identifications 2007713 2025-12-04 13:02:50.683166 2025-12-07 00:50:29.1527
numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-10-20 21:02:31.305341
primary_objects 1523657 2025-12-06 21:33:24.95052 2025-12-06 21:33:24.95052
obs_sbn 516226759 2025-12-05 15:30:23.701544-05 2025-12-07 04:20:16.825185-05
obs_alterations_deletions 1387773 2025-12-07 08:00:10.243867 2025-12-07 08:00:10.243867
obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2025-12-05 16:11:33.171335
obs_alterations_unassociations 526679 2025-12-07 07:33:12.558753 2025-12-07 07:33:12.558753
mpc_orbits 1479277 2021-02-03 23:51:43.532356 2025-12-07 09:18:56.197717
minor_planet_names 25905 2025-11-04 19:50:02.836296 2025-12-01 16:23:41.093411
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 516226453 2025-12-07 08:01:04.307865 2025-12-07 09:00:02.043986
MPC_mpcsbndb obs_sbn 516226453 2025-12-07 08:01:04.307865 2025-12-07 09:00:17.67333
SBN_to_AWS obs_sbn 516226453 2025-12-07 08:01:04.307865 2025-12-07 09:01:00.985243
MPC_primarydb current_identifications 2007713 2025-12-07 00:50:29.1527 2025-12-07 09:11:43.903665
MPC_mpcsbndb current_identifications 2007713 2025-12-07 00:50:29.1527 2025-12-07 09:11:44.570724
SBN_to_AWS current_identifications 2007713 2025-12-07 00:50:29.1527 2025-12-07 09:11:44.853304
MPC_primarydb minor_planet_names 25905 2025-12-01 16:23:41.093411 2025-12-07 09:11:45.386211
MPC_mpcsbndb minor_planet_names 25905 2025-12-01 16:23:41.093411 2025-12-07 09:11:45.53409
SBN_to_AWS minor_planet_names 25905 2025-12-01 16:23:41.093411 2025-12-07 09:11:45.63228
MPC_primarydb mpc_orbits 1479277 2025-12-07 08:01:21.736751 2025-12-07 09:11:45.730972
MPC_mpcsbndb mpc_orbits 1479277 2025-12-07 08:01:21.736751 2025-12-07 09:11:48.331619
SBN_to_AWS mpc_orbits 1479277 2025-12-07 08:01:21.736751 2025-12-07 09:11:48.630537
MPC_primarydb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-12-07 09:11:51.441431
MPC_mpcsbndb numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-12-07 09:11:51.782453
SBN_to_AWS numbered_identifications 875979 2025-10-20 21:02:31.305341 2025-12-07 09:11:51.921892
MPC_primarydb neocp_els 43 2025-12-07 09:04:23.159695 2025-12-07 09:11:52.066718
MPC_mpcsbndb neocp_els 43 2025-12-07 09:04:23.159695 2025-12-07 09:11:52.165197
SBN_to_AWS neocp_els 43 2025-12-07 09:04:23.159695 2025-12-07 09:11:52.246424
MPC_primarydb neocp_events 300197 2025-12-07 09:04:23.273713 2025-12-07 09:11:52.333719
MPC_mpcsbndb neocp_events 300197 2025-12-07 09:04:23.273713 2025-12-07 09:11:52.509284
SBN_to_AWS neocp_events 300197 2025-12-07 09:04:23.273713 2025-12-07 09:11:52.627386
MPC_primarydb neocp_obs 372 2025-12-07 09:04:23.027697 2025-12-07 09:11:52.74178
MPC_mpcsbndb neocp_obs 372 2025-12-07 09:04:23.027697 2025-12-07 09:11:52.842144
SBN_to_AWS neocp_obs 372 2025-12-07 09:04:23.027697 2025-12-07 09:11:52.924067
MPC_primarydb neocp_obs_archive 754600 2025-12-07 09:04:23.068883 2025-12-07 09:11:53.013125
MPC_mpcsbndb neocp_obs_archive 754600 2025-12-07 09:04:23.068883 2025-12-07 09:11:53.26576
SBN_to_AWS neocp_obs_archive 754600 2025-12-07 09:04:23.068883 2025-12-07 09:11:53.405634
MPC_primarydb neocp_prev_des 69628 2025-12-06 18:47:24.624971 2025-12-07 09:11:53.551115
MPC_mpcsbndb neocp_prev_des 69628 2025-12-06 18:47:24.624971 2025-12-07 09:11:53.684303
SBN_to_AWS neocp_prev_des 69628 2025-12-06 18:47:24.624971 2025-12-07 09:11:53.783982
MPC_primarydb neocp_var 81333 2025-12-07 09:04:23.115776 2025-12-07 09:11:53.88441
MPC_mpcsbndb neocp_var 81333 2025-12-07 09:04:23.115776 2025-12-07 09:11:54.030886
SBN_to_AWS neocp_var 81333 2025-12-07 09:04:23.115776 2025-12-07 09:11:54.142526
MPC_primarydb obscodes 2662 2025-12-05 13:40:40.122628 2025-12-07 09:11:54.277866
MPC_mpcsbndb obscodes 2662 2025-12-05 13:40:40.122628 2025-12-07 09:11:54.38972
SBN_to_AWS obscodes 2662 2025-12-05 13:40:40.122628 2025-12-07 09:11:54.473031
MPC_primarydb primary_objects 1523653 2025-12-06 21:33:24.95052 2025-12-07 09:11:54.561543
MPC_mpcsbndb primary_objects 1523653 2025-12-06 21:33:24.95052 2025-12-07 09:11:55.105341
SBN_to_AWS primary_objects 1523653 2025-12-06 21:33:24.95052 2025-12-07 09:11:55.312593
MPC_primarydb obs_alterations_corrections 0 2025-12-07 09:11:55.889647
MPC_mpcsbndb obs_alterations_corrections 0 2025-12-07 09:11:55.988858
SBN_to_AWS obs_alterations_corrections 0 2025-12-07 09:11:56.069498
MPC_primarydb obs_alterations_deletions 1387773 2025-12-07 08:00:10.243867 2025-12-07 09:11:56.154354
MPC_mpcsbndb obs_alterations_deletions 1387773 2025-12-07 08:00:10.243867 2025-12-07 09:11:56.655778
SBN_to_AWS obs_alterations_deletions 1387773 2025-12-07 08:00:10.243867 2025-12-07 09:11:56.785935
MPC_primarydb obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2025-12-07 09:11:56.935696
MPC_mpcsbndb obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2025-12-07 09:11:57.039887
SBN_to_AWS obs_alterations_redesignations 4476 2025-12-05 16:11:33.171335 2025-12-07 09:11:57.122653