Kbase P128849: Why is there no user number listed for a Single user connection to a database in the database log fi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2009 |
|
Status: Unverified
GOAL:
Why is there no user number listed for a Single user connection to a database in the database log file?
GOAL:
Why is there no user number listed for a Read Only Single user connection to a database in the database log file?
GOAL:
Why do I see a single user connection listed in my database log file when my database is in multi-user mode?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
OpenEdge Category: Database
FIX:
A single user connection to a database considers itself the only user connected to a database and does not report user number in the database log file.
Thu Feb 07 10:32:24 2008
[2008/02/07@10:32:24.984-0500] P-296 T-3060 I : (451) Single-user session begin for richards on CON:.
[2008/02/07@10:32:25.000-0500] P-296 T-3060 I : (5326) Begin Physical Redo Phase at 0 .
[2008/02/07@10:32:25.000-0500] P-296 T-3060 I : (7161) Physical Redo Phase Completed at blk 0 off 6966 upd 0.
[2008/02/07@10:32:25.000-0500] P-296 T-3060 I : (13547) At end of Physical redo, transaction table size is 32.
[2008/02/07@10:32:25.015-0500] P-296 T-3060 I : (12699) Database prog101b Options:
[2008/02/07@10:32:31.765-0500] P-296 T-3060 I : (334) Single-user session end.
Multi-User session connections report user number information. The user number is issued by the broker upon connection:
[2008/02/01@14:27:20.062-0500] P-1080 T-4724 I Usr 5: (453) Logout by richards on CON:.
[2008/02/01@15:02:45.609-0500] P-1216 T-3308 I Usr 5: (452) Login by richards on CON:.
[2008/02/01@15:02:45.640-0500] P-1216 T-3308 I Usr 5: (12699) Database prog101b Options:
[2008/02/01@15:05:19.187-0500] P-1216 T-3308 I Usr 5: (453) Logout by richards on CON:.
A single user connection in read-only mode may make a connection to a database while it is served and will introduce its own messages into the database log file. This additional logging is expected and was introduced to allow full monitoring of all logins for security purposes.
Thu Feb 07 10:36:06 2008
[2008/02/07@10:36:06.515-0500] P-4664 T-1752 I BROKER 0: (333) Multi-user session begin.
[2008/02/07@10:36:06.546-0500] P-4664 T-1752 I BROKER 0: (5326) Begin Physical Redo Phase at 0 .
[2008/02/07@10:36:06.562-0500] P-4664 T-1752 I BROKER 0: (7161) Physical Redo Phase Completed at blk 0 off 6966 upd 0.
[2008/02/07@10:36:06.578-0500] P-4664 T-1752 I BROKER 0: (13547) At end of Physical redo, transaction table size is 32.
[2008/02/07@10:36:06.609-0500] P-4664 T-1752 I BROKER 0: (4234) Progress OpenEdge Release 10.1B build 1372 SP03 on WINNT .
[2008/02/07@10:36:06.609-0500] P-4664 T-1752 I BROKER 0: (4281) Server started by richards on CON:.
[2008/02/07@10:36:06.609-0500] P-4664 T-1752 I BROKER 0: (6574) Started using pid: 4664.
[2008/02/07@10:36:06.625-0500] P-4664 &nbs.p; T-1752 I BROKER 0: (4235) Physical Database Name (-db): prog101b.
[2008/02/07@10:36:06.625-0500] P-4664 T-1752 I BROKER 0: (4236) Database Type (-dt): PROGRESS.
[2008/02/07@10:36:06.625-0500] P-4664 T-1752 I BROKER 0: (4237) Force Access (-F): Not Enabled.
[2008/02/07@10:36:06.625-0500] P-4664 T-1752 I BROKER 0: (4238) Direct I/O (-directio): Not Enabled.
[2008/02/07@10:36:06.625-0500] P-4664 T-1752 I BROKER 0: (4239) Number of Database Buffers (-B): 3000.
[2008/02/07@10:36:06.625-0500] P-4664 T-1752 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 16390.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (10014) The shared memory segment is not locked in memory.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (4241) Current Size of Lock Table (-L): 8192.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (-----) Maximum Area Number (-maxArea): 32000.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (4242) Hash Table Entries (-hash): 887.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 24000.
[2008/02/07@10:36:06.640-0500] P-4664 T-1752 I BROKER 0: (6526) Number of Semaphore Sets (-semsets): 3.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 128 Mb.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4244) Crash Recovery (-i): Enabled.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (6573) Database Blocksize (-blocksize): 4096.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 3.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4247) Before-Image File I/O (-r -R): Reliable.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4250) Before-Image Cluster Size: 524288.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4251) Before-Image Block Size: 8192.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (4252) Number of Before-Image Buffers (-bibufs): 20.
[2008/02/07@10:36:06.656-0500] P-4664 T-1752 I BROKER 0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth)
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (9238) BI File Threshold size (-bithold): 0.0 Bytes.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (6552) BI File Threshold Stall (-bistall): Disabled.
[20.08/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4254) After-Image Stall (-aistall): Not Enabled.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4255) After-Image Block Size: 8192.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4256) Number of After-Image Buffers (-aibufs): 20.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (8527) Storage object cache size (-omsize): 1024
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 5.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 5.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 1.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4260) Maximum Number of Users (-n): 21.
[2008/02/07@10:36:06.671-0500] P-4664 T-1752 I BROKER 0: (4261) Host Name (-H): Not Enabled.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (4262) Service Name (-S): Not Enabled.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (4263) Network Type (-N): Not Enabled.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (4282) Parameter File: Not Enabled.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (9336) Created shared memory with segment_id: 19136512
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12813) Allowed index cursors (-c): 84.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12814) Group delay (-groupdelay): 10.
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12815) Lock table hash table size (-lkhash): 1237
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12818) Message Buffer Size (-Mm): 1024
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12821) Use muxlatches (-mux): 1
[2008/02/07@10:36:06.687-0500] P-4664 T-1752 I BROKER 0: (12823) Semaphore Sets (-semsets): 3
[2008/02/07@10:36:06.703-0500] P-4664 T-1752 I BROKER 0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes.
[2008/02/07@10:36:06.703-0500] P-4664 T-1752 I BROKER 0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000.
[2008/02/07@10:36:06.703-0500] P-4664 T-1752 I BROKER 0: (10471) Database connections have been enabled.
Thu Feb 07 10:36:11 2008
[2008/02/07@10:36:11.015-0500] P-6004 T-5080 I : (451) Single-user session begin for richards on CON:.
[20.08/02/07@10:36:11.031-0500] P-6004 T-5080 I : (12699) Database prog101b Options:
[2008/02/07@10:36:19.234-0500] P-6004 T-5080 I : (334) Single-user session end.
[2008/02/07@10:36:22.546-0500] P-5600 T-2648 I SHUT 5: (542) Server shutdown started by richards on CON:.
[2008/02/07@10:36:24.703-0500] P-4664 T-1752 I BROKER 0: (2248) Begin normal shutdown
[2008/02/07@10:36:25.812-0500] P-4664 T-1752 I BROKER : (334) Multi-user session end. .