Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

23 Feb 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-03-12 15: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 5202 2017-03-15 16:46:33 2025-02-02 03:55:25
comet_orbits 9917 2025-02-07 23:25:28 2025-03-06 20:01:03
identifications 205015 2025-03-12 12:33:01 2025-03-12 12:33:01
isolated_tracklets 48362511 2025-03-12 14:56:50 2025-03-12 14:56:50
mp_discoverers 1937686 2014-10-19 04:36:17 2025-01-30 01:06:24
numbered_comet_identifications 1084 2025-02-24 11:40:13 2025-02-24 11:40:13
numbered_identifications 1199480 2025-02-07 17:43:41 2025-02-07 17:43:41
numbered_mps 773916 2025-02-07 19:44:28 2025-02-25 19:54:56
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 470529735 2025-03-12 15:49:15 2025-03-12 15:49:15
orbit_uncertainties 785438 2019-06-05 12:14:34 2024-12-03 08:16:15
orbits 1457082 2025-03-12 15:46:19 2025-03-12 15:46:19
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 35 2025-03-10 04:34:30.144394 2025-03-12 11:38:24.684198
neocp_events 266314 2025-03-12 15:46:19.495717 2025-03-12 15:46:19.495717
neocp_obs_archive 676854 2025-03-12 15:44:03.223739 2025-03-12 15:44:03.223739
neocp_obs 360 2025-03-12 11:26:45.683412 2025-03-12 11:26:45.683412
neocp_prev_des 65099 2025-03-12 15:46:19.464829 2025-03-12 15:46:19.464829
neocp_var 57034 2025-03-12 11:38:24.710154 2025-03-12 11:38:24.710154
current_identifications 1966876 2025-03-12 15:45:37.632038 2025-03-12 15:46:36.746323
numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-02-06 01:18:26.171581
primary_objects 1485816 2025-03-12 15:45:37.599775 2025-03-12 15:45:37.599775
obs_sbn 482915274 2025-03-06 05:41:12.51706-05 2025-03-12 11:56:23.143816-04
obs_alterations_deletions 1316366 2025-03-12 14:36:55.786459 2025-03-12 14:36:55.786459
obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-06 19:22:03.650961
obs_alterations_unassociations 376868 2025-03-12 14:37:25.709809 2025-03-12 14:37:25.709809
mpc_orbits 1435754 2025-03-12 15:45:59.494701 2025-03-12 15:45:59.494701
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 482915229 2025-03-12 14:57:43.722641 2025-03-12 15:00:01.685507
MPC_mpcsbndb obs_sbn 482915229 2025-03-12 14:57:43.722641 2025-03-12 15:00:13.808367
SBN_to_AWS obs_sbn 482915229 2025-03-12 14:57:43.722641 2025-03-12 15:00:48.399275
MPC_primarydb current_identifications 1966875 2025-03-12 12:33:54.934685 2025-03-12 15:01:22.401369
MPC_mpcsbndb current_identifications 1966875 2025-03-12 12:33:54.934685 2025-03-12 15:01:22.928937
SBN_to_AWS current_identifications 1966875 2025-03-12 12:33:54.934685 2025-03-12 15:01:23.129626
MPC_primarydb mpc_orbits 1435753 2025-03-12 14:54:42.366877 2025-03-12 15:01:23.385398
MPC_mpcsbndb mpc_orbits 1435753 2025-03-12 14:54:42.366877 2025-03-12 15:01:24.463724
SBN_to_AWS mpc_orbits 1435753 2025-03-12 14:54:42.366877 2025-03-12 15:01:24.762557
MPC_primarydb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-12 15:01:25.115282
MPC_mpcsbndb numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-12 15:01:25.426397
SBN_to_AWS numbered_identifications 774710 2025-02-06 01:18:26.171581 2025-03-12 15:01:25.572285
MPC_primarydb neocp_els 34 2025-03-12 11:38:24.684198 2025-03-12 15:01:25.792409
MPC_mpcsbndb neocp_els 34 2025-03-12 11:38:24.684198 2025-03-12 15:01:25.894764
SBN_to_AWS neocp_els 34 2025-03-12 11:38:24.684198 2025-03-12 15:01:25.977491
MPC_primarydb neocp_events 266312 2025-03-12 13:03:36.625769 2025-03-12 15:01:26.147734
MPC_mpcsbndb neocp_events 266312 2025-03-12 13:03:36.625769 2025-03-12 15:01:26.326876
SBN_to_AWS neocp_events 266312 2025-03-12 13:03:36.625769 2025-03-12 15:01:26.44276
MPC_primarydb neocp_obs 347 2025-03-12 11:26:45.683412 2025-03-12 15:01:26.639784
MPC_mpcsbndb neocp_obs 347 2025-03-12 11:26:45.683412 2025-03-12 15:01:26.744587
SBN_to_AWS neocp_obs 347 2025-03-12 11:26:45.683412 2025-03-12 15:01:26.827616
MPC_primarydb neocp_obs_archive 676851 2025-03-12 11:26:45.691561 2025-03-12 15:01:26.999402
MPC_mpcsbndb neocp_obs_archive 676851 2025-03-12 11:26:45.691561 2025-03-12 15:01:27.226536
SBN_to_AWS neocp_obs_archive 676851 2025-03-12 11:26:45.691561 2025-03-12 15:01:27.35405
MPC_primarydb neocp_prev_des 65098 2025-03-12 13:03:36.592872 2025-03-12 15:01:27.557871
MPC_mpcsbndb neocp_prev_des 65098 2025-03-12 13:03:36.592872 2025-03-12 15:01:27.699233
SBN_to_AWS neocp_prev_des 65098 2025-03-12 13:03:36.592872 2025-03-12 15:01:27.798489
MPC_primarydb neocp_var 55034 2025-03-12 11:38:24.710154 2025-03-12 15:01:27.984528
MPC_mpcsbndb neocp_var 55034 2025-03-12 11:38:24.710154 2025-03-12 15:01:28.126056
SBN_to_AWS neocp_var 55034 2025-03-12 11:38:24.710154 2025-03-12 15:01:28.234739
MPC_primarydb primary_objects 1485815 2025-03-12 11:47:25.459868 2025-03-12 15:01:28.424424
MPC_mpcsbndb primary_objects 1485815 2025-03-12 11:47:25.459868 2025-03-12 15:01:28.910209
SBN_to_AWS primary_objects 1485815 2025-03-12 11:47:25.459868 2025-03-12 15:01:29.107728
MPC_primarydb obs_alterations_corrections 0 2025-03-12 15:01:29.337068
MPC_mpcsbndb obs_alterations_corrections 0 2025-03-12 15:01:29.440617
SBN_to_AWS obs_alterations_corrections 0 2025-03-12 15:01:29.522562
MPC_primarydb obs_alterations_deletions 1316366 2025-03-12 14:36:55.786459 2025-03-12 15:01:29.694944
MPC_mpcsbndb obs_alterations_deletions 1316366 2025-03-12 14:36:55.786459 2025-03-12 15:01:30.144532
SBN_to_AWS obs_alterations_deletions 1316366 2025-03-12 14:36:55.786459 2025-03-12 15:01:30.271926
MPC_primarydb obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-12 15:01:30.482041
MPC_mpcsbndb obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-12 15:01:30.588661
SBN_to_AWS obs_alterations_redesignations 4208 2025-03-06 19:22:03.650961 2025-03-12 15:01:30.672641