I just started getting these errors in Firebird.log. The first error is always
followed by the second. It appears to always be the same database. What might
be causing this? I am using Firebird 2.5.3.26778.
NOVADB (Server) Mon Nov 11 19:17:03 2019
Operating system call ReleaseSemaphore
>Well, if your application uses UTF8, then probably yes, but if you only
>need a region specific character set, then using that character set
>could be good enough: specifying a connection character set other than
>NONE will automatically transliterate between character sets.
>We can't judge
I am using Firebird-2.5.3.26778_0_Win32 on Windows 8.1 64-bit.
When attempting to restore a database using the restore method of the service
API (via IBExpert if that matters) I am getting the following error:
gbak:restoring privilege for user PUBLIC
IBE: Invalid insert or update
More information. When using gbak I get a slightly different error:
gbak: ERROR:attempt to store duplicate value (visible to active transactions)
in
unique index RDB$INDEX_39
gbak: ERROR:Problematic key value is (RDB$ROLE_NAME = 'RDB$ADMIN')
gbak:Exiting before completion due to
Yes, I am using the sysdba user ID.
That might very well be it. I might have inadvertently used gbak 2.1 to back up
the database.
Thank You
Assuming OPS_ONBOARD_TIME, OPS_DELIVERED_TIME and OPS_APPT_LOW are all DATE
type,does this solve that problem?
COALESCE(OPS_ONBOARD_TIME, OPS_DELIVERED_TIME, OPS_APPT_LOW, CURRENT_DATE)
Since they are all TIMESTAMPS, that didn't fix the problem but
CURRENT_TIMESTAMP did.
Thanks.
SET;
That's slick. I'm going to have to read up on the WITH command.
Had to change the coalesce with all the dates to cast each date individually
or I got a conversion error. Not sure why.
COALESCE(CAST(OPS_ONBOARD_TIME AS DATE), CAST(OPS_DELIVERED_TIME AS DATE),
CAST(OPS_APPT_LOW AS
The following query:
SELECT PB_LOAD_TYPE,
/* If already picked up use the pick up date.
If already delivered us the delivered date.
If appointment date present, use it.
Otherwise, use today's date */
IIF(OPS_ONBOARD_TIME IS NOT NULL,
Thanks to everyone for all the feedback.
if (param IS SIMILAR '[0-9]+') then
Did everything I needed it to do.
Thanks again.
Is there any way, within a stored procedure, to test a VARCHAR to see if it
contains a valid number? I have a parameter that can contain different types of
value and it would be nice to be able to know if CAST(param as BIGINT) is going
to fail before an exception is thrown.
That worked great! Thank you!
I need to be able to revert an existing 2.1 database to 2.0.5. How can I
accomplish this. GBAK won't do it. It tells me:
ERROR: Expected backup version 1,2,3,4,5,6 or 7. Found 8.
Have you checked the database with gfix?
No, I haven't. What options would you suggest?
Did a gfix -v -f -n and no problems were reported.
I have just migrated a system from Firebird 1.5 to 2.0.7.13318 running on
Windows 2008 R2. I backed up the data using gbak on 1.5. and reloaded it using
gbak on 2.0.7. Now on 2.0.7 I am being plagued by:
Attempt to call GlobalRWLock::unlock() while not holding a valid lock for
logical owner
The code is a bit involved because it supports multiple versions of Firebird
and multiple OSes. However, the windows version calls this function to get the
buffer returned by FREE_IT:
static char *
GetResultBfr (int len)
{
return ((char *) ib_util_malloc (len));
}
My DLL is linked
This past weekend I tried to upgrade a site from 2.0.5 to 2.0.7. This failed
miserably.
Firstly, no sooner did I get more than 1 user logged into the database I
started getting errors:
internal gds software consistency check (Attempt to call
GlobalRWLock::unlock() while not holding a
I have a UDF DLL that has been running for years. I recently tried to upgrade a
site from FB 2.0 to FB 2.5.3.26778. Everything went well until I tried to start
my application. Then I got a pointer returned by FREE_IT not allocated by
ib_util_malloc. The thing is, all memory returned by FREE_IT
19 matches
Mail list logo