You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "fabio martelli (JIRA)" <ji...@apache.org> on 2016/07/11 08:13:11 UTC
[jira] [Commented] (SYNCOPE-903) Scheduler not operational due to
lowercase MySQL tables
[ https://issues.apache.org/jira/browse/SYNCOPE-903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15370357#comment-15370357 ]
fabio martelli commented on SYNCOPE-903:
----------------------------------------
Hi, are you sure you are using the right configuration.
Please, check into provisioning.properties the provided value for quartz.sql parameter: it should be tables_mysql.sql
Please, let us know.
Regards
> 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)