New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Can't see river state #658
Comments
River version is not supported in recent releases. |
@jprante Thanks for you quick reply. is there anyway i can check the last time it indexes the sql table ? I'm trying to make it fetch from database every 1 minute So this is my creating request
However it only run for the first time and never repeats again. |
Which version is this? Please put all JDBC importer parameters inside the If you don't index with a |
Oops ! It works now. Didn't realize it's no login a plugin. I haven't come back to this repo for couple months. Btw. is there any way I can track the SQL queries ? I'm using "select incremental data" method and it response with no rows every time it fetches. Thank you ! |
You can see the executed statements in the log file or console (depends on your logger configuration). The logging of the SQL statements are on level DEBUG so set the output level to DEBUG or TRACE. To enable logging you have to change your local log4j2.xml configuration and be sure that the file is configured at the feeder start script: java -cp "${lib}/*" \
-Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
org.xbib.tools.JDBCImporter Example configuration to display the statements in the log file "logs/jdbc.log" (root logger loglevel changed to DEBUG) <?xml version="1.0" encoding="UTF-8"?>
<configuration status="OFF">
<appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="[%d{ABSOLUTE}][%-5p][%-25c][%t] %m%n"/>
</Console>
<File name="File" fileName="logs/jdbc.log" immediateFlush="true" append="true">
<PatternLayout pattern="[%d{ABSOLUTE}][%-5p][%-25c][%t] %m%n"/>
</File>
</appenders>
<Loggers>
<Root level="debug"> <!--- Changed from INFO to DEBUG!! -->
<AppenderRef ref="File" />
</Root>
<!-- set this level to trace to debug SQL value mapping -->
<Logger name="importer.jdbc.source.standard" level="info">
<appender-ref ref="Console"/>
</Logger>
<Logger name="metrics.source.plain" level="info">
<appender-ref ref="Console"/>
</Logger>
<Logger name="metrics.sink.plain" level="info">
<appender-ref ref="Console"/>
</Logger>
<Logger name="metrics.source.json" level="info">
<appender-ref ref="Console"/>
</Logger>
<Logger name="metrics.sink.json" level="info">
<appender-ref ref="Console"/>
</Logger>
</Loggers>
</configuration> |
Hi all,
I trying to see the state of rivers by access to
http://localhost:9200/_river/jdbc/*/_state?pretty
and
http://localhost:9200/_river/jdbc/service/_state?pretty (My river is called service)
But I get this as result
And
The text was updated successfully, but these errors were encountered: