Re: [firebird-support] concat a integer variable to a varchar

2019-01-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.01.2019 9:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: >> RTFM Language Reference. In SQL queries PSQL variables must be used with >> colon. > you could have phrased that a little bit more > friendly and less hostile. English is not my mother-tong you know. What exactl

Re: [firebird-support] concat a integer variable to a varchar

2019-01-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.01.2019 12:02, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > RTFM == Read The Fucking Manual, which - to me - is similar to saying > "You're an idiot and why the fuck are you bothering us with this simple > question.". In my time "F" stayed for "Following" but the world obv

Re: [firebird-support] out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 11:51, eric.gueguin...@gmail.com [firebird-support] wrote: > After suspend, allocated memory should be release no ? No. Blobs whos ID was sent to client cannot be released until transaction end. -- WBR, SD. --

Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 14:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > This is Firebird 2.1 on Linux machine Classic or superserver? -- WBR, SD.

Re: [firebird-support] Re: out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 15:04, eric.gueguin...@gmail.com [firebird-support] wrote: > Why blob are not released in this case, why keep blob id ? If you learn Firebird API, you'll see that BLOB's content is requested to client separately. Server cannot predict that this BLOB won't be requested by client ap

Re: [firebird-support] Re: out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 21:41, sdnetw...@gmail.com [firebird-support] wrote: > maybe could be release when it's read by the client May be. But what is read once can be read twice. Because of that you must be very careful with temporary blobs and don't keep transactions opened more than necessary. --

Re: [firebird-support] Firebird Embedded with .NET Core on macOS

2019-01-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2019 22:49, Anil anil.muja...@gmail.com [firebird-support] wrote: > I'm trying to make it work in embedded mode with .NET Core application on > macOS. The same > scenario (just a dummy console project) works without issues on Windows. AFAIK you cannot just copy files into your applicati

Re: [firebird-support] How to insert characters for barcode code 128 to table via code?

2019-01-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.01.2019 3:12, trsk...@yahoo.com [firebird-support] wrote: > how to insert it via code? char buffer[8]; XSQLDA* sqlda; . sqlda->sqlvar[1].sqldata = buffer; memcpy(buffer, YourBarCode, 8); isc_dsql_execute(., sqlda); -- WBR, SD.

Re: [firebird-support] Falling at second hurdle ...

2019-01-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.01.2019 20:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > So what can I do next to get this to work? You can read Release Notes for Firebird 3.0, chapter "Compatibility Issues" including "Embedded Connections" and "Initializing Security Database". Also reading text of "

Re: [firebird-support] Re: installing fb 1.5 in Mac Mojave

2019-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2019 15:01, wang...@yahoo.com [firebird-support] wrote: > if do a port scan, 3050 is opened, any idea why> this is a classic fb 1.5, > maybe not started? Is (x)inetd started? Does netstat confirm that port 3050 is listened? -- WBR, SD. --

Re: [firebird-support] Re: installing fb 1.5 in Mac Mojave

2019-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2019 15:44, wang...@yahoo.com [firebird-support] wrote: > if i do a telnet localhost 3050, see the 'connected to localhost, escape > char...' > then 'connection closed by foreign host' > if I do a isql connection: > > connect "localhost:/home/sample.fdb', > got error unable to complete netw

Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while

2019-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2019 17:30, duque.herna...@yahoo.com [firebird-support] wrote: > Have anyone had this situation? > > Is it posible that it is related to a Windows version? If your database file has GDB extension, Windows System Restore (including automatic one after some minor reboot errors) can silen

Re: [firebird-support] Question about delay in fetch operation

2019-01-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.01.2019 17:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Im using firebird 3, tried with the latest stable release, and the latest > snapshot from today. Did you try it in embedded mode? -- WBR, SD.

Re: [firebird-support] Question about delay in fetch operation

2019-01-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.01.2019 18:10, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Tried downloading it now but couldnt find the embedded version for firebird 3 Read Release Notes. Embedded mode is used automatically for local connections. -- WBR, SD.

Re: [firebird-support] Connection lost after long inactive time

