WARN: Failed to read PPC purge ID of .ver file

Help
1

After upgrade from 7.0.14 to 7.1.4 we received several hundred warnings that appear to be related to flushing stale plans:

43203580326 2020-07-15 07:06:28.372 INFO: Evicted 0 plans in 0 seconds
43203582425 2020-07-15 07:06:28.375 WARN: Failed to read PPC purge ID of .ver file
.
.
.
43204713648 2020-07-15 07:06:29.506 WARN: Failed to read PPC purge ID of .ver file
43204714367 2020-07-15 07:06:29.507 WARN: Failed to read PPC purge ID of .ver file
43204715137 2020-07-15 07:06:29.507 INFO: Deleted 6399 stale plans from disk in 1 seconds. Found 0 stale plans on disk that are loaded
into memory.

Can we get an explanation of these warnings?

Thanks,
Marty

2

The warning about PPC purge IDs is because MemSQL did not have PPC purge IDs until version 7.1.

When you upgrade MemSQL, it will remove plans from the old version the first time it starts. That is the cause of the message “Deleted 6399 stale plans from disk in 1 seconds.”

1 Like