add-forge-now mail gateway: does not update `Last Modified Date` column
After #5503 (closed) got fixed, the mails are going through to the AFN web interface but the mails aren't updating the Last Modified Date column, like they did previously.
AFNR#1161 is an example, the request was created on 22/04/2024, 10:22:27 pm and a mail was sent to it on 12/01/2025, 10:50:55 am but the AFNR listing says that the last modification date is 22/04/2024, 10:22:27 pm.
Please also update the affected AFNRs, I believe this should be the full list; 1011 1093 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1884
Activity
mentioned in issue #5529
assigned to @guillaume
After restoring a dump of
swh-webdatabase in a local environment, I checked where theadd_forge_request.last_modified_datemismatched theadd_forge_request_history.datelast row:afnr id 3 afnr last_modified_date 2022-09-27 13:22:39.639126+00 afnr history last entry date 2022-09-27 13:24:12.172802+00 afnr id 4 afnr last_modified_date 2022-09-27 05:10:13.204948+00 afnr history last entry date 2022-09-27 05:11:10.158724+00 afnr id 5 afnr last_modified_date 2022-09-27 05:12:04.970073+00 afnr history last entry date 2024-03-16 14:46:39.789268+00 afnr id 6 afnr last_modified_date 2022-09-27 05:07:42.006901+00 afnr history last entry date 2022-09-27 05:08:59.020819+00 afnr id 8 afnr last_modified_date 2022-09-27 05:02:07.314623+00 afnr history last entry date 2022-09-27 05:05:52.596075+00 afnr id 9 afnr last_modified_date 2022-09-27 05:14:08.660479+00 afnr history last entry date 2022-09-27 05:15:03.995474+00 afnr id 10 afnr last_modified_date 2022-09-27 05:16:00.283792+00 afnr history last entry date 2022-09-27 05:17:06.198063+00 afnr id 12 afnr last_modified_date 2022-09-21 07:32:09.461533+00 afnr history last entry date 2022-09-21 08:04:40.961482+00 afnr id 13 afnr last_modified_date 2022-11-03 08:32:13.565863+00 afnr history last entry date 2022-11-03 08:34:13.500579+00 afnr id 14 afnr last_modified_date 2022-11-13 11:46:31.13438+00 afnr history last entry date 2022-11-13 11:48:21.216576+00 afnr id 15 afnr last_modified_date 2022-11-13 11:50:34.860405+00 afnr history last entry date 2022-11-13 11:51:30.591015+00 afnr id 19 afnr last_modified_date 2023-01-03 12:42:01.066839+00 afnr history last entry date 2023-01-03 12:43:08.49925+00 afnr id 22 afnr last_modified_date 2023-01-05 11:26:49.533615+00 afnr history last entry date 2023-01-05 11:29:52.492734+00 afnr id 26 afnr last_modified_date 2022-11-29 08:33:13.16346+00 afnr history last entry date 2022-11-29 08:37:00.016066+00 afnr id 30 afnr last_modified_date 2023-07-06 07:16:13.534197+00 afnr history last entry date 2023-07-06 07:36:54.808891+00 afnr id 85 afnr last_modified_date 2023-06-02 13:36:39.771868+00 afnr history last entry date 2023-06-02 13:39:49.04823+00 afnr id 86 afnr last_modified_date 2023-10-30 22:55:28.558521+00 afnr history last entry date 2023-10-31 07:21:48.014111+00 afnr id 150 afnr last_modified_date 2023-10-03 01:24:16.200341+00 afnr history last entry date 2024-03-20 23:36:56.558245+00 afnr id 155 afnr last_modified_date 2023-10-16 09:44:35.223872+00 afnr history last entry date 2023-10-20 02:50:52.079865+00 afnr id 197 afnr last_modified_date 2023-10-11 00:51:48.727504+00 afnr history last entry date 2023-10-11 00:59:53.930628+00 afnr id 401 afnr last_modified_date 2024-02-13 10:14:13.422388+00 afnr history last entry date 2024-12-23 11:51:53.54379+00 afnr id 405 afnr last_modified_date 2024-02-28 01:09:51.689109+00 afnr history last entry date 2024-02-28 17:45:39.99305+00 afnr id 413 afnr last_modified_date 2024-02-28 01:10:20.634285+00 afnr history last entry date 2024-02-28 18:10:36.340583+00 afnr id 421 afnr last_modified_date 2023-11-29 02:45:25.38487+00 afnr history last entry date 2024-02-28 18:13:26.152373+00 afnr id 423 afnr last_modified_date 2024-02-27 02:27:16.102231+00 afnr history last entry date 2024-02-29 01:28:56.103903+00 afnr id 435 afnr last_modified_date 2024-03-01 00:40:51.49797+00 afnr history last entry date 2024-03-01 00:41:42.413965+00 afnr id 440 afnr last_modified_date 2024-01-06 20:37:00.966013+00 afnr history last entry date 2024-02-29 01:25:05.218873+00 afnr id 445 afnr last_modified_date 2024-02-28 09:27:42.636955+00 afnr history last entry date 2024-02-29 01:35:42.273777+00 afnr id 448 afnr last_modified_date 2024-04-07 03:06:17.484836+00 afnr history last entry date 2024-04-12 20:36:30.662676+00 afnr id 502 afnr last_modified_date 2024-03-07 08:54:36.913031+00 afnr history last entry date 2024-03-07 11:03:22.364778+00 afnr id 503 afnr last_modified_date 2024-02-29 10:20:44.19656+00 afnr history last entry date 2024-02-29 23:29:23.309462+00 afnr id 508 afnr last_modified_date 2024-03-01 00:15:53.266842+00 afnr history last entry date 2024-03-01 00:20:13.577791+00 afnr id 529 afnr last_modified_date 2023-12-13 05:28:22.519731+00 afnr history last entry date 2024-03-03 23:47:50.386873+00 afnr id 546 afnr last_modified_date 2024-04-28 17:57:24.982383+00 afnr history last entry date 2024-04-29 17:17:09.871459+00 afnr id 569 afnr last_modified_date 2024-01-12 22:33:37.918203+00 afnr history last entry date 2024-03-20 22:49:45.685332+00 afnr id 573 afnr last_modified_date 2024-01-12 22:45:26.786849+00 afnr history last entry date 2024-04-05 08:37:36.733895+00 afnr id 581 afnr last_modified_date 2024-01-12 23:26:51.979457+00 afnr history last entry date 2024-03-09 03:04:00.153191+00 afnr id 593 afnr last_modified_date 2024-03-12 10:17:55.43126+00 afnr history last entry date 2024-03-19 17:43:58.454383+00 afnr id 594 afnr last_modified_date 2024-01-26 15:38:40.094662+00 afnr history last entry date 2024-03-15 02:27:34.240262+00 afnr id 595 afnr last_modified_date 2024-03-11 03:05:28.282438+00 afnr history last entry date 2024-03-19 16:57:17.725932+00 afnr id 652 afnr last_modified_date 2024-01-27 16:31:05.808766+00 afnr history last entry date 2024-03-15 15:40:46.842694+00 afnr id 653 afnr last_modified_date 2024-01-27 16:34:20.780629+00 afnr history last entry date 2024-03-16 00:59:51.634042+00 afnr id 665 afnr last_modified_date 2024-03-16 03:04:25.274416+00 afnr history last entry date 2024-04-15 00:27:39.258581+00 afnr id 706 afnr last_modified_date 2024-03-21 23:14:03.380809+00 afnr history last entry date 2024-05-01 16:08:28.940648+00 afnr id 727 afnr last_modified_date 2024-02-06 03:27:45.147732+00 afnr history last entry date 2024-03-19 02:08:34.574379+00 afnr id 735 afnr last_modified_date 2024-02-06 03:57:59.115381+00 afnr history last entry date 2024-03-19 02:17:38.833779+00 afnr id 737 afnr last_modified_date 2024-02-06 04:03:26.263725+00 afnr history last entry date 2024-03-19 02:20:13.268732+00 afnr id 753 afnr last_modified_date 2024-02-08 06:21:49.037894+00 afnr history last entry date 2024-03-19 02:39:04.91103+00 afnr id 760 afnr last_modified_date 2024-02-08 07:18:43.739857+00 afnr history last entry date 2024-03-19 02:48:02.366168+00 afnr id 791 afnr last_modified_date 2024-03-23 05:38:46.86985+00 afnr history last entry date 2024-03-25 16:11:09.818907+00 afnr id 809 afnr last_modified_date 2024-02-18 03:55:49.069156+00 afnr history last entry date 2024-03-19 03:43:52.175326+00 afnr id 839 afnr last_modified_date 2024-03-21 23:14:39.831958+00 afnr history last entry date 2024-03-22 00:00:11.728311+00 afnr id 871 afnr last_modified_date 2024-03-02 05:03:52.500419+00 afnr history last entry date 2024-03-20 12:33:55.435768+00 afnr id 886 afnr last_modified_date 2024-03-26 01:08:29.292509+00 afnr history last entry date 2024-04-12 12:50:04.63484+00 afnr id 903 afnr last_modified_date 2024-03-28 02:21:46.475185+00 afnr history last entry date 2024-03-28 02:24:39.010786+00 afnr id 953 afnr last_modified_date 2024-06-11 07:59:26.308924+00 afnr history last entry date 2025-01-06 09:04:30.345279+00 afnr id 971 afnr last_modified_date 2024-04-11 01:08:26.765314+00 afnr history last entry date 2024-04-11 01:10:48.831598+00 afnr id 978 afnr last_modified_date 2024-04-11 02:09:08.473501+00 afnr history last entry date 2024-04-11 02:13:22.214867+00 afnr id 983 afnr last_modified_date 2024-04-22 03:27:54.638921+00 afnr history last entry date 2024-04-24 05:09:42.820412+00 afnr id 993 afnr last_modified_date 2024-04-15 01:00:34.288413+00 afnr history last entry date 2024-04-15 01:02:18.469521+00 afnr id 996 afnr last_modified_date 2024-04-16 11:58:57.595913+00 afnr history last entry date 2024-04-17 01:24:27.037214+00 afnr id 1011 afnr last_modified_date 2024-10-28 20:05:49.69171+00 afnr history last entry date 2024-12-24 04:41:53.342381+00 afnr id 1013 afnr last_modified_date 2024-04-18 02:21:26.645996+00 afnr history last entry date 2024-04-18 02:22:23.721075+00 afnr id 1015 afnr last_modified_date 2024-04-18 02:33:55.061858+00 afnr history last entry date 2024-04-18 07:43:10.182613+00 afnr id 1029 afnr last_modified_date 2024-04-19 12:45:39.628262+00 afnr history last entry date 2024-04-28 16:16:10.835195+00 afnr id 1033 afnr last_modified_date 2024-04-19 13:02:16.315156+00 afnr history last entry date 2024-04-23 16:24:59.435449+00 afnr id 1035 afnr last_modified_date 2024-04-19 13:10:13.367353+00 afnr history last entry date 2024-04-28 16:16:54.521765+00 afnr id 1038 afnr last_modified_date 2024-04-19 13:27:13.747596+00 afnr history last entry date 2024-04-23 01:03:53.685926+00 afnr id 1047 afnr last_modified_date 2024-04-19 13:59:24.489895+00 afnr history last entry date 2024-07-13 02:41:14.23169+00 afnr id 1058 afnr last_modified_date 2024-04-19 14:49:40.580556+00 afnr history last entry date 2024-04-23 02:04:59.942372+00 afnr id 1065 afnr last_modified_date 2024-04-19 15:09:30.347444+00 afnr history last entry date 2024-04-23 02:13:58.259894+00 afnr id 1068 afnr last_modified_date 2024-04-19 15:15:29.381034+00 afnr history last entry date 2024-04-23 18:55:32.340464+00 afnr id 1083 afnr last_modified_date 2024-04-22 07:56:22.166741+00 afnr history last entry date 2024-04-25 02:16:36.33281+00 afnr id 1097 afnr last_modified_date 2024-11-25 02:36:40.380391+00 afnr history last entry date 2024-11-25 02:44:32.198393+00 afnr id 1098 afnr last_modified_date 2024-11-25 02:47:15.555918+00 afnr history last entry date 2025-01-12 01:52:05.702355+00 afnr id 1099 afnr last_modified_date 2024-11-25 02:50:57.847522+00 afnr history last entry date 2024-11-25 02:52:34.351748+00 afnr id 1100 afnr last_modified_date 2024-11-25 02:55:08.585991+00 afnr history last entry date 2024-11-25 02:56:25.409659+00 afnr id 1101 afnr last_modified_date 2024-11-25 02:59:14.631381+00 afnr history last entry date 2024-11-25 03:00:55.58889+00 afnr id 1102 afnr last_modified_date 2024-11-25 03:03:21.123462+00 afnr history last entry date 2024-11-25 03:04:19.442864+00 afnr id 1103 afnr last_modified_date 2024-11-25 03:07:12.393444+00 afnr history last entry date 2024-11-25 03:10:02.759084+00 afnr id 1105 afnr last_modified_date 2024-04-22 10:10:44.463224+00 afnr history last entry date 2024-11-25 03:16:36.790376+00 afnr id 1106 afnr last_modified_date 2024-04-22 11:37:52.526392+00 afnr history last entry date 2024-11-25 03:19:42.941126+00 afnr id 1107 afnr last_modified_date 2024-04-22 11:39:08.814297+00 afnr history last entry date 2024-11-25 03:21:18.592373+00 afnr id 1108 afnr last_modified_date 2024-04-22 11:40:11.011371+00 afnr history last entry date 2024-11-25 03:25:29.817456+00 afnr id 1109 afnr last_modified_date 2024-04-22 11:41:23.108405+00 afnr history last entry date 2024-11-25 03:27:52.141327+00 afnr id 1111 afnr last_modified_date 2025-01-12 01:53:15.219376+00 afnr history last entry date 2025-01-12 01:53:40.19595+00 afnr id 1112 afnr last_modified_date 2025-01-12 01:54:14.380416+00 afnr history last entry date 2025-01-12 01:55:22.227212+00 afnr id 1113 afnr last_modified_date 2024-11-25 03:36:52.572338+00 afnr history last entry date 2024-11-25 03:37:29.002215+00 afnr id 1114 afnr last_modified_date 2024-06-02 08:04:54.984098+00 afnr history last entry date 2024-11-25 03:40:03.325665+00 afnr id 1115 afnr last_modified_date 2024-06-12 02:30:23.149107+00 afnr history last entry date 2024-11-25 03:43:04.004609+00 afnr id 1118 afnr last_modified_date 2024-11-27 02:10:27.099869+00 afnr history last entry date 2024-12-20 08:02:16.955264+00 afnr id 1119 afnr last_modified_date 2024-06-05 05:41:44.693953+00 afnr history last entry date 2024-11-25 03:56:08.935908+00 afnr id 1122 afnr last_modified_date 2024-04-22 11:54:25.59079+00 afnr history last entry date 2025-01-12 01:58:09.953342+00 afnr id 1123 afnr last_modified_date 2024-04-22 11:55:29.59689+00 afnr history last entry date 2025-01-12 14:33:48.665807+00 afnr id 1124 afnr last_modified_date 2024-06-05 06:54:49.976886+00 afnr history last entry date 2025-01-12 02:02:53.770981+00 afnr id 1125 afnr last_modified_date 2024-04-22 11:57:16.831275+00 afnr history last entry date 2025-01-12 02:04:29.525473+00 afnr id 1126 afnr last_modified_date 2024-04-22 11:58:36.65529+00 afnr history last entry date 2025-01-12 02:05:33.686908+00 afnr id 1127 afnr last_modified_date 2024-06-05 06:08:41.588478+00 afnr history last entry date 2025-01-12 02:09:01.629832+00 afnr id 1128 afnr last_modified_date 2024-06-05 06:14:53.946156+00 afnr history last entry date 2025-01-12 02:12:25.543358+00 afnr id 1129 afnr last_modified_date 2024-04-22 12:01:50.522737+00 afnr history last entry date 2025-01-12 01:18:48.977175+00 afnr id 1130 afnr last_modified_date 2024-04-22 12:02:50.525963+00 afnr history last entry date 2025-01-12 01:21:28.560418+00 afnr id 1131 afnr last_modified_date 2024-04-22 12:04:19.585173+00 afnr history last entry date 2025-01-12 01:24:51.17498+00 afnr id 1132 afnr last_modified_date 2024-04-22 12:05:41.064285+00 afnr history last entry date 2025-01-12 01:31:57.123402+00 afnr id 1133 afnr last_modified_date 2024-06-05 06:01:33.762215+00 afnr history last entry date 2025-01-12 01:38:24.663572+00 afnr id 1134 afnr last_modified_date 2024-04-22 12:08:21.660602+00 afnr history last entry date 2025-01-12 01:39:50.356447+00 afnr id 1135 afnr last_modified_date 2024-04-22 12:09:45.708244+00 afnr history last entry date 2025-01-12 01:40:48.58677+00 afnr id 1136 afnr last_modified_date 2024-04-22 12:10:54.413439+00 afnr history last entry date 2025-01-12 01:45:19.906542+00 afnr id 1137 afnr last_modified_date 2024-04-22 12:12:07.328305+00 afnr history last entry date 2025-01-12 01:46:49.369324+00 afnr id 1138 afnr last_modified_date 2024-04-22 12:13:31.723671+00 afnr history last entry date 2025-01-12 01:49:10.685528+00 afnr id 1139 afnr last_modified_date 2024-04-22 12:18:11.087974+00 afnr history last entry date 2025-01-12 02:15:53.949318+00 afnr id 1140 afnr last_modified_date 2024-04-22 12:19:07.436716+00 afnr history last entry date 2025-01-12 02:17:22.612986+00 afnr id 1141 afnr last_modified_date 2024-04-22 12:19:56.108254+00 afnr history last entry date 2025-01-12 02:18:25.308872+00 afnr id 1142 afnr last_modified_date 2024-04-22 12:20:47.829615+00 afnr history last entry date 2025-01-12 02:19:51.180746+00 afnr id 1143 afnr last_modified_date 2024-04-22 12:21:53.832176+00 afnr history last entry date 2025-01-12 02:19:46.24029+00 afnr id 1144 afnr last_modified_date 2024-04-22 12:22:25.78427+00 afnr history last entry date 2025-01-12 02:20:43.71346+00 afnr id 1145 afnr last_modified_date 2024-04-22 12:23:16.563252+00 afnr history last entry date 2025-01-12 02:27:25.659865+00 afnr id 1146 afnr last_modified_date 2024-04-22 12:24:07.875555+00 afnr history last entry date 2025-01-12 02:27:15.171715+00 afnr id 1147 afnr last_modified_date 2024-04-22 12:25:08.971752+00 afnr history last entry date 2025-01-12 02:28:02.155294+00 afnr id 1148 afnr last_modified_date 2024-04-22 13:50:34.610217+00 afnr history last entry date 2025-01-12 02:30:22.721715+00 afnr id 1149 afnr last_modified_date 2024-04-22 13:51:19.74559+00 afnr history last entry date 2025-01-12 02:30:51.688637+00 afnr id 1150 afnr last_modified_date 2024-04-22 13:51:51.918946+00 afnr history last entry date 2025-01-12 02:31:16.716868+00 afnr id 1151 afnr last_modified_date 2024-04-22 13:54:56.304748+00 afnr history last entry date 2025-01-12 02:32:36.216924+00 afnr id 1152 afnr last_modified_date 2024-04-22 13:55:30.681459+00 afnr history last entry date 2025-01-12 02:33:04.184257+00 afnr id 1153 afnr last_modified_date 2024-04-22 13:56:00.6101+00 afnr history last entry date 2025-01-12 02:35:52.793488+00 afnr id 1154 afnr last_modified_date 2024-04-22 13:58:16.433978+00 afnr history last entry date 2025-01-12 02:35:48.083179+00 afnr id 1155 afnr last_modified_date 2024-04-22 14:00:05.97719+00 afnr history last entry date 2025-01-12 02:37:34.844206+00 afnr id 1156 afnr last_modified_date 2024-04-22 14:02:07.389362+00 afnr history last entry date 2025-01-12 02:40:26.416071+00 afnr id 1157 afnr last_modified_date 2024-04-22 14:09:15.555546+00 afnr history last entry date 2025-01-12 02:42:41.928083+00 afnr id 1158 afnr last_modified_date 2024-04-22 14:12:02.497555+00 afnr history last entry date 2025-01-12 02:44:24.545638+00 afnr id 1159 afnr last_modified_date 2024-04-22 14:12:37.66195+00 afnr history last entry date 2025-01-12 02:46:38.791194+00 afnr id 1160 afnr last_modified_date 2024-04-22 14:16:16.506122+00 afnr history last entry date 2025-01-12 02:48:59.973391+00 afnr id 1161 afnr last_modified_date 2024-04-22 14:22:27.988144+00 afnr history last entry date 2025-01-12 02:50:55.267609+00 afnr id 1311 afnr last_modified_date 2024-06-25 01:56:41.304229+00 afnr history last entry date 2024-06-24 02:59:47.490099+00 afnr id 1616 afnr last_modified_date 2024-08-16 01:57:05.946558+00 afnr history last entry date 2025-01-12 05:50:07.422328+00 afnr id 1884 afnr last_modified_date 2025-01-09 23:17:54.361115+00 afnr history last entry date 2025-01-09 23:24:09.076435+00 I will script the
last_modified_dateupgrade and make some tests in local environment.upgrading
last_modified_datein a local docker environmentrestoring an
swh-webdb dumpᐅ dck ps NAME IMAGE COMMAND SERVICE CREATED STATUS PORTS check_afnr_dates-database-1 postgres:16.4-alpine "docker-entrypoint.s…" database About an hour ago Up About an hour 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp ᐅ dck cp pg_swh-web_20250116_154959.sql database:/ ᐅ dck exec -it database bash 733a2bed5ec2:/# su - postgres 733a2bed5ec2:~$ dropdb swh-web 733a2bed5ec2:~$ createdb swh-web 733a2bed5ec2:~$ psql swh-web < /pg_swh-web_20250116_154959.sql > /dev/null && echo "swh-web restored successfully" swh-web restored successfullyrun check and upgrade scripts
ᐅ ./check_afnr_date.sh > before_afnr_with_mismatched_dates.md ᐅ ./upgrade_afnr_date.sh > upgrade_afnr_last_modified_date.md ᐅ ./check_afnr_date.sh > after_afnr_with_mismatched_dates.mdresults
before_afnr_with_mismatched_dates.md
afnr id 3 afnr last_modified_date 20220927132239 afnr history last entry date 20220927132412 afnr id 4 afnr last_modified_date 20220927051013 afnr history last entry date 20220927051110 afnr id 5 afnr last_modified_date 20220927051204 afnr history last entry date 20240316144639 afnr id 6 afnr last_modified_date 20220927050742 afnr history last entry date 20220927050859 afnr id 8 afnr last_modified_date 20220927050207 afnr history last entry date 20220927050552 afnr id 9 afnr last_modified_date 20220927051408 afnr history last entry date 20220927051503 afnr id 10 afnr last_modified_date 20220927051600 afnr history last entry date 20220927051706 afnr id 12 afnr last_modified_date 20220921073209 afnr history last entry date 20220921080440 afnr id 13 afnr last_modified_date 20221103083213 afnr history last entry date 20221103083413 afnr id 14 afnr last_modified_date 20221113114631 afnr history last entry date 20221113114821 afnr id 15 afnr last_modified_date 20221113115034 afnr history last entry date 20221113115130 afnr id 19 afnr last_modified_date 20230103124201 afnr history last entry date 20230103124308 afnr id 22 afnr last_modified_date 20230105112649 afnr history last entry date 20230105112952 afnr id 26 afnr last_modified_date 20221129083313 afnr history last entry date 20221129083700 afnr id 30 afnr last_modified_date 20230706071613 afnr history last entry date 20230706073654 afnr id 85 afnr last_modified_date 20230602133639 afnr history last entry date 20230602133949 afnr id 86 afnr last_modified_date 20231030225528 afnr history last entry date 20231031072148 afnr id 150 afnr last_modified_date 20231003012416 afnr history last entry date 20240320233656 afnr id 155 afnr last_modified_date 20231016094435 afnr history last entry date 20231020025052 afnr id 197 afnr last_modified_date 20231011005148 afnr history last entry date 20231011005953 afnr id 401 afnr last_modified_date 20240213101413 afnr history last entry date 20241223115153 afnr id 405 afnr last_modified_date 20240228010951 afnr history last entry date 20240228174539 afnr id 413 afnr last_modified_date 20240228011020 afnr history last entry date 20240228181036 afnr id 421 afnr last_modified_date 20231129024525 afnr history last entry date 20240228181326 afnr id 423 afnr last_modified_date 20240227022716 afnr history last entry date 20240229012856 afnr id 435 afnr last_modified_date 20240301004051 afnr history last entry date 20240301004142 afnr id 440 afnr last_modified_date 20240106203700 afnr history last entry date 20240229012505 afnr id 445 afnr last_modified_date 20240228092742 afnr history last entry date 20240229013542 afnr id 448 afnr last_modified_date 20240407030617 afnr history last entry date 20240412203630 afnr id 502 afnr last_modified_date 20240307085436 afnr history last entry date 20240307110322 afnr id 503 afnr last_modified_date 20240229102044 afnr history last entry date 20240229232923 afnr id 508 afnr last_modified_date 20240301001553 afnr history last entry date 20240301002013 afnr id 529 afnr last_modified_date 20231213052822 afnr history last entry date 20240303234750 afnr id 546 afnr last_modified_date 20240428175724 afnr history last entry date 20240429171709 afnr id 569 afnr last_modified_date 20240112223337 afnr history last entry date 20240320224945 afnr id 573 afnr last_modified_date 20240112224526 afnr history last entry date 20240405083736 afnr id 581 afnr last_modified_date 20240112232651 afnr history last entry date 20240309030400 afnr id 593 afnr last_modified_date 20240312101755 afnr history last entry date 20240319174358 afnr id 594 afnr last_modified_date 20240126153840 afnr history last entry date 20240315022734 afnr id 595 afnr last_modified_date 20240311030528 afnr history last entry date 20240319165717 afnr id 652 afnr last_modified_date 20240127163105 afnr history last entry date 20240315154046 afnr id 653 afnr last_modified_date 20240127163420 afnr history last entry date 20240316005951 afnr id 665 afnr last_modified_date 20240316030425 afnr history last entry date 20240415002739 afnr id 706 afnr last_modified_date 20240321231403 afnr history last entry date 20240501160828 afnr id 727 afnr last_modified_date 20240206032745 afnr history last entry date 20240319020834 afnr id 735 afnr last_modified_date 20240206035759 afnr history last entry date 20240319021738 afnr id 737 afnr last_modified_date 20240206040326 afnr history last entry date 20240319022013 afnr id 753 afnr last_modified_date 20240208062149 afnr history last entry date 20240319023904 afnr id 760 afnr last_modified_date 20240208071843 afnr history last entry date 20240319024802 afnr id 791 afnr last_modified_date 20240323053846 afnr history last entry date 20240325161109 afnr id 809 afnr last_modified_date 20240218035549 afnr history last entry date 20240319034352 afnr id 839 afnr last_modified_date 20240321231439 afnr history last entry date 20240322000011 afnr id 871 afnr last_modified_date 20240302050352 afnr history last entry date 20240320123355 afnr id 886 afnr last_modified_date 20240326010829 afnr history last entry date 20240412125004 afnr id 903 afnr last_modified_date 20240328022146 afnr history last entry date 20240328022439 afnr id 953 afnr last_modified_date 20240611075926 afnr history last entry date 20250106090430 afnr id 971 afnr last_modified_date 20240411010826 afnr history last entry date 20240411011048 afnr id 978 afnr last_modified_date 20240411020908 afnr history last entry date 20240411021322 afnr id 983 afnr last_modified_date 20240422032754 afnr history last entry date 20240424050942 afnr id 993 afnr last_modified_date 20240415010034 afnr history last entry date 20240415010218 afnr id 996 afnr last_modified_date 20240416115857 afnr history last entry date 20240417012427 afnr id 1011 afnr last_modified_date 20241028200549 afnr history last entry date 20241224044153 afnr id 1013 afnr last_modified_date 20240418022126 afnr history last entry date 20240418022223 afnr id 1015 afnr last_modified_date 20240418023355 afnr history last entry date 20240418074310 afnr id 1029 afnr last_modified_date 20240419124539 afnr history last entry date 20240428161610 afnr id 1033 afnr last_modified_date 20240419130216 afnr history last entry date 20240423162459 afnr id 1035 afnr last_modified_date 20240419131013 afnr history last entry date 20240428161654 afnr id 1038 afnr last_modified_date 20240419132713 afnr history last entry date 20240423010353 afnr id 1047 afnr last_modified_date 20240419135924 afnr history last entry date 20240713024114 afnr id 1058 afnr last_modified_date 20240419144940 afnr history last entry date 20240423020459 afnr id 1065 afnr last_modified_date 20240419150930 afnr history last entry date 20240423021358 afnr id 1068 afnr last_modified_date 20240419151529 afnr history last entry date 20240423185532 afnr id 1083 afnr last_modified_date 20240422075622 afnr history last entry date 20240425021636 afnr id 1097 afnr last_modified_date 20241125023640 afnr history last entry date 20241125024432 afnr id 1098 afnr last_modified_date 20241125024715 afnr history last entry date 20250112015205 afnr id 1099 afnr last_modified_date 20241125025057 afnr history last entry date 20241125025234 afnr id 1100 afnr last_modified_date 20241125025508 afnr history last entry date 20241125025625 afnr id 1101 afnr last_modified_date 20241125025914 afnr history last entry date 20241125030055 afnr id 1102 afnr last_modified_date 20241125030321 afnr history last entry date 20241125030419 afnr id 1103 afnr last_modified_date 20241125030712 afnr history last entry date 20241125031002 afnr id 1105 afnr last_modified_date 20240422101044 afnr history last entry date 20241125031636 afnr id 1106 afnr last_modified_date 20240422113752 afnr history last entry date 20241125031942 afnr id 1107 afnr last_modified_date 20240422113908 afnr history last entry date 20241125032118 afnr id 1108 afnr last_modified_date 20240422114011 afnr history last entry date 20241125032529 afnr id 1109 afnr last_modified_date 20240422114123 afnr history last entry date 20241125032752 afnr id 1111 afnr last_modified_date 20250112015315 afnr history last entry date 20250112015340 afnr id 1112 afnr last_modified_date 20250112015414 afnr history last entry date 20250112015522 afnr id 1113 afnr last_modified_date 20241125033652 afnr history last entry date 20241125033729 afnr id 1114 afnr last_modified_date 20240602080454 afnr history last entry date 20241125034003 afnr id 1115 afnr last_modified_date 20240612023023 afnr history last entry date 20241125034304 afnr id 1118 afnr last_modified_date 20241127021027 afnr history last entry date 20241220080216 afnr id 1119 afnr last_modified_date 20240605054144 afnr history last entry date 20241125035608 afnr id 1122 afnr last_modified_date 20240422115425 afnr history last entry date 20250112015809 afnr id 1123 afnr last_modified_date 20240422115529 afnr history last entry date 20250112143348 afnr id 1124 afnr last_modified_date 20240605065449 afnr history last entry date 20250112020253 afnr id 1125 afnr last_modified_date 20240422115716 afnr history last entry date 20250112020429 afnr id 1126 afnr last_modified_date 20240422115836 afnr history last entry date 20250112020533 afnr id 1127 afnr last_modified_date 20240605060841 afnr history last entry date 20250112020901 afnr id 1128 afnr last_modified_date 20240605061453 afnr history last entry date 20250112021225 afnr id 1129 afnr last_modified_date 20240422120150 afnr history last entry date 20250112011848 afnr id 1130 afnr last_modified_date 20240422120250 afnr history last entry date 20250112012128 afnr id 1131 afnr last_modified_date 20240422120419 afnr history last entry date 20250112012451 afnr id 1132 afnr last_modified_date 20240422120541 afnr history last entry date 20250112013157 afnr id 1133 afnr last_modified_date 20240605060133 afnr history last entry date 20250112013824 afnr id 1134 afnr last_modified_date 20240422120821 afnr history last entry date 20250112013950 afnr id 1135 afnr last_modified_date 20240422120945 afnr history last entry date 20250112014048 afnr id 1136 afnr last_modified_date 20240422121054 afnr history last entry date 20250112014519 afnr id 1137 afnr last_modified_date 20240422121207 afnr history last entry date 20250112014649 afnr id 1138 afnr last_modified_date 20240422121331 afnr history last entry date 20250112014910 afnr id 1139 afnr last_modified_date 20240422121811 afnr history last entry date 20250112021553 afnr id 1140 afnr last_modified_date 20240422121907 afnr history last entry date 20250112021722 afnr id 1141 afnr last_modified_date 20240422121956 afnr history last entry date 20250112021825 afnr id 1142 afnr last_modified_date 20240422122047 afnr history last entry date 20250112021951 afnr id 1143 afnr last_modified_date 20240422122153 afnr history last entry date 20250112021946 afnr id 1144 afnr last_modified_date 20240422122225 afnr history last entry date 20250112022043 afnr id 1145 afnr last_modified_date 20240422122316 afnr history last entry date 20250112022725 afnr id 1146 afnr last_modified_date 20240422122407 afnr history last entry date 20250112022715 afnr id 1147 afnr last_modified_date 20240422122508 afnr history last entry date 20250112022802 afnr id 1148 afnr last_modified_date 20240422135034 afnr history last entry date 20250112023022 afnr id 1149 afnr last_modified_date 20240422135119 afnr history last entry date 20250112023051 afnr id 1150 afnr last_modified_date 20240422135151 afnr history last entry date 20250112023116 afnr id 1151 afnr last_modified_date 20240422135456 afnr history last entry date 20250112023236 afnr id 1152 afnr last_modified_date 20240422135530 afnr history last entry date 20250112023304 afnr id 1153 afnr last_modified_date 20240422135600 afnr history last entry date 20250112023552 afnr id 1154 afnr last_modified_date 20240422135816 afnr history last entry date 20250112023548 afnr id 1155 afnr last_modified_date 20240422140005 afnr history last entry date 20250112023734 afnr id 1156 afnr last_modified_date 20240422140207 afnr history last entry date 20250112024026 afnr id 1157 afnr last_modified_date 20240422140915 afnr history last entry date 20250112024241 afnr id 1158 afnr last_modified_date 20240422141202 afnr history last entry date 20250112024424 afnr id 1159 afnr last_modified_date 20240422141237 afnr history last entry date 20250112024638 afnr id 1160 afnr last_modified_date 20240422141616 afnr history last entry date 20250112024859 afnr id 1161 afnr last_modified_date 20240422142227 afnr history last entry date 20250112025055 afnr id 1311 afnr last_modified_date 20240625015641 afnr history last entry date 20240624025947 afnr id 1616 afnr last_modified_date 20240816015705 afnr history last entry date 20250112055007 upgrade_afnr_last_modified_date.md
afnr_id 3 afn_check_date 20220927132412 update_msg UPDATE 1 afnr_id 4 afn_check_date 20220927051110 update_msg UPDATE 1 afnr_id 5 afn_check_date 20240316144639 update_msg UPDATE 1 afnr_id 6 afn_check_date 20220927050859 update_msg UPDATE 1 afnr_id 8 afn_check_date 20220927050552 update_msg UPDATE 1 afnr_id 9 afn_check_date 20220927051503 update_msg UPDATE 1 afnr_id 10 afn_check_date 20220927051706 update_msg UPDATE 1 afnr_id 12 afn_check_date 20220921080440 update_msg UPDATE 1 afnr_id 13 afn_check_date 20221103083413 update_msg UPDATE 1 afnr_id 14 afn_check_date 20221113114821 update_msg UPDATE 1 afnr_id 15 afn_check_date 20221113115130 update_msg UPDATE 1 afnr_id 19 afn_check_date 20230103124308 update_msg UPDATE 1 afnr_id 22 afn_check_date 20230105112952 update_msg UPDATE 1 afnr_id 26 afn_check_date 20221129083700 update_msg UPDATE 1 afnr_id 30 afn_check_date 20230706073654 update_msg UPDATE 1 afnr_id 85 afn_check_date 20230602133949 update_msg UPDATE 1 afnr_id 86 afn_check_date 20231031072148 update_msg UPDATE 1 afnr_id 150 afn_check_date 20240320233656 update_msg UPDATE 1 afnr_id 155 afn_check_date 20231020025052 update_msg UPDATE 1 afnr_id 197 afn_check_date 20231011005953 update_msg UPDATE 1 afnr_id 401 afn_check_date 20241223115153 update_msg UPDATE 1 afnr_id 405 afn_check_date 20240228174539 update_msg UPDATE 1 afnr_id 413 afn_check_date 20240228181036 update_msg UPDATE 1 afnr_id 421 afn_check_date 20240228181326 update_msg UPDATE 1 afnr_id 423 afn_check_date 20240229012856 update_msg UPDATE 1 afnr_id 435 afn_check_date 20240301004142 update_msg UPDATE 1 afnr_id 440 afn_check_date 20240229012505 update_msg UPDATE 1 afnr_id 445 afn_check_date 20240229013542 update_msg UPDATE 1 afnr_id 448 afn_check_date 20240412203630 update_msg UPDATE 1 afnr_id 502 afn_check_date 20240307110322 update_msg UPDATE 1 afnr_id 503 afn_check_date 20240229232923 update_msg UPDATE 1 afnr_id 508 afn_check_date 20240301002013 update_msg UPDATE 1 afnr_id 529 afn_check_date 20240303234750 update_msg UPDATE 1 afnr_id 546 afn_check_date 20240429171709 update_msg UPDATE 1 afnr_id 569 afn_check_date 20240320224945 update_msg UPDATE 1 afnr_id 573 afn_check_date 20240405083736 update_msg UPDATE 1 afnr_id 581 afn_check_date 20240309030400 update_msg UPDATE 1 afnr_id 593 afn_check_date 20240319174358 update_msg UPDATE 1 afnr_id 594 afn_check_date 20240315022734 update_msg UPDATE 1 afnr_id 595 afn_check_date 20240319165717 update_msg UPDATE 1 afnr_id 652 afn_check_date 20240315154046 update_msg UPDATE 1 afnr_id 653 afn_check_date 20240316005951 update_msg UPDATE 1 afnr_id 665 afn_check_date 20240415002739 update_msg UPDATE 1 afnr_id 706 afn_check_date 20240501160828 update_msg UPDATE 1 afnr_id 727 afn_check_date 20240319020834 update_msg UPDATE 1 afnr_id 735 afn_check_date 20240319021738 update_msg UPDATE 1 afnr_id 737 afn_check_date 20240319022013 update_msg UPDATE 1 afnr_id 753 afn_check_date 20240319023904 update_msg UPDATE 1 afnr_id 760 afn_check_date 20240319024802 update_msg UPDATE 1 afnr_id 791 afn_check_date 20240325161109 update_msg UPDATE 1 afnr_id 809 afn_check_date 20240319034352 update_msg UPDATE 1 afnr_id 839 afn_check_date 20240322000011 update_msg UPDATE 1 afnr_id 871 afn_check_date 20240320123355 update_msg UPDATE 1 afnr_id 886 afn_check_date 20240412125004 update_msg UPDATE 1 afnr_id 903 afn_check_date 20240328022439 update_msg UPDATE 1 afnr_id 953 afn_check_date 20250106090430 update_msg UPDATE 1 afnr_id 971 afn_check_date 20240411011048 update_msg UPDATE 1 afnr_id 978 afn_check_date 20240411021322 update_msg UPDATE 1 afnr_id 983 afn_check_date 20240424050942 update_msg UPDATE 1 afnr_id 993 afn_check_date 20240415010218 update_msg UPDATE 1 afnr_id 996 afn_check_date 20240417012427 update_msg UPDATE 1 afnr_id 1011 afn_check_date 20241224044153 update_msg UPDATE 1 afnr_id 1013 afn_check_date 20240418022223 update_msg UPDATE 1 afnr_id 1015 afn_check_date 20240418074310 update_msg UPDATE 1 afnr_id 1029 afn_check_date 20240428161610 update_msg UPDATE 1 afnr_id 1033 afn_check_date 20240423162459 update_msg UPDATE 1 afnr_id 1035 afn_check_date 20240428161654 update_msg UPDATE 1 afnr_id 1038 afn_check_date 20240423010353 update_msg UPDATE 1 afnr_id 1047 afn_check_date 20240713024114 update_msg UPDATE 1 afnr_id 1058 afn_check_date 20240423020459 update_msg UPDATE 1 afnr_id 1065 afn_check_date 20240423021358 update_msg UPDATE 1 afnr_id 1068 afn_check_date 20240423185532 update_msg UPDATE 1 afnr_id 1083 afn_check_date 20240425021636 update_msg UPDATE 1 afnr_id 1097 afn_check_date 20241125024432 update_msg UPDATE 1 afnr_id 1098 afn_check_date 20250112015205 update_msg UPDATE 1 afnr_id 1099 afn_check_date 20241125025234 update_msg UPDATE 1 afnr_id 1100 afn_check_date 20241125025625 update_msg UPDATE 1 afnr_id 1101 afn_check_date 20241125030055 update_msg UPDATE 1 afnr_id 1102 afn_check_date 20241125030419 update_msg UPDATE 1 afnr_id 1103 afn_check_date 20241125031002 update_msg UPDATE 1 afnr_id 1105 afn_check_date 20241125031636 update_msg UPDATE 1 afnr_id 1106 afn_check_date 20241125031942 update_msg UPDATE 1 afnr_id 1107 afn_check_date 20241125032118 update_msg UPDATE 1 afnr_id 1108 afn_check_date 20241125032529 update_msg UPDATE 1 afnr_id 1109 afn_check_date 20241125032752 update_msg UPDATE 1 afnr_id 1111 afn_check_date 20250112015340 update_msg UPDATE 1 afnr_id 1112 afn_check_date 20250112015522 update_msg UPDATE 1 afnr_id 1113 afn_check_date 20241125033729 update_msg UPDATE 1 afnr_id 1114 afn_check_date 20241125034003 update_msg UPDATE 1 afnr_id 1115 afn_check_date 20241125034304 update_msg UPDATE 1 afnr_id 1118 afn_check_date 20241220080216 update_msg UPDATE 1 afnr_id 1119 afn_check_date 20241125035608 update_msg UPDATE 1 afnr_id 1122 afn_check_date 20250112015809 update_msg UPDATE 1 afnr_id 1123 afn_check_date 20250112143348 update_msg UPDATE 1 afnr_id 1124 afn_check_date 20250112020253 update_msg UPDATE 1 afnr_id 1125 afn_check_date 20250112020429 update_msg UPDATE 1 afnr_id 1126 afn_check_date 20250112020533 update_msg UPDATE 1 afnr_id 1127 afn_check_date 20250112020901 update_msg UPDATE 1 afnr_id 1128 afn_check_date 20250112021225 update_msg UPDATE 1 afnr_id 1129 afn_check_date 20250112011848 update_msg UPDATE 1 afnr_id 1130 afn_check_date 20250112012128 update_msg UPDATE 1 afnr_id 1131 afn_check_date 20250112012451 update_msg UPDATE 1 afnr_id 1132 afn_check_date 20250112013157 update_msg UPDATE 1 afnr_id 1133 afn_check_date 20250112013824 update_msg UPDATE 1 afnr_id 1134 afn_check_date 20250112013950 update_msg UPDATE 1 afnr_id 1135 afn_check_date 20250112014048 update_msg UPDATE 1 afnr_id 1136 afn_check_date 20250112014519 update_msg UPDATE 1 afnr_id 1137 afn_check_date 20250112014649 update_msg UPDATE 1 afnr_id 1138 afn_check_date 20250112014910 update_msg UPDATE 1 afnr_id 1139 afn_check_date 20250112021553 update_msg UPDATE 1 afnr_id 1140 afn_check_date 20250112021722 update_msg UPDATE 1 afnr_id 1141 afn_check_date 20250112021825 update_msg UPDATE 1 afnr_id 1142 afn_check_date 20250112021951 update_msg UPDATE 1 afnr_id 1143 afn_check_date 20250112021946 update_msg UPDATE 1 afnr_id 1144 afn_check_date 20250112022043 update_msg UPDATE 1 afnr_id 1145 afn_check_date 20250112022725 update_msg UPDATE 1 afnr_id 1146 afn_check_date 20250112022715 update_msg UPDATE 1 afnr_id 1147 afn_check_date 20250112022802 update_msg UPDATE 1 afnr_id 1148 afn_check_date 20250112023022 update_msg UPDATE 1 afnr_id 1149 afn_check_date 20250112023051 update_msg UPDATE 1 afnr_id 1150 afn_check_date 20250112023116 update_msg UPDATE 1 afnr_id 1151 afn_check_date 20250112023236 update_msg UPDATE 1 afnr_id 1152 afn_check_date 20250112023304 update_msg UPDATE 1 afnr_id 1153 afn_check_date 20250112023552 update_msg UPDATE 1 afnr_id 1154 afn_check_date 20250112023548 update_msg UPDATE 1 afnr_id 1155 afn_check_date 20250112023734 update_msg UPDATE 1 afnr_id 1156 afn_check_date 20250112024026 update_msg UPDATE 1 afnr_id 1157 afn_check_date 20250112024241 update_msg UPDATE 1 afnr_id 1158 afn_check_date 20250112024424 update_msg UPDATE 1 afnr_id 1159 afn_check_date 20250112024638 update_msg UPDATE 1 afnr_id 1160 afn_check_date 20250112024859 update_msg UPDATE 1 afnr_id 1161 afn_check_date 20250112025055 update_msg UPDATE 1 afnr_id 1311 houston we have a problem afnr_id 1616 afn_check_date 20250112055007 update_msg UPDATE 1 after_afnr_with_mismatched_dates.md
afnr id 1311 afnr last_modified_date 20240625015641 afnr history last entry date 20240624025947 It seems the last row of
add_forge_request_historytable for this id is one day less than thelast-modified_date.scripts
check_afnr_date.sh
ᐅ cat check_afnr_date.sh | sed "s/\($PASS\|$USER\)/xxx/g" #!/usr/bin/env bash # vim: ai ts=2 sts=2 sw=2 typeset -r WEB_PG_ARGS="host=localhost user=xxx password=xxx dbname=xxx" AFNR_ID=$(psql -d "$WEB_PG_ARGS" -c 'select id from add_forge_request order by id;' -At) typeset -r AFNR_ID for afnr_id in $AFNR_ID do afn_date=$(psql -d "$WEB_PG_ARGS" \ -c "select last_modified_date from add_forge_request where id = ${afnr_id};" \ -At | awk -F "." '{gsub("[:-]| ","",$0);print $1}') afn_history_last_date=$(psql -d "$WEB_PG_ARGS" \ -c "select date from add_forge_request_history where request_id = ${afnr_id} order by date desc limit 1;" \ -At | awk -F "." '{gsub("[:-]| ","",$0);print $1}') if [[ "$afn_date" -ne "$afn_history_last_date" ]] then printf "| afnr id | %s |\n" "$afnr_id" printf "|---|---|\n" printf "| afnr last_modified_date | %s |\n" "$afn_date" printf "| afnr history last entry date | %s |\n\n" "$afn_history_last_date" fi doneupgrade_afnr_date.sh
ᐅ cat upgrade_afnr_date.sh | sed "s/\($PASS\|$USER\)/xxx/g" #!/usr/bin/env bash # vim: ai ts=2 sts=2 sw=2 typeset -r WEB_PG_ARGS="host=localhost user=xxx password=xxx dbname=xxx" AFNR_ID=$(psql -d "$WEB_PG_ARGS" \ -c 'select id from add_forge_request order by id;' -At) typeset -r AFNR_ID for afnr_id in $AFNR_ID do afn_history_last_date=$(psql -d "$WEB_PG_ARGS" \ -c "select date from add_forge_request_history where request_id = ${afnr_id} order by date desc limit 1;" \ -At) afn_check_date=$(psql -d "$WEB_PG_ARGS" \ -c "select last_modified_date from add_forge_request where id = ${afnr_id};" \ -At | awk -F "." '{gsub("[:-]| ","",$0);print $1}') afn_history_check_date=$(awk -F "." '{gsub("[:-]| ","",$0);print $1}' <<< "$afn_history_last_date") if [[ "${afn_history_check_date}" -gt "${afn_check_date}" ]] then printf "| afnr_id | %s |\n|---|---|\n" "$afnr_id" while [[ "${afn_history_check_date}" -gt "${afn_check_date}" ]] do update_msg=$(psql -d "$WEB_PG_ARGS" \ -c "update add_forge_request set last_modified_date = '${afn_history_last_date}' where id = ${afnr_id};" \ -At) afn_check_date=$(psql -d "$WEB_PG_ARGS" \ -c "select last_modified_date from add_forge_request where id = ${afnr_id};" \ -At | awk -F "." '{gsub("[:-]| ","",$0);print $1}') done printf "| afn_check_date | %s |\n| update_msg | %s |\n\n" \ "$afn_check_date" "$update_msg" elif [[ "${afn_history_check_date}" -lt "${afn_check_date}" ]] then printf "| afnr_id | %s |\n|---|---|\n" "$afnr_id" printf "| houston | we have a problem |\n\n" fi donementioned in commit swh/devel/swh-web@8d980367
mentioned in merge request swh/devel/swh-web!1381 (merged)
Saving
swh-webdatabasepostgres@albertina:~$ pg_dump -d swh-web > pg_swh-web_$(date "+%F_%T"|sed 's/[-:]//g').sql postgres@albertina:~$ ls -trl /var/lib/postgresql/pg_swh-web* -rw-r--r-- 1 postgres postgres 413026435 Jan 20 14:34 /var/lib/postgresql/pg_swh-web_20250120_143453.sqlUpgrading
last_modified_datein productionᐅ ./check_afnr_date.sh > production_afnr_check_last_modified_date.md ᐅ ./upgrade_afnr_date.sh > production_afnr_fix_last_modified_date.md ᐅ ./check_afnr_date.sh | afnr id | 1311 | |---|---| | afnr last_modified_date | 20240625015641 | | afnr history last entry date | 20240624025947 |`production_afnr_check_last_modified_date.md`
afnr id 3 afnr last_modified_date 20220927132239 afnr history last entry date 20220927132412 afnr id 4 afnr last_modified_date 20220927051013 afnr history last entry date 20220927051110 afnr id 5 afnr last_modified_date 20220927051204 afnr history last entry date 20240316144639 afnr id 6 afnr last_modified_date 20220927050742 afnr history last entry date 20220927050859 afnr id 8 afnr last_modified_date 20220927050207 afnr history last entry date 20220927050552 afnr id 9 afnr last_modified_date 20220927051408 afnr history last entry date 20220927051503 afnr id 10 afnr last_modified_date 20220927051600 afnr history last entry date 20220927051706 afnr id 12 afnr last_modified_date 20220921073209 afnr history last entry date 20220921080440 afnr id 13 afnr last_modified_date 20221103083213 afnr history last entry date 20221103083413 afnr id 14 afnr last_modified_date 20221113114631 afnr history last entry date 20221113114821 afnr id 15 afnr last_modified_date 20221113115034 afnr history last entry date 20221113115130 afnr id 19 afnr last_modified_date 20230103124201 afnr history last entry date 20230103124308 afnr id 22 afnr last_modified_date 20230105112649 afnr history last entry date 20230105112952 afnr id 26 afnr last_modified_date 20221129083313 afnr history last entry date 20221129083700 afnr id 30 afnr last_modified_date 20230706071613 afnr history last entry date 20230706073654 afnr id 85 afnr last_modified_date 20230602133639 afnr history last entry date 20230602133949 afnr id 86 afnr last_modified_date 20231030225528 afnr history last entry date 20231031072148 afnr id 150 afnr last_modified_date 20231003012416 afnr history last entry date 20240320233656 afnr id 155 afnr last_modified_date 20231016094435 afnr history last entry date 20231020025052 afnr id 197 afnr last_modified_date 20231011005148 afnr history last entry date 20231011005953 afnr id 401 afnr last_modified_date 20240213101413 afnr history last entry date 20241223115153 afnr id 405 afnr last_modified_date 20240228010951 afnr history last entry date 20240228174539 afnr id 413 afnr last_modified_date 20240228011020 afnr history last entry date 20240228181036 afnr id 421 afnr last_modified_date 20231129024525 afnr history last entry date 20240228181326 afnr id 423 afnr last_modified_date 20240227022716 afnr history last entry date 20240229012856 afnr id 435 afnr last_modified_date 20240301004051 afnr history last entry date 20240301004142 afnr id 440 afnr last_modified_date 20240106203700 afnr history last entry date 20240229012505 afnr id 445 afnr last_modified_date 20240228092742 afnr history last entry date 20240229013542 afnr id 448 afnr last_modified_date 20240407030617 afnr history last entry date 20240412203630 afnr id 502 afnr last_modified_date 20240307085436 afnr history last entry date 20240307110322 afnr id 503 afnr last_modified_date 20240229102044 afnr history last entry date 20240229232923 afnr id 508 afnr last_modified_date 20240301001553 afnr history last entry date 20240301002013 afnr id 529 afnr last_modified_date 20231213052822 afnr history last entry date 20240303234750 afnr id 546 afnr last_modified_date 20240428175724 afnr history last entry date 20240429171709 afnr id 569 afnr last_modified_date 20240112223337 afnr history last entry date 20240320224945 afnr id 573 afnr last_modified_date 20240112224526 afnr history last entry date 20240405083736 afnr id 581 afnr last_modified_date 20240112232651 afnr history last entry date 20240309030400 afnr id 593 afnr last_modified_date 20240312101755 afnr history last entry date 20240319174358 afnr id 594 afnr last_modified_date 20240126153840 afnr history last entry date 20240315022734 afnr id 595 afnr last_modified_date 20240311030528 afnr history last entry date 20240319165717 afnr id 652 afnr last_modified_date 20240127163105 afnr history last entry date 20240315154046 afnr id 653 afnr last_modified_date 20240127163420 afnr history last entry date 20240316005951 afnr id 665 afnr last_modified_date 20240316030425 afnr history last entry date 20240415002739 afnr id 706 afnr last_modified_date 20240321231403 afnr history last entry date 20240501160828 afnr id 727 afnr last_modified_date 20240206032745 afnr history last entry date 20240319020834 afnr id 735 afnr last_modified_date 20240206035759 afnr history last entry date 20240319021738 afnr id 737 afnr last_modified_date 20240206040326 afnr history last entry date 20240319022013 afnr id 753 afnr last_modified_date 20240208062149 afnr history last entry date 20240319023904 afnr id 760 afnr last_modified_date 20240208071843 afnr history last entry date 20240319024802 afnr id 791 afnr last_modified_date 20240323053846 afnr history last entry date 20240325161109 afnr id 809 afnr last_modified_date 20240218035549 afnr history last entry date 20240319034352 afnr id 839 afnr last_modified_date 20240321231439 afnr history last entry date 20240322000011 afnr id 871 afnr last_modified_date 20240302050352 afnr history last entry date 20240320123355 afnr id 886 afnr last_modified_date 20240326010829 afnr history last entry date 20240412125004 afnr id 903 afnr last_modified_date 20240328022146 afnr history last entry date 20240328022439 afnr id 953 afnr last_modified_date 20240611075926 afnr history last entry date 20250106090430 afnr id 971 afnr last_modified_date 20240411010826 afnr history last entry date 20240411011048 afnr id 978 afnr last_modified_date 20240411020908 afnr history last entry date 20240411021322 afnr id 983 afnr last_modified_date 20240422032754 afnr history last entry date 20240424050942 afnr id 993 afnr last_modified_date 20240415010034 afnr history last entry date 20240415010218 afnr id 996 afnr last_modified_date 20240416115857 afnr history last entry date 20240417012427 afnr id 1011 afnr last_modified_date 20241028200549 afnr history last entry date 20241224044153 afnr id 1013 afnr last_modified_date 20240418022126 afnr history last entry date 20240418022223 afnr id 1015 afnr last_modified_date 20240418023355 afnr history last entry date 20240418074310 afnr id 1029 afnr last_modified_date 20240419124539 afnr history last entry date 20240428161610 afnr id 1033 afnr last_modified_date 20240419130216 afnr history last entry date 20240423162459 afnr id 1035 afnr last_modified_date 20240419131013 afnr history last entry date 20240428161654 afnr id 1038 afnr last_modified_date 20240419132713 afnr history last entry date 20240423010353 afnr id 1047 afnr last_modified_date 20240419135924 afnr history last entry date 20240713024114 afnr id 1058 afnr last_modified_date 20240419144940 afnr history last entry date 20240423020459 afnr id 1065 afnr last_modified_date 20240419150930 afnr history last entry date 20240423021358 afnr id 1068 afnr last_modified_date 20240419151529 afnr history last entry date 20240423185532 afnr id 1083 afnr last_modified_date 20240422075622 afnr history last entry date 20240425021636 afnr id 1097 afnr last_modified_date 20241125023640 afnr history last entry date 20241125024432 afnr id 1098 afnr last_modified_date 20241125024715 afnr history last entry date 20250112015205 afnr id 1099 afnr last_modified_date 20241125025057 afnr history last entry date 20241125025234 afnr id 1100 afnr last_modified_date 20241125025508 afnr history last entry date 20241125025625 afnr id 1101 afnr last_modified_date 20241125025914 afnr history last entry date 20241125030055 afnr id 1102 afnr last_modified_date 20241125030321 afnr history last entry date 20241125030419 afnr id 1103 afnr last_modified_date 20241125030712 afnr history last entry date 20241125031002 afnr id 1105 afnr last_modified_date 20240422101044 afnr history last entry date 20241125031636 afnr id 1106 afnr last_modified_date 20240422113752 afnr history last entry date 20241125031942 afnr id 1107 afnr last_modified_date 20240422113908 afnr history last entry date 20241125032118 afnr id 1108 afnr last_modified_date 20240422114011 afnr history last entry date 20241125032529 afnr id 1109 afnr last_modified_date 20240422114123 afnr history last entry date 20241125032752 afnr id 1111 afnr last_modified_date 20250112015315 afnr history last entry date 20250112015340 afnr id 1112 afnr last_modified_date 20250112015414 afnr history last entry date 20250112015522 afnr id 1113 afnr last_modified_date 20241125033652 afnr history last entry date 20241125033729 afnr id 1114 afnr last_modified_date 20240602080454 afnr history last entry date 20241125034003 afnr id 1115 afnr last_modified_date 20240612023023 afnr history last entry date 20241125034304 afnr id 1118 afnr last_modified_date 20241127021027 afnr history last entry date 20241220080216 afnr id 1119 afnr last_modified_date 20240605054144 afnr history last entry date 20241125035608 afnr id 1122 afnr last_modified_date 20240422115425 afnr history last entry date 20250112015809 afnr id 1123 afnr last_modified_date 20240422115529 afnr history last entry date 20250112143348 afnr id 1124 afnr last_modified_date 20240605065449 afnr history last entry date 20250112020253 afnr id 1125 afnr last_modified_date 20240422115716 afnr history last entry date 20250112020429 afnr id 1126 afnr last_modified_date 20240422115836 afnr history last entry date 20250112020533 afnr id 1127 afnr last_modified_date 20240605060841 afnr history last entry date 20250112020901 afnr id 1128 afnr last_modified_date 20240605061453 afnr history last entry date 20250112021225 afnr id 1129 afnr last_modified_date 20240422120150 afnr history last entry date 20250112011848 afnr id 1130 afnr last_modified_date 20240422120250 afnr history last entry date 20250112012128 afnr id 1131 afnr last_modified_date 20240422120419 afnr history last entry date 20250112012451 afnr id 1133 afnr last_modified_date 20240605060133 afnr history last entry date 20250112013824 afnr id 1134 afnr last_modified_date 20240422120821 afnr history last entry date 20250112013950 afnr id 1135 afnr last_modified_date 20240422120945 afnr history last entry date 20250112014048 afnr id 1136 afnr last_modified_date 20240422121054 afnr history last entry date 20250112014519 afnr id 1137 afnr last_modified_date 20240422121207 afnr history last entry date 20250112014649 afnr id 1138 afnr last_modified_date 20240422121331 afnr history last entry date 20250112014910 afnr id 1139 afnr last_modified_date 20240422121811 afnr history last entry date 20250112021553 afnr id 1140 afnr last_modified_date 20240422121907 afnr history last entry date 20250112021722 afnr id 1141 afnr last_modified_date 20240422121956 afnr history last entry date 20250112021825 afnr id 1142 afnr last_modified_date 20240422122047 afnr history last entry date 20250112021951 afnr id 1143 afnr last_modified_date 20240422122153 afnr history last entry date 20250112021946 afnr id 1144 afnr last_modified_date 20240422122225 afnr history last entry date 20250112022043 afnr id 1145 afnr last_modified_date 20240422122316 afnr history last entry date 20250112022725 afnr id 1146 afnr last_modified_date 20240422122407 afnr history last entry date 20250112022715 afnr id 1147 afnr last_modified_date 20240422122508 afnr history last entry date 20250112022802 afnr id 1148 afnr last_modified_date 20240422135034 afnr history last entry date 20250112023022 afnr id 1149 afnr last_modified_date 20240422135119 afnr history last entry date 20250112023051 afnr id 1150 afnr last_modified_date 20240422135151 afnr history last entry date 20250112023116 afnr id 1151 afnr last_modified_date 20240422135456 afnr history last entry date 20250112023236 afnr id 1152 afnr last_modified_date 20240422135530 afnr history last entry date 20250112023304 afnr id 1153 afnr last_modified_date 20240422135600 afnr history last entry date 20250112023552 afnr id 1154 afnr last_modified_date 20240422135816 afnr history last entry date 20250112023548 afnr id 1155 afnr last_modified_date 20240422140005 afnr history last entry date 20250112023734 afnr id 1156 afnr last_modified_date 20240422140207 afnr history last entry date 20250112024026 afnr id 1157 afnr last_modified_date 20240422140915 afnr history last entry date 20250112024241 afnr id 1158 afnr last_modified_date 20240422141202 afnr history last entry date 20250112024424 afnr id 1159 afnr last_modified_date 20240422141237 afnr history last entry date 20250112024638 afnr id 1160 afnr last_modified_date 20240422141616 afnr history last entry date 20250112024859 afnr id 1161 afnr last_modified_date 20240422142227 afnr history last entry date 20250112025055 afnr id 1311 afnr last_modified_date 20240625015641 afnr history last entry date 20240624025947 afnr id 1616 afnr last_modified_date 20240816015705 afnr history last entry date 20250112055007 `production_afnr_fix_last_modified_date.md`
afnr_id 3 afn_check_date 20220927132412 update_msg UPDATE 1 afnr_id 4 afn_check_date 20220927051110 update_msg UPDATE 1 afnr_id 5 afn_check_date 20240316144639 update_msg UPDATE 1 afnr_id 6 afn_check_date 20220927050859 update_msg UPDATE 1 afnr_id 8 afn_check_date 20220927050552 update_msg UPDATE 1 afnr_id 9 afn_check_date 20220927051503 update_msg UPDATE 1 afnr_id 10 afn_check_date 20220927051706 update_msg UPDATE 1 afnr_id 12 afn_check_date 20220921080440 update_msg UPDATE 1 afnr_id 13 afn_check_date 20221103083413 update_msg UPDATE 1 afnr_id 14 afn_check_date 20221113114821 update_msg UPDATE 1 afnr_id 15 afn_check_date 20221113115130 update_msg UPDATE 1 afnr_id 19 afn_check_date 20230103124308 update_msg UPDATE 1 afnr_id 22 afn_check_date 20230105112952 update_msg UPDATE 1 afnr_id 26 afn_check_date 20221129083700 update_msg UPDATE 1 afnr_id 30 afn_check_date 20230706073654 update_msg UPDATE 1 afnr_id 85 afn_check_date 20230602133949 update_msg UPDATE 1 afnr_id 86 afn_check_date 20231031072148 update_msg UPDATE 1 afnr_id 150 afn_check_date 20240320233656 update_msg UPDATE 1 afnr_id 155 afn_check_date 20231020025052 update_msg UPDATE 1 afnr_id 197 afn_check_date 20231011005953 update_msg UPDATE 1 afnr_id 401 afn_check_date 20241223115153 update_msg UPDATE 1 afnr_id 405 afn_check_date 20240228174539 update_msg UPDATE 1 afnr_id 413 afn_check_date 20240228181036 update_msg UPDATE 1 afnr_id 421 afn_check_date 20240228181326 update_msg UPDATE 1 afnr_id 423 afn_check_date 20240229012856 update_msg UPDATE 1 afnr_id 435 afn_check_date 20240301004142 update_msg UPDATE 1 afnr_id 440 afn_check_date 20240229012505 update_msg UPDATE 1 afnr_id 445 afn_check_date 20240229013542 update_msg UPDATE 1 afnr_id 448 afn_check_date 20240412203630 update_msg UPDATE 1 afnr_id 502 afn_check_date 20240307110322 update_msg UPDATE 1 afnr_id 503 afn_check_date 20240229232923 update_msg UPDATE 1 afnr_id 508 afn_check_date 20240301002013 update_msg UPDATE 1 afnr_id 529 afn_check_date 20240303234750 update_msg UPDATE 1 afnr_id 546 afn_check_date 20240429171709 update_msg UPDATE 1 afnr_id 569 afn_check_date 20240320224945 update_msg UPDATE 1 afnr_id 573 afn_check_date 20240405083736 update_msg UPDATE 1 afnr_id 581 afn_check_date 20240309030400 update_msg UPDATE 1 afnr_id 593 afn_check_date 20240319174358 update_msg UPDATE 1 afnr_id 594 afn_check_date 20240315022734 update_msg UPDATE 1 afnr_id 595 afn_check_date 20240319165717 update_msg UPDATE 1 afnr_id 652 afn_check_date 20240315154046 update_msg UPDATE 1 afnr_id 653 afn_check_date 20240316005951 update_msg UPDATE 1 afnr_id 665 afn_check_date 20240415002739 update_msg UPDATE 1 afnr_id 706 afn_check_date 20240501160828 update_msg UPDATE 1 afnr_id 727 afn_check_date 20240319020834 update_msg UPDATE 1 afnr_id 735 afn_check_date 20240319021738 update_msg UPDATE 1 afnr_id 737 afn_check_date 20240319022013 update_msg UPDATE 1 afnr_id 753 afn_check_date 20240319023904 update_msg UPDATE 1 afnr_id 760 afn_check_date 20240319024802 update_msg UPDATE 1 afnr_id 791 afn_check_date 20240325161109 update_msg UPDATE 1 afnr_id 809 afn_check_date 20240319034352 update_msg UPDATE 1 afnr_id 839 afn_check_date 20240322000011 update_msg UPDATE 1 afnr_id 871 afn_check_date 20240320123355 update_msg UPDATE 1 afnr_id 886 afn_check_date 20240412125004 update_msg UPDATE 1 afnr_id 903 afn_check_date 20240328022439 update_msg UPDATE 1 afnr_id 953 afn_check_date 20250106090430 update_msg UPDATE 1 afnr_id 971 afn_check_date 20240411011048 update_msg UPDATE 1 afnr_id 978 afn_check_date 20240411021322 update_msg UPDATE 1 afnr_id 983 afn_check_date 20240424050942 update_msg UPDATE 1 afnr_id 993 afn_check_date 20240415010218 update_msg UPDATE 1 afnr_id 996 afn_check_date 20240417012427 update_msg UPDATE 1 afnr_id 1011 afn_check_date 20241224044153 update_msg UPDATE 1 afnr_id 1013 afn_check_date 20240418022223 update_msg UPDATE 1 afnr_id 1015 afn_check_date 20240418074310 update_msg UPDATE 1 afnr_id 1029 afn_check_date 20240428161610 update_msg UPDATE 1 afnr_id 1033 afn_check_date 20240423162459 update_msg UPDATE 1 afnr_id 1035 afn_check_date 20240428161654 update_msg UPDATE 1 afnr_id 1038 afn_check_date 20240423010353 update_msg UPDATE 1 afnr_id 1047 afn_check_date 20240713024114 update_msg UPDATE 1 afnr_id 1058 afn_check_date 20240423020459 update_msg UPDATE 1 afnr_id 1065 afn_check_date 20240423021358 update_msg UPDATE 1 afnr_id 1068 afn_check_date 20240423185532 update_msg UPDATE 1 afnr_id 1083 afn_check_date 20240425021636 update_msg UPDATE 1 afnr_id 1097 afn_check_date 20241125024432 update_msg UPDATE 1 afnr_id 1098 afn_check_date 20250112015205 update_msg UPDATE 1 afnr_id 1099 afn_check_date 20241125025234 update_msg UPDATE 1 afnr_id 1100 afn_check_date 20241125025625 update_msg UPDATE 1 afnr_id 1101 afn_check_date 20241125030055 update_msg UPDATE 1 afnr_id 1102 afn_check_date 20241125030419 update_msg UPDATE 1 afnr_id 1103 afn_check_date 20241125031002 update_msg UPDATE 1 afnr_id 1105 afn_check_date 20241125031636 update_msg UPDATE 1 afnr_id 1106 afn_check_date 20241125031942 update_msg UPDATE 1 afnr_id 1107 afn_check_date 20241125032118 update_msg UPDATE 1 afnr_id 1108 afn_check_date 20241125032529 update_msg UPDATE 1 afnr_id 1109 afn_check_date 20241125032752 update_msg UPDATE 1 afnr_id 1111 afn_check_date 20250112015340 update_msg UPDATE 1 afnr_id 1112 afn_check_date 20250112015522 update_msg UPDATE 1 afnr_id 1113 afn_check_date 20241125033729 update_msg UPDATE 1 afnr_id 1114 afn_check_date 20241125034003 update_msg UPDATE 1 afnr_id 1115 afn_check_date 20241125034304 update_msg UPDATE 1 afnr_id 1118 afn_check_date 20241220080216 update_msg UPDATE 1 afnr_id 1119 afn_check_date 20241125035608 update_msg UPDATE 1 afnr_id 1122 afn_check_date 20250112015809 update_msg UPDATE 1 afnr_id 1123 afn_check_date 20250112143348 update_msg UPDATE 1 afnr_id 1124 afn_check_date 20250112020253 update_msg UPDATE 1 afnr_id 1125 afn_check_date 20250112020429 update_msg UPDATE 1 afnr_id 1126 afn_check_date 20250112020533 update_msg UPDATE 1 afnr_id 1127 afn_check_date 20250112020901 update_msg UPDATE 1 afnr_id 1128 afn_check_date 20250112021225 update_msg UPDATE 1 afnr_id 1129 afn_check_date 20250112011848 update_msg UPDATE 1 afnr_id 1130 afn_check_date 20250112012128 update_msg UPDATE 1 afnr_id 1131 afn_check_date 20250112012451 update_msg UPDATE 1 afnr_id 1133 afn_check_date 20250112013824 update_msg UPDATE 1 afnr_id 1134 afn_check_date 20250112013950 update_msg UPDATE 1 afnr_id 1135 afn_check_date 20250112014048 update_msg UPDATE 1 afnr_id 1136 afn_check_date 20250112014519 update_msg UPDATE 1 afnr_id 1137 afn_check_date 20250112014649 update_msg UPDATE 1 afnr_id 1138 afn_check_date 20250112014910 update_msg UPDATE 1 afnr_id 1139 afn_check_date 20250112021553 update_msg UPDATE 1 afnr_id 1140 afn_check_date 20250112021722 update_msg UPDATE 1 afnr_id 1141 afn_check_date 20250112021825 update_msg UPDATE 1 afnr_id 1142 afn_check_date 20250112021951 update_msg UPDATE 1 afnr_id 1143 afn_check_date 20250112021946 update_msg UPDATE 1 afnr_id 1144 afn_check_date 20250112022043 update_msg UPDATE 1 afnr_id 1145 afn_check_date 20250112022725 update_msg UPDATE 1 afnr_id 1146 afn_check_date 20250112022715 update_msg UPDATE 1 afnr_id 1147 afn_check_date 20250112022802 update_msg UPDATE 1 afnr_id 1148 afn_check_date 20250112023022 update_msg UPDATE 1 afnr_id 1149 afn_check_date 20250112023051 update_msg UPDATE 1 afnr_id 1150 afn_check_date 20250112023116 update_msg UPDATE 1 afnr_id 1151 afn_check_date 20250112023236 update_msg UPDATE 1 afnr_id 1152 afn_check_date 20250112023304 update_msg UPDATE 1 afnr_id 1153 afn_check_date 20250112023552 update_msg UPDATE 1 afnr_id 1154 afn_check_date 20250112023548 update_msg UPDATE 1 afnr_id 1155 afn_check_date 20250112023734 update_msg UPDATE 1 afnr_id 1156 afn_check_date 20250112024026 update_msg UPDATE 1 afnr_id 1157 afn_check_date 20250112024241 update_msg UPDATE 1 afnr_id 1158 afn_check_date 20250112024424 update_msg UPDATE 1 afnr_id 1159 afn_check_date 20250112024638 update_msg UPDATE 1 afnr_id 1160 afn_check_date 20250112024859 update_msg UPDATE 1 afnr_id 1161 afn_check_date 20250112025055 update_msg UPDATE 1 afnr_id 1311 houston we have a problem afnr_id 1616 afn_check_date 20250112055007 update_msg UPDATE 1
The merge request swh/devel/swh-web!1381 (merged) will solve the issue (
last_modified_dateis not updated when submitter is 'EMAIL').
The merge request swh/devel/swh-web!1381 (merged) (merged) will solve the issue (last_modified_date is not updated when submitter is 'EMAIL').
It's been deployed [1]
[1] #5546 (closed)
mentioned in issue #5546 (closed)
@pabs The wrong
last_modified_datevalues have been updated and it should be the same when receiving emails.@guillaume @ardumont this issue has been fixed since the deployment, but today after I sent a bunch of mails most of them updated the
last_modified_datebut then it stopped working again. Could you take a look at this again?After restoring
swh-webin a local docker environment, I checked thelast_modified_date:ᐅ ./check_afnr_date.sh > production_afnr_check_last_modified_date.mdIndeed there are a lot of wrong dates:
`production_afnr_check_last_modified_date.md`
afnr id 467 afnr last_modified_date 20240402101654 afnr history last entry date 20250207091219 afnr id 1162 afnr last_modified_date 20250217001128 afnr history last entry date 20250217003848 afnr id 1163 afnr last_modified_date 20250217004054 afnr history last entry date 20250217004242 afnr id 1164 afnr last_modified_date 20250217004550 afnr history last entry date 20250217004711 afnr id 1165 afnr last_modified_date 20250217005100 afnr history last entry date 20250217010107 afnr id 1166 afnr last_modified_date 20250217005207 afnr history last entry date 20250217010107 afnr id 1167 afnr last_modified_date 20250217005608 afnr history last entry date 20250217010107 afnr id 1168 afnr last_modified_date 20250217010133 afnr history last entry date 20250217010321 afnr id 1169 afnr last_modified_date 20250217010514 afnr history last entry date 20250217010705 afnr id 1170 afnr last_modified_date 20240422144301 afnr history last entry date 20250217010907 afnr id 1171 afnr last_modified_date 20240422144625 afnr history last entry date 20250217011045 afnr id 1172 afnr last_modified_date 20240422144656 afnr history last entry date 20250217011123 afnr id 1173 afnr last_modified_date 20240422144727 afnr history last entry date 20250217011139 afnr id 1174 afnr last_modified_date 20240422144917 afnr history last entry date 20250217011159 afnr id 1175 afnr last_modified_date 20240422145459 afnr history last entry date 20250217011358 afnr id 1176 afnr last_modified_date 20240422152010 afnr history last entry date 20250217011612 afnr id 1177 afnr last_modified_date 20240422152046 afnr history last entry date 20250217012324 afnr id 1178 afnr last_modified_date 20240422152327 afnr history last entry date 20250217012332 afnr id 1179 afnr last_modified_date 20240422152946 afnr history last entry date 20250217012725 afnr id 1180 afnr last_modified_date 20240422153021 afnr history last entry date 20250217013035 afnr id 1181 afnr last_modified_date 20240422153102 afnr history last entry date 20250217013413 afnr id 1182 afnr last_modified_date 20240422153142 afnr history last entry date 20250217013643 afnr id 1184 afnr last_modified_date 20240605050304 afnr history last entry date 20250217014554 afnr id 1185 afnr last_modified_date 20240426123350 afnr history last entry date 20250217014757 afnr id 1187 afnr last_modified_date 20240426123514 afnr history last entry date 20250217020137 afnr id 1188 afnr last_modified_date 20240426123618 afnr history last entry date 20250217020737 afnr id 1189 afnr last_modified_date 20240426123700 afnr history last entry date 20250217021002 afnr id 1190 afnr last_modified_date 20240426123756 afnr history last entry date 20250217021620 afnr id 1191 afnr last_modified_date 20240605052017 afnr history last entry date 20250217021758 afnr id 1192 afnr last_modified_date 20240426123902 afnr history last entry date 20250217022022 afnr id 1193 afnr last_modified_date 20240426123936 afnr history last entry date 20250217022347 afnr id 1194 afnr last_modified_date 20240529060645 afnr history last entry date 20250217023100 afnr id 1195 afnr last_modified_date 20240605064021 afnr history last entry date 20250217023343 afnr id 1196 afnr last_modified_date 20240605050204 afnr history last entry date 20250217023650 afnr id 1197 afnr last_modified_date 20240426124147 afnr history last entry date 20250217023814 afnr id 1198 afnr last_modified_date 20240426124227 afnr history last entry date 20250217023938 afnr id 1199 afnr last_modified_date 20240426124257 afnr history last entry date 20250217024124 afnr id 1200 afnr last_modified_date 20240426124335 afnr history last entry date 20250217024248 afnr id 1201 afnr last_modified_date 20240426124404 afnr history last entry date 20250217024841 afnr id 1202 afnr last_modified_date 20240605051212 afnr history last entry date 20250217025206 afnr id 1203 afnr last_modified_date 20240605065824 afnr history last entry date 20250217025436 afnr id 1204 afnr last_modified_date 20240426124606 afnr history last entry date 20250217025846 afnr id 1205 afnr last_modified_date 20240426130614 afnr history last entry date 20250217030139 afnr id 1206 afnr last_modified_date 20240426130643 afnr history last entry date 20250217030322 afnr id 1208 afnr last_modified_date 20240426130744 afnr history last entry date 20250217030729 afnr id 1209 afnr last_modified_date 20240426131307 afnr history last entry date 20250217030817 afnr id 1210 afnr last_modified_date 20240426132539 afnr history last entry date 20250217030910 afnr id 1211 afnr last_modified_date 20240426132635 afnr history last entry date 20250217031110 afnr id 1212 afnr last_modified_date 20240426133115 afnr history last entry date 20250217031905 afnr id 1213 afnr last_modified_date 20240426133141 afnr history last entry date 20250217031906 afnr id 1214 afnr last_modified_date 20240426133209 afnr history last entry date 20250217033304 afnr id 1215 afnr last_modified_date 20240426133653 afnr history last entry date 20250217032946 afnr id 1216 afnr last_modified_date 20240426134014 afnr history last entry date 20250217033137 afnr id 1217 afnr last_modified_date 20240426134225 afnr history last entry date 20250217033542 afnr id 1218 afnr last_modified_date 20240426134746 afnr history last entry date 20250217033942 afnr id 1219 afnr last_modified_date 20240507045241 afnr history last entry date 20250217034210 afnr id 1220 afnr last_modified_date 20240611053309 afnr history last entry date 20250217034416 afnr id 1221 afnr last_modified_date 20240525040147 afnr history last entry date 20250217034655 afnr id 1222 afnr last_modified_date 20240528053703 afnr history last entry date 20250217034909 afnr id 1223 afnr last_modified_date 20240528054101 afnr history last entry date 20250217035154 afnr id 1224 afnr last_modified_date 20240528054922 afnr history last entry date 20250217035303 afnr id 1225 afnr last_modified_date 20240528062901 afnr history last entry date 20250217035428 afnr id 1226 afnr last_modified_date 20240528063200 afnr history last entry date 20250217035802 afnr id 1227 afnr last_modified_date 20240528064016 afnr history last entry date 20250217040026 afnr id 1228 afnr last_modified_date 20240528070638 afnr history last entry date 20250217040115 afnr id 1229 afnr last_modified_date 20240529043034 afnr history last entry date 20250217040130 afnr id 1230 afnr last_modified_date 20240529043445 afnr history last entry date 20250217040142 afnr id 1231 afnr last_modified_date 20240529044618 afnr history last entry date 20250217045159 afnr id 1232 afnr last_modified_date 20240529045442 afnr history last entry date 20250217040207 afnr id 1233 afnr last_modified_date 20240529050917 afnr history last entry date 20250217075501 afnr id 1236 afnr last_modified_date 20240529060321 afnr history last entry date 20250217040416 afnr id 1237 afnr last_modified_date 20240529061532 afnr history last entry date 20250217041120 afnr id 1311 afnr last_modified_date 20240625015641 afnr history last entry date 20240624025947 It seems the fix has not been deployed.
The fix is just after the last tag:ᐅ glol | head -12 * d4df3f46a - (HEAD -> master, origin/master, origin/HEAD) api/origin: Fix returned data documentation of some endpoints (5 days ago) <Antoine Lambert> * 7ceba5a50 - browse: Fix redirect issue in search interface (5 days ago) <Antoine Lambert> * 6f4809e37 - cypress/mailmap: Fix flaky test on Jenkins (5 days ago) <Antoine Lambert> * 0c66abf32 - alter/models: Remove no longer needed type ignore (6 days ago) <Antoine Lambert> * 661ac0a18 - package.json: Bump dependencies (6 days ago) <Antoine Lambert> * 785899b72 - A prototype for alteration requests: swh-web-alter (12 days ago) <Renaud Boyer> * ade2b0a17 - browse: Improve releases sorting in releases list view (6 weeks ago) <Antoine Lambert> * 1e0252495 - package.json: Bump node to >= 20 and upgrade dependencies (4 weeks ago) <Antoine Lambert> * 092710e03 - e2e: Acknowledge xhr failures (4 weeks ago) <Renaud Boyer> * fa785693b - api: Use drf serializers to sanitize query params (4 weeks ago) <Renaud Boyer> * 8d9803671 - inbound_email: Update AFNR last date when receiving an email (4 weeks ago) <Guillaume Samson> * b4762ee7b - (tag: v0.9.6) inbound_email: GET is not allowed (4 weeks ago) <Renaud Boyer>Here are the current
swh-webversion in production:ᐅ for web in $(kbp get po -n swh-cassandra -l app=web-archive -o name) do kbp exec -ti -n swh-cassandra -c web-archive "$web" -- grep 'swh-web=' requirements-frozen.txt done swh-web==0.9.6 swh-web==0.9.6I will backup the
swh-webdatabase and update thelast_modified_date.-
off-by-1 are a pain!
Actually, no, the tag I thought I pushed never came through.
A pending deployment with the fix will happen soon (some other commits are on their way in the webapp and they will be shipped alongside).
Edited by Antoine R. Dumont
After creating a dump of swh-web database, all the
last_modified_datehave been updated:root@albertina:~# ls -trl /var/lib/postgresql/pg_swh-web_20250217_134001.sql -rw-r--r-- 1 postgres postgres 435838294 Feb 17 13:40 /var/lib/postgresql/pg_swh-web_20250217_134001.sqlᐅ ./upgrade_afnr_date.sh > production_afnr_fix_last_modified_date.md`production_afnr_fix_last_modified_date.md`
afnr_id 467 afn_check_date 20250207091219 update_msg UPDATE 1 afnr_id 1162 afn_check_date 20250217003848 update_msg UPDATE 1 afnr_id 1163 afn_check_date 20250217004242 update_msg UPDATE 1 afnr_id 1164 afn_check_date 20250217004711 update_msg UPDATE 1 afnr_id 1165 afn_check_date 20250217010107 update_msg UPDATE 1 afnr_id 1166 afn_check_date 20250217010107 update_msg UPDATE 1 afnr_id 1167 afn_check_date 20250217010107 update_msg UPDATE 1 afnr_id 1168 afn_check_date 20250217010321 update_msg UPDATE 1 afnr_id 1169 afn_check_date 20250217010705 update_msg UPDATE 1 afnr_id 1170 afn_check_date 20250217010907 update_msg UPDATE 1 afnr_id 1171 afn_check_date 20250217011045 update_msg UPDATE 1 afnr_id 1172 afn_check_date 20250217011123 update_msg UPDATE 1 afnr_id 1173 afn_check_date 20250217011139 update_msg UPDATE 1 afnr_id 1174 afn_check_date 20250217011159 update_msg UPDATE 1 afnr_id 1175 afn_check_date 20250217011358 update_msg UPDATE 1 afnr_id 1176 afn_check_date 20250217011612 update_msg UPDATE 1 afnr_id 1177 afn_check_date 20250217012324 update_msg UPDATE 1 afnr_id 1178 afn_check_date 20250217012332 update_msg UPDATE 1 afnr_id 1179 afn_check_date 20250217012725 update_msg UPDATE 1 afnr_id 1180 afn_check_date 20250217013035 update_msg UPDATE 1 afnr_id 1181 afn_check_date 20250217013413 update_msg UPDATE 1 afnr_id 1182 afn_check_date 20250217013643 update_msg UPDATE 1 afnr_id 1184 afn_check_date 20250217014554 update_msg UPDATE 1 afnr_id 1185 afn_check_date 20250217014757 update_msg UPDATE 1 afnr_id 1187 afn_check_date 20250217020137 update_msg UPDATE 1 afnr_id 1188 afn_check_date 20250217020737 update_msg UPDATE 1 afnr_id 1189 afn_check_date 20250217021002 update_msg UPDATE 1 afnr_id 1190 afn_check_date 20250217021620 update_msg UPDATE 1 afnr_id 1191 afn_check_date 20250217021758 update_msg UPDATE 1 afnr_id 1192 afn_check_date 20250217022022 update_msg UPDATE 1 afnr_id 1193 afn_check_date 20250217022347 update_msg UPDATE 1 afnr_id 1194 afn_check_date 20250217023100 update_msg UPDATE 1 afnr_id 1195 afn_check_date 20250217023343 update_msg UPDATE 1 afnr_id 1196 afn_check_date 20250217023650 update_msg UPDATE 1 afnr_id 1197 afn_check_date 20250217023814 update_msg UPDATE 1 afnr_id 1198 afn_check_date 20250217023938 update_msg UPDATE 1 afnr_id 1199 afn_check_date 20250217024124 update_msg UPDATE 1 afnr_id 1200 afn_check_date 20250217024248 update_msg UPDATE 1 afnr_id 1201 afn_check_date 20250217024841 update_msg UPDATE 1 afnr_id 1202 afn_check_date 20250217025206 update_msg UPDATE 1 afnr_id 1203 afn_check_date 20250217025436 update_msg UPDATE 1 afnr_id 1204 afn_check_date 20250217025846 update_msg UPDATE 1 afnr_id 1205 afn_check_date 20250217030139 update_msg UPDATE 1 afnr_id 1206 afn_check_date 20250217030322 update_msg UPDATE 1 afnr_id 1208 afn_check_date 20250217030729 update_msg UPDATE 1 afnr_id 1209 afn_check_date 20250217030817 update_msg UPDATE 1 afnr_id 1210 afn_check_date 20250217030910 update_msg UPDATE 1 afnr_id 1211 afn_check_date 20250217031110 update_msg UPDATE 1 afnr_id 1212 afn_check_date 20250217031905 update_msg UPDATE 1 afnr_id 1213 afn_check_date 20250217031906 update_msg UPDATE 1 afnr_id 1214 afn_check_date 20250217033304 update_msg UPDATE 1 afnr_id 1215 afn_check_date 20250217032946 update_msg UPDATE 1 afnr_id 1216 afn_check_date 20250217033137 update_msg UPDATE 1 afnr_id 1217 afn_check_date 20250217033542 update_msg UPDATE 1 afnr_id 1218 afn_check_date 20250217033942 update_msg UPDATE 1 afnr_id 1219 afn_check_date 20250217034210 update_msg UPDATE 1 afnr_id 1220 afn_check_date 20250217034416 update_msg UPDATE 1 afnr_id 1221 afn_check_date 20250217034655 update_msg UPDATE 1 afnr_id 1222 afn_check_date 20250217034909 update_msg UPDATE 1 afnr_id 1223 afn_check_date 20250217035154 update_msg UPDATE 1 afnr_id 1224 afn_check_date 20250217035303 update_msg UPDATE 1 afnr_id 1225 afn_check_date 20250217035428 update_msg UPDATE 1 afnr_id 1226 afn_check_date 20250217035802 update_msg UPDATE 1 afnr_id 1227 afn_check_date 20250217040026 update_msg UPDATE 1 afnr_id 1228 afn_check_date 20250217040115 update_msg UPDATE 1 afnr_id 1229 afn_check_date 20250217040130 update_msg UPDATE 1 afnr_id 1230 afn_check_date 20250217040142 update_msg UPDATE 1 afnr_id 1231 afn_check_date 20250217045159 update_msg UPDATE 1 afnr_id 1232 afn_check_date 20250217040207 update_msg UPDATE 1 afnr_id 1233 afn_check_date 20250217075501 update_msg UPDATE 1 afnr_id 1236 afn_check_date 20250217040416 update_msg UPDATE 1 afnr_id 1237 afn_check_date 20250217041120 update_msg UPDATE 1 afnr_id 1311 houston we have a problem except for AFNR#1311 where the
last_modified_dateis older than the last entry inadd_forge_request_historytable.ᐅ ./check_afnr_date.sh | afnr id | 1311 | |---|---| | afnr last_modified_date | 20240625015641 | | afnr history last entry date | 20240624025947 |@pabs all the wrong
last_modified_datehave been updated and the fix have been deployed.@guillaume @ardumont today the same thing has happened, it was working for a while and now it has stopped updating again.
The
last_modified_dateis updated with an empty value:swh-web=> select date from add_forge_request_history where request_id = 1290 ; -[ RECORD 1 ]----------------------- date | 2024-06-21 14:12:49.075163+00 -[ RECORD 2 ]----------------------- date | 2024-06-24 03:23:59.018792+00 -[ RECORD 3 ]----------------------- date | 2025-02-19 07:32:16.509913+00 swh-web=> select last_modified_date from add_forge_request where id =1290; -[ RECORD 1 ]------+- last_modified_date |All these AFNR display
1/1/1970, 1:00:00 AMaslast_modified_date:afnr id 401 afnr last_modified_date afnr history last entry date 20250219033359 afnr id 467 afnr last_modified_date afnr history last entry date 20250219025924 afnr id 921 afnr last_modified_date afnr history last entry date 20250219040311 afnr id 1011 afnr last_modified_date afnr history last entry date 20250219035539 afnr id 1014 afnr last_modified_date afnr history last entry date 20250219035528 afnr id 1093 afnr last_modified_date afnr history last entry date 20250219035242 afnr id 1099 afnr last_modified_date afnr history last entry date 20250219035806 afnr id 1123 afnr last_modified_date afnr history last entry date 20250219030112 afnr id 1132 afnr last_modified_date afnr history last entry date 20250219035403 afnr id 1134 afnr last_modified_date afnr history last entry date 20250219032635 afnr id 1136 afnr last_modified_date afnr history last entry date 20250219032543 afnr id 1218 afnr last_modified_date afnr history last entry date 20250219022941 afnr id 1226 afnr last_modified_date afnr history last entry date 20250219021917 afnr id 1239 afnr last_modified_date afnr history last entry date 20250219043455 afnr id 1242 afnr last_modified_date afnr history last entry date 20250219045211 afnr id 1243 afnr last_modified_date afnr history last entry date 20250219045301 afnr id 1244 afnr last_modified_date afnr history last entry date 20250219045402 afnr id 1246 afnr last_modified_date afnr history last entry date 20250219045955 afnr id 1248 afnr last_modified_date afnr history last entry date 20250219051022 afnr id 1250 afnr last_modified_date afnr history last entry date 20250219051403 afnr id 1251 afnr last_modified_date afnr history last entry date 20250219051456 afnr id 1252 afnr last_modified_date afnr history last entry date 20250219051657 afnr id 1254 afnr last_modified_date afnr history last entry date 20250219052312 afnr id 1256 afnr last_modified_date afnr history last entry date 20250219052850 afnr id 1257 afnr last_modified_date afnr history last entry date 20250219053215 afnr id 1260 afnr last_modified_date afnr history last entry date 20250219053513 afnr id 1261 afnr last_modified_date afnr history last entry date 20250219053904 afnr id 1262 afnr last_modified_date afnr history last entry date 20250219054410 afnr id 1266 afnr last_modified_date afnr history last entry date 20250219091155 afnr id 1267 afnr last_modified_date afnr history last entry date 20250219061015 afnr id 1268 afnr last_modified_date afnr history last entry date 20250219061044 afnr id 1269 afnr last_modified_date afnr history last entry date 20250219061133 afnr id 1270 afnr last_modified_date afnr history last entry date 20250219075424 afnr id 1271 afnr last_modified_date afnr history last entry date 20250219062024 afnr id 1272 afnr last_modified_date afnr history last entry date 20250219062054 afnr id 1274 afnr last_modified_date afnr history last entry date 20250219062338 afnr id 1275 afnr last_modified_date afnr history last entry date 20250219062558 afnr id 1276 afnr last_modified_date afnr history last entry date 20250219062630 afnr id 1277 afnr last_modified_date afnr history last entry date 20250219075118 afnr id 1278 afnr last_modified_date afnr history last entry date 20250219062839 afnr id 1279 afnr last_modified_date afnr history last entry date 20250219063030 afnr id 1280 afnr last_modified_date afnr history last entry date 20250219063148 afnr id 1281 afnr last_modified_date afnr history last entry date 20250219063218 afnr id 1282 afnr last_modified_date afnr history last entry date 20250219063300 afnr id 1284 afnr last_modified_date afnr history last entry date 20250219064010 afnr id 1286 afnr last_modified_date afnr history last entry date 20250219064926 afnr id 1287 afnr last_modified_date afnr history last entry date 20250219071630 afnr id 1288 afnr last_modified_date afnr history last entry date 20250219072514 afnr id 1289 afnr last_modified_date afnr history last entry date 20250219072900 afnr id 1290 afnr last_modified_date afnr history last entry date 20250219073216 afnr id 1291 afnr last_modified_date afnr history last entry date 20250219073641
After tests in a local docker environment:
-
backup
swh-webdatabase:postgres@albertina:~$ ls -trl /var/lib/postgresql/pg_swh-web_20250219_100809.sql -rw-r--r-- 1 postgres postgres 438729801 Feb 19 10:08 /var/lib/postgresql/pg_swh-web_20250219_100809.sql -
update the
last_modified_date:ᐅ ./upgrade_afnr_date.sh > production_afnr_fix_last_modified_date.md
`production_afnr_fix_last_modified_date.md`
afnr_id 401 afn_check_date 20250219033359 update_msg UPDATE 1 afnr_id 467 afn_check_date 20250219025924 update_msg UPDATE 1 afnr_id 921 afn_check_date 20250219040311 update_msg UPDATE 1 afnr_id 1011 afn_check_date 20250219035539 update_msg UPDATE 1 afnr_id 1014 afn_check_date 20250219035528 update_msg UPDATE 1 afnr_id 1093 afn_check_date 20250219035242 update_msg UPDATE 1 afnr_id 1099 afn_check_date 20250219035806 update_msg UPDATE 1 afnr_id 1123 afn_check_date 20250219030112 update_msg UPDATE 1 afnr_id 1132 afn_check_date 20250219035403 update_msg UPDATE 1 afnr_id 1134 afn_check_date 20250219032635 update_msg UPDATE 1 afnr_id 1136 afn_check_date 20250219032543 update_msg UPDATE 1 afnr_id 1218 afn_check_date 20250219022941 update_msg UPDATE 1 afnr_id 1226 afn_check_date 20250219021917 update_msg UPDATE 1 afnr_id 1239 afn_check_date 20250219043455 update_msg UPDATE 1 afnr_id 1242 afn_check_date 20250219045211 update_msg UPDATE 1 afnr_id 1243 afn_check_date 20250219045301 update_msg UPDATE 1 afnr_id 1244 afn_check_date 20250219045402 update_msg UPDATE 1 afnr_id 1246 afn_check_date 20250219045955 update_msg UPDATE 1 afnr_id 1248 afn_check_date 20250219051022 update_msg UPDATE 1 afnr_id 1250 afn_check_date 20250219051403 update_msg UPDATE 1 afnr_id 1251 afn_check_date 20250219051456 update_msg UPDATE 1 afnr_id 1252 afn_check_date 20250219051657 update_msg UPDATE 1 afnr_id 1254 afn_check_date 20250219052312 update_msg UPDATE 1 afnr_id 1256 afn_check_date 20250219052850 update_msg UPDATE 1 afnr_id 1257 afn_check_date 20250219053215 update_msg UPDATE 1 afnr_id 1260 afn_check_date 20250219053513 update_msg UPDATE 1 afnr_id 1261 afn_check_date 20250219053904 update_msg UPDATE 1 afnr_id 1262 afn_check_date 20250219054410 update_msg UPDATE 1 afnr_id 1266 afn_check_date 20250219091155 update_msg UPDATE 1 afnr_id 1267 afn_check_date 20250219061015 update_msg UPDATE 1 afnr_id 1268 afn_check_date 20250219061044 update_msg UPDATE 1 afnr_id 1269 afn_check_date 20250219061133 update_msg UPDATE 1 afnr_id 1270 afn_check_date 20250219075424 update_msg UPDATE 1 afnr_id 1271 afn_check_date 20250219062024 update_msg UPDATE 1 afnr_id 1272 afn_check_date 20250219062054 update_msg UPDATE 1 afnr_id 1274 afn_check_date 20250219062338 update_msg UPDATE 1 afnr_id 1275 afn_check_date 20250219062558 update_msg UPDATE 1 afnr_id 1276 afn_check_date 20250219062630 update_msg UPDATE 1 afnr_id 1277 afn_check_date 20250219075118 update_msg UPDATE 1 afnr_id 1278 afn_check_date 20250219062839 update_msg UPDATE 1 afnr_id 1279 afn_check_date 20250219063030 update_msg UPDATE 1 afnr_id 1280 afn_check_date 20250219063148 update_msg UPDATE 1 afnr_id 1281 afn_check_date 20250219063218 update_msg UPDATE 1 afnr_id 1282 afn_check_date 20250219063300 update_msg UPDATE 1 afnr_id 1284 afn_check_date 20250219064010 update_msg UPDATE 1 afnr_id 1286 afn_check_date 20250219064926 update_msg UPDATE 1 afnr_id 1287 afn_check_date 20250219071630 update_msg UPDATE 1 afnr_id 1288 afn_check_date 20250219072514 update_msg UPDATE 1 afnr_id 1289 afn_check_date 20250219072900 update_msg UPDATE 1 afnr_id 1290 afn_check_date 20250219073216 update_msg UPDATE 1 afnr_id 1291 afn_check_date 20250219073641 update_msg UPDATE 1 -
mentioned in commit swh/devel/swh-web@3c40954c
mentioned in merge request swh/devel/swh-web!1391 (merged)
mentioned in commit swh/devel/swh-web@a80236e2
mentioned in commit swh/devel/swh-web@8c079d3b
@guillaume @ardumont unfortunately I mailed a few more AFNRs today and the last modified date got updated to 1970 again, since presumably the code changes above aren't deployed yet?
-
since presumably the code changes above aren't deployed yet?
Hello, no, we found out the bug in the code yesterday and fixed it.
Some other (unrelated) issues were being worked on at the time so it was not released immediately.
It's bundled in the v0.9.8 (which got released late yesterday evening).
We will deploy that new version soon.
Edited by Antoine R. Dumont
Backup
swh-webdatabase:postgres@albertina:~$ ls -trl /var/lib/postgresql/pg_swh-web_20250220_081045.sql -rw-r--r-- 1 postgres postgres 439147799 Feb 20 08:10 /var/lib/postgresql/pg_swh-web_20250220_081045.sqlCheck wrong AFNR
last_modified_date:ᐅ ./check_afnr_date.sh > production_afnr_check_last_modified_date.mdproduction_afnr_check_last_modified_date.md
afnr id 921 afnr last_modified_date afnr history last entry date 20250219154742 afnr id 1241 afnr last_modified_date afnr history last entry date 20250220074927 afnr id 1270 afnr last_modified_date afnr history last entry date 20250220024607 afnr id 1277 afnr last_modified_date afnr history last entry date 20250220044211 afnr id 1292 afnr last_modified_date afnr history last entry date 20250220032731 afnr id 1293 afnr last_modified_date afnr history last entry date 20250220033156 afnr id 1294 afnr last_modified_date afnr history last entry date 20250220033315 afnr id 1295 afnr last_modified_date afnr history last entry date 20250220033954 afnr id 1296 afnr last_modified_date afnr history last entry date 20250220034050 afnr id 1297 afnr last_modified_date afnr history last entry date 20250220034340 afnr id 1298 afnr last_modified_date afnr history last entry date 20250220034531 afnr id 1299 afnr last_modified_date afnr history last entry date 20250220034635 afnr id 1300 afnr last_modified_date afnr history last entry date 20250220041223 afnr id 1301 afnr last_modified_date afnr history last entry date 20250220035111 afnr id 1302 afnr last_modified_date afnr history last entry date 20250220035508 afnr id 1303 afnr last_modified_date afnr history last entry date 20250220035730 Fix wrong AFNR
last_modified_date:ᐅ ./upgrade_afnr_date.sh > production_afnr_fix_last_modified_date.mdproduction_afnr_fix_last_modified_date.md
afnr_id 921 afn_check_date 20250219154742 update_msg UPDATE 1 afnr_id 1241 afn_check_date 20250220081019 update_msg UPDATE 1 afnr_id 1257 afn_check_date 20250220081713 update_msg UPDATE 1 afnr_id 1270 afn_check_date 20250220024607 update_msg UPDATE 1 afnr_id 1277 afn_check_date 20250220044211 update_msg UPDATE 1 afnr_id 1292 afn_check_date 20250220032731 update_msg UPDATE 1 afnr_id 1293 afn_check_date 20250220033156 update_msg UPDATE 1 afnr_id 1294 afn_check_date 20250220033315 update_msg UPDATE 1 afnr_id 1295 afn_check_date 20250220033954 update_msg UPDATE 1 afnr_id 1296 afn_check_date 20250220034050 update_msg UPDATE 1 afnr_id 1297 afn_check_date 20250220034340 update_msg UPDATE 1 afnr_id 1298 afn_check_date 20250220034531 update_msg UPDATE 1 afnr_id 1299 afn_check_date 20250220034635 update_msg UPDATE 1 afnr_id 1300 afn_check_date 20250220041223 update_msg UPDATE 1 afnr_id 1301 afn_check_date 20250220035111 update_msg UPDATE 1 afnr_id 1302 afn_check_date 20250220035508 update_msg UPDATE 1 afnr_id 1303 afn_check_date 20250220035730 update_msg UPDATE 1 @pabs The fix has been deployed: #5578 (closed)
Edited by Guillaume SamsonThe
last_modified_dateis now correctly updated:ᐅ psql service=swh-web -At -c \ "select date from add_forge_request_history where request_id = 1290 order by date desc limit 1;" 2025-02-24 23:36:33.974751+00ᐅ psql service=swh-web -At -c \ "select last_modified_date from add_forge_request where id = 1290;" 2025-02-24 23:36:33.974751+00I close this issue.
Please register or sign in to reply