Один раз в сутки в одно и тоже время форум (версия 4.1.17.1) на пол часа падает с ошибкой 500.

 

В логах ошибка "Could not write to Store-FileSystem (rssFeeds)":

 

 

 

#0 /home/admin/web/domen.ru/public_html/system/Data/AbstractData.php(109): IPS\_Log::log('Could not write...', 'datastore')
#1 /home/admin/web/domen.ru/public_html/system/Data/Store.php(166): IPS\Data\_AbstractData->__set('rssFeeds', Array)
#2 /home/admin/web/domen.ru/public_html/applications/core/sources/Rss/Rss.php(444): IPS\Data\_Store->__set('rssFeeds', Array)
#3 /home/admin/web/domen.ru/public_html/system/Dispatcher/Front.php(168): IPS\core\_Rss::getAllFeeds()
#4 /home/admin/web/domen.ru/public_html/system/Dispatcher/Dispatcher.php(86): IPS\Dispatcher\_Front->init()
#5 /home/admin/web/domen.ru/public_html/index.php(13): IPS\_Dispatcher::i()
#6 {main}

 

 

SELECT * FROM `forums_forums` LEFT JOIN `core_permission_index` ON core_permission_index.app='forums' AND core_permission_index.perm_type='forum' AND core_permission_index.perm_type_id=forums_forums.id LEFT JOIN `core_members` ON core_members.member_id=forums_forums.last_poster_id WHERE min_posts_view<=0 AND (sub_can_post=0 OR can_view_others=1) AND (( FIND_IN_SET(2,perm_view) ) OR perm_view='*' ) ORDER BY position
IPS\Db\Exception: Got error 28 from storage engine (1030)
#0 /home/admin/web/domen.ru/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array)
#1 /home/admin/web/domen.ru/public_html/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#2 /home/admin/web/domen.ru/public_html/system/Node/Model.php(410): IPS\Db\_Select->rewind()
#3 /home/admin/web/domen.ru/public_html/applications/forums/sources/Forum/Forum.php(718): IPS\Node\_Model::loadIntoMemory('view', Object(IPS\Member), Array)
#4 /home/admin/web/domen.ru/public_html/applications/forums/modules/front/forums/forums.php(34): IPS\forums\_Forum::loadIntoMemory()
#5 /home/admin/web/domen.ru/public_html/system/Dispatcher/Controller.php(96): IPS\forums\modules\front\forums\_forums->manage()
#6 /home/admin/web/domen.ru/public_html/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#7 /home/admin/web/domen.ru/public_html/index.php(13): IPS\_Dispatcher->run()
#8 {main}

 

 

#0 /home/admin/web/domen.ru/public_html/init.php(508): IPS\_Log::log('SELECT * FROM `...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

 

 

 

 

Got error 28 from storage engine
SELECT * FROM `forums_forums` LEFT JOIN `core_permission_index` ON core_permission_index.app=? AND core_permission_index.perm_type=? AND core_permission_index.perm_type_id=forums_forums.id LEFT JOIN `core_members` ON core_members.member_id=forums_forums.last_poster_id WHERE min_posts_view<=? AND (sub_can_post=0 OR can_view_others=1) AND (( FIND_IN_SET(2,perm_view) ) OR perm_view=? ) ORDER BY position
Array
(
   [0] => forums
   [1] => forum
   [2] => 0
   [3] => *
)

| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| /system/Db/Db.php                                                          | [iPS\Db\_Exception].__construct                                               | 432               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Db/Select.php                                                      | [iPS\_Db].preparedQuery                                                       | 346               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Db/Select.php                                                      | [iPS\Db\_Select].runQuery                                                     | 408               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Node/Model.php                                                     | [iPS\Db\_Select].rewind                                                       | 410               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /applications/forums/sources/Forum/Forum.php                               | [iPS\Node\_Model].loadIntoMemory                                              | 718               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /applications/forums/modules/front/forums/topic.php                        | [iPS\forums\_Forum].loadIntoMemory                                            | 51                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Dispatcher/Controller.php                                          | [iPS\forums\modules\front\forums\_topic].manage                               | 96                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Content/Controller.php                                             | [iPS\Dispatcher\_Controller].execute                                          | 51                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /applications/forums/modules/front/forums/topic.php                        | [iPS\Content\_Controller].execute                                             | 40                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /system/Dispatcher/Dispatcher.php                                          | [iPS\forums\modules\front\forums\_topic].execute                              | 129               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| /index.php                                                                 | [iPS\_Dispatcher].run                                                         | 13                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

 

