JsonNotificationIndexTest

CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
FINE	thread=422	[HttpClient-29-SelectorManager] [42s 464ms] HttpClientImpl(29) SelectorManager shutting down
FINE	thread=421	[HttpClient-28-SelectorManager] [42s 465ms] HttpClientImpl(28) SelectorManager shutting down
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=423	[HttpClient-30-SelectorManager] [42s 492ms] HttpClientImpl(30) SelectorManager shutting down
FINE	thread=424	[HttpClient-31-SelectorManager] [42s 505ms] HttpClientImpl(31) SelectorManager shutting down
FINE	thread=425	[HttpClient-32-SelectorManager] [42s 529ms] HttpClientImpl(32) next timeout: 0
FINE	thread=425	[HttpClient-32-SelectorManager] [42s 529ms] HttpClientImpl(32) next expired: 0
FINE	thread=425	[HttpClient-32-SelectorManager] [42s 529ms] HttpClientImpl(32) Next deadline is 3000
FINER	thread=111	[null] running listener cleanup
Thu Sep 18 21:20:28 UTC 2025
FINE	thread=426	[HttpClient-33-SelectorManager] [42s 742ms] HttpClientImpl(33) SelectorManager shutting down
FINE	thread=427	[HttpClient-34-SelectorManager] [42s 752ms] HttpClientImpl(34) SelectorManager shutting down
FINE	thread=428	[HttpClient-35-SelectorManager] [42s 776ms] HttpClientImpl(35) SelectorManager shutting down
FINE	thread=429	[HttpClient-36-SelectorManager] [42s 789ms] HttpClientImpl(36) SelectorManager shutting down
FINE	thread=430	[HttpClient-37-SelectorManager] [42s 799ms] HttpClientImpl(37) SelectorManager shutting down
FINE	thread=431	[HttpClient-38-SelectorManager] [42s 820ms] HttpClientImpl(38) SelectorManager shutting down
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
FINE	thread=432	[HttpClient-39-SelectorManager] [42s 972ms] HttpClientImpl(39) SelectorManager shutting down
FINE	thread=433	[HttpClient-40-SelectorManager] [42s 983ms] HttpClientImpl(40) SelectorManager shutting down
FINE	thread=434	[HttpClient-41-SelectorManager] [42s 984ms] HttpClientImpl(41) SelectorManager shutting down
FINE	thread=435	[HttpClient-42-SelectorManager] [42s 995ms] HttpClientImpl(42) SelectorManager shutting down
FINE	thread=436	[HttpClient-43-SelectorManager] [43s 29ms] HttpClientImpl(43) next timeout: 0
FINE	thread=436	[HttpClient-43-SelectorManager] [43s 30ms] HttpClientImpl(43) next expired: 0
FINE	thread=436	[HttpClient-43-SelectorManager] [43s 30ms] HttpClientImpl(43) Next deadline is 3000
FINE	thread=437	[HttpClient-44-SelectorManager] [43s 54ms] HttpClientImpl(44) SelectorManager shutting down
FINE	thread=438	[HttpClient-45-SelectorManager] [43s 68ms] HttpClientImpl(45) SelectorManager shutting down
FINE	thread=439	[HttpClient-46-SelectorManager] [43s 89ms] HttpClientImpl(46) SelectorManager shutting down
FINE	thread=440	[HttpClient-47-SelectorManager] [43s 100ms] HttpClientImpl(47) SelectorManager shutting down
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINER	thread=111	[null] running listener cleanup
Thu Sep 18 21:20:29 UTC 2025
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.
FINE	thread=441	[HttpClient-48-SelectorManager] [44s 429ms] HttpClientImpl(48) SelectorManager shutting down
FINE	thread=442	[HttpClient-49-SelectorManager] [44s 444ms] HttpClientImpl(49) SelectorManager shutting down
FINE	thread=443	[HttpClient-50-SelectorManager] [44s 448ms] HttpClientImpl(50) SelectorManager shutting down
FINE	thread=444	[HttpClient-51-SelectorManager] [44s 458ms] HttpClientImpl(51) SelectorManager shutting down
FINE	thread=445	[HttpClient-52-SelectorManager] [44s 467ms] HttpClientImpl(52) SelectorManager shutting down
FINE	thread=446	[HttpClient-53-SelectorManager] [44s 477ms] HttpClientImpl(53) SelectorManager shutting down
FINE	thread=447	[HttpClient-54-SelectorManager] [44s 488ms] HttpClientImpl(54) SelectorManager shutting down
FINE	thread=448	[HttpClient-55-SelectorManager] [44s 488ms] HttpClientImpl(55) SelectorManager shutting down
FINE	thread=449	[HttpClient-56-SelectorManager] [44s 500ms] HttpClientImpl(56) SelectorManager shutting down
FINE	thread=450	[HttpClient-57-SelectorManager] [44s 510ms] HttpClientImpl(57) SelectorManager shutting down
FINE	thread=451	[HttpClient-58-SelectorManager] [44s 519ms] HttpClientImpl(58) SelectorManager shutting down
FINE	thread=452	[HttpClient-59-SelectorManager] [44s 528ms] HttpClientImpl(59) SelectorManager shutting down
FINE	thread=453	[HttpClient-60-SelectorManager] [44s 544ms] HttpClientImpl(60) SelectorManager shutting down
FINE	thread=454	[HttpClient-61-SelectorManager] [44s 558ms] HttpClientImpl(61) next timeout: 0
FINE	thread=454	[HttpClient-61-SelectorManager] [44s 559ms] HttpClientImpl(61) next expired: 0
FINE	thread=454	[HttpClient-61-SelectorManager] [44s 559ms] HttpClientImpl(61) Next deadline is 3000
FINER	thread=111	[null] running listener cleanup
FINE	thread=455	[HttpClient-62-SelectorManager] [44s 589ms] HttpClientImpl(62) SelectorManager shutting down
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
Thu Sep 18 21:20:30 UTC 2025
FINE	thread=164	[null] running event archive policy (testPolicy)
WARNING	thread=164	[null] exception running event archive policy (testPolicy) 
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "gov.usgs.earthquake.indexer.JDBCProductIndex.getConnection()" is null
	at gov.usgs.earthquake.indexer.JDBCProductIndex.getEvents(JDBCProductIndex.java:232)
	at gov.usgs.earthquake.indexer.Indexer.purgeExpiredProducts(Indexer.java:1838)
	at gov.usgs.earthquake.indexer.Indexer$1.run(Indexer.java:1785)
	at java.base/java.util.TimerThread.mainLoop(Timer.java:566)
	at java.base/java.util.TimerThread.run(Timer.java:516)
INFO	thread=164	[null] purged 0 expired events and 0 expired unassociated products.