Re: [Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-16 Thread Thomas Steinmaurer
Hi Mark, On 2021-09-13 15:59, Maya Opperman wrote:   Another possibility is to set coercion rules for new data type for your connection, see https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-msql-set-bind-native-to-legacy-coercion-rules Thanks

Re: [Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-13 Thread Thomas Steinmaurer
Hello Vlad, 13.09.2021 11:43, Thomas Steinmaurer wrote: Hello, congratulations to the Firebird 4 release! How do I best find out what has been changed in the area of MON$ tables and especially Firebird Trace API. MON$ tables get a bit of mentioning in the Release Notes, e.g. what fields

[Firebird-devel] Firebird 4 - MON$ / Trace API changes?

2021-09-13 Thread Thomas Steinmaurer
Hello, congratulations to the Firebird 4 release! How do I best find out what has been changed in the area of MON$ tables and especially Firebird Trace API. MON$ tables get a bit of mentioning in the Release Notes, e.g. what fields have been added etc. resp. I could extract the DDL for all

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
> 14.11.2016 21:00, Thomas Steinmaurer wrote: > >> But still, IMHO it does not explain why additional connect request with >> SS while running OLTP emul with 100 users are taking considerable time, >> although they are almost instant with SC? > >This is no

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi Vlad, > 14.11.2016 20:27, Thomas Steinmaurer wrote: > ... >> So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still >> recommended with Firebird 3 SS and the shared page cache, to rather use >> a smaller number, lets say 50K and keep the FileSystemCacheThr

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello Vlad, > 14.11.2016 16:09, Thomas Steinmaurer wrote: >> Hello Simon, >> >>> Thomas Steinmaurer <t...@iblogmanager.com> wrote Mon, 14 Nov 2016 15:03:41 >>> +0300: >>> >>>> Hello, >>>> >>>> using Firebird-3

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello Simon, > Thomas Steinmaurer <t...@iblogmanager.com> wrote Mon, 14 Nov 2016 15:03:41 > +0300: > >> Hello, >> >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 ph

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi, > Hi, > >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >> >> Performance related changes in firebird.conf are: >> >> DB Page Size = 8K >> DefaultDbCachePages = 128K (DB specific page

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hi, > using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. > with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) > > Performance related changes in firebird.conf are: > > DB Page Size = 8K > DefaultDbCachePages = 128K (DB specific page buffers = 0) >

[Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Thomas Steinmaurer
Hello, using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) Performance related changes in firebird.conf are: DB Page Size = 8K DefaultDbCachePages = 128K (DB specific page buffers = 0) TempCacheLimit

Re: [Firebird-devel] Profiling Windows native process?

2016-11-14 Thread Thomas Steinmaurer
in-visual-studio-2015/ > > On Mon, Nov 14, 2016 at 9:21 AM, Thomas Steinmaurer <t...@iblogmanager.com > <mailto:t...@iblogmanager.com>> wrote: > > Hello, > > do you have any recommendations what toolset to use when it comes to > profiling a Windows nati

[Firebird-devel] Profiling Windows native process?

2016-11-13 Thread Thomas Steinmaurer
Hello, do you have any recommendations what toolset to use when it comes to profiling a Windows native process resp. Firebird 3.0.1 in particular? Basically I intend to see where time is spent (or perhaps it is a sync contention) when running a loadtest against Firebird 3.0.1 SS 64-bit on

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-15 Thread Thomas Steinmaurer
> Whole story here : > > https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA > > Copy of message > - - - - - - - - - - - - - - - - > Is there a tool (or way) to debug database step by step. > > Now we have weird situation where delete from one database fails, on > foreign key

Re: [Firebird-devel] Usage of COLLATION specific attribute 'DISABLE-EXPANSIONS'

2016-08-31 Thread Thomas Steinmaurer
Hello Adriano, > Adriano, > >> On 21/07/2016 05:42, Thomas Steinmaurer wrote: >>> Any further ideas? >>> >>> >> What the DE_DE collation expands, and you don't need to add parameter, >> are these chars: >> >> static const ExpandC

Re: [Firebird-devel] C++11 features

2016-08-31 Thread Thomas Steinmaurer
> 31.08.2016 05:14, Adriano dos Santos Fernandes wrote: >> >> In the code I'm writing, I had good opportunities to use some features >> that the compiler flags we're using disallowed, like lambda and default >> arguments for template parameter. >> >> Also we have the ubiquitous ugly iterator types

Re: [Firebird-devel] Usage of COLLATION specific attribute 'DISABLE-EXPANSIONS'

2016-07-21 Thread Thomas Steinmaurer
Adriano, > On 21/07/2016 05:42, Thomas Steinmaurer wrote: >> Any further ideas? >> >> > What the DE_DE collation expands, and you don't need to add parameter, > are these chars: > > static const ExpandChar ExpansionTbl[NUM_EXPAND_CHARS + 1] = { > {230,

Re: [Firebird-devel] Usage of COLLATION specific attribute 'DISABLE-EXPANSIONS'

2016-07-21 Thread Thomas Steinmaurer
On 20.07.2016 13:19, Thomas Steinmaurer wrote: > Hello Adriano, > >> On 20/07/2016 04:35, Thomas Steinmaurer wrote: >>> Hello, >>> >>> I need to sort umlauts in its expanded expression (ae, oe, ue), thus I >>> thought >>> to define my own

Re: [Firebird-devel] Usage of COLLATION specific attribute 'DISABLE-EXPANSIONS'

2016-07-20 Thread Thomas Steinmaurer
Hello Adriano, > On 20/07/2016 04:35, Thomas Steinmaurer wrote: >> Hello, >> >> I need to sort umlauts in its expanded expression (ae, oe, ue), thus I >> thought >> to define my own collation based on DE_DE, but this does not seem to work. >> Perh

[Firebird-devel] Usage of COLLATION specific attribute 'DISABLE-EXPANSIONS'

2016-07-20 Thread Thomas Steinmaurer
Hello, I need to sort umlauts in its expanded expression (ae, oe, ue), thus I thought to define my own collation based on DE_DE, but this does not seem to work. Perhaps it is not supported anyway that way. Test case: create collation de_de_expansion for iso8859_1 from de_de

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-22 Thread Thomas Steinmaurer
>> I could simply use the entire snapshot build and sync the moving parts like >> security database, conf files, UDFs etc. or perhaps I could simply replace a >> single (executable) file (firebird.exe?) taken from the snapshot ZIP file? >> > > Not firebird.exe but engine12.dll. Thanks! Thomas

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-22 Thread Thomas Steinmaurer
>> 21.04.2016 13:35, Thomas Steinmaurer wrote: >> ... >>>> As you already found that fbtracemgr is OK, i guess something is not >>>> fully >>>> correct (or stepped on some another issue) at FB Trace Manager. Could you >>>> show

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-22 Thread Thomas Steinmaurer
> 21.04.2016 13:35, Thomas Steinmaurer wrote: > ... >>> As you already found that fbtracemgr is OK, i guess something is not >>> fully >>> correct (or stepped on some another issue) at FB Trace Manager. Could you >>> show >>> how do you wor

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
> 21.04.2016 13:35, Thomas Steinmaurer wrote: > ... >>> As you already found that fbtracemgr is OK, i guess something is not >>> fully >>> correct (or stepped on some another issue) at FB Trace Manager. Could you >>> show >>> how do you wor

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
> On 04/21/2016 12:47 PM, Thomas Steinmaurer wrote: >> Hi Alex, >> >>>>> Hello Vlad, >>>>> >>>>>>> 20.04.2016 0:47, Thomas Steinmaurer wrote: >>>>>>> ... >>>>>>>> What else could I provi

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
Hello Vlad, >>> Have you had time to look at it? > > Looking now, but seems you already on the way ;) > >>> Unfortunately this now also has happened in a production environment at >>> a customer site. >>> >>> We did quite some testing in the trace area at Firebird 3 Alpha stage >>> and I

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
Hi Alex, >>> Hello Vlad, >>> >>>>> 20.04.2016 0:47, Thomas Steinmaurer wrote: >>>>> ... >>>>>> What else could I provide so that you can investigate the offending >>>>>> thread? >>>>> Ful

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
Hi again, > Hello Vlad, > >>> 20.04.2016 0:47, Thomas Steinmaurer wrote: >>> ... >>>> What else could I provide so that you can investigate the offending >>>> thread? >>> >>>Full memory dump, please. > > Have y

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Thomas Steinmaurer
Hello Vlad, >> 20.04.2016 0:47, Thomas Steinmaurer wrote: >> ... >>> What else could I provide so that you can investigate the offending >>> thread? >> >>Full memory dump, please. Have you had time to look at it? Unfortunately this now als

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-20 Thread Thomas Steinmaurer
Vlad, > 20.04.2016 0:47, Thomas Steinmaurer wrote: > ... >> What else could I provide so that you can investigate the offending >> thread? > > Full memory dump, please. I'm not that familiar with WinDbg and played around with it. The stack trace of the hig

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-20 Thread Thomas Steinmaurer
Hello Vlad, > 20.04.2016 0:47, Thomas Steinmaurer wrote: > ... >> What else could I provide so that you can investigate the offending >> thread? > > Full memory dump, please. I have been using sysinternals procdump for that with: procdump -ma Is t

[Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-19 Thread Thomas Steinmaurer
Hello, first of all, congratulations to Firebird 3. I'm basically seeking for assistance pin-pointing an issue here with Firebird 3 SuperServer 32-bit on Windows 10 Prof., as it seems, in the context of the Trace API. This all is not an issue with Firebird 2.5. Unfortunately, it is only

Re: [Firebird-devel] Version 4 and network shares

2016-04-05 Thread Thomas Steinmaurer
> 05.04.2016 18:24, Dimitry Sibiryakov wrote: >> >> In V4 will we still support connection to database on network share or >> mapped drive >> using the trick with overwriting "local" connection string to named pipes >> one? >> I.e. can expand_share_name() be cleaned out of isc_file.cpp? > > I'd

Re: [Firebird-devel] Firebird 3 - Embedded deployment - Secure database login

2015-10-20 Thread Thomas Steinmaurer
Hello Dmitry, > 20.10.2015 00:18, Thomas Steinmaurer wrote: >> >> with Firebird 3, what are the capabilities to disallow unwanted users to >> open my database? >> >> I thought perhaps preparing a database pointing to itself as security >> database might be a

Re: [Firebird-devel] Firebird 2.5.4 - Trace API - CREATE TRIGGER not captured including RDB$GET_CONTEXT

2015-10-20 Thread Thomas Steinmaurer
Alexander, >> Hello, >> >> I'm using Firebird 2.5.4 x86 on Windows 7. >> >> A simple table: >> >> CREATE TABLE T1 >> ( >> ID INTEGER NOT NULL, >> CONSTRAINT PK_T1 PRIMARY KEY (ID) >> ); >> >> >> The following trace configuration: >> >> >> enabled true >> log_connections true >>

[Firebird-devel] Firebird 3 - Embedded deployment - Secure database login

2015-10-19 Thread Thomas Steinmaurer
Hello, with Firebird 3, what are the capabilities to disallow unwanted users to open my database? I thought perhaps preparing a database pointing to itself as security database might be an option (MON$DATABASE.MON$SEC_DATABASE=Self), but this database then still can be opened by an embedded

[Firebird-devel] Firebird 2.5.4 - Trace API - CREATE TRIGGER not captured including RDB$GET_CONTEXT

2015-10-19 Thread Thomas Steinmaurer
Hello, I'm using Firebird 2.5.4 x86 on Windows 7. A simple table: CREATE TABLE T1 ( ID INTEGER NOT NULL, CONSTRAINT PK_T1 PRIMARY KEY (ID) ); The following trace configuration: enabled true log_connections true log_transactions true log_statement_finish true print_plan true

[Firebird-devel] Firebird 3 - Trace API - Single CPU core fully occupied when stopping trace session

2015-10-16 Thread Thomas Steinmaurer
Hello, I'm using a Firebird 3 x86 Windows snapshot (SuperServer) from October 15, 2015 using Pavel's OLTP emulator to put load on Firebird, the trace functionality and our FB TraceManager. I'm using the following trace configuration: database = oltpemul.fdb { enabled = true

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Thomas Steinmaurer
Vlad, I can't exactly recall concrete numbers from the past, but I wonder if Firebird can currently go beyond 10MB/s disk I/O utilization. And this is not about being limited by spinning disk and seek time (random I/O). You'll be wonder if reevaluate concrete numbers... Firebird 3 or

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Thomas Steinmaurer
On Saturday, March 21, 2015, Thomas Steinmaurer t...@iblogmanager.com mailto:t...@iblogmanager.com wrote: IMHO 99% of the Firebird customer-base isn't in the distributed system business, thus state-of-the art scale up (instead of scale out) capabilities on a single server

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Thomas Steinmaurer
I can't exactly recall concrete numbers from the past, but I wonder if Firebird can currently go beyond 10MB/s disk I/O utilization. And this is not about being limited by spinning disk and seek time (random I/O). You'll be wonder if reevaluate concrete numbers... Firebird 3 or even

Re: [Firebird-devel] NoSQL, Transactions, and Minor Flames

2015-02-20 Thread Thomas Steinmaurer
On Thursday, February 19, 2015, Thomas Steinmaurer t...@iblogmanager.com mailto:t...@iblogmanager.com wrote: Jim, http://www.cio.co.uk/insight/data-management/jim-starkeys-nosql-low-down-it-wont-solve-big-data-3598479/ What do you think about tunable consistency

Re: [Firebird-devel] NoSQL, Transactions, and Minor Flames

2015-02-20 Thread Thomas Steinmaurer
Are you using the durability term strictly in the area of transactions or in a sense that a successful write survives a system crash? Durability has all sorts of interesting characteristics. In general, it means that after something bad, committed transactions persist. The questions are

Re: [Firebird-devel] NoSQL, Transactions, and Minor Flames

2015-02-19 Thread Thomas Steinmaurer
Jim, http://www.cio.co.uk/insight/data-management/jim-starkeys-nosql-low-down-it-wont-solve-big-data-3598479/ What do you think about tunable consistency instead of eventual consistency? http://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_config_consistency_c.html Thanks,

Re: [Firebird-devel] Wire compression and zlib on Windows

2014-11-28 Thread Thomas Steinmaurer
Recently wire compression was implemented by Alex. It uses well known zlib library. Have you guys considered LZ4? https://code.google.com/p/lz4/ It is getting very popular in the big-data / NoSQL area for both, compressing data on disk and over-the-wire. Regards, Thomas On Linux zlib

Re: [Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Thomas Steinmaurer
Hi, Is there a way to add/remove NOT NULL to a column using single DDL command in Firebird (2.5 for the start)? I'm tuning support for Entity Framework Migrations in .NET provider and this is one case. This will be available in Firebird 3. Regards, Thomas

Re: [Firebird-devel] Multiple instances under windows (was Re: Using Firebird 3, beta 1 - installer report)

2014-10-27 Thread Thomas Steinmaurer
Obviously it is possible to add support for multiple installs, although it does add complexity to the installer and we don't really have a way at the moment to deal with uninstallation because we don't have a mechanism in place to track what instances of firebird are running on which ports. I

[Firebird-devel] Firebird 3 Beta 2 according to tracker

2014-10-27 Thread Thomas Steinmaurer
Hello, does the following reflect the real status quo on what needs to be done for Beta 2? http://tracker.firebirdsql.org/browse/CORE/fixforversion/10586 Thanks, Thomas -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Thought about constraint declarations for V4

2014-10-27 Thread Thomas Steinmaurer
When we decided not to validate constraints on declaration, our reasoning was that computations and database access were expensive and any decent application programmer or DBA would always validate constraints before declaring them and control access to the constrained items until the

Re: [Firebird-devel] Prague

2014-10-20 Thread Thomas Steinmaurer
Ann and I are settled at the hotel in Prague. Looking forward to seeing everyone. Unfortunately I can't attend, but make sure to spoil the bar and session recording works (if there is any). ;-) Good luck and have fun. Thomas

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-03 Thread Thomas Steinmaurer
RELATION_NAME = Statement failed, SQLSTATE = 22001 arithmetic exception, numeric overflow, or string truncation -string right truncation -expected length 10, actual 21 SQL Seems to be a problem with using the TYPE OF clause for the data type. When I replace that with e.g.

Re: [Firebird-devel] Firebird 3.0.0.31348 - Weird domain metadata for newly created domain

2014-10-03 Thread Thomas Steinmaurer
03.10.2014 21:20, Martijn Tonies (Upscene Productions) wrote: I get exactly what's happening. And it's clear to me -something- has changed in this regard, cause if it weren't, everything would be just fine. Then tell us how a properly written application (the one not ignoring the NULL

Re: [Firebird-devel] Firebird 3.0.0.31348 - Weird domainmetadata for newly created domain

2014-10-03 Thread Thomas Steinmaurer
Martijn, P.S. This discussion is purely theoretical as compatibility has already been restored in the meantime. I never said a properly written application could be affected, I said something has clearly changed as existing applications suddenly return the wrong result. A change that

Re: [Firebird-devel] Firebird 3.0.0.31348 - Weird domainmetadata for newly created domain

2014-10-03 Thread Thomas Steinmaurer
P.S. This discussion is purely theoretical as compatibility has already been restored in the meantime. I never said a properly written application could be affected, I said something has clearly changed as existing applications suddenly return the wrong result. A change that only affects

[Firebird-devel] Firebird 3.0.0.31348 - Weird domain metadata for newly created domain

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. I have the following sequence of created domains in isql: SQL create domain d_mydomain bigint; SQL commit; SQL create domain d_mydomain_1 bigint; SQL commit; SQL create domain d_mydomain_2 bigint; SQL create

[Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. In a UTF8 database, I have a table with the following name: A_VERY_LONG_TABLENAME And a package with a single selectable SP, basically querying the table names: SET TERM ^^ ; CREATE OR ALTER PACKAGE

Re: [Firebird-devel] Firebird 3.0.0.31348 - string truncation error

2014-10-02 Thread Thomas Steinmaurer
Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. In a UTF8 database, I have a table with the following name: A_VERY_LONG_TABLENAME And a package with a single selectable SP, basically querying the table names: SET TERM ^^ ; CREATE OR ALTER PACKAGE

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Thomas Steinmaurer
Sean, 1. A query's operations (the reading of the data and sorting) execute in a single thread/process, correct? Correct. 2. Is Internal sorting performed by the ExecuteWriteTempSortBlock() step? Internal buffer is sorted as soon as filled up to its limit and then written into

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Thomas Steinmaurer
Claudio, -Original Message- From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] Sent: Domingo, 04 de Mayo de 2014 5:43 Personally, I find it frustrating to what Firebird disk IO profile when performing large select/sorts, on systems which have IO to burn (RAM Disk, SSD or PCIe

Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?

2014-02-22 Thread Thomas Steinmaurer
Hello Vlad, When I execute a stored procedure (with or without package, doesn't matter), e.g.: select * from pkg_schema.s_user_tables; I also see appropriate PREPARE_STATEMENT etc. events for the SELECT statement. Whereas when I execute a stored function with e.g.: select foo(2) from

Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?

2014-02-21 Thread Thomas Steinmaurer
will there be or is there already support for stored function execution in the Trace API similar to stored procedures? Sure, it is under development. Thanks for the information. Done, happy testing ;) Lovely. ;-) Thanks a lot! Will give it a go in the forthcoming days. As

Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure

2014-02-19 Thread Thomas Steinmaurer
Tried todays snapshot build (Win 32-bit). The output looks like a bit weird regarding package/procedure name: 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) C:\Program Files (x86)\Upscene

Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?

2014-02-19 Thread Thomas Steinmaurer
will there be or is there already support for stored function execution in the Trace API similar to stored procedures? Sure, it is under development. Thanks for the information. Done, happy testing ;) Lovely. ;-) Thanks a lot! Will give it a go in the forthcoming days. As well

Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure

