2025-09-30 10:00:00.150 [main] INFO  com.example.db.DatabaseService - Database service initializing
2025-09-30 10:00:00.300 [main] INFO  com.example.db.ConnectionPool - Creating connection pool (min: 5, max: 20)
2025-09-30 10:00:01.230 [main] INFO  com.example.db.ConnectionPool - Connection pool initialized with 5 connections
2025-09-30 10:00:01.570 [main] INFO  com.example.db.DatabaseService - Database service ready
2025-09-30 10:00:05.890 [query-executor-1] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM users WHERE active = true
2025-09-30 10:00:06.015 [query-executor-1] DEBUG com.example.db.QueryExecutor - Query executed in 125ms, returned 42 rows
2025-09-30 10:00:08.678 [query-executor-2] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM users WHERE email = ?
2025-09-30 10:00:08.889 [query-executor-2] DEBUG com.example.db.QueryExecutor - Query executed in 211ms, returned 1 row
2025-09-30 10:00:12.456 [query-executor-3] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM products WHERE name LIKE '%laptop%'
2025-09-30 10:00:12.677 [query-executor-3] DEBUG com.example.db.QueryExecutor - Query executed in 221ms, returned 15 rows
2025-09-30 10:00:15.234 [query-executor-4] DEBUG com.example.db.QueryExecutor - Starting transaction for order insertion
2025-09-30 10:00:15.456 [query-executor-4] DEBUG com.example.db.QueryExecutor - Executing: INSERT INTO orders (customer_id, total, status) VALUES (?, ?, ?)
2025-09-30 10:00:15.567 [query-executor-4] DEBUG com.example.db.QueryExecutor - Executing: INSERT INTO order_items (order_id, product_id, quantity, price) VALUES (?, ?, ?, ?)
2025-09-30 10:00:15.678 [query-executor-4] INFO  com.example.db.QueryExecutor - Batch insert: 127 items inserted
2025-09-30 10:00:15.789 [query-executor-4] DEBUG com.example.db.QueryExecutor - Transaction committed successfully
2025-09-30 10:00:18.456 [maintenance-1] INFO  com.example.db.Maintenance - Running cache cleanup task
2025-09-30 10:00:18.567 [maintenance-1] DEBUG com.example.db.CacheManager - Analyzing 5,432 cache entries
2025-09-30 10:00:18.678 [maintenance-1] INFO  com.example.db.CacheManager - Evicted 234 expired entries
2025-09-30 10:00:22.234 [query-executor-5] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM payment_gateway_config WHERE gateway_id = ?
2025-09-30 10:00:22.345 [query-executor-5] DEBUG com.example.db.QueryExecutor - Query executed in 111ms, returned 1 row
2025-09-30 10:00:22.567 [query-executor-5] WARN  com.example.db.ConnectionPool - Connection timeout detected, creating new connection
2025-09-30 10:00:27.890 [query-executor-5] ERROR com.example.db.ConnectionPool - Failed to create new database connection
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
    at com.example.db.ConnectionPool.createConnection(ConnectionPool.java:178)
