Server logs for Fatal Error

Had a test site running fine for several weeks and not changed anything for over 2 weeks but got a Fatal Error. I wonder if any of you experts can tell me why from the server log... 

[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] PHP WARNING: 2012-10-20 15:20:18 (BST): "file_get_contents(/tmp/sess_04b1bpccljvpf8rkoeni2hbc02): failed to open stream: No such file or directory" in file /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php (line 551)
[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] Deprecated in 1.8: register_elgg_event_handler() was deprecated by elgg_register_event_handler() Called from [#6] /home/sites/thealbertinn.com/public_html/social_albert/mod/time/start.php:42
[Sat Oct 20 15:20:18 2012] [error] [client 212.113.35.162] Deprecated in 1.8: register_elgg_event_handler() was deprecated by elgg_register_event_handler() Called from [#6] /home/sites/thealbertinn.com/public_html/social_albert/mod/smart_theme/start.php:3
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Exception #1350742833: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] , referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] QUERY: SELECT * from elgg_users_entity where guid=115' in /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php:261, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Stack trace:, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #0 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(405): execute_query('SELECT * from e...', Resource id #55), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #1 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(366): elgg_query_runner('SELECT * from e...', '', true), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #2 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(30): get_data_row('SELECT * from e...'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #3 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(126): get_user_entity_as_row('115'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #4 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(64): ElggUser->load(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #5 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(644): ElggUser->__construct(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #6 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(697): entity_row_to_elggstar(Object(stdClass)), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #7 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(534): get_entity(115), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #8 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php(430): get_user(115), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #9 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(2121): _elgg_session_boot(), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #10 [internal function]: _elgg_engine_boot('boot', 'system', NULL), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #11 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(773): call_user_func_array('_elgg_engine_bo...', Array), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #12 /home/sites/thealbertinn.com/public_html/social_albert/engine/start.php(99): elgg_trigger_event('boot', 'system'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #13 /home/sites/thealbertinn.com/public_html/social_albert/index.php(12): require_once('/home/sites/the...'), referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] #14 {main}, referer: http://aidnabet.com/index
[Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] File does not exist: /home/sites/thealbertinn.com/public_html/social_albert/favicon.ico
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] Exception #1350742854: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] , referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] QUERY: SELECT * from elgg_users_entity where guid=115' in /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php:261, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] Stack trace:, referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #0 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(405): execute_query('SELECT * from e...', Resource id #55), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #1 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/database.php(366): elgg_query_runner('SELECT * from e...', '', true), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #2 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(30): get_data_row('SELECT * from e...'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #3 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(126): get_user_entity_as_row('115'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #4 /home/sites/thealbertinn.com/public_html/social_albert/engine/classes/ElggUser.php(64): ElggUser->load(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #5 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(644): ElggUser->__construct(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #6 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/entities.php(697): entity_row_to_elggstar(Object(stdClass)), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #7 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/users.php(534): get_entity(115), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #8 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/sessions.php(430): get_user(115), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #9 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(2121): _elgg_session_boot(), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #10 [internal function]: _elgg_engine_boot('boot', 'system', NULL), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #11 /home/sites/thealbertinn.com/public_html/social_albert/engine/lib/elgglib.php(773): call_user_func_array('_elgg_engine_bo...', Array), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #12 /home/sites/thealbertinn.com/public_html/social_albert/engine/start.php(99): elgg_trigger_event('boot', 'system'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #13 /home/sites/thealbertinn.com/public_html/social_albert/engine/handlers/action_handler.php(17): require_once('/home/sites/the...'), referer: http://community.thealbertinn.com/activity
[Sat Oct 20 15:20:54 2012] [error] [client 146.90.159.44] #14 {main}, referer: http://community.thealbertinn.com/activity

 

Thanks

  • this looks suspect to me, is that a deleted user?

     [Sat Oct 20 15:20:33 2012] [error] [client 146.90.159.44] Exception #1350742833: exception 'DatabaseException' with message 'Table './web53@002dnawtnet/elgg_users_entity' is marked as crashed and should be repaired, referer: http://aidnabet.com/index

  • Like Steve pointed out, you need to repair your database tables. This should be an option in your database management interface if you don't know how to do it manually.

  • Thanks Steve & Bret... I'm on shared hosting and the MySQL database can be managed via phpMyAdmin. I can see that 2 tables...

    elgg_users_entity

    elgg_users_sessions

    Both are listed as "IN USE" unlike any other table and if I select either of them it states in RED...

    "marked as crashed and should be repaired" but I cannot find any method to repair them. Any ideas anyone?

  • I have read many times on here "keep out of the database" Should I be worried? :)

  • Go to phpmyadmin > select the db > in the bottom. you will see a link called select all (click that) > next to that there is a pull down showing with the selected, select an action > Select repair option. Thats it. 

  • @TW... SpotOn thanks. 

    One more Q... Most tables in the DB are TYPE - MyISAM,  Collation - utf8_general_ci

    But a couple are TYPE - MEMORY,  Collation - latin1_swedish_ci

    Why is that when my website is English (UK)?

  • Oh, any clues to how the DB crashed would be helpful.

  • I've never been able to pinpoint how tables crash under normal situations, but power outages/OS crashes can break them.

    Table charset has nothing to do with the language of the content, though collation can affect sorting strings.

  • Thanks everyone, great support.