2014-02-18 Thread Thomas Steinmaurer
Hello Vlad, 14.02.2014 22:50, Thomas Steinmaurer wrote: Would like to do so, but the latest snapshot build for Windows available is from 2 days ago. Just letting you know. Windows builds are broken at the moment, please wait a bit. It works now Tried todays snapshot build (Win 32

Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?

2014-02-17 Thread Thomas Steinmaurer
Vlad, will there be or is there already support for stored function execution in the Trace API similar to stored procedures? Sure, it is under development. Thanks for the information. Regards, Thomas --

Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure

2014-02-14 Thread Thomas Steinmaurer
Good point. I think it makes sense. I'll look at it (a bit later). Would you like to see procedure name prefixed with package name (PACKAGE.PROCEDURE) This would be consistent with the rest of the codebase, so IMHO it should be done this way. Sounds good. Check next snapshot build,

[Firebird-devel] Alpha 2 - Trace API - Stored Function support?

2014-02-14 Thread Thomas Steinmaurer
Hello, will there be or is there already support for stored function execution in the Trace API similar to stored procedures? I don't see that anywhere mentioned. At least the fbtrace.conf template file doesn't offer e.g. log_function_start, log_function_finish trace configuration parameters.

Re: [Firebird-devel] Alpha 2 - Trace Output - Execution ofpackage-based stored procedure

2014-02-13 Thread Thomas Steinmaurer
Good point. I think it makes sense. I'll look at it (a bit later). Would you like to see procedure name prefixed with package name (PACKAGE.PROCEDURE) This would be consistent with the rest of the codebase, so IMHO it should be done this way. Sounds good. Thank you, Thomas

[Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure

2014-02-12 Thread Thomas Steinmaurer
Hello, when I execute a stored procedure which is part of a package with e.g.: select * from pkg_schema.s_user_tables; I guess, it would make sense to also have the package name somewhere in the trace output for the EXECUTE_PROCEDURE_* event. Does this make sense? For the above call,

Re: [Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)

2014-02-06 Thread Thomas Steinmaurer
http://permalink.gmane.org/gmane.comp.db.firebird.python/360 At least with the ZIP distribution of Firebird 3 Alpha 2, you need to create a Firebird user via gsec first. Regards, Thomas -- Managing the Performance of

Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available for testing

2014-02-03 Thread Thomas Steinmaurer
sorry seems that was loading the old fbclient from /usr/lib/x86_64-linux-gnu/ ldd /opt/flamerobin/bin/flamerobin | grep libfb libfbclient.so.2 = /usr/lib/x86_64-linux-gnu/libfbclient.so.2 (0x7f1e8dfec000) cat /etc/ld.so.conf.d/x86_64-linux-gnu.conf /lib/x86_64-linux-gnu

Re: [Firebird-devel] Trace API withEmbeddedandUnicodeinitializationproblem

2014-02-02 Thread Thomas Steinmaurer
Hello Vlad, PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be useful? At least, we can try :)

[Firebird-devel] Embedded distribution and trace plugin, fbtracemgr.exe

2014-02-02 Thread Thomas Steinmaurer
Hello, is there any particular reason (except probable ZIP size) why the trace plugin and fbtracemgr.exe is not included in the embedded distribution? Thanks, Thomas -- WatchGuard Dimension instantly turns raw network

[Firebird-devel] Alpha 2 - SuperServer - Can't connect with multiple isql sessions

2014-02-02 Thread Thomas Steinmaurer
Hello, I'm sure I'm doing something wrong here ... Testing Alpha 2 x86 on Windows using the ZIP distribution. From a configuration side, I only changed the port in firebird.conf to 4050, so I'm running SuperServer. A first isql session with: isql 'localhost/4050:tourism.fdb' -user tourism

Re: [Firebird-devel] Trace APIwithEmbeddedandUnicodeinitializationproblem

2014-02-02 Thread Thomas Steinmaurer
Hello Vlad, PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be useful? At least, we can try :)

