Re: [Firebird-devel] Named parameters in client libraries

2022-08-17 Thread Lucas Schatz
Hi, last time I checked, IBExpert used the last parameter as reference, so it'll use a varchar(1)/char(1) . I followed the same pattern for the IBPP library bundled with Flamerobin when I added named parameters support, I wanted to convert correctly the parameter to its appropriate data type but

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

2022-06-03 Thread Lucas Schatz
2022 06:41, Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> escreveu: > 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

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

2022-05-27 Thread Lucas Schatz
Installed, now wait for the error, probably only next week Em sex., 27 de mai. de 2022 08:58, Alex Peshkoff escreveu: > 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" t

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

2022-05-26 Thread Lucas Schatz
< firebird-devel@lists.sourceforge.net> wrote: > 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

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

2022-05-25 Thread Lucas Schatz
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. On Wed, May 25, 2022 at 11:40 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/25/22 17:35, Lucas Schatz wrote: > > I

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

2022-05-25 Thread Lucas Schatz
But not really sure On Wed, May 25, 2022 at 11:29 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/25/22 17:23, Lucas Schatz wrote: > > 17gb +- > > > > Can you compress it (xz is preferred for obv.reasons) and put to some > download

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

2022-05-25 Thread Lucas Schatz
17gb +- On Wed, May 25, 2022 at 8:30 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > 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

Re: [Firebird-devel] Tablespaces proposal

2021-10-11 Thread Lucas Schatz
Just to clarify, the use of tablespace will be optional, right? Anyway it would be a great improvement to Fb! Thanks! On Wed, Oct 6, 2021 at 12:33 PM Roman Simakov wrote: > Hello, team! > > As you might know Red Soft has implemented Tablespace support for > RedDatabase 4 which is based on

[Firebird-devel] Centos 7 + Firebird-4.0.0.2496-0.amd64 + libncurses.so.6

2021-06-11 Thread Lucas Schatz
Hi, I has trying to install Fb4 Release at Centos 7.7 and got this error message: Please install required library 'libncurses.so.6' before firebird, after it repeat firebird install After creating the corresponding symlinks: ln -s libncurses.so.5 /usr/lib64/libncurses.so.6 ln -s libtommath.so.0

Re: [Firebird-devel] Firebird 4 Install and replication

2021-02-25 Thread Lucas Schatz
Ok, Thanks for your help On Thu, Feb 25, 2021 at 2:47 PM Dmitry Yemanov wrote: > 25.02.2021 20:37, Lucas Schatz wrote: > > > So I guess that for now the "safest" option is async (related to network > > instability) , correct? > > Right. > > > Just a cu

Re: [Firebird-devel] Firebird 4 Install and replication

2021-02-25 Thread Lucas Schatz
y changing log_archive_command to something that copies to 2 or more destinations, but I would like to know what you thing about Thanks On Thu, Feb 25, 2021 at 1:57 PM Dmitry Yemanov wrote: > 25.02.2021 17:10, Lucas Schatz wrote: > > > I im testing for a week, and I think that the current Synchrono

Re: [Firebird-devel] Firebird 4 Install and replication

2021-02-25 Thread Lucas Schatz
I im testing for a week, and I think that the current Synchronous mode is awesome but too fragile to a daily use as a security feature, if I'm not mistaken at any network failure or replica restart you'll be prone to inconsistency in the replica data, leading to more work from de DBA to find and

[Firebird-devel] Firebird 4 Invalid time zone region: , 00:00:00

2021-02-24 Thread Lucas Schatz
Hi, at Firebird 3 and older this SQL works fine: SELECT timestamp '01.01.2000, 00:00:00' from RDB$DATABASE or SELECT cast( '01.01.2000, 00:00:00' as timestamp ) from RDB$DATABASE But at Firebird 4 using DataTypeCompatibility = 3.0 I got this error: Unsuccessful execution caused by system error

[Firebird-devel] [FB-Tracker] Created: (CORE-6497) Fb4 RC1 synchronous replication to localhost hang on disconnect

