Skip to content
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

CSV Export not working #231

Open
spsijsr-rnd-kunald opened this issue May 23, 2024 · 3 comments
Open

CSV Export not working #231

spsijsr-rnd-kunald opened this issue May 23, 2024 · 3 comments

Comments

@spsijsr-rnd-kunald
Copy link

Upon clicking the CSV Export button the webpage shows that the link is loading and perpetually keeps buffering.

@rtrout
Copy link

rtrout commented Jun 27, 2024

I'm also experiencing this problem. Have only recently added this plugin, so my first time attempting export.

I note the plugin calls URL: /plugin/PrintJobHistory/exportPrintJobHistory/CSV

It appears to just timeout.

Anywhere I can look to post logs?

@vojtakaniok
Copy link

Same here !

Log from octorpint:

2024-12-06 08:11:42,204 - octoprint.server.util.tornado - ERROR - Exception in WSGI application
Traceback (most recent call last):
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint/server/util/tornado.py", line 782, in handle_request
    chunk = await loop.run_in_executor(self.executor, next_chunk)
  File "/usr/lib/python3.7/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint/server/util/tornado.py", line 777, in next_chunk
    return next(app_response_iter)
  File "/home/pi/oprint/lib/python3.7/site-packages/werkzeug/wsgi.py", line 500, in __next__
    return self._next()
  File "/home/pi/oprint/lib/python3.7/site-packages/werkzeug/wrappers/response.py", line 50, in _iter_encoded
    for item in iterable:
  File "/home/pi/oprint/lib/python3.7/site-packages/octoprint_PrintJobHistory/common/CSVExportImporter.py", line 457, in transform2CSV
    for job in allJobsDict:
  File "/home/pi/oprint/lib/python3.7/site-packages/peewee.py", line 4408, in next
    self.cursor_wrapper.iterate()
  File "/home/pi/oprint/lib/python3.7/site-packages/peewee.py", line 4319, in iterate
    row = self.cursor.fetchone()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 1700729952 and this is thread id 1650373728.

@rtrout
Copy link

rtrout commented Dec 7, 2024

Ok, my github detective fu is poor. This version of printjobhistory is abandoned, https://github.com/dojohnso/OctoPrint-PrintJobHistory is the latest fork but also abandoned, but probably where this issue should be reported (if it wasn't abandoned).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants