Stack Overflow
Stack Overflow

Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
0
votes
2 answers

Spring Boot Rest + ClearDB mySQL "exceeded 'max_user_connections'" error

I keep randomly getting this error every once in a while: "java.sql.SQLSyntaxErrorException: User '{key}' has exceeded the 'max_user_connections' resource (current value: 10)". I have tried googling help for this, but all I can find is: "increase…
Crossoni
  • 193
  • 1
  • 10
0
votes
1 answer

Insert request into MYSQL DB on Heroku with Node.js

I am having trouble with inserting data into my database on Heroku (MySQL, ClearDB). Whenever I am trying to execute INSERT query it just does not work, nothing is inserted, no error messages at all. SELECT query works fine and I confirmed that but…
Łukasz
  • 13
  • 5
0
votes
1 answer

issues with deployed springboot application on heroku

I deployed a springboot RestApi on Heroku. When I run this project on my computer via http://localhost:8080/api/userLog I get the desired response which is seen below: [ { "userId" : "ABC123XYZ", "sessionId" : "XYZ456ABC", "action" : [ { …
kingified
  • 195
  • 1
  • 2
  • 18
0
votes
1 answer

Unable to connect to any of the specified MySQL Hosts? C# + Heroku + ClearDB

I have a web API hosted on Heroku. It serves data from a ClearDB via a Golang program. I have a C# .NET script that will need to insert data into that ClearDB. I had this idea working on my local machine, but as I moved everything over to heroku,…
ty1
  • 334
  • 4
  • 19
0
votes
1 answer

Node.js app crashes exactly 1 minute after a successful cleardb query

I launched my app on Heroku and added cleardb:ignite as MySQL. The app was running well until it did a MySQL query. The app did receive a successful result from MySQL, but then, in exact 1 minute, the app crashed. The logs is shown as…
Zhengqian Kuang
  • 1,079
  • 1
  • 9
  • 12
0
votes
1 answer

cleardb (mySQL) connection problem witth Heroku (spring)

I am creating a springboot application which has data stored in a mysql database. I have used cleardb as an add-on and have deployed the app to Heroku. When I run the app (i.e heroku open), the main page (index.html) displays successfully as it does…
Carnageta
  • 321
  • 1
  • 3
  • 15
0
votes
1 answer

How to prevent ClearDB (MySQL) from dropping when heroku puts my app to sleep

I have deployed a Spring Boot app on heroku and installed ClearDB addon which is just MySQL database. I am using free plan so I don't mind that my app is going to sleep after an hour of inactivity but I have one issue - database drops after app is…
hdw3
  • 871
  • 10
  • 28
0
votes
0 answers

PHP site no longer working on Heroku: error 500

I'm trying to push an app that I wrote in vanilla PHP 7.2.1 to Heroku. I've developed in a local docker container with apache and mariaDB and things work fine. When I go to Heroku, the index page loads, but if I try to log in or go to any other…
Octa
  • 11
  • 1
0
votes
0 answers

How to connect to MySQL with a Flask app on Heroku using SQLAlchemy

On local machine, using a local MySQL database everything goes fine. Here is my app __init__.py file: #rootfolder/__init__.py from flask import Flask from flask_sqlalchemy import SQLAlchemy import os ON_HEROKU = 'ON_HEROKU' in os.environ if…
MattSom
  • 2,097
  • 5
  • 31
  • 53
0
votes
1 answer

Backup clearDB database to local

I am trying to backup and restore the cleardb database. I was trying to backup to my local computer first and then restore it. However, I am not able to create a backup mysqldump -h us-csdr-fern-sds-03.cleardb.net -u sdloremipsum5 -p ipsum…
jedu
  • 1,211
  • 2
  • 25
  • 57
0
votes
1 answer

Mysql Syntax error for spree migrations on heroku

So, I am using spree 3.7 and tried to deploy my rails 5.2.3 application on heroku with clearDB addon for MySQL support. But everytime i ran migrations, syntax error pops up. Mysql2::Error: You have an error in your SQL syntax; check the manual…
Rajan Verma
  • 87
  • 9
0
votes
1 answer

Error connecting to ClearDB when using Proximo

I'm running a Node.js app on Heroku through Proximo in order to get a static IP for outbound traffic. (See https://devcenter.heroku.com/articles/proximo#using-the-proximo-http-proxy, using the Procfile method). Since doing this the MySQL connection…
Jim Wiberley
  • 41
  • 1
  • 3
0
votes
0 answers

Different record fetch from the same dbs

i have two node.js application one is hosted on Heroku and the other is hosted locally, both are connected to the same database hosted on heroku clearDB extension. however , im getting different records when i fetch some data . but not competently,…
othman A
  • 3
  • 2
0
votes
1 answer

ClearDB connecting with 'npm run start' but not with Heroku deploy; ERR_CONNECTION_REFUSED

I deployed a node app on Heroku and set up ClearDB with MySQL Workbench. When I use npm run start it works great, data shows up. When I open in Heroku; heroku local web and heroku open the app is deployed but no data is displayed. The error message…
cDub
  • 488
  • 1
  • 6
  • 19
0
votes
1 answer

React Express Heroku 503 error for POST routes

My app was working fine locally. When I deploy to Heroku I get 503 errors for the post routes. The GET routes seem to work fine as one of them is the route that is required to login using Google OAuth. The logout route is also a GET route and it…
QHafeez
  • 197
  • 1
  • 4
  • 14
1 2 3
…
16 17