suddenly got Error: eZMySQLDB

Next topic

Author	Message
André R.	Thursday 23 March 2006 6:35:02 am I suddenly get this error now: Query error: Can't open file: 'ezsession.MYI' (errno: 145). Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='a22430de0492af2f1a0045d578d12d03' Its only on the siteaccesses that share db and cache folder. So tried deleting all cache files thru ftp (can't log inn to admin interface because of this), but that didn't help.. If you have an idea what this might be, pleas post it !!! Thanks !!!! ez 3.7.4 mySql 4.1 php 4.4.2 Apache 2.0.54 eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
André R.	Thursday 23 March 2006 7:26:02 am more info: http://ez.no/community/forum/install_configuration/can_t_login_to_admin/re_can_t_login_to_admin__4 http://ez.no/community/forum/install_configuration/can_t_log_in_admin_after_upgrade_to_3_7_3/re_can_t_log_in_admin_after_upgrade_to_3_7_3__3 In PhpMyAdmin, the ezsession table is marked with 'in use'. Might be that ez 'forgets' to unlock the table under some wired circumstances/ crash ?? Edit: fixed with a mysql repair on the ezsessions table eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom

Author

Message

Thursday 23 March 2006 6:35:02 am

I suddenly get this error now:
Query error: Can't open file: 'ezsession.MYI' (errno: 145). Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='a22430de0492af2f1a0045d578d12d03'

Its only on the siteaccesses that share db and cache folder.
So tried deleting all cache files thru ftp (can't log inn to admin interface because of this), but that didn't help..

If you have an idea what this might be, pleas post it !!! Thanks !!!!

ez 3.7.4
mySql 4.1
php 4.4.2
Apache 2.0.54

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

André R.

Thursday 23 March 2006 7:26:02 am

more info:

http://ez.no/community/forum/install_configuration/can_t_login_to_admin/re_can_t_login_to_admin__4

http://ez.no/community/forum/install_configuration/can_t_log_in_admin_after_upgrade_to_3_7_3/re_can_t_log_in_admin_after_upgrade_to_3_7_3__3

In PhpMyAdmin, the ezsession table is marked with 'in use'.

Might be that ez 'forgets' to unlock the table under some wired circumstances/ crash ??

Edit: fixed with a mysql repair on the ezsessions table

eZ debug

Timing:	Jan 19 2025 07:20:04
Script start
Timing:	Jan 19 2025 07:20:04
Module start 'layout'
Timing:	Jan 19 2025 07:20:04
Module start 'content'
Timing:	Jan 19 2025 07:20:05
Module end 'content'
Timing:	Jan 19 2025 07:20:05
Script end

Main resources:

Total runtime	1.7862 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0100	590.4063	152.6406
Module start 'layout'	0.0100	0.0030	743.0469	39.4766
Module start 'content'	0.0129	1.7718	782.5234	492.8594
Module end 'content'	1.7847	0.0014	1,275.3828	12.1484
Script end	1.7861		1,287.5313

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0039	0.2181	16	0.0002
Check MTime	0.0018	0.0988	16	0.0001
Mysql Total
Database connection	0.0028	0.1592	1	0.0028
Mysqli_queries	1.7336	97.0569	52	0.0333
Looping result	0.0006	0.0362	50	0.0000
Template Total	1.7357	97.2	2	0.8678
Template load	0.0021	0.1194	2	0.0011
Template processing	1.7335	97.0524	2	0.8668
Template load and register function	0.0001	0.0063	1	0.0001
states
state_id_array	0.0008	0.0423	1	0.0008
state_identifier_array	0.0013	0.0718	2	0.0006
Override
Cache load	0.0018	0.0999	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0478	1	0.0009
Fetch class attribute name	0.0014	0.0808	3	0.0005
XML
Image XML parsing	0.0006	0.0324	1	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0006	4	0.0000
General
dbfile	0.0008	0.0435	17	0.0000
String conversion	0.0000	0.0006	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs