[firebird-support] lock conflict on no wait transaction - finding the user

2012-02-06 Thread Marius Labuschagne
Hi, Is there something I can do to find out which user is locking a particular record in a database? If I can use the transaction number to lookup the user, then I may be able to simply ask that user to re-start his machine? The server is running Firebird Superserver 2.1.4 on Windows. I am tryin

Re: [firebird-support] time for 1600000 select

2012-02-06 Thread Fulvio Senore
Il 06/02/2012 18.17, pluto.pippo66 ha scritto: > Hi all > > I have aproblem with select fuction > > this is my function in C : > > the problem is 11 minuti for 160 select > > do you think is the right time ? > You should speed up things by executing all the selects in a single transaction.

Re: [firebird-support] time for 1600000 select

2012-02-06 Thread Mark Rotteveel
On 6-2-2012 18:17, pluto.pippo66 wrote: > the problem is 11 minuti for 160 select > > do you think is the right time ? What do you mean? Executing 1.6 million selects takes 11 minutes, or one select producing 1.6 million rows takes 11 minutes? If the first case, I don't think it is that wei

[firebird-support] time for 1600000 select

2012-02-06 Thread pluto.pippo66
Hi all I have aproblem with select fuction this is my function in C : int ReadValDbase(ISC_STATUS_ARRAY status,char* namedb,char* selstr,char* value) { charempdb[128]; char__Ex_value[128]; SQL_VARCHAR(20) fi

Re: [firebird-support] Re: sweep is running for more than 7 days now :(

2012-02-06 Thread Dmitry Kuzmenko
Hello, nathanelrick! Monday, February 6, 2012, 5:38:42 PM, you wrote: n> by kill mean n> NET STOP "Firebird Server - DefaultInstance" If this is Classic, you will just stop "listener" process, and it will not stop sweeping. Maybe you have some fb_inet_server process that "locks" sweeping. If t

Re: [firebird-support] Re: selecting between dates with timestamps fields

2012-02-06 Thread Matthias Hanft
Svein Erling Tysvær wrote: > > you can miss some records from the last second (let's say 02-01-2012 > 23:59:59.1234). How "exact" is a Firebird timestamp at all, and could I use fractions of a second in a query? For example where MyTimeStamp between '02-01-2012 00:00:00.' and '03-01-2012 23:5

[firebird-support] Re: sweep is running for more than 7 days now :(

2012-02-06 Thread nathanelrick
by kill mean NET STOP "Firebird Server - DefaultInstance" this is not safe too do to this during a sweep ? --- In firebird-support@yahoogroups.com, Alexey Kovyazin wrote: > > Hello, > > No, this is not normal. > No, it's not safe to kill fb_inet_server (though I think you'll have no > choice)

[firebird-support] How reliable is the event feature of Firebird

2012-02-06 Thread ik
Hello, I have a project that I'm doing, and it must have some sort of message queue when data is added/changed. I do not require heavy SQL work, but working with data both as a daemon and on the web. The daemon use the information that the web provides. But instead of constantly checking for addi

Re: [firebird-support] sweep is running for more than 7 days now :(

2012-02-06 Thread Alexey Kovyazin
Hello, No, this is not normal. No, it's not safe to kill fb_inet_server (though I think you'll have no choice) - especially in old Firebird versions. I would say you can have database corruption. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) > > Hello, > > Is it normal that the gfix -sweep

[firebird-support] sweep is running for more than 7 days now :(

2012-02-06 Thread nathanelrick
Hello, Is it normal that the gfix -sweep run for more than 7 days ? our database is pretty big (+300 Go) but 7 days it is not too much ? Also, during this sweep, is it "safe" to kill the gfix or better to shunt down the Firebird service of the fb_inet_server.exe ?

[firebird-support] Re: selecting between dates with timestamps fields

2012-02-06 Thread tomsee7
--- In firebird-support@yahoogroups.com, "Sergio H. Gonzalez" wrote: > > Hello! I have a timestamp field with an index > > how can I select the fields from a given date, but using the index? > > If I do: > > where > ((cast (MyTimeStamp as date)) between :from_date and :to_date) > > I gues

RE: [firebird-support] Re: selecting between dates with timestamps fields

2012-02-06 Thread Svein Erling Tysvær
>> I'm trying with (to get all records from Feb 2nd) >> >> where >> (MyTimeStamp between '02-01-2012 00:00:00' and '02-01-2012 >> 23:59:59') >> >> it uses the index, but I don't get all the records > >My mistake!... that seems to work OK... Now I just wonder if that is the > *best* way to do

Re: [firebird-support] Re: Using fbtracemgr

2012-02-06 Thread Thomas Steinmaurer
> For this test I'm using FlameRobin, but I have now also tried using the > applicaton. I have tried with an alias and with a direct local path: > D:\Passfield System\UAT Data\WHOLESALE_UAT.FDB The database filter in the tag evaluates to a regular expression filter using the new 2.5 SIMILAR TO

[firebird-support] Re: Using fbtracemgr

2012-02-06 Thread russ3ell
I've now tried removing the specific database and so just have ...

[firebird-support] Re: Using fbtracemgr

2012-02-06 Thread russ3ell
For this test I'm using FlameRobin, but I have now also tried using the applicaton. I have tried with an alias and with a direct local path: D:\Passfield System\UAT Data\WHOLESALE_UAT.FDB

Re: [firebird-support] Re: Using fbtracemgr

2012-02-06 Thread Thomas Steinmaurer
> Just noticed, the database name is wholesale_uk.fdb Make sure that you are using the correct database filter in the tag then. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ http://www.firebirdsql.org/en/firebird-foundation/