How to close the debug info?

[cookeem]

Debug sql info like this, how to close it?

10:54:10.023 [system-akka.persistence.dispatchers.default-plugin-dispatcher-5] DEBUG s.async.AsyncConnectionPool$ - Borrowed a new connection from scalikejdbc.async.internal.mysql.MySQLConnectionPoolImpl@1ed13381
[WARN] [01/08/2016 10:54:10.024] [system-akka.persistence.dispatchers.default-plugin-dispatcher-6] [akka.serialization.Serialization(akka://system)] Using the default Java serializer for class [actor.PersistenceBasicObj$ExampleState] which is not recommended because of performance implications. Use another serializer or disable this warning using the setting 'akka.actor.warn-about-java-serializer-usage'
10:54:10.031 [system-akka.persistence.dispatchers.default-plugin-dispatcher-6] DEBUG s.async.AsyncConnectionPool$ - Borrowed a new connection from scalikejdbc.async.internal.mysql.MySQLConnectionPoolImpl@1ed13381
10:54:10.038 [system-akka.persistence.dispatchers.default-plugin-dispatcher-5] DEBUG scalikejdbc.async.TxAsyncDBSession - [SQL Execution] 'INSERT INTO test_journal (persistence_key, sequence_nr, message) VALUES (?, ?, ?)' with (2,11,[B@6d8b440c)
10:54:10.043 [system-akka.persistence.dispatchers.default-plugin-dispatcher-6] DEBUG scalikejdbc.async.TxAsyncDBSession - [SQL Execution] 'INSERT INTO test_snapshot (persistence_key, sequence_nr, created_at, snapshot) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE created_at = ?, snapshot = ?' with (2,10,1452221650023,[B@beaa9fc,1452221650023,[B@beaa9fc)
10:54:10.046 [system-akka.persistence.dispatchers.default-plugin-dispatcher-5] DEBUG s.async.AsyncConnectionPool$ - Borrowed a new connection from scalikejdbc.async.internal.mysql.MySQLConnectionPoolImpl@1ed13381
10:54:10.055 [system-akka.persistence.dispatchers.default-plugin-dispatcher-5] DEBUG scalikejdbc.async.TxAsyncDBSession - [SQL Execution] 'INSERT INTO test_journal (persistence_key, sequence_nr, message) VALUES (?, ?, ?)' with (2,12,[B@7fb8247f)

[okumin]

@cookeem akka-persistence-sql-async logs information by using ActorLogging.
So you can configure the loglevel in application.conf.

Please refer to this sample.

[cookeem]

Hi okumin, thanks for your reply, but I have already set akka.loglevel = "WARNING" or akka.loglevel = "INFO",but the log still show there. My akka version: 2.4.1, scala version: 2.11.7.

Here is my application.conf:

akka.log-dead-letters = off
akka.loglevel = "WARNING"
akka.actor {
provider = "akka.cluster.ClusterActorRefProvider"
}
akka {
remote {
log-remote-lifecycle-events = off
netty.tcp {
hostname = "localhost"
port = 0
}
}
cluster {
seed-nodes = [
"akka.tcp://cluster@localhost:2551"]
auto-down-unreachable-after = 10s
}
}
akka.persistence {
journal.plugin = "akka-persistence-sql-async.journal"
snapshot-store.plugin = "akka-persistence-sql-async.snapshot-store"
}
akka-persistence-sql-async {
journal.class = "akka.persistence.journal.sqlasync.MySQLAsyncWriteJournal"
snapshot-store.class = "akka.persistence.snapshot.sqlasync.MySQLSnapshotStore"
user = "root"
password = "password"
url = "jdbc:mysql://localhost/akka_persistence"
max-pool-size = 4
wait-queue-capacity = 10000
metadata-table-name = "test_metadata"
journal-table-name = "test_journal"
snapshot-table-name = "test_snapshot"
}

[okumin]

@cookeem I have tried that configuration, but it seems to work correctly.

akka-persistence-sql-async-sample

Debug logs appear on logging-debug project, but not on logging-warning project.
I tried on sbt console.

Could you try to reproduce the problem on akka-persistence-sql-async-sample and show me that code?