Error 12334

Severity

21

Message text

Attempts to read logical page `%ld`, virtpage `%ld` from virtual device `%d` for %S_PTNINFO failed due to read failure in prefetch. Please contact Sybase Technical Support.

Explanation

A problem occurred when another process tried to read the indicated page asynchronously. Adaptive Server will retry this operation 10 times, then raise a 12334 error.

Action

It may be possible that some other process is taking an excessive amount of time while accessing the indicated page. Check either the sysprocesses.cpu field. For example:

select top 20 spid,status,program_name,cpu 
     from master..sysprocesses
order by cpu desc

Or, if you have Monitoring and Diagnostic (MDA) tables installed, check the monProcessActivity.CPUTime field to check for jobs with high CPU usage. For example:

select top 20 a.SPID, a.CPUTime, b.Application, b.Command
     from master..monProcessActivity a, master..monProcess b
     where a.SPID = b.SPID
order by a.CPUTime desc

Examine any jobs with unexpectedly high cpu usage to see what they are doing. When any problems are corrected, re-run the affected query.

Additional information

If error 12333 persists, it may be necessary to gather a configurable shared memory dump (CSMD). See “Obtaining a CSMD” in the Troubleshooting and Disaster Recovery guide section “Other Useful Tasks.”

Versions in which this error is raised

Version 15.0 and later