| Anonymous | Login | Signup for a new account | 2024-11-21 13:04 -03 |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0000005 | BrazilFW 3.x | [All Projects] BrazilFW 3.x | public | 2010-05-16 10:28 | 2010-05-16 19:34 | |
| Reporter | soulpower | |||||
| Assigned To | woshman | |||||
| Priority | high | Severity | minor | Reproducibility | have not tried | |
| Status | closed | Resolution | fixed | |||
| Platform | OS | OS Version | ||||
| Summary | 0000005: problemas com sql | |||||
| Description | SQL 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 | |||||
| Tags | No tags attached. | |||||
| Attached Files | ||||||
 Relationships |
|
 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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2010 MantisBT Group |
 |