Modern Vespa

I'm going to switch to an updated version of the server, which mostly involves pointing the IP address at a different server. The new server has an out of date SSL certificate, so for a brief few minutes (if you can see the server at all) your browser is likely to warn you that MV is unsafe, or has an expired certificate, or some equally misguided message.

Hopefully this will only take a few minutes.

Okay, that went as planned, and we were only down briefly.

Yet I still have this nagging suspicion that I've forgotten some critical step -- I haven't actually switched server instances in over a year, I'm a little rusty.

Certificate only valid for six months, or will you be swapping back to thing one?

Usually, I renew the certificate in situ. It's a single command (plus restarting apache) and it happens in under a minute.

In this case, I made changes to the test server (which did not / usually does not have a current cert) and then minted a server image from the test server. I then used that image to spin up a new production server, which meant that the certificate was going to be out of date, briefly.

Unfortunately, I can't renew the certificate while running as a test server, because the certbot renewal script goes through a challenge process that involves connecting to the server at the address specified in the certificate, which isn't the address that the test server resides at. So... yeah.

All very arcane.

The long and short of it is that I had no good alternatives except to bring up a production server that would briefly have an out of date certificate.

Gotcha, thanks.

There's likely another service interruption on the horizon, as I need to migrate the database to a new instance. That will require the site to be down for an hour or so -- quite a bit longer than the brief blip we had today.

We are currently running MySQL 5.7, which will reach end-of-life in October 2023. I did a test migration today (on an alternate instance) to MariaDB, running on ARM instead of Intel. It went surprisingly well.

I'll let you all know when I'm going to pull the plug, and give you more notice too. At this time of year, the user count is way down anyway, so this is probably the optimal time to do it.

Hey Jess... Search function seems broken, sorry man.


General Error
Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '1448387537' for key 'PRIMARY'

