databases.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web
join T_EMAIL_TYPE_DIM EMTD on EMTD.F_EMT_VALUE = EWR.F_EWR_TYPE;
Removing the distinct (I know, it's useless for the end result in this
case) makes the query finish fine.
Can I pinpoint why is this happening?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces
ere a ETA for 3.0.3?
>Could you confirm your app uses SELECT WITH LOCK ?
I was wrong. Found one statement using "FOR UPDATE WITH LOCK". So it
might be related at the end.
--
Mgr. Jiří Činčura
https://
able to run it. If/When the 3.0.3 fails I'll start again with 3.0.2 and
take the dump after it happens. Is there a way to trigger regular fault
at that point so I can attach procdump?
> PS Could it be http://tracker.firebirdsql.org/browse/CORE-5576 ?
Does to me.
--
Mgr. Jiř
nd on both the same.
If anybody is interested, I can get you memory dumps etc. It's a
production machine, but it's down because of this anyway so I can play
with it even bit more than regular production machine.
--
Mgr. Jiří Činčura
https://www.tabsover
BTW can I rely on the order of callbacks? First for database and the
other for security (or maybe vice versa, I don't have the code in front
of me now).
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out
'll not burn my time on this any more.
> But of course, you can use IMetadataBuilder.
Yeah. Not really. If I change charset I have to change the length myself
as well and I don't know the bytes per char for original charset.
--
Mgr. Jiří Čin
Hi *,
Can I *easily* get number of bytes per character for given character set ID in
external engine?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's
ameters.
You mean IMetadataBuilder, right?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-
Looks like it has no effect, though it is called. Using WIN1250 there and I'm
still getting the varchars in UTF-8 (connection charset). So it probably has
different purpose?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Mon, Jul 24, 2017, at 11:56, Jiří Činčura wrote:
> Hi *,
>
length==1 in metadata (metadata->getLength(status, i)), while when I
omit the "character set ascii" I get the expected length==4.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibran
Hi *,
is there a way to get attachement_id (the same as in mon$attachments)
from IAttachment isntance?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's
Too fast. The encrypted connection will have 'C' there and I'm getting
that string from isc_info_firebird_version.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one
> itself.
I think you can get the information from full version string. I'm using
it
(https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.UnitTests/FbConnectionTests.cs#L352)
to test everything with compression is fine from server's POV.
--
Mg
>Seems it runs in embedded mode and see itself only :)
>
> Try using xnet://service_mgr or inet://service_mgr
Yes, that works. Maybe worth putting this into docs?
--
Mgr. Jiří Činčura
https://www.tabsovers
svcmgr service_mgr
-user sysdba -password masterkey action_trace_start trc_name ...". Any
other idea?
It's vanilla 3.0.2 x64 downloaded from SF.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the
e server and
client. And that contract is now broken.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slas
>What Firebird account you used to run trace ?
I haven't specified any username/password. The command line I posted is
all I executed.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibr
Hi *,
I realized the fbtrace.conf has new format in FB3. Is the old one still
supported (because that's what the .NET provider is currently using - I
was not expecting this to be change "just because we can")?
--
Mgr. Jiří Činčura
https://www.tabsover
service_mgr
action_trace_start trc_name "test" trc_cfg fbtrace.conf
Although I get back "Trace session ID 1 started" I never get any
statement or connection, despite executing and connecting using isql as
hard as I can.
Am I missing something?
--
Mgr. Jiří Činčura
https://ww
>Yes. When keyholder is configured in global configuration, a key is
>requested for any
> database, no matter if it is encrypted or not.
Weird, but I suppose there's a reason. Thanks.
--
Mgr. Jiří Činčura
https://www.tabsovers
ows. The keyholder plugin is D.
Sibiryakov's Callback plugin.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sd
Never mind. Found it now. For some reason it was not called before, but
clean rebuild fixed it.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
Hi *,
when is the `dispose` method of IExternalResultSetImpl called for
external engine called? As soon as all data is processed by the client
and `fetch` returns `false`?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com
More info:
https://www.tabsoverspaces.com/233624-ado-net-provider-5-9-1-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
>You may create one ;)
Done.
http://tracker.firebirdsql.org/browse/CORE-5540
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging t
>And it will be fixed soon
Can't wait for it. Is there a tracker item I can follow?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engag
d for now.
Not in general. I of course don't know that for every possible Firebird
server it will encouter.
>I have same opinion and looks like we discussing it now ;)
:)
--
Mgr. Jiří Činčura
https://www.tabsov
>Add "Providers=Engine12" to databases.conf for security database. It
>would be also good
> to add "ServerMode=Classic" for it, but with 3.0 it is impossible.
The server might not be under my control. I control only the app using
the embedded Firebird.
ible.
What's hard to comprehend to me is why embedded even doing *anything*
with the server. I would expect the embedded to be completely
independent.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant te
/ no relation with obj_type_MAX
const int obj_user_or_role = 34;
const int obj_schema= 35;
const int obj_parameter = 36;
Why the 20-32 isn't there?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com
repro is here
http://www.uschovna.cz/zasilka/MAMF5RKT9XYHSAL7-GDI/ . Just run test.bat
from cmd two times.
Any ideas what's wrong?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech
" DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN;
What's that? Why there's Win_Sspi?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites
More info:
https://www.tabsoverspaces.com/233620-ado-net-provider-5-9-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
course to have
these IDs and related data (to prevent FK violations). I can explain it
to you in better detail, probably rather outside the list.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out t
endpoint.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing
acches (there are other
requirements, I don't want to go into too much details). Being able to
start next transaction, basically, from the point where the previous
left would be so convenient and remove a lot of hacks we have in place
right now.
--
Mgr. Jiří Činčura
https://www.tabsoverspac
> once. If they all are started without any commit between them (which can
> be ensured by a
> number of different ways), they will give you completely the same view of
> data.
I'm listening. That would make my life lot easier in certain scenarios,
--
Mgr. Jiří Č
> In this case, it would be faster for both of us if you just sent some
> (non-buildable) relevant pieces of code for now and I try to reproduce
> with UDR or FB/Java.
Sent in private email, with attachments.
--
Mgr. Jiří Činčura
https://www.tabsovers
> It would be very good, specially if it works in Linux (.NET Core?).
.NET Core does not have a support for C++/CLI yet (if ever), so it's a
full .NET, thus Windows only. Would that work for you?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.
's a bug.
I can create some sample for you, if you want. Then you can drop in your
own fbclient.dll and attach debugger or something like that.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the
L_VARYING properly.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing
> I'm running it from Embedded now. I'll try tomorrow normal server.
> Shouldn't matter, but just in case.
Shouldn't, but does. Using server I get correct lengths, but using
embedded I always get 4*length (when using parameter, of course).
--
Mgr. Jiří Činčura
https://www.tabsoverspac
CHAR just received the relevant length.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-
ARYING
gets me only so far.
> This change from SQL_TEXT->SQL_VARYING will not work only in some old
> versions (maybe firsts 2.1.x or 2.0.x).
Fine for me, as external engine needs 3.0 anyway.
--
Mgr. Jiří Činčura
It's always going to be spaces/0s. I don't see a way for otherwise.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Tue, Apr 18, 2017, at 17:43, Dimitry Sibiryakov wrote:
> 18.04.2017 17:38, Jiří Činčura wrote:
> > So my best chance is probably to trim to length/4
.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web
at's kind of lame.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing
r
CHAR(20) UTF8, changed to SQL_VARYING, the length is 80. Which is kind
of confusing. :)
* You're reading it here:
https://github.com/asfernandes/node-firebird-driver-native/blob/master/src/lib/fb-util.ts#L135
.
--
Mgr. Jiří Činčura
https://www.tabsovers
ing to handle the length here. I don't know the real length of the
string, do I?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech si
> Yes, sure.
Should changing the type be enough? Because I changed it from
SQL_TYPE_DATE to SQL_TIMESTAMP, but I'm still getting length == 4, while
the timestamp should be 8, isn't it?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.
builder->getMetadata and using this new
metadata later in my IExternalProcedureImpl? In other words, is then the
data passed in "void* msg" i.e. to Procedure::open going to be in new
format?
--
Mgr. Jiří Činčura
https://www.tabso
Yes. It happens during database drop. But there's no other connection.
Which is kind of weird. It's during unit tests. I'll try to add there a
small delay. Maybe server needs a second to breathe.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Wed, Apr 5, 2017, at 23:18, Vlad
Hi *,
what the "object DATABASE is in use" signals? I understand when there's
table or trigger being used. But database?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech
confirmed.
:)
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web
More info:
https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
>Could you, please, test today's snapshot build of fb4 ? It contains
> fix for CORE-5416 which looks exactly as you describe above. Or wait
> for tomorrow's snapshot build of fb3 (i plan to backport the fix today).
OK, will try it tomorrow.
--
Mgr. Jiří Činč
a look? Or guess what I might try?
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird
implementation). That would be only server-side configuration (_maybe_
option for DPB), because I see it strictly as DBA safety mechanism.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one
> But, client side already can set it own timer and cancel the statement.
To add to what others said. Isn't this feature, also, about helping i.e.
DBA to keep bad queries slowing down the server (considering (s)he has
no control over the application's code itself)?
--
Mgr. Jiří Činč
a lot of rows,
just a few, but take a long time to process.
The fetching time included seems to be skewed by network latency,
application logic (do I fetch all at once into, i.e. array or process
one by one), although thinking about your implementation I see what you
aimed for.
--
Mgr.
Did you tried using some small streamlined distribution as a base?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org
> It's hard to say anything without a test case.
It happens randomly. Anything I should focus on to get a grasp? What
might trigger it?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant t
Anyone?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web
nts on client side.
> // For INET it's not necessary because INET client's async port
> // wakes up while server performs shutdown(socket) call on its async
> port.
Thanks. That makes it clear. :)
--
Mgr. Jiří Činčur
Hi *,
I'm looking at
https://github.com/FirebirdSQL/firebird/blob/master/src/remote/client/interface.cpp#L6007
and wondering whether the server can ever send op_exit/op_disconnect on
aux connection? Is that possible? And I can somehow do it (for testing)?
--
Mgr. Jiří Činčura
Independent
>I was not clear. You send op_cancel_events on main conneciton and
> you get response at the same main connection. If you expect close of
> secondary (aux) connection - no, it is closed with main one.
Thanks. That's what I see from my side as well.
--
Mgr. Jiří Činčura
In
Thanks guys. That will make my life easier, I suppose. :)
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer
>Yes, you should got usual op_response
I get a response on main connection, not on aux. There should be
something on aux as well?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for In
Hi *,
when I call op_disconnect on main connection (the one from which I got
the aux connection details), the aux connection is closed as well. Is
that how it should be?
--
Mgr. Jiří Činčura
Independent IT Specialist
Hi,
do I get some response on aux connection after op_cancel_events?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based
Any luck with this?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing
> What is the exact error message?
deadlock
Error while parsing procedure 's BLR
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon
Hi *,
On 2.5.6 I've got error %subj%. It does happen very very occasionally. Is the
something I can do to prevent it? Or what might be causing it?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access
More info:
http://blog.cincura.net/233588-ado-net-provider-5-7-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon
re efficient to
> send whole blob to client and map it's memory there to required
> predefined data structure (it may be array or even something more
> interesting). If one really needs to extract a part of that data on
> server I suppose use of UDR will be much more efficient.
Well written
More info:
http://blog.cincura.net/233580-ado-net-provider-5-6-0-0-for-firebird-is-ready-with-net-core-support/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Developer Access Program for Intel Xeon Phi Processors
> 1.add field with "default"
Which you can later remove.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slash
More info:
http://blog.cincura.net/233576-ado-net-provider-5-5-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging
TE STATEMENT is used, probably with autonomous
> transactions - it could block itself if used not correctly (for example:
> update record and then update it again in autonomus tx with "wait"
> option)
I'll check for that. It's a huge database, so it will take a while.
--
!7ffbe68a13d2()
ntdll.dll!7ffbe69f5454()
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> Unfortunately not. Certainly that can be fixed for fb4 and later but
Given you can count provider writers on one hand, I don't think it's
necessary. Either one does it correctly or keep trying (a lot of what I
do :)).
--
Mgr. Jiří Činčura
Independent IT Special
> Pay attention - _removes_. Does not matter was there something useful in
> CNCT or not.
OK, I missed that. I though it's like a merge of values.
Thanks.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Fi
> things. But for os user name - no, not ok.
Can you elaborate?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/fireb
on't know any matching CNCT, to be precise), so I would rather
keep it around one place in code.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.
I was thinking quite the opposite. Dropping the CNCT values. In DPB
there's more (like process ID etc.) so I thought I would logically
group it there.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel
Thanks. Not sure why I'm sending it in CNCT and DPB as too. Maybe some history
code.
Time to clean it up! :) And save few bytes.
--
Mgr. Jiří Činčura
Independent IT Specialist
> On 16 Sep 2016, at 18:12, Dmitry Yemanov <firebi...@yandex.ru> wrote:
>
> 16.09.2016 19:00, Jiř
Thanks. So I'll keep it around for a while, just in case somebody still uses
protocol 10.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
Ahh, no CNCT_login is overridden isc_dpb_user_name. So what's the
CNCT_user for?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists
Hi,
what exactly this flag controls? I can't see much explanation in
protocol.h.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists
Hi,
is the CNCT_user and CNCT_host visible for normal developer somewhere? I
suppose CNCT_user is overriden by isc_dpb_user_name, right? Similar with
CNCT_host and isc_dpb_host_name.
--
Mgr. Jiří Činčura
Independent IT Specialist
More info:
http://blog.cincura.net/233571-ado-net-provider-5-1-1-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
OK, kudos to Vlad, who reached to me and after some debugging spotted
the problem (CORE-5347). Alex was then able to fix it easily.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web
the server should handle it gracefully, IMO. I can set up the
machine in few minutes and then it's RDP accessible, if somebody want's
to see it in action with me.
Any help would be greatly appreciated.
--
Mgr. Jiří Činčura
Independent IT Specialist
stency was just confusing.
> (windows runs on intels) and moreover different implementations.
And ARM (and maybe Itanium, if we count old systems). But that doesn't
make a difference in this discussion.
--
Mgr. Jiří Činčura
Indepen
8 byte[] -> isc_dpb_specific_auth_data
Sspi: byte[] -> isc_dpb_specific_auth_data
That doesn't seem right to me. But it's the combination that works. Am I
doing it right?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-D
So where the client auth data should be sent? And which tag?
--
Mgr. Jiří Činčura
Independent IT Specialist
On Thu, Sep 1, 2016, at 14:57, Alex Peshkoff wrote:
> On 09/01/2016 01:39 PM, Jiří Činčura wrote:
> > Looks like I moved somewhere. In op_connect+op_accept I send as
&
"unavailable
database" depending on what magic I'm doing, while isql (or protocol 12)
gives me expected "Login name too long (33 characters, maximum allowed
31)".
Can anybody explain what should happen after op_accept_data in protocol
13 with SSPI? Something right there or later in
some overview?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>Use debug build of Firebird. May be some assertions will jump on you.
Tried that and no assertion. :(
When this happens, it always happens in op_execute phase. I send the
op_execute packet and then the connection is closed. I'm not using
compression, just in case.
--
Mgr. Jiří Činč
401 - 500 of 647 matches
Mail list logo