Re: [firebird-support] How To Track Deadlocks

[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?

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[DougC d...@moosemail.net [firebird-support]]

Pablo-

I tried to use the new google group and have it send you an invite to join the 
group. What Google responded with was:
Some email addresses cannot be added to this group because their accounts are 
disabled or are blocked from Google Groups.




So Google does not like your email address for some reason.

Doug C.

 On Mon, 04 May 2020 18:22:49 -0400 pablo sanchez 
mailto:pab...@adinet.com.uy [firebird-support] 
 wrote 


 I sent an email to mailto:firebird-support+subscr...@googlegroups.com :
 
 /Quote
 From - Mon May 04 19:15:56 2020
 X-Mozilla-Status: 0001
 X-Mozilla-Status2: 0080
 X-Mozilla-Keys: 
 
 To: mailto:firebird-support+subscr...@googlegroups.com
 From: =?UTF-8?Q?Pablo_S=c3=a1nchez?= 
 Subject: Subscribe
 Message-ID: mailto:-83d1-5846-68a2-8f4f48b6a...@adinet.com.uy>
 Date: Mon, 4 May 2020 19:15:55 -0300
 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.7.0
 MIME-Version: 1.0
 Content-Type: text/plain; charset=utf-8; format=flowed
 Content-Transfer-Encoding: 7bit
 Content-Language: en-US
 
 Subscribe
 
 /UnQuote
 
 And I got :
 
 Address not found
 Your message wasn't delivered to 
 mailto:firebird-support+subscr...@googlegroups.com because the address 
couldn't 
 be found, or is unable to receive mail.
 
 Cheers...
 
 Pablo
 
 > 
 > You don't need a Google account to join. Email to
 > mailto:firebird-support+subscr...@googlegroups.com and confirm the join 
 > request
 > by **replying** to the join request.
 > 
 > But yes, if your email address is associated with a google account, then
 > Google will default to your gmail address, even if you subscribed from a
 > different address. To fix this you need to go to
 > https://groups.google.com/forum/#!myforums, find the group, click
 > **Edit** after your name, and change "Email used for membership" to your
 > preferred address.
 > 
 > Mark
 > -- 
 > Mark Rotteveel
 > 
 > 
 >
 

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

[DougC d...@moosemail.net [firebird-support]]

In your description you did not include a step to shutdown the server or 
database on Windows before copying it to Linux. Did you do that?



Doug C.



 On Fri, 17 Apr 2020 05:21:03 -0400 Shane delphi_ric...@yahoo.co.uk 
[firebird-support]  wrote 


 I've been dealing with this company support. https://www.delter.co.za/
 I'm an IT professional. Support Windows, Linux, Apple Mac.
 I have a technical question. When I copy a firebird database, from 
 Windows to the Linux file system through Windows. Deactivate Linux 
 firebird 2.5 first then replace the database. Reactivate the database on 
 Linux. Then start a Windows program that communicates with the database 
 from an IP address.
 The software developer has somehow put a hook in the software. That if 
 the path has changed the database needs to be reset, as in re-registered.
 The big frustration I'm having is the file I'm copying is not corrupt. 
 But when I'm starting it from the Linux server. It corrupt.
 This is according to the support person from delfin.
 Originally the firebird database was working perfectly on the Linux 
 computer.
 There is something in there software to me that has changed that somehow 
 won't see the Database correctly.
 
 Really hope someone could halp clarify why the database goes from not 
 corrupt from Windows to corrupt on Linux.
 
 Kind Regards
 Shane

Re: [firebird-support] Re: Firebird 4.0.0-1436 beta 1

[DougC d...@moosemail.net [firebird-support]]

Please move messages about Firebird 4 (and any unreleased version) to 
developers mailing list!

Re: [firebird-support] Will we move when yahoo Groups close theirs doors?

[DougC d...@moosemail.net [firebird-support]]

Jonatan-



This is far from obvious. Those two choices are simply two possible choices of 
many. 



I would like the Firebird community to get off the antiquated Yahoo service, 
which has presented operational problems fairly regularly, is clearly being 
reduced, and continues to be neglected by Yahoo.



I would certainly like to see the Firebird community consolidate to one 
platform that provides both forum-type access to threads as well as mailing 
list-type access. There are platforms that do both. My current preference is 
discourse.org.



Is this change something the Firebird Foundation could take a lead in?



 On Wed, 23 Oct 2019 08:51:11 -0400 jonatan.laurit...@yahoo.dk 
[firebird-support]  wrote 


 We should move the project to the github and use google groups for 
discussions. It is obvious, wondering, why such proposal has not emerged so far 
already.

Re: [firebird-support] Re: 2.5.9 - LOCALTIME

[DougC d...@moosemail.net [firebird-support]]

Try creating a view on the table that includes renaming the column to another 
name but otherwise includes all other columns in the table and nothing else (no 
joins, etc). Then reference that view in the connected code instead of 
referencing the actual table.




 On Mon, 05 Aug 2019 11:58:53 -0600 mailto:m-zs...@freemail.hu 
[firebird-support]  wrote 


 Hi Mark!



Database dialect is 1 and changing the column name and the connected code is 
not an option either at the moment, unfortunately.



Thanks for the answer though.



Best regards



Zsolt

Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

[DougC d...@moosemail.net [firebird-support]]

There was a link to a list of tools in Helen's message:



https://firebirdsql.org/en/third-party-tools/





 On Wed, 05 Jun 2019 13:40:11 -0400 Rita Liotta ritalio...@roadrunner.com 
[firebird-support]  wrote 



 

Can you name some of these tools? I'm just floundering try to
  find one.

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

[DougC d...@moosemail.net [firebird-support]]

Mon, 04 Mar 2019 12:29:22 -0500 Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support]  wrote 



