Broken pipe
Good morning Scrapers,
We've had SS Pro running on Linux for month now with hardly anything in the error logs but since a couple of days the logs are jammed with error messegaes like:
The error was Connection is broken: SQL was: DELETE FROM scriptinstance WHERE scrapingsessionid = -1 AND scrapeablefileid = -1 AND extractorpatternid = -1 AND httpsessionid = -1
An error occurred while executing the SQL statement. The error was Connection is broken: Broken pipe.
java.sql.SQLException: Connection is broken: Broken pipe
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at com.screenscraper.util.DataMain.executeInsert(DataMain.java:426)
at com.screenscraper.util.DataMain.executeInsert(DataMain.java:454)
at com.screenscraper.data.DScrapingSession.setScriptInstance(DScrapingSession.java:345)
at com.screenscraper.business.BScrapingSession.setScriptInstance(BScrapingSession.java:274)
at com.screenscraper.scraper.ScriptInstance.save(ScriptInstance.java:394)
at com.screenscraper.scraper.ScriptInstances.save(ScriptInstances.java:546)
at com.screenscraper.scraper.ExtractorPattern.save(ExtractorPattern.java:500)
at com.screenscraper.scraper.ScrapeableFile.save(ScrapeableFile.java:2031)
at com.screenscraper.scraper.ScrapingSession.save(ScrapingSession.java:2316)
at com.screenscraper.scraper.ScrapingSessionManager.importScrapingSession(ScrapingSessionManager.java:1010)
at com.screenscraper.scraper.ScrapingSessionManager.importFromReader(ScrapingSessionManager.java:780)
at com.screenscraper.scraper.ScrapingSessionManager.importFromFile(ScrapingSessionManager.java:748)
at com.screenscraper.scraper.ScrapingSessionManager.hotSwapScrapingSessionsFromFiles(ScrapingSessionManager.java:629)
at com.screenscraper.util.General.doFullHotSwapFromFiles(General.java:2911)
at com.screenscraper.scraper.RemoteScrapingSessionHandler.run(RemoteScrapingSessionHandler.java:225)
SQL was: INSERT INTO scriptinstance ( scriptid, scrapingsessionid, scrapeablefileid, extractorpatternid, httpsessionid, sequence, whentorun,enabled) VALUES ( 33, -1, -1, -1, -1, 1, 80, 1)
An error occurred while executing the SQL statement. The error was Connection is broken: Broken pipe.
java.sql.SQLException: Connection is broken: Broken pipe
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at com.screenscraper.util.DataMain.executeDelete(DataMain.java:539)
at com.screenscraper.util.DataMain.executeDelete(DataMain.java:582)
at com.screenscraper.data.DScrapingSession.deleteExtractorPatternTokens(DScrapingSession.java:864)
at com.screenscraper.business.BScrapingSession.deleteExtractorPatternTokens(BScrapingSession.java:604)
at com.screenscraper.scraper.ExtractorPattern.save(ExtractorPattern.java:504)
at com.screenscraper.scraper.ScrapeableFile.save(ScrapeableFile.java:2031)
at com.screenscraper.scraper.ScrapingSession.save(ScrapingSession.java:2316)
at com.screenscraper.scraper.ScrapingSessionManager.importScrapingSession(ScrapingSessionManager.java:1010)
at com.screenscraper.scraper.ScrapingSessionManager.importFromReader(ScrapingSessionManager.java:780)
at com.screenscraper.scraper.ScrapingSessionManager.importFromFile(ScrapingSessionManager.java:748)
at com.screenscraper.scraper.ScrapingSessionManager.hotSwapScrapingSessionsFromFiles(ScrapingSessionManager.java:629)
at com.screenscraper.util.General.doFullHotSwapFromFiles(General.java:2911)
at com.screenscraper.scraper.RemoteScrapingSessionHandler.run(RemoteScrapingSessionHandler.java:225)
SQL was: DELETE FROM extractorpatterntoken WHERE extractorpatternid = -1
++++++
I would appreciate a hand in interpreting these. The only thing I can recall that could have caused this is a server reboot that occurred at about the same time as these errors started to show.
No need
to answer this one. I found the error which was due to that the SS daemon was initiated by another user (on server reboot) than the one that invoke the scrapes. The daemon does not like that for some reason.