Re: [Firebird-devel] Alpha 2 - SuperServer - Can't connect with multiple isql sessions

2014-02-02 Thread Thomas Steinmaurer
02.02.2014 11:23, Thomas Steinmaurer wrote: From a configuration side, I only changed the port in firebird.conf to 4050, so I'm running SuperServer. No, to run Super-anything, you must run/install firebird.exe with -m switch. Thanks, that did the trick, although I do not see any

Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem

2014-02-02 Thread Thomas Steinmaurer
You now should see the UNICODE initialization problem in the trace output. No, i see ATTACH_DATABASE event by this application. That's a pity. ;-) Do you have the FIREBIRD environment variable set? No. PS does you tried LoadLibraryEx with LOAD_WITH_ALTERED_SEARCH_PATH ?

Re: [Firebird-devel] Trace API with Embedded andUnicodeinitializationproblem

2014-02-01 Thread Thomas Steinmaurer
It is interesting now, that the trace works for an isql based client session, even when using UTF8 as character set, but fails with e.g. Database Workbench. The only difference is that isql is in the same directory as embedded, but DBW isn't, although pointing to the same embedded library. I

Re: [Firebird-devel] Trace API with EmbeddedandUnicodeinitializationproblem

2014-02-01 Thread Thomas Steinmaurer
Any further ideas? Not at me. Regards, Vlad PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be

