Dobrý den,
tak jen bych upřesnil, že "kluci" z C4 k tomu bohužel měli důvod. Byl Vám zaslán následující e-mail.
-------------------------------------------------
Dobry den,
od vcerejsiho dne jsme zaregistrovali velke problemy na nasem
databazovem serveru, kde hostuje databazi Vase domena
http://www.cech-pivo.cz.
Postupnym setrenim bylo zjisteno, ze zavadu a padani celeho databazoveho
serveru zpusobuje databaze www-pivo.
Databazi jsme zkouseli opravit, vse se ale jako v poradku.
Nakonec jsme zjistili, ze problem zpusobuje urcity SQL dotaz:
Thread pointer: 0x7fe286f2d4c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fe0baa65dc0 thread_stack 0x48000
/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x7fe2789e396d]
/usr/libexec/mysqld(handle_fatal_signal+0x515)[0x7fe2785f9285]
/lib64/libpthread.so.0(+0xf5e0)[0x7fe277d265e0]
/usr/libexec/mysqld(+0x3962ef)[0x7fe2784ed2ef]
/usr/libexec/mysqld(_Z20get_best_combinationP4JOIN+0x35b)[0x7fe2784f3dcb]
/usr/libexec/mysqld(+0x3b73b3)[0x7fe27850e3b3]
/usr/libexec/mysqld(_ZN4JOIN8optimizeEv+0x675)[0x7fe278511625]
/usr/libexec/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xc8)[0x7fe2784c0b18]
/usr/libexec/mysqld(_ZN4JOIN8optimizeEv+0x1ec7)[0x7fe278512e77]
/usr/libexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xc8)[0x7fe278513ae8]
/usr/libexec/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x2db)[0x7fe2785145fb]
/usr/libexec/mysqld(+0x36b9d9)[0x7fe2784c29d9]
/usr/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x45d1)[0x7fe2784cd001]
/usr/libexec/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x125)[0x7fe2784cf8c5]
/usr/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1753)[0x7fe2784d1923]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x1c2)[0x7fe278583632]
/usr/libexec/mysqld(handle_one_connection+0x4a)[0x7fe2785836da]
/lib64/libpthread.so.0(+0x7e25)[0x7fe277d1ee25]
/lib64/libc.so.6(clone+0x6d)[0x7fe27651c34d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fe068f5e9b8): SELECT a.id, a.title, a.alias, a.introtext,
a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created,
a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state
> 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,CASE
WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified
END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN
a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up
END as publish_up,a.publish_down, a.images, a.urls, a.attribs,
a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference,
a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS
category_title, c.path AS category_route, c.access AS category_access,
c.alias AS category_alias,c.published, c.published AS
parents_published,CASE WHEN a.created_by_alias > ' ' THEN
a.created_by_alias ELSE ua.name END AS author,ua.email AS
author_email,parent.title as parent_title, parent.id as parent_id,
parent.path as parent_route, parent.alias as
parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0),
0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as
rating_count FROM chg_content AS a LEFT JOIN chg_categories AS c ON c.id
= a.catid LEFT JOIN chg_users AS ua ON ua.id = a.created_by LEFT JOIN
chg_users AS uam ON uam.id = a.modified_by LEFT JOIN chg_categories as
parent ON parent.id = c.parent_id LEFT JOIN chg_content_rating AS v ON
a.id = v.content_id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5)
AND c.published = 1 AND a.state = 1 AND (a.catid = 12 OR a.catid IN (
SELECT sub.id FROM chg_categories as sub INNER JOIN chg_categories as
this ON sub.lft > this.lft AND sub.rgt < this.rgt WHERE this.id = 12))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-17
05:07:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down
>= '2017-09-17 05:07:17') AND a.language in ('en-GB','*') ORDER BY
a.created DESC , a.created LIMIT 12
Connection ID (thread ID): 19339
Status: NOT_KILLED
Vzhledem k zavaznosti problemu nebyla jina moznost, nez celou databazi
ze serveru odstranit a spolecne s tim pozastavit protokol http/https u
webu
http://www.cech-pivo.cz.
Zalohu SQL dumpu jsem Vam umistil v rootu webu
http://www.cech-pivo.cz do
slozky sql_dump/.
--
S pozdravem
Petr Skrabalek
Webhosting C4
ČESKÝ WEBHOSTING s.r.o.
Tel: +420 234 139 876
E-mail:
info@c4.czhttp://www.c4.cz-------------------------------------------------
Tolik k odstavení Vašeho webu.
Pokud se Vám web za poslední dobou začal chovat sám od sebe nestandardně, tipoval bych to na nějaký virus, který se do Joomly dostal přes neaktualizovanou komponentu.
Situaci jsme se nejdříve snažili řešit tak, že jsme Vaši doménu přesunuli na jiný webserver, ale tam začaly okamžitě problémy.
Ale to vše víte, protože probíhá komunikace i přes e-mail.