starting a database - .lk error

T

tonedeaf

New Member
I am writing a script to start up the database and everytime i start it up I get this error.

Is there any sort of special permission needed? so i dont get this message?

There is no server for database /usr/Database/testing/database. (1423)
** Cannot find or open file /usr/Database/testing/database.lk, errno = 13. (43)
09:44:03 SERVER : Workgroup server cannot support more than 65 users. (5051)
09:44:03 SERVER : Number of users (-n) adjusted to 65. (5055)
09:44:03 BROKER 0: Multi-user session begin. (333)
09:44:04 BROKER 0: Begin Physical Redo Phase at 128 . (5326)
09:44:04 BROKER 0: Physical Redo Phase Completed at blk 213 off 1846 upd 0. (7161)
09:44:04 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
09:44:04 BROKER 0: Started for 2532 using TCP IPV4 address 0.0.0.0, pid 23268. (5644)
09:44:13 BROKER 1: Started for 2533 using TCP IPV4 address 0.0.0.0, pid 23270. (5644)
09:44:13 BROKER 1: This is an additional broker for this protocol. (5645)
09:44:13 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
 
Neither do you tell us something about the Progress/OpenEdge version you are running nor on which operating system you are on. From the path I guess you are running on some *nix flavor.

What does you script do?
What exactly is happening?
Is this a snippet of your database log file?

RealHeavyDude.
 
ok..thanks.

The snippet above is what i get on the screen when the server comes up. verbage on the screen when i run the script/

The Progress Version is 10.1C running on linux, Redhat Ent 5.0

The script is basically a online backup of one db, then shutdown/restore and startup.

Code: 
DLC=/usr/dlc;export DLC
PATH=$PATH:DLC/bin;export PATH

TESTDB=/usr/Database/testdb
TEMPDB=/usr/Database/testing
DBNAME=database

$DLC/bin/probkup online $TESTDB/$DBNAME /usr/Database/restoretemp/temp.bak;
$DLC/bin/proshut -b $TEMPDB/$DBNAME;
$DLC/bin/prorest $TEMPDB/$DBNAME /usr/Database/restoretemp/temp.bak;
$DLC/bin/_mprosrv -db /usr/Database/testing/database -N TCP -H server -S 2532 -L 3000 -n 66 -Mn 10 -Mpb 4 -Ma 20;
 $DLC/bin/_mprosrv -db /usr/Database/testing/database -N TCP -H server -S 2533 -L 3000 -m3 -Ma 5;
error i get

Backup complete. (3740)

Shutdown is executing. (1613)
Shutdown complete. (1614)
** Cannot find or open file /usr/Database/testing/database.lk, errno = 13. (43)

===
log file

Code: 
                Thu Jun 24 10:10:13 2010
