Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: darmasanthi on October 16, 2008, 07:20:51 AM

Title: Database Locked
Post by: darmasanthi on October 16, 2008, 07:20:51 AM: 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
Title: Re: Database Locked
Post by: cactus on October 16, 2008, 08:23:35 AM: Quote from: darmasanthi on October 16, 2008, 07:20:51 AM
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).
Title: Re: Database Locked
Post by: darmasanthi on October 16, 2008, 09:29:49 AM: 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
Title: Re: Database Locked
Post by: darmasanthi on October 16, 2008, 09:47:18 AM: Hi cactus,
in simple word the Query database is in locked state
regards,
darmasanthi
Title: Re: Database Locked
Post by: CharlieBrady on October 16, 2008, 02:41:02 PM: Quote from: darmasanthi on October 16, 2008, 09:29:49 AM
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).
Title: Re: Database Locked
Post by: chris burnat on October 17, 2008, 01:37:30 AM: This issue is not related to SME core packages as pointed out by Charlie. Moving to general discussion.