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=444	[HttpClient-38-SelectorManager] [34s 357ms] HttpClientImpl(38) next timeout: 0
FINE	thread=444	[HttpClient-38-SelectorManager] [34s 357ms] HttpClientImpl(38) next expired: 0
FINE	thread=444	[HttpClient-38-SelectorManager] [34s 357ms] HttpClientImpl(38) Next deadline is 3000
FINE	thread=445	[HttpClient-39-SelectorManager] [34s 364ms] HttpClientImpl(39) next timeout: 0
FINE	thread=445	[HttpClient-39-SelectorManager] [34s 364ms] HttpClientImpl(39) next expired: 0
FINE	thread=445	[HttpClient-39-SelectorManager] [34s 364ms] HttpClientImpl(39) Next deadline is 3000
FINE	thread=447	[HttpClient-41-SelectorManager] [34s 366ms] HttpClientImpl(41) next timeout: 0
FINE	thread=447	[HttpClient-41-SelectorManager] [34s 366ms] HttpClientImpl(41) next expired: 0
FINE	thread=447	[HttpClient-41-SelectorManager] [34s 366ms] HttpClientImpl(41) Next deadline is 3000
FINE	thread=446	[HttpClient-40-SelectorManager] [34s 368ms] HttpClientImpl(40) next timeout: 0
FINE	thread=446	[HttpClient-40-SelectorManager] [34s 368ms] HttpClientImpl(40) next expired: 0
FINE	thread=446	[HttpClient-40-SelectorManager] [34s 368ms] HttpClientImpl(40) Next deadline is 3000
FINE	thread=448	[HttpClient-42-SelectorManager] [34s 372ms] HttpClientImpl(42) next timeout: 0
FINE	thread=448	[HttpClient-42-SelectorManager] [34s 372ms] HttpClientImpl(42) next expired: 0
FINE	thread=448	[HttpClient-42-SelectorManager] [34s 372ms] HttpClientImpl(42) Next deadline is 3000
FINE	thread=449	[HttpClient-43-SelectorManager] [34s 392ms] HttpClientImpl(43) next timeout: 0
FINE	thread=449	[HttpClient-43-SelectorManager] [34s 392ms] HttpClientImpl(43) next expired: 0
FINE	thread=449	[HttpClient-43-SelectorManager] [34s 392ms] HttpClientImpl(43) Next deadline is 3000
FINE	thread=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[null] purged 0 expired events and 0 expired unassociated products.
FINE	thread=450	[HttpClient-44-SelectorManager] [34s 414ms] HttpClientImpl(44) next timeout: 0
FINE	thread=450	[HttpClient-44-SelectorManager] [34s 414ms] HttpClientImpl(44) next expired: 0
FINE	thread=450	[HttpClient-44-SelectorManager] [34s 414ms] HttpClientImpl(44) Next deadline is 3000
Wed Jul 30 21:45:11 UTC 2025
FINER	thread=123	[null] running listener cleanup
FINE	thread=451	[HttpClient-45-SelectorManager] [34s 443ms] HttpClientImpl(45) next timeout: 0
FINE	thread=451	[HttpClient-45-SelectorManager] [34s 443ms] HttpClientImpl(45) next expired: 0
FINE	thread=451	[HttpClient-45-SelectorManager] [34s 443ms] HttpClientImpl(45) Next deadline is 3000
FINE	thread=453	[HttpClient-47-SelectorManager] [34s 449ms] HttpClientImpl(47) next timeout: 0
FINE	thread=453	[HttpClient-47-SelectorManager] [34s 449ms] HttpClientImpl(47) next expired: 0
FINE	thread=453	[HttpClient-47-SelectorManager] [34s 449ms] HttpClientImpl(47) Next deadline is 3000
FINE	thread=452	[HttpClient-46-SelectorManager] [34s 449ms] HttpClientImpl(46) next timeout: 0
FINE	thread=452	[HttpClient-46-SelectorManager] [34s 450ms] HttpClientImpl(46) next expired: 0
FINE	thread=452	[HttpClient-46-SelectorManager] [34s 450ms] HttpClientImpl(46) Next deadline is 3000
FINE	thread=454	[HttpClient-48-SelectorManager] [34s 464ms] HttpClientImpl(48) next timeout: 0
FINE	thread=454	[HttpClient-48-SelectorManager] [34s 464ms] HttpClientImpl(48) next expired: 0
FINE	thread=454	[HttpClient-48-SelectorManager] [34s 464ms] HttpClientImpl(48) Next deadline is 3000
FINE	thread=455	[HttpClient-49-SelectorManager] [34s 464ms] HttpClientImpl(49) next timeout: 0
FINE	thread=455	[HttpClient-49-SelectorManager] [34s 464ms] HttpClientImpl(49) next expired: 0
FINE	thread=455	[HttpClient-49-SelectorManager] [34s 464ms] HttpClientImpl(49) Next deadline is 3000
FINE	thread=456	[HttpClient-50-SelectorManager] [34s 476ms] HttpClientImpl(50) next timeout: 0
FINE	thread=456	[HttpClient-50-SelectorManager] [34s 476ms] HttpClientImpl(50) next expired: 0
FINE	thread=456	[HttpClient-50-SelectorManager] [34s 476ms] HttpClientImpl(50) Next deadline is 3000
FINE	thread=457	[HttpClient-51-SelectorManager] [34s 492ms] HttpClientImpl(51) next timeout: 0
FINE	thread=457	[HttpClient-51-SelectorManager] [34s 493ms] HttpClientImpl(51) next expired: 0
FINE	thread=457	[HttpClient-51-SelectorManager] [34s 493ms] HttpClientImpl(51) Next deadline is 3000
FINE	thread=458	[HttpClient-52-SelectorManager] [34s 508ms] HttpClientImpl(52) next timeout: 0
FINE	thread=458	[HttpClient-52-SelectorManager] [34s 508ms] HttpClientImpl(52) next expired: 0
FINE	thread=458	[HttpClient-52-SelectorManager] [34s 508ms] HttpClientImpl(52) Next deadline is 3000
FINE	thread=459	[HttpClient-53-SelectorManager] [34s 509ms] HttpClientImpl(53) next timeout: 0
FINE	thread=459	[HttpClient-53-SelectorManager] [34s 509ms] HttpClientImpl(53) next expired: 0
FINE	thread=459	[HttpClient-53-SelectorManager] [34s 509ms] HttpClientImpl(53) Next deadline is 3000
FINE	thread=460	[HttpClient-54-SelectorManager] [34s 516ms] HttpClientImpl(54) next timeout: 0
FINE	thread=460	[HttpClient-54-SelectorManager] [34s 516ms] HttpClientImpl(54) next expired: 0
FINE	thread=460	[HttpClient-54-SelectorManager] [34s 516ms] HttpClientImpl(54) Next deadline is 3000
FINE	thread=461	[HttpClient-55-SelectorManager] [34s 516ms] HttpClientImpl(55) next timeout: 0
FINE	thread=461	[HttpClient-55-SelectorManager] [34s 516ms] HttpClientImpl(55) next expired: 0
FINE	thread=461	[HttpClient-55-SelectorManager] [34s 516ms] HttpClientImpl(55) Next deadline is 3000
FINE	thread=462	[HttpClient-56-SelectorManager] [34s 524ms] HttpClientImpl(56) next timeout: 0
FINE	thread=462	[HttpClient-56-SelectorManager] [34s 524ms] HttpClientImpl(56) next expired: 0
FINE	thread=462	[HttpClient-56-SelectorManager] [34s 524ms] HttpClientImpl(56) Next deadline is 3000
FINE	thread=463	[HttpClient-57-SelectorManager] [34s 528ms] HttpClientImpl(57) next timeout: 0
FINE	thread=463	[HttpClient-57-SelectorManager] [34s 528ms] HttpClientImpl(57) next expired: 0
FINE	thread=463	[HttpClient-57-SelectorManager] [34s 528ms] HttpClientImpl(57) Next deadline is 3000
FINE	thread=464	[HttpClient-58-SelectorManager] [34s 540ms] HttpClientImpl(58) next timeout: 0
FINE	thread=464	[HttpClient-58-SelectorManager] [34s 540ms] HttpClientImpl(58) next expired: 0
FINE	thread=464	[HttpClient-58-SelectorManager] [34s 540ms] HttpClientImpl(58) Next deadline is 3000
FINE	thread=465	[HttpClient-59-SelectorManager] [34s 564ms] HttpClientImpl(59) next timeout: 0
FINE	thread=465	[HttpClient-59-SelectorManager] [34s 564ms] HttpClientImpl(59) next expired: 0
FINE	thread=465	[HttpClient-59-SelectorManager] [34s 564ms] HttpClientImpl(59) Next deadline is 3000
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=466	[HttpClient-60-SelectorManager] [34s 588ms] HttpClientImpl(60) next timeout: 0
FINE	thread=466	[HttpClient-60-SelectorManager] [34s 588ms] HttpClientImpl(60) next expired: 0
FINE	thread=466	[HttpClient-60-SelectorManager] [34s 588ms] HttpClientImpl(60) Next deadline is 3000
FINE	thread=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[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
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[null] purged 0 expired events and 0 expired unassociated products.
Wed Jul 30 21:45:12 UTC 2025
FINER	thread=123	[null] running listener cleanup
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=433	[HttpClient-27-SelectorManager] [35s 715ms] HttpClientImpl(27) next timeout: 0
FINE	thread=433	[HttpClient-27-SelectorManager] [35s 715ms] HttpClientImpl(27) next expired: 0
FINE	thread=433	[HttpClient-27-SelectorManager] [35s 715ms] HttpClientImpl(27) Next deadline is 3000
FINE	thread=434	[HttpClient-28-SelectorManager] [35s 720ms] HttpClientImpl(28) next timeout: 0
FINE	thread=434	[HttpClient-28-SelectorManager] [35s 720ms] HttpClientImpl(28) next expired: 0
FINE	thread=434	[HttpClient-28-SelectorManager] [35s 720ms] HttpClientImpl(28) Next deadline is 3000
FINE	thread=435	[HttpClient-29-SelectorManager] [35s 734ms] HttpClientImpl(29) next timeout: 0
FINE	thread=436	[HttpClient-30-SelectorManager] [35s 735ms] HttpClientImpl(30) next timeout: 0
FINE	thread=435	[HttpClient-29-SelectorManager] [35s 735ms] HttpClientImpl(29) next expired: 0
FINE	thread=435	[HttpClient-29-SelectorManager] [35s 735ms] HttpClientImpl(29) Next deadline is 3000
FINE	thread=436	[HttpClient-30-SelectorManager] [35s 735ms] HttpClientImpl(30) next expired: 0
FINE	thread=436	[HttpClient-30-SelectorManager] [35s 735ms] HttpClientImpl(30) Next deadline is 3000
FINE	thread=437	[HttpClient-31-SelectorManager] [35s 745ms] HttpClientImpl(31) next timeout: 0
FINE	thread=437	[HttpClient-31-SelectorManager] [35s 745ms] HttpClientImpl(31) next expired: 0
FINE	thread=437	[HttpClient-31-SelectorManager] [35s 745ms] HttpClientImpl(31) Next deadline is 3000
FINE	thread=438	[HttpClient-32-SelectorManager] [35s 832ms] HttpClientImpl(32) next timeout: 0
FINE	thread=438	[HttpClient-32-SelectorManager] [35s 833ms] HttpClientImpl(32) next expired: 0
FINE	thread=438	[HttpClient-32-SelectorManager] [35s 833ms] HttpClientImpl(32) Next deadline is 3000
FINE	thread=439	[HttpClient-33-SelectorManager] [35s 839ms] HttpClientImpl(33) next timeout: 0
FINE	thread=439	[HttpClient-33-SelectorManager] [35s 839ms] HttpClientImpl(33) next expired: 0
FINE	thread=439	[HttpClient-33-SelectorManager] [35s 839ms] HttpClientImpl(33) Next deadline is 3000
FINE	thread=440	[HttpClient-34-SelectorManager] [35s 843ms] HttpClientImpl(34) next timeout: 0
FINE	thread=440	[HttpClient-34-SelectorManager] [35s 843ms] HttpClientImpl(34) next expired: 0
FINE	thread=440	[HttpClient-34-SelectorManager] [35s 843ms] HttpClientImpl(34) Next deadline is 3000
FINE	thread=441	[HttpClient-35-SelectorManager] [35s 852ms] HttpClientImpl(35) next timeout: 0
FINE	thread=441	[HttpClient-35-SelectorManager] [35s 852ms] HttpClientImpl(35) next expired: 0
FINE	thread=441	[HttpClient-35-SelectorManager] [35s 852ms] HttpClientImpl(35) Next deadline is 3000
FINE	thread=442	[HttpClient-36-SelectorManager] [35s 857ms] HttpClientImpl(36) next timeout: 0
FINE	thread=442	[HttpClient-36-SelectorManager] [35s 857ms] HttpClientImpl(36) next expired: 0
FINE	thread=442	[HttpClient-36-SelectorManager] [35s 857ms] HttpClientImpl(36) Next deadline is 3000
FINE	thread=443	[HttpClient-37-SelectorManager] [35s 866ms] HttpClientImpl(37) next timeout: 0
FINE	thread=443	[HttpClient-37-SelectorManager] [35s 866ms] HttpClientImpl(37) next expired: 0
FINE	thread=443	[HttpClient-37-SelectorManager] [35s 866ms] HttpClientImpl(37) Next deadline is 3000
FINE	thread=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[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
CONFIG	thread=1	[null] driver=org.sqlite.JDBC
CONFIG	thread=1	[null] table=notification
WARNING	thread=1	[null] schema not found, creating
FINE	thread=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[null] purged 0 expired events and 0 expired unassociated products.
Wed Jul 30 21:45:13 UTC 2025
FINER	thread=123	[null] running listener cleanup
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=176	[null] running event archive policy (testPolicy)
WARNING	thread=176	[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=176	[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