2021-02-24 Thread Lucas Schatz (JIRA)
Components: Engine Affects Versions: 4.0 RC 1 Environment: VM Centos 8 64bits, SELinux disabled fresh install 1 CPU, 2Gb RAM, 20Gb disk Reporter: Lucas Schatz Steps to reproduce: replication.conf: database = /db/primary.fdb { sync_replica = SYSDBA

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Lucas Schatz
http://tracker.firebirdsql.org/browse/CORE-6497 Thanks On Wed, Feb 24, 2021 at 12:36 PM Dmitry Yemanov wrote: > 24.02.2021 18:14, Lucas Schatz wrote: > > > Can someone reproduce it too? If yes, I'll open a report > > I can, thanks. Please post to the tracker. > > >

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Lucas Schatz
lhost:/db/replica.fdb Thanks On Wed, Feb 24, 2021 at 10:05 AM Dmitry Yemanov wrote: > 24.02.2021 15:55, Lucas Schatz wrote: > > > > Hi, I was experiencing this hanging here too, when using local > > synchronous replication the server hangs during the disconnection, maybe

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Lucas Schatz
On Wed, Feb 24, 2021 at 8:15 AM Martin Wong wrote: > Yes I missed applying these: > ALTER DATABASE ENABLE PUBLICATION; > > After applying it, replication done correctly and the replica database > updated directly, but now firebird hangs after master database > disconnected, but that did not

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

2021-02-23 Thread Lucas Schatz
Yes I know that I can extract and copy, I'll export/import only as a last resource But I'm asking if anyone here tried to do what I'm asking for, and if had any problems with this "hack" On Tue, Feb 23, 2021 at 6:28 PM Ivan Přenosil wrote: > - create new empty database using sql scripts (if

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

2021-02-23 Thread Lucas Schatz
On Tue, Feb 23, 2021 at 3:00 PM liviuslivius wrote: > Why not standard way by creating new field copy data delete old and > rename? > Hundreds of tables/SPs/Triggers using this domain (it's used domain in almost every table, multiple times per table) It can be slow operation, is it your conern

[Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

2021-02-23 Thread Lucas Schatz
Hi, I have a 100Gb+ database that has a domain of data type "Double Precision" but used as integer (no decimals, just integer values), and was hoping to change it to bigint. I has thinking: if I backup the database and edit the fdk with a hex editor and change the domain information, the 3º char

[Firebird-devel] FB4 asynchronous replication - segment files isn't deleted after a second full rsync

2021-02-20 Thread Lucas Schatz
New question: async replication is working fine and created 5 chlog journal files When I run rsync, Firebird successfully created/excluded everything, and I noted that Firebird deletes the journal files... and created a "UUID control file" So, how I was curious I re-run a full rsync of the journal

Re: [Firebird-devel] FB4 asynchronous replication offline replica problem

2021-02-20 Thread Lucas Schatz
Hello! I was able do make async work Thank you! On Sat, Feb 20, 2021 at 5:07 PM Dimitry Sibiryakov wrote: > 20.02.2021 19:20, Lucas Schatz wrote: > > Also, for the synchronous mode, I'm a little concerned about the > fragility in the sync > > state... is there a way to

Re: [Firebird-devel] FB4 asynchronous replication offline replica problem

2021-02-20 Thread Lucas Schatz
Hi Dmitry On Sat, Feb 20, 2021 at 6:24 AM Dmitry Yemanov wrote: > 20.02.2021 00:43, Lucas Schatz wrote: > > > > The async replication works correctly when both servers are running, the > > journaling files are created and moved from log_directory to > > log_arc

[Firebird-devel] FB4 asynchronous replication offline replica problem

2021-02-19 Thread Lucas Schatz
Hi everybody I'm testing the replication in Firebird4 RC1, and I'm experiencing a problem The async replication works correctly when both servers are running, the journaling files are created and moved from log_directory to log_archive_directory and the data is replicated almost instantly to the

Re: [Firebird-devel] Firebird 4, new int128 problem

2021-02-08 Thread Lucas Schatz
Thanks, worked like a charm :) On Mon, Feb 8, 2021 at 11:54 AM Dimitry Sibiryakov wrote: > 08.02.2021 15:44, Lucas Schatz wrote: > > Any advice of what I should do? > >Read firebird.conf about "DataTypeCompatibility" configuration setting > and > doc/REA

[Firebird-devel] Firebird 4, new int128 problem

2021-02-08 Thread Lucas Schatz
Hi, I'm beginning my tests with Fb4 RC1, successfully converted my database, but I'm having problems with the new int128 data type, where my component access doesn't support it yet, is it possible to disable somehow INT128,DECFLOAT(16) DECFLOAT(34) - DECFLOAT, NUMERIC(38)... from Fb4 directly? - -

[Firebird-devel] [FB-Tracker] Created: (CORE-6457) Internal error. Database page XXXXXXXX had been changed during backup (page SCN=YYYYYYY, backup SCN=ZZZZZZZZ)

2020-12-21 Thread Lucas Schatz (JIRA)
:00 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux Server Load during the episode: <1.15 Reporter: Lucas Schatz Hi everybody, just to explain, I`m running nbackup in 20 databases every minute during work time, for 1 year, and I got just 2 times this error so I`m assuming it`s a rare ev

[Firebird-devel] [FB-Tracker] Created: (CORE-6391) NBackup don't validate invalid level in some special occasions, leading to invalid files impossible to restore

2020-08-18 Thread Lucas Schatz (JIRA)
://tracker.firebirdsql.org/browse/CORE-6391 Project: Firebird Core Issue Type: Bug Components: NBACKUP Affects Versions: 3.0.6 Environment: Win 10, Fb 3.0.6 Reporter: Lucas Schatz Example: Do nbackup level 0 - OK Do nbackup level 1 - OK Do nbackup level 2