Segfault-Inc / Multicorn

Data Access Library
https://multicorn.org/
PostgreSQL License
701 stars 145 forks source link

Multicorn completly unresponsive #156

Closed oscardssmith closed 8 years ago

oscardssmith commented 8 years ago

I am working on a foreign data wrapper that uses a shell script to get its data. Everything was working great until I changed part of my foreign data wrapper. The change led to queries not completing, so I undid the changes and re-ran the querries. Nothing happens. I am now unable to run any commands that use multicorn. They throw no errors, but never return. Another multicorn FDW is not working that was never modified. The rest of the database (native sql) is working, as is the shell scrip. Any ideas what could cause this?

oscardssmith commented 8 years ago

It turns out that when a multicorn instance is in an infinite loop, it can't be stopped without force killing the pid from terminal, this arguably should be fixed.