Re: [Firebird-devel] MacOS problem with dlclose

2022-01-25 Thread Alex Peshkoff via Firebird-devel
On 1/24/22 21:21, Adriano dos Santos Fernandes wrote: As I talked earlier, FB 3 apparently was not affected. Now looking for details I see that configure.ac has: case $host in *-darwin*) ac_cv_func_clock_gettime=no ;; *)

Re: [Firebird-devel] MacOS problem with dlclose

2022-01-24 Thread Alex Peshkoff via Firebird-devel
On 1/24/22 12:28, Alex Peshkoff via Firebird-devel wrote: for FB3 and may be fb4 option 1 is a way to go. BTW, looks like we have 3.0.9 release soon. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MacOS problem with dlclose

2022-01-24 Thread Alex Peshkoff via Firebird-devel
On 1/21/22 23:19, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 21.01.2022 20:08: 1) Disable unload timer in PluginManager in MacOS. Fastest and simplest (or any other way to disable plugins unload). 2) Makes it possible for engine plugin to relive when it was shut down and

Re: [Firebird-devel] User name case

2022-01-20 Thread Alex Peshkoff via Firebird-devel
On 1/20/22 12:49, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 20.01.2022 10:43: Are you sure? fbs3 /usr/home/firebird/HEAD/gen/Debug/firebird/bin # ./isql -user РусLat -password abc localhost:employee Database: localhost:employee, User: РусLat   Try, for example, "

Re: [Firebird-devel] User name case

2022-01-20 Thread Alex Peshkoff via Firebird-devel
On 1/19/22 18:46, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 18.01.2022 18:03: fb_utils::dpbItemUpper(userName);   That's quite strange routine. It will uppercase the string even if it contains ASCII letters disallowed for not-delimited SQL identifier (which user

Re: [Firebird-devel] User name case

2022-01-18 Thread Alex Peshkoff via Firebird-devel
On 1/18/22 19:23, Dimitry Sibiryakov wrote: Hello All.   At which point user name is uppercased during attachDatabase() call? In ServerAuth::ServerAuth(). It calls     fb_utils::dpbItemUpper(userName); Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Pure C methods for IBatch

2022-01-17 Thread Alex Peshkoff via Firebird-devel
On 1/17/22 15:02, Jiří Činčura wrote: Hi *, I'm looking at 12.batch_isc.cpp and wondering whether there's a way to do batching using pure C methods [1]. Something like simply calling isc_dsql_prepare instead of IAttachment::prepare. I know I can handle the "this" manually, but that's PIA. :)

Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Alex Peshkoff via Firebird-devel
On 1/17/22 13:17, Tony Whyman wrote: Aren't you confusing isc_interprete with isc_sql_interprete? definitely yes sorry isc_sql_interprete interpets the SQLCode, so it does make sense to drop it if you are getting rid of  SQLCode. absolutely right to be precise - after code review I do not

Re: [Firebird-devel] Are isc_sql_interprete and isc_sqlcode deprecated calls?

2022-01-17 Thread Alex Peshkoff via Firebird-devel
On 1/17/22 12:24, Tony Whyman wrote: In the legacy Firebird API, there are three functions that support error message formatting: isc_sqlcode, isc_sql_interprete, and fb_interpret. In the OO API, fb_interpret becomes IUtil->formatStatus*. *However, I can find no OO API equivalent for the

Re: [Firebird-devel] isc_usrname_too_long

2022-01-16 Thread Alex Peshkoff via Firebird-devel
On 1/14/22 20:30, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 14.01.2022 18:08: Better mark set of isc_add/modify/delete_user() functions deprecated. That's the only place where subj is used.   Taking into account that proper SRP routines for adding a new user requires

Re: [Firebird-devel] isc_usrname_too_long

2022-01-14 Thread Alex Peshkoff via Firebird-devel
On 1/14/22 18:41, Dimitry Sibiryakov wrote: Hello All.   Shouldn't subj text to be corrected?   Also shouldn't it to be returned if user name received in DPB (after conversion into UTF-8) doesn't fit as well? Better mark set of isc_add/modify/delete_user() functions deprecated. That's the

Re: [Firebird-devel] Timeout on batch

2022-01-13 Thread Alex Peshkoff via Firebird-devel
On 1/13/22 16:52, Jiří Činčura wrote: It's this (on a protocol level) https://github.com/FirebirdSQL/firebird/blob/master/src/remote/protocol.cpp#L665 for a single statement. If that field is not supported - and it looks to me it isn't - it's fine for me, I'm just checking some options