INSERT INTO phpbb_search_results (search_id, session_id, search_time, search_array) VALUES(1448387537, 'cbca81171e9702e21eee3c12b99aa006', 1670127223, 'a:7:{s:14:"search_results";s:3645:"7695, 21856, 75270, 75979, 76162, 76470, 91063, 94935, 112184, 115902, 123613, 125168, 136450, 143377, 144439, 153101, 153599, 154730, 162203, 163920, 164163, 166807, 167187, 167266, 167348, 167552, 167647, 167652, 167656, 167809, 169491, 170073, 171457, 172135, 172283, 172498, 172877, 172883, 172901, 173059, 173066, 173100, 173149, 173181, 173183, 173193, 173669, 173949, 175666, 175758, 175850, 175928, 176471, 176721, 176809, 176890, 176946, 176959, 177182, 177244, 177253, 177294, 177308, 177372, 177402, 177403, 177446, 177447, 177469, 177483, 177484, 177487, 177493, 177499, 177501, 177540, 177546, 177571, 177599, 177603, 177622, 177626, 177659, 177679, 177775, 177800, 177841, 177851, 177869, 177897, 177912, 177960, 177970, 177979, 178001, 178003, 178013, 178015, 178017, 178018, 178019, 178024, 178057, 178065, 178066, 178067, 178074, 178077, 178084, 178097, 178103, 178104, 178108, 178113, 178117, 178119, 178137, 178145, 178166, 178170, 178177, 178195, 178201, 178205, 178206, 178213, 178214, 178217, 178232, 178248, 178254, 178257, 178263, 178276, 178277, 178310, 178317, 178319, 178321, 178322, 178323, 178325, 178342, 178343, 178347, 178350, 178352, 178355, 178358, 178364, 178377, 178383, 178384, 178405, 178415, 178444, 178455, 178458, 178461, 178478, 178480, 178481, 178489, 178493, 178503, 178517, 178551, 178552, 178561, 178573, 178581, 178585, 178590, 178592, 178597, 178602, 178620, 178633, 178646, 178657, 178669, 178672, 178686, 178688, 178695, 178696, 178718, 178721, 178722, 178723, 178726, 178735, 178737, 178739, 178744, 178748, 178750, 178751, 178752, 178764, 178786, 178788, 178810, 178821, 178825, 178838, 178870, 178890, 178902, 178904, 178915, 178918, 178926, 178929, 178932, 178942, 178959, 178964, 178971, 178974, 178978, 178991, 178993, 179004, 179005, 179016, 179020, 179023, 179041, 179056, 179065, 179069, 179072, 179162, 179204, 179218, 179253, 179283, 179297, 179298, 179303, 179309, 179310, 179328, 179364, 179375, 179377, 179392, 179398, 179466, 179475, 179494, 179538, 179556, 179571, 179594, 179640, 179644, 179687, 179718, 179746, 179749, 179765, 179800, 179818, 179828, 179849, 179888, 179892, 179901, 179923, 179955, 179977, 180003, 180009, 180036, 180039, 180047, 180079, 180131, 180149, 180165, 180200, 180244, 180259, 180264, 180302, 180335, 180338, 180392, 180397, 180398, 180404, 180412, 180444, 180453, 180460, 180463, 180472, 180487, 180497, 180508, 180512, 180516, 180518, 180540, 180543, 180547, 180552, 180571, 180591, 180609, 180668, 180729, 180753, 180771, 180776, 180789, 180809, 180811, 180847, 180855, 180862, 180901, 180908, 180910, 180921, 180954, 180968, 181041, 181045, 181095, 181122, 181137, 181140, 181142, 181162, 181184, 181188, 181211, 181240, 181242, 181244, 181277, 181278, 181290, 181301, 181310, 181318, 181328, 181329, 181335, 181336, 181342, 181345, 181353, 181354, 181355, 181378, 181382, 181388, 181407, 181422, 181430, 181473, 181479, 181489, 181523, 181525, 181530, 181533, 181546, 181577, 181578, 181582, 181584, 181587, 181640, 181647, 181664, 181681, 181683, 181692, 181713, 181718, 181721, 181730, 181760, 181764, 181768, 181805, 181847, 181866, 181869, 181880, 181891, 181902, 181907, 181908, 181938, 181948, 181970, 181971, 181983, 181986, 182015, 182020, 182023, 182028, 182029, 182043, 182049, 182067, 182068, 182097, 182103, 182533, 182617, 182633, 182676, 182680, 182691, 182692, 182707, 182723, 182733, 182741, 182757, 182758, 182762, 182763, 182776, 182783, 182785, 182804, 182822, 182828, 182840, 182850, 182851, 182877, 182882, 182888, 182895, 182900, 182904, 182906, 182965, 182966, 182967, 182968, 182986, 183006, 183009, 183017, 183051, 183070";s:17:"total_match_count";i:457;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 759
File : search.php

PS: I know there's a thread somewhere in here, specifically made for reporting errors on the site...

but I couldn't find it...

on account of...

Well, you know...

Yeah, this is a long-standing problem that I've been unable to resolve. It generally only affects one person at a time, and then only for a while. It'll work itself out.

Sorry I don't have a better answer.

And just like that, it's working again!
Just gotta mention it to IT and it fixes itself. Typical lol

Was Entomologist the badge you alluded in my thread last week? https://modernvespa.com/forum/post2584822#2584822

Nope. The Molto Verboso badge. Now that you've hit 1005 posts, you are eligible.

But there's a secret.

I actually have a reproducible case now. Searches are slow, giving plenty of time to second-guess whether one actually clicked the 'search' button or not. If I deliberately hit the 'search' button more than once, I get the error, but not until the next time I do a search (assuming a short time between searches).

Not sure if this is how everyone else is triggering it, but it is at least one way to trigger it, and that might be enough to work up a fix.

In my case, I had to wash my windshield.

If that's what it takes...

Believe me, it's a big deal.