Re: [firebird-support] How To Track Deadlocks

2020-05-13 Thread DougC d...@moosemail.net [firebird-support]
You need to move this question to mailto:firebird-supp...@googlegroups.com



See https://groups.google.com/d/forum/firebird-support



 On Wed, 13 May 2020 16:39:15 -0400 Roberto Vieweg 
jjw.roberto.fireb...@gmail.com [firebird-support] 
 wrote 


 Hi.
 
 I have a environment with 150 connections over my database.
 
 My application needs to use "Wait On Locks".
 A recent change in my application (client / server architeture) starts
 to get in some deadlocks.
 
 I found this article
 https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
 massive use of the database turns impossible to motitor the FBTRACE
 output.
 
 So, there is some way to track this deadlocks using the MON$ tables
 using a query?




[firebird-support] How To Track Deadlocks

2020-05-13 Thread Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support]
Hi.

I have a environment with 150 connections over my database.

My application needs to use "Wait On Locks".
A recent change in my application (client / server architeture) starts
to get in some deadlocks.

I found this article
https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
massive use of the database turns impossible to motitor the FBTRACE
output.

So, there is some way to track this deadlocks using the MON$ tables
using a query?


[firebird-support] FB Win -> Linux - Character Set not installed

2020-05-13 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello Friends.

I am migrating a FB DB from Windows 10 64 to Linux 64 (CentOS 7.8).

When restoring FBK (generated in Windows) to the Linux FB DB the Error:  
CHARACTER SET WIN1252 is not installed is showed.

I already tried to replace DEFAULT CHARACTER SET to UTF8 in the Windows FB DB 
before backuping, but did not work.

Any suggestion?

Thank you.

Atenciosamente,

+ + Hugo Eyng + +


RE: [firebird-support] Firebird x CentOS 7

2020-05-13 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you Mr. Makowski

Atenciosamente,

+ + Hugo Eyng + +


De: firebird-support@yahoogroups.com  em nome 
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] 

Enviado: quarta-feira, 13 de maio de 2020 06:40
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Firebird x CentOS 7

Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
>
> About:
>
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
>
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
>
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links





ODP: [firebird-support] Trigger created as inactive

2020-05-13 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi

First change group from yahoo to google group.

And without whole reproducible script no one can help i suppose

Regards,
Karol Bieniaszewski


Re: [firebird-support] Firebird x CentOS 7

2020-05-13 Thread Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]
Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
> 
> About:
> 
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
> 
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
> 
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/