[firebase-br] RES: Firebird 1.5 - Select From ( Select )
Fernando Burgarelli
fernando.burgarelli em grupoadmseg.com.br
Qua Fev 15 16:25:48 -03 2017
Alguem pode me ajudar estou com um servidor 2008 e tenho 45 bases, usando o
superclassicserver 2.5.6, porem estou tendo muitas quedas pq o sistema
começa a chamar um monte de appserver inflando assim o FB até travar,
coloquei uns logs para verificar o que estava acontecendo
15/02/2017 15:35:05
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:36:48
unable to allocate memory from operating system
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:36:58
unable to allocate memory from operating system
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 15:37:17
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:01:03
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:15:27
unable to allocate memory from operating system
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:15:46
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:15:47
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:15:58
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:16:43
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:17:08
Insufficient memory to allocate page buffer cache
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
15/02/2017 16:17:09
Unable to complete network request to host "127.0.0.1".
Error writing data to the connection.
LICENÇA: F16EB791-7472-4BB7-8183-809CB9D040D6
-----Mensagem original-----
De: lista [mailto:lista-bounces em firebase.com.br] Em nome de Carlos H. Cantu
Enviada em: quarta-feira, 15 de fevereiro de 2017 16:16
Para: FireBase <lista em firebase.com.br>
Assunto: Re: [firebase-br] Firebird 1.5 - Select From ( Select )
Se não me engano, select from select só é suportado a partir do Firebird 2.0
[]s
Carlos H. Cantu
eBook Guia de Migração para o FB 3 - www.firebase.com.br/guiafb3.php
www.FireBase.com.br - www.firebirdnews.org - blog.firebase.com.br
LG> Olá,
LG> Estou tentando fazer um select de um select
LG> *Select Codigo, Descricao*
LG> * From (*
LG> * Select Pa_Id Codigo, Pa_Dc Descricao*
LG> * From S_Pa*
LG> * )*
LG> Mas me retorna o erro:
LG> *"Token unknown - line 3, column 9.*
LG> *Select."*
LG> Alguém sabe me dizer que isso não é possível no Firebird 1.5?
LG> Obrigado.
LG> ______________________________________________
LG> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
LG> Para saber como gerenciar/excluir seu cadastro na lista, use:
LG> http://www.firebase.com.br/fb/artigo.php?id=1107
LG> Para consultar mensagens antigas:
LG> http://www.firebase.com.br/pesquisa_lista.html
______________________________________________
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://www.firebase.com.br/pesquisa_lista.html
Mais detalhes sobre a lista de discussão lista