syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francesco Chicchiriccò (JIRA) <j...@apache.org>
Subject [jira] [Commented] (SYNCOPE-903) Scheduler not operational due to lowercase MySQL tables
Date Fri, 15 Jul 2016 15:19:20 GMT

    [ https://issues.apache.org/jira/browse/SYNCOPE-903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15379544#comment-15379544
] 

Francesco Chicchiriccò commented on SYNCOPE-903:
------------------------------------------------

Any follow-up for this issue?

I confirm that everything should be working fine, when properly configured; and agree that
proper configuration derives from documentation.
The real problem here is that wiki pages are currently working for Syncope 1.X while we are
building Syncope 2.X documentation via SYNCOPE-700.

You can see the preliminary version [online|https://syncope.apache.org/docs/reference-guide.html];
as [~fmartelli] says above, we are not going to release the final 2.0.0 without this being
completed.

> Scheduler not operational due to lowercase MySQL tables
> -------------------------------------------------------
>
>                 Key: SYNCOPE-903
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-903
>             Project: Syncope
>          Issue Type: Bug
>          Components: archetype, core
>    Affects Versions: 2.0.0-M4
>         Environment: MySQL Database
>            Reporter: Jeffrey Everling
>
> Hello,
> After deploying the latest version of Syncope, I noticed that I could not create any
pull tasks. When I took a look at the error and compared this to the database structure it
has generated, I noticed that Syncope is searching for an uppercase name where my database
tables are lower case. 
> Error:
> 17:40:22.279 ERROR org.apache.syncope.client.console.wizards.AjaxWizard - Wizard error
on finish
> org.apache.syncope.common.lib.SyncopeClientException: Scheduling [Failure obtaining db
row lock: Table 'syncope.QRTZ_LOCKS' doesn't exist {prepstmnt 1156556661 SELECT * FROM QRTZ_LOCKS
WHERE SCHED_NAME =
> 'scheduler' AND LOCK_NAME = ? FOR UPDATE} [code=1146, state=42S02]]
> SQL table view:
> +--------------------------------+
> | Tables_in_syncope              |
> +--------------------------------+
> | ACT_EVT_LOG                    |
> | ACT_GE_BYTEARRAY               |
> | ACT_GE_PROPERTY                |
> | ACT_HI_ACTINST                 |
> | ACT_HI_ATTACHMENT              |
> | ACT_HI_COMMENT                 |
> | ACT_HI_DETAIL                  |
> | ACT_HI_IDENTITYLINK            |
> | ACT_HI_PROCINST                |
> | ACT_HI_TASKINST                |
> | ACT_HI_VARINST                 |
> | ACT_ID_GROUP                   |
> | ACT_ID_INFO                    |
> | ACT_ID_MEMBERSHIP              |
> | ACT_ID_USER                    |
> | ACT_PROCDEF_INFO               |
> | ACT_RE_DEPLOYMENT              |
> | ACT_RE_MODEL                   |
> | ACT_RE_PROCDEF                 |
> | ACT_RU_EVENT_SUBSCR            |
> | ACT_RU_EXECUTION               |
> | ACT_RU_IDENTITYLINK            |
> | ACT_RU_JOB                     |
> | ACT_RU_TASK                    |
> | ACT_RU_VARIABLE                |
> | ADynGroupMembership            |
> | ADynGroupMembership_AnyObject  |
> | AMembership                    |
> | APlainAttr                     |
> | APlainAttrUniqueValue          |
> | APlainAttrValue                |
> | ARelationship                  |
> | AccountPolicy                  |
> | AccountPolicy_ExternalResource |
> | AccountRuleConfInstance        |
> | AnyAbout                       |
> | AnyObject                      |
> | AnyObject_AnyTypeClass         |
> | AnyObject_ExternalResource     |
> | AnyTemplatePullTask            |
> | AnyTemplateRealm               |
> | AnyType                        |
> | AnyTypeClass                   |
> | AnyType_AnyTypeClass           |
> | CPlainAttr                     |
> | CPlainAttrUniqueValue          |
> | CPlainAttrValue                |
> | ConnInstance                   |
> | ConnInstance_capabilities      |
> | DerSchema                      |
> | DynRoleMembership              |
> | DynRoleMembership_User         |
> | ExternalResource               |
> | ExternalResource_PropActions   |
> | ExternalResource_capOverride   |
> | GPlainAttr                     |
> | GPlainAttrUniqueValue          |
> | GPlainAttrValue                |
> | MailTemplate                   |
> | Mapping                        |
> | MappingItem                    |
> | MappingItem_Transformer        |
> | Notification                   |
> | NotificationTask_recipients    |
> | Notification_events            |
> | Notification_staticRecipients  |
> | OPENJPA_SEQUENCES_TABLE        |
> | PasswordPolicy                 |
> | PasswordRuleConfInstance       |
> | PlainSchema                    |
> | Provision                      |
> | PullPolicy                     |
> | PullTask_actionsClassNames     |
> | PushPolicy                     |
> | PushTaskAnyFilter              |
> | PushTask_actionsClassNames     |
> | Realm                          |
> | Realm_actionsClassNames        |
> | RelationshipType               |
> | Report                         |
> | ReportExec                     |
> | ReportTemplate                 |
> | ReportletConfInstance          |
> | SYNCOPEAUDIT                   |
> | SecurityQuestion               |
> | SyncopeConf                    |
> | SyncopeDomain                  |
> | SyncopeGroup                   |
> | SyncopeGroup_AnyTypeClass      |
> | SyncopeGroup_ExternalResource  |
> | SyncopeLogger                  |
> | SyncopeRole                    |
> | SyncopeRole_Realm              |
> | SyncopeRole_entitlements       |
> | SyncopeUser                    |
> | SyncopeUser_AnyTypeClass       |
> | SyncopeUser_ExternalResource   |
> | SyncopeUser_SyncopeRole        |
> | SyncopeUser_passwordHistory    |
> | Task                           |
> | TaskExec                       |
> | TypeExtension                  |
> | TypeExtension_AnyTypeClass     |
> | UDynGroupMembership            |
> | UDynGroupMembership_User       |
> | UMembership                    |
> | UPlainAttr                     |
> | UPlainAttrUniqueValue          |
> | UPlainAttrValue                |
> | URelationship                  |
> | VirSchema                      |
> | anyObject_search               |
> | anyObject_search_adyngmemb     |
> | anyObject_search_amembership   |
> | anyObject_search_arelationship |
> | anyObject_search_attr          |
> | anyObject_search_group_res     |
> | anyObject_search_null_attr     |
> | anyObject_search_resource      |
> | anyObject_search_unique_attr   |
> | group_search                   |
> | group_search_attr              |
> | group_search_null_attr         |
> | group_search_resource          |
> | group_search_unique_attr       |
> | qrtz_fired_triggers            |
> | qrtz_locks                     |
> | qrtz_paused_trigger_grps       |
> | qrtz_scheduler_state           |
> | user_search                    |
> | user_search_attr               |
> | user_search_dynrmemb           |
> | user_search_group_res          |
> | user_search_null_attr          |
> | user_search_resource           |
> | user_search_role               |
> | user_search_udyngmemb          |
> | user_search_umembership        |
> | user_search_unique_attr        |
> | user_search_urelationship      |
> +--------------------------------+
> I discussed this issue over IRC and as per advice I have tried upgrading the database
(Current MySQL version: 5.5). The JDBC connector was already the latest version.
> But still MySQL is operating in a case sensitive way as far as I can check by performing
the following queries:
> mysql> select * from QRTZ_LOCKS;
> ERROR 1146 (42S02): Table 'syncope.QRTZ_LOCKS' doesn't exist
> mysql> select * from qrtz_locks;
> Empty set (0.00 sec)
> Can you please advise about this matter? I would like to continue building the demo,
but I would like to hear first if I can simply rename the database tables, or that I should
proceed in another way.
> Kind regards,
> Jeffrey Everling



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message