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

2021-02-24 Thread Mark Rotteveel
On 2021-02-25 01:38, Adriano dos Santos Fernandes wrote: On 24/02/2021 19:09, Lucas Schatz wrote: 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

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

2021-02-24 Thread Peter Gore
Hi Dimetri, 3 things if I may Your suggestion still did not work. What *does *seem to work is if I make log_source_directory = log_directory (NOT log_archive_directory as advised). *Please comment*. I am getting errors however in the replication log TOSHPJG (replica) Thu Feb 25 06:11:39 2021

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

2021-02-24 Thread Adriano dos Santos Fernandes
On 24/02/2021 19:09, Lucas Schatz wrote: > 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

[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)
Fb4 RC1 synchronous replication to localhost hang on disconnect --- Key: CORE-6497 URL: http://tracker.firebirdsql.org/browse/CORE-6497 Project: Firebird Core Issue Type: Bug

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. > > > Dmitry > > > Firebird-Devel

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Dmitry Yemanov
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. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Lucas Schatz
Can someone reproduce it too? If yes, I'll open a report Environment: Centos 8 64bits, SELinux disabled fresh install replication.conf: database = /db/primary.fdb { sync_replica = SYSDBA:***@localhost:/db/replica.fdb } // My script for testin systemctl stop firebird mkdir /db chown

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Dmitry Yemanov
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 open a bug report? If you have a reproducible scenario - sure, feel free. Dmitry Firebird-Devel mailing list, web

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] Firebird 4 replication

2021-02-24 Thread Martin Wong
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 happen when using flamerobin, so I will check my firebird client

[Firebird-devel] [FB-Tracker] Created: (CORE-6496) string_to_datetime and '\0' symbol

2021-02-24 Thread Kovalenko Dmitry (JIRA)
string_to_datetime and '\0' symbol -- Key: CORE-6496 URL: http://tracker.firebirdsql.org/browse/CORE-6496 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.8

[Firebird-devel] [FB-Tracker] Created: (CORE-6495) string_to_datetime and y2k problem

2021-02-24 Thread Kovalenko Dmitry (JIRA)
string_to_datetime and y2k problem -- Key: CORE-6495 URL: http://tracker.firebirdsql.org/browse/CORE-6495 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.8

[Firebird-devel] [FB-Tracker] Created: (CORE-6494) Inconsistent translation "string->timestamp->string->timestamp" and first dialect

2021-02-24 Thread Kovalenko Dmitry (JIRA)
Inconsistent translation "string->timestamp->string->timestamp" and first dialect -- Key: CORE-6494 URL: http://tracker.firebirdsql.org/browse/CORE-6494 Project:

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

2021-02-24 Thread Peter Gore
Hi Dimitry, At least now I do have a replication log - for the first time. It contains one entry. TOSHPJG (replica) Wed Feb 24 06:26:05 2021 Database: D:\USERS\PETER\DOCUMENTS\FB4DATA\FB4TESTREPLICA.FDB WARNING: Record being deleted from table INIDB does not exist, ignoring Not sure if this is

Re: [Firebird-devel] Firebird 4 replication

2021-02-24 Thread Dmitry Yemanov
24.02.2021 11:13, Martin Wong wrote: I am trying to test the new Firebird 4  synchronous replication on windows 7 64bit machine with the following configurations: #databases.conf master = d:\fb4\master.fdb replica = d:\fb4\replica.fdb #replication.conf database = master {    sync_replica =

[Firebird-devel] Firebird 4 replication

2021-02-24 Thread Martin Wong
Hello All, I am trying to test the new Firebird 4 synchronous replication on windows 7 64bit machine with the following configurations: #databases.conf master = d:\fb4\master.fdb replica = d:\fb4\replica.fdb #replication.conf database = master { sync_replica =