[Firebird-devel] Trace API with Embedded and Unicode initialization problem

2014-01-30 Thread Thomas Steinmaurer
Hello, the following is with: Firebird-2.5.2.26540-0_Win32 Embedded What can be the reason for the following error: cannot initialize UNICODE collation to use in trace plugin when a trace session is attempted to be started with Firebird Embedded? As usual, Firebird Embedded is extracted into

Re: [Firebird-devel] Trace API with Embedded and Unicode initializationproblem

2014-01-30 Thread Thomas Steinmaurer
Hello Vlad, the following is with: Firebird-2.5.2.26540-0_Win32 Embedded What can be the reason for the following error: cannot initialize UNICODE collation to use in trace plugin Adriano could know, i hope when a trace session is attempted to be started with Firebird Embedded?

Re: [Firebird-devel] Trace API with Embedded and Unicodeinitializationproblem

2014-01-30 Thread Thomas Steinmaurer
It is interesting now, that the trace works for an isql based client session, even when using UTF8 as character set, but fails with e.g. Database Workbench. The only difference is that isql is in the same directory as embedded, but DBW isn't, although pointing to the same embedded library. I

Re: [Firebird-devel] Trace API with Embedded andUnicodeinitializationproblem

2014-01-30 Thread Thomas Steinmaurer
It is interesting now, that the trace works for an isql based client session, even when using UTF8 as character set, but fails with e.g. Database Workbench. The only difference is that isql is in the same directory as embedded, but DBW isn't, although pointing to the same embedded library. I

