[YSQL] System cache inconsistency

[d-uspenskiy]

Jira Link: DB-4792
The following steps can break system cache consistency:

• start RF=3 cluster
• connect ysqlsh to node1 with ./bin/ysqlsh -h 127.0.0.1 (let's name it conn1)
• run CREATE TABLE t(k INT) on conn1
• connect ysqlsh to node2 with ./bin/ysqlsh -h 127.0.0.2 (conn2)
• run SELECT * FROM t on conn2
• start a transaction on conn2 by running BEGIN
• drop the table on conn1 by DROP TABLE t
• run CREATE VIEW v AS SELECT * FROM t on conn1 (it should fail but it doesn't)
• run COMMIT on conn1
• run SELECT * FROM v on conn1 (it fails with the error ERROR: cache lookup failed for relation 16384)