04.03.2019 18:11, Mark Rotteveel mailto:m...@lawinegevaar.nl [firebird-support] 
wrote: 

> Claiming some must have done something really wrong without clear 

> evidence is not really constructive. 



Yes, but without real data it is impossible to say what's wrong. My crystal 
ball is not 

good enough for that. 







Then it would be much better to just stay out of the conversation.

Re: [firebird-support] Mailing list change?

[DougC d...@moosemail.net [firebird-support]]

Well, let's not throw strawmen into the mix. Let's not assume moving the list 
means going to a web-based service OR going to a fee-based service. If we could 
find a reliable non-cost, non-web forum, is there any big reason not to move 
away from Yahoo's neglected service? Has anyone really looked for viable 
alternatives over the past few years? Doug C.

[firebird-support] Mailing list change?

[DougC d...@moosemail.net [firebird-support]]

In light of the current problem of duplicate messages being sent out, I'd like 
to bring up the idea of changing platforms from the Yahoo Groups platform. Many 
other mailing lists I receive used to use Yahoo Groups but have moved elsewhere 
over the past few years due to recurring issues with Yahoo. I think the 
Firebird lists are the only ones I subscribe to that have not done this. How 
should we explore this? I this idea of interest to other subscribers or admins? 
Doug C.

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

[DougC d...@moosemail.net [firebird-support]]

 On Fri, 04 May 2018 14:10:40 -0400 blackfalconsoftw...@outlook.com 
[firebird-support] firebird-support@yahoogroups.com wrote 



  I am hoping to begin writing a technical article soon that will introduce 
database application developers to these idiosyncrasies who are new to 
Firebird, making their initial forays into using this database engine less 
frustrating.



I have always believed that these types of issues have kept Firebird from being 
realized as a top-contender in the database world.  It is based upon an 
excellent technology foundation and should be exposed more generally for the 
excellent and highly efficient engine that it really is...








I hope you follow through on this, Steve! I agree with your observations.



Doug C.

Re: [firebird-support] Firebird UDF Access configuration failing

[DougC d...@moosemail.net [firebird-support]]

I agree with Mark. SD, you often jerk people around when you could actually 
directly help. The way you often reply just pisses people off.





 On Tue, 27 Mar 2018 06:51:59 -0400 Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] firebird-support@yahoogroups.com wrote 




27.03.2018 12:49, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: 

 Dimitry, it would be more helpful if you explicitly pointed out the 

 problem instead of giving vague hints. 

 

 Yes, but giving a fish to a man used to be considered less helpful than 
teaching him 

how to fish. 

 

Re: [firebird-support] Firebird 3 Developer's Guide released

[DougC d...@moosemail.net [firebird-support]]

Very glad this got done! Thanks to everyone who made it possible.



However, the PDF option yields a 404 error.





 On Fri, 02 Mar 2018 19:21:59 -0500 Helen Borrie hele...@iinet.net.au 
[firebird-support] firebird-support@yahoogroups.com wrote 






The Documentation team is proud to announce that the Firebird 3 

Developer's Guide, by Denis Simonov, is now available in English: 

 

https://www.firebirdsql.org/en/reference-manuals/#fbdevgd30 

 

Re: [firebird-support] Firebird 1.5 on Windows 10 32

