SYSCS_DIAG.ERROR_LOG_READER

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

SYSCS_DIAG.ERROR_LOG_READER

Peter Ondruška-4
Dear all,

in 10.13.1.1 (not tested with older) SYSCS_DIAG.ERROR_LOG_READER does not work with database booted in server with -Dderby.stream.error.style=rollingFile.

There are derby.log and derby-0.log in home directory and derby-0.log has error messages which I expect to be always the current log file when rollingFile is used.

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('derby-0.log')) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> ERROR 38000: The exception 'java.sql.SQLException: derby-0.log (No such file or directory)' was thrown while evaluating an expression.
ERROR null: derby-0.log (No such file or directory)
ij> ij> Finished: SUCCESS

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('derby.log')) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> ERROR 38000: The exception 'java.sql.SQLException: derby.log (No such file or directory)' was thrown while evaluating an expression.
ERROR null: derby.log (No such file or directory)
ij> ij> Finished: SUCCESS

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER()) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> TS                           |THREADID                                |XID            |LCCID          |DATABASE                                                                                                                        |DRDAID                                            |LOGTEXT                                                                                                                                                                                                
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 rows selected
ij> ij> Finished: SUCCESS

Under same environment without rollingFile everything works fine and content of derby.log is read.

--
Peter Ondruška

kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269.
Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, Prague 3, 130 00, Czech Republic.
https://www.kaibo.eu
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SYSCS_DIAG.ERROR_LOG_READER

Rick Hillegas-3
Hi Peter,

Thanks for reporting this defect. I have logged https://issues.apache.org/jira/browse/DERBY-6943 to track this issue. There I wondered what the correct behavior should be and I listed 3 options. If you have opinions about what's correct, then please add a comment to that issue.

Thanks,
-Rick

On 6/28/17 3:03 AM, Peter Ondruška wrote:
Dear all,

in 10.13.1.1 (not tested with older) SYSCS_DIAG.ERROR_LOG_READER does not work with database booted in server with -Dderby.stream.error.style=rollingFile.

There are derby.log and derby-0.log in home directory and derby-0.log has error messages which I expect to be always the current log file when rollingFile is used.

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('derby-0.log')) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> ERROR 38000: The exception 'java.sql.SQLException: derby-0.log (No such file or directory)' was thrown while evaluating an expression.
ERROR null: derby-0.log (No such file or directory)
ij> ij> Finished: SUCCESS

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('derby.log')) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> ERROR 38000: The exception 'java.sql.SQLException: derby.log (No such file or directory)' was thrown while evaluating an expression.
ERROR null: derby.log (No such file or directory)
ij> ij> Finished: SUCCESS

SELECT * FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER()) AS T1;
DISCONNECT;
ij version 10.13
ij> ij> ij> TS                           |THREADID                                |XID            |LCCID          |DATABASE                                                                                                                        |DRDAID                                            |LOGTEXT                                                                                                                                                                                                
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

0 rows selected
ij> ij> Finished: SUCCESS

Under same environment without rollingFile everything works fine and content of derby.log is read.

--
Peter Ondruška

kaibo, s.r.o., ID 28435036, registered with the commercial register administered by the Municipal Court in Prague, section C, insert 141269.
Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, Prague 3, 130 00, Czech Republic.
https://www.kaibo.eu


Loading...