Hi all, Recently I have migrated my h2db from verison 1.4.192 to 2.1.210. Every thing works wells and application is started with h2db.mv.db version 2. After some time I noticed that h2 deletes some of the tables by its own. In total I had 14 tables but after some time only 9 remains and 5 got deteled. Below are the tables which got deleted in h2 verison 2
create table if not exists alerting_criteria_violations(id identity, timestamp bigint not null, meta " + H2Schema.BINARY_COLUMN_64K, alerting_incident_id bigint not null, foreign key(alerting_incident_id) references alerting_incidents(id) on delete cascade); create table if not exists config(data " + H2Schema.BINARY_COLUMN_64K + "); create table if not exists user_alert_messengers(id bigint, user_id bigint, data " + H2Schema.BINARY_COLUMN_64K + ",foreign key (user_id) references users(id) on delete cascade); create table if not exists user_alert_services(id bigint, user_id bigint, data " + H2Schema.BINARY_COLUMN_64K + ", foreign key (user_id) references users(id) on delete cascade); create table if not exists user_permissions(user_id bigint, group_id bigint, server_id bigint, permissions smallint, foreign key (user_id) references users(id) on delete cascade, foreign key (group_id) references informix_server_groups(id) on delete cascade, foreign key (server_id) references informix_servers(id) on delete cascade); H2Schema.BINARY_COLUMN_64K = binary(65536) Then I started debug tracing mode and found some logs. Scenario: I opened my h2db.mv.db file with h2 console and ran a wrong query over there and was there on console for some time. After a few minutes, I disconnected from the console and started my application which use to connect with h2db for login information. but my application didn't started. I am attaching the debug logs with scenarios. Please help. Please note while migrating from h2 version 1 to 2 I have also executed some of the alters to create primary key on some tables. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/4a8c97e0-c303-4da8-8423-a7d13c710cf2n%40googlegroups.com.
h2-tables-drop-log
Description: Binary data
