Banco derrubado - (49) SYSTEM ERROR: Memory violation.

Discussão em 'Banco de Dados / Database' iniciado por mcfernandes, Novembro 19, 2014.

  1. mcfernandes

    mcfernandes Membro Participativo

    Bom dia!

    Pessoal, estou com um problema numa máquina de testes. Eu subo os bancos sem problemas mas logo em seguida o banco é finalizado. No log não consegui identificar nenhum problema, a informação está muito genérica ( (49) SYSTEM ERROR: Memory violation.)

    Já fiz teste com cópia do banco SPORTS, bancos vazios, bancos da minha aplicação. Em todos eles o comportamento é o mesmo. Segue exemplo do log de um deles:

    Wed Nov 19 11:39:41 2014
    [2014/11/19@11:39:41.983-0200] P-319312 T-140691246688000 I BROKER 0: (333) Multi-user session begin.
    [2014/11/19@11:39:42.048-0200] P-319312 T-140691246688000 I BROKER 0: (5326) Begin Physical Redo Phase at 2048 .
    [2014/11/19@11:39:46.957-0200] P-319312 T-140691246688000 I BROKER 0: (7161) Physical Redo Phase Completed at blk 5768 off 7851 upd 284884.
    [2014/11/19@11:39:46.957-0200] P-319312 T-140691246688000 I BROKER 0: (13547) At end of Physical redo, transaction table size is 32768.
    [2014/11/19@11:39:47.778-0200] P-319312 T-140691246688000 I BROKER 0: (452) Login by root on /dev/pts/0.
    [2014/11/19@11:39:47.787-0200] P-319312 T-140691246688000 I BROKER 0: (5644) Started for tot2mod_repl_mod using tcp IPV4 address 0.0.0.0, pid 319312.
    [2014/11/19@11:39:48.787-0200] P-319312 T-140691246688000 I BROKER 0: (4234) Progress OpenEdge Release 10.2B build 1907 SP08 on Linux lnxvedmodpdb01.telefonicadc.br 2.6.32-431.29.2.el6.x86_64 #1 SMP Sun Jul 27 15:55:46 EDT 2014 x86_64.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4281) Server started by root on /dev/pts/0.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Started using pid: 319312.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4235) Physical Database Name (-db): /data/dbteste/emsmod/ems2mod.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4236) Database Type (-dt): PROGRESS.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4237) Force Access (-F): Not Enabled.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4238) Direct I/O (-directio): Not Enabled.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) LRU mechanism enabled.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Number of LRU force skips (-lruskips): 0
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Number of LRU2 force skips (-lru2skips): 0
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4239) Number of Database Buffers (-B): 10000.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Number of Alternate Database Buffers (-B2): 0.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 194.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (10014) The shared memory segment is not locked in memory.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4241) Current Size of Lock Table (-L): 200000.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (13953) Maximum Area Number (-maxArea): 32000.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4242) Hash Table Entries (-hash): 3407.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 120000.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (6526) Number of Semaphore Sets (-semsets): 3.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 1024 Mb.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4244) Crash Recovery (-i): Enabled.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (6573) Database Blocksize (-blocksize): 4096.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 3.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4247) Before-Image File I/O (-r -R): Reliable.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4250) Before-Image Cluster Size: 33554432.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4251) Before-Image Block Size: 16384.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (4252) Number of Before-Image Buffers (-bibufs): 200.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth)
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (9238) BI File Threshold size (-bithold): 0.0 Bytes.
    [2014/11/19@11:39:48.788-0200] P-319312 T-140691246688000 I BROKER 0: (6552) BI File Threshold Stall (-bistall): Disabled.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4254) After-Image Stall (-aistall): Not Enabled.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4255) After-Image Block Size: 16384.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4256) Number of After-Image Buffers (-aibufs): 350.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (8527) Storage object cache size (-omsize): 1024
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 5.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 77.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 5.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Use pollset mechanism for client/server (-pollset): Disabled
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Minimum records in prefetch ms (-prefetchNumRecs): 16
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (-----) Suspension queue poll priority (-prefetchPriority): 0
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4260) Maximum Number of Users (-n): 381.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4261) Host Name (-H): lnxvedmodpdb01.telefonicadc.br.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4262) Service Name (-S): tot2mod_repl_mod.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (14268) TCP/IP Version (-ipver) : IPV4
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4263) Network Type (-N): tcp.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (4282) Parameter File: Not Enabled.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (5648) Minimum Port for Auto Servers (-minport): 3500.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (5649) Maximum Port for Auto Servers (-maxport): 64000.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (10357) Pending client connection timeout (-PendConnTimeout): 1440.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (8865) This broker supports both 4GL and SQL server groups.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (9336) Created shared memory with segment_id: 294912
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12813) Allowed index cursors (-c): 1524.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12814) Group delay (-groupdelay): 10.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12815) Lock table hash table size (-lkhash): 25621
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12816) Maxport (-maxport): 64000
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12817) Minport (-minport): 3500
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12818) Message Buffer Size (-Mm): 32600
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12821) Use muxlatches (-mux): 1
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (12823) Semaphore Sets (-semsets): 3
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000.
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (15219) Encryption enabled: 0
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (15218) Encryption cache size (-ecsize): 1000
    [2014/11/19@11:39:48.789-0200] P-319312 T-140691246688000 I BROKER 0: (49) SYSTEM ERROR: Memory violation.
    [2014/11/19@11:39:48.790-0200] P-319312 T-140691246688000 I BROKER 0: (5292) SYSTEM ERROR: The broker is exiting unexpectedly, beginning Abnormal Shutdown.
    [2014/11/19@11:39:48.790-0200] P-319312 T-140691246688000 I BROKER 0: (-----) drexit: Initiating Abnormal Shutdown
    [2014/11/19@11:39:48.790-0200] P-319312 T-140691246688000 I BROKER 0: (439) ** Save file named core for analysis by Progress Software Corporation.
    [2014/11/19@11:39:48.790-0200] P-319312 T-140691246688000 I BROKER 0: (15192) The database will complete shutdown within approximately 60 seconds.
    [2014/11/19@11:39:48.790-0200] P-319312 T-140691246688000 I BROKER 0: (2249) Begin ABNORMAL shutdown code 2
    [2014/11/19@11:39:49.790-0200] P-319312 T-140691246688000 I BROKER 0: (453) Logout by root on /dev/pts/0.
    [2014/11/19@11:39:50.810-0200] P-319312 T-140691246688000 I BROKER : (-----) Removed shared memory with segment_id: 294912
    [2014/11/19@11:39:50.833-0200] P-319312 T-140691246688000 I BROKER : (334) Multi-user session end.

    Obrigada!
  2. ds201

    ds201 Membro Participativo

  3. fabiano

    fabiano Consultor Banco de Dados Moderador Equipe de Suporte

    Cláudia, qual é o service pack que tu tem instalado?
    Tu utiliza o _mprosrv ou proserve para carregar o banco de dados?
  4. mcfernandes

    mcfernandes Membro Participativo

    Olá!!!!
    Fabiano, já tentei pelos 2 e o patch eh o 08.
  5. fabiano

    fabiano Consultor Banco de Dados Moderador Equipe de Suporte

    Ok!
    E tu já tentou fazer o teste de carregar com o mínimo de parâmetro?
    Exemplo:
    proserve banco -N tcp -S 30000
  6. michel

    michel Membro Participativo

    Faz um teste

    proutil dbname -C dbipcs

Compartilhe esta Página