#0 /home/admin/web/domen.ru/public_html/system/Db/Exception.php(109): IPS\_Log::log('Got error 28 fr...', 'sql')
#1 /home/admin/web/domen.ru/public_html/system/Db/Db.php(432): IPS\Db\_Exception->__construct('Got error 28 fr...', 1030, NULL, 'SELECT * FROM `...', Array)
#2 /home/admin/web/domen.ru/public_html/system/Db/Select.php(346): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array)
#3 /home/admin/web/domen.ru/public_html/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
#4 /home/admin/web/domen.ru/public_html/system/Node/Model.php(410): IPS\Db\_Select->rewind()
#5 /home/admin/web/domen.ru/public_html/applications/forums/sources/Forum/Forum.php(718): IPS\Node\_Model::loadIntoMemory('view', Object(IPS\Member), Array)
#6 /home/admin/web/domen.ru/public_html/applications/forums/modules/front/forums/topic.php(51): IPS\forums\_Forum::loadIntoMemory()
#7 /home/admin/web/domen.ru/public_html/system/Dispatcher/Controller.php(96): IPS\forums\modules\front\forums\_topic->manage()
#8 /home/admin/web/domen.ru/public_html/system/Content/Controller.php(51): IPS\Dispatcher\_Controller->execute()
#9 /home/admin/web/domen.ru/public_html/applications/forums/modules/front/forums/topic.php(40): IPS\Content\_Controller->execute()
#10 /home/admin/web/domen.ru/public_html/system/Dispatcher/Dispatcher.php(129): IPS\forums\modules\front\forums\_topic->execute()
#11 /home/admin/web/domen.ru/public_html/index.php(13): IPS\_Dispatcher->run()
#12 {main}

 

 

 

 

Как устранить ошибку?

В логах ошибка "Could not write to Store-FileSystem (rssFeeds)":

Форум не может записать кеш rss (rssFeeds) на диске. Проверьте права на запись у /datastore/ а также свободное место на диске.

 

Got error 28 from storage engine (1030)

Ошибка "Got error 28 from storage engine" означает "не хватает места на диске". Такое может быть если закончилось свободное место либо при выполнения запроса mysql создает временный файл значительного размера.

Вот такие ошибки стали появляться:

 

UPDATE `core_advertisements` core_advertisements  SET ad_impressions=ad_impressions+1 WHERE ad_id IN(1,6,7,5) 
IPS\Db\Exception: Lock wait timeout exceeded; try restarting transaction (1205)
#0 /home/admin/web/domen.ru/public_html/system/Db/Db.php(991): IPS\_Db->preparedQuery('/*IPS\\core\\_Adv...', Array)
#1 /home/admin/web/domen.ru/public_html/applications/core/sources/Advertisement/Advertisement.php(305): IPS\_Db->update('`core_advertise...', 'ad_impressions=...', 'WHERE ad_id IN(...')
#2 /home/admin/web/domen.ru/public_html/system/Output/Output.php(755): IPS\core\_Advertisement::updateImpressions()
#3 /home/admin/web/domen.ru/public_html/system/Dispatcher/Dispatcher.php(149): IPS\_Output->sendOutput('\x1F\x8B\x08\x00\x00\x00\x00\x00\x00\x03\xED}{s\e...', 200, 'text/html', Array)
#4 /home/admin/web/domen.ru/public_html/system/Dispatcher/Standard.php(104): IPS\_Dispatcher->finish()
#5 /home/admin/web/domen.ru/public_html/system/Dispatcher/Front.php(528): IPS\Dispatcher\_Standard->finish()
#6 /home/admin/web/domen.ru/public_html/system/Dispatcher/Dispatcher.php(131): IPS\Dispatcher\_Front->finish()
#7 /home/admin/web/domen.ru/public_html/index.php(13): IPS\_Dispatcher->run()
#8 {main}

 

Форум тормозит.

 

Что это за ошибки?

Что это за ошибки?

Lock wait timeout exceeded