Re: [Firebird-devel] IAttachment::execute() returned value

2022-09-19 Thread Alex Peshkoff via Firebird-devel
On 9/17/22 18:54, Dimitry Sibiryakov wrote: Hello All.   What are rules for plugin's returned value of IAttachment::execute() in the case when input transaction is not NULL? That depends upon statement executed. Should it return NULL? In a case of commit/rollback - yes. Should it

[Firebird-devel] test

2022-09-16 Thread Alex Peshkoff via Firebird-devel
TEST Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Sanity checks for methods' parameters in Y-valve

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 18:56, Dimitry Sibiryakov wrote: Hello All.   If someone by mistake calls IStatement::execute() providing metadata but no data buffer, it will pass the values as is to a provider and overall result will be segfault.   Shouldn't some sanity checks to be performed there? Not

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 17:18, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 15.09.2022 16:14: On the other hand tomcrypt is successfully used in our sample plugin - which is problematic with static linking. For me that appears more interesting and useful. Not to say about code

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 17:07, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 15.09.2022 12:04: With tommath there are no such issues...   Why don't force build with static libs? In what way it's better than own dynamic libraries?   Surely no problem with API/ABI. Therefore we

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 16:38, Mark Rotteveel wrote: On 15-09-2022 15:19, Alex Peshkoff via Firebird-devel wrote: On 9/15/22 14:36, Adriano dos Santos Fernandes wrote: On 15/09/2022 08:18, Alex Peshkoff via Firebird-devel wrote: This is solved by install script - it creates symlink to /inst/path/firebird

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 14:36, Adriano dos Santos Fernandes wrote: On 15/09/2022 08:18, Alex Peshkoff via Firebird-devel wrote: On 9/15/22 14:00, Adriano dos Santos Fernandes wrote: Em qui., 15 de set. de 2022 07:06, Alex Peshkoff via Firebird-devel escreveu:     >     >   Why don't force

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 14:00, Adriano dos Santos Fernandes wrote: Em qui., 15 de set. de 2022 07:06, Alex Peshkoff via Firebird-devel escreveu: > >   Why don't force build with static libs? > In what way it's better than own dynamic libraries? Not put files in system li

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 12:30, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 15.09.2022 11:08: Also, it's different in the sense that official package builds and package tomcrypt, but not tommath. We did discuss sometimes ago why for universal binary package we have to use built

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-15 Thread Alex Peshkoff via Firebird-devel
On 9/15/22 04:52, Adriano dos Santos Fernandes wrote: On 05/09/2022 08:13, Mark Rotteveel wrote: On 05-09-2022 13:00, Alex Peshkoff via Firebird-devel wrote: When adding it I cared about an ability to fix secirtiy issues in 3d-party libraries not rebuilding and reinstalling FB packages

Re: [Firebird-devel] getInfo() result format

2022-09-08 Thread Alex Peshkoff via Firebird-devel
On 9/8/22 12:49, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 07.09.2022 18:40: Do not remember - does ClumpletReader already supports getInfo() result format?   Sorry, can't remember. Supports, down to FB3. I.e. looks like we need an src review. Add a ticket please

Re: [Firebird-devel] getInfo() result format

2022-09-07 Thread Alex Peshkoff via Firebird-devel
On 9/7/22 19:33, Dimitry Sibiryakov wrote:   At fourth line you can get read-past-buffer and may be crash. And this code is copy-pasted everywhere in Firebird source. Do not remember - does ClumpletReader already supports getInfo() result format? Firebird-Devel mailing list, web

Re: [Firebird-devel] getInfo() result format

