faq:pervasive_troubleshooting
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
faq:pervasive_troubleshooting [2020/01/07 10:44 (4 years ago)] – kevin | faq: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. | + | Use this document to give you ideas on where to look for when experiencing a crashing Pervasive SQL service. |
+ | <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. | ||
===== 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. | * It can take time to rebuild a new virtual machine and to restore from backup. | ||
- | * Restoring from last known backup gets the business back into operation. | + | * Restoring from last known backup gets the business back into operation. |
* 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 | + | ===== Known Service Crashing Culprits ===== |
- | If the Peravsive | + | If the Pervasive |
- A corrupt database can cause a crash. | - A corrupt database can cause a crash. | ||
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" | - If receiving a "Roll forward recovery" | ||
- | - A 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 a snapshot or last known good server state) |
===== Trouble Shooting ===== | ===== Trouble Shooting ===== | ||
* Test network transmission of larger packet size as corrupt packets of data can cause failure | * Test network transmission of larger packet size as corrupt packets of data can cause failure | ||
- | * At command prompt ping -t -l 2000 (Is there packet loss?) | + | * At command prompt |
* Post and search the symptoms on [[https:// | * Post and search the symptoms on [[https:// | ||
* Capture the PVSW log file to be able to show other technicians. | * Capture the PVSW log file to be able to show other technicians. | ||
{{: | {{: | ||
* 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.1578422675.txt.gz · Last modified: 2020/01/07 10:44 (4 years ago) by kevin