Skocz do zawartości
  • Zarejestruj się
  • 0
drifter

Błędy mysql Prepared statement (1615)

Pytanie

Witam,

Mam ciągłe błędy mysql w logach błędy są codziennie i wyglądają mniej więcej tak na poniżej.

Dzisiaj już jest plik 2500 linijek z błędami.

Często na forum pojawia się błąd 500 może mieć coś wspólnego z tym mysql? 


Wed, 09 Jan 2019 06:10:51 +0000
SELECT cache_value FROM `ipb_core_cache` AS `core_cache` WHERE cache_key='page_3dacf28a8580db3631a7aea5b4c7951d_3_' AND cache_expire>1547014251
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/ht9806/__forum__public/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT cache_va...', Array, true)
#1 /home/ht9806/__forum__public/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 /home/ht9806/__forum__public/system/Db/Select.php(361): IPS\Db\_Select->rewind()
#3 /home/ht9806/__forum__public/system/Data/Cache/None.php(119): IPS\Db\_Select->first()
#4 /home/ht9806/__forum__public/system/Dispatcher/Front.php(429): IPS\Data\Cache\_None->getWithExpire('page_3dacf28a85...', true)
#5 /home/ht9806/__forum__public/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached()
#6 /home/ht9806/__forum__public/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init()
#7 /home/ht9806/__forum__public/index.php(13): IPS\_Dispatcher::i()
#8 {main}
#0 /home/ht9806/__forum__public/init.php(537): IPS\_Log::log('SELECT cache_va...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

-------------

Wed, 09 Jan 2019 12:04:53 +0000
SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ipb_forums_topics` AS `forums_topics`  LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id  LEFT JOIN `ipb_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums;',forums_topics.tid))  LEFT JOIN `ipb_core_members` AS `author` ON author.member_id = forums_topics.starter_id  LEFT JOIN `ipb_core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_topics.starter_id=885 AND forums_topics.state != 'link' AND forums_topics.state != 'draft' AND ( forums_forums.can_view_others=1 OR forums_topics.starter_id=0 ) AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(55,51,112,52,53,54,59,67,68,69,60,61,62,63,64,27,32,31,30,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,28,136,115,50,49,48,29,83,84,21,22,23,24,25,26,56,57,58,137,139,141,144,145,147,148,150,151,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213) ORDER BY start_date desc LIMIT 0,25
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/ht9806/__forum__public/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT forums_t...', Array, true)
#1 /home/ht9806/__forum__public/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [internal function]: IteratorIterator->rewind()
#4 /home/ht9806/__forum__public/system/Helpers/Table/Content.php(286): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#5 /home/ht9806/__forum__public/system/Helpers/Table/Table.php(485): IPS\Helpers\Table\_Content->getRows(Array)
#6 /home/ht9806/__forum__public/applications/core/modules/front/members/profile.php(575): IPS\Helpers\Table\_Table->__toString()
#7 /home/ht9806/__forum__public/system/Dispatcher/Controller.php(85): IPS\core\modules\front\members\_profile->content()
#8 /home/ht9806/__forum__public/applications/core/modules/front/members/profile.php(65): IPS\Dispatcher\_Controller->execute()
#9 /home/ht9806/__forum__public/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\members\_profile->execute()
#10 /home/ht9806/__forum__public/index.php(13): IPS\_Dispatcher->run()
#11 {main}
#0 /home/ht9806/__forum__public/init.php(537): IPS\_Log::log('SELECT forums_t...', 'uncaught_except...')
#1 /home/ht9806/__forum__public/system/Helpers/Table/Table.php(553): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 /home/ht9806/__forum__public/applications/core/modules/front/members/profile.php(575): IPS\Helpers\Table\_Table->__toString()
#3 /home/ht9806/__forum__public/system/Dispatcher/Controller.php(85): IPS\core\modules\front\members\_profile->content()
#4 /home/ht9806/__forum__public/applications/core/modules/front/members/profile.php(65): IPS\Dispatcher\_Controller->execute()
#5 /home/ht9806/__forum__public/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\members\_profile->execute()
#6 /home/ht9806/__forum__public/index.php(13): IPS\_Dispatcher->run()
#7 {main}

-------------

