Hai Sreejith, What you asked requires digging into the internals of monetdb deep in its core. Such information is usually hidden from users, because it changes from time to time. 11.27.3 is a very old version. I’m not 100% sure, but the catalogue has probably changed in the meantime. In addition, it’s summer holiday time. Alternatively: i) have you tried upgrading version by version, i.e. July2017 => March2018 => Aug2018 => Apr2019? ii) Actually, it’s more advisable to make an SQL dump of your database, and reload it into a fresh Apr2019 database. iii) We’re working on a bugfix release for Apr2019, which contains some major improvements for db stability. Unless you’re in a big hurry to upgrade, you can wait for this bugfix release. Regards, Jennie

On 6 Aug 2019, at 10:35, Sharma, Sreejith <Sreejith.Sharma@harman.com> wrote:

Any help here?

From: users-list <users-list-bounces+sreejith.sharma=harman.com@monetdb.org> On Behalf Of Sharma, Sreejith Sent: Friday, August 02, 2019 12:31 PM To: Communication channel for MonetDB users <users-list@monetdb.org> Subject: [EXTERNAL] Question on missing BAT file

All,

Is there a way to figure out which BAT files constitutes a specific table in MonetDB?

I know the location in sys.storage represents it, but I see one of the tail file is showing missing which is not available neither in sys.storage not in DB folder.

We get this error during migration from older version (MonetDB 11.27.3) to MonetDB 11.33.3 version.

2019-07-31 10:43:54 MSG TSV_PROD_DB_A[161617]: !ERROR: BBPcheckbats: cannot stat file /monet_data01/DBFARM_TSV/TSV_PROD_DB_A/bat/10/45/104502.tail

Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list