MantisBT - BrazilFW 3.x
View Issue Details
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
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-16 10:28soulpowerNew Issue
2010-05-16 10:28soulpowerStatusnew => assigned
2010-05-16 10:28soulpowerAssigned To => woshman
2010-05-16 12:43woshmanNote Added: 0000001
2010-05-16 12:48woshmanNote Deleted: 0000001
2010-05-16 12:48woshmanNote Added: 0000002
2010-05-16 12:48woshmanStatusassigned => acknowledged
2010-05-16 14:04soulpowerNote Added: 0000003
2010-05-16 15:32woshmanNote Added: 0000005
2010-05-16 18:37soulpowerNote Added: 0000007
2010-05-16 19:34woshmanStatusacknowledged => resolved
2010-05-16 19:34woshmanResolutionopen => fixed
2010-05-16 19:34woshmanStatusresolved => closed

Notes
(0000002)
woshman   
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   
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   
2010-05-16 15:32   
Aplique esse patch e veja se resolve o problema:
get-pkg /users/woshman/patches/228/mysql/patch0001
(0000007)
soulpower   
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