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.

Sign up for GitHub

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

Jump to bottom

Sync fails: Python int too large for SQL integer #1176

Closed
toth0attila opened this issue May 14, 2020 · 6 comments
Closed

Sync fails: Python int too large for SQL integer #1176

toth0attila opened this issue May 14, 2020 · 6 comments

Comments

@toth0attila
Copy link

toth0attila commented May 14, 2020 •
edited

Plexkodiconnect sync failed when syncing plex database the error message:
pyton int too large for SQL interger

I take a look into plex databes, and i realize that from at time plex stat to give metadata id length from 6 to 10. maybe that is a problem.
image

i check that at a smaller library section (5 item only), which contains 6 lenght and 10 lenght too.
sync fail at the item with lenght 10.

Please give advice what to do with that.

thanks for your great work.
A.
@croneter
Copy link
Owner

Theoretically, the Plex id should be able to up to 9223372036854775807. Please share your entire Kodi DEBUG log file when PKC throws this error, according to https://github.com/croneter/PlexKodiConnect/wiki/How-to-Report-A-Bug

@croneter
Copy link
Owner

croneter commented May 14, 2020 •
edited

My guess is that you somehow botched the Plex database so it'll return a Plex ID that is WAY too high. Try to somehow reset the Plex DB (without losing your watched statuses, resume points, ratings as well as manually set artwork, etc.). E.g.

Do make a backup of your Plex DB before you start messing around!

@toth0attila
Copy link
Author

Thanks, for your quick reply!
I will try it, and let you know, what is the result.

@toth0attila
Copy link
Author

I make a repair process, but the error is the same.
I attach the log.
kodi.log

error in the line 959 for example.

@croneter croneter changed the title Plexkodiconnect failed at sync: pyton int too large for SQL interger Sync fails: Python int too large for SQL integer May 14, 2020
@croneter
Copy link
Owner

croneter commented May 14, 2020 •
edited

Offending log lines:

NOTICE: PLEX.tvshows: ADD tvshow plex_id: 119045 - Inside Ikea
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 114856 - GRAND PRIX Driver
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 119150 - Borbás Marcsi Szakácskönyve
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 114928 - Kinn az orosz vadonban
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120872 - A Duna, Európa Gyöngyszeme
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 119159 - Inside Internet
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120563 - Our Planet
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120383 - Planet Earth
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120884 - Vad Afrika Az élet Folyói S01
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120893 - One Strange Rock
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 123794 - Seven Worlds, One Planet
DEBUG: PLEX.sync.full_sync: Put section in queue with 102 items: {'index': 2, 'name': 'Doku Sorozatok', 'section_id': 32, 'section_type': 'show', 'sync_to_kodi': True, 'last_sync': None}
DEBUG: PLEX.sync.fill_metadata_queue: Process section {'index': 2, 'name': 'Doku Sorozatok', 'section_id': 32, 'section_type': 'show', 'sync_to_kodi': True, 'last_sync': None} with 102 items
NOTICE: PLEX.sync.full_sync: User chose to not sync section {'index': 7, 'name': 'TV Shows', 'section_id': 1, 'section_type': 'show', 'sync_to_kodi': False, 'last_sync': None}
DEBUG: PLEX.sync.full_sync: Exiting threaded_get_generators
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 123858 - Our Planet (2019)
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 120905 - Planet Earth II
DEBUG: PLEX.sync.fill_metadata_queue: Put section in queue with 102 items: {'index': 2, 'name': 'Doku Sorozatok', 'section_id': 32, 'section_type': 'show', 'sync_to_kodi': True, 'last_sync': None}
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 121566 - Wild China
NOTICE: PLEX.tvshows: ADD tvshow plex_id: 1879048330 - Night on Earth
ERROR: PLEX.sync: Exception encountered: Python int too large to convert to SQLite INTEGER
ERROR: PLEX.utils: Error encountered:  - Python int too large to convert to SQLite INTEGER
ERROR: PLEX.utils: _____________________________________________________________
ERROR: PLEX.utils:     Traceback (most recent call last):
ERROR: PLEX.utils:       File "C:\Users\toth0\AppData\Roaming\Kodi\addons\plugin.video.plexkodiconnect\resources\lib\library_sync\common.py", line 32, in run
ERROR: PLEX.utils:         self._run()
ERROR: PLEX.utils:       File "C:\Users\toth0\AppData\Roaming\Kodi\addons\plugin.video.plexkodiconnect\resources\lib\library_sync\process_metadata.py", line 85, in _run
ERROR: PLEX.utils:         children=item['children'])
ERROR: PLEX.utils:       File "C:\Users\toth0\AppData\Roaming\Kodi\addons\plugin.video.plexkodiconnect\resources\lib\itemtypes\tvshows.py", line 282, in add_update
ERROR: PLEX.utils:         last_sync=self.last_sync)
ERROR: PLEX.utils:       File "C:\Users\toth0\AppData\Roaming\Kodi\addons\plugin.video.plexkodiconnect\resources\lib\plex_db\tvshows.py", line 31, in add_show
ERROR: PLEX.utils:         last_sync))
ERROR: PLEX.utils:     OverflowError: Python int too large to convert to SQLite INTEGER
ERROR: PLEX.utils: _____________________________________________________________

1879048330 is WAY larger than the last shows id 121566. But it should still go through, not sure yet why not

@toth0attila
Copy link
Author

hello!

I fix my plex database, and work like a charm.
So this ticket can be closed.
Thanks,
A.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@croneter @toth0attila