updatedb is giving us error table file_type doesn't exist on updatedb from 7.x-2.0-unstable6 to latest dev:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'os_dev.file_type' doesn't exist [error]
An error occurred at function : drush_core_updatedb_batch_process [error]
WD menu: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table [error]
'os_dev.file_type' doesn't exist: SELECT t__0.*
FROM
{file_type} t__0; Array
(
)
in ctools_export_load_object() (line 427 of
.../modules/contrib/ctools/includes/export.inc).
Any clues gratefully investigated.
Thanks,
Russell
Comment | File | Size | Author |
---|---|---|---|
#17 | Graph API | Site-Install.png | 51.26 KB | clemens.tolboom |
#2 | debug.trace_.gz | 27.96 KB | russellb |
Comments
Comment #1
ParisLiakos CreditAttribution: ParisLiakos commenteda debug_backtrace() in ctools_export_load_object() would help a lot here:)
Comment #2
russellb CreditAttribution: russellb commentedthanks rootatwc - backtrace attached
Comment #3
russellb CreditAttribution: russellb commentedWe have had some progress on this issue today by updating file_entity first and separately from media. We suspect this problem occurs if you update file_entity and media on the same update db
Comment #4
ParisLiakos CreditAttribution: ParisLiakos commentedI think you are right. Media's 7209 has not register the file_entity 7201 as depepndency
i made a commit
http://drupalcode.org/project/media.git/commit/93bf919
Lets hope this fixes it
Comment #5
russellb CreditAttribution: russellb commentedWe still have the same problem there I'm afraid with latest dev.
So when we upgrade from unstable6 of media and file_entity to latest dev. of both we still get the errors above.
Our work-around still works with latest dev - put the new files on for file_entity and run updatedb, then new files on for media and updatedb
We are moving forward now with our 2 stage work-around here.
Comment #6
bensnyder CreditAttribution: bensnyder commentedYep - see #1844174: Update #7208 Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation
I found this issue after I posted that one.
Comment #7
ParisLiakos CreditAttribution: ParisLiakos commentedCorrecting status
Comment #8
js CreditAttribution: js commentedI am confused. I have 7.x-2.0-unstable7 versions of both file_entity and media with the error
Update #7208 Failed
What is the work around?
Should I be using dev versions or working around with these versions?
Is this problem important on a live site?
Thanks, Jerry
Comment #9
russellb CreditAttribution: russellb commentedOur work-around was as follows:
- get the new files for file_entity
- put them in place in your modules directory
- run drupal update db
- get the new files for media
- put them in place in your modules directory
- run drupal update db
When we encountered this problem unstable7 wasn't quite out yet, so I don't know for sure if this works with unstable7, but I expect it does.
As to whether it is important on a live site, I would be nervous myself about database updates failing on a live site. We ran test deployments on our development servers before taking this to our live site.
Comment #10
ezeedub CreditAttribution: ezeedub commentedI'm getting the same error trying to update both file_entity and media from unstable6 to unstable7.
I had the same idea to update first file_entity then media, but that's not working for me.
Comment #11
technivant CreditAttribution: technivant commentedI was able to get this working by:
- updating file_entity
- running the below sql on the affected db
- updating media (and media_youtube) modules
Comment #12
slashrsm CreditAttribution: slashrsm commentednew release blocker
Comment #13
ParisLiakos CreditAttribution: ParisLiakos commentedso after running file entity updates tables are not there?
if so this is not a race condition/cache problem as i suspected..
this is freaking weird to be honest, something is wrong with
file_entity_update_7201
are there any other errors in logs?
Comment #14
ParisLiakos CreditAttribution: ParisLiakos commentedfor all other use cases above this commit should fix the problen
http://drupalcode.org/project/media.git/commit/9ef1709
Comment #15
clemens.tolboomMaybe use hook_update_dependencies
for proper ordering of hook_update_N() and add dependencies in media.info and or file_entity.info like
Comment #16
slashrsm CreditAttribution: slashrsm commented@technivant: could you check schema versions of media and file_entity in system table BEFORE the upgrade?
Run:
Comment #17
clemens.tolboomI did the following
and finish manually without trouble.
Next
and finish manually without trouble.
So running update.php from within the browser is no problem. (Hope that helps a tiny bit)
[edit: image is dependencies graph latest dev]
Comment #18
clemens.tolboomAs we have changed media_update_dependencies a few times
- [#1832297]
- #1846518: Document file types are undefined after module update
it is possible schema versions are installed not in sync between media and file_entity.
Could it be update_resolve_dependencies skip dependency check and install out of order? At least that's how I read the code
(my 2 cents)
Comment #19
Dave ReidComment #20
clemens.tolboomIn #17 I had no trouble to upgrade.
So my guess now is this is not a release blocker.
@Dave Reid why is this a release blocker now?
Comment #21
Dave Reid#18 sounded like there was more to investigate and this wasn't fully resolved. If that's incorrect, then feel free to remove the blocker tag.
Comment #22
clemens.tolboom@Dave Reid you are right the phrasing could have been better.
I hope the others would agree with cannot reproduce.
Rereading #14 it is probably fixed due to the commit mentioned in #14.
So I remove the release blocker and set to cannot reproduce as try to show with #17.
Feel free to reopen.
Comment #23
RaulMuroc CreditAttribution: RaulMuroc commentedThe latest stable version of the module seems to (somehow) fix it.