Yes, you definitely have a problem. Sooner of all some client code is
attached to the services manager and forgot to detach. Trace could help you to
identify that client application and what service it is used.
Regards,
Vlad
> I'm confused. I thought that read-only read-committed transactions did not
> consume transaction ids.
> By nature they don't need the protection of the transactional system. They
> don't make changes so
> there's no need to roll back. Nor is there any need to prevent others from
> reading t
> Another quick update. TIBBackupService does actually work, you just have to
> know that it does nasty things like this inside the ServerName setter method
>
> if (FProtocol = Local) and (FServerName <> '') then
> FProtocol := TCP
>
> I was updating the protocol to Local in the occas
> Hello Group,
> Is it possible to take a backup of a 2.5 database whilst it is running in
> embedded mode (Windows) and whilst that application is otherwise
> connected to the database using the services manager (just like you can on
> the full server)?
Sure
> I am presently getting an ex
> Why do you think you can't use just v2.5 client ?
>isn't supported from Zeoslib for Delphi 5 :(
Sounds crazy, sorry. Can you provide a reason for it ? Just curious...
> Choose any folder you like, put firebird.msg there and set environment
> variable
>FIREBIRD_MSG pointing to thi
---In firebird-support@yahoogroups.com, wrote:
> Hallo,
> I have a PC with two clients:
> - fbclient21.dll (I use ZeosLib + Delphi) for version 2.1 in windows\system
> - fbclient.dll for version 2.5 in windows\system
Why do you think you can't use just v2.5 client ?
> Both clients connect t
> From your earlier postings, I gather that in May 2013 nbackup failed to
> complete, so the main database file has been frozen for 8 months, and
> all the changes since May 2013 have accumulated in the delta.
This is too strong statement. To verify it we need to know physical backup
state o
---In firebird-support@{{emailDomain}}, wrote:
> I am building an application with the firebird 2.5 API. I keep getting the
> following errors at compile time. I am using VS 2005 on win 7.
...
> I have done extensive searching on the web for a solution to this.
> Near as I can tell, I am
---In firebird-support@{{emailDomain}}, wrote:
On 18 Dec 2013 13:14:07 -0800, mailto:hvlad@...> wrote:
>>> Besides the documented limitation that passwords are 8 characters
>>> (Firebird 3 will lift that limitation), the connection protocol is not
>>> encrypted meaning that people can sniff
---In firebird-support@yahoogroups.com, wrote:
> Besides the documented limitation that passwords are 8 characters
> (Firebird 3 will lift that limitation), the connection protocol is not
> encrypted meaning that people can sniff the traffic and determine the
> password.
Password is never
---In firebird-support@yahoogroups.com, wrote:
> My pagesize is 16k and pages cache is set to 65536. And this can not be that.
> I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value =
> 120637.
> Database have 6685 pages what is corelated with real db size = ~104MB
Oop
---In firebird-support@yahoogroups.com, wrote:
> In MON$IO_STATS - MON$PAGE_FETCHES field i see reads 120637 pages but my
> whole test database have only 6685 pages. > Is something wrong with counters
> when status of statement is 2 in field MON$STATE?
Your page cache is definitely less
---In firebird-support@yahoogroups.com, wrote:
> Is it possible to refer to internal structures by reference in PSQL?
No. It is not possible.
Regards,
Vlad
> Thank you for your help. I dont understand why sweep is not doing clean.
> I use Super Server 2.5. I try also to run sweep manually and it ends
> immediatelly without doing clean.
Make sure your database is not shutdown. Show us gstat -h output.
Regards,
Vlad
PS And consider to remove "r
---In firebird-support@yahoogroups.com,
wrote:
> For my tool, I like to determine which DDL event items are involved in a DDL
> trigger (FB 3.0).
...
> But how can I query from rdb$triggers (rdb$trigger_type field) whether
> 'CREATE TABLE' or 'ALTER CHARACTER SET' or any other DDL event is
Firebird itself doesn't access dependent tables if FK value was not changed
by UPDATE statement.
Do you have UPDATE triggers ?
Regards,
Vlad
> the indices are used, but only the server knows why he scans the whole table.
> > > SQL:
> DELETE FROM
> DETAIL
> WHERE
> ID=? /* ID */
>
> Execution Plan:
> PLAN (DETAIL INDEX (I_DETAILS_ID))
>
> Statement Statistics:
> Reads: 1,0 GB Inserts: 25 Indexed Reads: 25 > Writes: 180,0 KB U
Petri,
> When you are using File-Based Write Filter
Do you think all here knows what is "File-Based Write Filter" ? I found that
this is a feature of
Windows Embedded :
---
File-Based Write Filter (FBWF) enables redirection of all changes made to a
protected volume to an in-memory overl
> we use nbackup only
> my gstat accept no parameter -list
It was a typo, i mean gfix of course
> The transaction was cancelled after DB shutdown -> Firebird restart -> DB
> online. Then also sweep takes
> effect.
Then it was not a limbo transaction...
> BUT: Sinati
Do you have applications which used distributed transactions ? Such as
replication software.
Run gstat -list and show us results.
Regards,
Vlad
Make sure you are connecting to the 2.1 using fbclient from 2.1
FB 2.x and FB 1.x have different and not compatible implementations of local
protocol, therefore you should use correct client version
Regards,
Vlad
--- In firebird-support@yahoogroups.com, Huan Ruan wrote:
>
> >
> > The question is - do global temporary tables have performance advantages
> > over usual tables? And whether global temporary tables were designed with
> > optimization goal in mind at all? Maybe they have different goals?
> >
> I
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
>
> Hi Vlad,
>
> >> >> Can someone let me know if the following is thread-safe:
> >> >>
> >> >> - a client library from Firebird version 1, 1.5, 2 or 2.1
> >> >> - using a connection per thread
> >> >> - executing calls via multiple
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
>
> Hi Vlad,
>
> >> Can someone let me know if the following is thread-safe:
> >>
> >> - a client library from Firebird version 1, 1.5, 2 or 2.1
> >> - using a connection per thread
> >> - executing calls via multiple threads
> >
> >
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:
>
> Hi all,
>
> Can someone let me know if the following is thread-safe:
>
> - a client library from Firebird version 1, 1.5, 2 or 2.1
> - using a connection per thread
> - executing calls via multiple threads
Add also: protect a
--- In firebird-support@yahoogroups.com, "lem_ita_78" wrote:
...
> Is it possible to set something (a registry key, a config file, some other
> trick) to tell windows where to look for this dll?
Yes, use instreg utility
> Is it possible to move this dll to an other folder removing it from
>
--- In firebird-support@yahoogroups.com, Vitali Voroth wrote:
>
> Hi!
>
> I'm not sure if the following is a bug, so i try it here first before posting
> it to
> firebird-devel. Chances are that somebody on this list can help me.
>
> I am running the 64-bit version of Firebird 2.5.2 (26540) on
--- In firebird-support@yahoogroups.com, "stoneoldrock" wrote:
>
> Hi, all (and Vlad)
>
> I was here to ask help about BLOB, and it helped a lot.
>
> Now I have developed a function which can load multiple (different) files
> into multiple blob columns by INSERT or UPDATE with a single functio
--- In firebird-support@yahoogroups.com, "stoneoldrock" wrote:
...
> There is now NO more error message, for the function hangs inside the
> isc_dsql_execute_immediate(..) call, and NEVER gets out...
>
> any further suggestions?
Sooner of all you have not committed concurrent update or
--- In firebird-support@yahoogroups.com, "stoneoldrock" wrote:
>
> Hi, all
>
> I am coming into a XSQLDA problem, would anyone of you like to point out
> where is wrong in the following code?
...
>in_sqlda->sqlvar[0].sqldata = (char *) &blob_id;
>in_sqlda->sqlvar[0].sqltype = SQL_BL
--- In firebird-support@yahoogroups.com, "Fabiano Kureck" wrote:
>
> Hi!
>
>
>
> I must read the "Memory Buffers" parameter from the database using sql.
>
> I know that I can use gfix to change and gstat to read.
>
>
>
> I want to read it via a sql command. How do that?
In recent Firebi
--- In firebird-support@yahoogroups.com, Stefan Heymann wrote:
>
> Hello everybody,
>
> I had a strange effect on a customer's system today. We usually deploy
> our application with a minimal Firebird client. So the application
> folder contains
> MyApp.exeand
> fbclient.dll and
--- In firebird-support@yahoogroups.com, "un_spoken" wrote:
>
> I will provide one more test for firebird 2.5.2. I have a corrupted base, I
> will see what gfix says after running it. I think that it should return 1 as
> an error code. Or atleast error code <> 0.
>
You think wrong.
Comma
--- In firebird-support@yahoogroups.com, "certfb" wrote:
...
> *Oops*, please disregard the above, yes I do get an isc_info_svc_timeout,
> sorry and thank you for helping me track this down.
Good to know :)
Good luck with tracing,
Vlad
--- In firebird-support@yahoogroups.com, "certfb" wrote:
>
>
> > > The only problem that I have at the moment is that I am using the
> > > "isc_info_svc_timeout" command as part of a "isc_info_svc_line"
> > > isc_service_query() but instead of replying with "isc_info_svc_timeout"
> > > in the
--- In firebird-support@yahoogroups.com, "certfb" wrote:
>
> Hello list!
>
> I have implemented a very simple GUI version of the bundled trace tool
> fbtracemgr using wxWidgets.
>
> If anyone is interested I am more than happy to upload or send them the code.
>
> If I get the chance I will tr
--- In firebird-support@yahoogroups.com, Mike Ro wrote:
Mark,
since v2.5 it is possible to use Firebird embedded without install of full CS
package.
All you need is to create the almost the same folders layout as with full
Firebird package, including bin, intl, lib, plugin, UDF folders and it
--- In firebird-support@yahoogroups.com, "Rick Debay" wrote:
>
> Changing the catch block:
> WHEN /*GDSCODE unique_key_violation*/ ANY DO
> Allows us to work around the problem.
This is not a mine deal of course, but this is VERY BAD. Hiding exceptions is
a *very bad* practice. But this is you
--- In firebird-support@yahoogroups.com, "Rick Debay" wrote:
>
> I think it's a 1.5 bug, as executing the procedure from DBW also fails
"no current record for fetch" is well-known optimizer bug and in some form
exists even in latest Firebird versions. Usually it happens when one mixed two
ki
--- In firebird-support@yahoogroups.com, "certfb" wrote:
...
> Sorry I should have said that I am using CS 2.5.2 on Ubuntu 12.10.
It is still not clear which process handle database connection - your
application's embedded attachment or worker process of Firebird CS.
> I have set up fbtracemgr
--- In firebird-support@yahoogroups.com, "Rick Debay" wrote:
>
> Does anyone have any insight in to this?
>
> Running this statement in isql:
>
> EXECUTE PROCEDURE P_IMPORT;
>
> Yields this error:
>
> Statement failed, SQLCODE = -508
> no current record for fetch operation
> -violatio
--- In firebird-support@yahoogroups.com, "certfb" wrote:
>
> Hi,
>
> Sorry for the (possibly) silly question, but is it possible to use fbtracemgr
> with the embedded server?
Yes
> If so what should the 'connect' string look like, i.e. in...
>
> fbtracemgr -SE remote_host:service_mgr -USE
--- In firebird-support@yahoogroups.com, "Carlos H. Cantu" wrote:
>
> h> Don't use WNET connection strings, especially on Win7.
>
> I never use WNET, but I'm curious: why not?
And why yes ? :)
Not, because:
a) NetBEUI is deprecated by MS since WinXP (iirc)
b) it requires additional security
--- In firebird-support@yahoogroups.com, "Justin"wrote:
...
> Extract from C:\\ProgramData\IBPReplicator\Replicate.log:
>
> 02/23/13 10:48:39: *** Start Replication
>
> Replicate BOX3->BOX4, BOX3 -> BOX4
> 02/23/13 10:48:49: Connected to DB: \\BOX3\C:\Program
--- In firebird-support@yahoogroups.com, Jiri Cincura wrote:
>
> On Thu, Jan 31, 2013 at 11:15 AM, hvlad wrote:
> > Why do you omit first lines of trace configuration ?
>
> Yahoo did that. You can see it at http://pastebin.com/K2zV4KZx .
Strange, but anyway
> >
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær wrote:
> I use Fb 2.5
Wow ! Finally ! You are migrated from FB 1.5 ?
Congratulations !
Vlad
--- In firebird-support@yahoogroups.com, Jiri Cincura wrote:
>
> Just in case the trace configuration is:
>
> enabled true
> log_connections true
> connection_id 0
Why do you omit first lines of trace configuration ? I assume you use pattern
for database name. In this case, by the rules
--- In firebird-support@yahoogroups.com, "randallsell" wrote:
>
> Hello all,
>
> I recently upgraded FB from 2.1.5 to 2.5.1. In order to port data we
> essentially write the contents of the database to a file, then read it back
> in again. In short, this amounts to many thousands of INSERT sta
--- In firebird-support@yahoogroups.com, Jesus Garcia wrote:
>
> Two days ago, we moved from one server with interbase 2009 windows 2003 and
> 4 Gb RAM to Firebird 2.5.2 Superclassic, 16 Gb RAM
> The database is around 21 Gb, and yesterday seems all was running fine.
>
> Today, i have checked Fire
--- In firebird-support@yahoogroups.com, "anthonyjang2012" wrote:
>
> Vlad,
>
> We have emailed a link to download the mini-dump and lock-print.
Just answered to you privately.
> Please let us know if this is helps to resolve the issue
Sure.
Regards,
Vlad
--- In firebird-support@yahoogroups.com, "anthonyjang2012" wrote:
> The issue occurred again, but, unfortunately, we only obtained a full dump.
> The full dump is 8GB (1GB zipped). Would this be useful to send to you?
> Please let me know so that I can put it on an ftp site for you to download
> It might be worth to investigate this tradeoff, or just to provide an
> option to rebuild indices without using temporary sort spaces so others
> can measure it for themselves (or to have a workaround if disk space is
> not large enough to accommodate the rebuild).
You already can do it b
--- In firebird-support@yahoogroups.com, Alec Swan wrote:
> What can you expect if Firebird needs temporary disk space which isn't
> > available to create/activate an index?
> >
>
> I expect the statement to fail but but not corrupt the state of the
> database. Similarly to how a query with a lar
--- In firebird-support@yahoogroups.com, Alec Swan wrote:
> My main question is how can we calculate the temp sort space required
> to ALTER INDEX ACTIVE (on all indexes serially) given the size of the
> database? Is twice the size of the database a good upper bound?
Enumerate all fields in
--- In firebird-support@yahoogroups.com, "Michael Vilhelmsen" wrote:
>
> Ah - you are right :)
> Its the amount of start/commit I was referring to. My bad.
>
> Statistics are as of now:
>
> Database "E:\DB\OCCeasyPos.Fdb"
> Database header page information:
> Flags 0
>
--- In firebird-support@yahoogroups.com, Alec Swan wrote:
>
> Vlad, the large files have fb_sort prefix. But we also see a lot of small
> fb_lock files.
They could be left only if engine was not shutted down correctly.
fb_sort_XXX files left means application was crushed.
fb_lock_XXX f
--- In firebird-support@yahoogroups.com, Alec Swan wrote:
>
> Hello,
>
> Our customers are complaining that there are lots of (GBs) temp files
> written by Firebird in temp directory.
Does names of that files have common prefix ?
What OS (Windows, i guess)?
Regards,
Vlad
--- In firebird-support@yahoogroups.com, "anthonyjang2012" wrote:
>
> How do we take a memory dump from the fb_inet_server process?
There are a lot of tools to do it, starting from task manager (since vista),
userdump and process explorer (my favorite tool)
Regards,
Vlad
--- In firebird-support@yahoogroups.com, "anthonyjang2012" wrote:
>
> Environment : Firebird 2.5.1 Super-Classic x64 on Windows 2008 R2 Server with
> 32 GB of RAM
>
> We have a Firebird server installation that periodically blocks all
> operations for a few minutes and then comes back alive on i
--- In firebird-support@yahoogroups.com, Ray Holme wrote:
> I said it was C not C++ and I said that I use ibase.h and ib_util.h to
> define the two routines, but I should also say that my gcc compile line
> specifies "-DWIN32" so the functions would be declared
>
> extern void __stdcall isc_dec
--- In firebird-support@yahoogroups.com, "jankowalsky825" wrote:
>
> Hi guys.
>
> I've read whatever I could find about this problem. Suggestion is to create a
> proper indices and that should speed up the query but query optimizer do not
> take my indices into account and generates natural pl
> --here is a try using the lib files
>
> gcc -shared -o vetAdmin.dll udf.o fbclient_ms.lib ib_util_ms.lib
> -Wl,--export-all-symbols -Wl,--enable-auto-import
>
> udf.o:udf.c:(.text+0x1ce): undefined reference to `isc_decode_date@8'
> udf.o:udf.c:(.text+0x205): undefined reference to `ib_
--- In firebird-support@yahoogroups.com, "nathanelrick" wrote:
>
> OK, thanks...
>
> so it's confirm :
>
> 1/ try to avoid table with big number of fields (mostly try to make the size
> of a record (size used by all fields) more little as possible)
Nope. It is the same as if you going to avoi
--- In firebird-support@yahoogroups.com, "nathanelrick" wrote:
>
> > Just run this query and show us results:
> >
> > SELECT R.RDB$RELATION_NAME, COUNT(*)
> > FROM RDB$PAGES PG JOIN RDB$RELATIONS R
> > ON PG.RDB$RELATION_ID = R.RDB$RELATION_ID
> > WHERE PG.RDB$PAGE_TYPE = 4
> >AND R.R
--- In firebird-support@yahoogroups.com, "David Hollings" wrote:
...
> Conclusion:
>
> Baffled why a select (which could never possibly return a result) reads
> ~1150 pages from DESC_VARCHAR but only ~230 pages from DESC_EMPTY given that
> the two indices on IDOBJ columns are virtually identical
--- In firebird-support@yahoogroups.com, Marcin Bury wrote:
...
> File FreeUDFLib.dll is placed in UDF directory
...
> The new server version is: LI-V6.3.1.26351 Firebird 2.5 running on
> CentOS Linux...
>
> Any clues?
dll on Linux, oh man...
Regards,
Vlad
--- In firebird-support@yahoogroups.com, Ann Harrison wrote:
> Trust the right side, Luke. Maybe someone has fixed this in a more
> recent version of Firebird, but it's a
> characteristic bug of databases that Jim Starkey writes. Unless
> there's a sort (e.g. order by, distinct,
> grouped) they
--- In firebird-support@yahoogroups.com, "kittikira" wrote:
>
> Hello,
>
> I allready postet this to the firebird tracker, but did not get any
> response from there. For it is an urgent problem, I hope I find some
> help here.
What is the ticket number ?
Regards,
Vlad
--- In firebird-support@yahoogroups.com, "Michael Vilhelmsen"
wrote:
>
>
> The log file contains 42.609.189 lines.
> around 41.000.000 og those are this
>
> DBSRV02 (Server) Sat Nov 19 12:46:06 2011
> INET/inet_error: accept errno = 10038
>
>
> DBSRV02 (Server) Sat Nov 19 12
--- In firebird-support@yahoogroups.com, "samcarleton" wrote:
>
>
>
> --- In firebird-support@yahoogroups.com, "fernnaj" wrote:
> >
> > Hello,
> >
> > I had the same question time ago, and I posted at MS Forums - please have a
> > look at my post at
> > http://social.microsoft.com/Forums/en
--- In firebird-support@yahoogroups.com, "cruvadom" wrote:
>
> Hi all,
> I have a IBExpert client querying Firebird 2.5 server via tcp/ip over WAN.
> I'm making a simple query on the client side for an indexed table containing
> 2 columns and 4 rows (very small).
> overall time until data is sh
Jesus and Karol,
it is better to go to fb-devel with this subject, i think.
Regards,
Vlad
--- In firebird-support@yahoogroups.com, "a.casati" wrote:
>
> Hello. I did a gbak of a 2.1.4 DB.
> One field is a varchar(128) with default value '%t n° %n del %d'.
> I get an error restoring it with 2.5.0: "Invalid metadata detected".
> Is it caused by the "%" character? How can I resolve this is
--- In firebird-support@yahoogroups.com, Jesus Garcia wrote:
>
> Hello, is normal to crash the engine whe an exception is raised inside a udf
> dll or must be catch by the engine?
Any kind of exception *must* be handled inside UDF.
> I had a udf with the function power. If i call power with
--- In firebird-support@yahoogroups.com, Nols Smit wrote:
> Now I wondered if it's possible to have one block of executable SQL?
It depends on what do you call as "one block of executable SQL".
Regards,
Vlad
--- In firebird-support@yahoogroups.com, Nols Smit wrote:
>
> Hi,
>
>
> Is it possible to merge results of a recursive CTE with the results of a
> non-recursive CTE?
>
> I seems one can not have one executable block of SQL containing both.
>
> Typically I use a non-recursive CTE to filter data
--- In firebird-support@yahoogroups.com, Nick Upson wrote:
>
> ISC_kill: process 17382 couldn't deliver signal 16 to process 17918:
> permission denied
>
>
> running 2.1.4 CS on Centos, anyone understand it?
You have few engine processes running by different users. For example,
regular wor
--- In firebird-support@yahoogroups.com, Iwan Cahyadi Sugeng wrote:
>
> Hmm interesting info helen, so the embeded server will work mostly like the
> super server.
No ! Embedded in v2.5 is based on SuperClassic architecture.
> so what is the performance impact by using embeded server this
> way
--- In firebird-support@yahoogroups.com, Helen Borrie wrote:
...
> Actually, with v.2.5, you can separate the embedded Firebird components from
> the application components when you deploy. If you wish to have the three
> applications all use the same Firebird components, you can do so with 2.5,
79 matches
Mail list logo