org.h2.jdbc.JdbcSQLException: Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via GitHub by camsaul
, 1 year ago
Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192]
via GitHub by pratapsingh
, 1 year ago
Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192]
via GitHub by camsaul
, 1 year ago
Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192]
via GitHub by flyway
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode; SQL statement: null/12e1317cbe458f8e1fa7d1297ab855d46cbe54b4b0f [90020-147]
via raibledesigns.com by Unknown author, 1 year ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-154]
via Google Groups by David Baldin, 2 years ago
NULL not allowed for column "MODEL_ID"; SQL statement: INSERT INTO field (dependent,slug,position,map,localized,name,locked,model_id,target_id,uuid,type,updated_at,model_position,link_id,status_position) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [23502-170]
org.h2.jdbc.JdbcSQLException: Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.ddl.CreateFunctionAlias.update(CreateFunctionAlias.java:42)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at org.h2.tools.RunScript.process(RunScript.java:260)
at org.h2.tools.RunScript.process(RunScript.java:190)
at org.h2.tools.RunScript.process(RunScript.java:328)
at org.h2.tools.RunScript.runTool(RunScript.java:141)
at org.h2.tools.RunScript.main(RunScript.java:68)

Users with the same issue

Once, 1 week ago
Once, 1 week ago
4 times, 2 weeks ago
Once, 3 weeks ago
4 times, 1 month ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.