following through this thread and I agree it is a programming error
causing a waste of resources. But I am confused as to why this is a
problem for Firebird. I thought that lots of short transactions was
actually something to be encouraged over long running transactions. Is
there some limit
60 transactions / day, uniformly distributed means ~ 7 transactions
per second, which is nothing. I'm sure you don't have that pattern in
production, thus e.g. the most busy hour in respect to transaction
throughput might be interesting.
I know 7 transactions seconds and peaks of 20/30
Hi, thank you.
I plan on using my own system administrative account - hence not the
default SYSDBA account.
I will connect to security2.fdb to locate the users table and will post
If I have trouble.
Regards
Danie van Eeden
On 7/10/2012 7:54 AM, Thomas Steinmaurer wrote:
I'm new to Firebird
Now that I have a list of different questions all going in different
directions I need to start over.
I took several databases that were backed up from IB v6 and 2007. Before
backing them up I removed ownership of the tables RDB$OWNER_NAME = NULL.
This I learned to do when transferring
2012/7/10 Danie van Eeden vaneeden.da...@gmail.com
**
I will connect to security2.fdb to locate the users table and will post
If I have trouble
I think you can't connect no more to security2.fdb with firebird 2.5. You
will have to get users trough API.
Regards, Jesus
[Non-text portions
Hi
I am trying to write a PHP script to create a new Firebird user but when
I run the code I get the following:
Service DB - Could not connect: Cannot attach to services manager
service var/lib/firebird/2.5/data/grip.fdb:service_mgr is not defined
I am running Firebird 2.5 on Ubuntu.
This is the
Seems that the rich text editor doesn't work and has stripped out all the
formatting so here is the error message and code again:
*
Service DB - Could not connect: Cannot attach to services manager service
var/lib/firebird/2.5/data/grip.fdb:service_mgr is not defined
the SQL statement that containing the error is
-
select L_ID, AC_ID, AC_ENAME
,AC_ANAME , DOCNO, REF,
ENTRY_ID,
Seems that the rich text editor doesn't work and has stripped out all the
formatting so here is the error message and code again:
*
Service DB - Could not connect: Cannot attach to services manager service
var/lib/firebird/2.5/data/grip.fdb:service_mgr is not
Thomas
That is the error message you are referring to, the call is:
---
if (($service = ibase_service_attach($host, $username, $password)) == FALSE) {
---
the host is defined as:
---
$host =
grip_2ls wrote:
*
Service DB - Could not connect: Cannot attach to services manager service
var/lib/firebird/2.5/data/grip.fdb:service_mgr is not defined
*
// connect to the service database
if (($service = ibase_service_attach($host,
I have 20+ databases in production, most of them between 3 and 8GB with no
BLOBs. My problem seems to be that sweeping is not executing when I either
perform a full backup or doing full table scans. Below is the gstat header
info and as you can clearly see that it should have kicked in long
What Firebird release/version # and version of the engine (Classic,
SuperServer, SuperClassic or Embedded) are you trying to access?
I think your question might be part of the problem. I am not trying to
access an engine. The word access to me talks about network connection.
I am using the
Neil,
That is the error message you are referring to, the call is:
---
if (($service = ibase_service_attach($host, $username, $password)) ==
FALSE) {
---
the host is defined as:
---
$host =
Hello, fdt4y!
Tuesday, July 10, 2012, 1:31:23 PM, you wrote:
f What are we overlooking? Our only current solution is to do a
f full backup and restore at silly morning hours, otherwise the system grows
terribly slow
f due to garbage not being collected.
f Oldest transaction
I have 20+ databases in production, most of them between 3 and 8GB with no
BLOBs. My problem seems to be that
sweeping is not executing when I either perform a full backup or doing full
table scans. Below is the gstat
header info and as you can clearly see that it should have kicked in long
Lester/Thomas
Thanks for your help - you are right as soon as I took out the db name it
worked!
Thanks again
Neil
--- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote:
grip_2ls wrote:
*
Service DB - Could not connect: Cannot attach to
grip_2ls wrote:
Thanks for your help - you are right as soon as I took out the db name it
worked!
There is also a list for firebird/php support ...
http://groups.yahoo.com/group/firebird-php/
--
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
Add those users to the firebird group, or make sure all those programs use
the service manager or tcp/ip connection to attach to the database. The
problem is now that they try to access the database as a local database
(which AFAIK means it behaves as a privately owned classic server
Thank you very much for your responses - this makes sense. We have a couple of
server side applications that run constantly. Although, they should all be
closing their connections. We will investigate further.
Could this somehow be related to the .NET driver with connection pooling? The
one
Hello,
Thank you very much for your responses - this makes sense. We have a couple
of server side applications that run constantly. Although, they should all
be closing their connections. We will investigate further.
Could this somehow be related to the .NET driver with connection
Thank you very much for your responses - this makes sense. We have a couple of
server side applications that run
constantly. Although, they should all be closing their connections. We will
investigate further.
Could this somehow be related to the .NET driver with connection pooling? The
one
Again, thank you guys - I've found the issue in a application that started a
read-only transaction to update some labels on a form and keeping the OAT
stuck.
With my luck, I closed the app and froze the poor server, now trying to sweep 7
days worth of transactions from all other tables... ouch
Again, thank you guys - I've found the issue in a application that started a
read-only transaction to update some labels on a form and keeping the OAT
stuck.
With my luck, I closed the app and froze the poor server, now trying to sweep
7 days worth of transactions from all other tables...
I tried firebird classic server 2.0. All the programs work just fine;
qli, isql and gbak. Unfortunately, this means we will not be able to
advance to any newer version of firebird. Unless somebody can explain
what needs to be done to get normal access to database files.
Hello,
I thank you for the reply. Please forgive my limited understanding of Firebird
DB thus far. I understand that security2 is the replacement for the previous
security.fbd and that now I cannot connect to it (even with DBAdmin).
You mentioned using the API. COuld you perhaps direct me to
Isn't it possible to write one SQL procedure
for all the 'Rules'. Should be much faster
than shipping data from the database,
apply some 'Rule' and shipping it back
to the database. If anything fails in
the SQL procedure or a data error was
detected by some 'Rule' and exception
rolls everything
Hello, fdt4y!
Tuesday, July 10, 2012, 7:17:56 PM, you wrote:
f After some more investigation I found that our main user interface
f client app starts a single long running read transaction used to pull data
for
f display in its grids. All updates are executed in small/short
f 'write'
the SQL statement that containing the error is
Reformatted by me (it was almost unreadable) and slightly modified (no need to
cast nulls)
-
select L_ID, AC_ID, AC_ENAME, AC_ANAME, DOCNO, REF, ENTRY_ID, JV, A_DESC,
E_DESC,
At 12:29 AM 11/07/2012, dve83 wrote:
Hello,
I thank you for the reply. Please forgive my limited understanding of Firebird
DB thus far. I understand that security2 is the replacement for the previous
security.fbd and that now I cannot connect to it (even with DBAdmin).
You mentioned using the
Thank you for the advice, currently our read only transactions are not true
read only, they contain the write parameter - I will try to change them
tonight (should be possible)
More importantly then are you saying that truly read-only transactions are
not counted as interesting active
Hello All,
How do I get my database current time zone?
I need it in order to calculate database current UTC time.
Thank you,
-Halim
Halim,
Hello All,
How do I get my database current time zone?
I need it in order to calculate database current UTC time.
The database engine doesn't have native functions for this purpose but you
could build* a UDF which would provide these details.
Sean
* There are UDF libraries which
33 matches
Mail list logo