{"action":"created","issue":{"url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/104","repository_url":"https://api.github.com/repos/maxirobaina/django-firebird","labels_url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/104/comments","events_url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/104/events","html_url":"https://github.com/maxirobaina/django-firebird/issues/104","id":390873943,"node_id":"MDU6SXNzdWUzOTA4NzM5NDM=","number":104,"title":"large sets of data","user":{"login":"pszpakowicz","id":45860758,"node_id":"MDQ6VXNlcjQ1ODYwNzU4","avatar_url":"https://avatars3.githubusercontent.com/u/45860758?v=4","gravatar_id":"","url":"https://api.github.com/users/pszpakowicz","html_url":"https://github.com/pszpakowicz","followers_url":"https://api.github.com/users/pszpakowicz/followers","following_url":"https://api.github.com/users/pszpakowicz/following{/other_user}","gists_url":"https://api.github.com/users/pszpakowicz/gists{/gist_id}","starred_url":"https://api.github.com/users/pszpakowicz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pszpakowicz/subscriptions","organizations_url":"https://api.github.com/users/pszpakowicz/orgs","repos_url":"https://api.github.com/users/pszpakowicz/repos","events_url":"https://api.github.com/users/pszpakowicz/events{/privacy}","received_events_url":"https://api.github.com/users/pszpakowicz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-12-13T21:48:38Z","updated_at":"2018-12-13T22:09:58Z","closed_at":null,"author_association":"NONE","body":"When running django-admin with django-firebird on large amount of data, it gives following error:\r\n\r\n('Error while preparing SQL statement:\\n- SQLCODE: -204\\n- Dynamic SQL Error\\n- SQL error code = -204\\n- Implementation limit exceeded\\n- block size exceeds implementation restriction', -204, 335544569)\r\n\r\nSame error when trying to get any object via shell, i.e:\r\n\r\nz = MyModel.object.all()\r\nz[0]\r\ndjango.db.utils.DatabaseError: ('Error while preparing SQL statement:\\n- SQLCODE: -204\\n- Dynamic SQL Error\\n- SQL error code = -204\\n- Implementation limit exceeded\\n- block size exceeds implementation restriction', -204, 335544569)\r\n\r\nor even when counting:\r\nlen(z)\r\n\r\n\r\nany workaround ?"},"comment":{"url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/comments/447138479","html_url":"https://github.com/maxirobaina/django-firebird/issues/104#issuecomment-447138479","issue_url":"https://api.github.com/repos/maxirobaina/django-firebird/issues/104","id":447138479,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NzEzODQ3OQ==","user":{"login":"pszpakowicz","id":45860758,"node_id":"MDQ6VXNlcjQ1ODYwNzU4","avatar_url":"https://avatars3.githubusercontent.com/u/45860758?v=4","gravatar_id":"","url":"https://api.github.com/users/pszpakowicz","html_url":"https://github.com/pszpakowicz","followers_url":"https://api.github.com/users/pszpakowicz/followers","following_url":"https://api.github.com/users/pszpakowicz/following{/other_user}","gists_url":"https://api.github.com/users/pszpakowicz/gists{/gist_id}","starred_url":"https://api.github.com/users/pszpakowicz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pszpakowicz/subscriptions","organizations_url":"https://api.github.com/users/pszpakowicz/orgs","repos_url":"https://api.github.com/users/pszpakowicz/repos","events_url":"https://api.github.com/users/pszpakowicz/events{/privacy}","received_events_url":"https://api.github.com/users/pszpakowicz/received_events","type":"User","site_admin":false},"created_at":"2018-12-13T22:09:58Z","updated_at":"2018-12-13T22:09:58Z","author_association":"NONE","body":"yes it is FB related. query lengts (statement) lenght in this case.\r\nWhen django does MyModel.objects.all() it creates query with all fields in form table_name.column_name. If statement excess build in there is a problem.\r\n\r\nI don't know if it is fixxable on this level or not. If not you can close issue.\r\n\r\nTHX"}}
{"actor":{"display_login":"pszpakowicz"}}