MySQL server has gone away during content type creation

chrisdaems - December 28, 2007 - 17:11
Project:Content Construction Kit (CCK)
Version:5.x-1.6-1
Component:General
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed
Description

Is there a limit of content types or the amount of fields that can be created with CCK?

I was able to create 8 content types and all of them without any problems. After the creation of a 9th content type, a MySQL server has gone away error appeared. I was able to restore my site and migrated everything into a test environment. I restored everything except the last content type.

To troubleshoot the error I created the content type in the same way. Again the same error. My first guess was that I had problems with a node reference field. But I also tried to recreate the content type without the node reference. But without success.

The first lines are warnings with the following message:

Warning: MySQL server has gone away query: watchdog INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: fieldgroup_groups\nSELECT nfi.*, ng.group_name FROM node_group ng INNER JOIN node_group_fields ngf ON ngf.type_name = ng.type_name AND ngf.group_name = ng.group_name INNER JOIN node_field_instance nfi ON nfi.field_name = ngf.field_name AND nfi.type_name = ngf.type_name ORDER BY nfi.weight</em> in <em>C:\\wamp\\www\\scv_demo\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://localhost/scv_demo/admin/content/types/opdrachtfiche/fields/field_of_omschrijving', 'http://localhost/scv_demo/admin/content/types/opdrachtfiche/add_field', '127.0.0.1', 1198859890) in C:\wamp\www\scv_demo\includes\database.mysql.inc on line 172

I also can see the same warning but for another table:

user warning: MySQL server has gone away query: cache_set UPDATE cache_views SET data = 'a:4:{s:6:\"tables\";a:121:{s:17:\"nodefamily_parent\";a:3:{s:4:\"name\";s:10:\"nodefamily\";s:4:\"join\";a:3:{s:4:\"left\";a:2:{s:5:\"table\";s:4:\"node\";s:5:\"field\";s:3:\"nid\";}s:5:\"right\";a:1:{s:5:\"field\";s:10:\"parent_nid\";}s:4:\"type\";s:5:\"inner\";}s:7:\"filters\";a:1:{s:9:\"child_nid\";a:5:{s:4:\"name\";s:25:\"Nodefamily: Child Node ID\";s:8:\"operator\";s:28:\"views_handler_operator_eqneq\";s:6:\"option\";a:2:{s:5:\"#type\";s:6:\"select\";s:8:\"#options\";a:23:{s:12:\"autogegevens\";s:12:\"Autogegevens\";s:16:\"bedrijfsgegevens\";s:16:\"Bedrijfsgegevens\";s:4:\"blog\";s:10:\"Blog entry\";s:4:\"book\";s:9:\"Book pag......

Is it possible that there is a problem with the caching mechanism? I can see that it tries to cache all content types in the cache_views table.

Memory is no problem because the site is currently running on a development environment with a memory limit equal to 128M.

I currently use drupal 5.3
cck 1.6

Regards,
chris

#1

VeryMisunderstood - December 28, 2007 - 17:28
Category:bug report» support request
Priority:critical» normal

use the error in a search = http://drupal.org/search/node/MySQL+server+has+gone+away

find: http://drupal.org/node/147179

according to that you need to increase the packet size limit.

Also of note: you should be using Drupal 5.5, 5.3 is insecure.

#2

chrisdaems - December 28, 2007 - 18:55
Status:active» fixed

hi,

it's solved. I was really looking into the wrong direction.
You're right again, I will upgrade drupal 5.3 to 5.5.

I will mark this issue as fixed.

Many thanks
chris

#3

Anonymous - January 11, 2008 - 19:14
Status:fixed» closed

Automatically closed -- issue fixed for two weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.