2026-04-11 10:48:50 - __main__ - INFO - ============================================================
2026-04-11 10:48:50 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-04-11 10:48:50 - __main__ - INFO - ============================================================
2026-04-11 10:48:50 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate
2026-04-11 10:48:50 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp
2026-04-11 10:48:50 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 10:48:50 - __main__ - WARNING - Download saltato - uso file esistenti in Temp/
2026-04-11 10:48:50 - __main__ - INFO - ============================================================
2026-04-11 10:48:50 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-04-11 10:48:50 - __main__ - INFO - ============================================================
2026-04-11 10:48:50 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-04-11 10:48:54 - src.transformer - INFO -   title_basics: 1,264,057 righe (filtrate per titleType)
2026-04-11 10:48:54 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-04-11 10:49:04 - src.transformer - INFO -   title_akas: 5,321,724 righe (solo region=IT)
2026-04-11 10:49:04 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-04-11 10:49:04 - src.transformer - INFO -   title_ratings: 1,658,155 righe
2026-04-11 10:49:04 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-04-11 10:49:25 - src.transformer - INFO -   title_principals: 31,768,337 righe (director+actor)
2026-04-11 10:49:25 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-04-11 10:49:28 - src.transformer - INFO -   name_basics: 15,225,343 righe
2026-04-11 10:49:28 - src.transformer - INFO - Caricamento OTT da: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_OTT.accdb
2026-04-11 10:50:03 - src.transformer - INFO -   OTT caricata: 326,017 righe
2026-04-11 10:50:03 - src.transformer - INFO - Costruzione new_imdb (step separati)...
2026-04-11 10:50:03 - src.transformer - INFO -   Step 1/5: titoli italiani
2026-04-11 10:50:04 - src.transformer - INFO -   Step 2/5: registi
2026-04-11 10:50:10 - src.transformer - INFO -   Step 3/5: attori
2026-04-11 10:50:19 - src.transformer - INFO -   Step 4/5: OTT latest
2026-04-11 10:50:19 - src.transformer - INFO -   Step 5/5: join finale
2026-04-11 10:50:21 - src.transformer - INFO -   new_imdb: 1,264,057 righe totali, 34,864 con OTT_EMESSO
2026-04-11 10:50:21 - src.transformer - INFO - Scrittura parquet: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 10:50:22 - src.transformer - INFO -   Parquet scritto: 1,264,057 righe, 51.1 MB
2026-04-11 10:50:23 - __main__ - INFO - Transform completato: 1,264,057 righe in parquet
2026-04-11 10:50:28 - __main__ - INFO -   Parquet copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\imdb.parquet
2026-04-11 10:50:28 - __main__ - INFO - ============================================================
2026-04-11 10:50:28 - __main__ - INFO - FASE 4: Export Parquet → MS Access
2026-04-11 10:50:28 - __main__ - INFO - ============================================================
2026-04-11 10:50:28 - src.access_exporter - INFO - Copia template Access: db_split_IMDB.accdb -> db_split_IMDB.accdb
2026-04-11 10:50:28 - src.access_exporter - INFO - Database Access creato: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-11 10:50:28 - src.access_exporter - INFO - Export Parquet -> Access: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb
2026-04-11 10:56:30 - __main__ - ERROR - Errore fatale: ('HY000', '[HY000] [Microsoft][Driver ODBC Microsoft Access] Superato il numero di blocchi per la condivisione di file. Aumentare la voce di registro MaxLocksPerFile. (-1033) (SQLExecDirectW)')
Traceback (most recent call last):
  File "C:\PYTHON\ImdbUpdate\main.py", line 260, in main
    if not export_to_access():
           ^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ImdbUpdate\main.py", line 118, in export_to_access
    exporter.export_parquet_to_access(PARQUET_OUTPUT_PATH, ACCESS_DB_FINAL, "IMDB")
  File "C:\PYTHON\ImdbUpdate\src\access_exporter.py", line 58, in export_parquet_to_access
    total = pta_export({
            ^^^^^^^^^^^^
  File "C:\PYTHON\ParquetToAccess\core\exporter.py", line 211, in export
    total = _export_pyodbc(con, query, target, table, write_cols, col_types, mode)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ParquetToAccess\core\exporter.py", line 82, in _export_pyodbc
    _insert_batch(cur, table, write_cols, batch)
  File "C:\PYTHON\ParquetToAccess\core\exporter.py", line 59, in _insert_batch
    cur.executemany(sql, coerced)
pyodbc.Error: ('HY000', '[HY000] [Microsoft][Driver ODBC Microsoft Access] Superato il numero di blocchi per la condivisione di file. Aumentare la voce di registro MaxLocksPerFile. (-1033) (SQLExecDirectW)')