'NoneType' object is not subscriptable in rebuild_index function after manual index reindexing

[Andrey3096]

Description

The script encounters a TypeError in the rebuild_index function when processing index rebuilding operations.

How to reproduce

1. Run the bloat analysis script on a PostgreSQL database. I ran with this command
   ./pg_bloat_check.py -c "host=<host> dbname=<db> user=<db_owner>" --bloat_schema=monitoring --format=jsonpretty --min_size='50mb' -N pg_toast --recovery_mode_norun --rebuild_index --debug > report.txt
2. Identify indexes that require rebuilding
3. Manually execute REINDEX INDEX CONCURRENTLY on one or more indexes
   reindex index concurrently idx_large_table_composite; REINDEX
4. Continue with the script's index rebuilding process
   ./pg_bloat_check.py -c "host=<host> dbname=<db> user=<db_owner>" --bloat_schema=monitoring --format=jsonpretty --min_size='50mb' -N pg_toast --recovery_mode_norun --rebuild_index --debug > report.txt
5. Script fails with TypeError
   `Traceback (most recent call last):
   File "/Users/andrey.samsonov/utils/pg_bloat_check/./pg_bloat_check.py", line 747, in
   rebuild_index(conn, result)

File "/Users/andrey.samsonov/utils/pg_bloat_check/./pg_bloat_check.py", line 513, in rebuild_index
quoted_table = """ + result[0] + ""."" + result[1] + """
~~~~~~^^^
TypeError: 'NoneType' object is not subscriptable`

Unfortunately, i didn't come up with a solution but hope for your attention to this issue.

[keithf4]

Just to clarify, are you getting that error while the other indexes are still rebuilding and you run the analysis in parallel with that? Or you're getting the error after the index rebuilding has completed?

[Andrey3096]

the index rebuilt has competed.

In my case

1. I get report.txt file with 3 indexes that need rebuilding
2. Rebuild one of these 3 indexes manually with REINDEX CONCURRENTLY. Rebuilt completed. Two bloat indexes left.
3. Run analysis again.
4. Get an error.