MySQL server has gone away

danio_d
Topic Author
Offline
Senior Member

10 years 9 months ago #44640 by danio_d

MySQL server has gone away was created by danio_d

Hi,

I have a strange problem.
Recently, very often. In the flexicontent panel shows a message:

Code:

        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1
        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1

or this:

Code:

        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1
        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1
        Wystąpił błąd podczas wczytywania modułu MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM gavwb_modules AS m LEFT JOIN gavwb_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN gavwb_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-01-31 20:39:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-01-31 20:39:45') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

and Initial permission show update.

After refresh view times, message disappears and flexi working properly. But recently, very often I get an error 500 on the front page.

My version is: J2.5.17, F:2.0.0 RC9b r1601
Yes, I now it's old. But I made backup and test page, and update to the last varsion and the error is stille this same.

Any help?

THX
dede

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 9 months ago #44647 by ggppdk

Replied by ggppdk on topic MySQL server has gone away

Hello

how many items do you have in your website, and how many versions per item ?

please execute this in phpmyadmin:
SHOW VARIABLES LIKE 'max_allowed_packet'

what is the size given by the above command

you may try contacting your web-host to increase the above given value

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

danio_d
Topic Author
Offline
Senior Member

10 years 9 months ago #44664 by danio_d

Replied by danio_d on topic MySQL server has gone away

Hi,

Code:

max_allowed_packet 	8388608

items total: 11700
cats: 146
versions per item: 10, change now to 5

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 9 months ago #44666 by ggppdk

Replied by ggppdk on topic MySQL server has gone away

Hello

you have a lot of content,
latest versions of FLEXIcontent has several important speed optimizations for large sites, (10x,20x faster SQL queries)
-- category view
-- items manager
-- module
-- other ...

you should update

About your issue:
-- the changed value 10 -> 5 will effect only new save operations

in your backup site , truncate (=make empty do not delete) these 2 table (e.g. via phpmyadmin select the table and then click to empty them)
DBPREFIX_flexicontent_versions
DBPREFIX_flexicontent_item_versions

- or in the SQL box of phpmyadmin execute:

Code:

truncate DBPREFIX_flexicontent_versions,
DBPREFIX_flexicontent_item_versions

Then visit FLEXIcontent dashboard and click to add item versions

Does it solve the problem?

Please Log in or Create an account to join the conversation.

danio_d
Topic Author
Offline
Senior Member

10 years 9 months ago #44683 by danio_d

Replied by danio_d on topic MySQL server has gone away

THX for Your answer.

I made how You write.
Tell me. As long as it works? Because it works 5 hours. When I refresh page error code was this same.

So, I repeat operation and truncate this two tables.
After that in position 'Add the items current versions' show error code:

Code:

ABORT: PHP cpu time limit exceeded in FlexicontentModelFlexicontent::getDiffVersions() called at [/05v_fabryka_2014/administrator/components/com_flexicontent/models/flexicontent.php:862], in FlexicontentModelFlexicontent::getDiffVersions() called at [/05v_fabryka_2014/administrator/components/com_flexicontent/models/flexicontent.php:906], in FlexicontentModelFlexicontent::addCurrentVersionData() called at [/05v_fabryka_2014/administrator/components/com_flexicontent/controller.php:976], in FlexicontentController::addCurrentVersionData() called at [/05v_fabryka_2014/libraries/joomla/application/component/controller.php:761], in JController::execute() called at [/05v_fabryka_2014/administrator/components/com_flexicontent/admin.flexicontent.php:198], in require_once() called at [/05v_fabryka_2014/libraries/joomla/application/component/helper.php:383], in JComponentHelper::executeComponent() called at [/05v_fabryka_2014/libraries/joomla/application/component/helper.php:351], in JComponentHelper::renderComponent() called at [/05v_fabryka_2014/administrator/includes/application.php:153], in JAdministrator::dispatch() called at [/05v_fabryka_2014/administrator/index.php:46]

Now I have the same situation as at the beginning:

Code:

currentMissing(): SQL QUERY ERROR:
        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1
        currentMissing(): SQL QUERY ERROR:
        MySQL server has gone away SQL=SELECT c.id,c.version,iv.version as iversion FROM gavwb_content as c LEFT JOIN gavwb_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN gavwb_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1
        Wystąpił błąd podczas wczytywania modułu MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM gavwb_modules AS m LEFT JOIN gavwb_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN gavwb_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-02-02 20:16:38') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-02-02 20:16:38') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

and 'Initial permission' update button

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 9 months ago #44686 by ggppdk

Replied by ggppdk on topic MySQL server has gone away

Hello

SHOW VARIABLES LIKE 'max_allowed_packet'
gives
8M

what does this give ?
SHOW VARIABLES LIKE 'wait_timeout'

- ask your provider to change 'max_allowed_packet' to at least 16M
or preferably 32M
- and increase 'wait_timeout' if it is too low

this is a server limitation, but i guess we can try to bypass Joomla DB layer and use an unbuffered DB query ?

Please Log in or Create an account to join the conversation.