dhis2-devs team mailing list archive

[Orvalho Joaquim Augusto <orvaquim@xxxxxxxxx>]

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@xxxxxxxxx <mailto:knutst@xxxxxxxxx>>
>
> 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
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp