Home » Download » Drupal project » Drupal » Issues

Duplicated Queries

xwalox - December 3, 2008 - 08:50
Project:Drupal
Version:5.7
Component:base system
Category:bug report
Priority:critical
Assigned:Unassigned
Status:postponed (maintainer needs more info)
Description

Hi!
i'm building a web and i was having problems with mysql, when i use projeclogmonitor to see the queries i get a lot for queries duplicated, so, can somebody helpme?

there are the queries:

081203 3:54:15 root@localhost on Connect root@localhost on
081203 3:54:15 root@localhost on Init DB cristal_pruebas
081203 3:54:15 root@localhost on Query SET NAMES "utf8"
081203 3:54:15 root@localhost on Query SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1
081203 3:54:15 root@localhost on Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:15 root@localhost on Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
081203 3:54:15 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables'
081203 3:54:15 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:15 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'admin'
081203 3:54:16 root@localhost on Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
081203 3:54:16 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = '1:en'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/status/php'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/status/sql'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/status/run-cron'
081203 3:54:16 root@localhost on Query SELECT name, schema_version FROM system WHERE type = 'module'
081203 3:54:16 root@localhost on Query SELECT * FROM system WHERE type = 'theme'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/content/node'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/content/types'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/content/node-settings'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/content/rss-publishing'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/build/block'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/build/modules'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/build/themes'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/admin'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/clean-urls'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/date-time'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/error-reporting'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/file-system'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/image-toolkit'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/filters'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/performance'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/site-information'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings/site-maintenance'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user/settings'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user/access'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user/rules'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user/roles'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user/user'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/watchdog'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/access-denied'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/page-not-found'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs/status'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/compact/off'
081203 3:54:16 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'home'
081203 3:54:16 root@localhost on Query SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
081203 3:54:16 root@localhost on Query SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'node/add'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'user/1'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/content'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/build'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/settings'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/user'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/logs'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'logout'
081203 3:54:16 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin/by-module'
081203 3:54:16 root@localhost on Query SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
081203 3:54:16 root@localhost on Query SELECT title FROM `menu` where path LIKE 'admin'
081203 3:54:16 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:16 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272856 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:16 root@localhost on Query UPDATE users SET access = 1228272856 WHERE uid = 1
081203 3:54:16 root@localhost on Quit
081203 3:54:17 root@localhost on Connect root@localhost on
081203 3:54:17 root@localhost on Init DB cristal_pruebas
081203 3:54:17 root@localhost on Query SET NAMES "utf8"
081203 3:54:17 root@localhost on Query SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1
081203 3:54:17 root@localhost on Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:17 root@localhost on Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
081203 3:54:17 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables'
081203 3:54:17 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:17 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'modules/javascript/certifica-js14.js'
081203 3:54:18 root@localhost on Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
081203 3:54:18 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = '1:en'
081203 3:54:18 root@localhost on Query INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'page not found', 'modules/javascript/certifica-js14.js', 1, '', 'http://localhost/cristal_pruebas/modules/javascript/certifica-js14.js', 'http://localhost/cristal_pruebas/admin', '127.0.0.1', 1228272858)
081203 3:54:18 root@localhost on Query SELECT * FROM system WHERE type = 'theme'
081203 3:54:18 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'home'
081203 3:54:18 root@localhost on Query SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
081203 3:54:18 root@localhost on Query SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'node/add'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'user/1'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'logout'
081203 3:54:18 root@localhost on Query SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
081203 3:54:18 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272858 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query UPDATE users SET access = 1228272858 WHERE uid = 1
081203 3:54:18 root@localhost on Quit
081203 3:54:18 root@localhost on Connect root@localhost on
081203 3:54:18 root@localhost on Init DB cristal_pruebas
081203 3:54:18 root@localhost on Query SET NAMES "utf8"
081203 3:54:18 root@localhost on Query SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1
081203 3:54:18 root@localhost on Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
081203 3:54:18 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables'
081203 3:54:18 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:18 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'modules/javascript/certifica.js'
081203 3:54:18 root@localhost on Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
081203 3:54:18 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = '1:en'
081203 3:54:18 root@localhost on Query INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'page not found', 'modules/javascript/certifica.js', 1, '', 'http://localhost/cristal_pruebas/modules/javascript/certifica.js', 'http://localhost/cristal_pruebas/admin', '127.0.0.1', 1228272858)
081203 3:54:18 root@localhost on Query SELECT * FROM system WHERE type = 'theme'
081203 3:54:18 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'home'
081203 3:54:18 root@localhost on Query SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
081203 3:54:18 root@localhost on Query SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'node/add'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'user/1'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin'
081203 3:54:18 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'logout'
081203 3:54:18 root@localhost on Query SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
081203 3:54:18 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272858 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query UPDATE users SET access = 1228272858 WHERE uid = 1
081203 3:54:18 root@localhost on Quit
081203 3:54:18 root@localhost on Connect root@localhost on
081203 3:54:18 root@localhost on Init DB cristal_pruebas
081203 3:54:18 root@localhost on Query SET NAMES "utf8"
081203 3:54:18 root@localhost on Query SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1
081203 3:54:18 root@localhost on Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:18 root@localhost on Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
081203 3:54:18 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables'
081203 3:54:19 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:19 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'modules/javascript/certifica-js14.js'
081203 3:54:19 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:19 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'modules/javascript/certifica-js14.js'
081203 3:54:19 root@localhost on Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
081203 3:54:19 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = '1:en'
081203 3:54:19 root@localhost on Query INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'page not found', 'modules/javascript/certifica-js14.js', 1, '', 'http://localhost/cristal_pruebas/modules/javascript/certifica-js14.js', 'http://localhost/cristal_pruebas/admin', '127.0.0.1', 1228272859)
081203 3:54:19 root@localhost on Query SELECT * FROM system WHERE type = 'theme'
081203 3:54:19 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'home'
081203 3:54:19 root@localhost on Query SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
081203 3:54:19 root@localhost on Query SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
081203 3:54:19 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'node/add'
081203 3:54:19 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'user/1'
081203 3:54:19 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin'
081203 3:54:19 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'logout'
081203 3:54:19 root@localhost on Query SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
081203 3:54:19 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:19 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272859 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:19 root@localhost on Query UPDATE users SET access = 1228272859 WHERE uid = 1
081203 3:54:19 root@localhost on Quit
081203 3:54:19 root@localhost on Connect root@localhost on
081203 3:54:19 root@localhost on Init DB cristal_pruebas
081203 3:54:19 root@localhost on Query SET NAMES "utf8"
081203 3:54:19 root@localhost on Query SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('127.0.0.1') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1
081203 3:54:19 root@localhost on Query SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:19 root@localhost on Query SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
081203 3:54:19 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables'
081203 3:54:19 root@localhost on Query SELECT COUNT(pid) FROM url_alias
081203 3:54:19 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'modules/javascript/certifica.js'
081203 3:54:20 root@localhost on Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
081203 3:54:20 root@localhost on Query SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = '1:en'
081203 3:54:20 root@localhost on Query INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'page not found', 'modules/javascript/certifica.js', 1, '', 'http://localhost/cristal_pruebas/modules/javascript/certifica.js', 'http://localhost/cristal_pruebas/admin', '127.0.0.1', 1228272860)
081203 3:54:20 root@localhost on Query SELECT * FROM system WHERE type = 'theme'
081203 3:54:20 root@localhost on Query SELECT src FROM url_alias WHERE dst = 'home'
081203 3:54:20 root@localhost on Query SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
081203 3:54:20 root@localhost on Query SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
081203 3:54:20 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'node/add'
081203 3:54:20 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'user/1'
081203 3:54:20 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'admin'
081203 3:54:20 root@localhost on Query SELECT dst FROM url_alias WHERE src = 'logout'
081203 3:54:20 root@localhost on Query SELECT * FROM system WHERE type = 'theme' AND name = 'garland'
081203 3:54:21 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:21 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272861 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:21 root@localhost on Query UPDATE users SET access = 1228272861 WHERE uid = 1
081203 3:54:21 root@localhost on Quit
081203 3:54:21 root@localhost on Query SELECT sid FROM sessions WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:21 root@localhost on Query UPDATE sessions SET uid = 1, cache = 1228269803, hostname = '127.0.0.1', session = '', timestamp = 1228272861 WHERE sid = '0rknp9c6ka7aob2aokr6hgpk94'
081203 3:54:21 root@localhost on Query UPDATE users SET access = 1228272861 WHERE uid = 1
081203 3:54:21 root@localhost on Quit

» Login or register to post comments

#1

xwalox - December 3, 2008 - 08:58
Login or register to post comments

#2

drumm - December 3, 2008 - 17:11
Status:active» postponed (maintainer needs more info)

What specific queries concern you? Most of those look different.

Login or register to post comments

#3

xwalox - December 4, 2008 - 23:49

i got the problem!
when the system miss a file , an image, it try to load some tpl file or somethin like that so the queries get repeated

how can i solve this problem???

Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.