Okay folks, server is going down. EDIT: We’re back!
Post Reply    Forum -> General Discussion
Author Message
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Sun May 02, 2021 5:00 pm quote
Be back in a few hours, I hope.
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Sun May 02, 2021 7:12 pm quote
So, the database upgrade did not go quite as planned. I had to roll back to the original and then make a few of the lesser mods that I had planned, but not the big MySQL version upgrade.

Anyway, we’re back.
Veni, Vidi, Posti
LX190, Primavera
Joined: 12 Oct 2007
Posts: 7009
Location: New Zealand
Sun May 02, 2021 7:17 pm quote
Yay!
Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: 21 Jul 2007
Posts: 5635
Location: Latina (Italy)
Mon May 03, 2021 12:48 am quote
The best thing about this change is that Jess came back to us more often, I felt like someone whose closest relative had gone far and you saw him every now and then.
With gratitude
Attilio Ferrari aka Attila
Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: 21 Jul 2007
Posts: 5635
Location: Latina (Italy)
Mon May 03, 2021 1:01 am quote
Jess .... does not make me edit the posts after entering them, I need it for grammar corrections otherwise I write bullshit.
Moderator
VNB VSC VBC VSX
Joined: 28 May 2008
Posts: 4835
Location: Hustletown, TX
Mon May 03, 2021 5:51 am quote
^^^
Agreed. I noticed the same.
(The edit feature isn't functional... not that you write bullshit.)
Hooked
2013 BV350
Joined: 24 Jul 2011
Posts: 369
Location: Sacramento, California
Mon May 03, 2021 6:32 am quote
Hi Jess!

I'm glad to discover that you are still with us and keeping busy. I've used this site and owned three scoots since discovering MV. Thanks to this site, I've learned so much to drive safely and maintain (yup, I wrench.) scoots. Thanks for everything.

Mark
Mr F.
Veni, Vidi, Posti
2007 LX150 2015 GTS 2013 BV 350
Joined: 13 Sep 2012
Posts: 9784
Location: Fond du Lac, Wisconsin
Mon May 03, 2021 7:35 am quote
Birdsnest wrote:
^^^
Agreed. I noticed the same.
(The edit feature isn't functional... not that you write bullshit.)
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 8:11 am quote
Sorry, folks! I busted the Lambretta.

Trying to figure out what went wrong.
Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: 21 Jul 2007
Posts: 5635
Location: Latina (Italy)
Mon May 03, 2021 9:07 am quote
Indeed it seems that the expression on your avatar's face has changed ...
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 9:52 am quote
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
Ossessionato
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: 16 Jan 2010
Posts: 3777
Location: Tempe, AZ
Mon May 03, 2021 10:26 am quote
Nice picture of Patrick. Good to see him pop up too.
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 10:28 am quote
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
Ossessionato
GTS300 Super (Heinz) GTS250 Super (Bulger)
Joined: 16 Jan 2010
Posts: 3777
Location: Tempe, AZ
Mon May 03, 2021 11:09 am quote
jess wrote:
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
Good one. I noticed the two-time Cannomball SYM in the background too. I'd bet Patrick could'a done it!
Veni, Vidi, Posti
Neutrino MP3 492.7 AK, 2013 Moto Guzzi Norge
Joined: 29 Mar 2008
Posts: 21794
Location: Harriman, Tennessee, Tn
Mon May 03, 2021 11:54 am quote
wow its slower now than before
Veni, Vidi, Posti
Neutrino MP3 492.7 AK, 2013 Moto Guzzi Norge
Joined: 29 Mar 2008
Posts: 21794
Location: Harriman, Tennessee, Tn
Mon May 03, 2021 1:43 pm quote
speed has picked up ALOT. thank you
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 1:44 pm quote
old as dirt wrote:
speed has picked up ALOT. thank you
Fingers crossed. I am not entirely sure this is going to continue to function.
Veni, Vidi, Posti
LX190, Primavera
Joined: 12 Oct 2007
Posts: 7009
Location: New Zealand
Mon May 03, 2021 2:41 pm quote
jess wrote:
Syd wrote:
Nice picture of Patrick. Good to see him pop up too.
Here's the back story for that picture: MP4-500 Project
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 2:54 pm quote
znomit wrote:
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
Which isn't even in the MP3 section. Errrm, this is awkward.
Veni, Vidi, Posti
LX190, Primavera
Joined: 12 Oct 2007
Posts: 7009
Location: New Zealand
Mon May 03, 2021 3:08 pm quote
jess wrote:
znomit wrote:
I was going to suggest deleting the MP3 forum might help tidy things up , but it does have that one redeeming post.
Which isn't even in the MP3 section. Errrm, this is awkward.
Maybe consult MV-Bot for neutral advice?
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 3:15 pm quote
znomit wrote:
Maybe consult MV-Bot for neutral advice?
MV-Bot is neutral in the same way that a hand grenade is neutral.
Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2012 Honda NC700 DCT, 2014 Can Am Spyder RT
Joined: 02 Mar 2013
Posts: 6409
Location: Madison, Wisconsin
Mon May 03, 2021 5:04 pm quote
jess wrote:
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
Huh. Your post doesn't indicate that it was edited. I'd swear I saw that in the past.....

So here's me editing it to see if it says it was edited.. 3...2...1...

Nope, no indication it was edited. Commence chaos...

And, edit...

Last edited by Madison Sully on Mon May 03, 2021 5:29 pm; edited 1 time in total
Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2012 Honda NC700 DCT, 2014 Can Am Spyder RT
Joined: 02 Mar 2013
Posts: 6409
Location: Madison, Wisconsin
Mon May 03, 2021 5:07 pm quote
jess wrote:
znomit wrote:
Maybe consult MV-Bot for neutral advice?
MV-Bot is neutral in the same way that a hand grenade is neutral.
Um, so, who exactly "throws" MV-Bot then?
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 5:18 pm quote
Madison Sully wrote:
Nope, no indication it was edited. Commence chaos...
It only shows "edited" if it gets edited after someone replies to it. If it's the last reply in the topic, then the edited tag doesn't get applied.
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Mon May 03, 2021 5:19 pm quote
Madison Sully wrote:
Um, so, who exactly "throws" MV-Bot then?
It's a mystery. I mostly don't even know. I think the moderators change her password whenever they need her to post.
Veni, Vidi, Posti
MP3 500, GTS 250 (both 2008 MY), 2012 Honda NC700 DCT, 2014 Can Am Spyder RT
Joined: 02 Mar 2013
Posts: 6409
Location: Madison, Wisconsin
Mon May 03, 2021 5:30 pm quote
Madison Sully wrote:
jess wrote:
Well that was no fun.

I upgraded the database last night. Specifically, I changed all MyISAM tables (which are ancient and largely unsupported) to InnoDB. Which makes sense, right?

Except that InnoDB supports ROLLBACK, and so does the forum software. Unbeknownst to me, though, there was a SQL transaction that's been failing pretty much constantly because (drumroll...) I removed all the banners, and the banner stats code can't cope with updating empty stats. Which triggered a rollback on editing posts.

If you're not following this, don't worry. It's ridiculously complicated and also ridiculously absurd.

I think it's fixed now, but there's a strong chance there are more errant SQL queries that will trigger a ROLLBACK in the database. I am logging them now and will keep an eye on it.

Thanks again for your patience.

EDIT: Editing to add that I am editing this post. Heh.
Huh. Your post doesn't indicate that it was edited. I'd swear I saw that in the past.....

So here's me editing it to see if it says it was edited.. 3...2...1...

Nope, no indication it was edited. Commence chaos...

And, edit...
Crap, chaos averted.
Veni, Vidi, Posti
In garage: Yamaha Tricity 155 Urban 2019 - MV Agusta 125 RS 1956
Joined: 21 Jul 2007
Posts: 5635
Location: Latina (Italy)
Mon May 03, 2021 10:50 pm quote
My IT experience is limited to the knowledge and use of CAD / CAM programs for mechanics and woodworking for furnishings. Ask me to disassemble and reassemble an engine and I will do it but with a PC more likely I washed it down with gasoline to set it on fire.
Petty Tyrant
GTS250 GTS300 MP3 500
Joined: 11 Oct 2005
Posts: 30070
Location: Bay Area, California
Tue May 04, 2021 5:59 am quote
Attila wrote:
Ask me to disassemble and reassemble an engine and I will do it but with a PC more likely I washed it down with gasoline to set it on fire.
I am a professional software engineer, and if I'm honest there are days that I would do the same.
  DoubleGood Vespa T-Shirts  
Post Reply    Forum -> General Discussion
[ Time: 0.0376s ][ Queries: 25 (0.0199s) ][ Debug on ][ Thing Two ]