2019-01-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.01.2019 18:15, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: > Does anybody have an idea what is going on here? Yes. Router (CISCO most likely) or firewall (Comodo) breaks inactive TCP connection. > DummyPacketInterval = 0 (but this should be irrelevant for this type > o

Re: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3

2019-01-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.01.2019 21:13, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > the multi-segment indexes are to optimize commonly used queries. In this case you can consider removing one or two fields from the index and see how much selectivity it lose and how much performance would

Re: [firebird-support] What to install on a client computer

2019-01-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.01.2019 14:16, Ivan Cenov i...@okto7.com [firebird-support] wrote: > What is needed to install on a client computer so as an application to > access Firebird server 2.0.3 > that is  installed on another computer. is there some client > distributable package? Run installer and choose "Minimum

Re: [firebird-support] Question about delay in fetch operation

2019-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2019 13:09, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Can I ask you if there is any good tutorial so one could start learning the > ins and outs > about optimizing queries and plans? I’ve sifted through the available > documentation a few > times but they are

Re: [firebird-support] Built in RegEx Capability?

2019-02-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.02.2019 22:18, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > Ideally I need to extract the 'V' element and the 'p' element into their > own fields so I can look up Volume '12' and page '234' or list all the > pdf's for Volume '12' in page order. You could use "Regular expressio

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.02.2019 16:39, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > My bet is on the addition of the savepoint. Yes, this is the way partial cursor stability is implemented in 3.0: insert-select cannot see changes made inside of the same savepoint, so sub-query in second query

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.02.2019 18:29, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I like the idea of creating an empty database and pumping the data over. Is > there a tool > for this? (Actually just found one from Clever Components) I'd recommend to look at FBCopy/FBExport tools.

Re: [firebird-support] Re: New Firebird project/OpenEMR/Wind8.1/asgalib20/#201902a

2019-02-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.02.2019 20:03, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Mark is correct in his previous reply as I went through some of the > documentation for the > Open EMR System.  The OpenEMR system makes use of the MySQL database engine, > not Firebird. I guess the author wanted t

Re: [firebird-support] Formatting currency

2019-02-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.02.2019 11:57, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if I select this and store it in a varchar-variable, I get 1112223.44, with > the point, not > comma. Storing numbers in varchar fields is a big mistake. -- WBR, SD. -

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.02.2019 12:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > No clue why you'd get that error randomly Because it is not a real error. CORE-4964 hides errors caused by failing connection to security database. Some of them were fixed in post releases. -- WBR, SD. -

Re: [firebird-support] optimal free disk space

2019-02-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.02.2019 13:57, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Do you think having 20GB of free disk space may be a problem? No.Problem is drive's speed and badly designed application that you use. First problem you can solve with SSD and Firebird 4, second problem requires a program

Re: ODP: [firebird-support] Re: Strange behavior on very large table

2019-03-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.03.2019 10:50, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > You have quite big fill 94%, that there is a chence that new page must be > allocated – but > here still you have free slots. It may be a sign of record fragmentation which is bad from performance P

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

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 10:44, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > there other server tweaks to improve the performance for my case? First of all you must define "your case" and find bottleneck by using system monitoring tools. Usual reason for Firebird being slow in virtual machine

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

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > As I mentioned in my first post I run that query for 15 times for each sever > FB,PG,mysql. Are all of them installed and run on the same virtual host? -- WBR, SD. ---

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

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > yes In this case you must done something really wrong. -- WBR, SD. ++

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

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > In this case you must done something really wrong. > > Claiming some must have done something really wrong without clear > evidence is not really constructive. Yes, but without real data it is impossible to sa

Re: [firebird-support] keeping the connection

2019-03-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.03.2019 16:45, wang...@yahoo.com [firebird-support] wrote: > any idea why it got disconnected CISCO router in-between dropped idle TCP connection after configured timeout. -- WBR, SD.

Re: [firebird-support] Can I restrict sysdba to login from localhost?

2019-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2019 9:06, cyc...@gmail.com wrote: > Can I restrict the sysdba to be able to login to firebird server on localhost > only? No. But you can remove SYSDBA account at all and let it use trusted auth or embeded mode. -- WBR, SD.

Re: [firebird-support] Can I restrict sysdba to login from localhost?

2019-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2019 11:07, Rustam rusta...@ukr.net wrote: > I suppose, you can create ON CONNECT trigger and verify 'current_user' and > client remote > IP address against '127.0.0.1' (from MON$ATTACHMENTS table). No, SYSDBA is able to bypass them. -- WBR, SD. -

Re: [firebird-support] Can I restrict sysdba to login from localhost?

2019-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2019 15:17, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > >>No, SYSDBA is able to bypass them. > > Can i ask how and why? SYSDBA can use -no-db-triggers switch and connect without ON CONNECT triggers fire. AFAIU this thread is about preventing of someone outs

Re: [firebird-support] Database corrptions

2019-03-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.03.2019 10:05, ma_go...@yahoo.com [firebird-support] wrote: > We use 2.5.8 CS on Oracle Linux 7.6. It has 200+ database and 4000+ > connections. > > Yesterday we had corruptions in many databases around the same moment. > > These are the different messages in the firebird.log after the corrup

Re: [firebird-support] String conversion to timestamp fails during insertion in 12 hour format

2019-03-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.03.2019 16:05, joje j...@codework-solutions.com [firebird-support] wrote: > Why is it conversion fails in 12 hour format while successful in 24 hour > format? Firebird can recognize only chosen (ANSI standard preferable) timestamp formats and doesn't take system locale into account. --

Re: [firebird-support] Install a DB Firebird on a web site

2019-03-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.03.2019 19:39, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > My question wanted to be: a direct connection is possible (IP:alias) > through a router? Yes, it is possible but this is a) insecure; b) may be slow. If your application is not ready to work over high-lat