[2010/06/24@10:10:13.277-0500] P-28822      T-0     I BROKER  0: (333)   Multi-user session begin.
[2010/06/24@10:10:13.296-0500] P-28822      T-0     I BROKER  0: (5326)  Begin Physical Redo Phase at 128 .
[2010/06/24@10:10:13.360-0500] P-28822      T-0     I BROKER  0: (7161)  Physical Redo Phase Completed at blk 213 off 1846 upd 0.
[2010/06/24@10:10:13.371-0500] P-28822      T-0     I BROKER  0: (13547) At end of Physical redo, transaction table size is 256.
[2010/06/24@10:10:13.700-0500] P-28822      T-0     I BROKER  0: (5644)  Started for 2532 using TCP IPV4 address 0.0.0.0, pid 28822.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4234)  Progress OpenEdge Release 10.1C build 1282 on Linux server.domain 2.6.18-164.2.1.el5 #1 S
MP Mon Sep 21 04:37:51 EDT 2009.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4281)  Server started by user on /dev/pts/2.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (6574)  Started using pid: 28822.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4235)  Physical Database Name (-db): /usr/Database/testing/database.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4236)  Database Type (-dt): PROGRESS.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4237)  Force Access (-F): Not Enabled.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4238)  Direct I/O (-directio): Not Enabled.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (-----) LRU mechanism enabled.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4239)  Number of Database Buffers (-B): 3000.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (9422)  Maximum private buffers per user (-Bpmax): 64.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (4240)  Excess Shared Memory Size (-Mxs): 38.
[2010/06/24@10:10:14.752-0500] P-28822      T-0     I BROKER  0: (10014) The shared memory segment is not locked in memory.
[2010/06/24@10:10:14.753-0500] P-28822      T-0     I BROKER  0: (4241)  Current Size of Lock Table (-L): 3008.
[2010/06/24@10:10:14.753-0500] P-28822      T-0     I BROKER  0: (13953) Maximum Area Number (-maxArea): 32000.
[2010/06/24@10:10:14.753-0500] P-28822      T-0     I BROKER  0: (4242)  Hash Table Entries (-hash): 887.
[2010/06/24@10:10:14.753-0500] P-28822      T-0     I BROKER  0: (4243)  Current Spin Lock Tries (-spin): 1.
[2010/06/24@10:10:14.764-0500] P-28822      T-0     I BROKER  0: (6526)  Number of Semaphore Sets (-semsets): 3.
[2010/06/24@10:10:14.774-0500] P-28822      T-0     I BROKER  0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 128 Mb.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4244)  Crash Recovery (-i): Enabled.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (6573)  Database Blocksize (-blocksize): 4096.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4245)  Delay of Before-Image Flush (-Mf): 3.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4247)  Before-Image File I/O (-r -R): Reliable.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4249)  Before-Image Truncate Interval (-G): 0.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4250)  Before-Image Cluster Size: 524288.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4251)  Before-Image Block Size: 8192.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (4252)  Number of Before-Image Buffers (-bibufs): 20.
[2010/06/24@10:10:14.775-0500] P-28822      T-0     I BROKER  0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth)
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (9238)  BI File Threshold size (-bithold): 0.0   Bytes.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (6552)  BI File Threshold Stall (-bistall): Disabled.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4254)  After-Image Stall (-aistall): Not Enabled.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4255)  After-Image Block Size: 8192.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4256)  Number of After-Image Buffers (-aibufs): 20.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (8527)  Storage object cache size (-omsize): 1024
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4257)  Maximum Number of Clients Per Server (-Ma): 20.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4258)  Maximum Number of Servers (-Mn): 11.
[2010/06/24@10:10:14.776-0500] P-28822      T-0     I BROKER  0: (4259)  Minimum Clients Per Server (-Mi): 1.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4260)  Maximum Number of Users (-n): 66.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4261)  Host Name (-H): server.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4262)  Service Name (-S): 2532.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (14268) TCP/IP Version (-ipver) : IPV4
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4263)  Network Type (-N): TCP.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4264)  Character Set (-cpinternal): ISO8859-1.
[2010/06/24@10:10:14.777-0500] P-28822      T-0     I BROKER  0: (4282)  Parameter File: Not Enabled.
[2010/06/24@10:10:14.778-0500] P-28822      T-0     I BROKER  0: (12820) Maximum Servers per Broker (-Mpb): 4
[2010/06/24@10:10:14.778-0500] P-28822      T-0     I BROKER  0: (12821) Use muxlatches (-mux): 1
[2010/06/24@10:10:14.778-0500] P-28822      T-0     I BROKER  0: (12823) Semaphore Sets (-semsets): 3
[2010/06/24@10:10:14.779-0500] P-28822      T-0     I BROKER  0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0  KBytes.
[2010/06/24@10:10:14.779-0500] P-28822      T-0     I BROKER  0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000.
[2010/06/24@10:10:14.779-0500] P-28822      T-0     I BROKER  0: (10471) Database connections have been enabled.
[2010/06/24@10:11:11.320-0500] P-28826      T-0     I BROKER  1: (5644)  Started for 2533 using TCP IPV4 address 0.0.0.0, pid 28826.
[2010/06/24@10:11:11.321-0500] P-28826      T-0     I BROKER  1: (5645)  This is an additional broker for this protocol.
[2010/06/24@10:11:11.321-0500] P-28826      T-0     I BROKER  1: (8865)  This broker supports both 4GL and SQL server groups.
[2010/06/24@10:11:36.682-0500] P-28831      T-0     I SHUT   11: (542)   Server shutdown started by overwritetemp on /dev/pts/2.
[2010/06/24@10:11:36.694-0500] P-28822      T-0     I BROKER  0: (2248)  Begin normal shutdown
[2010/06/24@10:11:36.694-0500] P-28822      T-0     I BROKER  0: (-----) Sending signal 12 to user 1
[2010/06/24@10:11:37.822-0500] P-28822      T-0     I BROKER   : (-----) Removed shared memory with segment_id: 1572869
[2010/06/24@10:11:37.860-0500] P-28822      T-0     I BROKER   : (334)   Multi-user session end.

                Thu Jun 24 10:11:39 2010
