Jump to content

Issues after server outage.


Dean Hamer

Recommended Posts

Afternoon,

 

I am having a few issues after a server outage, when looking at online users we get the following error:

SELECT COUNT(*) FROM `core_sessions` WHERE ( core_sessions.id IN('SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>'SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>? AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NULL GROUP BY `ip_address`' AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NOT NULL GROUP BY `member_id`') OR core_sessions.id IN(?) )
IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)
#0 /home/footbal9/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 /home/footbal9/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#2 /home/footbal9/public_html/system/Session/Store/Database.php(250): IPS\Db\_Select->first()
#3 /home/footbal9/public_html/applications/core/widgets/stats.php(94): IPS\Session\Store\_Database->getOnlineUsers(7)
#4 /home/footbal9/public_html/system/Widget/Widget.php(833): IPS\core\widgets\_stats->render()
#5 /home/footbal9/public_html/system/Widget/Widget.php(888): IPS\_Widget->_render()
#6 /home/footbal9/public_html/system/Theme/Theme.php(885) : eval()'d code(171): IPS\_Widget->__toString()
#7 /home/footbal9/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_cms_front_pages->widgetContainer('col1', Array, 'horizontal')
#8 /home/footbal9/public_html/applications/cms/sources/Theme/Theme.php(610) : eval()'d code(12): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array)
#9 /home/footbal9/public_html/applications/cms/sources/Pages/Page.php(2269): IPS\Theme\class_cms_page_page_builder->single_column(Object(IPS\cms\Pages\Page), Array)
#10 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(116): IPS\cms\Pages\_Page->output()
#11 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(43): IPS\cms\modules\front\pages\_page->view()
#12 /home/footbal9/public_html/system/Dispatcher/Controller.php(118): IPS\cms\modules\front\pages\_page->manage()
#13 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(33): IPS\Dispatcher\_Controller->execute()
#14 /home/footbal9/public_html/system/Dispatcher/Dispatcher.php(153): IPS\cms\modules\front\pages\_page->execute()
#15 /home/footbal9/public_html/index.php(13): IPS\_Dispatcher->run()
#16 {main}

Logging in to admin shows that:

Locked Task: userAgentStatistics

Locked Task: onlineusers

Locked Task: clearsessions

Are all unable to run, clicking run brings up the following error message:

Quote

2C124/2 The task is already running and cannot be ran until it has finished or the lock is removed.

 

Logging in to the dashboard shows this:

SELECT * FROM `core_sessions` WHERE ( core_sessions.id IN('SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>'SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>? AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NULL GROUP BY `ip_address`' AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NOT NULL GROUP BY `member_id`') OR core_sessions.id IN(?) ) ORDER BY core_sessions.running_time desc
IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)
#0 /home/footbal9/public_html/system/Db/Select.php(286): IPS\Db\_Select->runQuery()
#1 /home/footbal9/public_html/system/Session/Store/Database.php(253): IPS\Db\_Select->setKeyField('id')
#2 /home/footbal9/public_html/applications/core/extensions/core/Dashboard/OnlineUsers.php(52): IPS\Session\Store\_Database->getOnlineUsers(6, 'desc')
#3 /home/footbal9/public_html/applications/core/modules/admin/overview/dashboard.php(64): IPS\core\extensions\core\Dashboard\_OnlineUsers->getBlock()
#4 /home/footbal9/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\overview\_dashboard->manage()
#5 /home/footbal9/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#6 /home/footbal9/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#7 {main}

 

Anyone have any ideas?

Link to comment
Share on other sites

Your core_sessions table crashed, most likely caused by the server outage you mentioned:

Quote

IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)

You can repair the table from phpMyAdmin or a similar tool. If you are unsure on how to do it it's probably best if you ask your hosting for assistance instead.

Edited by teraßyte
Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...