|
[
Permalink
| « Hide
]
Alexander Peshkov added a comment - 22/Jan/19 03:18 PM
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.
Not needed. I've reproduced a bug on 32-bit build using gcc 6.4.
> 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 ? Tried with your configuration, tried both debug & release builds - still not reproduced. What else can I miss?
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 ======= Can not reproduce (used exactly your script with default config):
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 |