WARNING: * Monitor: High disk read -virtprof error

Virtuoso Universal Server Tips, Tricks, and HowTos
1

Hi,

Virtuoso SPARQL is not working properly, I have outputs like this during the execution of a COUNT statement:

15:38:34 WARNING: * Monitor: High disk read (1)
15:39:04 INFO: ERRS_0 39000 FA005 **Can't open file 'virtprof.out', error 2**
..................................................................................................................................

Or:

15:02:22 INFO: CSLQ_0 0 Internal Internal xpf-extension DB.DBA.VSPX_CONTROL_EXISTS(?)
15:02:22 INFO: CSLQ_0 0 Internal Internal xpf-extension DB.DBA.VSPX_CONTROL_EXISTS(?)
idem 
idem
...................................................

#top

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

303973 root 20 0 2234028 567936 18772 S 107.6 7.1 27:18.26 virtuoso-t

I think when Virtuoso get TOP %CPU values (107.6) have strange behaviors

2

What is the COUNT query being executed ?

The virtprof.out file is created when the SQL query profiling is enabled with the prof_enable(1) command is run, thus have or did you have this enabled at some point ?

The Internal xpf-extension DB.DBA.VSPX_CONTROL_EXISTS can generally be ignored.

Do you have the Virtuoso trace_on() logging enabled either dynamically via isql or statically by setting in the INI file ?

Can you provide a copy of your INI file (virtuoso.ini) for review ?

3

Hi @hwilliams,

i will post soon the info you have required.

Regards.