← prev | next →
® star 2020-05-09 09:17:50
where is store log file of restore sql dump?
Gnation88 2020-05-09 10:45:36
® star 2020-05-09 09:17:50
where is store log file of restore sql dump?
Binlog?
AleHerz 2020-05-09 23:29:46
Master Yoda 2020-05-08 21:46:18
I can’t say without looking at several things. Maybe increase timeout limit for now?
I’m going crazy.
I noticed that with up to 2 connections as a pool_size everything works, with more 2 it doesn’t work
I tried mysql on docker, mariadb on docker, mysql on digital ocean, mariadb on digital ocean, nothing works.
This is my db scheme: https://hastebin.com/gavusetome.sql
Master Yoda 2020-05-09 23:34:07
AleHerz 2020-05-09 23:29:46
I’m going crazy.
I noticed that with up to 2 connections as a pool_size everything works, with more 2 it doesn’t work
I tried mysql on docker, mariadb on docker, mysql on digital ocean, mariadb on digital ocean, nothing works.
This is my db scheme: https://hastebin.com/gavusetome.sql
I don’t know q bit about connection pooling. I never did. Wish I could help
AleHerz 2020-05-09 23:37:23
Master Yoda 2020-05-09 23:34:07
I don’t know q bit about connection pooling. I never did. Wish I could help
Do you know of any other community where i can ask? Thank you!
Master Yoda 2020-05-09 23:38:01
AleHerz 2020-05-09 23:37:23
Do you know of any other community where i can ask? Thank you!
You tried stackoverflow?
AleHerz 2020-05-09 23:54:18
Master Yoda 2020-05-09 23:38:01
You tried stackoverflow?
Nope
Master Yoda 2020-05-09 23:58:28
AleHerz 2020-05-09 23:54:18
Nope
Try post the issue there with all y details.
MasterZiv 2020-05-10 07:50:10
AleHerz 2020-05-08 18:29:40
UPDATE lock rows and other queries go into timeout because they’re not unlocked, how can I fix it? I’m using only SELECT/UPDATE/INSERT/DELETE, not LOCK
Thanks!
Use
COMMIT
or
Rollback
statements
MasterZiv 2020-05-10 07:54:46
AleHerz 2020-05-08 18:59:20
the script do this
conn = get_conn_from_pool()
SELECT * FROM users WHERE id=%s LIMIT 1
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT t_u.* FROM users u INNER JOIN twitch_users t_u ON u.twitch_id = t_u.twitch_id WHERE u.id=%s LIMIT 1
UPDATE users SET in_group=%s WHERE id=%s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
conn.close()
….
conn = get_conn_from_pool()
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
TIMEOUT
ID is everytime the same in this case and with every query I open and close a cursor
Don’t send client-side scripts or programs !
If you want to get help, prepare the transcript of effective SQL statements being executed.
MasterZiv 2020-05-10 07:58:56
AleHerz 2020-05-08 18:59:20
the script do this
conn = get_conn_from_pool()
SELECT * FROM users WHERE id=%s LIMIT 1
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT t_u.* FROM users u INNER JOIN twitch_users t_u ON u.twitch_id = t_u.twitch_id WHERE u.id=%s LIMIT 1
UPDATE users SET in_group=%s WHERE id=%s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
conn.close()
….
conn = get_conn_from_pool()
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
TIMEOUT
ID is everytime the same in this case and with every query I open and close a cursor
This can’t generate timeouts.
I suspect you don’t do COMMIT somewhere while you think you do.
kamado_tanjiro21 2020-05-10 20:21:52
kamado_tanjiro21 2020-05-10 20:22:42
tried runing workbench and it was showing this error
Master Yoda 2020-05-10 20:34:18
kamado_tanjiro21 2020-05-10 20:22:42
tried runing workbench and it was showing this error
Is mysql server running? Check all those steps mentioned in the above error message
kamado_tanjiro21 2020-05-11 10:19:40
Master Yoda 2020-05-10 20:34:18
Is mysql server running? Check all those steps mentioned in the above error message
if im opening it on terminal by sudo mysql its workin fine also i cant use mysql.connector with python
piterden 2020-05-11 10:29:03
kamado_tanjiro21 2020-05-11 10:19:40
if im opening it on terminal by sudo mysql its workin fine also i cant use mysql.connector with python
Check your connection points
kamado_tanjiro21 2020-05-11 10:37:01
piterden 2020-05-11 10:29:03
Check your connection points
its on the default settings and i dont know about that
Master Yoda 2020-05-11 10:37:13
kamado_tanjiro21 2020-05-11 10:19:40
if im opening it on terminal by sudo mysql its workin fine also i cant use mysql.connector with python
The above message you sent shows something related to apparmor. Can you disable it for a moment and then try connect?
kamado_tanjiro21 2020-05-11 10:38:09
piterden 2020-05-11 10:29:03
Check your connection points
kamado_tanjiro21 2020-05-11 10:38:36
Master Yoda 2020-05-11 10:37:13
The above message you sent shows something related to apparmor. Can you disable it for a moment and then try connect?
let me find what that is
kamado_tanjiro21 2020-05-11 10:42:40
kamado_tanjiro21 2020-05-11 10:38:36
let me find what that is
kartik@kartik-PC:~$ sudo service apparmor reload
apparmor.service is not active, cannot reload.
kamado_tanjiro21 2020-05-11 10:43:39
it doesnt seem to be active
Master Yoda 2020-05-11 10:44:08
Check error log
kamado_tanjiro21 2020-05-11 10:44:21
Master Yoda 2020-05-11 10:44:08
Check error log
how?
Master Yoda 2020-05-11 10:44:45
kamado_tanjiro21 2020-05-11 10:44:21
how?
You have access to the terminal?
kamado_tanjiro21 2020-05-11 10:44:54
yes
Master Yoda 2020-05-11 10:45:12
Fire this
Master Yoda 2020-05-11 10:45:21
Select @@log_error
Master Yoda 2020-05-11 10:45:33
It will display path to error log file
kamado_tanjiro21 2020-05-11 10:46:34
select command not found wait which terminal were u talking about?
kamado_tanjiro21 2020-05-11 10:46:56
oh ok
kamado_tanjiro21 2020-05-11 10:46:58
my bad
Master Yoda 2020-05-11 10:48:20
What is the user you are using with workbench?
Master Yoda 2020-05-11 10:48:22
Root?
kamado_tanjiro21 2020-05-11 10:48:29
yes
Master Yoda 2020-05-11 10:48:51
Root cannot connect to remote unless granted privileges for remote
kamado_tanjiro21 2020-05-11 10:49:24
ohhh how do i fix that?
Master Yoda 2020-05-11 10:49:54
kamado_tanjiro21 2020-05-11 10:49:24
ohhh how do i fix that?
Select host , user from mysql.user;
Master Yoda 2020-05-11 10:49:57
Fire this
kamado_tanjiro21 2020-05-11 10:50:26
Master Yoda 2020-05-11 10:49:54
Select host , user from mysql.user;
mysql> Select host , user from mysql.user;
+———–+——————+
| host | user |
+———–+——————+
| localhost | debian-sys-maint |
| localhost | kartik |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+———–+——————+
5 rows in set (0.00 sec)
Master Yoda 2020-05-11 10:50:30
Check which user is been granted remote connection . The kne with % is allowed to connect from any host which also means remotely
Master Yoda 2020-05-11 10:50:41
You have to create the user
Master Yoda 2020-05-11 10:50:49
And grant privileges
kamado_tanjiro21 2020-05-11 10:50:58
i think i disabled that while i was installing it
kamado_tanjiro21 2020-05-11 10:51:33
should i reinstall mysql?
Master Yoda 2020-05-11 10:51:57
Create user ‘kartik’@’workbench_machine_ip’ identified by ‘pass’;
Master Yoda 2020-05-11 10:52:05
And then grant necessary privileges
Master Yoda 2020-05-11 10:52:17
kamado_tanjiro21 2020-05-11 10:51:33
should i reinstall mysql?
No
kamado_tanjiro21 2020-05-11 10:52:48
Master Yoda 2020-05-11 10:52:05
And then grant necessary privileges
how do i do that?😅
Master Yoda 2020-05-11 10:53:16
Master Yoda 2020-05-11 10:51:57
Create user ‘kartik’@’workbench_machine_ip’ identified by ‘pass’;
Fire this. Replace ip with your workbench machine ip and pass with your password
← prev | next →
