• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Migrations and Pooling - Exception
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migrations and Pooling - Exception

  • Subject: Re: Migrations and Pooling - Exception
  • From: Stefan Klein <email@hidden>
  • Date: Thu, 23 Sep 2010 09:47:15 +0200
Hi Farrukh,

my first guess is, that the db user you are using does not have write permissions.

On the other hand I had the same exceptions playing with ERMigration and MaxDB:

1) MaxDB doesn't like the table name _dbupdater (only with surrounded ")
2) Tried er.migration.JDBC.dbUpdaterTableName=DBUPDATESTATE in the Properties file
3) Stumbled in uppercase - lowercase pitfall
4) Created table DBUPDATER via sql

CREATE TABLE DBUPDATESTATE (
    lockowner VARCHAR(100),
    modelname VARCHAR(100) NOT NULL,
    updatelock INTEGER NOT NULL,
    version INTEGER NOT NULL);
//.
ALTER TABLE DBUPDATESTATE ADD PRIMARY KEY (modelname)
//.

insert into DBUPDATESTATE (modelname, version, updatelock, lockowner) values ('YourModelName', -1, 0, NULL)

5) That works

Stefan

Am 23.09.10 08:55, schrieb Farrukh Ijaz:
Hi,

During the conversion process for Migration, I've started facing issue for one of our frameworks where in the Properties file following properties are defined:

er.extensions.ERXJDBCAdaptor.className=er.extensions.jdbc.ERXJDBCAdaptor
er.extensions.ERXJDBCAdaptor.useConnectionBroker = true

dbMinConnectionsGLOBAL=1
dbMaxConnectionsGLOBAL=5
dbMaxCheckoutGLOBAL=600
dbDebugLevelGLOBAL=3

However if my project use this framework, the Migrations fail with following exception:

ERROR: relation "_dbupdater" does not existat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:263)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:176)
at er.extensions.jdbc.ERXJDBCAdaptor$Channel.updateValuesInRowsDescribedByQualifier(ERXJDBCAdaptor.java:278)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:93)
at er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...

at com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel(JDBCContext.java:170)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:344)
at com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:176)
at er.extensions.jdbc.ERXJDBCAdaptor$Channel.updateValuesInRowsDescribedByQualifier(ERXJDBCAdaptor.java:278)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:93)
at er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
2010-09-23 09:49:08,200 ERROR QSTPTRMS[-:12345 0] er.extensions.appserver.ERXApplication (ERXApplication.java:1301)  - QSTPTRMS failed to start.
 er.extensions.migration.ERXMigrationFailedException: Failed to create lock table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100)  NOT NULL, updatelock int4  NOT NULL, version int4  NOT NULL);

.
at er.extensions.migration.ERXMigrationFailedException.fillInStackTrace(ERXMigrationFailedException.java:50001)
at java.lang.Throwable.<init>(Throwable.java:218)
at java.lang.Exception.<init>(Exception.java:59)
at java.lang.RuntimeException.<init>(RuntimeException.java:61)
at er.extensions.migration.ERXMigrationFailedException.<init>(ERXMigrationFailedException.java:14)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:159)
at er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
Caused by: java.lang.NullPointerException
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:646)
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:597)
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:579)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:152)
... 26 more
2010-09-23 09:49:08,201 WARN  QSTPTRMS[-:12345 0] NSLog (ERXNSLogLog4jBridge.java:43)  - A fatal exception occurred: Failed to create lock table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100)  NOT NULL, updatelock int4  NOT NULL, version int4  NOT NULL);

.
 [2010-9-23 9:49:8 AST] <main> er.extensions.migration.ERXMigrationFailedException: Failed to create lock table. Try executing:
CREATE TABLE _dbupdater (lockowner varchar(100) , modelname varchar(100)  NOT NULL, updatelock int4  NOT NULL, version int4  NOT NULL);

.
at er.extensions.migration.ERXMigrationFailedException.fillInStackTrace(ERXMigrationFailedException.java:50001)
at java.lang.Throwable.<init>(Throwable.java:218)
at java.lang.Exception.<init>(Exception.java:59)
at java.lang.RuntimeException.<init>(RuntimeException.java:61)
at er.extensions.migration.ERXMigrationFailedException.<init>(ERXMigrationFailedException.java:14)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:159)
at er.extensions.migration.ERXJDBCMigrationLock.tryLock(ERXJDBCMigrationLock.java:69)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.doPerform(ERXMigrator.java:451)
at er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1487)
at er.extensions.migration.ERXMigrator$ERXMigrationAction.perform(ERXMigrator.java:50001)
at er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:201)
at er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1184)
...
Caused by: java.lang.NullPointerException
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:646)
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:597)
at er.extensions.jdbc.ERXJDBCUtilities.executeUpdateScript(ERXJDBCUtilities.java:579)
at er.extensions.migration.ERXJDBCMigrationLock._tryLock(ERXJDBCMigrationLock.java:152)
... 26 more

Any ideas?

Thanks,

Farrukh

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: Migrations and Pooling - Exception
      • From: Farrukh Ijaz <email@hidden>
References: 
 >Migrations and Pooling - Exception (From: Farrukh Ijaz <email@hidden>)

  • Prev by Date: Migrations and Pooling - Exception
  • Next by Date: Re: Migrations and Pooling - Exception
  • Previous by thread: Migrations and Pooling - Exception
  • Next by thread: Re: Migrations and Pooling - Exception
  • Index(es):
    • Date
    • Thread