Timeouts while updating from 3.0.0 to 3.0.1

[Hovik]

Hi friends, here is a copy of the page. Also my site is running very slow recently, I'm wondering if this has anything to do with the timeouts...

Code: Select all

Updating database to latest stable release


Database type :: mysql4
Previous version :: 3.0.0
Updated version :: 3.0.1




Updating database schema


Progress :: . . . . . Done
Result :: Some queries failed, the statements and errors are listing below. 

Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: ALTER TABLE `phpbb_forums` ADD COLUMN `display_subforum_list` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: DROP INDEX group_legend ON phpbb_groups


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: CREATE INDEX group_legend_name ON phpbb_groups(group_legend, group_name)




This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our support forums. See README for details on how to obtain advice.




Updating data


Progress :: . . . . . . . . . . . . . . . . . . . Done
Result :: Some queries failed, the statements and errors are listing below. 

Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 19 WHERE smiley_url = 'icon_e_surprised.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_eek.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_cool.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_lol.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_mad.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_razz.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_redface.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_cry.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_evil.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_twisted.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_rolleyes.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_exclaim.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_question.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_idea.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_arrow.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_neutral.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 15, smiley_height = 15 WHERE smiley_url = 'icon_mrgreen.gif'


Error :: Lock wait timeout exceeded; try restarting transaction
SQL :: UPDATE phpbb_smilies SET smiley_width = 19, smiley_height = 18 WHERE smiley_url = 'icon_e_ugeek.gif'




This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our support forums. See README for details on how to obtain advice.




Updating version and optimising tables


Progress :: . . Done
Result :: No errors



Update completed


The database update was successful. Now you need to continue the update process.

Continue the update process now


Fatal error: SQL ERROR [ mysql4 ]

Lock wait timeout exceeded; try restarting transaction [1205]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type) VALUES (1, '76.170.115.127', 1212366714, 'LOG_UPDATE_DATABASE', 'a:2:{i:0;s:5:\"3.0.0\";i:1;s:5:\"3.0.1\";}', 0)

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions.php
LINE: 2664
CALL: dbal_mysql->sql_query()

FILE: install/database_update.php
LINE: 1314
CALL: add_log()


in /usr/local/psa/home/vhosts/armenianancestry.com/httpdocs/phpbb/includes/db/dbal.php on line 593

any help would be much appreciated.
website: www.armenianancestry.com

[Pit$Bull]

You should contact your host about the 'slowness' and timeouts.

[Hovik]

You should contact your host about the 'slowness' and timeouts.

Tried that, according to them it's loading "fast". Did you try to go to my site and see how slow it takes a thread to load? this site is a rocketship compared to mine, and mine used to be like this too, I just don't know what happened.

[Pit$Bull]

Loads fast for me and I'm only on a 128k ISDN dialup connection.

[Hovik]

Loads fast for me and I'm only on a 128k ISDN dialup connection.

Yeah about 10 minutes after I got off the line w/ support it started to load faster. It's looking much better now, but I have a much bigger problem to deal w/ now. Every since the timeouts during the update from 3.0.0 to 3.0.1 I now am getting the message:

Code: Select all

This Board has no forums

This only happens when a regular member or moderator sign in, but not when I log in under my administrator account. Also if you are not logged in at all, the forums display fine... HELP, this is a big big problem.

[rhythm1]

no. It not a big big problem. Check the group permissions for mods.

[Hovik]

no. It not a big big problem. Check the group permissions for mods.

Yeah I realized this and came back to retract my last post, looks like you beat me to it. I must say it's flipping retarded that the permissions get reset when you attempt to update the forum... totally retarded.

Thanks for your help just the same.