Kbase P126965: SQL92 statements terminate with socket errors and 49 due to permissions issue where -T is pointing t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/03/2010 |
|
Status: Verified
SYMPTOM(s):
Receiving 49 errors when running SQL92 statements against a database
SYSTEM ERROR: Memory violation. (49)
SQL client receives socket errors.
Error: Socket closed. (State:08S01, Native Code: 1D4F)
Error: Server crash likely. (State:S1000, Native Code: FFFFFFFC)
SQL client sometimes returns data prior to receiving socket errors.
Memory violation error appear in database log file.
FACT(s) (Environment):
Databases being used are a copy of Production databases on a different system.
Multiple databases exhibiting the same behavior.
Same SQL92 Statements work fine on databases on Production server.
Database has correct permissions
Progress installation contains valid permissions on "_" (executable files)
WRKDIR has permissions for temporary files to be created.
Databases are being started via a UNIX shell script
UNIX
Progress 9.x
OpenEdge 10.x
CHANGE:
Copied databases from Production Server to Development Server machine.
CAUSE:
The UNIX script called out a parameter file that was using a -T parameter and redirecting temporary files for the database server to a subdirectory within the WRKDIR (Working Directory). Some of the temporary directories did not exist. Some of the temporary directories that did exist, did not have sufficient permissions to allow the temporary files to be created.
FIX:
Ensure that the directory where database temporary files are being redirected to with the -T parameter: exist and have sufficient permissions that allow the creation of files by the process starting the database broker.