User Tools

Site Tools


faq:pervasive_troubleshooting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
faq:pervasive_troubleshooting [2020/01/07 10:45 (4 years ago)] kevinfaq:pervasive_troubleshooting [2020/06/25 11:11 (4 years ago)] (current) kevin
Line 1: Line 1:
 ====== Pervasive Crash Troubleshooting ====== ====== Pervasive Crash Troubleshooting ======
-Use this document to give you ideas on where to look for when experiencing a crashing Pervasive SQL service.  This article is written expecting you know how to run the PCC (Pervasive Control Center) and have a technical background in System Five.  If you are unsure what to do, contact Windward Software customer care.+Use this document to give you ideas on where to look for when experiencing a crashing Pervasive SQL service.  This article is written expecting you to know how to run the PCC (Pervasive Control Center) or ZenCC and have a technical background in System Five.  If you are unsure what to do, contact Windward Software customer care.
  
 +<note tip>This article was written with Pervasive SQL version 12 in mind.  Many of the issues will pertain to Actian Zen PSQL 14 which was a rebrand by Actian Software.  Note they renamed the PCC to ZenCC.</note>
  
 ===== Questions to Ask ===== ===== Questions to Ask =====
   * What is the plan to restore from backup?    * What is the plan to restore from backup? 
     * It can take time to rebuild a new virtual machine and to restore from backup.  Start this while doing any further trouble shooting.     * It can take time to rebuild a new virtual machine and to restore from backup.  Start this while doing any further trouble shooting.
-    * Restoring from last known backup gets the business back into operation.  You can trouble shoot a database issue in training or on another server entirely.+    * Restoring from last known backup gets the business back into operation.  You can troubleshoot a database issue in training or on another server entirely.
   * What has changed?   * What has changed?
   * Groom the logs and ask questions to understand service restarts or messages.   * Groom the logs and ask questions to understand service restarts or messages.
Line 12: Line 13:
   * What date and time was the last known good backup taken (with the PSQL service turned off)?   * What date and time was the last known good backup taken (with the PSQL service turned off)?
  
-===== Known Pervasive Service Crashing Culprits ===== +===== Known Service Crashing Culprits ===== 
-If the Peravsive SQL database service is crashing here are some things to check.+If the Pervasive SQL database service is crashing here are some things to check.
  
   - A corrupt database can cause a crash.  Restore from backup.   - A corrupt database can cause a crash.  Restore from backup.
Line 20: Line 21:
   - Is the Pervasive database version patched and up to date.  (Verify service pack and version)   - Is the Pervasive database version patched and up to date.  (Verify service pack and version)
   - If receiving a "Roll forward recovery" or "The log file is corrupt" message in the logs you could try to clear out the [[https://communities.actian.com/s/question/0D5f300005W2NqiCAF/cause-of-roll-forward-recovery-in-files-all-of-a-sudden|Transaction Log]]   - If receiving a "Roll forward recovery" or "The log file is corrupt" message in the logs you could try to clear out the [[https://communities.actian.com/s/question/0D5f300005W2NqiCAF/cause-of-roll-forward-recovery-in-files-all-of-a-sudden|Transaction Log]]
-  - operating system patch or pending operating system patch can cause odd behavior. (Reboot; apply updates; restore from snapshot or last known good server state)+  - An operating system patch or pending operating system patch can cause odd behavior. (Reboot; apply updates; restore from snapshot or last known good server state)
  
 ===== Trouble Shooting ===== ===== Trouble Shooting =====
Line 29: Line 30:
 {{:faq:pcc-pvsw_log.png?400|}} {{:faq:pcc-pvsw_log.png?400|}}
   * Check the server event log for messages that may indicate what the problem is.   * Check the server event log for messages that may indicate what the problem is.
-  * Using the PCC you can go table by table and view by view to find the offending file that will crash the database service.+  * Using the PCC you can go table by table and view to find the offending file that will crash the database service.
   * Consider stopping the relational service which will stop SQL support. This may help isolate the issue to the application causing the problem.   * Consider stopping the relational service which will stop SQL support. This may help isolate the issue to the application causing the problem.
  
faq/pervasive_troubleshooting.txt · Last modified: 2020/06/25 11:11 (4 years ago) by kevin