Page 1 of 1

[Fixed] After installation the databse seems to freeze

Posted: 30. October 2008 10:10
by davaguco
Your Portal Version: 1.0.2
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Advanced Knowledge
Boardlink: http://www.forodelasrozas.com/pruebas

What have you done before the problem was there?
I have copied all the MOD files, edited the relevant files, I ran the install.php and everything seemed to have finished well. All this is on my test forum (fortunately).

However, now I can't access my test board. I can't even access mysql to see what happened to my test database.

I believe some wierd process started by the portal code has left my board inactive.


What have you already tryed to solve the problem?
As I can't access mysql or my board administration, I can't do much. Of course, I can always uninstall everything and delete the files (I have a backup of all the files) but before doing this I would like to know if there is a solution to my problem

Description and Message
I have copied all the MOD files, edited the relevant files, I ran the install.php and everything seemed to have finished well. All this is on my test forum (fortunately).

However, now I can't access my test board. I can't even access mysql to see what happened to my test database.

I believe some wierd process started by the portal code has left my board inactive.

Re: After installation the databse seems to freeze

Posted: 30. October 2008 10:19
by davaguco
I forgot to mention this forum is an exact copy of : http://www.forodelasrozas.com/foro/index.php

(without the portal MOD installed, of course).

Re: After installation the databse seems to freeze

Posted: 30. October 2008 11:33
by davaguco
I deleted all files, I copied the old backuped files, then I could access mysql. These are the processes running for a very long time:

proceso 2931122 forodelasrozas duffman.dreamhost.com:40374 rozas_pruebas Query 6334 Copying to tmp table SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_last_post_time, t.topic_tim
2931367 forodelasrozas duffman.dreamhost.com:52080 rozas_pruebas Query 6146 Locked UPDATE phpbb_users SET user_last_confirm_key = '29JH5MHHBC' WHERE user_id =4
2931399 forodelasrozas duffman.dreamhost.com:37124 rozas_pruebas Query 6123 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931408 forodelasrozas duffman.dreamhost.com:58761 rozas_pruebas Query 6107 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931410 forodelasrozas duffman.dreamhost.com:47741 rozas_pruebas Query 6104 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931420 forodelasrozas duffman.dreamhost.com:50705 rozas_pruebas Query 6096 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931426 forodelasrozas duffman.dreamhost.com:44977 rozas_pruebas Query 6086 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931440 forodelasrozas duffman.dreamhost.com:51503 rozas_pruebas Query 6073 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '433499537e6176122
2931461 forodelasrozas duffman.dreamhost.com:59972 rozas_pruebas Query 6059 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '69fdb8c564bc5fc7e
2931485 forodelasrozas duffman.dreamhost.com:57830 rozas_pruebas Query 6046 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2931838 forodelasrozas duffman.dreamhost.com:49491 rozas_pruebas Query 5775 Locked SELECT COUNT(*) FROM `rozas_pruebas`.`phpbb_users`
2933651 forodelasrozas duffman.dreamhost.com:57937 rozas_pruebas Query 4412 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2934673 forodelasrozas duffman.dreamhost.com:43932 rozas_pruebas Query 3719 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2934917 forodelasrozas duffman.dreamhost.com:45523 rozas_pruebas Query 3514 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2934968 forodelasrozas duffman.dreamhost.com:33216 rozas_pruebas Query 3447 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2934983 forodelasrozas duffman.dreamhost.com:47779 rozas_pruebas Query 3422 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2934997 forodelasrozas duffman.dreamhost.com:40501 rozas_pruebas Query 3405 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2935087 forodelasrozas duffman.dreamhost.com:33563 rozas_pruebas Query 3320 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '433499537e6176122
2935092 forodelasrozas duffman.dreamhost.com:48833 rozas_pruebas Query 3308 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2935175 forodelasrozas duffman.dreamhost.com:49764 rozas_pruebas Query 3202 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2935270 forodelasrozas duffman.dreamhost.com:46592 rozas_pruebas Query 3133 Locked SELECT * FROM phpbb_users WHERE user_id = 1
2935277 forodelasrozas duffman.dreamhost.com:46899 rozas_pruebas Query 3127 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '433499537e6176122

Re: After installation the databse seems to freeze

Posted: 30. October 2008 11:50
by davaguco
I am not sure but I think that when I copied the database I didnt copy the index definitions. So my test database is not an exact copy, it is missing the primary index on each table.

Re: After installation the databse seems to freeze

Posted: 30. October 2008 14:58
by davaguco
Everything is ok now, working fine.