[IGNITE-18449] Select from a table fails after the table is created

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Labels: ignite-3
• Assignee: Unassigned
• Reporter: Roman Puchkovskiy
• Created: 22/Dec/22 16:48
• Updated: 04/Sep/24 16:19
• Resolved: 14/Oct/23 06:39

Description

The scenario is as follows:

1. Start and init a cluster of 3 nodes
2. Create a table named TEST with 3 replicas via node 0
3. On node 2, execute a query like 'select * from PUBLIC.TEST'

This sometimes causes the following error:

Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'TEST' not found
  at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)
  at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:599)
  ... 25 more

But after some time, a retry of the same query succeeds.

This might have something to do with IGNITE-18203.

Issue Links

• is fixed by: IGNITE-19226 Fetch table schema by timestamp
• is related to: IGNITE-18733 Mechanism to synchronize database schema changes between nodes
• relates to: IGNITE-18079 Integrate RAFT streaming snapshots