Re: [Firebird-devel] Trace API withEmbeddedandUnicodeinitializationproblem
Hello Vlad, PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be useful? At least, we can try :) Please download: http://www.iblogmanager.com/download/misc/FBEmbeddedTrace.zip This includes FB Embedded 2.5.2 Update 1 x86, trace plugin and fbtracemgr.exe from a regular x86 Server ZIP. In an 'application' sub-directory you will find a 32-bit Delphi application and a test database. The embedded library has been renamed to fbclient.dll. Please make sure that no other fbclient.dll is available through PATH etc. Then, please try: * Run _start_trace.bat * Run _start_isql.bat This should show trace output just fine. Now: * Run application/FBEmbeddedTest.exe * The pre-configured client library in the edit box should be fine * Click the Connect button You now should see the UNICODE initialization problem in the trace output. Thanks for investigating. Regards, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Embedded distribution and trace plugin, fbtracemgr.exe
Hello, is there any particular reason (except probable ZIP size) why the trace plugin and fbtracemgr.exe is not included in the embedded distribution? Thanks, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available fortesting
No builds for macosx ? No... I am still in the process of trying to do the port... MacOSX gcc is broken (exception handling) - even the version in MacPorts AFAICS (64bit only) So am attempting to use clang... (latest version of XCode on Mavericks) Which brings its own problems... TLS issues and 10.7+ support only or will have to revert to a previous version of MacOSX and XCode that works If you are bored you can join in the fun. Paul On Sat, Feb 1, 2014 at 10:55 AM, Dmitry Yemanov firebi...@yandex.ru wrote: Firebird Project announces the second Alpha release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker. Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release. Please read the Release Notes carefully before installing and testing this Alpha release. Download page: http://www.firebirdsql.org/en/firebird-3-0-0-alpha2/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Alpha2-ReleaseNotes.pdf -- Dmitry Yemanov -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Alpha 2 - SuperServer - Can't connect with multiple isql sessions
Hello, I'm sure I'm doing something wrong here ... Testing Alpha 2 x86 on Windows using the ZIP distribution. From a configuration side, I only changed the port in firebird.conf to 4050, so I'm running SuperServer. A first isql session with: isql 'localhost/4050:tourism.fdb' -user tourism -password x With TCPView, I see isql being connected through port 4050. A second isql session with the same call as above fails with: Statement failed, SQLSTATE = 08001 I/O error during CreateFile (open) operation for file tourism.fdb -Error while trying to open file -The process cannot access the file because it is being used by another process. Am I doing something wrong? Thanks, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - SuperServer - Can't connect with multiple isql sessions
02.02.2014 11:23, Thomas Steinmaurer wrote: From a configuration side, I only changed the port in firebird.conf to 4050, so I'm running SuperServer. No, to run Super-anything, you must run/install firebird.exe with -m switch. -- WBR, SD. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Trace APIwithEmbeddedandUnicodeinitializationproblem
PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be useful? At least, we can try :) Please download: http://www.iblogmanager.com/download/misc/FBEmbeddedTrace.zip This includes FB Embedded 2.5.2 Update 1 x86, trace plugin and fbtracemgr.exe from a regular x86 Server ZIP. In an 'application' sub-directory you will find a 32-bit Delphi application and a test database. The embedded library has been renamed to fbclient.dll. Please make sure that no other fbclient.dll is available through PATH etc. I've set PATH to empty value Then, please try: * Run _start_trace.bat * Run _start_isql.bat This should show trace output just fine. Yes, it shows trace output Now: * Run application/FBEmbeddedTest.exe * The pre-configured client library in the edit box should be fine * Click the Connect button You now should see the UNICODE initialization problem in the trace output. No, i see ATTACH_DATABASE event by this application. Regards, Vlad PS does you tried LoadLibraryEx with LOAD_WITH_ALTERED_SEARCH_PATH ? -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Trace APIwithEmbeddedandUnicodeinitializationproblem
Hello Vlad, PS If you provide me with reproducible sample i'll try to investigate it The only thing I could provide is a 32-bit Delphi application which points to an Embedded library. The executable must not be in the same directory. Would this be useful? At least, we can try :) Please download: http://www.iblogmanager.com/download/misc/FBEmbeddedTrace.zip This includes FB Embedded 2.5.2 Update 1 x86, trace plugin and fbtracemgr.exe from a regular x86 Server ZIP. In an 'application' sub-directory you will find a 32-bit Delphi application and a test database. The embedded library has been renamed to fbclient.dll. Please make sure that no other fbclient.dll is available through PATH etc. I've set PATH to empty value Then, please try: * Run _start_trace.bat * Run _start_isql.bat This should show trace output just fine. Yes, it shows trace output Now: * Run application/FBEmbeddedTest.exe * The pre-configured client library in the edit box should be fine * Click the Connect button You now should see the UNICODE initialization problem in the trace output. No, i see ATTACH_DATABASE event by this application. That's a pity. ;-) Do you have the FIREBIRD environment variable set? Regards, Vlad PS does you tried LoadLibraryEx with LOAD_WITH_ALTERED_SEARCH_PATH ? Doesn't help. Regards, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - SuperServer - Can't connect with multiple isql sessions
02.02.2014 11:23, Thomas Steinmaurer wrote: From a configuration side, I only changed the port in firebird.conf to 4050, so I'm running SuperServer. No, to run Super-anything, you must run/install firebird.exe with -m switch. Thanks, that did the trick, although I do not see any reason to make -m mandatory for SuperServer. The release notes also only mention -m as a distinction between CS/SC and doesn't take SS into account. Regards, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem
You now should see the UNICODE initialization problem in the trace output. No, i see ATTACH_DATABASE event by this application. That's a pity. ;-) Do you have the FIREBIRD environment variable set? No. PS does you tried LoadLibraryEx with LOAD_WITH_ALTERED_SEARCH_PATH ? Doesn't help. That's a pity. ;-) Regards, Vlad PS You could also try to use FileMon\ProcMon to trace application activity -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4330) not correct result function LAG, if the value OFFSET values are assigned from a table
not correct result function LAG, if the value OFFSET values are assigned from a table --- Key: CORE-4330 URL: http://tracker.firebirdsql.org/browse/CORE-4330 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis with t(a, b) as ( select 1, null from rdb$database union all select 2, 1 from rdb$database union all select 3, 2 from rdb$database union all select 4, 3 from rdb$database union all select 5, 2 from rdb$database ) select a, b, lag(a, b) over(order by a) as la from t A B LA 1 2 1 -- incorrect 3 2 -- incorrect 4 3 2 -- incorrect 5 2 3 PostgreSQL return correct result with t(a, b) as ( select 1, null union all select 2, 1 union all select 3, 2 union all select 4, 3 union all select 5, 2 ) select a, b, lag(a, b) over(order by a) as la from t A B LA 1 2 1 1 3 2 1 4 3 1 5 2 3 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem
You now should see the UNICODE initialization problem in the trace output. No, i see ATTACH_DATABASE event by this application. That's a pity. ;-) Do you have the FIREBIRD environment variable set? No. PS does you tried LoadLibraryEx with LOAD_WITH_ALTERED_SEARCH_PATH ? Doesn't help. That's a pity. ;-) Regards, Vlad PS You could also try to use FileMon\ProcMon to trace application activity I see that icuin30.dll is tried to be loaded from various places (although excluding the embedded root path), but this fails. icuin30.dll is available in the embedded root directory. When I put the dll into the application sub-folder, then the trace output works. Can you please check from where icuin30.dll is loaded when running my test application? Btw, I now found: http://tracker.firebirdsql.org/browse/CORE-3183 Regards, Thomas -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem
PS You could also try to use FileMon\ProcMon to trace application activity I see that icuin30.dll is tried to be loaded from various places (although excluding the embedded root path), but this fails. icuin30.dll is available in the embedded root directory. When I put the dll into the application sub-folder, then the trace output works. Can you please check from where icuin30.dll is loaded when running my test application? I have all three ICU libraries in system32 folder. And your application load icuin30.dll from system32 (even when i set PATH to empty string) and other two ICU dll's from embedded folder. Btw, I now found: http://tracker.firebirdsql.org/browse/CORE-3183 It finally points me to the source of the problem - fbtrace.dll have no idea that it works with embedded and load icuin30.dll not using LOAD_WITH_ALTERED_SEARCH_PATH flag. Will think how to fix it correctly. Thanks, Vlad -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem
02.02.2014 20:16, Vlad Khorsun wrote: It finally points me to the source of the problem - fbtrace.dll have no idea that it works with embedded and load icuin30.dll not using LOAD_WITH_ALTERED_SEARCH_PATH flag. I wonder why it doesn't use library already loaded by server itself. Do they use library name with pathes in LoadLibrary() call?.. -- WBR, SD. -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem
02.02.2014 20:16, Vlad Khorsun wrote: It finally points me to the source of the problem - fbtrace.dll have no idea that it works with embedded and load icuin30.dll not using LOAD_WITH_ALTERED_SEARCH_PATH flag. I wonder why it doesn't use library already loaded by server itself. icuin30.dll is loaded dynamically when it is needed. fbtrace needs it at the very early stage of attachment initialization and before the user attachment (probably) needs it itself Do they use library name with pathes in LoadLibrary() call?.. No. It not used LOAD_WITH_ALTERED_SEARCH_PATH flag as it is used only by embedded engine. Maybe it was too conservative decision - to use this flag by embedded only. Regards, Vlad -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel