The database was locked as a result of trying to script functions

To drop the database, you need to execute in test_09

CLOSE DATABASE
go

(and then you can drop it as

DROP DATABASE test_09
GO

)

(I had to restart the server after)

The message dialog is null means that there is not error message. I changed it to "unknown error" (but canot reproduce it)

The database gets locked while trying to script functions of a newly created database. If we Close the database, I was able to Drop it.

tried to delete in ADS 6.9.78.1 and got the NULL dialog again

32 bit

I tested it on Informix 11 and I sometimes had a problem dropping a database if I previously had an error running something else. 

Please, test it on different versions of Informix.

If i try to Multi script functions and then try to drop the database - i get this error. It seems Multiscripting functions creates some kind of

lock on the tables. Right now, I dont get any error if I multi script objects like functions, but Dropping the database using GUI leads to the NULL pop up

Changed the null to "Unknown error"

As for locking up, it seems to be a server problem

If I drop test_2, then try to open Query Analyzer, I get an exception

java.sql.SQLException: Could not do a physical-order read to fetch next row.
    at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3204)
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
    at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1532)
    at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1471)
    at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1401)
    at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204)
    at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1212)
    at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:202)
    at com.aquafold.aquacore.scripts.ConnectionMetaData.getDatabases(ConnectionMetaData.java:670)
    at com.aquafold.datastudio.queryanalyzer.QueryPanel.initComponents(QueryPanel.java:1510)
    at com.aquafold.datastudio.queryanalyzer.QueryPanel.<init>(QueryPanel.java:290)
    at com.aquafold.datastudio.queryanalyzer.QueryPanel.<init>(QueryPanel.java:270)
    at com.aquafold.datastudio.mainframe.actions.menu.QueryAnalyzer.processAction(QueryAnalyzer.java:254)
    at com.common.ui.frame.actions.CAction.processAction(CAction.java:80)
    at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(ActionHandler.java:1445)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.AbstractButton.doClick(Unknown Source)
    at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(VsnetMenuItemUI.java:1374)
    at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(VsnetMenuItemUI.java:1181)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: ISAM error: record is locked.
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
    ... 41 more

After I refresh the tree, it works fine

Fix verified in build 6.9.88.1