Space problem

Forwarding to the list.

···

---------- Forwarded message ----------
From: Knut Staring knutst@gmail.com

Hi guys,

Have any of you come across this error when starting DHIS2?

WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1030, SQLState: HY000

ERROR [org.hibernate.util.JDBCExceptionReporter] Got error 28 from storage engine

Mysql: Error code 28: No space left on device

Our server admin asked the following:

/tmp was full on the server, should work better now.

Is your application using a lot /tmp to create sess_ files?

http://amazing-development.com/archives/2006/08/16/javasqlsqlexception-got-error-28-from-storage-engine/

http://www.vbulletin.com/forum/showthread.php?t=138463

Cheers,
Knut Staring


Cheers,
Knut Staring

Hello.

MySQL is suffering. There is no space where he can put data or to move innodb temporary stuff. Those things normally on Linux (as I guess by /tmp) are on the same directory you have the data. And that directory is not /tmp.

MySQL could use /tmp for the socket.

I think those strange files are being generated by some other thing, not by mysql. And it is really strange.

1. Chech the space of the MySQL tables (usually /var/lib/mysql).

2. Check who is the owner of those ses files.

Good luck
Caveman

By again

Knut Staring wrote:

···

Forwarding to the list.

---------- Forwarded message ----------
From: *Knut Staring* <knutst@gmail.com <mailto:knutst@gmail.com>>

Hi guys,

Have any of you come across this error when starting DHIS2?

WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1030, SQLState: HY000
ERROR [org.hibernate.util.JDBCExceptionReporter] Got error 28 from storage engine

Mysql: Error code 28: No space left on device

Our server admin asked the following:

/tmp was full on the server, should work better now.

Is your application using a lot /tmp to create sess_ files?

» java.sql.SQLException: Got error 28 from storage engine « amazing development

http://www.vbulletin.com/forum/showthread.php?t=138463
--
Cheers,
Knut Staring

--
Cheers,
Knut Staring

------------------------------------------------------------------------

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp