Hola Emmanuel,Thank you for such a quick answer. I have configured log4j with Debug, but i didn't saw the statements. Attached my log4j, recoverylog and a trace ouput of the error. My Problem is thaht i don't see the statements, maybe i have configured wrong ?
Thank you regards Andreas
Hi Andreas,It looks like the error you get is either a problem with a column name (could you post your recovery log config?) or some encoding of the PreparedStatement that needs to be logged into the recovery log. Could you post the PreparedStatement that you are trying to execute? If you set log4j.logger.org.continuent.sequoia.controller.virtualdatabase.request to DEBUG in log4j.properties, that should log the encoded PreparedStatement that are sent to the recovery log.Thanks for your interest in Sequoia, EmmanuelI was testing a Sequoia setup with one Controller and two Database Backends. All configured with an Oracle 10g Database, also the Recovery Instanz. During my tests if have used the DbVisualizer Version 5.1.1 (License Version) to manipulate the Virtual Database. When i was using the Sql-Window to send update, delete, insert commands everyting works fine. But when i have tried to work with the mouse to select what i want, the following update on Sequoia failed at the Recovery Table. What i have done was to choose inside the Object Menue all Tables. Then i have choosen one Table with "script select all" from this Table. I new sql windows was opened to select everything from the Table [select * from Andreas]. Inside the window the results were shown and on this result i have changed a String Parameter and commited the value. The update on all Databases were done, but with the Recovery i have got the following error message:java.sql.SQLException: ORA-00911: invalid character.The command is stored inside the Recovery Table but it seems that a following update fails? I have switched to Debug Level so see more whats happening, but i didn't saw the sql statements. The only thing i knew is that a perpared statement was send.Well the result is, that sequoia says that the Recovery is corrupted. Is there a possibility to avoid this error ?If not is it possible to find out what sql statements were send to the Recovery Table ?Am i doing something wrong ? Best Regards Andreas Staab ------------------------------------------------------------------------ _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
-- ___________________ Andreas Staab Dolivostrasse 11 D-64293 Darmstadt Germany Telefon: (+49) (0) 61 51 / 81 93 15 Telefax: (+49) (0) 61 51 / 81 93 43 eMail: [email protected] WWW: http://www.mtg.de media transfer AG Firmensitz: Dolivostraße 11, 64293 Darmstadt Registergericht: Amtsgericht Darmstadt, HRB 8901 Vorstand: Dr. Hans-Detlef Schulz, Andrea Klenk, Jürgen Ruf Aufsichtsratsvorsitzender: Dr. Thomas Milde
2009-01-30 15:20:15,645 INFO continuent.sequoia.enduser Database backend
myoracleDB.ebobsydblocal2 is now in state replaying
2009-01-30 15:20:15,678 INFO controller.recoverylog.RecoverThread Starting
recovery
2009-01-30 15:20:15,713 INFO controller.recoverylog.RecoverThread Recovery
completed
2009-01-30 15:20:16,429 INFO continuent.sequoia.enduser Database backend
myoracleDB.ebobsydblocal2 is now in state write-only enabled
2009-01-30 15:20:16,431 INFO continuent.sequoia.enduser Database backend
myoracleDB.ebobsydblocal2 is now in state enabled
2009-01-30 15:20:16,433 INFO controller.recoverylog.RecoverThread Database
backend ebobsydblocal2 is now enabled
2009-01-30 15:20:16,438 INFO continuent.sequoia.enduser Virtual database
myoracleDB successfully enabled from checkpoint on database backend
ebobsydblocal2
2009-01-30 15:24:26,422 ERROR sequoia.controller.recoverylog Failed to log
begin for transaction 0
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,467 ERROR sequoia.controller.recoverylog Failed to log
begin for transaction 0
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,468 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log operation
2009-01-30 15:24:26,468 ERROR sequoia.controller.recoverylog Logger thread was
unable to log LogRequestEvent: Log entry: log id1 (T) transactionId:0
requestId:0 vlogin:user status: S sql:begin params:null because of
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,646 ERROR sequoia.controller.recoverylog Failed to log
commit for transaction 0
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,689 ERROR sequoia.controller.recoverylog Failed to log
commit for transaction 0
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,689 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log operation
2009-01-30 15:24:26,689 ERROR sequoia.controller.recoverylog Logger thread was
unable to log LogRequestEvent: Log entry: log id3 (T) transactionId:0
requestId:0 vlogin:user status: E sql:commit params:null because of
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:24:26,719 ERROR sequoia.controller.recoverylog Recovery log was
unable to update request completion status:
oracle.jdbc.driver.t4cpreparedstatem...@c2b2f6
2009-01-30 15:25:32,075 ERROR sequoia.controller.recoverylog Failed to log
begin for transaction 1
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,119 ERROR sequoia.controller.recoverylog Failed to log
begin for transaction 1
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,120 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log operation
2009-01-30 15:25:32,120 ERROR sequoia.controller.recoverylog Logger thread was
unable to log LogRequestEvent: Log entry: log id4 (T) transactionId:1
requestId:0 vlogin:user status: S sql:begin params:null because of
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,221 ERROR sequoia.controller.recoverylog Failed to log
commit for transaction 1
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,264 ERROR sequoia.controller.recoverylog Failed to log
commit for transaction 1
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,264 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log operation
2009-01-30 15:25:32,264 ERROR sequoia.controller.recoverylog Logger thread was
unable to log LogRequestEvent: Log entry: log id6 (T) transactionId:1
requestId:0 vlogin:user status: E sql:commit params:null because of
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
java.sql.SQLException: ORA-00911: Ungültiges Zeichen
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:104)
at
org.continuent.sequoia.controller.recoverylog.events.LogCommitEvent.execute(LogCommitEvent.java:76)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:678)
2009-01-30 15:25:32,292 ERROR sequoia.controller.recoverylog Recovery log was
unable to update request completion status:
oracle.jdbc.driver.t4cpreparedstatem...@1fe88d
# Set the options for the Console appender.
# Console's layout is a PatternLayout, using the conversion pattern
# %d: current date in ISO8601 format
# %p: priority of the logging event
# %c: category name
# %m: the message
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d{ABSOLUTE} %-5p %c{3} %m\n
# Requests appender is used to log requests received by the controller.
# These log can be automatically replayed using the request player.
log4j.appender.Requests=org.apache.log4j.RollingFileAppender
log4j.appender.Requests.File=${sequoia.log}/request.log
log4j.appender.Requests.MaxFileSize=100MB
log4j.appender.Requests.MaxBackupIndex=5
log4j.appender.Requests.layout=org.apache.log4j.PatternLayout
log4j.appender.Requests.layout.ConversionPattern=%d{ABSOLUTE} %c{1} %m\n
# DistributedRequests appender is used to log distributed request execution at
# each controller. This can be used to track if queries are properly executed
# at all controllers.
log4j.appender.DistributedRequests=org.apache.log4j.RollingFileAppender
log4j.appender.DistributedRequests.File=${sequoia.log}/distributed_request.log
log4j.appender.DistributedRequests.MaxFileSize=100MB
log4j.appender.DistributedRequests.MaxBackupIndex=5
log4j.appender.DistributedRequests.layout=org.apache.log4j.PatternLayout
log4j.appender.DistributedRequests.layout.ConversionPattern=%d{ABSOLUTE} %c{1}
%m\n
# This is for example only, and will send an email if there is '1' message sent
to the log4j
# system with a FATAL level.
# This needs the mail.jar and the activation.jar to be in the classpath,
included in the
# Sequoia binary distribution ...
log4j.appender.email=org.apache.log4j.net.SMTPAppender
log4j.appender.email.BufferSize=1
log4j.appender.email.Threshold=FATAL
log4j.appender.email.from=f...@from
log4j.appender.email.to...@to
log4j.appender.email.smtphost=s...@smtp
log4j.appender.email.Subject=Sequoia
log4j.appender.email.layout=org.apache.log4j.PatternLayout
log4j.appender.email.layout.conversionPattern=%-4r %-5p [%t] %37c %3x
# Additional mail appender configuration
log4j.appender.email.UserName=username
#log4j.appender.email.Password=
#log4j.appender.email.Authenticate= <true> ignore case, if something else than
true, no authentication will be done>
# Filetrace is used for Sequoia log files, this appender is removed from the
log4j system
# if the parameter setFileLogging is set to false in the controller xml
configuration file.
log4j.appender.Filetrace=org.apache.log4j.RollingFileAppender
log4j.appender.Filetrace.File=${sequoia.log}/full_cluster.log
log4j.appender.Filetrace.MaxFileSize=10MB
log4j.appender.Filetrace.MaxBackupIndex=5
log4j.appender.Filetrace.layout=org.apache.log4j.PatternLayout
log4j.appender.Filetrace.layout.ConversionPattern=%d %-5p %c{3} %m\n
log4j.appender.Filetrace.immediateFlush=true
# EndUserFiletrace is used for end-user messages log files
log4j.appender.EndUserFiletrace=org.apache.log4j.RollingFileAppender
log4j.appender.EndUserFiletrace.File=${sequoia.log}/cluster.log
log4j.appender.EndUserFiletrace.MaxFileSize=10MB
log4j.appender.EndUserFiletrace.MaxBackupIndex=5
log4j.appender.EndUserFiletrace.layout=org.apache.log4j.PatternLayout
log4j.appender.EndUserFiletrace.layout.ConversionPattern=%d %-5p %m\n
log4j.appender.EndUserFiletrace.immediateFlush=true
# For remote display of log entries.
log4j.appender.server = org.apache.log4j.net.SocketHubAppender
log4j.appender.server.Port = 9010
# Root logger set to INFO using the Console appender defined above.
log4j.rootLogger=INFO, Console,Filetrace
######################
# Logger definitions #
######################
# Controller #
log4j.logger.org.continuent.sequoia.controller.core.Controller=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.core.Controller=false
# Controller #
log4j.logger.org.continuent.sequoia.controller.core.PingResponder=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.core.PingResponder=false
# XML Parsing #
log4j.logger.org.continuent.sequoia.controller.xml=WARN, Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.xml=false
# Virtual Database #
# to INFO a specific virtual database append the virtual database name. #
# example:
log4j.logger.org.continuent.sequoia.controller.virtualdatabase.mydb=INFO,
Console #
log4j.logger.org.continuent.sequoia.controller.virtualdatabase=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.virtualdatabase=false
log4j.logger.org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread=false
# Request Manager #
log4j.logger.org.continuent.sequoia.controller.RequestManager=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.RequestManager=false
# To trace requests #
log4j.logger.org.continuent.sequoia.controller.virtualdatabase.request=DEBUG,
Requests
log4j.additivity.org.continuent.sequoia.controller.virtualdatabase.request=true
# SQL monitoring (append virtual database name if needed) #
log4j.logger.org.continuent.sequoia.controller.monitoring=INFO, Console
log4j.additivity.org.continuent.sequoia.controller.monitoring=false
# To trace distributed requests #
log4j.logger.org.continuent.sequoia.controller.distributedvirtualdatabase.request=OFF,
DistributedRequests
log4j.additivity.org.continuent.sequoia.controller.distributedvirtualdatabase.request=false
# Backup #
log4j.logger.org.continuent.sequoia.controller.backup=INFO, Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.backup=false
# Scheduler #
log4j.logger.org.continuent.sequoia.controller.scheduler=INFO, Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.scheduler=false
# Cache #
log4j.logger.org.continuent.sequoia.controller.cache=INFO, Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.cache=false
# Load Balancer #
log4j.logger.org.continuent.sequoia.controller.loadbalancer=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.loadbalancer=false
# Connection #
log4j.logger.org.continuent.sequoia.controller.connection=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.connection=false
# Database backend #
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.backend.DatabaseBackend=false
# Recovery Log #
log4j.logger.org.continuent.sequoia.controller.recoverylog=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.recoverylog=false
#log4j.logger.org.continuent.sequoia.controller.recoverylog.recovery.jdbc.loggerthread=INFO,
Console,Filetrace
#log4j.additivity.org.continuent.sequoia.controller.recoverylog.recovery.jdbc.loggerthread=false
#log4j.logger.org.continuent.sequoia.controller.recoverylog.recovery.jdbc=INFO,
Console,Filetrace
#log4j.additivity.org.continuent.sequoia.controller.recoverylog.recovery.jdbc=false
# JMX #
log4j.logger.org.continuent.sequoia.controller.jmx=WARN, Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.jmx=false
# Utils #
log4j.logger.org.continuent.sequoia.common.util.Zipper=OFF, Console
log4j.additivity.org.continuent.sequoia.common.util.Zipper=false
# Commons XML #
log4j.logger.org.continuent.sequoia.common.xml=WARN, Console
log4j.additivity.org.continuent.sequoia.common.xml=false
# EndUser #
log4j.logger.org.continuent.sequoia.enduser=INFO, EndUserFiletrace
log4j.additivity.org.continuent.sequoia.enduser=true
######################################
# Hedera group communication loggers #
######################################
# Hedera channels test #
log4j.logger.test.org.continuent.hedera.channel=INFO, Console, Filetrace
log4j.additivity.test.org.continuent.hedera.channel=false
# Hedera adapters #
log4j.logger.org.continuent.hedera.adapters=INFO, Console, Filetrace
log4j.additivity.org.continuent.hedera.adapters=false
# Hedera factories #
log4j.logger.org.continuent.hedera.factory=INFO, Console, Filetrace
log4j.additivity.org.continuent.hedera.factory=false
# Hedera channels #
log4j.logger.org.continuent.hedera.channel=INFO, Console, Filetrace
log4j.additivity.org.continuent.hedera.channel=false
# Hedera Group Membership Service #
log4j.logger.org.continuent.hedera.gms=INFO, Console, Filetrace
log4j.additivity.org.continuent.hedera.gms=false
# JGroups
log4j.logger.org.jgroups=WARN, Console, Filetrace
log4j.additivity.org.jgroups=false
# JGroups protocols
log4j.logger.org.jgroups.protocols=WARN, Console, Filetrace
log4j.additivity.org.jgroups.protocols=false
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";> <SEQUOIA> <VirtualDatabase name="myoracleDB"> <Monitoring> <SQLMonitoring defaultMonitoring="off"> <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/> </SQLMonitoring> </Monitoring> <Backup> <Backuper backuperName="Octopus" className="org.continuent.sequoia.controller.backup.backupers.ScriptBackuper" options="scriptName=/home/astaab/sequoia/sequoia-2.10.10-bin/config/virtualdatabase/backupscriptas.sh,ignoreStdErrOutput=true"/> </Backup> <AuthenticationManager> <Admin> <User username="admin" password="admin"/> </Admin> <VirtualUsers> <VirtualLogin vLogin="user" vPassword="bob"/> </VirtualUsers> </AuthenticationManager> <DatabaseBackend name="ebobsydblocal1" driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@unterfranke:1522:xe" connectionTestStatement="select * from dual"> <DatabaseSchema dynamicPrecision="table"/> <ConnectionManager vLogin="user" rLogin="ebobsydbseq1" rPassword="bob"> <VariablePoolConnectionManager initPoolSize="5" minPoolSize="2" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <!--url="jdbc:oracle:thin:@unterfranke:1522:xe"--> <DatabaseBackend name="ebobsydblocal2" driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@calliope:1521:tux10db" connectionTestStatement="select * from dual"> <DatabaseSchema dynamicPrecision="table"/> <ConnectionManager vLogin="user" rLogin="ebobsydbseq1" rPassword="bob"> <VariablePoolConnectionManager initPoolSize="5" minPoolSize="2" maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> </ConnectionManager> </DatabaseBackend> <RequestManager> <RequestScheduler> <RAIDb-1Scheduler level="passThrough"/> </RequestScheduler> <RequestCache> <MetadataCache maxNbOfMetadata="0"/> <!-- <MetadataCache/> max ist 10000--> <ParsingCache/> <!-- <ResultCache granularity="table"/> --> </RequestCache> <LoadBalancer> <RAIDb-1> <WaitForCompletion policy="first"/> <RAIDb-1-LeastPendingRequestsFirst/> </RAIDb-1> </LoadBalancer> <!-- url="jdbc:oracle:thin:@unterfranke:1522:xe" login="ebobreposdb" password="bob" recoveryBatchSize="200">--> <!--url="jdbc:oracle:thin:@calliope:1521:tux10db" login="ebobsydbseq2" password="bob" recoveryBatchSize="200">--> <RecoveryLog driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@unterfranke:1522:xe" login="ebobreposdb" password="bob" recoveryBatchSize="200"> <RecoveryLogTable tableName="RECOVERY" logIdColumnType="NUMBER NOT NULL" vloginColumnType="VARCHAR2(255) NOT NULL" sqlColumnType="CLOB" sqlParamColumnType="CLOB" autoConnTranColumnType="VARCHAR2(1) NOT NULL" transactionIdColumnType="NUMBER NOT NULL" requestIdColumnType="NUMBER NOT NULL" execTimeColumnType="NUMBER" updateCountColumnType="NUMBER"/> <CheckpointTable tableName="CHECKPOINT" checkpointNameColumnType="VARCHAR2(255) NOT NULL" logIdColumnType="NUMBER"/> <BackendTable tableName="BACKEND" databaseNameColumnType="VARCHAR2(255) NOT NULL" backendNameColumnType="VARCHAR2(255) NOT NULL" backendStateColumnType="NUMBER" checkpointNameColumnType="VARCHAR2(255)"/> <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR2(255) NOT NULL" dumpDateColumnType="TIMESTAMP" dumpPathColumnType="VARCHAR2(4000) NOT NULL" dumpFormatColumnType="VARCHAR2(255) NOT NULL" checkpointNameColumnType="VARCHAR2(255) NOT NULL" backendNameColumnType="VARCHAR2(255) NOT NULL" tablesColumnType="VARCHAR2(255) NOT NULL"/> </RecoveryLog> </RequestManager> </VirtualDatabase> </SEQUOIA>
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