Re: [firebird-support] Re: Character set ISO8859_1 is not installed

2019-04-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.04.2019 8:35, b...@tbwb.nl [firebird-support] wrote: > I am using CentOS 7, and installed firebird with > > yum install firebird Use strace to find out where it is looking for fbintl/ICU and why they cannot be found. -- WBR, SD. ---

Re: [firebird-support] How to return a result set of unknown number of columns from an Execute Block?

2019-04-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.04.2019 15:22, Paul Read fireb...@nsolve.com [firebird-support] wrote: > > *Is there a way to return from an execute block a result set with an unknown > number of > columns?* No, there is no way. -- WBR, SD. --

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

2019-04-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.04.2019 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 2. While following connection strings fails: > Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB > localhost:/home/ubuntu_user/Documents/Sample.FDB > 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB It looks li

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > It seems that the DB creation on Windows is resulting in an invalid DB file. Yes. Because you didn't put all necessary files into proper directory structure, Firebird engine failed to load fbintl module. Database file w

Re: [firebird-support] user manager?

2019-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2019 7:27, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > how can I change both sysdba-passwords? The one from srp and the other from > legacy auth? "ALTER USER" clause has "USING" part which set user manager to be used. -- WBR, SD. ---

Re: [firebird-support] user manager?

2019-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2019 15:50, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > ..if I use the fbclient.dll, I can connect with every password, why? Because you use embedded mode and password isn't checked. -- WBR, SD. --

Re: [firebird-support] Automating Firebird maintenance on Linux

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 18:23, my...@techsol.org [firebird-support] wrote: > End users (and end user reporting applications, scripts, etc.) that connect > to this > database are often connected when I attempt to run these maintenance tasks, > so I can never > get the database to go to "offline" mode because

Re: [firebird-support] lock_timeout or isc_tpb_lock_timeout?

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 19:59, hamacker sirhamac...@gmail.com [firebird-support] wrote: > First question: > fdconn1.Params.Values['lock_timeout']:='180'; > or > fdconn1.Params.Values['isc_tpb_lock_timeout']:='180'; > ??? IFAIK, FireDAC can recognize both names, but value for timeout must be an integer, not

Re: [firebird-support] user manager?

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 12:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > I'm using not the embedded mode, or ibexpert uses it? If I configure "local" > and use the > fbclient.dll, every password works. If you read Release Notes for Firebird 3.0 you'll find out that "local" there is u

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.04.2019 15:10, my...@techsol.org [firebird-support] wrote: > but gfix refuses to shutdown the database to single user maintenance mode if > there are any > existing connections to it. Use -force_shutdown. -- WBR, SD. ---

Re: [firebird-support] Granting Create Database via client api

2019-04-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.04.2019 7:03, rgilland1...@gmail.com [firebird-support] wrote: > In order to create a database in Firebird 3 by a non SYSDBA user, a > connection must be > made and th e CREATE DATABASE privilege must be granted. But on a clean > firebird system > there is no database to connect to. SYSD

Re: [firebird-support] Firebird 3 - gstat output about blobs

2019-04-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.04.2019 14:38, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > records are 136628 blobs are 10021, is this mean that some blobs are null? Yes. > blob pages: 0 - what this mean? Blob is stored in the same page as other > fields? Yes. > What about levels 0, 1, 2