Re: [Firebird-devel] Timeout on batch

2022-01-13 Thread Alex Peshkoff via Firebird-devel
On 1/13/22 16:45, Jiří Činčura wrote: Is there a way to send timeout value for batch, same way it's now possible for single statements (op_execute/op_execute2)? Nobody? Sooner of all not but not 100% sure how it's done for single statements... Firebird-Devel mailing list, web interface

Re: [Firebird-devel] TAG_MULTIERROR

2022-01-13 Thread Alex Peshkoff via Firebird-devel
On 1/13/22 16:27, Jiří Činčura wrote: Hi *, What does TAG_MULTIERROR exactly mean? The comment says "Can have >1 buffers with errors", but what is the "buffer" referring to? Incoming message. I.e. by default batch stops processing on first error and returns that error to the user (in

Re: [Firebird-devel] Sub routines accessing outer variables, parameters and cursors

2022-01-12 Thread Alex Peshkoff via Firebird-devel
On 1/11/22 22:15, Adriano dos Santos Fernandes wrote: Hi! Currently sub routines cannot access the outer (main routine/block) variables, parameters and cursors - #4769. There is some details to make that happen safely. Currently a variable cannot have its value changed while its being used.

Re: [Firebird-devel] Reading from batch

2022-01-03 Thread Alex Peshkoff via Firebird-devel
On 1/3/22 16:29, Jiří Činčura wrote: Hi *, Is there a way to read from a batch? I.e. executing `insert into foo (x) values (?) returning x` with bunch of parameters in a batch a then getting the values of `x`. Planned for next version, that will be another interface. Firebird-Devel

Re: [Firebird-devel] Different commands in a batch

2022-01-03 Thread Alex Peshkoff via Firebird-devel
On 1/3/22 16:23, Jiří Činčura wrote: Hi *, Executing different commands in a batch is not supported, right? Aka, it's only single command with multiple sets of parameters. Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] p_batch_cs on the wire

2022-01-03 Thread Alex Peshkoff via Firebird-devel
On 1/3/22 12:07, Jiří Činčura wrote: ULONG p_batch_errors; // error's recnums Numbers of records with error. Used when too many errors took place. For each error server sends number of message for which execution of SQL statement failed. And yes - such number is 4-byte

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-26 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 11:51, Jiří Činčura wrote: Or maybe more broadly, is there some high level description of the batching? I'm failing to find something, except batch interface description in Using_OO_API.html, but that's about API, not about the "protocol". Added chapter to

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-22 Thread Alex Peshkoff via Firebird-devel
On 12/20/21 14:08, Jiří Činčura wrote: I have this piece of code (based on structure from 11.batch.cpp) and doing `batch->execute` crashes the remote server, version 4.0.0.2496. I know it will end up in error, because I didn't fix the `project1` for my structure, but client should not crash

Re: [Firebird-devel] p_batch_cs on the wire

2021-12-21 Thread Alex Peshkoff via Firebird-devel
On 12/21/21 18:12, Jiří Činčura wrote: Are you sure you've shown me dump correctly? Here must be one more That's what I see in WireShark. Could you maybe describe in one or two sentences what the fields in p_batch_cs mean logically? typedef struct p_batch_cs   // completion

Re: [Firebird-devel] p_batch_cs on the wire

2021-12-21 Thread Alex Peshkoff via Firebird-devel
On 12/21/21 18:48, Jiří Činčura wrote: Now I realized what's going on. I started with `67 00 00 00 ...`, yet I forgot about the leading zeros, it should be `00 00 00 67 00 00 00 ...`. Now it makes bit more sense. But still a simple description of fields in p_batch_cs would speed things up

Re: [Firebird-devel] p_batch_cs on the wire

2021-12-21 Thread Alex Peshkoff via Firebird-devel
On 12/21/21 15:46, Jiří Činčura wrote: When sending 2 msgs (again, using fbclient.dll), the response is as follows. I don't understand that either. 67 00 00 00 (obviously operation ) 02 00 00 00 p_batch_statement 02 00 00 00 p_batch_reccount 02 00 00 00 p_batch_updates 00 00 00 00

Re: [Firebird-devel] p_batch_cs on the wire

2021-12-21 Thread Alex Peshkoff via Firebird-devel
On 12/21/21 14:20, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 21.12.2021 12:06: this I can't explain right now, looks like 3 last 00 got lost somehow   Perhaps you mistakenly used routine for storing INF values which throw away leading zeros reducing value to minimal

Re: [Firebird-devel] p_batch_cs on the wire

2021-12-21 Thread Alex Peshkoff via Firebird-devel
On 12/21/21 12:04, Jiří Činčura wrote: Hi *, I'm trying to read the response for op_batch_exec (op_batch_cs), the p_batch_cs. But what I'm getting over the wire (using fbclient library) is this `67 00 00 00 02 00 00 00 01 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 01` and I'm confused.

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Alex Peshkoff via Firebird-devel
On 12/20/21 20:01, Jiří Činčura wrote: Do you want me to create GH issue? Please do. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Alex Peshkoff via Firebird-devel
On 12/20/21 14:27, Jiří Činčura wrote: 4.0.1.2692 crashes too. Thank you, reproduced. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-17 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 21:47, Jiří Činčura wrote: Sending binary to devel failed - Jiri if you still need it send me your private email. A. Is that the msgLen in BlrFromMessage::buildBlr? Looking at the code then the length for SQL_LONG should be 6 (4 + 2), isn't it? Yes. When you will send >1

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-17 Thread Alex Peshkoff via Firebird-devel
On 12/17/21 12:06, Jiří Činčura wrote: Should be 0, NULL. And with (TAG_RECORD_COUNTS, 1)? 10 {1, 2, 4, 0, 0, 0, 1, 0, 0, 0} But please don't use me as XpbBuilder more ;-) Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-17 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 22:27, Jiří Činčura wrote: BTW just to make sure, what is the 2nd and 3rd line going to return? IXpbBuilder* pb = utl->getXpbBuilder(, IXpbBuilder::BATCH, NULL, 0); pb->getBufferLength(); pb->getBuffer(); Should be 0, NULL. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 17:11, Jiří Činčura wrote: I'm bit confused here. I thought it's the size of the p_batch_blr (which looked weird). But you're saying it's "message size". What's that exactly? Is that the msgLen in BlrFromMessage::buildBlr? Looking at the code then the length for SQL_LONG should be

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 16:49, Jiří Činčura wrote: p_batch_msglen is needed for server to check that in matches message size, calculated based on BLR. And it seems that in your case it does not match - may be because you want bigint parameter but use blr_long. I'm bit confused here. I thought it's the size

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 15:12, Mark Rotteveel wrote: On 2021-12-16 10:28, Alex Peshkoff via Firebird-devel wrote: be segmented and swap bytes in segment length when needed. Afraid there is - as always :( - no protocol description except source code. Key ops are op_batch_msg, op_batch_blob_stream &

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 13:48, Jiří Činčura wrote: Afraid there is - as always :( - no protocol description except source code. Key ops are op_batch_msg, op_batch_blob_stream & also op_batch_cs (retuning batch execution state to client). Can you create some simple paragraph with the description? Because

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-16 Thread Alex Peshkoff via Firebird-devel
On 12/16/21 11:51, Jiří Činčura wrote: What should be in p_batch_create.p_batch_pb? Is this some new format or something like DPB? Exactly like DPB v.2 (i.e. 32-bit clumplet lengths). And what should - logically - be inside? Or maybe more broadly, is there some high level description of the

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-13 Thread Alex Peshkoff via Firebird-devel
Gabor, please check FB5 installer on aarch64. A. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Alex Peshkoff via Firebird-devel
On 12/13/21 14:00, Dimitry Sibiryakov wrote: Vlad Khorsun wrote 13.12.2021 11:53: 13.12.2021 12:45, Dimitry Sibiryakov пишет: Vlad Khorsun wrote 13.12.2021 10:32: Our IFirebirdConf implementation is not generic enough to provide way to get value of any known setting as string.    IMHO it

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-13 Thread Alex Peshkoff via Firebird-devel
On 12/13/21 12:56, Adriano dos Santos Fernandes wrote: On 12/12/2021 14:55, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 12.12.2021 18:52: If it does not return sensitive information, I see no problem in add it to examples UDR project. With a check for SYSDBA I see

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-12 Thread Alex Peshkoff via Firebird-devel
On 12/12/21 01:21, Adriano dos Santos Fernandes wrote: Em sáb., 11 de dez. de 2021 18:03, Alex Peshkoff via Firebird-devel escreveu: I see no big use in full support of v.3. Requested UDR is trivial but I highly displike requirement of keeping it in std distro of firebird

Re: [Firebird-devel] UDR for reading server configuration for Firebird QA

2021-12-11 Thread Alex Peshkoff via Firebird-devel
On 12/10/21 14:41, Pavel Cisar wrote: Hi all, our test suite contains many tests that depend on specific server configuration settings (mostly related to security, encryption, pools, timeouts, transactions etc.). As these configuration requirements may contradict each other, it's not

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-11 Thread Alex Peshkoff via Firebird-devel
On 12/10/21 18:52, Gabor Boros wrote: 2021.12.10. 12:43 keltezéssel, Alex Peshkoff via Firebird-devel írta: Try such function please: Results of the below script Pi OS 64bit: /lib/aarch64-linux-gnu /lib Debian 11 32bit: /lib/i386-linux-gnu /lib Debian 11 64bit: /lib/x86_64-linux-gnu

Re: [Firebird-devel] Content for p_batch_create.p_batch_pb

2021-12-10 Thread Alex Peshkoff via Firebird-devel
On 12/10/21 15:30, Jiří Činčura wrote: Hello, What should be in p_batch_create.p_batch_pb? Is this some new format or something like DPB? Exactly like DPB v.2 (i.e. 32-bit clumplet lengths). Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-10 Thread Alex Peshkoff via Firebird-devel
On 12/9/21 11:31, Gabor Boros wrote: 2021.12.08. 18:25 keltezéssel, Gabor Boros írta: 2021.12.08. 17:55 keltezéssel, Alex Peshkoff via Firebird-devel írta: No, sorry. I don't know how, but the bigger problem is I don't know the good solution. Gabor The below script works with aarch64

Re: [Firebird-devel] Build and install with a Raspberry Pi 4B

2021-12-08 Thread Alex Peshkoff via Firebird-devel
On 12/8/21 18:06, Gabor Boros wrote: 2021.12.08. 14:23 keltezéssel, Gabor Boros írta: dirname: hiányzó operandus További információkért adja ki a(z) „dirname --help” parancsot. One problem what I found, the below commit not care about aarch64. Alex? :-) Yep, we need something more generic

Re: [Firebird-devel] op_crypt_key_callback during op_connect

2021-12-08 Thread Alex Peshkoff via Firebird-devel
On 12/7/21 17:52, Jiří Činčura wrote: Hi, How can I get op_crypt_key_callback during op_connect to test P15 (as I see in protocol.h (https://github.com/FirebirdSQL/firebird/blob/master/src/remote/protocol.h#L86))? My hope was that encrypting security database would do the trick, but even in

Re: [Firebird-devel] Maximum number of HashSlots

2021-12-06 Thread Alex Peshkoff via Firebird-devel
On 12/6/21 12:24, Roman Simakov wrote: Hello! Isn't it time to increase the maximum number of HashSlots and make it ULONG instead of USHORT? We can see: Hash slots: 65521, Hash lengths (min/avg/max):0/ 13/ 30 Under heavy load. In FB5? Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] WNET future

2021-11-30 Thread Alex Peshkoff via Firebird-devel
On 11/30/21 19:54, Dimitry Sibiryakov wrote: Leyne, Sean wrote 30.11.2021 17:15: (We have 200+ servers deployed and none of them use (have never) WNET   With dropping this option ability to open database file from mounted network drive also will be dropped (or at least must be heavily

Re: [Firebird-devel] Firebird 5 and Update...Returning

2021-11-26 Thread Alex Peshkoff via Firebird-devel
On 11/26/21 5:47 PM, Tony Whyman wrote: On 26/11/2021 14:32, Dmitry Yemanov wrote: 26.11.2021 17:28, Tony Whyman wrote: 1. IAttachment.prepare is used to parse 'Update Employee Set Hire_Date = ? Where EMP_NO = ? Returning LAST_NAME' 2. IStatement.getType is then used to determine the

Re: [Firebird-devel] Square brackets in plugin config

2021-11-23 Thread Alex Peshkoff via Firebird-devel
On 11/23/21 7:52 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 23.11.2021 17:45: square brackets? This one: [ ] ? I do not remember and do not see in a code any special processing for them.   Yes, there is no special processing of them (so I can use them freely

Re: [Firebird-devel] Square brackets in plugin config

2021-11-23 Thread Alex Peshkoff via Firebird-devel
On 11/23/21 7:26 PM, Dimitry Sibiryakov wrote: Hello All.   Currently Firebird config file parser accept a string in square brackets and consider it to be a parameter without value.   May I rely on this behavior? square brackets? This one: [ ] ? I do not remember and do not see in a code

Re: [Firebird-devel] Is it necessary that gbak uses read-write transaction?

2021-11-22 Thread Alex Peshkoff via Firebird-devel
On 11/22/21 2:30 PM, Dimitry Sibiryakov wrote: Ivan Přenosil wrote 22.11.2021 12:21: Thanks for you answers, but you are answering question I did not ask :)   In this case you should ask questions with a little more details. The answer "everything is possible in soft world, it is just a

Re: [Firebird-devel] Is it necessary that gbak uses read-write transaction?

2021-11-21 Thread Alex Peshkoff via Firebird-devel
On 11/21/21 4:26 PM, Dimitry Sibiryakov wrote: Ivan Přenosil wrote 21.11.2021 14:22: or could it be changed to read-only in FB4?   It is meaningless. Read-write transaction has no differences from read-only until it perform an actual write.   And no, it cannot be "read-only read committed"

Re: [Firebird-devel] ON DISCONNECT triggers and MON$ATTACHMENTS

2021-11-09 Thread Alex Peshkoff via Firebird-devel
On 11/9/21 11:25 AM, Ilya Eremin wrote: Hello! Currently ON DISCONNECT triggers are not called when an attachment is deleted from MON$ATTACHMENTS by another attachment. Is it the correct behavior? On my mind - not. The only case when ON DISCONNECT triggers not to be called is server

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/21 2:36 PM, Pavel Cisar wrote: For example: The key "HROCH" (Czech word for hippopotamus) could have sortkey: 13+27+23+14 (each letter replaced with byte representing it's order place in alphabet, which is simplification for this showcase, i.e. 13=H 27=R 23=O 14=CH) If you would

Re: [Firebird-devel] ODP: RFC: Fix for issue 6915

2021-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/4/21 6:56 PM, Karol Bieniaszewski wrote: „The main reason why this "removal of trailing partial contraction" was done is to achieve behavior "consistent" with search/evaluation in other software (like text editors etc.), so (for example) STARTING WITH "C" or LIKE "C%" will return rows

Re: [Firebird-devel] Tablespaces proposal

2021-10-12 Thread Alex Peshkoff via Firebird-devel
On 10/11/21 10:07 PM, Dimitry Sibiryakov wrote: Roman Simakov wrote 11.10.2021 20:23: > Note: *MAIN* - is a name of the basic database file.    Please, use *DEFAULT* for default (main) tablespace at "main" database file.     It is much more consistent with SQL and allows to avoid

Re: [Firebird-devel] Plugins and symlinks

2021-10-08 Thread Alex Peshkoff via Firebird-devel
On 10/8/21 4:57 PM, Dimitry Sibiryakov wrote: Hello All.   Currently Firebird is unable to load plugins via symlinks. Is it intentional? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Tablespaces proposal

2021-10-06 Thread Alex Peshkoff via Firebird-devel
On 10/6/21 6:32 PM, Roman Simakov wrote: 4. CREATE TABLE … TABLESPACE Given syntax does not let specify tablespace for constraints-related indexes and separate fields. That's serious limitation. At least for blobs that's IMHO needed. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Pros/cons of stream blobs, and should I use them?

2021-10-05 Thread Alex Peshkoff via Firebird-devel
On 10/5/21 5:49 PM, Mark Rotteveel wrote: No, I was referring to the fact the OO API in Firebird 3 - according to the discussion I referenced - does not provide a way to build BPBs. Exactly. BTW, if needed it's very simple to backport additional Xpb types to FB3. I'm just not sure is it

Re: [Firebird-devel] Pros/cons of stream blobs, and should I use them?

2021-10-04 Thread Alex Peshkoff via Firebird-devel
On 10/3/21 2:25 PM, Mark Rotteveel wrote: - New OO API (at least in Firebird 3), not providing an explicit way to create stream blobs (see "[Firebird-devel] IBlob::putSegment" from 27 May 2021) I suppose you mean this phraze: "Last two parameters are required only if you want to use blob

Re: [Firebird-devel] Unhandled exception in Why

2021-10-01 Thread Alex Peshkoff via Firebird-devel
On 9/30/21 9:04 PM, Jiří Činčura wrote: Can you share metadata backup? I can, but the build from Vlad works fine, so I think we know what the problem is and what the fix looks like. So probably not needed anymore. Certainly :) Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Unhandled exception in Why

2021-09-27 Thread Alex Peshkoff via Firebird-devel
On 9/27/21 12:20 PM, Jiří Činčura wrote: I'm almost sure it is it. Could you confirm database have expression index which depends on PSQL function that uses UDR ? As far as I can tell there isn't any such index. Can you share metadata backup? Firebird-Devel mailing list, web interface

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-21 Thread Alex Peshkoff via Firebird-devel
On 9/21/21 4:13 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 21.09.2021 15:06: Valgring makes execution many times slower (that's from my own experience).   Does it really matter if test suite isn't run in production anyway?.. Memory leaks detector does run

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-21 Thread Alex Peshkoff via Firebird-devel
On 9/21/21 2:50 PM, Adriano dos Santos Fernandes wrote: I think we can improve things here. We have our GlobalPtr, InitInstance and we may continue using them. And we have FB_NEW which allocates memory from the global default pool. We may split that global default pool in two, so we'll have

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-21 Thread Alex Peshkoff via Firebird-devel
On 9/21/21 4:02 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 21.09.2021 14:51: That's why this solution is usable only if we can't do something else.   https://github.com/google/sanitizers can detect much wider set of problems that our pools. Its support is built

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-21 Thread Alex Peshkoff via Firebird-devel
On 9/21/21 3:31 PM, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 21.09.2021 14:24: Though we will lose way to monitor leaks.   Valgrind, drMemory and sanitizers will work in this case. Valgring makes execution many times slower (that's from my own experience). I've never

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-21 Thread Alex Peshkoff via Firebird-devel
On 9/21/21 3:24 PM, Adriano dos Santos Fernandes wrote: On 21/09/2021 09:11, Dimitry Sibiryakov wrote: Adriano dos Santos Fernandes wrote 21.09.2021 13:50: We may split that global default pool in two, so we'll have another default pool for external (not controlled by us) libraries. All memory

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-09-20 Thread Alex Peshkoff via Firebird-devel
On 8/23/21 3:44 PM, Tony Whyman wrote: On 23/08/2021 13:03, Alex Peshkoff via Firebird-devel wrote: The minor bug is that if TAG_BUFFER_BYTES_SIZE is set to > 256MB no error status is reported on a call to createBatch. Instead, you only know you have a problem when an error is returned f

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-19 Thread Alex Peshkoff via Firebird-devel
On 9/17/21 6:15 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 17:03: as an additional cherry on a cake we have very fast, efficient and (last but not least) familiar for developers support of hunting for memory leaks.   Is it more familiar than DrMemory

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-17 Thread Alex Peshkoff via Firebird-devel
On 9/17/21 5:53 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 16:13: First of all dynamically loaded libraries are unloaded in reverse order, next invoken executable dtors/atexits, and only after it - dtors of linked libraries.   Ah, ok. But returning

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-17 Thread Alex Peshkoff via Firebird-devel
On 9/17/21 12:44 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 17.09.2021 9:08: Is it about a library dynamically (dlopen, LoadLibrary) loaded or linked to the exacutable?   Both. The library tree is the same (at least on Linux). Tree is the same - but cleanup order

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-17 Thread Alex Peshkoff via Firebird-devel
On 9/16/21 10:58 PM, Dimitry Sibiryakov wrote: Unfortunately atexit of executable is called after atexit of the library causing the executable to call the routine(s) from the library with already destructed globals. Is it about a library dynamically (dlopen, LoadLibrary) loaded or linked

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-09-16 Thread Alex Peshkoff via Firebird-devel
On 9/16/21 4:38 PM, Adriano dos Santos Fernandes wrote: Hi! Unfortunately init_priority do not work as we intended in MacOS. clang generate correct assembly/object file but the MacOS linker do not sort and merge the sections of different files. Pity. But typical for Mac :-(

Re: [Firebird-devel] MessageBuffer vs C struct alignment

2021-09-16 Thread Alex Peshkoff via Firebird-devel
On 9/16/21 1:00 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 16.09.2021 11:52: First of all it's good to know what places are affected. Do not want to try to guess them.   ODS The most strightforward solution for FB5 is new major ODS. For FB4 I see only one

Re: [Firebird-devel] MessageBuffer vs C struct alignment

2021-09-16 Thread Alex Peshkoff via Firebird-devel
On 9/16/21 12:18 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 13.09.2021 9:39: Yes, that should be fixed. If one builds FB with native __int128 it fails on unaligned data access. But changing alignment requirement to 16 bytes is not enough - appears some buffers

Re: [Firebird-devel] MessageBuffer vs C struct alignment

2021-09-13 Thread Alex Peshkoff via Firebird-devel
On 9/12/21 6:40 PM, Dimitry Sibiryakov wrote: Alex Peshkoff via Firebird-devel wrote 15.05.2018 12:13: On 05/15/18 13:06, Dimitry Sibiryakov wrote: 15.05.2018 11:58, Alex Peshkoff via Firebird-devel wrote:   Do alignment of fields in C struct matches alignment of the same fields

Re: [Firebird-devel] fb_info_protocol_version implementation

2021-09-03 Thread Alex Peshkoff via Firebird-devel
On 9/3/21 3:32 PM, Jiří Činčura wrote: Hi, Where I can find fb_info_protocol_version implementation? I'm looking into https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/inf.cpp and that case is not there. Nor I can find the fb_info_protocol_version while grep-ing the sources.

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

2021-09-03 Thread Alex Peshkoff via Firebird-devel
On 9/3/21 2:29 PM, Mike Kaganski wrote: ODB is a ZIP; it contains a database/firebird.fbk, from which a FDB is created when LO opens the DB. I used 'gbak -C firebird.fbk firebird.fdb' to extract the file initially. For example database that has left in tmp dir. Here it is:

Re: [Firebird-devel] Rework the error message processing for simpler and faster build

2021-09-03 Thread Alex Peshkoff via Firebird-devel
On 9/2/21 7:32 PM, Dimitry Sibiryakov wrote: That's pity. It is a dead piece anyway. After such phraze should fiollow: "instead it I suggest bla-bla-bla...". Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

2021-09-03 Thread Alex Peshkoff via Firebird-devel
On 9/3/21 1:24 PM, Mike Kaganski wrote: Sure - here's the stack trace of the moment when VS shows "Exception thrown at 0x7FFA0F4A1A29 (vcruntime140d.dll) in soffice.bin: 0xC005: Access violation writing location 0x025B7D701000."; sorry for not including it from start. Note that

Re: [Firebird-devel] Tips for a strange bug in firebird integrated into LibreOffice

2021-09-03 Thread Alex Peshkoff via Firebird-devel
On 9/3/21 11:54 AM, Mike Kaganski wrote: Hi! I understand that the question is less than ideal, and I'm sorry for that. I'm trying to debug a very strange bug in Firebird built into LibreOffice (embedded DB functionality). A specific ODB (a package that contains a FB database) crashes

Re: [Firebird-devel] Dialect 3 inconsistent round/trunc - configurable calculation method needed

2021-09-01 Thread Alex Peshkoff via Firebird-devel
On 9/1/21 7:13 PM, Omacht András wrote: (Or please support D1 and don’t force developers to rewrite existing codebase.) May be I've missed something - but did we have plans to remove Dialect 1? It seems that not. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-23 Thread Alex Peshkoff via Firebird-devel
On 8/21/21 6:26 PM, Tony Whyman wrote: The good news is that I believe I have found a way around the problem. The bad news is that I think I have found another minor bug. The workaround for variable message sizes is to compute the "used" buffer size after each call to IBatch::add by ensuring

Re: [Firebird-devel] The IBatch Interface and Buffer Overflow

2021-08-20 Thread Alex Peshkoff via Firebird-devel
On 8/20/21 4:01 PM, Tony Whyman wrote: .. With my test data, the buffer overflow occurs after several thousand calls to IBatch::add. The number of message buffers lost is of the order of hundreds. I don't want to have to keep a copy of every message buffer as that could result in other

Re: [Firebird-devel] isc_info_sql_stmt_type/isc_info_sql_stmt_flags

2021-08-19 Thread Alex Peshkoff via Firebird-devel
On 8/19/21 4:17 PM, Adriano dos Santos Fernandes wrote: Hi! Since RETURNING was created, we change values of isc_info_sql_stmt_type so clients can understand that statements with RETURNING have values. With GH-6815, RETURNING will return cursors (except for INSERT INTO ... VALUES RETURNING

Re: [Firebird-devel] Windows installer and ICU files

2021-08-16 Thread Alex Peshkoff via Firebird-devel
On 8/16/21 5:56 PM, Paul Reeves wrote: On Mon, 16 Aug 2021 17:34:09 +0300 Alex Peshkoff via Firebird-devel wrote: One detail - this should not be called "minimum client install". This should be called "default install", Or maybe just call it 'client install', or 'clie

Re: [Firebird-devel] Windows installer and ICU files

2021-08-16 Thread Alex Peshkoff via Firebird-devel
On 8/16/21 5:25 PM, Carlos H. Cantu wrote: VK>Only by explicit user request, off by default. Beside the ICU DLLs, I also agree with Adriano that zlib1.dll should be installed during a Client install. I would go further and install chacha.dll too. Currently installer doesn't install

Re: [Firebird-devel] ConfigStorage mutex error

2021-08-09 Thread Alex Peshkoff via Firebird-devel
On 8/8/21 6:54 PM, Dimitry Sibiryakov wrote: Hello All   what can be a reason for the error "ConfigStorage: mutex mutexLock error, status = 22" in firebird.log?    EINVAL The mutex was created with the protocol attribute having the value PTHREAD_PRIO_PROTECT and the calling  thread's

Re: [Firebird-devel] New getInfo2 API

2021-07-27 Thread Alex Peshkoff via Firebird-devel
On 7/26/21 10:08 PM, Dimitry Sibiryakov wrote: Why not return IXpbBuilder? It already has all needed navigation methods. Yes - and functions to read info data in different formats are also there. Just make getinfo2() return XpbBuilder instead InfoBuffer. Firebird-Devel mailing list, web

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

2021-07-26 Thread Alex Peshkoff via Firebird-devel
On 7/26/21 5:40 PM, Arnaud Le-roy wrote: Also I do not see any thread actively working with database, i.e. probably one with AV (thread 2) is such thread. And in that case problematic UDF (as always) is first candidate to raise problems. Can one confirm that w/o UDF bug does not happen?

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

2021-07-26 Thread Alex Peshkoff via Firebird-devel
On 7/24/21 12:23 PM, Arnaud Le-roy wrote: Hi, This is the complete gdb logs : >20 frames in a thread without any debug info... nice bug. Must say that firebird sometimes can create such traces w/o debug info - this happens when provider is unloaded (by mistake, certainly) in the middle of

Re: [Firebird-devel] Thread about Jaybird / Firebird Embedded crash on firebird-java

2021-07-23 Thread Alex Peshkoff via Firebird-devel
On 7/23/21 10:50 AM, Mark Rotteveel wrote: Hi, Last week a question was asked on firebird-java regarding a JVM crash on Linux when Firebird Embedded is used in combination with a UDF, but to be honest, I have no clue what to look for. I have been able to reproduce the crash (or possibly

Re: [Firebird-devel] Invalid SPB

2021-07-20 Thread Alex Peshkoff via Firebird-devel
On 7/20/21 5:17 PM, Jiří Činčura wrote: BTW, anybody remembers the reason why version 2 has two values - isc_spb_version, isc_spb_current_version - at the beginning? Sooner of all this should be asked in Borland / Inprise - that was so in IB6.0. Firebird-Devel mailing list, web

Re: [Firebird-devel] Invalid SPB

2021-07-20 Thread Alex Peshkoff via Firebird-devel
On 7/20/21 4:52 PM, Jiří Činčura wrote: Aha! I suppose in version 2 I can't send data with 2-byte length, right? Aka, I need to jump to version 3 and use 4-byte length. Exactly. V.3 for SPB is like v.2 for DPB. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Invalid SPB

2021-07-20 Thread Alex Peshkoff via Firebird-devel
On 7/20/21 4:29 PM, Jiří Činčura wrote: Looks OK to me, but obviously it is not. Both the isc_spb_auth_plugin_name and isc_spb_specific_auth_data should be wide (https://github.com/FirebirdSQL/firebird/blob/B3_0_Release/src/common/classes/ClumpletReader.cpp#L324), right? What am I missing?

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 4:54 PM, Tony Whyman wrote: So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 12:39 PM, Tony Whyman wrote: I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/15/21 10:56 PM, Dimitry Sibiryakov wrote: 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: Comments?   I see no point in the new interface. Not new iface, just extension of old one. It would be simpler to raise trace BLR event from SQL prepare and let anyone interested to watch

Re: [Firebird-devel] Client forcing server to encryption

2021-07-15 Thread Alex Peshkoff via Firebird-devel
On 7/15/21 12:23 PM, Jiří Činčura wrote: Hi, I have server with "WireCrypt = Disabled", but I can "just" send op_crypt and server follows. Is this expected? With current code - yes. But on my mind that's a bug (never seen with fbclient). Please add a ticket to the tracker.

Re: [Firebird-devel] IPluginModule::doClean() call point

2021-07-14 Thread Alex Peshkoff via Firebird-devel
On 7/14/21 3:37 PM, Vlad Khorsun wrote: 14.07.2021 15:29, Dimitry Sibiryakov wrote: 14.07.2021 14:25, Vlad Khorsun wrote:    Are you sure fb_shutdown() was called before exit() ?    isql calls fb_shutdown() in atexit() handler so it is surely called after exit().  Yes, indeed. In isql

<    1   2   3   4   5   6   7   8   9   >