General issues

[Josquius]

We beat the database software. Mission accomplished.

[mongers]

We beat the database software. Mission accomplished.

But, but,, , now I won't be able to post the traditional Fitness 202* in 5 months time. 

[DGuller]

How the hell could a thread ID hit the max number anyway?  That's a LOT of threads.

[mongers]

How the hell could a thread ID hit the max number anyway?  That's a LOT of threads.

I blame Timmay. 

[Crazy_Ivan80]

How the hell could a thread ID hit the max number anyway?  That's a LOT of threads.

Time to order new guids? 

(Yes, we actually convinced a former colleague that would be necessary. One of the reasons he's former)

[Baron von Schtinkenbutt]

How the hell could a thread ID hit the max number anyway?  That's a LOT of threads.

I'm still debugging the problem, but it's very strange.  We have far fewer threads than an a MySQL unisigned mediumint can handle.  Like, three orders of magnitude fewer.  I have no idea how the autoincrement sequence hit max value, or exactly what I can do to adjust it without breaking things.

[Maladict]

It looks like topic numbers jump from 167xx to 16777xxx

edit: sometime around October 2023

[Josquius]

Looks fixed.
Maladict's observation is the source?

edit- oh no, it isn't. I'm a liar.

[Baron von Schtinkenbutt]

Thanks Maladict.  I just took a quick look, and yeah for some reason the autoincrement sequence suddenly jumped ahead by over 16.6MM.  There are a few dozen older topic IDs that are out-of-sequence as well.  I think I can write a small program to edit the out-of-range indexes and reset the sequence to the new point.

[Baron von Schtinkenbutt]

Well, it's not going to be so simple.  The database schema doesn't have a proper foreign key setup, so I need to manually identify every table that references topic IDs and edit those columns as well.

[grumbler]

Well, it's not going to be so simple.  The database schema doesn't have a proper foreign key setup, so I need to manually identify every table that references topic IDs and edit those columns as well.

We* don't always show it, but we are grateful for the time and effort and money you have put into keeping this forum alive.


*even if only "the royal we."

[Jacob]

Agreed. Much obliged 

[HVC]

Meh I think you're just alright.



kidding, I too greatly appreciate it.