Re: [firebird-support] Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

2019-04-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.04.2019 14:11, 'Chris LeFebvre' lefebv...@comcast.net [firebird-support] wrote: > And it seems like the setup should be that the FireDAC TFDPhysFBDriverLink > should have > “Embedded” set to true (which I do) and “VendorLib” should point to > “engine12.dll” located > in the Firebird/plugins

Re: [firebird-support] Strange items in log file

2019-04-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.04.2019 11:52, respekt...@post.cz [firebird-support] wrote: > What should I do with it ??? Check you file system and disc health. There is no way for a piece of system log to sneak into firebird.log except bad storage corruption. -- WBR, SD. ---

Re: [firebird-support] SYSDBA user

2019-04-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.04.2019 7:26, dennisktl...@yahoo.com [firebird-support] wrote: > can i remove SYSDBA user? Yes, you can. -- WBR, SD. ++ Visit http://www.firebi

Re: [firebird-support] How to trigger automatic sweep?

2019-05-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.05.2019 11:44, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > I need a detailed recipe to increase > the gap. In isql: "Set transaction no auto undo" + any DML + rollback. -- WBR, SD.

Re: [firebird-support] Re: firebird mingw

2019-05-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.05.2019 3:41, robol...@yahoo.com [firebird-support] wrote: > I decided definitely to give the package a try in mingw. Maybe I will get > lucky and > someone will agree to update that package at a future time. Nope. MinGW build is completely abandoned. Use binary installation. -- WBR,

Re: [firebird-support] insert data two databases different

2019-05-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.05.2019 16:25, 'Joel Moo' joel@verticalknits.com [firebird-support] wrote: > i stopped the service of > firebird before renaming the file .fdb. If Firebird is in Classic mode stopping of service has no effect to existing connections. -- WBR, SD.

Re: [firebird-support] FB 3 Database hanging in multi-user

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 2:31, Sukhendu Barua sb.peace...@gmail.com [firebird-support] wrote: > I can not reproduce this in my desktop computer to debug. Turn on Firebird transaction audit and analyze logs. Most likely your application has a bad transaction management and transaction in one application is

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 13:03, Drew Jensen drewjensen.in...@gmail.com [firebird-support] wrote: > What is the reason they don't have direct connection to FB servers as an > option? > > No one stepped up to write it. It is an office packet. I personally see no point for it to support anything besi

Re: [firebird-support] FB 3 Database hanging in multi-user

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 15:52, Sukhendu Barua sb.peace...@gmail.com [firebird-support] wrote: > Please tell me how to turn on the Firebird transactions audit. In the FB > config file? Is > there a tool that does it? It is described in doc/README.trace_services and there are tools that can help you analy

Re: [firebird-support] FB classic 3.0.4 - cannot find tip page (165), file: tra.cpp line: 2331

2019-05-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.05.2019 17:41, Vladimir Zbodulja vladimir.zbodu...@pis.eu.com [firebird-support] wrote: > I'm not if this two issues are the same Still it is a good idea to upgrade to current snapshot 3.0.5 first of all. -- WBR, SD.

Re: [firebird-support] Engine12 32 64 bit question

2019-05-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.05.2019 9:32, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > It sounds like your code is attempting to use Firebird Embedded instead > of Firebird Server. Even if not, default configuration put Engine12 to the first place so it is tried before network connection. He sh

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:19, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > What stops me taking a copy of SecretDatabase.fdb and connecting to it on my > own Firebird > installation? You cannot do that if you 1) Have no access to the file (and server file system as whole). 2) Don't know

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:32, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > anyone can open any Firebird database and view the data (unless it happens to > be encrypted). Yes, and it is true for any database server. -- WBR, SD. -

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:54, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > 2) In my testing I was able to open MyDB and view its contents *without > *knowing the > owner's password just by making it use my default security.fbd and > SYSDBA/masterkey. For this you again must have access t

Re: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.05.2019 21:25, 'Dany Schaer' danysch...@yahoo.com [firebird-support] wrote: > What can be the problem with this query undewr 2.5.8? "IN" predicate is in trouble. Get rid of it if possible. -- WBR, SD. +++

Re: ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.05.2019 22:36, danysch...@yahoo.com [firebird-support] wrote: > I don't think this problem is about parameters, there is something that > changed a lot > between 2.5.0 and 2.5.8 that is making this queries to go that slow. http://tracker.firebirdsql.org/browse/CORE-4690 -- WBR, SD.

