[firebase-br] Problema com firebird e Site
Carlos H. Cantu (TeamFB)
listas em warmboot.com.br
Sex Fev 1 21:35:15 -03 2008
Mandei o seu log para o Vlad Horsun, e ele disse que o log não diz
nada de util. Pediu para vc configurar o Dr.Watson com a versão do FB
que vem com os arquivos PDB, assim consegue gerar um log com mais
informações. Para saber como fazer isso, veja o seguinte artigo:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_pdb_win32
Outra coisa, no Windows >= NT, é recomendado não usar o FB Guardian se
estiver rodando o FB como serviço, pois o próprio Windows pode
restartar o servidor se ele cair.
[]s
Cantu (Membro do TeamFB - FireBase)
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
MA> Sei que já estou enxendo o saco com esse meu problema, mas é que já estou
MA> meio que desesperado, pois está durando menos de 30 minutos o server ativo,
MA> já tentamos de tudo sem nenhum sucesso, por favor se alguem puder ajudar.
MA> Estava tudo normal e de uma hora para outra começou isso.
MA> As coisas que foram feitas ultimamente no servidor foram:
MA> - Baixado e instalado todos os Packs do windows 2003 server
MA> - Passado antivirus
MA> - Instalado o SpyBot e passado no servidor
MA> Segue abaixo os ultimos logs gerados no firebird.log
MA> SP0288A (Server) Fri Feb 01 12:14:53 2008
MA> XNET error: get_free_slot() failed
MA> SP0288A (Server) Fri Feb 01 12:14:53 2008
MA> Database:
MA> unknown ISC error 0
MA> SP0288A (Client) Fri Feb 01 12:32:59 2008
MA> C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated
MA> abnormally (4294967295)
MA> SP0288A (Client) Fri Feb 01 12:33:00 2008
MA> Guardian starting: C:\Program
MA> Files\Firebird\Firebird_2_0\bin\fbserver.exe
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: read errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: read errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: read errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: read errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
MA> Uncommitted work may have been lost
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
MA> Uncommitted work may have been lost
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
MA> Uncommitted work may have been lost
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
MA> Uncommitted work may have been lost
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:03 2008
MA> INET/inet_error: send errno = 10054
MA> SP0288A (Client) Fri Feb 01 12:33:04 2008
MA> INET/inet_error: connect errno = 10061
MA> SP0288A (Client) Fri Feb 01 12:33:06 2008
MA> INET/inet_error: connect errno = 10061
MA> SP0288A (Client) Fri Feb 01 14:11:30 2008
MA> C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated
MA> abnormally (4294967295)
MA> SP0288A (Client) Fri Feb 01 14:11:31 2008
MA> Guardian starting: C:\Program
MA> Files\Firebird\Firebird_2_0\bin\fbserver.exe
MA> SP0288A (Server) Fri Feb 01 14:12:46 2008
MA> Shutting down the Firebird service with 17 active connection(s) to 1
MA> database(s)
MA> SP0288A (Server) Fri Feb 01 14:12:46 2008
MA> The database C:\RADIOSAQUI\DADOS_GERAIS\DADOS_MODULOS.FDB was being
MA> accessed when the server was shutdown
MA> SP0288A (Client) Fri Feb 01 14:12:46 2008
MA> C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: normal shutdown
MA> SP0288A (Client) Fri Feb 01 14:12:52 2008
MA> Guardian starting: C:\Program
MA> Files\Firebird\Firebird_2_0\bin\fbserver.exe
MA> os Alarcon" <marcos em omegasistemas.com.br>
MA> escreveu na mensagem news:fnv5ar$pg8$1 em ger.gmane.org...
>> Hoje caiu novamente, e o log registrado no firebird.log foi:
>>
>> SP0288A (Client) Fri Feb 01 10:52:20 2008
>> C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated
>> abnormally (4294967295)
>>
>> SP0288A (Client) Fri Feb 01 10:52:24 2008
>> Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
>>
>> SP0288A (Server) Fri Feb 01 10:52:24 2008
>> XNET error: XNET server initialization failed
>>
>> SP0288A (Server) Fri Feb 01 10:52:24 2008
>> Database:
>>
>> SP0288A (Client) Fri Feb 01 10:52:30 2008
>> INET/inet_error: send errno = 10054
>>
>> SP0288A (Client) Fri Feb 01 10:52:30 2008
>> INET/inet_error: send errno = 10054
>>
>> depois segue dando esse ultimo erro continuamente, e para voltar o serviço
>> é necessário finalizar o FBServer.exe
>>
>> Obs: O Firewall do Windows está ativo e a porta 3050 está bloqueada.
>>
>> Desde já agradeço pela atenção dispensada.
>>
>>
>>
>> "Carlos H. Cantu (TeamFB)"
>> <listas em warmboot.com.br> escreveu na mensagem
>> news:527927773.20080131170537 em warmboot.com.br...
>> E no log do Firebird (firebird.log)?
>>
>> []s
>> Cantu (Membro do TeamFB - FireBase)
>> http://www.warmboot.com.br
>> FireBase - http://www.FireBase.com.br
>>
>> MA> Só pra esclarecer a questão, no servidor quando cai o serviço gera o
>> MA> seguinte log no servidor:
>>
>>
>>
>> ______________________________________________
>> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
>> Para saber como gerenciar/excluir seu cadastro na lista, use:
>> http://www.firebase.com.br/fb/artigo.php?id=1107
>> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
>>
>>
>>
>>
>>
MA> --------------------------------------------------------------------------------
MA> ______________________________________________
MA> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
MA> Para saber como gerenciar/excluir seu cadastro na lista, use:
MA> http://www.firebase.com.br/fb/artigo.php?id=1107
MA> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
Mais detalhes sobre a lista de discussão lista