How to fix a "cycle in groups"
Run following query in the database:
update groups set groupid = null where id = groupid;Thank you! I am getting
update groups set groupid = null where id = groupid;
Table "GROUPS" not found; SQL statement:
update groups set groupid = null where id = groupid [42102-195] 42S02/42102
What am I doing wrong? Sorry for my ignorance ...
jdbc:h2:~/database.mv
INFORMATION_SCHEMA
CATALOGS
COLLATIONS
COLUMNS
COLUMN_PRIVILEGES
CONSTANTS
CONSTRAINTS
CROSS_REFERENCES
DOMAINS
FUNCTION_ALIASES
FUNCTION_COLUMNS
HELP
INDEXES
IN_DOUBT
LOCKS
QUERY_STATISTICS
RIGHTS
ROLES
SCHEMATA
SEQUENCES
SESSIONS
SESSION_STATE
SETTINGS
TABLES
TABLE_PRIVILEGES
TABLE_TYPES
TRIGGERS
TYPE_INFO
USERS
VIEWS
Benutzer
SA
H2 1.4.195 (2017-04-23)
You are looking at the wrong schema.
Where is the right schema?
I used c:\Program Files\Traccar\data\database.mv.db
What schemas do you have?
I have the following files in c:\Program Files\Traccar\data.
database.trace.db
database.mv.db
I am not talking about files. I am talking about schemas in the database.
Sorry, do you mean:
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME IS_DEFAULT REMARKS ID
DATABASE.MV INFORMATION_SCHEMA SA Unicode OFF FALSE -1
DATABASE.MV PUBLIC SA Unicode OFF TRUE 0or
SELECT * FROM INFORMATION_SCHEMA.TABLES;
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE STORAGE_TYPE SQL REMARKS LAST_MODIFICATION ID TYPE_NAME TABLE_CLASS ROW_COUNT_ESTIMATE
DATABASE.MV INFORMATION_SCHEMA FUNCTION_COLUMNS SYSTEM TABLE CACHED null 5 -22 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA CONSTANTS SYSTEM TABLE CACHED null 5 -23 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA SEQUENCES SYSTEM TABLE CACHED null 5 -9 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA RIGHTS SYSTEM TABLE CACHED null 5 -12 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA TRIGGERS SYSTEM TABLE CACHED null 5 -25 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA CATALOGS SYSTEM TABLE CACHED null 5 -6 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA CROSS_REFERENCES SYSTEM TABLE CACHED null 5 -20 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA SETTINGS SYSTEM TABLE CACHED null 9223372036854775807 -7 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA FUNCTION_ALIASES SYSTEM TABLE CACHED null 5 -13 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA VIEWS SYSTEM TABLE CACHED null 5 -18 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA TYPE_INFO SYSTEM TABLE CACHED null 5 -5 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA CONSTRAINTS SYSTEM TABLE CACHED null 5 -21 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA COLUMNS SYSTEM TABLE CACHED null 5 -2 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA LOCKS SYSTEM TABLE CACHED null 9223372036854775807 -27 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA DOMAINS SYSTEM TABLE CACHED null 5 -24 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA SCHEMATA SYSTEM TABLE CACHED null 5 -14 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA COLUMN_PRIVILEGES SYSTEM TABLE CACHED null 5 -16 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA HELP SYSTEM TABLE CACHED null 5 -8 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA SESSION_STATE SYSTEM TABLE CACHED null 9223372036854775807 -28 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA TABLE_PRIVILEGES SYSTEM TABLE CACHED null 5 -15 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA TABLE_TYPES SYSTEM TABLE CACHED null 5 -4 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA TABLES SYSTEM TABLE CACHED null 5 -1 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA QUERY_STATISTICS SYSTEM TABLE CACHED null 5 -29 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA ROLES SYSTEM TABLE CACHED null 5 -11 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA SESSIONS SYSTEM TABLE CACHED null 9223372036854775807 -26 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA IN_DOUBT SYSTEM TABLE CACHED null 9223372036854775807 -19 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA USERS SYSTEM TABLE CACHED null 5 -10 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA COLLATIONS SYSTEM TABLE CACHED null 5 -17 null org.h2.table.MetaTable 1000
DATABASE.MV INFORMATION_SCHEMA INDEXES SYSTEM TABLE CACHED null 5 -3 null org.h2.table.MetaTable 1000I am talking about database schema. What you are looking at is INFORMATION_SCHEMA which is a system schema that you shouldn't touch. You should look at the PUBLIC schema which contains Traccar database.
Sorry, I am somehow lost ...
How to see the PUBLIC schema?
Which file do I have to open with H2 Console?
Why am I not seeing the PUBLIC schema?
I don't know. Probably the issue with the tool that you are using. I believe I have provided enough information to solve the problem. If you have some problems with tools, then this is not the right place to ask. I'm sure there is plenty of information online.
Thank you for your great and speedy help!
Hello,
Please help with detailed instructions how to fix a "cycle in groups" problem.
I am getting ...
I searched the forum and found "cycle in groups" comments, then tried to use H2 Console with database.mv but fail to locate and edit the respective data.
Please, please advise as I'm afraid to lose my data, i.e. can't afford to wipe the database.
Thank you in advance!