Strange stuff from firebird I am hoping to get some insight on...please bear
with me while I describe the problem!
I've run into a problem with a firebird installation that is using a 3rd party
report viewer to display crystal reports from a firebird db on client
PCs...this is a windows
Hello Bob,
1): The most obvious thing according to the header page is a very
large
gap between the oldest active transaction and the next transaction.
This
means, you have a long-running/stuck transaction. If you are lucky,
you
can go into the MON$TRANSACTIONS table and check out if you
Hello,
Strange stuff from firebird I am hoping to get some insight on...please bear
with me while I describe the problem!
I've run into a problem with a firebird installation that is using a 3rd
party report viewer to display crystal reports from a firebird db on client
PCs...this is a
On 2012-09-17 16:23, Thomas Steinmaurer wrote:
Look here:
http://www.firebirdnews.org/?p=5027
Yep, that looks exactly like my case. Unfortunately, I'm not able to
re-create users by hand because of the scale of the problem (and because
I don't know their passwords, and resetting them means me
On 2012-09-17 16:23, Thomas Steinmaurer wrote:
Look here:
http://www.firebirdnews.org/?p=5027
Yep, that looks exactly like my case. Unfortunately, I'm not able to
re-create users by hand because of the scale of the problem (and because
I don't know their passwords, and resetting them means
Yep, that looks exactly like my case. Unfortunately, I'm not able to re-create
users by hand because of the scale of the problem (and because I don't
know their passwords, and resetting them means me looking for another job
;) ).
You can pump the data to another database shell without
Hello Bob,
Is there any way to tell if the sweep was successful other than all of
the markers matching? Is there any way to tell why a sweep would have
failed?
No. You should manually check transactions' markers difference, or use
tool like FBDataGuard which can check it in desired time
Alan,
I've already tried that. I described it in my previous post. The problem
is the password ciphers seem too long compared to the RDB$PASS data
type. I could try to change the type of RDB$PASS, but I don't know if
it's safe to mess with the domains in security DB.
Tomasz
On 2012-09-18
I am running firebird 2.5.1 super-classic on ubuntu server 12.04
Firebird/linux AMD64 (access method), version LI-V2.5.1.26351 Firebird 2.5
on disk structure version 11.1
The problem I am experiencing is that Firebird randomly hangs every
couple of days, I need to do a service restart to get it
On Tue, 18 Sep 2012 09:16:30 +0100, Tomasz Tyrakowski
t.tyrakow...@sol-system.pl wrote:
Thomas,
On 2012-09-18 08:47, Thomas Steinmaurer wrote:
Neither do I. There's only the standard pre-2.0-to-2.0 security
upgrade
script. If there is such script available and someone could post a
link
to
On 2012-09-18 08:47, Thomas Steinmaurer wrote:
Neither do I. There's only the standard pre-2.0-to-2.0 security upgrade
script. If there is such script available and someone could post a link
to it, please please do.
If you are brave, you could go into firebird-devel with that. ;-)
I'll
On 2012-09-18 09:39, Mark Rotteveel wrote:
could you spend half a minute and look into your security2.fdb to check
if your varchar(64) RDB$USERS.RDB$PASS field also contains 80-character
long ciphers?
That's kind of intriguing, isn't it?
What is your connection characterset? What happens if
On 2012-09-18 08:50, Alan McDonald wrote:
You can pump the data to another database shell without touching or knowing
the passwords
Alan
I'm not quite sure the data itself is valid (and whether pumping it to
another database will fix the problem). I suspect there might be
something wrong
On 2012-09-18 08:47, Thomas Steinmaurer wrote:
If you are brave, you could go into firebird-devel with that. ;-)
Just got an answer on firebird-devel. I'll try the solution proposed by
Dmitry Yemanov and post a summary in the afternoon.
regards
Tomasz
--
Problem solved, thanks to Thomas Steinmaurer and Dmitry Yemanov.
Here's what to do when you experience problems regarding users with
elevated privileges not being able to alter other users via SQL.
1. Disconnect all clients from Firebird.
2. Copy security2.fdb to another location.
3. Connect to
Thanks for posting the summary, Tomasz. Excellent job of sleuthing!
I'm glad you figured it out in the end.
Doug C.
Alexey
From: Alexey Kovyazin [mailto:a...@ib-aid.com]
Is there any way to tell if the sweep was successful other than
all of the markers
matching? Is there any way to tell why a sweep would have failed?
No. You should manually check transactions' markers difference, or
Hello Bob,
Is there any way to tell if the sweep was successful other than
all of the markers
matching? Is there any way to tell why a sweep would have failed?
No. You should manually check transactions' markers difference, or use
tool like FBDataGuard which can check it in desired
Here's a related question for you - as I looked at our script for
doing nightly backups, I see a note that says:
do not use garbage collection (gbak -g) since we run a manual sweep
every night
Do you know if that's true - we don't need to do garbage collection
via gbak if we are running gfix
Here's a related question for you - as I looked at our script for
doing nightly backups, I see a note that says:
do not use garbage collection (gbak -g) since we run a manual sweep
every night
Do you know if that's true - we don't need to do garbage collection
via gbak if we are running
Hello there,
the problem persists. WTF is this?
- doing a GBAK backup shows NO ERRORS!
- GFIX shows NO ERRORS!
- FBFirstAid shows NO ERRORS!
- validating the Database via IBExpert shows NO ERRORS!
- the Database is working fine!
- there are NO duplicated Values in that RDB$COLLATIONS Table (i
Thanks for the reply and I wouldn't consider my self an expert with databases.
I have worked on teams responsible for database design and have done some small
to somewhat complex queries, triggers and such. My recomendation to the client
is that they store all of there data in a centralized
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Here's a related question for you - as I looked at our script for
v doing nightly backups, I see a note that says:
do not use garbage collection (gbak -g) since we run a manual
We are having an issue with caching when using Firebird 2.5.1 on a Windows
Server 2008 box. The system flies when turning forced writes off, but we don't
want to operate that way.
The strange thing is that we have a number of clients using 2.5.1 on Windows
Server 2008 and nobody has brought
The database is bigger than the RAM memory?
If yes this is an issue of 2.5.1
You do not need a backup/restore cycle for migrating to 2.5.2
Fabiano
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de todderamaa
Enviada em: terça-feira, 18 de setembro
18.09.2012 19:21, todderamaa wrote:
Do we need to backup on 2.5.1 and restore to 2.5.2?
In this particular case, you do need backup/restore.
Dmitry
Do we need to backup on 2.5.1 and restore to 2.5.2?
In this particular case, you do need backup/restore.
Dmitry
__._,_._
I´m curious Dmitry, why?
__
[Non-text portions of this message have been removed]
Finished backing up and restoring. Same issue with 2.5.2. You can hear the
server writing to disk constantly when running the software.
As I mentioned, we have a number of installations (approx 60) of the same
database and software and no complaints from other clients about performance.
We
I have a guess!
What is the database Server? Is a truly *Dell* server? (Like Dell PowerEdge
T410)
If yes, make sure the hardware that control the HD HAS cache!
If it doesn´t have the problem is it!
To solve that replace the disk controller or use another server
[Non-text portions of
It is a Dell Server (Power Edge T110).
How can I tell if the hardware that controls the HD has cache?
Todd
--- In firebird-support@yahoogroups.com, Fabiano fabianoaspro@... wrote:
I have a guess!
What is the database Server? Is a truly *Dell* server? (Like Dell PowerEdge
T410)
If yes,
Maybe you can go to the Dell website and check this.
In Portuguese is controladora SAS6/IR (suporta apenas RAID 0 e 1), sem
cachê).
Or SAS6/IR controller with no cache.
Maybe you can call them and check this (sorry I have no internet connection)
De: firebird-support@yahoogroups.com
I believe this is the problem.
We found the setting when looking at the Device Manager. The 'enable write
caching' is turned off. It won't allow us to turn it on. I am guess the
hardware doesn't allow it.
In the Windows Help it mentions that turning it on can cause issues with
corruption.
In our test we can turn on but there are no result in terms of performance.
Is a hardware issue.
I think changing the disk controller and turning write caching on does not
have any problem is the default installation on Windows!
De: firebird-support@yahoogroups.com
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Here's a related question for you - as I looked at our script for
v doing nightly backups, I see a note that says:
do not use garbage collection (gbak -g) since we run a
Do we need to backup on 2.5.1 and restore to 2.5.2?
In this particular case, you do need backup/restore.
Dmitry
__._,_._
I´m curious Dmitry, why?
From the 2.5.2 RC1 release notes.
Warning re Databases Created or Restored under Firebird 2.5.1
All users upgrading from Firebird 2.5.1 to a
I use zedebee with internet conection, bandwitdh drop only take 20% from direct
connection, but it take processor time to compress and encrypt
Terima Kasih
Yanto Asnawi
087808244204
Pin BB : 2687C905
+whatsapp
-Original Message-
From: Kjell Rilbe kjell.ri...@datadia.se
Sender:
Hi all!
Today it seems easier and simpler for me to create all character fields encoded
in UTF8.
Is there something against doing this?
I asked some days ago about index sizes in this post
(http://tech.groups.yahoo.com/group/firebird-support/message/119234), and it
seems UTF8 can generate
Carlos,
Is it possible to combine a Foreign Key + a Unique Constraint to avoid
duplicate index ?
ALTER TABLE SVCs_BatchADD
CONSTRAINT RF_SVCs_Batch2XDRs_Batch
FOREIGN KEY (Id_XDRs_Batch) REFERENCES XDRs_Batch(Id_XDRs_Batch)
using *UNIQUE* index FK_SVCs_Batch_XDRs_BATCH;
this is not
38 matches
Mail list logo