Im having a java web application running in App engine standard environment with this configuration
<basic-scaling>
<max-instances>25</max-instances>
<idle-timeout>50m</idle-timeout>
</basic-scaling>
and connecting to the Cloud Sql second generation:
vCPUs Memory SSD Storage
2 7.5GB 31GB
and Im using Eclipse link provider with the following versions
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>javax.persistence</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>eclipselink</artifactId>
<version>2.7.1</version>
<exclusions>
<exclusion>
<groupId>org.eclipse.persistence</groupId>
<artifactId>javax.persistence</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
<exclusions>
<exclusion>
<groupId>com.google.protobuf</groupId>
<artifactId>protobuf-java</artifactId>
</exclusion>
</exclusions>
</dependency>
I put those exclusions cause it causes conflict with other library im using in the POM.xml
and every thing is just fine, later I upgraded the version of the eclipse link to be 2.7.3 after I've done that and deploy the changes into app engine it works fine but 30 min later it started to throw the below error, I set the version back then that Exception just gone for 2 months, and today when I changed the default_time_zone of the cloud sql sec generation from "+02:00" to "+01:00" then I restarted my DB it works fine for 10 min then started to throw the same exception
Exception details
its thrown for any JPA query Example: "Select u from User u where u.facebookId = :fbid"
[e~p8belel/api:20181121t183222.414147041342026241].<stdout>: [EL Warning]: 2018-11-21 17:10:39.183--UnitOfWork(1650244092)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.1.v20171221-bd47e8f): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Column Index out of range, 2 > 1.
Error Code: 0
Call: SELECT ID, about_me, account_note, account_status, birth_date, body_type, created_time, EMAIL, facebook_access_token_expry, facebook_access_token, facebook_id, game_balance, game_last_time_play, gender, hashed_password, HEIGHT, IP, job_details, last_activity_date, LIKABILITY, NAME, phone_number, signedup_device_id, signup_token, un_serious_count, class, subscription_plan, CITY_ID, marital_status_id, NEIGHBORHOOD_ID, RELIGION_ID, collage_id, job_id, my_match_id, setting_id, univ_id FROM user_table WHERE (facebook_id = ?)
bind => [1 parameter bound]
Query: ReadAllQuery(name="User.getUserByFbId" referenceClass=User sql="SELECT ID, about_me, account_note, account_status, birth_date, body_type, created_time, EMAIL, facebook_access_token_expry, facebook_access_token, facebook_id, game_balance, game_last_time_play, gender, hashed_password, HEIGHT, IP, job_details, last_activity_date, LIKABILITY, NAME, phone_number, signedup_device_id, signup_token, un_serious_count, class, subscription_plan, CITY_ID, marital_status_id, NEIGHBORHOOD_ID, RELIGION_ID, collage_id, job_id, my_match_id, setting_id, univ_id FROM user_table WHERE (facebook_id = ?)")
The User class is
public class User {
@Id
String id;
@Column(nullable = false)
String name;
@Column(unique = true)
String email;
@Column(name="phone_number",unique = true)
@Convert(converter = EncryptorConverter.class)
String phoneNumber;
@Column(name="hashed_password")
String hashedPassword;
@Column(name="signedup_device_id", unique=true)
String signedUpDeviceId;
@Column(name="signup_token")
String signupToken;
@OneToOne(mappedBy = "user")
private VerificationId verificationId;
@OneToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "setting_id")
AccountSetting setting = new AccountSetting();
@Temporal(TemporalType.DATE)
@Column(name = "birth_date")
Date birthDate;
@ManyToOne
@JoinColumn(name="marital_status_id")
MaritalStatus maritalStatus;
@Enumerated(EnumType.STRING)
@Column(name = "account_status")
AccountStatus accountStatus;
@OneToMany(mappedBy = "user")
List<Device> devices;
@Deprecated
@ManyToOne
City city;
@ManyToOne
Neighborhood neighborhood;
Integer height;
@Column(name="body_type")
@Enumerated(EnumType.STRING)
BodyType bodyType;
@Column(name="game_balance")
Integer gameBalance = 0;
@ManyToOne
Religion religion;
@JoinColumn(name = "my_match_id")
User myMatch;
Integer likability;
@Column(name="un_serious_count")
Integer unSeriousCount;
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "game_last_time_play")
Date gameLastPlay;
@Lob
@Column(name = "job_details")
@Convert(converter = EncryptorConverter.class)
String jobDetails;
@JoinColumn(name = "job_id")
Job job;
@JoinColumn(name = "univ_id")
University university;
@JoinColumn(name = "collage_id")
Collage collage;
@Lob
@Column(name = "about_me")
@Convert(converter = EncryptorConverter.class)
String aboutMe;
@Lob
@Column(name = "account_note")
@Convert(converter = EncryptorConverter.class)
String accountNote;
@Lob
@Convert(converter = EncryptorConverter.class)
@Column(name = "facebook_access_token", length = 700)
String facebookAccessToken;
@Column(name = "facebook_access_token_expry")
@Temporal(TemporalType.DATE)
Date faceBookTokenExpry;
@Column(name = "facebook_id", unique = true)
String facebookId;
@Column(name = "gender")
@Enumerated(EnumType.STRING)
Gender gender;
@Column(name = "class")
@Enumerated(EnumType.STRING)
UserClass userClass;
@OneToMany(mappedBy = "user")
@OrderBy("pictureOrder")
List<Picture> pictures = new ArrayList<Picture>();
@OneToMany(mappedBy = "user")
List<UserAnswer> answers;
@OneToMany(mappedBy = "user", orphanRemoval = true)
List<WorkHistory> work = new ArrayList<>();
@OneToMany(mappedBy = "user", orphanRemoval = true)
List<EducationHistory> education = new ArrayList<>();
@Column(name = "last_activity_date")
@Temporal(TemporalType.DATE)
Date lastActivityDate = new Date();
@Enumerated(EnumType.STRING)
@Column(name="subscription_plan")
SubscriptionPlan userPlan = SubscriptionPlan.FREEMIUM;
// getters and setters
}
Im really sorry for such a huge post, but Im really running out of ideas why this exception is happening
I fixed it, it seems like eclipse link starting from version 2.7.1 having that issue with MYSQL DB and its not stable, I just downgraded it to 2.7.0 and now its working just fine