It is cool that I probably don't need to use explicit locking much if at all!
thx. - have a cool rest of your weekend :-)
jim
https://firebirdsql.org/refdocs/langrefupd21-notes-withlock.html
https://firebirdsql.org/refdocs/langrefupd21-notes-withlock.html
Hi-
I am studying transactions with freepascal. It is going really well now. The
next thing I'd like to try is explicit locking. Can someone please describe in
a sentence or two how this works- 'explicit locking doesn't happen until the
record is output to servers row buffer'? I am not sure
Hi-
the gods are with me I found older versions at sourceforge.net.
well... got to get some sleep. much work tomorrow of a stressful nature.
have a cool monday.
thx. - jim
Hi-
I gave this a really good look. It seems no matter what i do I get an error in
gpre with cobol.
here is my cobol code:
IDENTIFICATION DIVISION.
PROGRAM-ID. Moon.
ENVIRONMENT DIVISION.
Configuration Section.
Special-Names.
DATA
hi -
I noticed that I am running the firebird server process under a different
account than root which is good from what I have read now that I have a
firebird:firebird user and group. I run the script in /etc/init.d/firebird
start.
thanks - jim
Hi-
I don't know why installer didn't add one. I just added a group firebird.
thx. - jim
hi-
I am using fedora 25 Linux. I can't use systemctl because I did a source
install. I can use fbguard. I tried gfix, and that won't work it seems. Then I
decided per advice from a website to use the script in init.d. That gave me the
following msg.
init.d # ./firebird stop
chown inval
okay Scott.
thx. for list suggestion.
I just got past icu by using :
--with-system-icu with ./configure.
but I got another gpre error.
I will head over there.
thx. - jim
well ... that's life.
I can't get by it. make throws an error in linux when I do source install. I
will have to go to icu boot camp so I can test out gpre later.
if there is an easy way to get by this please post.
thx. -jim
I am going to skip ICU for today unless easy fix. Will use ascii or something.
I am testing out different thing...gpre and I don't want to slow down to fool
with ICU if it isn't ready out of the box... at least not today.
thx.-jim
You must use /usr/bin/gmake to build ICU.
If the result of the above commands looks okay to you, go to the directory
source in the ICU distribution to build ICU. Please remember that ICU needs
GNU make to build properly...
I am just doing maybe UTF8 for characterset. Do I even need ICU if
SORRY !
THX. - JIM
Hi-
I am looking at firebird downloads and I don't see where they have a source
built with a configure script for linux for 2.5.x or maybe I am not looking in
the right place.
I found a source build for windows but couldn't get it to build with cygwin.
So now I am checking out to see
hi-
I found it now. I thought I was going crazy! sources is the first link on the
main download page. I was trying to find sources in the linux section.
thx.-
jim
HI-
I kind of solved the problem but not really. I just used super-classic.
now i can stop and start the server at will.
To help someone else out if they come across this in fedora24 I do:
[root@localhost system]# systemctl start firebird-superclassic.service
[root@localhost system]# top -b -n
Hi-
I thought I could use some services to shut down firebird with classic. I get
this error message.
I didn't know if it is safe or the preferred way to shut down classic by just
ctrl-c when
i used # ./fb_inet_server -m. The way I tried is like systemctl enable
firebird-classic.socket
HI-
i needed to do fb_inet_server -m
I wish I could find help on that command.
also my telnet didn't work.
on fedora you need a file on this path: cd /usr/lib/systemd/system
and this file goes in that directory: telnet.socket
i was missing telnet-server package in fedora.
Any help on where
hi -
I changed the service to gds_db. not sure if that will help.
Also, here is more complete information on telnet:
[turbolinux@localhost firebird]$ telnet localhost 3050
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: C
hi-
I have tried so hard to get firebird 2.5 up and running. I cannot anywhere
find the command to start and restart the server on fedora for firebird-classic.
It seems like that command has vanished from the internet!
I also cant telnet like this:
telnet localhost 3050
and get the error lik
hi-
i found it. sorry.
thx. - 3rdshiftcoder
Hi-
Does anyone use isql-fb and know the code to make the tid display?
thx.- 3rdshiftcoder
Hi Helen-
I am working on fixing my understanding.
I ran example 1 on cursors in book okay.
I am using flamerobin to see what is going on.
There is something cool called execute block I can use too.
I will look over your helpful comments and do example 2 tomorrow.
thanks,
Hi-
I since figured out part of it. RDB$ prefix denotes system tables.
Okay, so I am still wondering where RNAME gets it values.
thanks for any help.
jim
Hi-
I hope this doesn't double post.
RDB$ denotes a system table.
Stilll not sure where RNAME gets its value.
thanks - jim
Hi-
I have 2 questions from the code below.
Where do you come up with RDB$FIELD_NAME?
Is FIELDNAME part THE NAME OF A FIELD IN an actual TABLE AND
RELATION_FIELDS THE NAME OF A REAL TABLE?
How can you use :RNAME IN THE WHERE clause?
Where is it getting its value from? It seems like it
oops... I got it to work now.
this time I put in BOTH:
isc_tpb_read AND isc_tpb_write. I had just isc_tpb_write and it didn't work.
sorry,
jim
Hi-
I am using zeosdbo-7.1.4, fb 2.5 without the extra "d", and lazarus v1.4.2.
I have a similar thread posted in lazarus db forum but it looks like it might
go unanswered.
I will try to keep this short as possible.
in isql I can make this work with two isql-fb open:
set transaction read wri
Hi-
After getting stuck over the weekend, I am getting unstuck thanks to Mark. R,
the group, and the Internet. I watched a slide share presentation done by a
cool Russian on transactions. It helped me visualize what the heck is going on.
I didn't really understand it all that well before the s
Hi Mark Rotteveel and group -
Thanks for all the replies. I am in a vicious work cycle (joking).
I will study your replies tonight.
thanks so much,
jim
Hi-
Is there a way I can draw a diagram and match it to my input in isql?
I am trying to set the default transaction in each of my isql clients that are
open in separate windows.
In each isql I type: set transaction wait isolation level read committed.
I tried to make a chart like thi
Hi-
I am just practicing. I might have posted a confusing question before.
I want to see how selects behave differently with being in different isolation
contexts rather than just running the default snapshot like in isql with
nothing else going on (no other transactions).
This is an example o
HI-
I read through and practiced with all types of read committed transactions with
and without wait. I understand those scenarios as they apply to read write
with, for i.e., update statements.
I am trying to figure out besides snapshot, which is the default isolation in
isql, how a select que
Hi-
I think that on superclassic fb_inet_server is a listener on the firebird port.
fb_smp_server process is threaded and the thread count increases when the
client connections increase
or vice versa.
I hope I got that right. That is my best guess for now.
Have a cool week at work,
jim
Hi-
I kind of get it now. With superclassic the fb_smp_server process is threaded.
Its threads increase when the client connection count increases instead of
adding or reducing processes.
my best guess is that fb_init_server is a listener process on the firebird port.
e.g.
Sun Aug 30 18:15:36
Hi-
I noticed if I connect with the sql client like isql-fb, the threads go up in
the process fb_smp_server.
If I disconnect the sql client, the thread count goes down. I use pstree pid to
look at the threads.
thanks,
jim
Hi-
I am using fb superclassic 2.5..4 fedora xfce .
I am fooling with firebird today. Earlier I had to read some networking to
understand about the hosts file in linux i.e. /etc/hosts. That went okay. Now I
am looking at something different.
Is there a way you can make the threads show up in
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
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
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
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-
I figured this question out. An updated NEW question is coming. Thanks for any
assistance.
thanks!
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
43 matches
Mail list logo