Hi Maxime,
There is a special debug option that can be passed to “isql” on the localhost
machine to enable the PL debugger of an instance:
$ /opt/virtuoso/bin/isql 1111 dba dba -D
OpenLink Interactive PL Debugger (Virtuoso).
Type EXIT to exit, HELP for help
Debug session estabilished to 1111
DEBUG> help
OpenLink Interactive PL Debugger (Virtuoso).
Available commands:
BREAK procedure_name [line number] - Set breakpoint at specified line or PL
function
NEXT - Step program, proceeding through PL subroutine calls.
INFO (THREAD|CLIENT|BREAK) - Generic command for showing things about the
program/process being debugged.
THREADS - Running threads
CLIENTS - Connected SQL/ODBC clients
BREAKPOINTS - Active breakpoints
ATTACH thread_id|client_id - Attach to a running process.
STEP - Step PL program until it reaches a different source line.
LIST [procedure name] [line number] - List specified procedure or line.
WHERE - Print backtrace of all stack frames.
CONTINUE - Continue PL program being debugged after breakpoint.
PRINT variable_name - Print value of variables or arguments.
SET variable_name new_value - Assign a specified value to a variable.
DELETE ([breakpoint_number]|[procedure_name] [line_number]) - Delete some
breakpoints.
FRAME frame_number - Select and print a stack frame.
FINISH - Execute until returns.
UNTIL line_number - Execute until the program reaches a source line greater
than the current.
DEBUG>
DEBUG> info threads
@1111:8 in DB.DBA.RDF_OBJ_FT_RULE_ADD () at -1
DEBUG>
This can perform limited debugging to see of example what threads are running
that might be hanging the server, as the “info threads” command above ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 20 Sep 2011, at 15:07, Maxime Teissèdre wrote:
> Hello,
>
> I'm wondering is there is some kind of privileged connection for specific
> user as done in MySQL, because I'm concerned about people using all available
> connection of the pool, leaving dba user without connection to administrate
> and doing changes. So does virtuoso differentiate standard users and
> administrator.
>
> I thinking about how virtuoso is unable to permit connection when it's under
> heavy-load, as we experienced this issue. Is it something that can be
> work-arounded or that can be fixed ?
>
>
> Regards,
> Maxime T.
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1_______________________________________________
> Virtuoso-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
