Admin area not loading.

alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Admin area not loading.

Post by alexscj »

Hello,

after updating to the latest version (201310031102), I can' load the admin area for some reason (the page just loads for a long time and eventually drives the server in kernel panic mode).

Same thing if I run manually:

-bash-3.2$ php index.php

it doesn't do anything nor display any errors.

Any idea what could be wrong?

Please note the default version 1.49 of SCJ (from the current install_scj.php) works perfectly along with other 1.50 SCJ instances (latest version on server 201306170843).
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Admin area not loading.

Post by admin »

Did you try to run update again ?
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Admin area not loading.

Post by alexscj »

Yes, also reinstalled and re-updated, didn't help.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Admin area not loading.

Post by admin »

I have no idea, PM ssh access, i'll figure it out.
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Admin area not loading.

Post by alexscj »

SSH info sent, thanks.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Admin area not loading.

Post by admin »

DB server is overloaded, any query to that DB takes few seconds ...
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Admin area not loading.

Post by alexscj »

Thanks for checking, I'll investigate the DB server issue.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Admin area not loading.

Post by admin »

NP
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Admin area not loading.

Post by alexscj »

Wanted to follow up on this for future reference.

Checked the DB server with the host support and everything is ok, including the server load, the disk load etc.

I watched the mysql db processes related to the problematic SCJ install while waiting (in vain) for the SCJ admin page to load:

Query 26 NULL CHECK TABLE admin_sessions

I've noticed State: NULL for the query. Researched a bit and it seems it's a msql bug.

Converting the admin_sessions table from the default Inno_DB to MyISAM solved the problem and the SCJ admin area loads fine now.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Admin area not loading.

Post by admin »

Great, but do you have all updates ?
I remember fixing that innodb problem.
Don't forget to run script update
Post Reply