Error renaming a column in MySQL

How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to manufacturerid I tried using PHPMyAdmin panel, but I get this error: MySQL...

Foreign Key add fails in MySQL with Error Code 1005, number 150

So I'm attempting to add a new foreign key to one of my tables as such: ALTER TABLE `UserTransactions`.`ExpenseBackTransactions` ADD CONSTRAINT `FK_EBTx_CustomAccountID` FOREIGN KEY...

Ubuntu 12.04, Tomcat7, NetBeans 7 - getting java.lang.NoClassDefFoundError: Lorg/slf4j/Logger;

I have a Java EE project, which is working fine in one of our remote servers with tomcat container. Whenever we want to make some changes to our application, we do it on our local machine, then...

"Data too long for column" - why?

I've written a MySQL script to create a database for hypothetical hospital records and populate it with data. One of the tables, Department, has a column named Description, which is declared as...

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#7': Instantiation of bean failed

I'm basically trying to implement openId in spring which will allow user to login through goggle and extract their emailId, name and save in data base After adding openid4java jar, now I'm getting...

MySQL error when creating foreign key with Laravel migration

I have a Laravel application set up and I'm using Sentry 2 for user authentication. I have a model called Post along with the default sentry User table. I would like to have a user to have many...

Django "static" folder not being loaded

I'm using Django, and for some reason, no matter what I do, the "static" folder containing things such as the CSS is not being loaded. I've searched through all the other questions and none of...

CacheManager No Bean Found - Not Trying to setup any Cache

I'm getting a no CacheManager bean found... But i have not tried to do anything with CacheManager! Here's my error! org.springframework.beans.factory.BeanCreationException: Error creating bean...

Getting an error in Spring Boot when i am trying to put data in database

I am getting this error when I am running my Spring Boot Application and I can't figure out where I am going wrong Exception in thread "main"...

How to retrieve data from database to display it in csv format on a webpage?

Actually I want to display data in csv format on a web page . Data is stored in message field in the database. The data is : data count 120 80 140 50 170 100 150 70 180 120 I want to...

SEVERE [localhost-startStop-1] org.apache.catalina.core.ContainerBase.addChildInternal

I've just opened the project in netbeans, cleaned and build it then run the project but its showing the following error message. Note:Same project is working fine in other systems. 03-Jan-2017...

Keycloak server is not getting started with cloud DB services

I have a locally hosted Keycloak server which I am able to get up and running with PostgreSQL locally. But when I configure same data source properties to use cloud hosted database service (I am...

Why does Spark fail with "java.lang.NoSuchMethodError: io.netty.channel.DefaultFileRegion.<init>(Ljava/io/File;JJ)V"?

I use Spark Streaming 2.10, Kafka_2.11-0.10.0.0, and Spark-streaming-0-10-2.11-2.10. spark-submit --version Welcome to ____ __ / __/__ ___ _____/ /__ _\ \/ _ \/ _ `/...

mysql has gone away and tuning mysql database

i have a mysql database that crashes about 1 time a day with error mysql server has gone away. timeout is 28800 sec and I set max_allowed_packet to 1024M but i have still the problem. I read in...

Aurora failover leaves connections open as read-only state

We are using MySQL in Aurora cluster We have 2 instances - master and slave. We are working with spring transactions on top of a c3po connection pool. We are using mariadb jdbc driver (version...

error while running Grails 3.3.8 application start failed

While I'm trying to run my Grails 3.3.8 I got the below error but I don't know from where it came I'm using Java 8 and MySQL 8.0.12 and Intellj: enter code here` ERROR --- [ main]...

Failed to find valid data directory. MySQL generic binary installion

Im going to install mysql to linux server. But I dont have root access to that server. So I created two folders called mysql and mysqldata. mysql folder holds binary files. mysqldata folder holds...

Error when creating JPA Repository: EntityPathResolver must not be null

Trying to create the base of a spring project (xml configuration, tomcat server), everything works fine except that mysterious exception that I can't seem to find anywhere else on the net. The...

How to create an Azure Devops Buildpipeline for a React APP

I have created one build pipeline with 2 npm tasks, the installer and then custom script with arguments run-script build, as seen in the screenshot However I get errors and this is in the...

NG Build fails in Azure Pipelines with NPM error 134

Approx 50% of my hosted builds are failing with npm error 134. I am building the same commit with the same build definition using hosted vs2017. I am building an Angular Application using the...

Exception on Spring Boot startup

I have a Spring Boot endpoint which takes inputs from user in Http request body of a POST request and persists it into a MySql database. Build is successful but when i try to run the application...

MySQL - Error: 150 "Foreign key constraint is incorrectly formed")

Got an odd problem I cant solve after browsing dozens of forum posts, and my local SQL Books. I've got two tables, and want to add a foreign key to one of them. The foreign key and primary key...

Spring Boot application crashes on Heroku code=H10

I have deployed a springboot application on heroku app. The application worked fine for quite a long time. But now suddenly i get an error Code="H10" and the app crashes. The build is successfull...

Keycloak MySQL setup failed with error "Timeout after [300] seconds waiting for service container stability. Operation will roll back."

I tried with 8.x and 10.x version of Keycloak, also with tried with Keycloak docker image but getting below issue, while configuring Keycloak with MySQL 12:27:16,047 DEBUG...

Docker MySQL container ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' from storage engine

I created a docker container with MySQL and whenever I'm trying to create a table here is the error I have : ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' from storage...

WSO2 IS - org.wso2.carbon.user.core.UserStoreException: null

I'm running a WSO2 container with all products together(apim-is-as-km-with-analytics) using mysql as database and I'm facing an error when the docker compose starts. My problem is on wso2-is...

Changing database during runtime. How can i refresh data source for JdbcTemplate bean?

i have following problem: I am currently writing a spring boot application that provides a rest endpoint and also constantly evaluates some data stored inside a remote MySql database that i have...

How to fix ModuleNotFoundError: No module named '_mysql'?

Environment: Ubuntu 18.04.5 LTS (GNU/Linux 4.15.0-45-generic x86_64) Server version: Apache/2.4.29 (Ubuntu) Python 3.7.5 Flask 1.1.2 Werkzeug 1.0.1 We deployed a flask application on our VPS...

MySQL create table: error 1005 errno: 150 “Foreign key constraint is incorrectly formed”

why laravel schema reply: SQLSTATE[HY000]: General error: 1005 Can't create table employee_management.employees (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table...

Unable to make a migration. Getting errors related to foreign keys

First migration file: <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateUsersTable extends...