Re: ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.05.2019 13:37, danysch...@yahoo.com [firebird-support] wrote: > The very important diference is the plan. 2.5.8  is not using MOVI_FECH > index, so it must > read more than one millon records to analize ("MOVI"."FECH" between > '20190301' and > '20190412'). Remove "DISTINCT" from subquer

Re: [firebird-support] Re: Query optimizer is not using the useful indexes.

2019-05-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.05.2019 13:18, danysch...@yahoo.com [firebird-support] wrote: > That (and ONLY THAT) is making my query to need 24 minutes insted of 1 minute. Do you understand that DISTINCT inside of IN is meaningless? -- WBR, SD. --

Re: [firebird-support] Firebird upgrade advise

2019-06-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.06.2019 0:00, SP Ooi sp.ooi@gmail.com [firebird-support] wrote: > May I know what our upgrade path should be to bring our firebird databases to > the > latest version? 1. Install a new server with new Firebird version. 2. Create a new database from script. 3. Pump data from old database.

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: >  Invalid token. >      invalid request BLR at offset 27. >      BLR syntax error: expected valid BLR code at offset 28, encou ntered > 210. This database obviously used some new features of Firebird 3 in stored cod

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use? Create database from scratch, pump data. -- WBR, SD. +

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:26, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > based application is written for 2.5,just some test are done for Fb 3,in case > something > goes wrong, must go back to 2.5 until a fix is done,so that restore is need. That's a wrong way of migration. Better set

Re: [firebird-support] Help interpret plan

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Would this mean that the table F would be subject to a full natural scan > for each record of the preceding joins? Yes. -- WBR, SD. ---

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:53, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I've extracted db into a script You must have a "master script" instead of extracting metadata from live database. Ask the database author for it. -- WBR, SD. ---

Re: [firebird-support] Open database connection fails

2019-06-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.06.2019 11:48, gregorkob...@yahoo.com [firebird-support] wrote: > May somebody has me a hint. https://support.microsoft.com/en-us/help/239924/how-to-disable-the-media-sensing-feature-for-tcp-ip-in-windows -- WBR, SD.

Re: [firebird-support] rw vs ro connections

2019-06-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.06.2019 17:51, Nick Upson n...@telensa.com [firebird-support] wrote: > Should I expect any performance gain if I change my rw connections to ro, > given that the > query is always of the form "select * from ..." At first, there is no such things as "ro connection". At second, ro transac

Re: [firebird-support] index vs page size

2019-06-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.06.2019 17:10, Nick Upson n...@telensa.com [firebird-support] wrote: > Can anyone suggest other actions I could take. Increase page cache size to ensure that this index fits into it. Re-consider size of field(s) in this index. -- WBR, SD. -

Re: [firebird-support] query Integer overflow

2019-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64 My advice is "never perform calculations (especially multiplication and division) in SQL". Your expression has result of type NUMERIC(18,14) an

Re: [firebird-support] query Integer overflow

2019-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > The calculation is on a SP code and I need it there Then get rid of IIF and decide at which moment you need round intermediate values. Then cast the values to types with smaller precision. -- WBR, SD.

Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.07.2019 18:11, duque.herna...@yahoo.com [firebird-support] wrote: > What am I doing wrong? You misunderstood documentation. Sweep does move OAT (and collect garbage as a side effect), but it has nothing to do with Next Transaction. Numbers from your gstat output tell that your applicati

Re: [firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.07.2019 16:55, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > Is it possible that this works totally different in MS SQL? Yes, it works totally different in MS SQL. Yes, only AFTER and INSTEAD OF triggers are available there. Besides, they are statement-level, not row-l

Re: [firebird-support] Read OAT value

2019-07-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.07.2019 16:14, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Is then a different way to read oldest active transaction from the connected > db client? isc_database_info(isc_info_oldest_active) -- WBR, SD.

Re: [firebird-support] Re: run firebird engine without fbguard

2019-07-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.07.2019 12:16, peshk...@mail.ru [firebird-support] wrote: > server does not contain code to daemonize itself, i.e. you will have to > perform all > required for it activity yourself. systemd does not require daemonization from services. If firebird use own listener it is enough to choose

Re: [firebird-support] Help creating expression index

2019-07-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.07.2019 17:54, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I want to create a index to improve a query like that: >     SELECT * FROM MYTABLE WHERE EXTRACT(YEAR FROM datein)=2019  AND > EXTRACT(MONTH FROM > datein)=1 Rewrite it as SELECT * FROM MYTABLE WHERE datein between

Re: [firebird-support] System requirements for the Firebird 3.0

2019-08-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.08.2019 15:35, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > I would like to know if someone can help me with the minimum system > requirements for the > Firebird 3.0, specific for Debian distribution. Distribution, kernel and so > on. Debian has Firebird in standar

Re: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.08.2019 14:05, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support] wrote: > Which is the best way to check if a database exist if my connection is alias > based? > > I have to try to connect and manage response? Yes, this is the only way. -- WBR, SD. -

