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