2025-09-30 10:00:27.901 [query-executor-5] WARN  com.example.db.ConnectionPool - Retrying connection (attempt 1/3)
2025-09-30 10:00:33.234 [query-executor-5] ERROR com.example.db.ConnectionPool - Failed to create new database connection (attempt 1)
2025-09-30 10:00:33.345 [query-executor-5] WARN  com.example.db.ConnectionPool - Retrying connection (attempt 2/3)
2025-09-30 10:00:38.678 [query-executor-5] ERROR com.example.db.ConnectionPool - Failed to create new database connection (attempt 2)
2025-09-30 10:00:38.789 [query-executor-5] WARN  com.example.db.ConnectionPool - Retrying connection (attempt 3/3)
2025-09-30 10:00:38.890 [query-executor-5] ERROR com.example.db.ConnectionPool - Failed to create new database connection after 3 attempts
2025-09-30 10:00:42.234 [query-executor-6] DEBUG com.example.db.QueryExecutor - Executing: SELECT SUM(total) as revenue, COUNT(*) as orders FROM orders WHERE created_at >= ? AND created_at < ?
2025-09-30 10:00:42.567 [query-executor-6] DEBUG com.example.db.QueryExecutor - Executing complex aggregate query
2025-09-30 10:00:45.890 [query-executor-6] INFO  com.example.db.QueryExecutor - Aggregate query executed in 3.656s, processed 12,345 rows
2025-09-30 10:00:50.345 [rate-monitor] WARN  com.example.db.Monitor - High query rate detected: 45 queries/second
2025-09-30 10:00:51.678 [rate-monitor] ERROR com.example.db.Monitor - Query rate limit exceeded: 52 queries/second (limit: 50)
2025-09-30 10:00:51.789 [rate-monitor] INFO  com.example.db.Monitor - Enabling query throttling for 60 seconds
2025-09-30 10:01:00.123 [health-check] INFO  com.example.db.HealthCheck - Running database health check
2025-09-30 10:01:00.234 [health-check] DEBUG com.example.db.HealthCheck - Connection pool status: 18/20 connections in use
2025-09-30 10:01:00.345 [health-check] DEBUG com.example.db.HealthCheck - Query response time: avg 245ms, p95 1234ms
2025-09-30 10:01:00.456 [health-check] DEBUG com.example.db.HealthCheck - Cache hit ratio: 78.4%
2025-09-30 10:01:00.567 [health-check] WARN  com.example.db.HealthCheck - Slow query detected: avg response time above threshold
2025-09-30 10:01:00.678 [health-check] INFO  com.example.db.HealthCheck - Overall database health: DEGRADED
2025-09-30 10:01:15.234 [query-executor-7] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM large_table WHERE conditions...
2025-09-30 10:01:15.345 [query-executor-7] INFO  com.example.db.QueryExecutor - Large result set query: fetching 50,000 rows
2025-09-30 10:01:18.567 [query-executor-7] DEBUG com.example.db.QueryExecutor - Query executed in 3.333s
2025-09-30 10:01:25.890 [maintenance-2] INFO  com.example.db.BackupTask - Starting database backup
2025-09-30 10:01:26.012 [maintenance-2] DEBUG com.example.db.BackupTask - Creating snapshot: backup-2025-09-30-10-01
2025-09-30 10:01:26.234 [maintenance-2] INFO  com.example.db.BackupTask - Backup in progress (0%)
2025-09-30 10:01:30.456 [maintenance-2] INFO  com.example.db.BackupTask - Backup in progress (25%)
2025-09-30 10:01:35.678 [maintenance-2] INFO  com.example.db.BackupTask - Backup in progress (50%)
2025-09-30 10:01:40.890 [maintenance-2] INFO  com.example.db.BackupTask - Backup in progress (75%)
2025-09-30 10:01:45.234 [maintenance-2] INFO  com.example.db.BackupTask - Backup completed: 245MB compressed
2025-09-30 10:02:00.123 [query-executor-8] DEBUG com.example.db.QueryExecutor - Executing: INSERT INTO files (name, size, hash) VALUES (?, ?, ?)
2025-09-30 10:02:00.234 [query-executor-8] ERROR com.example.db.QueryExecutor - Constraint violation: file size exceeds maximum
2025-09-30 10:02:05.567 [query-executor-9] DEBUG com.example.db.QueryExecutor - Starting batch notification insert
2025-09-30 10:02:05.678 [query-executor-9] DEBUG com.example.db.QueryExecutor - Inserting 1,234 notification records
2025-09-30 10:02:08.890 [query-executor-9] INFO  com.example.db.QueryExecutor - Batch insert completed in 3.323s
2025-09-30 10:02:15.345 [query-executor-10] DEBUG com.example.db.QueryExecutor - Executing: SELECT * FROM search_index WHERE terms MATCH ?
2025-09-30 10:02:15.456 [query-executor-10] DEBUG com.example.db.QueryExecutor - Full-text search executed in 111ms, returned 23 rows
2025-09-30 10:02:20.890 [main] INFO  com.example.db.DatabaseService - Shutdown signal received
2025-09-30 10:02:21.012 [main] INFO  com.example.db.DatabaseService - Closing all active queries (5 active)
2025-09-30 10:02:23.567 [main] INFO  com.example.db.ConnectionPool - Closing all database connections
2025-09-30 10:02:23.678 [main] INFO  com.example.db.DatabaseService - Database service shutdown complete