|
Just checked again, on 3.0.5.33085 -- bug *does* exist, see attached screen.
My config: ======= [root@localhost firebird]# cat firebird.conf RemoteServicePort = 3050 #include /opt/scripts/fb30.conf.SC include /opt/scripts/fb30.conf.SS DeadlockTimeout = 10 BugCheckAbort=1 TempDirectories = /tmp AuthServer = Legacy_Auth,Srp AuthClient = Legacy_Auth,Srp WireCrypt = Enabled UserManager = Legacy_UserManager,Srp UdfAccess = Restrict UDF ExternalFileAccess = Full [root@localhost firebird]# cat /opt/scripts/fb30.conf.SS ServerMode=Super DefaultDbCachePages = 999K FileSystemCacheThreshold = 65535K TempCacheLimit = 1G TempSpaceLogThreshold = 512M LockHashSlots = 49999 LockMemSize = 50M IpcName = fb30SS ======= Tried with your configuration, tried both debug & release builds - still not reproduced. What else can I miss?
> What else can I miss?
Just checked on LI-V3.0.5.33077, *special* build with replication support, on another POSIX host (i.e. not CentOS): ======= root@f51-db02:/opt/scripts# cat /etc/*release* DISTRIB_ID=Ubuntu DISTRIB_RELEASE=16.04 DISTRIB_CODENAME=xenial DISTRIB_DESCRIPTION="Ubuntu 16.04.1 LTS" NAME="Ubuntu" VERSION="16.04.1 LTS (Xenial Xerus)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 16.04.1 LTS" VERSION_ID="16.04" ======= + config: ======= AuthClient = Legacy_Auth, Srp AuthServer = Legacy_Auth, Srp BugCheckAbort = 1 DefaultDbCachePages = 10K ExtConnPoolLifeTime = 900 ExtConnPoolSize = 100 FileSystemCacheThreshold = 999999K LockHashSlots = 30011 LockMemSize = 30M RemoteAuxPort = 3060 RemoteServicePort = 3050 ServerMode=Super TempBlockSize = 2048576 TempCacheLimit = 1500M TempDirectories = /dev/shm;/tmp TempSpaceLogThreshold = 1000M UserManager = Srp, Legacy_UserManager WireCompression = true WireCrypt = Enabled ======= -- result is the same (i.e. with bug). Checked one more time on WI-V3.0.5.33084, *standard* build (downloaded from official FB site with snapshots folder), -- and also got wrong output. So... i really do not know what the reason that it works OK on your environment... I can force EDS connection to stay in long pause when it is establishes (using UDF or simulate this delay on "pure PSQL" with attempt to insert duplicate iondex key - no matter). And gather full memory dumps + stack trace for this state, both on Linux and Windows. And send this info to you and Vlad. Can this help in investigation ? Not needed. I've reproduced a bug on 32-bit build using gcc 6.4.
Issue was reproduced unstable due to dependence of it from order of items in DPB which in turn depends upon a lot of other factors like length of authentication block in it.
|
WHERE_I_AM /usr/home/firebird/HEAD/gen/Debug/firebird/examples/empbuild/employee.fdb
WHO_AM_I BAR
WHATS_MY_RTOLE MANAGER
WHERE_I_AM /usr/home/firebird/HEAD/gen/Debug/firebird/examples/empbuild/employee.fdb
WHO_AM_I FOO
WHATS_MY_ROLE WORKER
ISQL Version: LI-T4.0.0.1384-dev Firebird 4.0 Alpha 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T4.0.0.1384-dev Firebird 4.0 Alpha 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T4.0.0.1384-dev Firebird 4.0 Alpha 1/tcp (fbs3)/P16:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T4.0.0.1384-dev Firebird 4.0 Alpha 1/tcp (fbs3)/P16:C"
on disk structure version 13.0
WHERE_I_AM /usr/home/firebird/B3_0_Release/gen/Debug/firebird/examples/empbuild/employee.fdb
WHO_AM_I BAR
WHATS_MY_RTOLE MANAGER
WHERE_I_AM /usr/home/firebird/B3_0_Release/gen/Debug/firebird/examples/empbuild/employee.fdb
WHO_AM_I FOO
WHATS_MY_ROLE WORKER
ISQL Version: LI-V3.0.5.33084-dev Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.5.33084-dev Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.5.33084-dev Firebird 3.0/tcp (fbs3)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.5.33084-dev Firebird 3.0/tcp (fbs3)/P15:C"
on disk structure version 12.0