Topic: Database Locked

[darmasanthi]

Hi All,
I'm using SME 7.3 with all update's installed on the server
Now i have problem with my database.
When I'm checking the database with MySQL GUI Tools, i found the database was locked
on the server connections section at state column

And the database is hangs

regards,
darmasanthi

[cactus]

Hi All,
I'm using SME 7.3 with all update's installed on the server
Now i have problem with my database.
When I'm checking the database with MySQL GUI Tools, i found the database was locked
on the server connections section at state column

And the database is hangs

regards,
darmasanthi

What actions did you take to allow the MySQL GUI Tools access to the SME Server MySQL engine? I am guessing you installed the GUI tools on a machine other than the server itself therefore by default it should not be able to access the MySQL engine at all (from remote machines at least).

[darmasanthi]

Hi Cactus,
Thanks for your reply..
I can connect to the MySQL server, also i can browsing the database.
but a few database was locked on the state status

regards,
darmasanthi

[darmasanthi]

Hi cactus,
in simple word the Query database is in locked state
regards,
darmasanthi

[CharlieBrady]

I can connect to the MySQL server, also i can browsing the database.
but a few database was locked on the state status

That relates to the operation of your applications which are using MySQL. This has nothing/little to do with SME server software operations (SME software only uses MySQL for storage of webmail user preferences).

[chris burnat]

This issue is not related to SME core packages as pointed out by Charlie.  Moving to general discussion.