Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000005BrazilFW 3.x[All Projects] BrazilFW 3.xpublic2010-05-16 10:282010-05-16 19:34
Reportersoulpower 
Assigned Towoshman 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Summary0000005: problemas com sql
DescriptionSQL Error
ERROR on SQL query
SQL query: SELECT DATE_FORMAT(date, '%W, %d %M %x') AS dateFormatted,date,MIN(date) AS minDate,MAX(date) AS maxDate,COUNT(DISTINCTROW ip) AS hosts,COUNT(DISTINCTROW usersID) AS users,COUNT(DISTINCTROW sitesID) AS sites,SUM(inCache+outCache) AS bytes,TRUNCATE(SUM(inCache)/SUM(inCache+outCache)*100,0) AS cachePercent FROM trafficSummaries GROUP BY dateFormatted ORDER BY date DESC
Database error number: 3
Database error message: Error writing file '/tmp/MYkyANgH' (Errcode: 28)
Exiting...

(ao acessar o mysql ele ta este erro)
começou a aparecer do dia 15 para o 16, antes disto estava funcionando normalmente
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0000002)
woshman (administrator)
2010-05-16 12:48

Errcode: 28 = Não há espaço suficiente em disco.
Aumente a quantidade de memória do BFW.
(0000003)
soulpower (reporter)
2010-05-16 14:04

me desculpe woshman

mas o bfw nao deveria informar uso de memoria no maximo???? (ou estou errado)
segui os passo do topico do mysar
e acabou que piorou mais ainda
gostaria de saber como faço para
reinstalar o mysql
(0000005)
woshman (administrator)
2010-05-16 15:32

Aplique esse patch e veja se resolve o problema:
get-pkg /users/woshman/patches/228/mysql/patch0001
(0000007)
soulpower (reporter)
2010-05-16 18:37

deu certo
usei o seu comando
e agreguei este

por luapufo » Dom Mai 16, 2010 7:07 pm

reconfigurar o Banco de Dados ( BD ) do mysql para o padrão

Código: Selecionar todos
/etc/init.d/mysql stop
rm -rf /partition/mysql
/etc/init.d/mysql start
com os codigos acima, voce zera todos os BD que usam mysql, se quiser so zerar o BD sem perder os outros BD ( Mysar, SAPW, Portal, etc... ), faça o seguinte

Código: Selecionar todos
/etc/init.d/mysql stop
rm -rf /partition/mysql/mysql
/etc/init.d/mysql start

agora funciona tudo certo

- Issue History
Date Modified Username Field Change
2010-05-16 10:28 soulpower New Issue
2010-05-16 10:28 soulpower Status new => assigned
2010-05-16 10:28 soulpower Assigned To => woshman
2010-05-16 12:43 woshman Note Added: 0000001
2010-05-16 12:48 woshman Note Deleted: 0000001
2010-05-16 12:48 woshman Note Added: 0000002
2010-05-16 12:48 woshman Status assigned => acknowledged
2010-05-16 14:04 soulpower Note Added: 0000003
2010-05-16 15:32 woshman Note Added: 0000005
2010-05-16 18:37 soulpower Note Added: 0000007
2010-05-16 19:34 woshman Status acknowledged => resolved
2010-05-16 19:34 woshman Resolution open => fixed
2010-05-16 19:34 woshman Status resolved => closed


Copyright © 2000 - 2010 MantisBT Group
Powered by Mantis Bugtracker