ValueError: too many values to unpack

[movermeyer]

Traceback (most recent call last):
  <some lines elided for privacy>
  File "C:\Python27\lib\site-packages\firebirdsql\fbcore.py", line 367, in fetchall
    return [tuple(r) for r in self._fetch_records]
  File "C:\Python27\lib\site-packages\firebirdsql\fbcore.py", line 192, in _fetch_generator
    stmt.handle, stmt.xsqlda)
ValueError: too many values to unpack

This is a result of this line in fbcore.py:

(rows, more_data) = connection._op_fetch_response(stmt.handle, stmt.xsqlda)

Which assumes that there are only 2 values returned. However, _op_fetch_response() can return 3 values since it can return the result of _parse_op_response() (line 780 of wireprotocol.py).

[nakagami]

Thanks, I understand that code has something wrong.

I want test code, Can you show a sample code ?

[movermeyer]

I've managed to produce a simple enough test case that demonstrates the issue.

1. Create a new database
2. Run the SQL commands found here.
3. Run the Python script found here against the database.

Note that it fails if you try to select more than 400 BLOBs.

Tested using

• pyfirebirdsql 0.9.8
• Firebird SQL 2.5.4.26856, 64 bit

[nakagami]

Thank you.
I have released 0.9.9 just now.
Please test with it.

[movermeyer]

The commit you made to fix this introduced an infinite loop.

1. Create a new database
2. Run the SQL commands found here.
3. Run the Python script found here against the database.

Tested using

• pyfirebirdsql 0.9.8
• Firebird SQL 2.5.4.26856, 64 bit
• Windows 7 Pro

[nakagami]

I am certain of this problem.

[nakagami]

Probably fixed at version 0.9.11
I want to know your result

[movermeyer]

It now seems to work. My program is once again working without issue (for the first time since before 0.9.2).

:)