[2010/06/24@10:11:39.390-0500] P-28834      T-0     I BROKER  0: (333)   Multi-user session begin.
[2010/06/24@10:11:39.399-0500] P-28834      T-0     I BROKER  0: (5326)  Begin Physical Redo Phase at 128 .
[2010/06/24@10:11:39.420-0500] P-28834      T-0     I BROKER  0: (7161)  Physical Redo Phase Completed at blk 213 off 1846 upd 0.
[2010/06/24@10:11:39.421-0500] P-28834      T-0     I BROKER  0: (13547) At end of Physical redo, transaction table size is 256.
[2010/06/24@10:11:39.445-0500] P-28834      T-0     I BROKER  0: (5644)  Started for 2532 using TCP IPV4 address 0.0.0.0, pid 28834.
[2010/06/24@10:11:40.552-0500] P-28834      T-0     I BROKER  0: (4234)  Progress OpenEdge Release 10.1C build 1282 on Linux server.domain 2.6.18-164.2.1.el5 #1 S
MP Mon Sep 21 04:37:51 EDT 2009.
[2010/06/24@10:11:40.552-0500] P-28834      T-0     I BROKER  0: (4281)  Server started by overwritetemp on /dev/pts/2.
[2010/06/24@10:11:40.552-0500] P-28834      T-0     I BROKER  0: (6574)  Started using pid: 28834.
[2010/06/24@10:11:40.552-0500] P-28834      T-0     I BROKER  0: (4235)  Physical Database Name (-db): /usr/Database/testing/database.
[2010/06/24@10:11:40.552-0500] P-28834      T-0     I BROKER  0: (4236)  Database Type (-dt): PROGRESS.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4237)  Force Access (-F): Not Enabled.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4238)  Direct I/O (-directio): Not Enabled.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (-----) LRU mechanism enabled.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4239)  Number of Database Buffers (-B): 3000.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (9422)  Maximum private buffers per user (-Bpmax): 64.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4240)  Excess Shared Memory Size (-Mxs): 38.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (10014) The shared memory segment is not locked in memory.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4241)  Current Size of Lock Table (-L): 3008.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (13953) Maximum Area Number (-maxArea): 32000.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4242)  Hash Table Entries (-hash): 887.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4243)  Current Spin Lock Tries (-spin): 1.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (6526)  Number of Semaphore Sets (-semsets): 3.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 128 Mb.
[2010/06/24@10:11:40.553-0500] P-28834      T-0     I BROKER  0: (4244)  Crash Recovery (-i): Enabled.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (6573)  Database Blocksize (-blocksize): 4096.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (4245)  Delay of Before-Image Flush (-Mf): 3.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (4247)  Before-Image File I/O (-r -R): Reliable.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (4249)  Before-Image Truncate Interval (-G): 0.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (4250)  Before-Image Cluster Size: 524288.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (4252)  Number of Before-Image Buffers (-bibufs): 20.
[2010/06/24@10:11:40.554-0500] P-28834      T-0     I BROKER  0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth)
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (9238)  BI File Threshold size (-bithold): 0.0   Bytes.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (6552)  BI File Threshold Stall (-bistall): Disabled.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4254)  After-Image Stall (-aistall): Not Enabled.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4255)  After-Image Block Size: 8192.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4256)  Number of After-Image Buffers (-aibufs): 20.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (8527)  Storage object cache size (-omsize): 1024
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4257)  Maximum Number of Clients Per Server (-Ma): 20.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4258)  Maximum Number of Servers (-Mn): 11.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4259)  Minimum Clients Per Server (-Mi): 1.
[2010/06/24@10:11:40.555-0500] P-28834      T-0     I BROKER  0: (4260)  Maximum Number of Users (-n): 66.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (4261)  Host Name (-H): server.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (4262)  Service Name (-S): 2532.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (14268) TCP/IP Version (-ipver) : IPV4
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (4263)  Network Type (-N): TCP.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (4264)  Character Set (-cpinternal): ISO8859-1.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (4282)  Parameter File: Not Enabled.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (5647)  Maximum Servers Per Broker (-Mpb): 4.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (5648)  Minimum Port for Auto Servers (-minport): 1025.
[2010/06/24@10:11:40.556-0500] P-28834      T-0     I BROKER  0: (5649)  Maximum Port for Auto Servers (-maxport): 2000.
[2010/06/24@10:11:40.557-0500] P-28834      T-0     I BROKER  0: (8865)  This broker supports both 4GL and SQL server groups.
[2010/06/24@10:11:40.557-0500] P-28834      T-0     I BROKER  0: (9336)  Created shared memory with segment_id: 1605637
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12813) Allowed index cursors (-c): 264.
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12814) Group delay (-groupdelay): 10.
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12815) Lock table hash table size (-lkhash): 449
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12816) Maxport (-maxport): 2000
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12817) Minport (-minport): 1025
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12818) Message Buffer Size (-Mm): 1024
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12820) Maximum Servers per Broker (-Mpb): 4
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12821) Use muxlatches (-mux): 1
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (12823) Semaphore Sets (-semsets): 3
[2010/06/24@10:11:40.568-0500] P-28834      T-0     I BROKER  0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0  KBytes.
[2010/06/24@10:11:40.569-0500] P-28834      T-0     I BROKER  0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000.
[2010/06/24@10:11:40.569-0500] P-28834      T-0     I BROKER  0: (10471) Database connections have been enabled.
[2010/06/24@10:11:40.618-0500] P-28836      T-0     I BROKER  1: (5644)  Started for 2533 using TCP IPV4 address 0.0.0.0, pid 28836.
[2010/06/24@10:11:40.619-0500] P-28836      T-0     I BROKER  1: (5645)  This is an additional broker for this protocol.
[2010/06/24@10:11:40.619-0500] P-28836      T-0     I BROKER  1: (8865)  This broker supports both 4GL and SQL server groups.
 
Error 13 on *nix is almost always a user permission problem ...

in your log above...
Server started by user on /dev/pts/2.

Server started by overwritetemp on /dev/pts/2.
 
Sorry overwritetemp is actually the user. I tried to hide my username but its revealed now.

I started the databases initially with the same user that I am running the script with. I thought if i started the db with the user that user would own the process and would have no restrictions.
 
The .lk file locks the database. It is used to make sure that a user doesn't try to start the db if it is already running. This is especially handy if you have a shared disk arrangement of some sort.

Running as root would override most permissions problems and error 13 is a permissions problem. So it seems likely that that is what you have.

Are the Progress executables installed setuid to root? If they aren't that might explain your problem.
 
You must log in or register to reply here.
Back
Top