Problem

When running comprehensive compliance and system test suites for sqlalchemy-spanner, test sessions occasionally encountered "404 Database not found" errors. This happened because:

1. The stale database cleanup script used a 10-minute timeout threshold, which was too aggressive for longer compliance test runs that exceed 10 minutes.
2. Concurrent test runs shared a time-based naming pattern without sufficient uniqueness, leading to potential race conditions where one test run's cleanup deleted another active test run's database.

Solution

1. Updated create_test_database.py to generate session-isolated database names using a truncated timestamp and a random hex suffix (within Spanner's 30-character name limit).
2. Increased the stale database cleanup cutoff threshold to 30 minutes to accommodate long-running test suites safely without risking quota exhaustion.
3. Added active duration logging during teardown in drop_test_database.py to report how long each test database was active.

Notes for Reviewers

• This change prevents premature database dropping during concurrent test execution and provides clear test lifecycle metrics in Nox logs.