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