• 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: Migration Issue with 0 level migration and ERAttachement
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migration Issue with 0 level migration and ERAttachement

  • Subject: Re: Migration Issue with 0 level migration and ERAttachement
  • From: James Cicenia <email@hidden>
  • Date: Fri, 04 Nov 2011 14:51:19 -0500
Hmmm

More from the log:



Upgrading ERAttachment to version 0 with migration 'er.attachment.migrations.ERAttachment0@5c66b06b'
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing CREATE TABLE ERAttachment(attachmentDataID INTEGER, configurationName VARCHAR(100), filesystemPath VARCHAR(255), height INTEGER, id INTEGER NOT NULL, mimeType VARCHAR(100) NOT NULL, originalFileName VARCHAR(255) NOT NULL, ownerID VARCHAR(16), parentID INTEGER, proxied VARCHAR(5) NOT NULL, s3Path VARCHAR(1000), size INTEGER NOT NULL, smallData LONG VARBINARY, storageType VARCHAR(10), thumbnail VARCHAR(10), webPath VARCHAR(1000) NOT NULL, width INTEGER)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing ALTER TABLE ERAttachment ADD PRIMARY KEY (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing ALTER TABLE `ERAttachment` ADD UNIQUE `ERAttachmentWebPath` (`webPath`(255))
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing CREATE TABLE ERAttachmentData(data LONG VARBINARY, id INTEGER NOT NULL)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing ALTER TABLE ERAttachmentData ADD PRIMARY KEY (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO  er.extensions.jdbc.ERXJDBCUtilities  - Executing ALTER TABLE ERAttachment ADD CONSTRAINT ERAttachment_attachmentDataID_id_FK FOREIGN KEY (attachmentDataID) REFERENCES ERAttachmentData (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET version = ? WHERE modelname = ?" withBindings: 1:0(version), 2:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] INFO  er.extensions.migration.ERXMigrator  - ERAttachment is now version 0

==== >>  PERFECT !! SO FAR


Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET lockowner = NULL, updatelock = ? WHERE modelname = ?" withBindings: 1:0(updateLock), 2:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.MySQLPlugIn' for JDBCAdaptor@909751202
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET lockowner = ?, updatelock = ? WHERE (modelname = ? AND (updatelock = ? OR lockowner = ?))" withBindings: 1:"MidwestFoodsWeb-James-iMac-2.local:-1"(lockOwner), 2:1(updateLock), 3:"ERAttachment"(modelName), 4:0(updateLock), 5:"MidwestFoodsWeb-James-iMac-2.local:-1"(lockOwner)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT t0.version FROM _dbupdater t0 WHERE t0.modelname = ?" withBindings: 1:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  - fetch canceled
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog  - 1 row(s) processed


==== >>>>>>   NOW WHY THIS?!!

Nov 04 14:10:04 MidwestFoodsWeb[65241] INFO  er.extensions.migration.ERXMigrator  - Upgrading ERAttachment to version 1 with migration 'er.attachment.migrations.ERAttachment1@35f784d7'

Everything is set to 0 in my properties file?

James





smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
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
References: 
 >Migration Issue with 0 level migration (From: James Cicenia <email@hidden>)
 >Re: Migration Issue with 0 level migration (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Migration Issue with 0 level migration
  • Next by Date: Re: Migration Issue with 0 level migration
  • Previous by thread: Re: Migration Issue with 0 level migration
  • Next by thread: Q about ERModernLook and embedded lists
  • Index(es):
    • Date
    • Thread