maintain-dbusers failing to create user for 'u4692'@'%' on instance-tools-db-4.tools.wmcloud.org
Closed, ResolvedPublicBUG REPORT
Actions

Assigned To

Authored By

	bd808
	Fri, Jan 3, 9:14 PM

Description

Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]: ERROR [root._create_accounts_on_host:1019] Unable to create user ranjithraj on 185.15.56.15:3306, got exception: (1396, "Operation CREATE USER failed for 'u4692'@'%'")             
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]: Traceback (most recent call last):                                                                  Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/local/sbin/maintain-dbusers", line 992, in _create_accounts_on_host                    Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     _create_user_on_cloud_db(
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/local/sbin/maintain-dbusers", line 901, in _create_user_on_cloud_db
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     _create_account(
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/local/sbin/maintain-dbusers", line 861, in _create_account
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     cloud_db_cur.execute(create_acct_sql_str)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 153, in execute
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     result = self._query(query)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:              ^^^^^^^^^^^^^^^^^^
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 322, in _query
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     conn.query(q)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 558, in query
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:
      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 822, in _read_query_result
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     result.read()
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1200, in read
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     first_packet = self.connection._read_packet()
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 772, in _read_packet
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     packet.raise_for_error()
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     err.raise_mysql_exception(self._data)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:   File "/usr/lib/python3/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]:     raise errorclass(errno, errval)
Jan 03 21:03:05 cloudcontrol1005 maintain-dbusers[3446189]: pymysql.err.OperationalError: (1396, "Operation CREATE USER failed for 'u4692'@'%'")

Event Timeline

bd808 created this task.Fri, Jan 3, 9:14 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFri, Jan 3, 9:14 PM

bd808 added a subscriber: fnegri.Fri, Jan 3, 9:14 PM

bd808 updated the task description. (Show Details)Fri, Jan 3, 9:20 PM

MariaDB [(none)]> show create user 'u4692'@'%';
+--------------------------------------------------------------------------------------------+
| CREATE USER for u4692@%                                                                    |
+--------------------------------------------------------------------------------------------+
| CREATE USER `u4692`@`%` IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
+--------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [(none)]> drop user 'u4692'@'%';
Query OK, 0 rows affected (0.101 sec)

After a few moments:

MariaDB [(none)]> show create user 'u4692'@'%';
+--------------------------------------------------------------------------------------------+
| CREATE USER for u4692@%                                                                    |
+--------------------------------------------------------------------------------------------+
| CREATE USER `u4692`@`%` IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
+--------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

taavi@tools-bastion-12:~ $ sudo mysql --defaults-file=/home/ranjithraj/replica.my.cnf --host=tools-db-4
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 115244427
Server version: 10.6.19-MariaDB-log MariaDB Server

maintain-dbusers failing to create user for 'u4692'@'%' on instance-tools-db-4.tools.wmcloud.orgClosed, ResolvedPublicBUG REPORTActions

Description

Event Timeline

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!

maintain-dbusers failing to create user for 'u4692'@'%' on instance-tools-db-4.tools.wmcloud.org
Closed, ResolvedPublicBUG REPORT
Actions