Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
I have a website using UBBT 6.1.1 , more than 14xxxx posts and 12xxx users , when I tried to upgrade to 6.2 , I found the step 9 takes toooooo much time.... I don't know why it takes so much time. I've waited for one hour in this step , and still waiting NOW.......

I am running tcpdump to observe what the hell is doing between my web and db server (via eth1) , and I found that it seems sending one query per second. Why use such this inefficient way ? It seems updating some column second by second.....

And in my db server , mysql daemon always stick to 99.9% of CPU time ....for at least one hour (not finished yet now...)


Is it normal ? How long should I wait ?

Anonymous
Unregistered
Anonymous
Unregistered
After upgrading to 6.2 , all users' receive box and sent box and favorite threads are LOST !!!

Although I can see how many messages in my receive box and sent box in login.php , but when I click to open the box , there is nothing......... <img border="0" title="" alt="[Mad]" src="images/icons/mad.gif" />

Anonymous
Unregistered
Anonymous
Unregistered
Sir - do you mean the PM's? Or does this effect personal content as well..

Rick was able to narrow this error down a bit and had this to say in a ticket I have open now:

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">It seems what happens is on some servers when the script takes took long it reloads the thing. So, the second pass through that code loop ends up setting all of the M_Sender fields to zero.
</font><hr /></blockquote><font size="" face="">I do have a solution if you would like to see it?

Regards,

Brett Harris
Infopop Corporation

Anonymous
Unregistered
Anonymous
Unregistered
Some people experienced a loss of PMs when the altertable timed out or soemthing.

Alot of user ids in the Private Messages and Address books got set to user ID 0.

If you don't have a backup to restore to, you can set the User IDs of the PMs to 1, at least the messages will show up. (It won't show who they are from though). Or you can delete the PM's with zeros as their IDs to get the PM counts in MY HOme correct.

This is a related thread with some info that might help:
http://community.infopop.net/6/ubb.x?a=tpc&s=729094322&f=6183028913&m=8023056096

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

Anonymous
Unregistered
Anonymous
Unregistered
I restored my backedup database......
But I am unwilling to do the altertable again....
If , there are a lot of PMs in the database , is there a SAFER way to upgrade to 6.2 ? It should avoid timeout problem....


[quote]Originally posted by JoshPet:
Some people experienced a loss of PMs when the altertable timed out or soemthing.

Alot of user ids in the Private Messages and Address books got set to user ID 0.

If you don't have a backup to restore to, you can set the User IDs of the PMs to 1, at least the messages will show up. (It won't show who they are from though). Or you can delete the PM's with zeros as their IDs to get the PM counts in MY HOme correct.

This is a related thread with some info that might help:
http://community.infopop.net/6/ubb.x?a=tpc&s=729094322&f=6183028913&m=8023056096

Josh
http://www.measurection.com Admin | http://www.threadsdev.com Moderator
Register to see my http://www.threadsdev.com/threads/php/postlist.php?Cat=&Board=library at ThreadsDev.com.
_My threads 'tweaking' abilities are ]http://www.joshuapettit.com_<HR></BLOCKQUOTE>

Anonymous
Unregistered
Anonymous
Unregistered
There is only the current method - why some servers are timing out and others are not and causing this condition is currently under investigation.

Anonymous
Unregistered
Anonymous
Unregistered
If you have a copy to play with and can try running the altertable locally. Not sure if the browser times out and restarts the process.

Or if you've got shell access and can run from the command line.

The result of the zeros seems to be indicating that the process is run more than once.

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by JoshPet:
Some people experienced a loss of PMs when the altertable timed out or soemthing.

Alot of user ids in the Private Messages and Address books got set to user ID 0.

If you don't have a backup to restore to, you can set the User IDs of the PMs to 1, at least the messages will show up. (It won't show who they are from though). Or you can delete the PM's with zeros as their IDs to get the PM counts in MY HOme correct.

This is a related thread with some info that might help:
http://community.infopop.net/6/ubb.x?a=tpc&s=729094322&f=6183028913&m=8023056096

Josh
http://www.measurection.com Admin | http://www.threadsdev.com Moderator
Register to see my http://www.threadsdev.com/threads/php/postlist.php?Cat=&Board=library at ThreadsDev.com.
_My threads 'tweaking' abilities are ]http://www.joshuapettit.com_</f... size="" face="">

Excuse the newbie question, but as the Administrator of a 6.1.1 site wanting to make the move to 6.2, what are PM's? <img border="0" title="" alt="[Roll Eyes]" src="images/icons/rolleyes.gif" />

Anything we should be aware of? We put up the 6.1.1 site just before Christmas, just moved everyone over from a Webbbs system, lots of grumblings. Would really hate to upset them at this point. Shoule we wait for a maintenance release ? <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Anonymous
Unregistered
Anonymous
Unregistered
PM's are "Private Messages"... sort of like email within the site. You can send and view Private Messages on the My Home screen.

Rick has updated the altertable script in 6.2 once or twice since release. I think it's better, as it's broken the big step into smaller quicker steps (which is safer).

If your board is new..... you might not have alot of Private Messages in the system anyway. IMO the Address book loss was no biggie either, uses can rebuild their Address Book.

I haven't lost any users or posts....that's the important part. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

Anonymous
Unregistered
Anonymous
Unregistered
Today (Feb/21) , I gave my ubbthreads 6.1.1 -> 6.2.2 a try....

BUT BUT BUT , IT TIMES OUT AT altertable-6.1-6.2.php?step=step9 AGAIN !!!

According to my observation (use TCPDUMP , listen to port 3306 on DB server) , it sends one SELECT/UPDATE per second !!! Why so inefficient ???

I have A LOT of PMs , (more than 100000 ) , how long should I wait to finish this step ?


I fell very disappointed .....

Anonymous
Unregistered
Anonymous
Unregistered
One interesting thing that Allen and I discovered the other night....

If your browser times out....
the process seems to continue on the server. Don't try again, or it gets corrupted.

If you have something like phpMyAdmin, you can watch the processes.... and watch them go until they all finish.. .then move on to the next step.

I think all the trouble comes from running the altertable more than once... then it'll lose who the PMs belong to.

Now the "official" word from Infopop is to disgard extra PMs before upgrade. I typically ditched everything older than 30 days prior to upgrades... and beyond the initial release... I never lost a PM with the updated altertable.

That said... 100,000 PMs is alot. Maybe your browser times out... and the server should conintue.. unless PHP times out on the server.
What it's doing at that point is looking at the name that was associated with the Message... looking up it's user number. Then assiging all the messages by user number.

It has to do this for sender and recipient for each private message.

<img border="0" title="" alt="[Eek!]" src="images/icons/shocked.gif" /> Wish there were a better answer.

My advice would be to let it do it's thing, and try to monitor for when it finishes.

I think if it can sucessfully run once (and only once) even if it times out in the browser... all will be fine. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.

Anonymous
Unregistered
Anonymous
Unregistered
You are right ,
thank you. I have waited for about 2 or 3 hours ,
and finally I found 'mysqld' load began to low. It seems the process has finished.

And I manually modify step9 to step10 , and finally finished the update process.... (no PMs lost)

It should be added to the notes...(in case somebody clicks step9 more than once)

Anonymous
Unregistered
Anonymous
Unregistered
I'll suggest that to Rick.....

Allen actually was the one to discover that it keeps going. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Thanks for letting us know it worked. <img border="0" title="" alt="[Big Grin]" src="images/icons/grin.gif" />

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)