Forums / General / MySQL Query Error: LOCK TABLES eZSession_SessionVariable WRITE

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?

eZ debug

Timing: Jan 18 2025 03:04:14
Script start
Timing: Jan 18 2025 03:04:14
Module start 'content'
Timing: Jan 18 2025 03:04:14
Module end 'content'
Timing: Jan 18 2025 03:04:15
Script end

Main resources:

Total runtime0.6983 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0070 587.9609180.8047
Module start 'content' 0.00700.5521 768.7656464.2266
Module end 'content' 0.55910.1392 1,232.9922333.6016
Script end 0.6982  1,566.5938 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00440.6319210.0002
Check MTime0.00150.2209210.0001
Mysql Total
Database connection0.00080.115710.0008
Mysqli_queries0.634490.85221910.0033
Looping result0.00190.27471890.0000
Template Total0.673396.420.3366
Template load0.00240.339720.0012
Template processing0.670996.073920.3354
Template load and register function0.00010.018910.0001
states
state_id_array0.00080.119710.0008
state_identifier_array0.00070.105820.0004
Override
Cache load0.00200.2805160.0001
Sytem overhead
Fetch class attribute can translate value0.00150.220530.0005
Fetch class attribute name0.00210.299720.0010
XML
Image XML parsing0.00050.065530.0002
class_abstraction
Instantiating content class attribute0.00000.001320.0000
General
dbfile0.00330.4680210.0002
String conversion0.00000.001030.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/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