Wed, 09 Jan 2019 12:04:58 +0000
SELECT cache_value FROM `ipb_core_cache` AS `core_cache` WHERE cache_key='page_31200d752d1b68313602a902586c91f2_3_' AND cache_expire>1547035498
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/ht9806/__forum__public/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT cache_va...', Array, true)
#1 /home/ht9806/__forum__public/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 /home/ht9806/__forum__public/system/Db/Select.php(361): IPS\Db\_Select->rewind()
#3 /home/ht9806/__forum__public/system/Data/Cache/None.php(119): IPS\Db\_Select->first()
#4 /home/ht9806/__forum__public/system/Dispatcher/Front.php(429): IPS\Data\Cache\_None->getWithExpire('page_31200d752d...', true)
#5 /home/ht9806/__forum__public/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached()
#6 /home/ht9806/__forum__public/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init()
#7 /home/ht9806/__forum__public/index.php(13): IPS\_Dispatcher::i()
#8 {main}
#0 /home/ht9806/__forum__public/init.php(537): IPS\_Log::log('SELECT cache_va...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

-------------

Wed, 09 Jan 2019 12:05:08 +0000
SELECT cache_value FROM `ipb_core_cache` AS `core_cache` WHERE cache_key='page_aae3b3357f00239142428d02ddf04fc9_3_' AND cache_expire>1547035508
IPS\Db\Exception: Prepared statement needs to be re-prepared (1615)
#0 /home/ht9806/__forum__public/system/Db/Select.php(378): IPS\_Db->preparedQuery('SELECT cache_va...', Array, true)
#1 /home/ht9806/__forum__public/system/Db/Select.php(440): IPS\Db\_Select->runQuery()
#2 /home/ht9806/__forum__public/system/Db/Select.php(361): IPS\Db\_Select->rewind()
#3 /home/ht9806/__forum__public/system/Data/Cache/None.php(119): IPS\Db\_Select->first()
#4 /home/ht9806/__forum__public/system/Dispatcher/Front.php(429): IPS\Data\Cache\_None->getWithExpire('page_aae3b3357f...', true)
#5 /home/ht9806/__forum__public/system/Dispatcher/Front.php(38): IPS\Dispatcher\_Front->checkCached()
#6 /home/ht9806/__forum__public/system/Dispatcher/Dispatcher.php(103): IPS\Dispatcher\_Front->init()
#7 /home/ht9806/__forum__public/index.php(13): IPS\_Dispatcher::i()
#8 {main}
#0 /home/ht9806/__forum__public/init.php(537): IPS\_Log::log('SELECT cache_va...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

 

 

Screenshot_26.png

Screenshot_27.png

Udostępnij ten post


Link to postu
Udostępnij na innych stronach

3 odpowiedzi na to pytanie

Polecane posty

  • 0

Którą masz wersję MySQL? to jest problem po stronie bazy danych nie oprogramowania, ale powodów może być kilka

  • Like 1

Udostępnij ten post


Link to postu
Udostępnij na innych stronach
  • 0
9 minut temu, Spanner napisał:

Którą masz wersję MySQL? to jest problem po stronie bazy danych nie oprogramowania, ale powodów może być kilka

5.5.46-37.5-log.

Udostępnij ten post


Link to postu
Udostępnij na innych stronach

Bądź aktywny! Zaloguj się lub utwórz konto

Tylko zarejestrowani użytkownicy mogą komentować zawartość tej strony

Utwórz konto

Zarejestruj nowe konto, to proste!

Zarejestruj nowe konto

Zaloguj się

Posiadasz własne konto? Użyj go!

Zaloguj się

  • Kto przegląda   0 użytkowników

    Brak zalogowanych użytkowników przeglądających tę stronę.

×

Ważne informacje

W celu świadczenie usług przez nasz Serwis na najwyższym poziomie, w ramach Serwisu wykorzystujemy pliki Cookies (tzw. ciasteczka). Korzystając ze stron Serwisu IPSBEYOND.PL bez zmiany ustawień przeglądarki będą one zapisane w pamięci urządzenia. Jeżeli nie dokonacie Państwo zmiany ustawień przeglądarki internetowej to wyrażacie zgodę na zapisywanie plików Cookies.