Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

24 Apr 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-05-31 22: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 5206 2025-04-09 15:30:27 2025-04-09 15:30:27
comet_orbits 9978 2025-05-27 17:46:53 2025-05-27 18:01:03
identifications 206013 2025-05-22 12:15:03 2025-05-22 12:15:03
isolated_tracklets 48665604 2025-05-31 22:39:48 2025-05-31 22:39:48
mp_discoverers 1937677 2014-10-19 04:36:17 2025-01-30 01:06:24
numbered_comet_identifications 1087 2025-04-05 10:20:36 2025-04-05 10:20:36
numbered_identifications 1221099 2025-04-04 17:20:59 2025-04-04 17:20:59
numbered_mps 793066 2019-05-24 00:33:02 2025-05-28 16:38:01
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 478378272 2025-05-31 16:02:43 2025-05-31 16:02:43
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1467511 2020-08-13 23:47:11 2025-05-31 17:01:03
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 59 2025-05-30 13:14:04.017584 2025-05-31 21:48:22.673271
neocp_events 274882 2025-05-31 21:48:22.837119 2025-05-31 21:48:22.837119
neocp_obs_archive 698608 2025-05-31 21:48:22.669785 2025-05-31 21:48:22.669785
neocp_obs 457 2025-05-31 21:48:22.66186 2025-05-31 21:48:22.66186
neocp_prev_des 66169 2025-05-31 15:49:31.822312 2025-05-31 15:49:31.822312
neocp_var 115214 2025-05-31 21:48:22.708935 2025-05-31 21:48:22.708935
current_identifications 1976997 2025-05-31 20:24:52.555408 2025-05-31 20:25:41.197185
numbered_identifications 793862 2025-03-31 20:41:42.296919 2025-03-31 20:41:42.296919
primary_objects 1495449 2025-05-31 20:24:52.528296 2025-05-31 20:24:52.528296
obs_sbn 490733965 2025-05-31 12:06:32.364194-04 2025-05-31 18:48:55.791702-04
obs_alterations_deletions 1358318 2025-05-31 13:05:36.706633 2025-05-31 13:05:36.706633
obs_alterations_redesignations 4254 2025-05-27 01:34:46.695928 2025-05-27 01:34:46.695928
obs_alterations_unassociations 411561 2025-05-31 12:26:13.633907 2025-05-31 12:26:13.633907
mpc_orbits 1447925 2021-02-04 00:15:41.929432 2025-05-31 22:43:10.636706
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 490726414 2025-05-31 21:48:10.054925 2025-05-31 22:00:02.482285
MPC_mpcsbndb obs_sbn 490726414 2025-05-31 21:48:10.054925 2025-05-31 22:00:23.5298
SBN_to_AWS obs_sbn 490726414 2025-05-31 21:48:10.054925 2025-05-31 22:00:37.87887
MPC_primarydb current_identifications 1976997 2025-05-31 20:25:41.197185 2025-05-31 22:30:49.88774
MPC_mpcsbndb current_identifications 1976997 2025-05-31 20:25:41.197185 2025-05-31 22:30:50.535637
SBN_to_AWS current_identifications 1976997 2025-05-31 20:25:41.197185 2025-05-31 22:30:50.761521
MPC_primarydb mpc_orbits 1447925 2025-05-31 22:26:22.368259 2025-05-31 22:30:51.294448
MPC_mpcsbndb mpc_orbits 1447925 2025-05-31 22:26:22.368259 2025-05-31 22:30:52.675463
SBN_to_AWS mpc_orbits 1447925 2025-05-31 22:26:22.368259 2025-05-31 22:30:52.892281
MPC_primarydb numbered_identifications 793862 2025-03-31 20:41:42.296919 2025-05-31 22:30:53.941297
MPC_mpcsbndb numbered_identifications 793862 2025-03-31 20:41:42.296919 2025-05-31 22:30:54.274537
SBN_to_AWS numbered_identifications 793862 2025-03-31 20:41:42.296919 2025-05-31 22:30:54.404851
MPC_primarydb neocp_els 59 2025-05-31 21:48:22.673271 2025-05-31 22:30:54.551439
MPC_mpcsbndb neocp_els 59 2025-05-31 21:48:22.673271 2025-05-31 22:30:54.654387
SBN_to_AWS neocp_els 59 2025-05-31 21:48:22.673271 2025-05-31 22:30:54.741776
MPC_primarydb neocp_events 274882 2025-05-31 21:48:22.837119 2025-05-31 22:30:54.835359
MPC_mpcsbndb neocp_events 274882 2025-05-31 21:48:22.837119 2025-05-31 22:30:55.027501
SBN_to_AWS neocp_events 274882 2025-05-31 21:48:22.837119 2025-05-31 22:30:55.141112
MPC_primarydb neocp_obs 457 2025-05-31 21:48:22.66186 2025-05-31 22:30:55.261036
MPC_mpcsbndb neocp_obs 457 2025-05-31 21:48:22.66186 2025-05-31 22:30:55.363441
SBN_to_AWS neocp_obs 457 2025-05-31 21:48:22.66186 2025-05-31 22:30:55.451244
MPC_primarydb neocp_obs_archive 698608 2025-05-31 21:48:22.669785 2025-05-31 22:30:55.547257
MPC_mpcsbndb neocp_obs_archive 698608 2025-05-31 21:48:22.669785 2025-05-31 22:30:55.793344
SBN_to_AWS neocp_obs_archive 698608 2025-05-31 21:48:22.669785 2025-05-31 22:30:55.921302
MPC_primarydb neocp_prev_des 66169 2025-05-31 15:49:31.822312 2025-05-31 22:30:56.062669
MPC_mpcsbndb neocp_prev_des 66169 2025-05-31 15:49:31.822312 2025-05-31 22:30:56.192229
SBN_to_AWS neocp_prev_des 66169 2025-05-31 15:49:31.822312 2025-05-31 22:30:56.294139
MPC_primarydb neocp_var 115214 2025-05-31 21:48:22.708935 2025-05-31 22:30:56.401358
MPC_mpcsbndb neocp_var 115214 2025-05-31 21:48:22.708935 2025-05-31 22:30:56.554535
SBN_to_AWS neocp_var 115214 2025-05-31 21:48:22.708935 2025-05-31 22:30:56.6804
MPC_primarydb obscodes 2620 2025-05-28 16:17:07.34923 2025-05-31 22:30:56.808207
MPC_mpcsbndb obscodes 2620 2025-05-28 16:17:07.34923 2025-05-31 22:30:56.939455
SBN_to_AWS obscodes 2620 2025-05-28 16:17:07.34923 2025-05-31 22:30:57.027786
MPC_primarydb primary_objects 1495449 2025-05-31 20:24:52.528296 2025-05-31 22:30:57.121773
MPC_mpcsbndb primary_objects 1495449 2025-05-31 20:24:52.528296 2025-05-31 22:30:57.589994
SBN_to_AWS primary_objects 1495449 2025-05-31 20:24:52.528296 2025-05-31 22:30:57.74892
MPC_primarydb obs_alterations_corrections 0 2025-05-31 22:30:58.377266
MPC_mpcsbndb obs_alterations_corrections 0 2025-05-31 22:30:58.479457
SBN_to_AWS obs_alterations_corrections 0 2025-05-31 22:30:58.566408
MPC_primarydb obs_alterations_deletions 1358318 2025-05-31 13:05:36.706633 2025-05-31 22:30:58.657513
MPC_mpcsbndb obs_alterations_deletions 1358318 2025-05-31 13:05:36.706633 2025-05-31 22:30:59.147722
SBN_to_AWS obs_alterations_deletions 1358318 2025-05-31 13:05:36.706633 2025-05-31 22:30:59.274351