Re: [Firebird-devel] RES: Firebird Alpha 1 GBAK bug

2013-09-04 Thread Thomas Steinmaurer
is denied by server administrator gbak:Exiting before completion due to errors Looks a bit like your UDF library isn't accessible for Firebird 3. Or perhaps you did declare your UDF with a full-qualified path (the one above) to the UDF library dll? -- With regards, Thomas Steinmaurer http

Re: [Firebird-devel] FB 3.0 Alpha 1 - Initialize security database - Reference to quick start guide

2013-08-06 Thread Thomas Steinmaurer
On 08/05/13 22:13, Thomas Steinmaurer wrote: Hello, upon first usage/connect, the user is prompted with an -Install incomplete, please read chapter Initializing security database in Quick Start Guide message. Obviously there is no QSG (or I haven't found it), so that's a bit confusing

[Firebird-devel] FB 3.0 Alpha 1 - Initialize security database - Reference to quick start guide

2013-08-05 Thread Thomas Steinmaurer
Hello, upon first usage/connect, the user is prompted with an -Install incomplete, please read chapter Initializing security database in Quick Start Guide message. Obviously there is no QSG (or I haven't found it), so that's a bit confusing for people being new to 3.0 (Alpha1). Regards,

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Thomas Steinmaurer
i wrote this RFC by request of one local company which have (as many others) wrote own replicator and got some issues which could be resolved very easy with a little support from the Firebird engine side. I think we could discuss it and determine if requested feature could add some value to

Re: [Firebird-devel] Covering index?

2013-01-28 Thread Thomas Steinmaurer
On Sun, Jan 27, 2013 at 3:23 PM, Dimitry Sibiryakov s...@ibphoenix.com mailto:s...@ibphoenix.com wrote: 27.01.2013 21:17, Thomas Steinmaurer wrote: Is Firebird able here to serve the result here out of the index or does it need to lookup data by following the index key

Re: [Firebird-devel] Covering index?

2013-01-28 Thread Thomas Steinmaurer
28.01.2013 17:27, Thomas Steinmaurer wrote: How does the engine know when to garbage collect an index entry? When list of record references in it is empty. Thanks. Regards, Thomas -- Master Visual Studio

[Firebird-devel] Covering index?

2013-01-27 Thread Thomas Steinmaurer
Hello, SQL Server supports something called covering index, which basically means, that additional columns can be added to the index definiton, which aren't in the index key then, but at index lead level only. I know Firebird doesn't support something like that, but I wonder if Firebird can

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

2013-01-08 Thread Thomas Steinmaurer
i move info from support list what i provide there 1. I use Super Server 64 bit Certainly super does not write pages to disk as active as classic, but... 2. DB Page Size is 16k and DefaultDBPageCache is 65536 (i disable system cache in fbconfig) that's just 1Gb cache. We GC pages during

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Thomas Steinmaurer
On Wed, 31 Oct 2012 08:41:39 +0100, Paul Beach pbe...@ibphoenix.com wrote: I have no idea what to do (well, actually I have a very easy and good one, you know, it's to wipe dialect 1/2). I'd hate to split a single field in two to support something which should be removed +10 years ago.

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Thomas Steinmaurer
Over all 12 years of FB development it became clear that *remaining* dialect 1 users simply can't switch at all (old legacy app, they certainly switch with new app. versions), so giving them another 2 years inserting deprecation version before removal will not help them in any significant

Re: [Firebird-devel] Database dialect and BIGINT in metadata

2012-10-31 Thread Thomas Steinmaurer
31.10.2012 15:32, Thomas Steinmaurer wrote: Management = Firebird Admin List? Nope, I meant just another part of my responsibilities ;-) Ah, ok. I guess you have a bunch of hats for different roles in your garderobe then. ;-) Regards, Thomas

Re: [Firebird-devel] CORE-3934 (log_sweep configuration) and Firebird 2.5.2

2012-10-17 Thread Thomas Steinmaurer
17.10.2012 9:55, Thomas Steinmaurer wrote: will the fix for CORE-3934 be available in the final 2.5.2 release? Any comments? I has been included there. Great. Thanks. Regards, Thomas -- Everyone hates slow

Re: [Firebird-devel] CORE-3934 (log_sweep configuration) and Firebird 2.5.2

2012-10-16 Thread Thomas Steinmaurer
Hello, will the fix for CORE-3934 be available in the final 2.5.2 release? Any comments? Thanks, Thomas -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Thomas Steinmaurer
I agree that sometime more context from intermediate levels could help to better understand what happens. For example, when transliterate error happens it is good to know assignment destination (field or variable) name. I'm not sure it is easy to implement. But in the case of CreateFile

[Firebird-devel] CORE-3934 (log_sweep configuration) and Firebird 2.5.2

2012-09-29 Thread Thomas Steinmaurer
Hello, will the fix for CORE-3934 be available in the final 2.5.2 release? Regards, Thomas -- How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is

Re: [Firebird-devel] A script to fix/upgrade security2.fdb

2012-09-18 Thread Thomas Steinmaurer
18.09.2012 12:47, Tomasz Tyrakowski wrote: Any chance the script mentioned here http://www.firebirdnews.org/?p=5027 (which was supposed to be shipped with FB 2.5.1) will be available soon? I'm experiencing problems described in this article and the script would be most welcome. IIRC,

[Firebird-devel] Firebird 2.5.2 RC1 - Trace API - Rock solid

2012-09-17 Thread Thomas Steinmaurer
Hello, just letting you know, that the Trace API in 2.5.2 RC1 is rock solid so far. I'm having a test app simulating 150 client connections inserting into a GTT and 7 parallel trace sessions in FB TraceManager with all trace configuration options enabled capturing these events. No single

[Firebird-devel] Firebird 2.5.3?

2012-09-13 Thread Thomas Steinmaurer
Hello, current snapshot builds are prefixed with 2.5.3, and there is no sign regarding 2.5.2. What's the most recent strategy regarding the next stable post 2.5.1 release? Thanks, Thomas -- Live Security Virtual

  1   2   >