Re: [firebird-support] SELECT FIRST N BY GROUP

2019-08-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.08.2019 14:26, pg...@mccolls.co.uk [firebird-support] wrote: > Is this possible in a single SELECT query I would try WHERE ROW_NUMBER() OVER (PARTITION BY empid, ORDER BY effdate) <= 2. -- WBR, SD. +

Re: [firebird-support] How to trigger automatic sweep?

2019-08-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.08.2019 21:03, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Any other tips? Turn on transaction audit and see what happened to OIT/OAT. -- WBR, SD.

Re: [firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.08.2019 14:36, Róbert Sisa robert.s...@dyntell.com [firebird-support] wrote: > Can anybody help me?  It looks like a FB bug... No, this is not a bug. Yes, monitoring tables are slow and locking whole server to get snapshot of its state. Don't use them unless absolutely necessary. --

Re: [firebird-support] Error code help

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.08.2019 16:24, Todd Pickler t...@midlandsxray.com [firebird-support] wrote: > Can anyone help with this error? > > Getting SQL error code = -206 This is a very generic error code with meaning "something is wrong". You must read the rest of the error message for details. -- WBR, SD.

Re: [firebird-support] Array datatype?

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2019 15:29, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I define an array datatype and use it in some functions? No way. Forget about arrays in Firebird. -- WBR, SD. +

Re: [firebird-support] Array datatype?

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2019 16:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > is there no way? I know the thing with the execute statement, but it is not > the best > solution. I would like to add a value, if the weekday is 1 (Monday), then I > would like to > take the variable t1 and add the

Re: [firebird-support] MS-Windows<-->Linux compatibility

2019-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.08.2019 13:06, emou...@yahoo.fr [firebird-support] wrote: > In theory, if I create a Firebird database with IBExpert under MS-Windows, is > it then > possible to use it with a Linux application (written in Lazarus), giving it > all the right > rights, ie without going through an IBExpert's s

Re: [firebird-support] Re: Is this a bug in ROUND function?

2019-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.08.2019 13:45, m.djo...@gmail.com [firebird-support] wrote: > In binary representation of the values maybe 4.72 is the closest, but we are > talking about > mathematic. There is no point to talk about mathematic while we all working with binary computers. -- WBR, SD. -

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird > use all > cpus/cores? Or should I set it to 15 for 4 cores? I have found some > information for the > 2.5 only. For Firbird 3 CPU af

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:12, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I understand this gap? The biggest probability is a memory leak in your UDFs. -- WBR, SD. +

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:53, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > but the UDFs I haven’t change in. So a leak in them (if any) has no chance to be fixed. > How can I delimit this leak? Can I debug > the memory? Developers version of Firebird writes memory leaks into file on e

Re: [firebird-support] 32 Bit and 64 Bit

2019-09-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.09.2019 15:35, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > Can I use the 64 Bit Client-Installation of Firebird for the clients or > should I take the > 32-Bit firebird installer to install the minimum client installation? Applications cannot use libraries of different bi

Re: [firebird-support] Basic Re-Start

2019-09-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.09.2019 14:52, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > I don't know the answer to some questions: I recommend you to read Firebird Quick Start Guide and other documentation in doc folder. -- WBR, SD. -

Re: [firebird-support] Basic Re-Start

2019-09-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > What the the link for downloading Embedded Firebird? None. Read Firebird 3 Release Notes. -- WBR, SD. ++

Re: [firebird-support] Trigger checking for empty strings and replace with NULL

2019-10-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.10.2019 15:43, 'pc_f...@bluewin.ch' pc_f...@bluewin.ch [firebird-support] wrote: > Is it Possible to create a solution that checks every existing field that > exists on the > table ? No. -- WBR, SD. ++

<    1   2   3   4   5   6   7   8   >