Hi to all
Server: Firebird 2.5.4.
I have following stored procedure:
ALTER PROCEDURE TEST_ (
I SMALLINT)
RETURNS (
SUMA NUMERIC(15,2),
A NUMERIC(15,2),
B NUMERIC(15,2),
C INTEGER,
D VARCHAR(10),
E VARCHAR(10))
AS
begin
for select sum(t.a) - sum(t
Hi All
If possible at all, how can I trace which workstation (Firebird Client) is
holding a record hostage and thus causing a deadlock conflict?
Regards
Stef van der Merwe
email s...@autotech.co.za
[Non-text portions of this message have been removed]
Hi,
Probably you mean Lock conflict, not a true deadlock (full error text
will help).
If you see transaction number in the message, you can track it using
MON$ tables, and then find out which connection has started it.
Regards,
Alexey Kovyazin
IBSurgeon
Hi All
If possible at all, how can
Hi all I experience the same problem.
Is there a tutorial to track theese kind of problems?
tks
Razvan
Hello Ann
Well, that was not the case, because without the word CONSTRAINT has failed
and with that word has worked fine and I was the only user of the database
at that moment.
But no problem, I know the solution: always use the word CONSTRAINT.
Greetings.
Walter.
On Sun, Aug 23, 2015 at 12
Hello Karol
No, I don't have a backup previous to add the Primary Key then I can use
for reproduce the problem.
Using ISQL, one time I try to add the Primary Key without using the word
CONSTRAINT, seconds later I try again but using the word CONSTRAINT. The
first time had failed, the second time
Hi,
Please provide full error text and detailed description of the problem.
Regards,
Alexey Kovyazin
IBSurgeon
Hi all
I experience the same problem.
Is there a tutorial to track theese kind of problems?
tks
Razvan
As far as I can tell it sorts as it should. What sort are you expecting?
Mark
- Reply message -
Van: "'Bogdan' bog...@mordicom.si [firebird-support]"
Aan:
Onderwerp: [firebird-support] Error in order by clause
Datum: ma, aug. 24, 2015 10:37
Hi to all Server: Firebird 2.5.4. I have f
Hi,
what about drop this PK
do backup restore and try again?
P.S.
If you previously name some constraint as INTEG... then conflict with name can
appear
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015 5:00 PM
To: firebird-support@yahoog
On 21/08/15 14:17, 'Bogdan' bog...@mordicom.si [firebird-support] wrote:
> order by iif(:i = 1, t.c, IIF(:I = 0, sum(t.a) - sum(t.b), E))
> DESCENDING
>
> If i run it with i = 0 it gives wrong sort order.
>
> SUMA A B C D E
> -1,11,2
Hello everybody
I had the following query:
SELECT
D.ASI_ANOEJE,
D.ASI_CODSUC,
EXTRACT(MONTH FROM C.ASC_FECHAX) AS ASI_NUMMES,
D.ASI_NUMCUE,
D.ASI_NUMSUB
FROM
ASIENTOSDET D
JOIN
ASIENTOSCAB C
ON D.ASI_CODSUC = C.ASC_CODSUC AND
D.ASI_IDECAB = C.ASC_IDENTI
GROUP B
It should be
SUMA A B C D E
12 14 2 1 11 1
0 3 3 2 12 2
-1,11,2 2,3 1 11 3
-1,8
Hi,
No – you can not create single index on more then one table
But you really need it?
How big is resultset? I do not see any filter in this query no HAVING nor WHERE
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015 7:28 PM
To: firebird-s
Hello Karol
As I had said before, it is a mystery for me. The Primary Keys created by
me always begin with the PK_ characters, if they begin with INTEG_ is
because were created by ISQL.
But not problem at all, using CONSTRAINT it is solved.
Greetings.
Walter.
On Mon, Aug 24, 2015 at 12:51 PM,
Hello Karol
Thank you for your answer.
The query is a very simplified one, just for show the idea.
I can create an index as the following:
CREATE INDEX IDX_ASIENTOSDET1 ON ASIENTOSDET COMPUTED BY (
CAST(ASI_ANOEJE AS CHAR(5)) ||
CAST(ASI_CODSUC AS CHAR(5)) ||
CAST(EXTRACT(MONTH FROM (S
Hi-
I changed firebird to #: passwd myfb at the command-line.
At su firebird I get:
su: failed to execute /bin/nologin: No such file or directory
firebird:x:901:902::/:/bin/nologin
not sure what I am doing wrong. I am using firebird 2.5.4 fedora xfce classic.
Please assist!
Addendum: with th
Hi-
I figured this question out. An updated NEW question is coming. Thanks for any
assistance.
thanks!
Hi-
I used this to get by the error: su: failed to execute /bin/nologin: No such
file or directory
I changed to sbin instead of bin in /etc/passwd
I also log in like this for firebird user:
# su - firebird -s /bin/bash
Now I am getting under the firebird user:
I was told to try
Hi,
as i say previously you can not do this
as index can not be updated if something was changed in ASIENTOSCAB.
And any subseclect is not recognized by plan parser as expression index def
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015
Hi,
as i say previously you can not do this
as index can not be updated if something was changed in ASIENTOSCAB.
And any subseclect is not recognized by plan parser as expression index def
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015
Hi-
I have more intel on the problem.
SQL> connect "localhost:/var/lib/firebird/data/employee.fdb" user SYSDBA
password "mypass";
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird/
I have the fb listening on 3050 now.
tcp6 0 0 :::3050
Ok, thank you Karol.
Greetings.
Walter.
On Mon, Aug 24, 2015 at 2:32 PM, liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi,
>
> as i say previously you can not do this
> as index can not be updated if something was changed in ASIENTOSCAB.
> And any subseclect is not recognized by
I have one more curiosity... I lied actually many more-
why is fedora insisting in package manager to install embedded. Even when i try
to get rid of it fedora chooses to uninstall other files which I canceled and
not do?
could this be part of the problem that i have both embedded AND other cli
At 07:52 a.m. 25/08/2015, thirdshiftco...@yahoo.com [firebird-support] wrote:
>I have one more curiosity... I lied actually many more-
>
>why is fedora insisting in package manager to install embedded. Even when i
>try to get rid of it fedora chooses to uninstall other files which I canceled
>a
You are not supposed to login as user Firebird, that is also why it is pointing
to nologin. That user is only the user for running the service, and for
security reasons you shouldn't login with it.
To connect to Firebird, you need to have an account in Firebird (created using
gsec) and connect t
Hi Mark & Helen-
I somehow lost my post. I will try to make it briefer. I don't know how links
work here.
Mark nailed it on the source of my confusion. I thought like in postgres you
did :
su -
# su - postgres
pg$
Helen was right that I was doing
su - firebird -s /bin/bash
which is a "tweak
26 matches
Mail list logo