Difference between revisions of "Lessons Learned"
| Line 1: | Line 1: | ||
This page contains some solutions to situations we've encountered during the life of Truxton | This page contains some solutions to situations we've encountered during the life of Truxton | ||
| − | =Load.exe Disappears From Install Folder= | + | =Administrative= |
| + | ==Load.exe Disappears From Install Folder== | ||
When Truxton is processing incoming media, it may (probably will) encounter malware. | When Truxton is processing incoming media, it may (probably will) encounter malware. | ||
When <code>[[Load|Load.exe]]</code> (or maybe <code>[[EMail|EMail.exe]]</code>) writes this malware to the [[Depot|depot]] file, the process might get quarantined by your virus scanner. | When <code>[[Load|Load.exe]]</code> (or maybe <code>[[EMail|EMail.exe]]</code>) writes this malware to the [[Depot|depot]] file, the process might get quarantined by your virus scanner. | ||
| Line 8: | Line 9: | ||
You can prevent this by disabling virus protection on loader machines or configuring them to exempt Truxton's processes and folders from scanning. | You can prevent this by disabling virus protection on loader machines or configuring them to exempt Truxton's processes and folders from scanning. | ||
| − | =Delete Folder Structure= | + | ==Delete Folder Structure== |
When expanding [[Type_Outlook_Personal_Folders|PST]] files, sometimes folders can be left behind. | When expanding [[Type_Outlook_Personal_Folders|PST]] files, sometimes folders can be left behind. | ||
Usually, they will contain filenames that Windows thinks doesn't exist. | Usually, they will contain filenames that Windows thinks doesn't exist. | ||
| Line 16: | Line 17: | ||
</source> | </source> | ||
| − | =Deleting Folder Structure 2= | + | ==Deleting Folder Structure 2== |
Sometimes, when expanding archives, folder ownership will be reset. | Sometimes, when expanding archives, folder ownership will be reset. | ||
To delete them, you must first take ownership and reset the security. | To delete them, you must first take ownership and reset the security. | ||
| Line 26: | Line 27: | ||
</source> | </source> | ||
| − | =Killing Processes= | + | ==Killing Processes== |
If you have mistakenly started loading a [[Load List|load list]], you can stop the Truxton service but the <code>Load.exe</code> processes will still be running. | If you have mistakenly started loading a [[Load List|load list]], you can stop the Truxton service but the <code>Load.exe</code> processes will still be running. | ||
<source lang="bat"> | <source lang="bat"> | ||
| Line 42: | Line 43: | ||
log_hostname = off | log_hostname = off | ||
</pre> | </pre> | ||
| + | |||
| + | =Debugging ETLs= | ||
| + | ==Application is in Break Mode== | ||
| + | "Application is in Break Mode" is Microsoftspeak for "Cannot debug because Just My Code is enabled" | ||
| + | |||
| + | When your ETL goes bonkers, you can right button on the process in Task Manager and choose Create Dump File. | ||
| + | This will dump the state of your process to your %appdata% temp folder. | ||
| + | You can open your project in Visual Studio, then open the DMP file and it will magically take you to the point where the process was. | ||
| + | Well, unless you get the "Application is in break mode" message whereby you can do nothing. | ||
| + | To fix this, in Visual Studio, go to Debug->Options->General and uncheck "Enable Just My Code" | ||
Revision as of 07:49, 15 February 2021
This page contains some solutions to situations we've encountered during the life of Truxton
Contents
Administrative
Load.exe Disappears From Install Folder
When Truxton is processing incoming media, it may (probably will) encounter malware.
When Load.exe (or maybe EMail.exe) writes this malware to the depot file, the process might get quarantined by your virus scanner.
When this happens, depending on your settings, the executable files will disappear from the installation folder.
You can prevent this by disabling virus protection on loader machines or configuring them to exempt Truxton's processes and folders from scanning.
Delete Folder Structure
When expanding PST files, sometimes folders can be left behind. Usually, they will contain filenames that Windows thinks doesn't exist. To delete the folder, use the "escaped" name which tells Windows to not think too hard when interpreting the filename.
rmdir /s /q \\?\H:\Trux\Truxton\55E3AF7109F30CA7
Deleting Folder Structure 2
Sometimes, when expanding archives, folder ownership will be reset. To delete them, you must first take ownership and reset the security.
takeown /a /r /d Y /f D:\Temp
icacls D:\Temp /t /grant administrators:F
rmdir /S /Q D:\Temp
mkdir D:\Temp
Killing Processes
If you have mistakenly started loading a load list, you can stop the Truxton service but the Load.exe processes will still be running.
taskkill /fi "IMAGENAME eq Load.exe" /F
Debugging PostgreSQL
Sorry, too many clients already
We have seen PostgreSQL run out of connections and die (yes, the entire process tree collapses).
It does not matter how many connections it is configured to support.
To help debug this, set the following three items in postgresql.conf file:
log_connections = on log_disconnections = on log_hostname = off
Debugging ETLs
Application is in Break Mode
"Application is in Break Mode" is Microsoftspeak for "Cannot debug because Just My Code is enabled"
When your ETL goes bonkers, you can right button on the process in Task Manager and choose Create Dump File. This will dump the state of your process to your %appdata% temp folder. You can open your project in Visual Studio, then open the DMP file and it will magically take you to the point where the process was. Well, unless you get the "Application is in break mode" message whereby you can do nothing. To fix this, in Visual Studio, go to Debug->Options->General and uncheck "Enable Just My Code"
