MySQL Query Error: LOCK TABLES eZSession_SessionVariable WRITE

« 
Previous topic
|
General
|
Next topic
 »
Author Message

Jan Aril Sigvartsen

Thursday 24 April 2003 4:53:00 am

MySQL Query Error: LOCK TABLES eZSession_SessionVariable WRITE
Error number:1044
Error message: Access denied for user: user@host' to database 'ez_database'

This error keeps popping up once and awhile on eZ sites (2.x). It runs a MySQL 4.0.x server and has the following rights: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER.

Max connections, updates and queries are set to unlimited.

Any tips for what could be wrong? Is it a problem in eZ publish somewhere? I have no other users (ex. runnings PhpBB or other applications) with this type of error (Access denied that is).

--- Later i observed that this was the 3.x section. Forgive me for posting this message in the wrong forum. Still any possibilites to solve the problem? ---

Regards,
Jan Aril Sigvartsen
WebDeal AS

espen pedersen (det er noe rart med den andre kontoen min ;-)

Thursday 24 July 2003 9:35:26 am

I Have the exact same problem. It happened when I moved to a differnt ISP. The number one differnence was that the new ISP is running mysql 4. Could that be the problem???

Anyway if the case is solve could you provide me with som information?
Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 05:06:18
Script start
Timing: Jan 18 2025 05:06:18
Module start 'layout'
Timing: Jan 18 2025 05:06:18
Module start 'content'
Timing: Jan 18 2025 05:06:18
Module end 'content'
Timing: Jan 18 2025 05:06:18
Script end

Main resources:

Total runtime0.7033 sec
Peak memory usage4,096.0000 KB
Database Queries54

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 589.5938152.6563
Module start 'layout' 0.00580.0029 742.250039.5078
Module start 'content' 0.00870.6933 781.7578459.1172
Module end 'content' 0.70210.0012 1,240.87508.2500
Script end 0.7033  1,249.1250 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00300.4324160.0002
Check MTime0.00130.1790160.0001
Mysql Total
Database connection0.00100.137910.0010
Mysqli_queries0.662194.1449540.0123
Looping result0.00060.0797520.0000
Template Total0.673795.820.3369
Template load0.00220.319420.0011
Template processing0.671595.471520.3357
Template load and register function0.00020.033810.0002
states
state_id_array0.00070.097010.0007
state_identifier_array0.00110.153920.0005
Override
Cache load0.00170.2445160.0001
Sytem overhead
Fetch class attribute can translate value0.00070.095720.0003
Fetch class attribute name0.00090.134320.0005
XML
Image XML parsing0.00030.042120.0001
class_abstraction
Instantiating content class attribute0.00000.001020.0000
General
dbfile0.00060.0802100.0001
String conversion0.00000.001340.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 9
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs