Re: email@hidden
Re: email@hidden
- Subject: Re: email@hidden
- From: Mike Schrag <email@hidden>
- Date: Fri, 4 Apr 2008 15:19:25 -0400
Please keep this on the list ... You're not including the actual stack
trace, only the error message. Are you not running this from inside
Eclipse?
ms
On Apr 4, 2008, at 3:08 PM, Theodore Petrosky wrote:
Here is part of the log... the only change is making
the default be false... tell me if you need more. I
can zip the entire log and send it to you.
Ted
Apr 04 15:03:46 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing CREATE
TABLE _dbupdater (lockowner varchar(100), modelname
varchar(100) NOT NULL, updatelock int4 NOT NULL,
version int4 NOT NULL)
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"UPDATE _dbupdater SET lockowner = ?::varchar(100),
updatelock = ?::int4 WHERE (modelname =
?::varchar(100) AND (updatelock = ?::int4 OR lockowner
= ?::varchar(100)))" withBindings:
1:"SooperSeekrit--1"(lockOwner), 2:1(updateLock),
3:"SooperSeekrit"(modelName), 4:0(updateLock),
5:"SooperSeekrit--1"(lockOwner)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"SELECT t0.updatelock FROM _dbupdater t0 WHERE
t0.modelname = ?::varchar(100)" withBindings:
1:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - 0 row(s)
processed
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"INSERT INTO _dbupdater(lockowner, version,
updatelock, modelname) VALUES (?::varchar(100),
?::int4, ?::int4, ?::varchar(100))" withBindings:
1:"SooperSeekrit--1"(lockOwner), 2:-1(version),
3:1(updateLock), 4:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCMigrationLock.java:105) INFO
er.extensions.migration.ERXJDBCMigrationLock -
Waiting on updateLock for model 'SooperSeekrit' ...
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"SELECT t0.version FROM _dbupdater t0 WHERE
t0.modelname = ?::varchar(100)" withBindings:
1:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - fetch
canceled
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - 1 row(s)
processed
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXMigrator.java:392) INFO
er.extensions.migration.ERXMigrator - Upgrading
SooperSeekrit to version 0 with migration
'com.sooperseekrit.migration.SooperSeekrit0@752bea'
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing CREATE
TABLE t_user (c_first_name varchar(255) NOT NULL,
c_last_name varchar(255), c_password varchar(255) NOT
NULL, c_username varchar(255) NOT NULL, id int4 NOT
NULL)
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing ALTER
TABLE t_user ADD CONSTRAINT t_user_pk PRIMARY KEY (id)
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"UPDATE _dbupdater SET version = ?::int4 WHERE
modelname = ?::varchar(100)" withBindings:
1:0(version), 2:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXMigrator.java:400) INFO
er.extensions.migration.ERXMigrator - SooperSeekrit
is now version 0
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"UPDATE _dbupdater SET lockowner = NULL, updatelock =
?::int4 WHERE modelname = ?::varchar(100)"
withBindings: 1:0(updateLock),
2:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - Using
JDBCPlugIn
'com.webobjects.jdbcadaptor.PostgresqlPlugIn' for
JDBCAdaptor@11948158
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"UPDATE _dbupdater SET lockowner = ?::varchar(100),
updatelock = ?::int4 WHERE (modelname =
?::varchar(100) AND (updatelock = ?::int4 OR lockowner
= ?::varchar(100)))" withBindings:
1:"SooperSeekrit--1"(lockOwner), 2:1(updateLock),
3:"SooperSeekrit"(modelName), 4:0(updateLock),
5:"SooperSeekrit--1"(lockOwner)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"SELECT t0.version FROM _dbupdater t0 WHERE
t0.modelname = ?::varchar(100)" withBindings:
1:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - fetch
canceled
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - 1 row(s)
processed
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXMigrator.java:392) INFO
er.extensions.migration.ERXMigrator - Upgrading
SooperSeekrit to version 1 with migration
'com.sooperseekrit.migration.SooperSeekrit1@f7ba12'
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing CREATE
TABLE t_userpersonalmeta (c_address1 varchar(255),
c_address2 varchar(255), c_birthday timestamp, c_city
varchar(255), c_emergencycontact varchar(255),
c_emergencycontactrelationship varchar(255), c_state
varchar(255), c_zip varchar(255), id int4 NOT NULL)
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing ALTER
TABLE t_userpersonalmeta ADD CONSTRAINT
t_userpersonalmeta_pk PRIMARY KEY (id)
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXJDBCUtilities.java:523) INFO
er.extensions.ERXJDBCUtilities - Executing alter
table t_user add c_group_id int4 NOT NULL
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog -
evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression:
"UPDATE _dbupdater SET lockowner = NULL, updatelock =
?::int4 WHERE modelname = ?::varchar(100)"
withBindings: 1:0(updateLock),
2:"SooperSeekrit"(modelName)>
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Commit Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Begin Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:44) DEBUG NSLog - ===
Rollback Internal Transaction
Apr 04 15:03:47 SooperSeekrit[49713]
(ERXNSLogLog4jBridge.java:41) WARN NSLog - A fatal
exception occurred: Migration failed.
[2008-4-4 15:3:47 EDT] <main>
er.extensions.migration.ERXMigrationFailedException:
Migration failed.
------------------------------
Message: 7
Date: Fri, 4 Apr 2008 09:10:57 -0400
From: Mike Schrag <email@hidden>
Subject: Re: migration and null problem
To: WebObjects-Dev List
<email@hidden>
Message-ID:
<email@hidden>
Content-Type: text/plain; charset=US-ASCII;
format=flowed
Notice the creation of the new column in t_user. I
had
to change the allow null to true... If it is false,
then the whole process fails.
"fails". Fails how? Exact exception, please. What
WO version?
ms
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of
Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
_______________________________________________
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