2022-09-07 Thread Alex Peshkoff via Firebird-devel
On 9/7/22 19:18, Dimitry Sibiryakov wrote: Hello All.   isc_info_truncated is a terminal item which is NOT followed by two bytes length, right? Not sure what you mean by 'terminal item', but it may be followed by isc_info_end if that fits into buffer. What about two bytes length - it's

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Alex Peshkoff via Firebird-devel
On 9/5/22 13:20, Mark Rotteveel wrote: On 05-09-2022 12:06, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:59, Mark Rotteveel wrote: On 05-09-2022 11:50, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:31, Mark Rotteveel wrote: That is inconsistent compared to what is done

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Alex Peshkoff via Firebird-devel
On 9/5/22 12:59, Mark Rotteveel wrote: On 05-09-2022 11:50, Alex Peshkoff via Firebird-devel wrote: On 9/5/22 12:31, Mark Rotteveel wrote: On 05-09-2022 11:23, Alex Peshkoff via Firebird-devel wrote: This is solved by install script - it creates symlink to /inst/path/firebird/lib/.tm

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Alex Peshkoff via Firebird-devel
On 9/5/22 12:31, Mark Rotteveel wrote: On 05-09-2022 11:23, Alex Peshkoff via Firebird-devel wrote: This is solved by install script - it creates symlink to /inst/path/firebird/lib/.tm/libtommath.so.0 in system lib directory (provided it's missing). That's done this way in order to make

Re: [Firebird-devel] Building Firebird Linux with --with-builtin-tommath

2022-09-05 Thread Alex Peshkoff via Firebird-devel
On 9/3/22 16:12, Mark Rotteveel wrote: I'm investigating ways of packaging Firebird Embedded for Java, so it can be used as drop-in Java library (which is then unpacked to a temporary directory automatically). Given Firebird complains about missing libtommath when I use the normal build, and

Re: [Firebird-devel] Service errors returned by API

2022-09-01 Thread Alex Peshkoff via Firebird-devel
On 8/25/22 21:52, Dimitry Sibiryakov wrote: Perhaps warnings should be returned both ways: the binary form in status and duplicate text in output. In this case applications will get them as usual and advanced ones may be interested in parsing status. I will look at what can be done here.

Re: [Firebird-devel] Service errors returned by API (was: [FirebirdSQL/firebird] [FR] Database restore must make every effort on activating deferred indexes (Issue #7269))

2022-08-25 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 20:59, Dimitry Sibiryakov wrote: Alexander Peshkov wrote 24.08.2022 19:06: On 8/24/22 14:31, Dimitry Sibiryakov wrote:  > Without it services seem to be pretty useless. I think this to be suggested in devel and if nobody sees problems - feel free to add a ticket, I will implement

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 19:33, Jiří Činčura wrote: How crazy idea it would be to have even Linux builds with binaries? May be I've lost context - but we release linux builds with binaries since the first days of the project. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 17:14, Mark Rotteveel wrote: On 24-08-2022 16:06, Alex Peshkoff via Firebird-devel wrote: On 8/24/22 17:04, Mark Rotteveel wrote: On 24-08-2022 15:36, Dimitry Sibiryakov wrote: Mark Rotteveel wrote 24.08.2022 15:32: If the term is confusing or ambiguous, it already is so in its

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 17:10, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 24.08.2022 16:06: Same for linux - not stripped binaries provided.   Nope. Firebird-debuginfo-4.0.2.2816-0.amd64.tar.gz contains only extracted debug symbols, not binaries. Sorry, but they are created

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 17:04, Mark Rotteveel wrote: On 24-08-2022 15:36, Dimitry Sibiryakov wrote: Mark Rotteveel wrote 24.08.2022 15:32: If the term is confusing or ambiguous, it already is so in its current form.    Yes, it is. That's why I would suggest to change that. The Windows pdb packages are

Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Alex Peshkoff via Firebird-devel
On 8/24/22 15:03, Adriano dos Santos Fernandes wrote: On 24/08/2022 08:59, Mark Rotteveel wrote: On 24-08-2022 13:45, Adriano dos Santos Fernandes wrote: This is our Firebird 4.0.2 released files: [..] It's difficult to understand, they do not mention OS and hardware architectures are

Re: [Firebird-devel] Purpose of op_batch_sync

2022-08-19 Thread Alex Peshkoff via Firebird-devel
On 8/19/22 19:02, Mark Rotteveel wrote: On 19-08-2022 17:30, Alex Peshkoff via Firebird-devel wrote: On 8/19/22 18:24, Mark Rotteveel wrote: It looks like op_batch_sync is just used to force the client to send the deferred messages to the server, and the server to send the deferred responses

Re: [Firebird-devel] Purpose of op_batch_sync

2022-08-19 Thread Alex Peshkoff via Firebird-devel
On 8/19/22 18:24, Mark Rotteveel wrote: It looks like op_batch_sync is just used to force the client to send the deferred messages to the server, and the server to send the deferred responses. Is that correct? exactly Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Do repeated op_batch_create leak the batch?

2022-08-15 Thread Alex Peshkoff via Firebird-devel
On 8/13/22 14:59, Mark Rotteveel wrote: I'm implementing batch execution in Jaybird. Looking at the code of rem_port::batch_create(P_BATCH_CREATE* batch, PACKET* sendL) in server.cpp, it looks like sending multiple op_batch_create requests for the same statement handle could leak a previously

Re: [Firebird-devel] BLOB_APPEND and NULL

2022-08-11 Thread Alex Peshkoff via Firebird-devel
On 8/11/22 19:04, Vlad Khorsun wrote:   So far I don't see it as mistake. +1 Function is anyway damned non-standard. And as soon as we have documented behavior - no problems at all. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-10 Thread Alex Peshkoff via Firebird-devel
On 8/10/22 10:36, Pavel Cisar wrote: Hi, Dne 09. 08. 22 v 17:02 Alex Peshkoff via Firebird-devel napsal(a): *Pavel & Pavel!* I understand you have some problems with testing system due to unablity to create self-security database remotely. But I do not understand how could as solu

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-09 Thread Alex Peshkoff via Firebird-devel
On 8/9/22 17:14, Pavel Cisar wrote: Hi, Dne 09. 08. 22 v 6:33 Alex Peshkoff via Firebird-devel napsal(a): Why this restriction exists ? Because login / password to be validated in the database that does not exist yet. Therefore password check fails and you can't attach to server. Without

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-09 Thread Alex Peshkoff via Firebird-devel
On 8/9/22 12:41, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 09.08.2022 6:33: PPS. If one has access to database.conf to create new alias he definitely has embedded access to server, i.e. problem appears to be rather artificial.   Consider a shared database hosting where

Re: [Firebird-devel] Ability to use non-local protocol to create DB which alias is declared as self-security

2022-08-08 Thread Alex Peshkoff via Firebird-devel
On 8/8/22 15:41, Pavel Zotov wrote: Currently one need to use only local connection in order to create self-security database, i.e.: 1) we create in the databases.conf alias of DB that we want to create, e.g.: tmp_self= $(dir_sampleDb)/tmp_self_example.fdb {     SecurityDatabase = tmp } 2) we

Re: [Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-26 Thread Alex Peshkoff via Firebird-devel
On 7/26/22 18:30, Leyne, Sean wrote: -Original Message- From: Alex Peshkoff via Firebird-devel On 7/26/22 14:39, Mark Rotteveel wrote: On 16-07-2022 10:54, Mark Rotteveel wrote: Is sending op_batch_rls necessary in the wire protocol, or is closing the statement itself sufficient

Re: [Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-26 Thread Alex Peshkoff via Firebird-devel
On 7/26/22 14:39, Mark Rotteveel wrote: On 16-07-2022 10:54, Mark Rotteveel wrote: Is sending op_batch_rls necessary in the wire protocol, or is closing the statement itself sufficient? Similar question, is a batch automatically released when unpreparing the statement, or preparing a new

Re: [Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-18 Thread Alex Peshkoff via Firebird-devel
On 7/16/22 11:54, Mark Rotteveel wrote: Is sending op_batch_rls necessary in the wire protocol, or is closing the statement itself sufficient? Closing the statement should be sufficient Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-06-03 Thread Alex Peshkoff via Firebird-devel
On 6/3/22 14:58, Lucas Schatz wrote: Hello Just do clarify, 600-900 seconds or ms? I think makes sense to be ms, anyway I'll put 30 seconds just to be sure, because almost every second the DB gets attached As soon as I have news I'll post here (hope not), at most probably next month I'll give

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-06-03 Thread Alex Peshkoff via Firebird-devel
On 5/27/22 23:06, Lucas Schatz wrote: Installed, now wait for the error, probably only next week With that dump I've more or less understood where bug happens. But fixing that may be not quick. I'm almost sure that use of big enough linger (600 or 900 or even bigger) should make this bug

Re: [Firebird-devel] Tablespaces proposal

2022-06-02 Thread Alex Peshkoff via Firebird-devel
On 6/2/22 14:45, Adriano dos Santos Fernandes wrote: On 02/06/2022 08:08, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 02.06.2022 13:01:   It is "ALTER TABLE" which must be executed on replica. Otherwise you'll have problem with ALTER TABLE ADD FIELD. Is it

Re: [Firebird-devel] Tablespaces proposal

2022-06-02 Thread Alex Peshkoff via Firebird-devel
On 6/2/22 13:03, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 02.06.2022 9:31: ALTER TABLE SET TABLESPACE is tablespaces-related DDL operator - i.e. it should not be executed on replica. Why conflict?   It is "ALTER TABLE" which must be executed on replica.

Re: [Firebird-devel] Tablespaces proposal

2022-06-02 Thread Alex Peshkoff via Firebird-devel
On 6/2/22 10:14, Ilya Eremin wrote: Hello! The last tablespaces proposal says: > Tablespaces are excluded from replication because it's physical layout > of a database and a replica may have another one. which means that tablespaces-related DDL operators won't be executed on a replica. But

Re: [Firebird-devel] event_t::event_count

2022-05-30 Thread Alex Peshkoff via Firebird-devel
On 5/30/22 14:37, Adriano dos Santos Fernandes wrote: Hi! Isn't this thread unsafe? struct event_t { SLONG event_count; int pid; pthread_mutex_t event_mutex[1]; pthread_cond_t event_cond[1]; }; int SharedMemoryBase::eventPost(event_t* event) { ...

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-05-27 Thread Alex Peshkoff via Firebird-devel
On 5/27/22 04:38, Lucas Schatz wrote: Hello, I moved the database to another server with Fb4.0.0 for some days, and "fortunately" today crashed too So, if you can send me the tar.gz I'll install with no problem http://web.firebirdsql.org/download/rabbits/alex/MutexError22/ Any additional

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-05-26 Thread Alex Peshkoff via Firebird-devel
On 5/25/22 17:43, Lucas Schatz wrote: Sorry, just to clarify: server Fb4.0.1, remote client Fb 3.0+PHP7.3 Anyway I'll send you the links as soon as possible. I've made a close look at that dump. Unfortunately I could not find something very useful in it. I.e. it's more or less clear at what

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-05-25 Thread Alex Peshkoff via Firebird-devel
On 5/25/22 17:35, Lucas Schatz wrote: I got 4 coredumps, can I send PM to you the link? Please do - but compress them separately. Also, I think we spotted the problem's source, looks like it's a PHP related issue Looking at the stack-trace, it looks like something related to a web server

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-05-25 Thread Alex Peshkoff via Firebird-devel
On 5/25/22 17:23, Lucas Schatz wrote: 17gb +- Can you compress it (xz is preferred for obv.reasons) and put to some downloadable place? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7

2022-05-25 Thread Alex Peshkoff via Firebird-devel
On 5/23/22 16:07, Lucas Schatz wrote: The stack-trace is attached, as soon I get more stack-traces I'll send here too How big is core dump? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] gbak output not flushing?

2022-05-18 Thread Alex Peshkoff via Firebird-devel
On 5/17/22 10:41, Fabiano Bonin wrote: Firebird version 3.0.9 64bits on Debian When I use gbak with "nohup" in Debian, it seems gbak's output to nohup.out is written in chunks, nohup gbak -b -v -g database database.fbk & It shows, for instance: gbak:52 records written gbak:53 re

Re: [Firebird-devel] Refresh roles

2022-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/11/22 19:40, Adriano dos Santos Fernandes wrote: On 11/05/2022 11:55, Roman Simakov wrote: Can you make up or describe a potential case of the situation? Undoubtedly the feature would be useful but we've lived without it for all the time. In the profiler, I will create a role, the tables

Re: [Firebird-devel] isc_spb_version Call Without Global User?

2022-05-04 Thread Alex Peshkoff via Firebird-devel
On 5/4/22 10:29, Mark Rotteveel wrote: On 03-05-2022 18:56, Dimitry Sibiryakov wrote: Scott Morgan via Firebird-devel wrote 03.05.2022 18:29: What can you do to get the server's info if you only have per-DB user accounts?    Use isc_dpb_expected_db with your database name to inform Firebird

Re: [Firebird-devel] WITH CALLER PRIVILEGES propagation

2022-04-22 Thread Alex Peshkoff via Firebird-devel
On 22.04.2022 18:07, Jiří Činčura wrote: Yes. Fails. Do you want me to create script for testing? Can you please check your script on some old version? Like 2.5. May be I miss something. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] WITH CALLER PRIVILEGES propagation

2022-04-22 Thread Alex Peshkoff via Firebird-devel
On 22.04.2022 08:20, Jiří Činčura wrote: Without it, it obviously fail. Because the "limited" user does not have permissions. That's what I'm trying go around thru the permissions of calling object. Fails w/o execute statement ? Just using select from procedure instead? Very strange - this

Re: [Firebird-devel] WITH CALLER PRIVILEGES propagation

2022-04-21 Thread Alex Peshkoff via Firebird-devel
On 21.04.2022 13:38, Jiří Činčura wrote: I guess the "caller privileges" is propagated only into `pkg_test_limited.test` when calling, but not further into `t_test`. Can I somewhat make it work/propagate? Or did I misunderstood the feature? "with caller privileges" was designed to make

Re: [Firebird-devel] Fw: [firebird-support] ARM64 Support

2022-04-20 Thread Alex Peshkoff via Firebird-devel
On 19.04.2022 20:06, Hugo Larson via Firebird-devel wrote: Hi, I want to build FB4 for Linux (Ubuntu) arm64 and wonder if there is documentation with instructions? Nothing special. I've tried that build a year or so ago, it builds w/o any special measures. ./configure make Certainly

Re: [Firebird-devel] Status of 3.0.10

2022-04-14 Thread Alex Peshkoff via Firebird-devel
On 4/13/22 21:57, Paul Reeves wrote: For now, all I can suggest is that we remove the option to set legacy auth support in the Fb3 installer. The best solution on my mind! Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Status of 3.0.10

2022-04-13 Thread Alex Peshkoff via Firebird-devel
On 4/13/22 17:11, Pavel Cisar wrote: Hi, because 3.0.9 has significant regression (#7137 - we've got multiple reports from large affected and unhappy users), I'd like ask what are the prospect to release v3.0.10 soon. BTW, it would also address contracted collation performance issues that

Re: [Firebird-devel] Handling exception from external plugins

2022-04-12 Thread Alex Peshkoff via Firebird-devel
function which is needed to 'boot' OO API in plugin, and certainly it should not throw over module boundaries. пн, 11 апр. 2022 г. в 18:45, Alex Peshkoff via Firebird-devel : On 4/11/22 17:56, Dimitry Sibiryakov wrote: Vasiliy Yashkov wrote 11.04.2022 16:52: What is the right way to throw

Re: [Firebird-devel] Handling exception from external plugins

2022-04-11 Thread Alex Peshkoff via Firebird-devel
On 4/11/22 17:56, Dimitry Sibiryakov wrote: Vasiliy Yashkov wrote 11.04.2022 16:52: What is the right way to throw an exception?   Plugins (as any other DLL) is not supposed to throw exceptions ever. Yes, throwing directly (like in your code) is impossible. But there is a way to return an

Re: [Firebird-devel] Security vulnerability in zlib library

2022-04-01 Thread Alex Peshkoff via Firebird-devel
On 4/1/22 01:30, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 31.03.2022 16:08:   The crash happen when a stream of definite data is tried to be compressed. IMHO, it is hard (if possible at all) to purposefully construct such stream *from* server to crash or exploit

Re: [Firebird-devel] Security vulnerability in zlib library

2022-03-31 Thread Alex Peshkoff via Firebird-devel
On 3/31/22 16:39, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 31.03.2022 15:21:   Note that the crash happen on compression so it doesn't affect Firebird security. Did not catch why - we use zlib compression on the wire (since fb3) and in gbak (since fb4). Both cases

Re: [Firebird-devel] Security vulnerability in zlib library

2022-03-31 Thread Alex Peshkoff via Firebird-devel
On 3/31/22 16:13, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 31.03.2022 15:05: On 3/31/22 11:11, Mark Rotteveel wrote: A security vulnerability was found in zlib: https://nakedsecurity.sophos.com/2022/03/29/zlib-data-compressor-fixes-17-year-old-security-bug-patch-errr

Re: [Firebird-devel] Security vulnerability in zlib library

2022-03-31 Thread Alex Peshkoff via Firebird-devel
On 3/31/22 11:11, Mark Rotteveel wrote: A security vulnerability was found in zlib: https://nakedsecurity.sophos.com/2022/03/29/zlib-data-compressor-fixes-17-year-old-security-bug-patch-errr-now/ Will we include an updated version in the next release? On linux that's not our problem - we

Re: [Firebird-devel] IBatch::TAG_BUFFER_BYTES_SIZE and p_batch_data

2022-03-18 Thread Alex Peshkoff via Firebird-devel
On 3/17/22 15:30, Jiří Činčura wrote: Hi *, Is the IBatch::TAG_BUFFER_BYTES_SIZE directly related to how big p_batch_data (in total) can be? Yes. BTW - setting this tag to 0 is treated as use maximum size, currently 256Mb. Or is it something different. Firebird-Devel mailing list,

Re: [Firebird-devel] Local tables

2022-03-16 Thread Alex Peshkoff via Firebird-devel
On 3/15/22 20:41, Dmitry Yemanov wrote: 15.03.2022 20:31, Alex Peshkoff via Firebird-devel wrote: For me, "created" LTT is similar to GTT (i.e. stored in the schema) but with data isolated per request (per PSQL routine). I'd consider about CREATE'd LTT as attachment-private obj

Re: [Firebird-devel] Local tables

2022-03-15 Thread Alex Peshkoff via Firebird-devel
On 3/15/22 20:27, Dmitry Yemanov wrote: 15.03.2022 20:17, Vlad Khorsun wrote: For me, "created" LTT is similar to GTT (i.e. stored in the schema) but with data isolated per request (per PSQL routine). I'd consider about CREATE'd LTT as attachment-private object. I see no need to store its

Re: [Firebird-devel] Local tables

2022-03-15 Thread Alex Peshkoff via Firebird-devel
On 3/15/22 17:14, Adriano dos Santos Fernandes wrote: Hi! As part of "Support multiple rows for DML RETURNING (#6815)" feature, BLR verbs for "local table" were created. Local tables (LT) as defined there works outside transaction control. For #6815 this does not matter, but I want to add LT

Re: [Firebird-devel] Compiled statement cache

2022-03-03 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 20:30, Adriano dos Santos Fernandes wrote: On 28/02/2022 13:18, Alex Peshkoff via Firebird-devel wrote: I suppose it's with mentoned 2Mb cache. Yes. But it's the same even with 100K as the test uses very few and small statements. Taking into an account that bigmost was 21k

Re: [Firebird-devel] Statement::verifyAccess of internal requests

2022-03-02 Thread Alex Peshkoff via Firebird-devel
On 3/1/22 21:33, Adriano dos Santos Fernandes wrote: Hi! Do we have any good reason to make this method do for internal requests everything it does for user's statement? Or could we start it with this? void Statement::verifyAccess(thread_db* tdbb) { if (flags & FLAG_INTERNAL)

Re: [Firebird-devel] Snapshot buuilds

2022-03-01 Thread Alex Peshkoff via Firebird-devel
On 3/1/22 19:19, Karol Bieniaszewski wrote: Hi Snapshots are not avilable http://web.firebirdsql.org/download/snapshot_builds/win/3.0 and whole page http://web.firebirdsql.org/ I've notified Sean privately about it. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename

2022-03-01 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 21:39, Jiří Činčura wrote: Thanks. I suppose not only TPB, but also buffers for batch, events, etc., right? Yes. Basically only DPB and SPB are "UTF8-ready". If one wants everyting to be utf8 why not have appropriate attachment? Firebird-Devel mailing list, web interface

Re: [Firebird-devel] Knowing whether fbclient supports isc_dpb_utf8_filename

2022-03-01 Thread Alex Peshkoff via Firebird-devel
On 3/1/22 13:45, Jiří Činčura wrote: Hi *, Can somebody think of a way to detect whether fbclient supports isc_dpb_utf8_filename? For example when calling isc_create_database in .NET provider with "Embedded" I need to know whether I can use UTF8 in database path. On Windows I can check

Re: [Firebird-devel] Compiled statement cache

2022-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 16:54, Adriano dos Santos Fernandes wrote: On 26/02/2022 22:05, Adriano dos Santos Fernandes wrote: I will report back some numbers (memory, prepare times). Here is a performance test I did: https://pastebin.com/3UnB5BNU It's relative simple (not much indices) and common metadata.

Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename

2022-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 13:38, Jiří Činčura wrote: Does the isc_dpb_utf8_filename imply also UTF8 strings in TPB (i.e. for table names used with isc_tpb_lock_write, etc.)? They are expected in attachment charset. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename

2022-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 13:40, Jiří Činčura wrote: Also, does the isc_dpb_utf8_filename imply UTF8 for database name in i.e. op_attach (not DPB, the name that's before DPB)? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_arg_string in status vector

2022-02-28 Thread Alex Peshkoff via Firebird-devel
On 2/28/22 13:10, Jiří Činčura wrote: Hi *, If I get pointer to a string in isc_arg_string in status vector the encoding is UTF8 if isc_dpb_utf8_filename was specified and ANSI/system charset when isc_dpb_utf8_filename was not specified? Data in status vector should be according to

Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Alex Peshkoff via Firebird-devel
On 2/26/22 17:14, Adriano dos Santos Fernandes wrote: Hi! I do want to define default cache size. I'm thinking in 2M. Comments? As long as it's one_place_change constant - any value is OK for begining. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Build for WASM

2022-02-24 Thread Alex Peshkoff via Firebird-devel
On 2/24/22 03:45, Adriano dos Santos Fernandes wrote: On 23/02/2022 06:40, Jiří Činčura wrote: You mean, running in the browser? Yes. Or any other place where WASM is/will be supported. I had a (very) brief look at it once. Main difficulties should be: - Memory manager - no mmap - Shared

Re: [Firebird-devel] INT64 and index keys

2022-02-24 Thread Alex Peshkoff via Firebird-devel
On 2/15/22 18:20, Vlad Khorsun wrote: I'd vote to remove idx_numeric2 in favour of idx_decimal and look how to improve Decimal128::makeIndexKey() performance. For example, it stores every 3 decimal digits into 10 bits using relatively complex (computationally) algorithm with shifts and

Re: [Firebird-devel] INT64 and index keys

2022-02-21 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 13:49, Alex Peshkoff via Firebird-devel wrote: On 2/16/22 12:54, Dmitry Yemanov wrote: 16.02.2022 12:19, Mark Rotteveel wrote: However, that was not my main point. My main point was that it sounds like an index format that was created for supporting DECFLOAT(34

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 12:54, Dmitry Yemanov wrote: 16.02.2022 12:19, Mark Rotteveel wrote: However, that was not my main point. My main point was that it sounds like an index format that was created for supporting DECFLOAT(34), and that it is not suitable for the full range of INT128 and

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 13:34, Dmitry Yemanov wrote: 16.02.2022 13:28, Dmitry Yemanov wrote: It looks so. Unless we miss something (Alex?), perhaps we need to add a runtime check that rejects key creation for INT128 values longer than 34 decimal digits. Thinking twice, an overflow error should already

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 13:28, Dmitry Yemanov wrote: 16.02.2022 13:24, Alex Peshkoff via Firebird-devel wrote: It looks so. Unless we miss something (Alex?), perhaps we need to add a runtime check that rejects key creation for INT128 values longer than 34 decimal digits. Thinking twice, an overflow

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 12:59, Dmitry Yemanov wrote: 16.02.2022 12:54, Dmitry Yemanov wrote: It looks so. Unless we miss something (Alex?), perhaps we need to add a runtime check that rejects key creation for INT128 values longer than 34 decimal digits. Thinking twice, an overflow error should already

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/16/22 12:45, Alex Peshkoff via Firebird-devel wrote: To be precise - 9 digits into ULONG. No shifts (BTW what a problem with them, CPUs have appropriate fast support since first pentium or even more). There is one division of small integer (range from 0 to 33). It can be easily replaced

Re: [Firebird-devel] INT64 and index keys

2022-02-16 Thread Alex Peshkoff via Firebird-devel
On 2/15/22 18:20, Vlad Khorsun wrote: I'd vote to remove idx_numeric2 in favour of idx_decimal Appears to be good idea. and look how to improve Decimal128::makeIndexKey() performance. For example, it stores every 3 decimal digits into 10 bits using relatively complex (computationally)

Re: [Firebird-devel] JRD_reschedule

2022-02-14 Thread Alex Peshkoff via Firebird-devel
On 2/14/22 15:33, Adriano dos Santos Fernandes wrote: Hi! What is the importance of JRD_reschedule today? More specifically speaking, verifying contention and "checking out"? - AST (yes, 'A'-async is wrong tday, but I use traditional term) processing - cancel, shutdown, etc. processing

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Alex Peshkoff via Firebird-devel
On 2/10/22 19:21, Dimitry Sibiryakov wrote: Dmitry Yemanov wrote 10.02.2022 17:13: Cannot the UTF8-translated SQL text (which is currently inside Statement::sqlText) be the key, to avoid dependency on the charset? I don't think that semantically different statements may have the same UTF8

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Alex Peshkoff via Firebird-devel
On 2/10/22 15:57, Adriano dos Santos Fernandes wrote: On 10/02/2022 06:59, Alex Peshkoff via Firebird-devel wrote: If we need to take roles into an account - only for attachment with same USER. Even without shared cache, user can change its roles with SET ROLES and new prepared statements

Re: [Firebird-devel] Compiled statement cache

2022-02-10 Thread Alex Peshkoff via Firebird-devel
On 2/10/22 12:44, Vlad Khorsun wrote: I've peek these: - statement text - clientDialect - isInternalRequest   Why it is important ? Do we have internal DSQL requests now ? Yes we have - but not too much. Is it makes sense to have two caches - for internal and for user statements ? -

Re: [Firebird-devel] Compiled statement cache

2022-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/22 16:36, Adriano dos Santos Fernandes wrote: Hi! I have refactored DSQL statements/requests (continued worked of many time ago) to separate shared (statement) and specific (request) parts. It seems this ground work for compiled statement cache is complete and I have even did a (very

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/22 12:23, Jiří Činčura wrote: First of all DPB, but conf files are also interesting. DPB: isc_dpb_dummy_packet_interval => 120 dummy packet interval makes no sense for embedded do not think that affects result - just strange isc_dpb_sql_dialect => 3 isc_dpb_user_name

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/22 11:27, Jiří Činčura wrote: Are you using default DB options? You mean DPB or settings in firebird.conf? First of all DPB, but conf files are also interesting. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/7/22 13:52, Jiří Činčura wrote: Hi *, For some tests I'm creating and dropping a database for each test. Doing just that, it takes around 0.042s (on average on my machine) on FB 2.5, but 0.162s on FB4. Is this expected? Are you using default DB options? Firebird-Devel mailing

Re: [Firebird-devel] Parameter block and database/service name encoding

2022-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/22 16:44, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 04.02.2022 14:37: What to do with values of tags that are unknown (other version or provider-specific)? I see no way to tell on destination side if they arrived as is or were transliterated. Take a look

Re: [Firebird-devel] Parameter block and database/service name encoding

2022-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/22 15:17, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 04.02.2022 12:59: I suppose you suggest to fallback to existing way when there is no isc_dpb_lc_ctype in DPB?   I suggest nothing but wonder what to do if there is no isc_dpb_utf8 tag in DPB

Re: [Firebird-devel] Parameter block and database/service name encoding

2022-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/22 13:41, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 04.02.2022 9:53:   Remember me please why isc_lc_ctype isn't used to determine encoding of database name and DPB values? Due to limitations of WideCharToMultiByte API. (with posix iconv this cabe easily done

Re: [Firebird-devel] Parameter block and database/service name encoding

2022-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/3/22 18:39, Dimitry Sibiryakov wrote: Hello All.   Remember me please why isc_lc_ctype isn't used to determine encoding of database name and DPB values? Due to limitations of WideCharToMultiByte API. (with posix iconv this cabe easily done) BTW, service name during service attach

Re: [Firebird-devel] Packaging FirebirdSQL for Conan

2022-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/22 17:04, Horváth V. wrote: Okay, so from this it appears that fbclient 3.x has basically no required external dependencies? I'm not sure how tommath relates to threading and atomics, it appears to be a MPI library. Yes. tommath is the only requirement not in std libraries list.

Re: [Firebird-devel] Packaging FirebirdSQL for Conan

2022-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/22 15:46, Adriano dos Santos Fernandes wrote: On 02/02/2022 09:21, Horváth V. wrote: Hello list! I have the intention of packaging FirebirdSQL 3.x for the Conan cross-platform package manager, so that I can start working on migrating PHP to being a CMake and Conan managed project.

Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Alex Peshkoff via Firebird-devel
On 1/26/22 17:48, Roman Simakov wrote: I hope it can be handled while restoring. I have no good idea how to deal with differences between 3 and 4. It's possible to make a gap in 5 and handle it while restoring as well. Let's make a gap only when have real need to change it. Firebird-Devel

Re: [Firebird-devel] MacOS problem with dlclose

2022-01-25 Thread Alex Peshkoff via Firebird-devel
On 1/25/22 11:11, Paul Beach wrote: Should this be maintained in FB 3? No, Min version now for 3.0.8 is 10.15 Ahh - OK, have not known when suggested a fix a few minutes ago. This makes things just simpler. Firebird-Devel mailing list, web interface at

  1   2   3   4   5   6   7   8   9   10   >