[DougC d...@moosemail.net [firebird-support]]

Why, oh why, do you even have a copy of FB 1.5 to use? It has been long left 
behind by the Firebird project. Unsupported for years.



Try a more recent version!







 On Fri, 12 Jan 2018 13:10:28 -0500 fo...@darsys.com.ar [firebird-support] 
firebird-support@yahoogroups.com wrote 




  Hi

 I can't install FB 1.5 on my Windows 10 32b


I get "this app can't run on this PC"

In "more information" opens MS page that says "your app does not work on your 
PC.

In adition, I had it installed it. I think it was unistalled by Windows Update.

Antivirus Eset

Re: [firebird-support] Deadlock error from firebird during midnight

[DougC d...@moosemail.net [firebird-support]]

Please, let us know what the cause ended up being and how you resolved the 
problem!





 On Sat, 02 Dec 2017 23:08:49 -0500 LtColRDSChauhan rdsc1...@gmail.com 
[firebird-support] firebird-support@yahoogroups.com wrote 




  Thanks a lot, Dimitry !

This issue of mine, for which I had posted for help on the 
firebird-net-provider group, is now resolved.

Re: [firebird-support] embedded database with Chinese path

[DougC d...@moosemail.net [firebird-support]]

Hamish-



Windows short path names are decidedly NOT for apps that cannot handle Unicode. 
They were introduced far earlier than that and were intended for programs that 
could not handle anything but the short 8.3 limits for any given file or folder 
name. That they often help with avoiding unicode is a side effect.



Sound like your misunderstanding of this may be contributing to your 
frustration.



Doug C.





 On Tue, 03 Oct 2017 23:25:23 -0400 Hamish Moffatt 
ham...@risingsoftware.com [firebird-support] 
firebird-support@yahoogroups.com wrote 




On 03/10/17 19:59, Dimitry Sibiryakov s...@ibphoenix.com 

[firebird-support] wrote: 

 03.10.2017 2:25, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote: 

 Any ideas? 

 Give up. Firebird does not support unicode characters in database name and 
path. Only ANSI. 

 

 

 

Thanks for confirming what I figured from the source. But this is 

exactly what the Windows short path names are for - if your application 

can't handle Unicode filenames, use the short names. I tried it and it 

fails. Firebird explicitly converts the short path name back to a long 

name it can't use?! 

 

It seems to mostly work with UTF-8 on linux, or at least I had it 

working a couple of years back. 

 

 

Hamish 

Re: [firebird-support] Is this a bug of Firebird?

[DougC d...@moosemail.net [firebird-support]]

Delphi's latest compiler provides a hint in these cases:



var

  x: Int32;

begin

  try

x := 0;

x := 1;

writeln(x);

end.



[dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used

(Line 14 is the one assigning zero.)



 On Thu, 09 Feb 2017 04:30:06 -0500 Tim Ward t...@telensa.com 
[firebird-support] firebird-support@yahoogroups.com wrote 




  It' the equivalent in a conventional programming language of saying:

 

 x = a;

 x = b;

 

 where the compiler is expected to know that neither a not the first assignment 
have any side effects other than the assignment (and where the expression b 
doesn't depend on the value of x)(and where x isn't volatile, ect ect).

 

 A compiler *could* detect and warn about such things (ie it's not forbidden by 
the laws of mathematics) but I don't think I know of any that do. And as there 
are good reasons for deliberately wanting to do the above it could only be a 
warning, not an error. 

Re: [firebird-support] firebird schema changes during backup

[DougC d...@moosemail.net [firebird-support]]

 On Mon, 23 Jan 2017 15:48:15 -0500 Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] firebird-support@yahoogroups.com wrote 



Changing metadata is a bad idea in general. 

 Continuous development is the worst thing that can happen to a database. 







And that is the traditional database's Achilles Heel because "change" is 
inevitable and rapid change is a fact of life today.



If Firebird were to bolster its support for dynamic changes it would become a 
much more attractive beast.


Doug C.

Re: [firebird-support] 2 servers acessing one database

[DougC d...@moosemail.net [firebird-support]]

No, it is not. Two firebird server instances cannot access the same database 
regardless of where it is located.










 On Wed, 16 Dec 2015 06:33:33 -0500 Rudi Feijó 
rudi.fe...@multidadosti.com.br [firebird-support] 
firebird-support@yahoogroups.comwrote 








  Is it possible to use 2 pc’s with firebird installed, accessing a single


 database that resides in a shared storage area network (which is acessible


 to both servers)?