I'm not sure where this really should go, but the problem only exists while using views (latest version) and occurs for all users except those with "Administer nodes" permission. It is likely pilot error. The site was working until all my files were deleted and I had to restore them. All now works except normal users cannot see any views that have computed fields. The filter specification at the top of the page shows and then the page fails -- no navigation blocks or anything. The admin user gets to see everything just fine. The system this is running on is lightly loaded so shouldn't have timeout issues.

I increased mysql config values per the recommendations and even went beyond that with no luck. Views without computed fields are ok and the underlying content is accessible directly. The error in the title is what I see in the Apache logs. Any ideas? I'm currently stumped. I have tried a few versions of Views and disabled nearly all features.

The full error and stack is:

[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP Stack trace:
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 1. sess_write() /var/apache2/2.2/htdocs/3acres/includes/session.inc:0
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 2. db_query() /var/apache2/2.2/htdocs/3acres/includes/session.inc:75
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 3. _db_query() /var/apache2/2.2/htdocs/3acres/includes/database.mysql-common.inc:42
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 4. trigger_error() /var/apache2/2.2/htdocs/3acres/includes/database.mysqli.inc:128
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 5. drupal_error_handler() /var/apache2/2.2/htdocs/3acres/includes/common.inc:0
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 6. watchdog() /var/apache2/2.2/htdocs/3acres/includes/common.inc:663
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 7. module_invoke() /var/apache2/2.2/htdocs/3acres/includes/bootstrap.inc:966
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 8. call_user_func_array() /var/apache2/2.2/htdocs/3acres/includes/module.inc:462
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 9. dblog_watchdog() /var/apache2/2.2/htdocs/3acres/includes/module.inc:0
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 10. db_query() /var/apache2/2.2/htdocs/3acres/modules/dblog/dblog.module:147
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 11. _db_query() /var/apache2/2.2/htdocs/3acres/includes/database.mysql-common.inc:42
[Fri Aug 27 16:16:12 2010] [error] [client 10.0.0.104] PHP 12. trigger_error() /var/apache2/2.2/htdocs/3acres/includes/database.mysqli.inc:128

Thanks,
Doug

Comments

dawehner’s picture

dawehner
Primary language German
commented

Does alpha 3 works for you?
Beside the backtrace I think it would be worth to have the error itself

dougm’s picture

dougm commented

Just tried alpha 3 with no luck. I turned output to screen on and include that. If you want to see what I get for output, http://3acres.org/ColorChart will display it Many thanks in advance.

Doug

Here is the full error output:
user warning: Lost connection to MySQL server during query query: SELECT COUNT(*) FROM (SELECT node.title AS node_title, node.nid AS nid, node_data_field_color_id.field_color_id_value AS node_data_field_color_id_field_color_id_value, node.type AS node_type, node.vid AS node_vid, node_data_field_color_id.field_cg_tertiary_value AS node_data_field_color_id_field_cg_tertiary_value, node_data_field_color_id.field_hue_value AS node_data_field_color_id_field_hue_value, node_data_field_brand.field_brand_nid AS node_data_field_brand_field_brand_nid FROM node node LEFT JOIN content_type_color_sample node_data_field_color_id ON node.vid = node_data_field_color_id.vid LEFT JOIN content_field_brand node_data_field_brand ON node.vid = node_data_field_brand.vid LEFT JOIN node modr_n ON node.nid = modr_n.nid WHERE ((modr_n.moderate != 1)) AND ( (node.status <> 0) AND (node.type in ('color_sample')) )) count_alias in /var/apache2/2.2/htdocs/3acres/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT node.title AS node_title, node.nid AS nid, node_data_field_color_id.field_color_id_value AS node_data_field_color_id_field_color_id_value, node.type AS node_type, node.vid AS node_vid, node_data_field_color_id.field_cg_tertiary_value AS node_data_field_color_id_field_cg_tertiary_value, node_data_field_color_id.field_hue_value AS node_data_field_color_id_field_hue_value, node_data_field_brand.field_brand_nid AS node_data_field_brand_field_brand_nid FROM node node LEFT JOIN content_type_color_sample node_data_field_color_id ON node.vid = node_data_field_color_id.vid LEFT JOIN content_field_brand node_data_field_brand ON node.vid = node_data_field_brand.vid LEFT JOIN node modr_n ON node.nid = modr_n.nid WHERE ((modr_n.moderate != 1)) AND ( (node.status <> 0) AND (node.type in ('color_sample')) )ORDER BY node_title ASC LIMIT 0, 40 in /var/apache2/2.2/htdocs/3acres/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT info FROM system WHERE type = 'theme' AND name = 'acquia_marina' in /var/apache2/2.2/htdocs/3acres/modules/system/system.module on line 1014.
warning: array_map() [function.array-map]: Argument #2 should be an array in /var/apache2/2.2/htdocs/3acres/modules/system/system.module on line 1015.
warning: array_keys() [function.array-keys]: The first argument should be an array in /var/apache2/2.2/htdocs/3acres/includes/theme.inc on line 1817.
warning: Invalid argument supplied for foreach() in /var/apache2/2.2/htdocs/3acres/includes/theme.inc on line 1817.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:page-cid:ColorChart:1' in /var/apache2/2.2/htdocs/3acres/includes/cache.inc on line 26.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'navigation' AND link_path IN ('ColorChart') in /var/apache2/2.2/htdocs/3acres/includes/menu.inc on line 898.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'navigation' AND link_path = 'ColorChart' in /var/apache2/2.2/htdocs/3acres/includes/menu.inc on line 903.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT m.load_functions, m.to_arg_functions, m.access_callback, m.access_arguments, m.page_callback, m.page_arguments, m.title, m.title_callback, m.title_arguments, m.type, m.description, ml.* FROM menu_links ml LEFT JOIN menu_router m ON m.path = ml.router_path WHERE ml.menu_name = 'navigation' AND ml.plid IN (0) ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC in /var/apache2/2.2/htdocs/3acres/includes/menu.inc on line 941.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe' in /var/apache2/2.2/htdocs/3acres/includes/cache.inc on line 26.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: UPDATE cache_menu SET data = 'a:2:{s:4:\"tree\";a:0:{}s:10:\"node_links\";a:0:{}}', created = 1283041028, expire = 0, headers = '', serialized = 1 WHERE cid = 'links:navigation:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe' in /var/apache2/2.2/htdocs/3acres/includes/cache.inc on line 109.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: UPDATE cache_menu SET data = 'links:navigation:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe', created = 1283041028, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:navigation:page-cid:ColorChart:1' in /var/apache2/2.2/htdocs/3acres/includes/cache.inc on line 109.
user warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) query: SELECT * FROM menu_router WHERE tab_root = 'ColorChart' ORDER BY weight, title in /var/apache2/2.2/htdocs/3acres/sites/all/modules/ctools/includes/menu.inc on line 293.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed 
Lost connection to MySQL server during query query:

I think this says everything.

dougm’s picture

dougm commented

Any idea why it works when privileged?

Status: Fixed » Closed (fixed)

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

dawehner’s picture

dawehner
Primary language German
commented
Title: query: INSERT INTO watchdog and computed fields in views » query: INSERT INTO watchdog and computed fields in views

fix title