Nothing like a 3 hour update taking 18 hours. (though I suppose the + can mean 15hours...:P) Are we gonna find out what happened to the time space continuum?
rimcrazy Yea..........and 640K will be plenty of memory.......... And the world will only need 4 computers................... And no one would ever need a computer at home..............
Sheesh......where do they come up with this stuff?
A new one:
We will never have more than 16777215 comments.............
Run a program which sends out mass mails, or communicates with a server or does other actions then malicious people will write malicious code. Just because a virus cannot harm the operating system does not mean it is harmless.
Agreed on the points for the reindexing, but the database has been created to specification. As they said, its an oversight after converting years ago.
A few years ago I had to do a similar fix on the behemoth I inherited which used 16 bit index keys.
I personally think mysql handles slash really nicely and coupled with the open source foundations it stands on allows a lot more people to get systems up and running, moving to a proprietary database (even a free one) would exclude a lot of people from running their own site with slashcode.
Maybe there are enough database developers out there today who have been effected by this who could step up to the plate and fix mysql itself so it does have the required features. There are certainly enough geeks in here.
Theres no point in a problem being buried away down here - it needs highlighting so something can be done. I'm not sure if the dupes problem will ever come out, if infact the data value has been stored incorrectly in the database then the parent can never be restored. I suppose a quick way to find out is to actually find comment with id 16777215 and see how many replies its got...
It might simply be that a few of us are getting this problem, I notice on the bugs page there is reference to the database load balancing code, so it might be that our DB is the only one having a problem. I started noticing problems and comments early this morning.
I don't mind if they sell a base model without an operating system, but when companies sell products they should be able to support them. If its a hardware only sale then they support the hardware, if there is bundled software they better know how to support it.
They can put as many disclaimers as they like but its just going to bring bad vibes in when a user cannot boot up their computer which is DOA.
I am not a red herring but I am wrong (I'm more like an angry sea bass) I had outdated information on the cachability of hotmail mails (i posted an explanation a few minutes ago as a reply to my original post).
You are 100% correct about all the other methods and the only possible detail the spammer could require are the mail headers which are available on any device which downloads a view of the mail.
I fired IE6 up went to hotmail and read a mail. After closing its no longer there. They must have changed something fairly recently (ie since I started using firefox) because they used to be there for all to see.
Not quite nothing. If they start selling computers with Linux, they have to made damned sure they can support it - even if that support is a checklist leading upto a full system rebuild.
How would you feel if you bought a computer to find problems with it and being told to RTFM?
Currently at least dell support will attempt to help you get the machine you bought from them running.
Its the pigeons. Put gmail and squirrel on the same server accessing the same database and then see which is quicker. Until then you are comparing a large organisation specially towards sorting and extracting information against something you run on your home computer.
Slashdot Mirror
I was thinking the opposite.
If big business is trying to muscle in, then we should all run for the hills.
Is itsatrap relevant here?
I might be overreacting, and we already have one big benevolent overlord guiding us (the Vorlons ermmmmm I mean IBM), do we need others?
Update: 11/10 12:52 GMT by J : It's fixed.
:P)
Nothing like a 3 hour update taking 18 hours.
(though I suppose the + can mean 15hours...
Are we gonna find out what happened to the time space continuum?
You should call in Hiro Nakamura.
rimcrazy
Yea..........and 640K will be plenty of memory..........
And the world will only need 4 computers...................
And no one would ever need a computer at home..............
Sheesh......where do they come up with this stuff?
A new one:
We will never have more than 16777215 comments.............
Aren't most Syn/Ack floods just damned impatient users swamping a site after news breaks that its "under attack"? ;)
We are the main vehicle of a ddos
Run a program which sends out mass mails, or communicates with a server or does other actions then malicious people will write malicious code.
Just because a virus cannot harm the operating system does not mean it is harmless.
Still got no threading and its been over 7 hours.
You don't know how much you miss something until its gone do you?
Agreed on the points for the reindexing, but the database has been created to specification.
As they said, its an oversight after converting years ago.
A few years ago I had to do a similar fix on the behemoth I inherited which used 16 bit index keys.
I personally think mysql handles slash really nicely and coupled with the open source foundations it stands on allows a lot more people to get systems up and running, moving to a proprietary database (even a free one) would exclude a lot of people from running their own site with slashcode.
Maybe there are enough database developers out there today who have been effected by this who could step up to the plate and fix mysql itself so it does have the required features. There are certainly enough geeks in here.
[ Parent ]
If the data can be broken down into smaller more logical chunks, put it in a database and let your users get the data they require.
;)
make sure you use more than a 24bit key though
Save bandwidth, time and support headaches.
Its not a problem with counting, its the fact he used the lower case c for comments.
16777216 comments = 16 million rows.
16777216 Comments = nearly 17million rows.
Also, he could have used mibicomments to get the proper units and would have totally avoided this confusion.
Does this mean that comment id#16777215 has the longest thread in history?
Can anyone actually find it to see - I tried but could only get to 16777217, its likely to be in a journal or just a reply to an older article.
Theres no point in a problem being buried away down here - it needs highlighting so something can be done.
I'm not sure if the dupes problem will ever come out, if infact the data value has been stored incorrectly in the database then the parent can never be restored.
I suppose a quick way to find out is to actually find comment with id 16777215 and see how many replies its got...
It might simply be that a few of us are getting this problem, I notice on the bugs page there is reference to the database load balancing code, so it might be that our DB is the only one having a problem.
I started noticing problems and comments early this morning.
My god I haven't seen threadless articles in slash since I last delved into the real archives.
I think people aren't noticing it, but they will.
Damn annoying when a technical fault occurs, and no I don't know why its marked as troll either.
It appears as though the threading code has broken since the comments went over id 16777215 (ie limit of 24bit numbers)
The comments themselves are being added, but the internal link back to its parent has gone up the swanny.
Is a 24bit value an acceptable database field length or is this a code problem?
Top level comments only?
Its just eaten 2 comments, well they exist in my history but not in the flow.
There is a gremlin in the database.
hmmmm try again:
Yes there is an error, but why shouldn't CNN cover the completion of Vista
Slash just eaten my comment.
how bizarre, it exists but its not in the threadtree.
Yes there is an error, but why shouldn't CNN cover the completion of Vista?
This damned story has an advert with a spider at the top.
*shudder*
Contextual advertising or just fluke?
Don't mock this technology,
its the closest thing we have to enable stabbing someone in the face over the internet.
I don't mind if they sell a base model without an operating system, but when companies sell products they should be able to support them.
If its a hardware only sale then they support the hardware, if there is bundled software they better know how to support it.
They can put as many disclaimers as they like but its just going to bring bad vibes in when a user cannot boot up their computer which is DOA.
I am not a red herring but I am wrong (I'm more like an angry sea bass)
I had outdated information on the cachability of hotmail mails (i posted an explanation a few minutes ago as a reply to my original post).
You are 100% correct about all the other methods and the only possible detail the spammer could require are the mail headers which are available on any device which downloads a view of the mail.
It is all just a stalling tactic.
oooops
I just tried to put my money where my mouth was.
I fired IE6 up went to hotmail and read a mail.
After closing its no longer there.
They must have changed something fairly recently (ie since I started using firefox) because they used to be there for all to see.
Using Internet explorer (on windows...) go onto hotmail and read a few emails.
Then go into your internet cache and find the pages.
They exist.
Not quite nothing.
If they start selling computers with Linux, they have to made damned sure they can support it - even if that support is a checklist leading upto a full system rebuild.
How would you feel if you bought a computer to find problems with it and being told to RTFM?
Currently at least dell support will attempt to help you get the machine you bought from them running.
Its the pigeons.
Put gmail and squirrel on the same server accessing the same database and then see which is quicker.
Until then you are comparing a large organisation specially towards sorting and extracting information against something you run on your home computer.