SMAT Error

[David Speare]

Hello –

I have a process that is throwing SMAT errors.  This is a test box (linux) and i did a complete dbinit -A -C and physically deleted all the SMAT files in the directory, but every time I try and start the process it crashes.  Any thoughts?

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:25] Thread d_pyxes_mfn_tam auto-started.

[prod:prod:INFO/0:d_pyxes_mfn_tam:01/14/2018 18:07:25] Starting protocol thread d_pyxes_mfn_tam as tid 74.

[pd  :open:ERR /0:d_pyxes_mfn_tam:01/14/2018 18:07:25] Error returned from SMAT database: Recovered 5 frames from WAL file /qdxtestsites/cis6.1/pyxis_tst/exec/processes/pyxisES/d_pyxes_mfn_tam.smatdb-wal. Error code is 0

[prod:prod:INFO/0:d_pyxes_mfn_tam:01/14/2018 18:07:25] Applying EO config: ”

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:25] Thread d_pyxES_ctmc auto-started.

[prod:prod:INFO/0: d_pyxES_ctmc:01/14/2018 18:07:25] Starting protocol thread d_pyxES_ctmc as tid 75.

[pd  :open:ERR /0: d_pyxES_ctmc:01/14/2018 18:07:25] Error returned from SMAT database: Recovered 5 frames from WAL file /qdxtestsites/cis6.1/pyxis_tst/exec/processes/pyxisES/d_pyxES_ctmc.smatdb-wal. Error code is 0

[prod:prod:INFO/0: d_pyxES_ctmc:01/14/2018 18:07:25] Applying EO config: ”

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:25] Thread d_pyxes_del auto-started.

[prod:prod:INFO/0:  d_pyxes_del:01/14/2018 18:07:25] Starting protocol thread d_pyxes_del as tid 76.

[pd  :open:ERR /0:  d_pyxes_del:01/14/2018 18:07:25] Error returned from SMAT database: Recovered 5 frames from WAL file /qdxtestsites/cis6.1/pyxis_tst/exec/processes/pyxisES/d_pyxes_del.smatdb-wal. Error code is 0

[prod:prod:INFO/0:  d_pyxes_del:01/14/2018 18:07:25] Applying EO config: ”

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:25] Thread s_pyxES_heh auto-started.

[prod:prod:INFO/0:  s_pyxES_heh:01/14/2018 18:07:25] Starting protocol thread s_pyxES_heh as tid 77.

[pd  :open:ERR /0:  s_pyxES_heh:01/14/2018 18:07:25] Error returned from SMAT database: Recovered 5 frames from WAL file /qdxtestsites/cis6.1/pyxis_tst/exec/processes/pyxisES/s_pyxES_heh.smatdb-wal. Error code is 0

[prod:prod:INFO/0:  s_pyxES_heh:01/14/2018 18:07:25] Applying EO config: ”

NO OPERATOR

[MORE LINES]

prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:29] Thread d_phocusrx_del auto-started.

[prod:prod:INFO/0:d_phocusrx_del:01/14/2018 18:07:29] Starting protocol thread d_phocusrx_del as tid 94.

[pd  :open:ERR /0:d_phocusrx_del:01/14/2018 18:07:29] Error returned from SMAT database: Recovered 5 frames from WAL file /qdxtestsites/cis6.1/pyxis_tst/exec/processes/pyxisES/d_phocusrx_del.smatdb-wal. Error code is 0

[prod:prod:INFO/0:d_phocusrx_del:01/14/2018 18:07:29] Applying EO config: ”

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:29] Thread s_cer_pyx_fis not auto-started.

[prod:prod:INFO/0:  pyxisES_cmd:01/14/2018 18:07:29] Thread d_pyxES_mfn_wch auto-started.

[prod:prod:INFO/0:d_pyxES_mfn_wch:01/14/2018 18:07:29] Starting protocol thread d_pyxES_mfn_wch as tid 95.

[prod:prod:INFO/0:d_pyxES_mfn_wch:01/14/2018 18:07:30] Applying EO config: ”

PANIC: “fd < 1024" PANIC: Calling “pti” for thread pyxisES_cmd

---

Scheduler State

---

Thread Events     State      Priority Runnable  PT Msgs

  0      0   SCHED_IDLE         0       0       0,0,0

  1      0   SCHED_IDLE         0       0       0,0,93

  2      0   SCHED_IDLE         0       0       0,0,0

  3      0   SCHED_IDLE         0       0       0,0,0

Topic

[Peter Heggie]

Sorry I don’t have a better answer, but have not seen these (not having any mention of SQLITE).

Is the Site option set to Save to Database=Y and Encryption=N?

Also, maybe enable Smat History?

Peter Heggie

[Mark Thompson]

Please double check that you deleted all *.smatdb* files in that process, not just the ones ending in .smatdb.  There can be several files created by sqlite that all relate to the same smatdb file – used to improve concurrent access.

- Mark Thompson
HealthPartners

[Jerry Tilsley]

You may also want to ensure that any messages in the recovery database for those threads are deleted.  I’ve had issues with those.

Thanks,

Jerry

[David Coffey]

The line “fd < 1024" catches my eye.  Is this a new install?  Are there other sites running w/o issue?  What is the limit for open file descriptors?  Also what are the permissions for the directory for the smat files?  Maybe the process cannot write to the directory?  

Just some random thoughts.

[Author]

Replies